Easy Populate 1.2.5.4 support

[DrByte]

then i downloaded a full sheet with the details in and made a start on the descriptions .. but they are not showing at all ..

I'm not sure I follow you. You downloaded the details, but the descriptions aren't showing...
Are you saying the downloaded file doesn't contain the descriptions, or that your edits don't show after uploading, or that after uploading ALL your products no longer have descriptions?

[Erica]

I'm not sure I follow you. You downloaded the details, but the descriptions aren't showing...
Are you saying the downloaded file doesn't contain the descriptions, or that your edits don't show after uploading, or that after uploading ALL your products no longer have descriptions?

i started initially with a blank sheet, and added all bits except the descriptions and uploaded it all and it worked great. i then went and customised the rest of the site. this evening i went to admin/tools/easy populate .. and downloaded the complete delimited file. i opened it up in excel and started copying and pasting descriptions. i only did a few full ones and the rest i put 'info to follow' in the space. i uploaded the file and the descriptions are not showing on the products.

Sorry .. i just tried again, as i was describing what i was doing .. and its working sorry .. i obviously did something wrong last time
Erica xx

[Woodymon]

something has caused the description rows to not be created in the table products_descriptions. Have you changed this database table?

Thanks for the tip. Looking in the DB at the products and products_description tables I observe the products uploaded via EP appear ok in the products table but do not appear in the products_description table.

Any possible causes?

The products I added manually via admin appear in both tables (and display correctly).

The products and products_description table structure follows. (all default ZC 1.3.0.2 fresh install structure)

Products table structure

products
Field Type Null Default 
products_id   int(11) No      
products_type   int(11) No  1    
products_quantity   float No  0    
products_model   varchar(32) Yes  NULL    
products_image   varchar(64) Yes  NULL    
products_price   decimal(15,4) No  0.0000    
products_virtual   tinyint(1) No  0    
products_date_added   datetime No  0001-01-01 00:00:00    
products_last_modified   datetime Yes  NULL    
products_date_available   datetime Yes  NULL    
products_weight   float No  0    
products_status   tinyint(1) No  0    
products_tax_class_id   int(11) No  0    
manufacturers_id   int(11) Yes  NULL    
products_ordered   float No  0    
products_quantity_order_min   float No  1    
products_quantity_order_units   float No  1    
products_priced_by_attribute   tinyint(1) No  0    
product_is_free   tinyint(1) No  0    
product_is_call   tinyint(1) No  0    
products_quantity_mixed   tinyint(1) No  0    
product_is_always_free_shipping   tinyint(1) No  0    
products_qty_box_status   tinyint(1) No  1    
products_quantity_order_max   float No  0    
products_sort_order   int(11) No  0    
products_discount_type   tinyint(1) No  0    
products_discount_type_from   tinyint(1) No  0    
products_price_sorter   decimal(15,4) No  0.0000    
master_categories_id   int(11) No  0    
products_mixed_discount_quantity   tinyint(1) No  1    
metatags_title_status   tinyint(1) No  0    
metatags_products_name_status   tinyint(1) No  0    
metatags_model_status   tinyint(1) No  0    
metatags_price_status   tinyint(1) No  0    
metatags_title_tagline_status   tinyint(1) No  0    


Indexes: Keyname Type Cardinality Field 
PRIMARY  PRIMARY 15   products_id  
idx_products_date_added_zen  INDEX None   products_date_added  
idx_products_status_zen  INDEX None   products_status

--

Products_description table structure

products_description
Field Type Null Default 
products_id   int(11) No      
language_id   int(11) No  1    
products_name   varchar(64) No      
products_description   text Yes  NULL    
products_url   varchar(255) Yes  NULL    
products_viewed   int(5) Yes  0    


 Indexes: Keyname Type Cardinality Field 
PRIMARY  PRIMARY 4   products_id  
language_id  
idx_products_name_zen  INDEX None   products_name

[Woodymon]

I cleared the text in each products description field in the spreadsheet and instead just entered D1 for each product description and then uploaded. But same negative result.

It is strange why one table would get updated but the other table would not.

Any other tables I should look at?

Wonder if the mod_security filtering on server is contributing to this isssue?

[Woodymon]

And I just did the same for model numbers. Cleared them all out and instead entered simple unique numerics for each product model eg. 1, 2, 3 etc. no errors reported but same negative result. Any clues?

[wtashby]

Is your file properly-saved as "tab-delimited" ?
Does it have the closing EOREOR column at the end of each row?
Does it work any differently if you upload the file by FTP and then tell EP the filename to use directly?

Yes, it's tab-delimited
Yes, EOREOR ends every line
No, it doesn't act differently using ftp.

I still get the error:

File Import Failed! Primary index column v_products_model missing from uploads file. Please consult the readme.html file for more information

[wtashby]

Can someone please tell me what the header fields for 3.0.2 are?

Many are the same as older versions, but many are also different! Especially the categories. I have already tried creating and downloading all of the test files available in ep, and NONE of them show me what to name my sub categories. In fact those data files and data templates you can create and download as examples are completely useless.

What do you name the master category, and subsequent sub-categories.

Thanks,

Tom

[apinkpony11]

Hi again,

for some reason, when i go to split my file of around 7000 items, it will only split twice, and then those two splits only have around 600 items each!

I know I saved it correctly, and all of that, but I'm not sure what's going on.

This time, it told me this:

Warning: fopen(/home/content/a/p/i/apinkpony/html/shop/temp/Full-EP2006Aug12-1111.txt): failed to open stream: No such file or directory in /home/content/a/p/i/apinkpony/html/shop/admin/easypopulate.php on line 1126

Warning: fgets(): supplied argument is not a valid stream resource in /home/content/a/p/i/apinkpony/html/shop/admin/easypopulate.php on line 1129

Warning: fgets(): supplied argument is not a valid stream resource in /home/content/a/p/i/apinkpony/html/shop/admin/easypopulate.php on line 1141

Warning: fclose(): supplied argument is not a valid stream resource in /home/content/a/p/i/apinkpony/html/shop/admin/easypopulate.php on line 1168

Not sure what to do w/ that information though.

[langer]

Can someone please tell me what the header fields for 3.0.2 are?

Support for the advanced version is not offered here.

[apinkpony11]

Any thoughts?