ExpressionEngine CMS
Open, Free, Amazing

Thread

This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.

The active forums are here.

Member Import "Convert delimited text to XML" not reading data columns correctly

March 15, 2011 5:07pm

Subscribe [5]
  • #16 / Jun 10, 2012 11:49am

    John Henry Donovan

    12339 posts

    Ryan,

    Recently went through this process myself. Do not use Microsoft for any CSV work on a Mac as it is atrocious.
    Use OpenOffice or NeoOffice for the Mac. This will make sure you have the correct line endings etc.

    Another online tool I came across recently if you want to bypass the conversion tool altogether is Mr.Data Converter http://shancarter.com/data_converter/ The tool is excellent and you will have your XML in seconds
    Only thing to remember is name your Column heading sin your CSV to the same field name as your member fields

    Hope that helps

  • #17 / Jun 11, 2012 10:06am

    Ryan M.

    1511 posts

    Thanks for the feedback, John! I may try the online converter.

  • #18 / Jun 13, 2012 10:19am

    Shane Eckert

    7174 posts

    Hey All,

    Nice work collaborating! Thanks for the tip John Henry.

    Please let support know if there is anything else we can do to help!

    Thank you,

.(JavaScript must be enabled to view this email address)

ExpressionEngine News!

#eecms, #events, #releases