If this is your first visit, check our documentation. To post, register or login.
Forums / Addon Admin Tools / Easy Populate 1.2.5.4 support

Easy Populate 1.2.5.4 support

Started by langer on 9 May 2006, 9:44 PM · Views: 1,303,108

Results 261 to 280 of 3,834
19 Aug 2006, 8:27 PM
#261
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,512
Plugin Contributions:
176

Easy Populate 1.2.5.4 support

Erica:

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?

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

19 Aug 2006, 8:42 PM
#262
erica avatar

erica

Zen Follower

Join Date:
Jul 2006
Location:
Rotherham, UK
Posts:
126
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

DrByte:

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 :blush: sorry .. i obviously did something wrong last time
Erica xx

19 Aug 2006, 10:26 PM
#263
woodymon avatar

woodymon

Totally Zenned

Join Date:
Sep 2004
Posts:
2,309
Plugin Contributions:
1

Re: Easy Populate 1.2.5.4 support

langer:

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  
19 Aug 2006, 10:45 PM
#264
woodymon avatar

woodymon

Totally Zenned

Join Date:
Sep 2004
Posts:
2,309
Plugin Contributions:
1

Re: Easy Populate 1.2.5.4 support

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?

19 Aug 2006, 10:55 PM
#265
woodymon avatar

woodymon

Totally Zenned

Join Date:
Sep 2004
Posts:
2,309
Plugin Contributions:
1

Re: Easy Populate 1.2.5.4 support

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?

19 Aug 2006, 11:52 PM
#266
wtashby avatar

wtashby

Totally Zenned

Join Date:
Feb 2006
Posts:
594
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

DrByte:

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

I Think, Therefore I Zen. I Zen, Therefore, I AM!
Personalized Flowers!
Flowertown Speaking Roses
using version 1.5.7-06232020

20 Aug 2006, 12:58 AM
#267
wtashby avatar

wtashby

Totally Zenned

Join Date:
Feb 2006
Posts:
594
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

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.:huh:

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

Thanks,

Tom

I Think, Therefore I Zen. I Zen, Therefore, I AM!
Personalized Flowers!
Flowertown Speaking Roses
using version 1.5.7-06232020

20 Aug 2006, 1:49 AM
#268
apinkpony11 avatar

apinkpony11

Zen Follower

Join Date:
Aug 2006
Posts:
112
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

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.

20 Aug 2006, 2:23 AM
#269
langer avatar

langer

Totally Zenned

Join Date:
Aug 2004
Location:
Sydney, Australia
Posts:
1,258
Plugin Contributions:
1

Re: Easy Populate 1.2.5.4 support

wtashby:

Can someone please tell me what the header fields for 3.0.2 are?
Support for the advanced version is not offered here.

20 Aug 2006, 2:43 AM
#270
apinkpony11 avatar

apinkpony11

Zen Follower

Join Date:
Aug 2006
Posts:
112
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

Any thoughts?

20 Aug 2006, 3:00 AM
#271
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,512
Plugin Contributions:
176

Re: Easy Populate 1.2.5.4 support

wtashby:

File Import Failed! Primary index column v_products_model missing from uploads file. Please consult the readme.html file for more information
v_products_model ... must exist. EP cannot run without it.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

20 Aug 2006, 3:03 AM
#272
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,512
Plugin Contributions:
176

Re: Easy Populate 1.2.5.4 support

/home/content/a/p/i/apinkpony/html/shop/temp/Full-EP2006Aug12-1111.txt): failed to open stream: No such file or directory

Is this the name of the file you were uploading?: Full-EP2006Aug12-1111.txt

Not sure why it would have trouble splitting the file. Haven't used that feature much.

While I realize it's a bit of a pain, can you split the file manually on your PC, and then upload the separate files manually?

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

20 Aug 2006, 3:05 AM
#273
apinkpony11 avatar

apinkpony11

Zen Follower

Join Date:
Aug 2006
Posts:
112
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

Yeah. That's what I originally did was split in manually, but that's before I realized it could split it, it self.

It worked fine the first time, but I had to like, start over because I had a lot of ugly stuff going on with categories.

Anyway, yeah, guess it's back to manually splitting. No biggie, thank you.

20 Aug 2006, 2:04 PM
#274
wtashby avatar

wtashby

Totally Zenned

Join Date:
Feb 2006
Posts:
594
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

DrByte:

v_products_model ... must exist. EP cannot run without it.

Look, I said earlier, and I'll say it again, I HAVE v_products_model in my files. I also said that this is a file I have succesfully uploaded with earlier versions of EP. The problem seems to be that many of the header names for the advanced version are different than previous versions, causing errors, unless you updated your header names as well.

However, I have learned that support for the advanced version can be found elsewhere, as Langer was kind enough to tell me where to find it. Thank you.

Therefore, please consider my issue resolved and closed. Thanks.

I Think, Therefore I Zen. I Zen, Therefore, I AM!
Personalized Flowers!
Flowertown Speaking Roses
using version 1.5.7-06232020

20 Aug 2006, 10:42 PM
#275
woodymon avatar

woodymon

Totally Zenned

Join Date:
Sep 2004
Posts:
2,309
Plugin Contributions:
1

Re: Easy Populate 1.2.5.4 support

Woodymon:

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?

Hosting provider reported that all is well with mod_security configuration.

I'm out of ideas.

Anyone else observe similar issues of EP updating the products table but NOT the products_description table?

Anyone here know this mod well enough to explain if an internal EP log file is maintained, which records the INSERT SQL attempts which should be occurring during the HTTP upload process?

I've heard of a possible EP debug file but don't know where to find it. I have Admin > Config > EP > Debug Logging set to "true". Or maybe that feature refers to the "Upload Results" written to screen during the upload?

And/or is there would be a server log file (MySQL or Apache or otherwise) that might provide useful troubleshooting info?

If not able to solve this will just have to give up on EP and begin the long process of enter hunderds of products and categories manually. Or maybe enter via phpmyadmin

Thanks for any ideas.

Woody

21 Aug 2006, 5:05 AM
#276
petteriu avatar

petteriu

New Zenner

Join Date:
Nov 2005
Posts:
6
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

Woodymon:

...Anyone here know this mod well enough to explain if an internal EP log file is maintained, which records the INSERT SQL attempts which should be occurring during the HTTP upload process?....
Woody
EP log is in the uploads folder. I see it only when there are problems during operation, not continiously for all activities I don't know if ZC admin log would be any use for you ?

Petteri

21 Aug 2006, 6:39 AM
#277
woodymon avatar

woodymon

Totally Zenned

Join Date:
Sep 2004
Posts:
2,309
Plugin Contributions:
1

Re: Easy Populate 1.2.5.4 support

petteriu:

EP log is in the uploads folder. I see it only when there are problems during operation, not continiously for all activities I don't know if ZC admin log would be any use for you ?

Petteri

Thanks. Where would the EP "uploads" folder be located?

Or are you referrring to the directory on the client PC which we are uploading from? No log files appear there.

Where is ZC admin log located?

21 Aug 2006, 6:56 AM
#278
petteriu avatar

petteriu

New Zenner

Join Date:
Nov 2005
Posts:
6
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

I was referring to EP advanced, but it seems that you aren't using advanced, are you ? There should be uploads directory defined in either EP configuration settings or easypopulate_config.php file.
Not sure if there is a place to view Zencart admin log, except going to databse itself (table admin_activity_log, note possible prefix in table name)

Petteri

Woodymon:

Thanks. Where would the EP "uploads" folder be located?

Or are you referrring to the directory on the client PC which we are uploading from? No log files appear there.

Where is ZC admin log located?

21 Aug 2006, 10:18 AM
#279
woodymon avatar

woodymon

Totally Zenned

Join Date:
Sep 2004
Posts:
2,309
Plugin Contributions:
1

Re: Easy Populate 1.2.5.4 support

petteriu:

I was referring to EP advanced, but it seems that you aren't using advanced, are you ?
No. v.1.2.5.4

petteriu:

There should be uploads directory defined in either EP configuration settings or easypopulate_config.php file.
I am uploading directly from client so not directly observing the temp directory. I see now the upload directory points to the /temp directory on the server.

I assume this refers to /public_html/shop/temp. That directory contains copies of the *.txt files I processed via HTTP upload from the EP client. But no log or debug files appear in that directory.

petteriu:

Not sure if there is a place to view Zencart admin log, except going to databse itself (table admin_activity_log, note possible prefix in table name)
via phpyadmin looked in admin_activity_log table and page accessed column shows entries for easypopulate.php with page_parameters of "split=0&", corresponding to the times when I processed my various test uploads. No other info displayed.

I suspect I need to check the Apache logs. I'm not sure if I have access to DB server logs on this particular host.

Would you know if EP Advanced has the debugging and logging tools that might assist?

Any server confguration settings that I should investigate which might apply to my issue?

22 Aug 2006, 2:06 PM
#280
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,512
Plugin Contributions:
176

Re: Easy Populate 1.2.5.4 support

Woody,

If you download a fresh TXT file from EP for your products, then delete all but 5 records, edit their descriptions, and then re-upload to test whether their descriptions get updated, what happens?

Also, what tools are you using to do your edits?

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.