Easy Populate 1.2.5.4 support

maxim

Did you try using the temp dir to generate the txt file into to download from and then upload the txt file to it and insert into db from it?

francesca_ph :- Look at your error message it tells you your problem...
You haven't /home/musicalv/public_html/o-bean.com/admin/easypopulate.php installed on the server. Also you would need to create a /temp folder on your server with permissions correctly set, read the readme file...

maxim : - have you tried to download a complete file and open, changed some detail and re upload to the server to see if this works, as usual errors are in file format, this is always a good test to see if everything works OK.

Dear Anguz and Scrat:

This newbie isn't quite advanced enough to understand all of your guidance, but I think I have discovered the problem based on trying to do what both of you suggested.

The file that I am trying to insert is listed in the temp directory as the following file type: ASCII text, with CRLF line terminators; whereas files that I have generated to the temp directory are listed as ASCII text files (only).

I've tried cutting and pasting the data into one of the generated files, but I still get the CRLF line terminator format.

Any ideas?

Newbie :wacko: Linda

maxim : Don't know anything about SSH, but after goolging I found this quote:

This is because SSH
# servers seem to treat CRLF as two line-ends.

FTP and SFTP clients will often have an option to send files as
ASCII/BINARY/AUTO. This option controls how CRLF is handled when
encountered in the source file. This option has nothing at all to do with
the FTP/SFTP protocol itself; but is an option often included in client
software.

Basically you need to SFTP your file in ASCII not BINARY so you should have setting in your FTP software to send .txt files as ASCII.

Hope that helps ?

:frusty:
hi all zenners, I am very newer at this and may ask questions that seems stupid, but please help. So far, I have been able to successfully install and configure zen all by just reading up on the support post. After spending hours and days trying to figure out this "Easy-Populate" module, I got say, its not so "easy". Guess i just don't know where to look and the right questions to ask. I am able to sucessfully install it, but don't know how to use it. If there is anyone out there that willing to show me step by step. Much appreciated. Hope I not asking too much. thankshttp://www.chopstickrestaurant.com/zen

[QUOTE=Scrat;581855]francesca_ph :- Look at your error message it tells you your problem...
You haven't /home/musicalv/public_html/o-bean.com/admin/easypopulate.php installed on the server. Also you would need to create a /temp folder on your server with permissions correctly set, read the readme file...

hi scrat,

i already have it installed......all the files r in it

Warning: file(/home/musicalv/public_html/o-bean.com/temp/temp/) [function.file]: failed to open stream: No such file or directory in /home/musicalv/public_html/o-bean.com/admin/easypopulate.php on line 1223

Warning: Invalid argument supplied for foreach() in /home/musicalv/public_html/o-bean.com/admin/easypopulate.php on line 1301

francesca_ph : PHP gives you error messages as above if you read the error it is saying that it cannot find the easypopulate.php file, so I would check that all your files are in the right folders first. Strange thing you seem to have two temp folders one inside the other > home/musicalv/public_html/o-bean.com/temp/temp/

I would start again, ftp all the files again to make sure you have them all in the right folders, check that you have the /temp folder in the right directory and then import/export a test file.(Also the right permissions especially the temp folder!)

winwallc : Easyiest way download a complete tab file and it should be pretty straight forward how it works, then add a product to that file and upload it via EP.

Hi hi,

i only get the error msg when i try to upload a file in EP. eg, i download the 'full', edit in excel, save as .txt and upload it again

then when i 'insert into db', i get the error msg....

francesca_ph :
Have you reinstalled the files ?
You had so much problems setting this up putting the files in the right folder, I can only think a file is corrupted or in the wrong folder ?
As I stated, start again, delete the EP files off the server first , and reinstall.
EP just works if you have it set up correctly.

i juz updated the file and uploaded it.
it says upload successful and shows all the items being updated
but when i refresh my store, it does not show anything at all

i have included product model (tho i do not know what is that for), item name, qty, statues, brand, AND PUT ALL 'EOREOR' (also do not know what is dat)

francesca_ph : First of all ZC needs some products already in the database for EP to work, so enter one or two products in via ZC not EP.
Secondly EP will only work if you have a model ref this is unique to that product you CANNOT have duplicate model ref's or EP .

:frusty:
Like the gentleman who seems frustrated by not being able to see anything when using EP to upload product - I am having the same issue.

My file is in excel, but is a tab delimited text file - what I did, to be sure that I used the same contextual file as EP uses, is that I first downloaded the current prod/price/category file and deleted all the previous content, leaving the heading in-tact.

I then formatted my content to fit in the proper columns and uploaded the file. It tells me the upload was successful and I go to look in the specific category, but there is nothing. So I thought perhaps that I needed to Import from Temp Dir (temp/) so, copy and pasting the temp file name into the import section - it tells me that the import was successful, but again, nothing is there.

I did read something about htaccess and global settings set to on - but mine is already set so...I'm not sure where to turn. I read the "readme.txt" file, but I am finding nothing useful to help me with this issue.

I have no other specifics that I can give on this issue as there are no warnings, errors or anything other than it stating it was successful and below that a list of all that was supposed to have been uploaded.

Would it be helpful to reinstall this mod, overwriting the old, or does someone have some information that may help me with this issue? Any help would be extremely appreciated.

Thanks in advance,

When you are preparing your .csv file for upload, what is the best way to add the line breaks in the descriptions if you have thousands of products?

I think that would be in your EP Configuration in the admin - from what I have read.

This is what I see under the smart tags:

Smart Tags Replacement of Newlines

Allows your description fields in your uploads file to have carriage returns and/or new-lines converted to HTML line-breaks on uploading, thus preserving some rudimentary formatting (default: true).

But then I am a newbie so don't quote me on this - someone else may have a better answer - but thought it just might be something to look into.

Hi,

I am having the same problems as others:

I am using EP_v2_76g_MS2 with Zen Cart v1.3.8a/v1.3.8

When I import, I get the follwing report:

emporary filename: D:\apache2triad\temp\php23.tmp
User filename: zencart.txt
Size: 14326
| B1702S-B2 | | Iiyama PLB | 0 | 0 | 12.00 | | Monitors | | | !New Product!

| B1702S-W2 | | Iiyama PLB | 0 | 0 | 6.00 | | Monitors | | | !New Product!

| B1902S-B1 | | Iiyama PLB | 0 | 0 | 15.00 | | Monitors | | | !New Product!

| B1902S-W1 | | Iiyama PLB | 0 | 0 | 11.00 | | Monitors | | | !New Product!

from my source file zencart.txt

v_products_model,v_status,v_products_name_1,v_products_price,v_products_priced_by_attribute,v_products_quantity,v_manufacturers_name,v_categories_name_1,v_categories_name_2,v_categories_name_3,v_categories_name_4,EOREOR
B1702S-B2,,Iiyama PLB1702S-B2 17 Inch LCD-Black,0,0,12.00,,Monitors,,,,EOREOR
B1702S-W2,,Iiyama PLB1702S-W2 17 Inch LCD-White,0,0,6.00,,Monitors,,,,EOREOR
B1902S-B1,,Iiyama PLB1902S-B1S 19 Inch TFTLCD Black,0,0,15.00,,Monitors,,,,EOREOR
B1902S-W1,,Iiyama PLB1902S-W1S 19 Inch TFTLCD White,0,0,11.00,,Monitors,,,,EOREOR

EP reports that it has imported OK but it does not show up in the product list....

However... it WILL update an existing product if it is already in the DB using this method.

What can i possibly be doing wrong?

mentor : Use a better version, hence the thread title > " Easy Populate support for Version 1.2.5.4 " ** NOT Version :-EP_v2_76g_MS2**
As far as I can tell all the versions in the downloads are buggy, version 1.2.5.4 from modhole is the best and proven :yes: search this thread for the address see no.1 reply in this thread in Langer signature.

SaMortensen : Have you got products in ZC already as ZC does not accept EP imports otherwise. If so edit the present data and upload and see if that works, 9 times out of 10 it will be your file format which is wrong. Also check your version => Version 1.2.5.4 is the one to use...

Scrat:

francesca_ph : First of all ZC needs some products already in the database for EP to work, so enter one or two products in via ZC not EP.
Secondly EP will only work if you have a model ref this is unique to that product you CANNOT have duplicate model ref's or EP .

dear Scrat,

ZC already have products in it. its the demo. i haven deleted them as I need the various examples as guides.

Mine is a pet food store, therefore under 'model' i cannot have the same word like 'treats' 'kibbles' 'toys' ? coz under the demo, which i opened, it has 4products 'normal' and 2 products 'special'. only 1 was sucessfully uploaded. i.e. the 1st one.

also what do you mean by duplicate EP? meaning i can only have 1 file in the temp dir?

and what is 'EOREOR' ?

francesca_ph : You have to have a unique model reference which is the first field in all the file .csv download files.

v_products_model

So product1, product2, product3 etc etc

Otherwise EP cannot find the product to insert/update/delete

If you download a complete file it will show you an example from the sample data.

Scrat:

francesca_ph : You have to have a unique model reference which is the first field in all the file .csv download files.

So product1, product2, product3 etc etc

Otherwise EP cannot find the product to insert/update/delete

If you download a complete file it will show you an example from the sample data.

ok, so is dis field compulsory? i did read the sample, that's why i mentioned i saw the same product model and it was actually updated well in zc...wierd?

Scrat:

SaMortensen : Have you got products in ZC already as ZC does not accept EP imports otherwise. If so edit the present data and upload and see if that works, 9 times out of 10 it will be your file format which is wrong. Also check your version => Version 1.2.5.4 is the one to use...

Yes, I already have products in ZC - Store has been in operation for two years now - been using ZC since January.

Also, I am using version 1.2.5.4

I'm not sure what you mean by editing my present data - can you explain?
Attachment #4224
I have attached one of the files I have been importing for reference - also a screen shot if you prefer that format:

please tell me what I need to do to edit this file.

Thanks!