Zen Cart Logo
Forums / All Other Contributions/Addons / Easy Populate 1.2.5.5.csv "No model field" error

Easy Populate 1.2.5.5.csv "No model field" error

Locked

Views: 2,962

Results 1 to 9 of 9
This thread is locked. New replies are disabled.
17 Sep 2009, 7:31 PM
#1
swirlback avatar

swirlback

New Zenner

Join Date:
Sep 2009
Location:
Oregon, US
Posts:
11
Plugin Contributions:
0

Easy Populate 1.2.5.5.csv "No model field" error

Hi. It's my first time posting. If this has been answered already, I'd appreciate a link to the pertinent thread. My ZenCart version is 1.3.8a, patch1.
I get "No model field in record. This line was not imported" error when doing the following:

  1. On [tools]> [Easy Populate] page, click "download Complete .csv file to edit"
  2. Open the csv file, and delete rows so only the top row and 3 products are left in the csv file.
  3. Modify a single cell, under "v_products_description_1" in one of the products with plain alphabet letters.
  4. FTP the file into "tempEP" folder, enter the filename in "Import from Temp Dir (tempEP/)" box, and click [insert into db] button.
  5. Upload Results displays the correct filename, plus over 1700 lines of "No model field in record. This line was not imported" error in red font.

Could you tell me why I get the error?

17 Sep 2009, 9:12 PM
#2
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: Easy Populate 1.2.5.5.csv "No model field" error

Do your products have model numbers entered?
The free EP available requires that "ALL" products have a model # as it indexes on that field

17 Sep 2009, 9:17 PM
#3
schoolboy avatar

schoolboy

Totally Zenned

Join Date:
Jun 2005
Location:
Cumbria, UK
Posts:
10,327
Plugin Contributions:
0

Re: Easy Populate 1.2.5.5.csv "No model field" error

Search the WIKI for Easy Populate - I wrote a tutorial for 1.2.5.4 , but much of it is relevant for the csv version...

17 Sep 2009, 9:33 PM
#4
swirlback avatar

swirlback

New Zenner

Join Date:
Sep 2009
Location:
Oregon, US
Posts:
11
Plugin Contributions:
0

Re: Easy Populate 1.2.5.5.csv "No model field" error

kobra:

Do your products have model numbers entered?
The free EP available requires that "ALL" products have a model # as it indexes on that field

Yes, I should have mentioned that all 3 products have data in the first column "v_products_model'.
I just tested again with same result. All I did to the downloaded csv was to delete extra products so that I only had 3 products and the top row with field names, and change ONE cell under "v_products_description_1" of one of the product.

I printed out and read the wiki on Easy Populate yesterday. Can't say I didn't miss anything, but it mostly made sense. I am puzzled.

17 Sep 2009, 10:31 PM
#5
swirlback avatar

swirlback

New Zenner

Join Date:
Sep 2009
Location:
Oregon, US
Posts:
11
Plugin Contributions:
0

Re: Easy Populate 1.2.5.5.csv "No model field" error

I just tried opening the downloaded csv with OpenOffice Calc, as ISO-8859-1, US Ascii, and UTF-8. I get a slightly different error now than Japanese encoding my Excel defaults to when opening a csv (grrrr). I copied the resulting error message below-- still no dice.

I'll copy the text of downloaded csv below that, and attach a jpg of csv spreadsheet view .

error message

Filename: new8.csv

No model field in record. This line was not importedariana.jpg | Ariana | apple desc | | | | | 5 | 0.05 | | 05/31/09 0 | 10 | Canon | Vintage Cr | | | | | | | Taxable Go | 1 | 0 | 0 | 0 | 0 | 0 | | | |
No model field in record. This line was not importedamdelt.jpg | America's | apple desc | | | | | 10 | 0.05 | 0001-01-01 | 09/17/09 1 | 10 | Canon | Vintage Cr | | | | | | | Taxable Go | 1 | 0 | 0 | 0 | 0 | 0 | | | |
SKIPPED! - Model: - No category provided for this product
SKIPPED! - Model: - No category provided for this product
SKIPPED! - Model: - No category provided for this product
SKIPPED! - Model: - No category provided for this product |
SKIPPED! - Model: - No category provided for this productthree sixt | apple desc | | | | | 5 | 0.05 | | 09/17/09 1 | 10 | Canon | Vintage Cr | | | | | | | Taxable Go | 1 | 0 | 0 | 0 | 0 | 0 | | | |
Upload Complete


csv text of the uploaded file

"v_products_model","v_products_image","v_products_name_1","v_products_description_1","v_products_url_1","v_specials_price","v_specials_date_avail","v_specials_expires_date","v_products_price","v_products_weight","v_date_avail","v_date_added","v_products_quantity","v_manufacturers_name","v_categories_name_1","v_categories_name_2","v_categories_name_3","v_categories_name_4","v_categories_name_5","v_categories_name_6","v_categories_name_7","v_tax_class_title","v_status","v_metatags_products_name_status","v_metatags_title_status","v_metatags_model_status","v_metatags_price_status","v_metatags_title_tagline_status","v_metatags_title_1","v_metatags_keywords_1","v_metatags_description_1"
"Ariana","ariana.jpg","Ariana","apple description ",,,,,5,0.05,,05/31/09 04:50 PM,10,"Canon","Vintage Crate Labels",,,,,,,"Taxable Goods",1,0,0,0,0,0,,,
"bbbbbbbbbbbbbbb","amdelt.jpg","America's Delight","apple description ",,,,,10,0.05,"0001-01-01 00:00:00",09/17/09 10:48 AM,10,"Canon","Vintage Crate Labels",,,,,,,"Taxable Goods",1,0,0,0,0,0,,,
365,"365.jpg","three sixty-five","apple description ",,,,,5,0.05,,09/17/09 11:26 AM,10,"Canon","Vintage Crate Labels",,,,,,,"Taxable Goods",1,0,0,0,0,0,,,

18 Sep 2009, 7:08 AM
#6
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: Easy Populate 1.2.5.5.csv "No model field" error

swirlback,
I am not seeing the EOL* that should be at the end of every line

18 Sep 2009, 9:44 AM
#7
schoolboy avatar

schoolboy

Totally Zenned

Join Date:
Jun 2005
Location:
Cumbria, UK
Posts:
10,327
Plugin Contributions:
0

Re: Easy Populate 1.2.5.5.csv "No model field" error

I think that for the CSV version, the EOREOR format was "discontinued" Look for posts by "phazei" who was originally behind the csv project...

(or uninstall 1.2.5.5 csv, and use 1.2.5.4)

18 Sep 2009, 4:06 PM
#8
swirlback avatar

swirlback

New Zenner

Join Date:
Sep 2009
Location:
Oregon, US
Posts:
11
Plugin Contributions:
0

Re: Easy Populate 1.2.5.5.csv "No model field" error

Hi kobra and schoolboy,

I appreciate your reviews and comments. I'll try different ways for now, but I appreciate the efforts made thus far towards the csv project as well. It's not easy to get things right right away. Thanks.

18 Sep 2009, 7:41 PM
#9
swirlback avatar

swirlback

New Zenner

Join Date:
Sep 2009
Location:
Oregon, US
Posts:
11
Plugin Contributions:
0

Re: Easy Populate 1.2.5.5.csv "No model field" error

The title of this thread is not correct. The version I was having problem was "1.2.5.6.csv.2". (I copied the version off my screen while on Easy Populate, but obviously it was off. Sorry. )

I was able to uninstall it as per: http://modhole.com/modhole/index.php?module=wiki&page=EpRemove .