Sign in Register
Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • singer777 69 posts 80 karma points
    Apr 05, 2013 @ 23:16
    singer777
    0

    How to deal with Commas and HTML

    Using CMSImport

    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!

    Copy Link
  • Richard Soeteman 4035 posts 12842 karma points MVP
    Apr 06, 2013 @ 09:26
    Richard Soeteman
    1

    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

     

    Copy Link
  • singer777 69 posts 80 karma points
    Apr 15, 2013 @ 17:06
    singer777
    0

    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!

    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft