Pohemi
Lifer
- Oct 2, 2004
- 10,877
- 16,960
- 146
Red Squirrel
No Lifer
In the past week or so my black cat randomly decided to take interest in a toy that was previously never really touched. It's this round plastic thing with a ball inside. Makes lot of racket when he plays with it, it's hilarious, he's going completely nuts right now.
bigboxes
Lifer
- Apr 6, 2002
- 42,233
- 12,415
- 146
sdifox
No Lifer
- Sep 30, 2005
- 100,238
- 17,895
- 126
Red Squirrel
No Lifer
Fuck Excel's stupid default paste options. WHY?! Would anyone want completely random data to be treated as a date. Have to manually right click and chose a different paste option for each paste so it doesn't do that.
I don't know what's worse, Microsoft, or CGI. The web page to get door codes only shows 8 items at a time, and there's no search. That's what prompted me to copy and paste into excel as it does recognize that it's a table so it gets all the columns right and will make a single searchable document at least. If there was thousands of entries I'd try to reverse engineer the web site so I can scrape the data but looking at it real quick it doesn't look easy as they're using javascript to format the table and the data comes in as some kind of encoded blob, and it's not base64. Think it's serialized data, didn't dive deeper than that. So opted to just copy and paste each page manually.
Going to revise the data tomorrow to make sure things look right then send it off. The first version I sent had a bunch of random codes that were showing up as dates, and if I tried to change the cell formatting it would just convert to a completely different value than what it should be.
I don't know what's worse, Microsoft, or CGI. The web page to get door codes only shows 8 items at a time, and there's no search. That's what prompted me to copy and paste into excel as it does recognize that it's a table so it gets all the columns right and will make a single searchable document at least. If there was thousands of entries I'd try to reverse engineer the web site so I can scrape the data but looking at it real quick it doesn't look easy as they're using javascript to format the table and the data comes in as some kind of encoded blob, and it's not base64. Think it's serialized data, didn't dive deeper than that. So opted to just copy and paste each page manually.
Going to revise the data tomorrow to make sure things look right then send it off. The first version I sent had a bunch of random codes that were showing up as dates, and if I tried to change the cell formatting it would just convert to a completely different value than what it should be.
TRENDING THREADS
-
Discussion Zen 5 Speculation (EPYC Turin and Strix Point/Granite Ridge - Ryzen 9000)- Started by DisEnchantment
- Replies: 25K
-
Discussion Intel Meteor, Arrow, Lunar & Panther Lakes + WCL Discussion Threads
- Started by Tigerick
- Replies: 22K
-
News NVIDIA and Intel to Develop AI Infrastructure and Personal Computing Products- Started by poke01
- Replies: 393
-
Discussion Intel current and future Lakes & Rapids thread- Started by TheF34RChannel
- Replies: 23K
Facebook
Twitter