When I export all my rankings to a CSV, some rows are not correct. See image.
https://imgur.com/a/bLoVom0
Export CSV
- mpowell
- Posts: 3853
- 1201 Ratings
- Your TCI: na
- Joined: Fri Sep 09, 2005 10:22 am
Re: Export CSV
Thanks for reporting this! We'll take a look and let you know when it's fixed!
- mpowell
- Posts: 3853
- 1201 Ratings
- Your TCI: na
- Joined: Fri Sep 09, 2005 10:22 am
Re: Export CSV
Hi again! We've made a couple changes to this functionality, but they're not necessarily going to address the problems you reported:
The garbled character in "Autómata" depends on you importing the file in UTF8 format -- when I import this into my spreadsheet, for example, it looks correct.
And the backslashed quotes are necessary, as part of the XML format. There's just no way around it -- the easiest way to "fix" the problem would be to search/replace within your spreadsheet program, from \" to "
The changes we did make will also help with the formatting of this file Thanks again!
The garbled character in "Autómata" depends on you importing the file in UTF8 format -- when I import this into my spreadsheet, for example, it looks correct.
And the backslashed quotes are necessary, as part of the XML format. There's just no way around it -- the easiest way to "fix" the problem would be to search/replace within your spreadsheet program, from \" to "
The changes we did make will also help with the formatting of this file Thanks again!
- livelove
- Posts: 759
- 67 Ratings
- Your TCI: na
- Joined: Thu Sep 17, 2015 9:36 pm
Re: Export CSV
Why is XML format necessary for a CSV file ?mpowell wrote:And the backslashed quotes are necessary, as part of the XML format.
- td888
- Posts: 836
- 3955 Ratings
- Your TCI: na
- Joined: Thu Jul 12, 2007 10:44 am
Re: Export CSV
mpowell wrote:Hi again! We've made a couple changes to this functionality, but they're not necessarily going to address the problems you reported:
The garbled character in "Autómata" depends on you importing the file in UTF8 format -- when I import this into my spreadsheet, for example, it looks correct.
And the backslashed quotes are necessary, as part of the XML format. There's just no way around it -- the easiest way to "fix" the problem would be to search/replace within your spreadsheet program, from \" to "
The changes we did make will also help with the formatting of this file Thanks again!
Thanks for the reply.
- livelove
- Posts: 759
- 67 Ratings
- Your TCI: na
- Joined: Thu Sep 17, 2015 9:36 pm
Re: Export CSV
@mpowell:mpowell wrote:And the backslashed quotes are necessary, as part of the XML format.
We are talking about CSV files (topic title).
Why is XML format necessary for a CSV file ?