How to FIX Easy Populate Error: No model field in record

[williamsba]

I came across an issue when I tried to import products to my Zen Cart install using the Easy Populate module that seems to be fairly common.

When importing your file you receive this error:

No model field in record. This line was not imported

In my case, the problem was with Excel. Excel was adding a bunch of extra tabs at the end of each row for some reason.

The fix that worked for me was to copy ONLY the columns and rows that contain the data, paste that data to a new spreadsheet, and re-export as a tab-delimited text file. This will remove all extra tabs from your file and allow you to import the file into Zen Cart using the Easy Populate module.

Hope this helps others with the same problem!

[micmed]

Thanks, that helped!

[dimsumgurl]

thanks you!!! This helped me too =]

[townsend2009]

Thanks for this temp fix.

I'm on a mac using NeoOffice and that software seems to add stuff to the end of the csv sheet too, every time you close and re-open. Very frustrating. I wonder why.

Anyone know a permanent fix to this?

[misty]

Use FREE program, Open Office, with Easy Populate.
Works much better than Excel

[AmyCapolupo]

I am using Open Office and the method above but I'm still getting the error. Even with every item having a number. Anybody got any other ideas?