csv import not working without mapping

6 posts by 3 authors in: Forums > CMS Builder: Plugins & Add-ons
Last Post: May 7, 2012   (RSS)

By rez - February 5, 2011


I amtrying to import the 50 staes csv available in this zip:
http://www.tellingmachine.com/post/all-50-states-as-xml-json-csv-xls-files.aspx

I create an editor named states and select it with my target file. Everything analyzes fine and looks ok in the preview. (preview is no more than 10 records?)
I dont select any options because i want all the fields created automatically. readme.txt "If you're importing into an empty section, you won't need to set
any options at all."

When I select validate, I get:

No target fields selected! You must select at least one target field!

Thanks for any help.

Re: [rez] csv import not working without mapping

By Jason - February 7, 2011

Hi,

If the section is empty section, you don't need to choose any advanced options, but you do need to complete the "Map Fields" section. This tells the plugin which columns should go into which CMS Builder fields.

Hope this helps.
---------------------------------------------------
Jason Sauchuk - Project Manager
interactivetools.com

Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/

Re: [Jason] csv import not working without mapping

By rez - February 7, 2011

Oh, in other words the plug in does not create fields based on the column headers in the import file? I thought that was possible automatically.

I have to create an editor with all the fields to import into and then map them you mean?

Re: [rez] csv import not working without mapping

By Jason - February 7, 2011

Yes, you have to map individual columns to fields you created in your section.

Hope this helps
---------------------------------------------------
Jason Sauchuk - Project Manager
interactivetools.com

Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/

Re: [Jason] csv import not working without mapping

By gversion - May 4, 2012

Hi Jason,

How do I import without column headings? It seems to say "Column Headings: Yes" by default and I can't find out how to change this setting.

My CSV doesn't have column headings so I don't want it to ignore the first row.

Thanks,
Greg