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: [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

Re: [gversion] csv import not working without mapping

By Jason - May 7, 2012

Hi Greg,

The current version of the plugin doesn't allow for files without column headers. This is a feature that we are currently working on, but has not yet been released. In the mean time, the best approach would be to add column headers to your file before uploading.

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/