Loading…
14
Changed my mind about asking for help after a simple question took me two days
I needed to find a good way to archive old forum threads without losing the data. I figured I could just export to a CSV file and be done in an hour. The export worked, but the dates and user tags were a complete mess in the spreadsheet. I spent the next 48 hours trying different scripts I found online, none of which worked with my specific setup. I finally asked in the community's help channel and someone gave me a one-line command that fixed it in five seconds. Has anyone else wasted a bunch of time on what seemed like a basic data question?
2 comments
Log in to join the discussion
Log In2 Comments
cooper.reese6mo ago
Man, why do CSV exports always mess up the date format? I've had to fix that exact thing before... ended up writing a tiny script just to clean it up. Next time, try exporting as JSON first if you can, it usually keeps the structure better. That one-line fix is always out there, but finding it feels impossible sometimes.
5
charlie2696mo ago
Tell me about it, @cooper.reese, CSV dates are the WORST. Your script idea is smart, I basically did the same thing but it feels like fighting the same dumb battle every month. JSON is definitely cleaner if the system lets you, but half the old tools ONLY do CSV. The real fix needs to be the people making the export button actually thinking about it for five seconds.
1