Easy Populate 1.2.5.4 support

[spikebuck77]

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?

[SaMortensen]

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.

[mentor]

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_b y_attribute,v_products_quantity,v_manufacturers_name,v_categories_name_1,v_categ ories_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?

[Scrat]

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

[francesca_ph]

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' ?

[Scrat]

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.

[francesca_ph]

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?

[SaMortensen]

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?
bracelets.txt
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!

[Scrat]

SaMortensen
Two Very Import Fields : -

v_status EOREOR

You need in v_status either : 1 = new import or 9 = Delete this product and every line/row must have " EOREOR " at the end.

[rickiesdiscount]

I tried to upload files today using easy populate v1.2.5.4 .....i was trying to update my first half of my files with the produtcts url's and then I upload some new files...well...i kept getting this error

and the only thing i added was the manufacturers url to my product information that shouldnt have messed it up should it?

This is the error i kept on getting:

<!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML 2.0//EN">
<html><head>
<title>500 Internal Server Error</title>
</head><body>
<h1>Internal Server Error</h1>
<p>The server encountered an internal error or
misconfiguration and was unable to complete
your request.</p>
<p>Please contact the server administrator,
[email protected] and inform them of the time the error occurred,
and anything you might have done that may have
caused the error.</p>
<p>More information about this error may be available
in the server error log.</p>
</body></html>


Then after i tried to upload my files so many times i got this error:

1226 User 'u70568462' has exceeded the 'max_questions' resource (current value: 50000)
in:
[select value from sessions where sesskey = 'ba0414ffc29cc39d6fa5871e0407183b' and expiry > '1216072998']
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.


I know what the second error is....its because i had to many products/attributes uploaded at one time and the server cannot handle it....

But the first error (internal server error) i have no idea whats going on that has never happened before.


I know i have it set up right to because the other day i uploaded 1299 items with no problem.....

Could this be a problem with my hosting?
I have netfirms right now