Forgot your password?
Re: Change Delimiter
Posted by
lorty
at
2006-09-19 15:57
I am using the python csv module,
to change delimiters you should refer to its documentation.
Anyway its a good practice to quote the text you are going to import,
e.g.
id, text, field1
1,"this text is quoted, so this comma is not a problem","abcd"
Please let me know if this solves your problem.
Thanks,
Lorenzo Musizza
Re: Re: Change Delimiter
Posted by
at
2006-09-19 18:25
Thank you for the quick response and the reference to the CSV module.
It turns out I didn't need to make any changes to the Importer.py file. I needed to set the delimiter in the header of the upload file in the Plone interface in Step 2.
The example header provided was:
ID,Title,Description,Text
By replacing the commas with my desired delimiter (e.g. ~) I could successfully map the fields:
ID~Title~Description~Text
In this case I am attempting a mass html import, where commas and quote characters are extremely common, which would truncate my imports. The new delimited characters are working very well.
Thanks for your help,
Shem
