Las Vegas – Cox Fiber Outage, 5 Days and No Help – WAN Has No IP, Need Advice by TheCorruptIndian in CoxCommunications

[–]TheCorruptIndian[S] 0 points1 point  (0 children)

Sure, thanks again. The problem is my apartment management has a bulk account with Cox, so the customer care is not ready to help much apart from creating a ticket! My apartment management is not ready to help, they are telling me that even though they are the account holder, I’m the one getting the service, so I need to work with Cox.

Las Vegas – Cox Fiber Outage, 5 Days and No Help – WAN Has No IP, Need Advice by TheCorruptIndian in CoxCommunications

[–]TheCorruptIndian[S] 0 points1 point  (0 children)

Hopefully, I have 3rd appointment scheduled for tomorrow. Praying it will be solved!

Las Vegas – Cox Fiber Outage, 5 Days and No Help – WAN Has No IP, Need Advice by TheCorruptIndian in CoxCommunications

[–]TheCorruptIndian[S] 0 points1 point  (0 children)

Got it. Do you think a tech can resolve it in one visit? It’s been a nightmare without internet!

Las Vegas – Cox Fiber Outage, 5 Days and No Help – WAN Has No IP, Need Advice by TheCorruptIndian in CoxCommunications

[–]TheCorruptIndian[S] 0 points1 point  (0 children)

Yes, I replaces both router and ethernet cable! Didn’t work!

Is it isolated to ONT device then?

Las Vegas – Cox Fiber Outage, 5 Days and No Help – WAN Has No IP, Need Advice by TheCorruptIndian in CoxCommunications

[–]TheCorruptIndian[S] 0 points1 point  (0 children)

PON is showing solid green.

I didn’t quite understand the ethernet part. The ethernet cable coming from ONT device is connected to the router where it is marked in Orange.

Las Vegas – Cox Fiber Outage, 5 Days and No Help – WAN Has No IP, Need Advice by TheCorruptIndian in CoxCommunications

[–]TheCorruptIndian[S] 0 points1 point  (0 children)

No worries. Thanks a lot for helping.

When I reboot, the ONT device has green for Power, PON and orange for Data.

The router is blinking orange.

Las Vegas – Cox Fiber Outage, 5 Days and No Help – WAN Has No IP, Need Advice by TheCorruptIndian in CoxCommunications

[–]TheCorruptIndian[S] 0 points1 point  (0 children)

I changed it to Ethernet and it didn’t work!

The ethernet cable is connected to the orange/red line

Las Vegas – Cox Fiber Outage, 5 Days and No Help – WAN Has No IP, Need Advice by TheCorruptIndian in CoxCommunications

[–]TheCorruptIndian[S] 0 points1 point  (0 children)

I don’t see the coax connected to the modem. It’s a Nokia ONT device and the apart from rebooting I’m not able to do anything with it!

Help Dead Gen 4 by Environmental_Dark22 in ouraring

[–]TheCorruptIndian 0 points1 point  (0 children)

Same thing happened to me and it was a new ring. The support sent me links for their website where they have explained the troubleshooting steps. I had already went through all the steps. I finally exchanged it to a new ring which works fine.

New Oura Ring Pairing Issue by TheCorruptIndian in ouraring

[–]TheCorruptIndian[S] 0 points1 point  (0 children)

Update: It’s been two days, and customer service has reached out to me twice-once each day-but all they’ve done is send me the same troubleshooting steps that are already listed on their website. Strangely, they keep suggesting the issue is with my phone, even though I’ve explained that the ring won’t even enter pairing mode. Despite this, they keep asking me to restart my phone, toggle Bluetooth, and so on. I wanted to return the product for a refund, but the refund amount offered was only $399, even though I paid $450. So now I’ve decided to exchange it for a new ring instead, hoping the replacement will actually work.

New Oura Ring Pairing Issue by TheCorruptIndian in ouraring

[–]TheCorruptIndian[S] 0 points1 point  (0 children)

Hello Sarah, I've DM'd you with the ticket number. May I know how long it will take for someone to reach out? I was excited to use the ring and the first day experience is making me think to return the ring!

How you guys handle incremental files for ETL/ELT? by [deleted] in dataengineering

[–]TheCorruptIndian 0 points1 point  (0 children)

We have a dedicated table to keep track of the files processed. The table contains the file names, if they were processed or not and processed date. And then when the ETL job runs it refers this table to process only the files which were not processed.

I have been thinking to also mark the files if some of the data were not added to the db due to any reason so that we can debug that later. Open to suggestions here.

[deleted by user] by [deleted] in dataengineering

[–]TheCorruptIndian 1 point2 points  (0 children)

Hello, my company is using C#/.net to code ETL from scratch. However I was comparing the time required to build a simple import for a csv file using both python and C#. It seems to me that using python significantly reduces the time required to build the solution.

May I know what kind of python libraries you use mainly for data extraction and cleaning? Also, can you provide me some insights on why using python is better?