BUG: Importing CSV file problem

[Ed Philpott]

I exported a file in CSV format to do some mass editing. I did not change the column names or structure, just the data. When I import the file back into ToDoList I get an error saying that I need to include Title in the column mapping but there is no way of doing this. I even tried re-importing the exported CSV file and got the same error.
The online help file does not address this issue.
Thanks, Ed

[.dan.g.]

Hi Ed

I suspect that the problem is being caused by the software not correctly determining the 'column separator' character.

In the following dialog:

try changing the CSV delimiter (top-right) to '\t' (without the quote marks). 

Then you should see something like:

Dan

[Ed Philpott]

Dan, the "\t" worked. I explored the original csv file and found that it was a tab delimited file not an actual csv file. I re-exported the task list assigning a "," as the separator but Excel did not recognize it so did not break it into columns. I may explore further but for now all is OK.
Thanks, Ed

[G-Eric]

Ed,
According to your "regional settings", your Excel might expect ';' (semicolon) as separator.
In this case, do it again by replacing your ',' entry by a ';'.

Otherwise, you can always edit (Notepad) your exported file with ',' separator and add a new top first line (to force the symbol used during the import process) stating :
SEP=,

It is a temp workaround, and I hope this might help.
Thanks, Eric