Importing simple CSV file into EE with CSVGrab is not working...
Development and Programming
Hello,
I have a simple CSV file that I would like to import as weblog entries. I am using three custom fields, and when I go through the process, I get this message:
TRACE: Array ( [title] => Array ( [is_custom] => 0 [field] => 1 ) [date] => Array ( [is_custom] => 0 [field] => ) [exhibitor_name] => Array ( [is_custom] => 1 [field] => 1 ) [exhibitor_booth] => Array ( [is_custom] => 1 [field] => 2 ) [exhibitor_url] => Array ( [is_custom] => 1 [field] => 3 ) )
TRACE: Resource id #49
TRACE: 1 - Array ( [0] => Advanced Tracking Technologies Inc. [1] => Advanced Tracking Technologies Inc. [2] => 1101 [3] => http://www.online-access.com/ )
Checking: Advanced Tracking Technologies Inc.
Found new entry: Advanced Tracking Technologies Inc.
MySQL ERROR:
Error Number: 1054
Description: Unknown column 'field_id_' in 'field list'
Query: INSERT INTO `exp_weblog_data` (`entry_id`, `weblog_id`, `field_id_`, `field_ft_`) VALUES ('153', '4', 'http://www.online-access.com/', '')I think: field_id_, field_ft_ this is the troublesome bit, but am not sure…
I have tried using the plugin about 20 different ways, with different configurations, different delimiters, etc… At this point, I’m just stuck..
The plugin DOES seem to add the first record, or at least some of it. I can see it in the blog list, but when I go to edit it, EE says it does not exist!
I have attached the CSV file as a TXT file.
Thanks for your help, I’m really impressed by EE and look forward to being part of the community…
Is there any other information I could add to assist in answering my question? Could somebody that has used this plugin successfully share their CSV file and inline code?
This is an odd error. It would appear that there’s something wrong with one of the custom field definitions. Could you post your template?
Doublecheck to make sure the custom field names really correspond to custom fields in the weblog.
Try a very simple import first. Just choose one custom field, no date, etc. If that succeeds, add one field at a time. If that fails, try another field first.
Did you figure out a solution to this issue?
I am getting a similar Unkown column field_id error and can’t figure it out to save my life.
Any help would be much appreciated.
Notice: Undefined index: id in /home/site/public_html/system/plugins/pi.csvgrab.php on line 579
MySQL ERROR:
Error Number: 1054
Description: Unknown column 'field_id_' in 'where clause'
Query: SELECT * FROM exp_weblog_titles t, exp_weblog_data d WHERE t.entry_id = d.entry_id AND field_id_="Test Import"
I too am getting a similar error.
Checking:
Found new entry:
MySQL ERROR:
Error Number: 1054
Description: Unknown column 'field_id_' in 'field list'
Query: INSERT INTO `exp_weblog_data` (`entry_id`, `weblog_id`, `field_id_`, `field_ft_`, `field_id_26`, `field_ft_26`) VALUES ('733', '59', '', '', '', 'none')I figured out that in my case - I had not assigned the field group to the weblog I was trying to import into. That fixed the issue for me.
Thanks for the quick reply! As it turns out, my field group names did not match what I was requesting (mismatched upper and lower case)