Thanks for such a great product. I was wondering your recommendation on how to upload a .csv that 1) Contains HTML to go in a rich text editor and 2) Contains commas.
You are welcome sir! I don't think CSV is the best format for HTML since it usually contains a text indicator " and sometimes comma's also. CSV can be imported if you surround it with a text indicator like "
Example:
1,"Test","package,umbraco"
2 "Test2", "umbraco, conference"
Etc.
But for HTML the best format in the free edition will be SQL, or XML.
I wanted to give some feedback on this for those who may need help in the future as well.
I'm not schooled on SQL or XML uploading though that might be ideal.
What I did was use the quotes as Richard suggested. This kept the HTML in tact, however, the quotes actually appear in the fields as well. So I did have to manually go into each field and delete the quotes. Still, it was better than the first uploads I did.
How to deal with Commas and HTML
Hi Richard,
Thanks for such a great product. I was wondering your recommendation on how to upload a .csv that 1) Contains HTML to go in a rich text editor and 2) Contains commas.
Thanks for any direction you can offer!
Hi Jonathan,
You are welcome sir! I don't think CSV is the best format for HTML since it usually contains a text indicator " and sometimes comma's also. CSV can be imported if you surround it with a text indicator like "
Example:
1,"Test","package,umbraco"
2 "Test2", "umbraco, conference"
Etc.
But for HTML the best format in the free edition will be SQL, or XML.
Thanks,
Richard
I wanted to give some feedback on this for those who may need help in the future as well.
I'm not schooled on SQL or XML uploading though that might be ideal.
What I did was use the quotes as Richard suggested. This kept the HTML in tact, however, the quotes actually appear in the fields as well. So I did have to manually go into each field and delete the quotes. Still, it was better than the first uploads I did.
Thanks, Richard!
is working on a reply...