Quote:
Originally Posted by halldorr
This is what I was finding as well. I wrote something where I could upload a zip of the CSVs, it would unzip the CSVs, then insert it into temporary tables.
I still had to code up all the HTML reports stuff but ran into this very issue you mention with the ampersands causing issues.
|
Yeah, this is an issue which I cant help but feel must just be an oversight in how that dump feature works. Unless there is a reason for those HTML escape characters to just be included on the end of some lines and I'm just ignorant of that (which is entirely possible). Even if they made an amendment to change the encoding to something like 'latin-1' and got rid of the unescaped HTML that would be a huge improvement for the player_master.csv when it comes to trying to do anything with Pandas/Python with it.