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 241 to 260 of 3,834
13 Aug 2006, 11:12 PM
#241
langer avatar

langer

Totally Zenned

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

Easy Populate 1.2.5.4 support

ericpeng:

Got problem after upload.
It seems it's caused by line feed(\n) has been replaced to <br /> aftre upload.

  1. Firefox - copy
  2. dreamweaver - paste
  3. copy the code, copy to excel
  4. save as tab delimited text file
<table cellspacing="0" cellpadding="0"> <tr> <td><table border="0" cellpadding="0" cellspacing="0" width="100%"> <tbody> <tr> <td valign="top"><img src="http://usa.asus.com/999/images/products/768/b.gif" border="0" height="23" width="16"></td> <td>Quality K8 939 Solution with Leading Features All on 1 Board</td> </tr> </tbody> </table>

Anyway can avoid the problem.
Thanks

This is the smart tag option in EP config: Admin -> Config -> Easy Populate

14 Aug 2006, 6:19 PM
#242
cbo avatar

cbo

New Zenner

Join Date:
Feb 2006
Location:
colorado
Posts:
73
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

Maybe I've missed it someplace and I opologise if I have but are there any detailed instructions on how to use Easy Populate?
I know that fromt he readme that if you set the v_status to 9 it deletes the product. What about the catagory? After testing teh v_status 9 I noticed that the products were gone but the catagory and sub catagories are still present. How are those deleted?

Details on how to use the file would be of great help:)

Thanks

14 Aug 2006, 7:18 PM
#243
apinkpony11 avatar

apinkpony11

Zen Follower

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

Re: Easy Populate 1.2.5.4 support

Hi Guys.

Every time i try to update my items with easy populate, i get duplicate items! (Perticularly if i try to change categories). Is there a way to avoid getting duplicate items?

Also, now that i have 6000 items that have been duplicated, is there a way to delete them, without doing it one by one?

This is perticularly frusterating.

15 Aug 2006, 12:20 AM
#244
apinkpony11 avatar

apinkpony11

Zen Follower

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

Re: Easy Populate 1.2.5.4 support

Anyone? There has got to be a way.

15 Aug 2006, 1:20 AM
#245
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

you cannot delete categories with Easy Populate.

The default behaviour for Easy Populate when an existing product is found and a new category specified is to create a linked product. You must 1st delete the product and then upload it to any new category.

Delete each product with v_status = 9.

15 Aug 2006, 4:42 AM
#246
drbyte avatar

drbyte

Sensei

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

Re: Easy Populate 1.2.5.4 support

langer:

Delete each product with v_status = 9.
I didn't understand this statement...

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

15 Aug 2006, 5:14 AM
#247
woodymon avatar

woodymon

Totally Zenned

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

Re: Easy Populate 1.2.5.4 support

DrByte:

I didn't understand this statement...

As Langer suggested in post #89 of this thread... ;-)

To delete products, use v_status = 9 for each product. This is explained in the readme.txt and the install.txt...

15 Aug 2006, 9:18 AM
#248
drbyte avatar

drbyte

Sensei

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

Re: Easy Populate 1.2.5.4 support

Oops -- caught me skipping a few posts and a readme ... :ohmy:

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

15 Aug 2006, 7:00 PM
#249
jensderknipser avatar

jensderknipser

New Zenner

Join Date:
Mar 2006
Location:
munich
Posts:
34
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

sorry everybody, luckily working on EP, to bother you with this:

I am hardly trying to get ep 1.2.5.4 running, but neither on a fresh 1.3.01 nor in an fresh 1.3.0.2 install the installer is willing to do his job. In both versions this error is prompted:

1136 Column count doesn't match value count at row 1

So this was my troubleshooting up to now:
Downloaded a "virgin" copy from the modhole, just to see, if maybe some files were not correct;

Tried to install on a fresh copy of 1.3.1, just to see, if maybe the database-structure could handle the sql-stetment different;

Reinstalled the fresh ep on a fresh 132, again to check, if all files are correct;

Results see above. Does anybody can give me an Idea about what I am doing wrong?????

Thanks to all

15 Aug 2006, 10:45 PM
#250
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

this results from a modified configuration table. Have you added a module that has altered this table?

To overcome this, you will need to change the sql code text file to match the database schema of your modified store, and use the sql patch tool in Zen Cart admin to install it.

18 Aug 2006, 12:27 AM
#251
llamagod avatar

llamagod

New Zenner

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

Re: Easy Populate 1.2.5.4 support

i'm running into an interesting situation - i'm able to upload all product and i'm a HUGE fan of easy populate - used it in osCommerce and now i'm moving up in the world to zen cart! 'priciate all the hard work langer

NEway, to the issue at hand, when i upload the spreadsheet, i get all my products, however, i have manufacturers for some products but not all - the products i leave empty are somehow acquiring a manufacturer from (i believe) the previously added product that DOES have a manufacturer. an exerpt from a fresh upload (after removing all products using v_status=9):

NEW PRODUCT! - Model: 90000 | 90000.gif | Essential | We're spil | 15.95 | | 8/11/2006 | 0 | Gifts | | Taxible Go | 1 |
NEW PRODUCT! - Model: 120000 | 120000.gif | SportDog™ | Blaze oran | 219.95** | SportDog |** 8/11/2006 | 0 | Dog Produc | Training A | Taxible Go | 1 |
NEW PRODUCT! - Model: 250000 | 250000.gif | Dale Spart | Page after | 66.95 | | 8/11/2006 | 0 | Gifts | | Taxible Go | 1 |

these three items are the first three items in my spreadsheet. model 90000 is fine, the manufacturer is blank (which is good). the second item (model 120000) has a manufacturer 'SportDog' (which is good). the third item (model 250000) show's here no manufacturer (which is good) - however checking the item (250000) in my store, the listing has 'SportDog' as the manufacturer (which is NOT good). i'm lead to believe that this is due to a bug where all the fields are not cleared before the next SQL statement is executed (in particular the v_manufacturers_name field).

am i the only one who's run across this scenario? i've perused /admin/easypopulate.php and i'm looking between lines 1765 and 1802 of v1.2.5.4 - the IF statement that converts the manufacturer's name to the ID and the only place where the $v_manufacturers_name variable is used. i see that there is no ELSE statement to handle the case where $v_manufacturers_name==''.

the obvious workaround would be to put the items that do not have a manufacturer at the top of the spreadsheet, so there would be nothing to replace the nothing that is listed. but this is just another step, that could be easily forgotten.

a heads up to you langer, right now i do not have time to work on that ELSE or perhaps an ELSEIF... but if you might know of what i'm speaking and might be able to turn around a quick fix for this, that'd be most excellent.

again, love the plugin! and thanks for all the hard work!

18 Aug 2006, 7:34 AM
#252
jensderknipser avatar

jensderknipser

New Zenner

Join Date:
Mar 2006
Location:
munich
Posts:
34
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

langer:

this results from a modified configuration table. Have you added a module that has altered this table?

To overcome this, you will need to change the sql code text file to match the database schema of your modified store, and use the sql patch tool in Zen Cart admin to install it.

Yep, thanks for this Idea, and indeed, as I am running my installation multilangual I had to add the language-table into the code. It now reads as follows:

INSERT INTO configuration_group VALUES ('','43', 'Easy Populate', 'Config options for Easy Populate', '1', '1');

see the '43' in it. This way it's working fine now. Thank you!

jens

19 Aug 2006, 11:05 AM
#253
woodymon avatar

woodymon

Totally Zenned

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

Re: Easy Populate 1.2.5.4 support

I set up one product in Zen cart 1.3.0.2 then via EP 1.2.5.4 downloaded a "complete file" to edit.

Then I added 12 sample items to the file (some in the same categories and some in different categories) and exported as tab-delimited text and uploaded from client via EP.

EP Upload results displayed NEW PRODUCT! at beginning of each line and no errors reported (besides the next to the last line "no model field in record" which means end-of-file, so not an error). Then last line showed "Upload Complete".

And then when I checked the shop Catalog side I can see the new categories were created and numbers besides each primary category correctly indicate subcategories. However when I drill down thru the subcategories to an expected product listing, no products are displayed.

And similar within admin. New categories and subcategories display correctly. And on the lowest level subcategory listing, products are indicated as contained in the sub category (e.g. "Quantity 3 of 3 active" is displayed). But when opening the subcategory no products are listed.

I'm stumped. Any ideas? Thanks.
Woody

19 Aug 2006, 12:45 PM
#254
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

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

19 Aug 2006, 6:55 PM
#255
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?
Hi Langer, Not sure if you are replying to my query. I think so.
No changes to the DB. The products I entered via Zen Cart admin are displaying just fine. But not the products I uploaded via EP.

Some of the products I uploaded purposely have the question mark in the model field and have HTML in the description field (but not all). And I have left some of the fields blank (inlcuding images) but all model, name and description fields contain data. v_status is set to 1 for all products.

I assume the above is ok.

My previous test upload went fine after my host staightened out mod_security issues. And not seeing similar errors now. Products just are not showing up.

Woody

19 Aug 2006, 7:13 PM
#256
wtashby avatar

wtashby

Totally Zenned

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

Re: Easy Populate 1.2.5.4 support

i just tried to install ep 3.0.2 and when I click on easypopulate in admin->tools, all I get is a blank page. What's up with that?

Thanks,

Tom

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

19 Aug 2006, 7:38 PM
#257
wtashby avatar

wtashby

Totally Zenned

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

Re: Easy Populate 1.2.5.4 support

Ok, I got the blank page fixed, and ep is trying to work, except now, I get the following when I try to upload a file:

Progress: >
Warning: fopen(/hsphere/local/home/wtashby/theashbymint.com/uploads/NFL): failed to open stream: No such file or directory in /hsphere/local/home/wtashby/theashbymint.com/admin/includes/easypopulate/classes/eclipse/FileIterator.php on line 146

Warning: fgets(): supplied argument is not a valid stream resource in /hsphere/local/home/wtashby/theashbymint.com/admin/includes/easypopulate/classes/eclipse/FileIterator.php on line 132
Warning File Import Failed! Primary index column v_products_model missing from uploads file. Please consult the readme.html file for more information

I do have v_products_model in the first column. In fact, it's a file I've succesfully uploaded with the earlier versions of ep.

Help!:shocking:

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

19 Aug 2006, 8:03 PM
#258
wtashby avatar

wtashby

Totally Zenned

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

Re: Easy Populate 1.2.5.4 support

Also, when I try to import a file directly after browsing for it by clicking the import button, I also get:

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

Somebody please throw me a lifeline here, this is killing me.:no: :wacko: :cry:

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

19 Aug 2006, 8:10 PM
#259
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

Can anyone help please .. I have added over 1700 products using EP. everything was brill .. i did the customisation and got the rest of the site done .. then i downloaded a full sheet with the details in and made a start on the descriptions .. but they are not showing at all .. please can someone help .. i cant stand the thought of having to enter 1714 descriptions manually lol

Erica xx

incase you need to see it, the site is https://www.costumejewelleryaccessories.co.uk .. please be aware that there is adult products on there.

19 Aug 2006, 8:26 PM
#260
drbyte avatar

drbyte

Sensei

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

Re: Easy Populate 1.2.5.4 support

wtashby:

I do have v_products_model in the first column. In fact, it's a file I've succesfully uploaded with the earlier versions of ep.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?

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