Open full view…

Export to CSV (error)

Sat, 19 Nov 2016 17:28:09 GMT

I am testing your software. I like it But while testing, I notice an error that occur while exporting to a text file (CSV) I took the example file "World Inventions" and export it to csv file. The text of the value summary does not export properly as the text is sometime on 2 or 3 lines. I use Notepad++ and at line 287 "2","2nd Millenium BC Inventions" is on 3 lines and at line 290 "3","1st Millenium BC Inventions" is on 2 line Does that mean that there is a limit of text to export in a CSV file in the Value Summary ? Or a bug ?

Sun, 20 Nov 2016 18:59:57 GMT

Using WINDOWS version

Mon, 21 Nov 2016 00:16:52 GMT

Hi, The reason that these two events have data on more than 1 line, is that the text itself in the Value Summary contains new line characters. Therefore when exporting to csv, these characters are included, and therefore the text starts on a new line. Jess

Mon, 21 Nov 2016 03:52:44 GMT

I understand that, so in Summary, the limit is one line of character and should not be more than one new line character

Mon, 21 Nov 2016 04:05:18 GMT

I tested it and it work. Therefore no paragraph in Summary I suggest that you correct the examples (at least the World invention for i did not test the Murder on the Orient Express)

Mon, 21 Nov 2016 04:06:37 GMT


Mon, 21 Nov 2016 11:11:03 GMT

Hi, While the CSV format is not standard, most applications (e.g. Microsoft Excel, Apple Numbers) will be able to understand and correctly interpret new lines inside double quotes as being part of the same field, not a new row. Therefore you should be able to do more than one paragraph in the summary. Jess