Easy Populate 1.2.5.4 support

gerhard59 ; see the first reply in this thread in Langers signature for the download from Langers Modhole if you downloaded from the ZC download area Yes you have a buggy version.

Scrat:

gerhard59 ; see the first reply in this thread in Langers signature for the download from Langers Modhole if you downloaded from the ZC download area Yes you have a buggy version.

oh.. why don't you upload a NON buggy version on zen-cart? thats a bit miss leading no??

where i cant find this download link anywhere??

only one i can find is:

ftp://portability.dnsalias.com/EP_v1.2.5.1.zip

which don't seem to be working....

never mind

http://www.modhole.com/modhole/index.php?module=documents&JAS_DocumentManager_op=viewDocument&JAS_Document_id=2

found it

ok.

everything seems to work perfectly..

:clap:

apart from :lamo:

under tools i have

BOX_TOOLS_POPULATE

instead of the easy populate link.. and when i click it, it links me too:

admin/FILENAME_POPULATE.php

right im sorry to add another reply..

I believe the above error is there because I'd already installed easy populate, and still have the old link there, which links to it fine. so i'll just have to edit the other one out on the menu, whats the file to do this?

i have just done the exact same thing with my other shop and its gone crazy :huh:

i get all this code in the admin section, at the top.. and cant stop it.

[quote=gerhard59;585680]Just started a webshop and added some items manually, exported the list to get the right EP format.
I added the rest of the products and try to import this file.
Record format is correct but I get message "No products_id field in record. This line was not imported" and no products are imported.
record format starts with
"19-10pdu samples/19-8pdu.jpg 19-10pdu powerstrip....etc"
In this case 19-10pdu is a unique identifier connected with v_products_model
The manually added products do get updated whenever I import the file but no new items are added. Images are already downloaded to server.
I use Zencart version 1.3.8 and latest version of easypopulate.
quote]

I have the exact same problem and I have EPA. I entered products without the description manually into zen cart, saved the file, added the description into the file and imported it back into zencart. All I get is the following error message:

Product Import Results
SKIPPED! - Product Index: - no such current category path for this existing product.
SKIPPED! - Product Index: - no such current category path for this existing product.
SKIPPED! - Product Index: - no such current category path for this existing product.
SKIPPED! - Product Index: - no such current category path for this existing product.
SKIPPED! - Product Index: - no such current category path for this existing product.
SKIPPED! - Product Index: - no such current category path for this existing product.
SKIPPED! - Product Index: - no such current category path for this existing product.
SKIPPED! - Product Index: - no such current category path for this existing product.
SKIPPED! - Product Index: - no such current category path for this existing product.
SKIPPED! - Product Index: - no such current category path for this existing product.
SKIPPED! - Product Index: - no such current category path for this existing product.
SKIPPED! - Product Index: - no such current category path for this existing product.
SKIPPED! - Product Index: - no such current category path for this existing product.
SKIPPED! - Product Index: - no such current category path for this existing product.
SKIPPED! - Product Index: - no such current category path for this existing product.
Invalid index (products_model) in upload file - This line was not imported - Product - | catalog/2_ | Ergo Diape | | | | | | 60 | 0 | | 18/07/2008 | 0 | Ergo Baby | Sales & Cl | | | Taxable Go | 1 |

I really really want to be able to use EP but so far it hasn't been very successful.

Please help

Erin

https://www.momandbabyboutique.ca/servlet

Thnx, I have downloaded the right version now and decided to start from scratch. My store was still in the making and not yet open to the public.
I will keep you posted about my progress with ZC 1.3.8 and EP1.2.5.4

Sc0rian : Firstly, its not my mod to place in the downloads area, that would be up to Langer as it is his port from OSC. If you think its misleading then contact a Moderator re the uploads section, I have contacted them to rename this thread so it is for Version 1.2.5.4 to avoid confusion regarding versions to try to help people, as I feel the download section is there for people to post fix's if a mod improvement does not work, as this is a community add-on not a ZC feature.

Secondly to me it looks as you have conflict with your first EP install and your second install of version 1.2.5.4, so you must still have some files installed ?

erinl : Contact Langer as EPA is a commercial product and he does support his product on his website via his forum (and email I think).

Scrat: I'll post my question to Langer - thanks for responding!

Erin

thanks for your reply scrat.

I deleted my whole admin folder and tried uploading a fresh one and tried uploading the workin one out of my other shop. both didnt work..

Progress on installation and Easy Populate.:smartalec:
I reinstalled zen cart and easy populate this morning and started testing with my product files. One thing I noticed was EP under Tools was different then before, which was good in my opinion.
Importing still did not work properly. Although all neccesary folders had write access according to dreamweaver (I use DW for other websites and uploading) it turned out this was not true.:frusty:
After applying the proper rights on the neccesary folders the import is working perfectly.:clap:
According to screen it looks like EP is using a different folder for temp.
Whole thing is working like a charm now.:bigups:

Now it's time to start sales.

I need Easy Populate 1.2.5.4 to modify the maximum quantity field. I can’t afford the $65 version and I don’t need the other features – I just need maximum quanties. I have tried all I can to get it to work, but it doesn’t. If there is a PHP expert than can give me a tip to get it to work then I would be grateful.

Below I describe what I have tried.

I tried to follow the instructions posted by awev in post #950, but I think his instructions only work for variables stored in TABLE_PRODUCTS_DESCRIPTION.
I believe that max quantity is in the TABLE_PRODUCTS and named products_quantity_order_max.

I tried to modify his method by searching for every instance of “quantity” When I found anything referring to products_quantity I added a line below it and replaced products_quantity with products_quantity_order_max. While I think that is straight forward, it doesn’t work. I get an SQL error. In Admin the message “An SQL error has occured. Please check your input data for tabs within fields and delete these. If this error continues, please forward your error log to the Easy Populate maintainer” is displayed.

Below is what is in the ep_dubug_log

MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '13651")' at line 3
When executing:
UPDATE products
SET
products_price="0.50" ,products_image="Eventid_Batwing_Brume.jpg", products_weight="0.004", products_tax_class_id="1", products_date_available= NULL, products_date_added= "2008-07-25 10:35", products_last_modified=CURRENT_TIMESTAMP, products_quantity="560, products_quantity_order_max="" ,manufacturers_id=7 , products_status=1
WHERE
(products_id = "13651")

The exact steps I took are below: The bold lines are what I added.

Line 392

'v_date_added'      => $iii++,
'v_products_quantity'   => $iii++,

** 'v_products_quantity_order_max' => $iii++,**

line 460

p.products_tax_class_id as v_tax_class_id,
p.products_quantity as v_products_quantity,
**p.products_quantity_order_max as v_products_quantity_order_max,**

line 485

'v_products_price'    => $iii++,
'v_products_quantity'   => $iii++,

** 'v_products_quantity_order_max' => $iii++,**

line 500

p.products_tax_class_id as v_tax_class_id,
p.products_quantity as v_products_quantity

** p.products_quantity_order_max as v_products_quantity_order_max**

line 607

p.products_tax_class_id as v_tax_class_id,
p.products_quantity as v_products_quantity,
**p.products_quantity_order_max as v_products_quantity_order_max,**

line 1290

'v_products_price',
'v_products_quantity',
**'v_products_quantity_order_max',

**
line 1444

p.products_tax_class_id as v_tax_class_id,
p.products_quantity as v_products_quantity,
**p.products_quantity_order_max as v_products_quantity_order_max,**

line 1919

products_weight,
products_quantity,
**products_quantity_order_max,

**
line 1933

'".zen_db_input($v_products_weight)."',
'".zen_db_input($v_products_quantity)."',
**'".zen_db_input($v_products_quantity_order_max)."',

**
line 1970

', products_last_modified=CURRENT_TIMESTAMP' .
', products_quantity="' . zen_db_input($v_products_quantity) .  
**', products_quantity_order_max="' . $v_products_quantity_order_max .

**
Any ideas what is wrong?

[QUOTE=erinl;586336]> gerhard59:

Just started a webshop and added some items manually, exported the list to get the right EP format.
I added the rest of the products and try to import this file.
Record format is correct but I get message "No products_id field in record. This line was not imported" and no products are imported.
record format starts with
"19-10pdu samples/19-8pdu.jpg 19-10pdu powerstrip....etc"
In this case 19-10pdu is a unique identifier connected with v_products_model
The manually added products do get updated whenever I import the file but no new items are added. Images are already downloaded to server.
I use Zencart version 1.3.8 and latest version of easypopulate.
quote]

I have the exact same problem and I have EPA. I entered products without the description manually into zen cart, saved the file, added the description into the file and imported it back into zencart. All I get is the following error message:

Product Import Results
SKIPPED! - Product Index: - no such current category path for this existing product.
SKIPPED! - Product Index: - no such current category path for this existing product.
SKIPPED! - Product Index: - no such current category path for this existing product.
SKIPPED! - Product Index: - no such current category path for this existing product.
SKIPPED! - Product Index: - no such current category path for this existing product.
SKIPPED! - Product Index: - no such current category path for this existing product.
SKIPPED! - Product Index: - no such current category path for this existing product.
SKIPPED! - Product Index: - no such current category path for this existing product.
SKIPPED! - Product Index: - no such current category path for this existing product.
SKIPPED! - Product Index: - no such current category path for this existing product.
SKIPPED! - Product Index: - no such current category path for this existing product.
SKIPPED! - Product Index: - no such current category path for this existing product.
SKIPPED! - Product Index: - no such current category path for this existing product.
SKIPPED! - Product Index: - no such current category path for this existing product.
SKIPPED! - Product Index: - no such current category path for this existing product.
Invalid index (products_model) in upload file - This line was not imported - Product - | catalog/2_ | Ergo Diape | | | | | | 60 | 0 | | 18/07/2008 | 0 | Ergo Baby | Sales & Cl | | | Taxable Go | 1 |

I really really want to be able to use EP but so far it hasn't been very successful.

Please help

Erin

https://www.momandbabyboutique.ca/servlet

If you have categories set up already, you MUST allocate a category (and relative sub-category in your EP file.

See the WIKI for an EP tutorial - search WIKI for Easy Populate.

can EP be also used for things like zones, co0untries, users database?

francesca_ph:

can EP be also used for things like zones, co0untries, users database?

Sadly not...

read install text file again and again spending over 24 hours, still cannot complete the installaion. need someone to help.

my easy populate version is: (1).2.5.4

1. i think i install the install_sql sucessfully. configuate / easy poplate , i saw this tab . i can have 10 option to config , like uploads directory.

2. but i think installation is not completed. tool/ there is nothing for easy populate.

• the admin folder - i renamed to "easy" and put it to zencart/admin/easy,
  i don't set any chmod for this easy folder
• the temp folder - i located either on zencart/temp or zencart/admin/temp,
  i also set this temp and all subdirectory to 700.
• there are 4 text file, (history, read me, licence , install) , i think it is not necessary for installation.

on brower, when i typed
http: //www.my.com/zencart/admin/easypopulate.php?langer=install

got 404

please help to direct me where is the problem.

thank you.

???

• the admin folder - i renamed to "easy" and put it to zencart/admin/easy,***

Why did you do this?

All you need to do is FTP two folders to the root install of your ZC.

admin

and

temp

fairestcape:

???

---

• the admin folder - i renamed to "easy" and put it to zencart/admin/easy,***

Why did you do this?

All you need to do is FTP two folders to the root install of your ZC.

admin

and

temp

this is because:

there was already a admin folder existed . zencart/admin is the folder comes from zencart.

easy poplute comes with admin and temp folder.

if i ftp ep admin to zencart directory, it will overwrite the zencart/admin . so this is the reason why i rename ep admin to ep easy.

then ep admin, where should i ftp?
if to zencart/ - i will overwrite everything for zencart orignal admin folder .

please help

thank you.

colour97:

this is because:

there was already a admin folder existed . zencart/admin is the folder comes from zencart.

easy poplute comes with admin and temp folder.

if i ftp ep admin to zencart directory, it will overwrite the zencart/admin . so this is the reason why i rename ep admin to ep easy.

then ep admin, where should i ftp?
if to zencart/ - i will overwrite everything for zencart orignal admin folder .

please help

thank you.

hi finally , i got it work. now i understand i have wrong concept of same admin folder. and details of admin is totally different from zencart admin folder.

thank again for your help

Folders do not overwrite folders. All you need do is this

In your FTP program you will have two panes:

1. is for your local machine
2. is for your remote machine (server)

In your local machine pane you will see:-

admin
temp

(and some txt files that DO NOT get ftp'd)

Highlight both folders and click the arrow (or drag and drop) to send them to your remote machine (server)

The server will see the folders and say:

"Ah... here comes some files and they must go in the ADMIN FOLDER... I already have a admin folder, so I'll just bring in the files..."

(and they get put in the admin folder)

Then, your server says:

"Ah... here comes a folder called temp, and as I don't have a folder called temp yet, I will create one and put all the files from temp on the local drive, into the temp folder I just created."

Naturally, if there are ADDITIONAL folders in the admin and temp on your LOCAL machine, the server will simply create them if they don't already exist, or if they DO exist, will take the contents only.

fairestcape:

Folders do not overwrite folders. All you need do is this

In your FTP program you will have two panes:

1. is for your local machine
2. is for your remote machine (server)

In your local machine pane you will see:-

admin
temp

(and some txt files that DO NOT get ftp'd)

Highlight both folders and click the arrow (or drag and drop) to send them to your remote machine (server)

The server will see the folders and say:

"Ah... here comes some files and they must go in the ADMIN FOLDER... I already have a admin folder, so I'll just bring in the files..."

(and they get put in the admin folder)

Then, your server says:

"Ah... here comes a folder called temp, and as I don't have a folder called temp yet, I will create one and put all the files from temp on the local drive, into the temp folder I just created."

---

Naturally, if there are ADDITIONAL folders in the admin and temp on your LOCAL machine, the server will simply create them if they don't already exist, or if they DO exist, will take the contents only.

thank you very much, now fully understand. this is the 1st time i have shopping cart experience, so far so good. thank again for your help.