Ultimate Guide to Multi Channel Sofwtare Book
Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

mail_open
Magmi import failure: wrong column number : 30 found over 1, line skipped
annalisa

Not so New
March 1, 2018 - 10:51 am
Member Since: February 9, 2018
Forum Posts: 4
sp_UserOfflineSmall Offline

Hi there,
I’m trying to upload my first batch of products to Magento via MAGMI it’s driving me nuts. It’s a series of variation products (30 parents, each with 5 child products). I ran a test with an upload of one parent with its associated child products and it uploaded quickly and everything populated in Magento as it expected. Following this, I tried to upload another batch of 20 or so products, and every time I upload, I get 66 warnings in Magmi. The error reads as follows:

plugin;Magmi_CSVDataSource;warning:CSV Datasource v1.3 – warning: line 1 , wrong column number : 30 found over 1, line skipped
plugin;Magmi_CSVDataSource;warning:CSV Datasource v1.3 – warning: line 2 , wrong column number : 41 found over 1, line skipped
plugin;Magmi_CSVDataSource;warning:CSV Datasource v1.3 – warning: line 3 , wrong column number : 41 found over 1, line skipped
plugin;Magmi_CSVDataSource;warning:CSV Datasource v1.3 – warning: line 4 , wrong column number : 41 found over 1, line skipped
plugin;Magmi_CSVDataSource;warning:CSV Datasource v1.3 – warning: line 5 , wrong column number : 41 found over 1, line skipped
….etc to line 66

The status data reads as follows:
Running Magmi Product Import Engine v1.7.1 by dweeves
Import Profile:default
Import Mode:update
CSV Datasource v1.3 – Importing CSV : /home/framingm/public_html/var/import/MAGMI_UPLOAD_180229.csv using separator [ /t ] enclosing [ ” ]
Performing Datasouce Lookup…
Found 66 records, took 0.0248367786407 sec
CSV Datasource v1.3 – No BOM detected, assuming File is UTF8 without BOM…
CSV Datasource v1.3 – 1 CSV headers columns found
Image attributes processor v1.0.25 – no image attributes found in datasource, disabling image processor
Configurable Item processor v1.3.7 – no options_container set, defaulting to :Block after product info
Ajusted processed columns:3

I’ve tried varying the inpu details for the CSV separator and enclosure fields (trying with a tab, without a tab, with and without commas, apostrophes and leaving it blank…) but it doesn’t make a difference.

Can anyone offer any suggestions as to how we fix this and get back up and running. This is the first time we have used Magmi to upload variations, so we’re wondering if it’s anything to do with that, or if it’s an issue with the CSV.

Avatar
Dave Furness

Founder
March 7, 2018 - 6:14 pm
Member Since: July 19, 2013
Forum Posts: 4557
sp_UserOfflineSmall Offline

Hey Anna,

9 times out of 10 an issue like this is caused by the spreadsheet. Double check the fields and entries to make sure they are right. If you havd success with your first test import double check what you are doing now with that.

Feel free to upload a spreadsheet here if you are still stuck to see if we can assist.

Dave

The following users say thank you to Dave Furness for this useful post:

annalisa

Every expert was once a beginner

annalisa

Not so New
March 8, 2018 - 10:16 am
Member Since: February 9, 2018
Forum Posts: 4
sp_UserOfflineSmall Offline

Yep, the spreadsheet was the proble. I hate CSVs!!!!!

Avatar
Dave Furness

Founder
March 13, 2018 - 1:42 pm
Member Since: July 19, 2013
Forum Posts: 4557
sp_UserOfflineSmall Offline

Ha ha ha that’s why I hate Magmi :D If it wasn’t for Matt I wouldn’t touch it

Every expert was once a beginner

 

Why Should You Join UnderstandingE?

 
  • Access to over 500 step-by-step video tutorials
  • +20 video courses available
  • Magento, M2E Pro, Magmi, eBay, Amazon & Design all covered
  • Everything is in 100% Plain English
  • Learn how to build your own multi-channel software for eBay & Amazon
  • Access to the community forums, meet fellow business owners like yourself

Join Now with 2 Clicks

 

Join now for less that £1 per day you can gain access to over 400 step-by-step video tutorials & learn how to build your very own multi-channel software.

 

Forum Timezone: Europe/London

Most Users Ever Online: 1012

Currently Online:
8 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Jim @ Moogento: 688

Steve Froggatt: 514

Badeth - UE: 513

Jimbob: 453

Paul Cartwright: 414

Forum Stats:

Groups: 6

Forums: 37

Topics: 5171

Posts: 27363

Administrators: Matthew Ogborne: 4565, Dave Furness: 4557