EasyPopulate 4.0 Support Thread

[chadderuski]

creyesx6:

do you have a static ip for the site? if so, you can use the IP for the site rather than the http://server.domain.com/~cpanelusername/
shortcut. I HAVE seen issues with this before but don't remember how we fixed it. Using the IP has always worked for me though.

http://server.domain.com/~cpanelusername/ <<< there is a name for this, but I can't find it. It's like using a semaphore, but that's not right either. Anyone know??

-chadd

Hmm, interesting indeed. You should be able to ftp the file and put it in the directory used by/for EP4. Then perhaps the import will take. I would say though, that it is not an EP4 issue. Perhaps folder permissions maybe don't allow the transfer or still could be a configure.php issue. Typcially it is not suggested to install cia the cPanle, but instead. By ftp and then go to the webpage address to install, rename the admin folder and basically remove the install folder. This is not to say that install won't work that way, but there have been known to be problems.

There may be something else going on also related to the store's setup as to why you are taken back to the admin login while under this temporary setup. But as said, if. Able to ftp the file to the right place, try to import. (And yes since can't upload, all the rest about importing doesn't help from my previous message.)

What is the configuration otherwise? ZC version, php, etc.?

The ftp to the temp folder works! It still takes me to the login screen after importing but at least it imports. Since it's a temporary url, I can work with that to at least get the products on the site and then I will update the dns servers and the temporary url issue will be gone. Thanks for the suggestion![/QUOTE]

[ChrisUren]

I am using Zen Cart v1.5.1 (The latest one) and Easy Populate for v1.5.1.

I Downloaded Zen Cart today after finally losing patience with OpenCart, and have ran into trouble using easy populate. I would really appreciate some help from the community.

When I go to add my CSV File to the database, this error comes up

Upload Results

File uploaded.
Temporary filename: /customers/1/9/0/cheaponline############s.com/tmp/phpacB0j8
User filename: condoms.csv
Size: 24433

No model field in record. This line was not imported teat ende | made from |
No model field in record. This line was not imported teat ende | made from |
No model field in record. This line was not imported Coloured | Novelty;T |
No model field in record. This line was not imported Coloured | Novelty;T |
No model field in record. This line was not imported lubricate | Coloured | Novelty;T |
No model field in record. This line was not imported lubricate | Coloured | Novelty;T |
No model field in record. This line was not imported Coloured | Novelty;T |
No model field in record. This line was not imported Coloured | Novelty;T |
No model field in record. This line was not imported Coloured | Novelty;T |
No model field in record. This line was not imported Bubble Gu | Banana an | lubricate | Coloured | Novelty;T |
No model field in record. This line was not imported Coloured | Novelty;T |
No model field in record. This line was not imported for all r | they come | moisten t | seal | and let y | the bette | Coloured | Novelty;T |
No model field in record. This line was not imported Coloured | Novelty;T |
No model field in record. This line was not imported Bubble Gu | Banana an | lubricate | Coloured | Novelty;T |
No model field in record. This line was not imported Coloured | Novelty;T |
No model field in record. This line was not imported Coloured | Novelty;T |
No model field in record. This line was not imported teat ende | made from |
No model field in record. This line was not imported teat ende | made from |
No model field in record. This line was not imported teat ende | made from |
No model field in record. This line was not imported teat ende | made from |
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported tapered a | silky smo | special r | made from | individua |
No model field in record. This line was not imported as when i | size real | manufactu |
No model field in record. This line was not imported as when i | size real | manufactu |
No model field in record. This line was not imported
No model field in record. This line was not imported tell them | condoms c | A width o | however | come in m |
No model field in record. This line was not imported tell them | condoms c | A width o | however | come in m |
No model field in record. This line was not imported tell them | condoms c | A width o | however | come in m |
No model field in record. This line was not imported tell them | condoms c | A width o | however | come in m |
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported specially |
No model field in record. This line was not imported teat ende | made from |
No model field in record. This line was not imported teat ende | made from |
No model field in record. This line was not imported teat ende | made from |
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported Made from | teated en | Each cond |
No model field in record. This line was not imported
No model field in record. This line was not imported SKINS are | Skins nat | natural f |
No model field in record. This line was not imported the World | has put t | sensitive | and simpl |
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported SKINS are | Skins nat | natural f |
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported teat ende | made from | Ribbed | Warming;T |
No model field in record. This line was not imported warming a | Ribbed | Warming;T |
No model field in record. This line was not imported Ribbed | Warming;T |
No model field in record. This line was not imported Durex Per | Ribbed | Warming;T |
No model field in record. This line was not imported Ribbed | Warming;T |
No model field in record. This line was not imported Ribbed | Warming;T |
No model field in record. This line was not imported our studd | Ribbed | Warming;T |
No model field in record. This line was not imported Ribbed | Warming;T |
No model field in record. This line was not imported for extra | Ribbed | Warming;T |
No model field in record. This line was not imported Ribbed | Warming;T |
No model field in record. This line was not imported teat ende | made from |
No model field in record. This line was not imported 40percent |
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported
Upload Complete 

You can view the CSV File here, please just check this to see if I'm making any glaring errors - http://tinyurl.com/q5x58lr
(Please note, the CSV File contains adult goods, I Run an adult store so just be aware)

I am using windows 7 and Open Office Calc for the editing.

Any advice would be appreciated.

[mc12345678]

I am using Zen Cart v1.5.1 (The latest one) and Easy Populate for v1.5.1.

I Downloaded Zen Cart today after finally losing patience with OpenCart, and have ran into trouble using easy populate. I would really appreciate some help from the community.

When I go to add my CSV File to the database, this error comes up

Upload Results

File uploaded.
Temporary filename: /customers/1/9/0/cheaponline############s.com/tmp/phpacB0j8
User filename: condoms.csv
Size: 24433

No model field in record. This line was not imported teat ende | made from |
No model field in record. This line was not imported teat ende | made from |
No model field in record. This line was not imported Coloured | Novelty;T |
No model field in record. This line was not imported Coloured | Novelty;T |
No model field in record. This line was not imported lubricate | Coloured | Novelty;T |
No model field in record. This line was not imported lubricate | Coloured | Novelty;T |
No model field in record. This line was not imported Coloured | Novelty;T |
No model field in record. This line was not imported Coloured | Novelty;T |
No model field in record. This line was not imported Coloured | Novelty;T |
No model field in record. This line was not imported Bubble Gu | Banana an | lubricate | Coloured | Novelty;T |
No model field in record. This line was not imported Coloured | Novelty;T |
No model field in record. This line was not imported for all r | they come | moisten t | seal | and let y | the bette | Coloured | Novelty;T |
No model field in record. This line was not imported Coloured | Novelty;T |
No model field in record. This line was not imported Bubble Gu | Banana an | lubricate | Coloured | Novelty;T |
No model field in record. This line was not imported Coloured | Novelty;T |
No model field in record. This line was not imported Coloured | Novelty;T |
No model field in record. This line was not imported teat ende | made from |
No model field in record. This line was not imported teat ende | made from |
No model field in record. This line was not imported teat ende | made from |
No model field in record. This line was not imported teat ende | made from |
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported tapered a | silky smo | special r | made from | individua |
No model field in record. This line was not imported as when i | size real | manufactu |
No model field in record. This line was not imported as when i | size real | manufactu |
No model field in record. This line was not imported
No model field in record. This line was not imported tell them | condoms c | A width o | however | come in m |
No model field in record. This line was not imported tell them | condoms c | A width o | however | come in m |
No model field in record. This line was not imported tell them | condoms c | A width o | however | come in m |
No model field in record. This line was not imported tell them | condoms c | A width o | however | come in m |
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported specially |
No model field in record. This line was not imported teat ende | made from |
No model field in record. This line was not imported teat ende | made from |
No model field in record. This line was not imported teat ende | made from |
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported Made from | teated en | Each cond |
No model field in record. This line was not imported
No model field in record. This line was not imported SKINS are | Skins nat | natural f |
No model field in record. This line was not imported the World | has put t | sensitive | and simpl |
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported SKINS are | Skins nat | natural f |
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported teat ende | made from | Ribbed | Warming;T |
No model field in record. This line was not imported warming a | Ribbed | Warming;T |
No model field in record. This line was not imported Ribbed | Warming;T |
No model field in record. This line was not imported Durex Per | Ribbed | Warming;T |
No model field in record. This line was not imported Ribbed | Warming;T |
No model field in record. This line was not imported Ribbed | Warming;T |
No model field in record. This line was not imported our studd | Ribbed | Warming;T |
No model field in record. This line was not imported Ribbed | Warming;T |
No model field in record. This line was not imported for extra | Ribbed | Warming;T |
No model field in record. This line was not imported Ribbed | Warming;T |
No model field in record. This line was not imported teat ende | made from |
No model field in record. This line was not imported 40percent |
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported
Upload Complete 

You can view the CSV File here, please just check this to see if I'm making any glaring errors - http://tinyurl.com/q5x58lr
(Please note, the CSV File contains adult goods, I Run an adult store so just be aware)

I am using windows 7 and Open Office Calc for the editing.

Any advice would be appreciated.

Haven't looked at the file, but from the reported errors, the data is missing either a unique model number for each item, or the fields header is not formatted (spelt) correctly. Easy populate ver 4 requires every unique item to have a unique model number. For first time uploading, the model number could be generated in the spreadsheet using whatever method desired, but will be the model number for that product until changed in the admin panel.

[mc12345678]

I am using Zen Cart v1.5.1 (The latest one) and Easy Populate for v1.5.1.

I Downloaded Zen Cart today after finally losing patience with OpenCart, and have ran into trouble using easy populate. I would really appreciate some help from the community.

When I go to add my CSV File to the database, this error comes up

Upload Results

File uploaded.
Temporary filename: /customers/1/9/0/cheaponline############s.com/tmp/phpacB0j8
User filename: condoms.csv
Size: 24433

No model field in record. This line was not imported teat ende | made from |
No model field in record. This line was not imported teat ende | made from |
No model field in record. This line was not imported Coloured | Novelty;T |
No model field in record. This line was not imported Coloured | Novelty;T |
No model field in record. This line was not imported lubricate | Coloured | Novelty;T |
No model field in record. This line was not imported lubricate | Coloured | Novelty;T |
No model field in record. This line was not imported Coloured | Novelty;T |
No model field in record. This line was not imported Coloured | Novelty;T |
No model field in record. This line was not imported Coloured | Novelty;T |
No model field in record. This line was not imported Bubble Gu | Banana an | lubricate | Coloured | Novelty;T |
No model field in record. This line was not imported Coloured | Novelty;T |
No model field in record. This line was not imported for all r | they come | moisten t | seal | and let y | the bette | Coloured | Novelty;T |
No model field in record. This line was not imported Coloured | Novelty;T |
No model field in record. This line was not imported Bubble Gu | Banana an | lubricate | Coloured | Novelty;T |
No model field in record. This line was not imported Coloured | Novelty;T |
No model field in record. This line was not imported Coloured | Novelty;T |
No model field in record. This line was not imported teat ende | made from |
No model field in record. This line was not imported teat ende | made from |
No model field in record. This line was not imported teat ende | made from |
No model field in record. This line was not imported teat ende | made from |
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported tapered a | silky smo | special r | made from | individua |
No model field in record. This line was not imported as when i | size real | manufactu |
No model field in record. This line was not imported as when i | size real | manufactu |
No model field in record. This line was not imported
No model field in record. This line was not imported tell them | condoms c | A width o | however | come in m |
No model field in record. This line was not imported tell them | condoms c | A width o | however | come in m |
No model field in record. This line was not imported tell them | condoms c | A width o | however | come in m |
No model field in record. This line was not imported tell them | condoms c | A width o | however | come in m |
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported specially |
No model field in record. This line was not imported teat ende | made from |
No model field in record. This line was not imported teat ende | made from |
No model field in record. This line was not imported teat ende | made from |
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported Made from | teated en | Each cond |
No model field in record. This line was not imported
No model field in record. This line was not imported SKINS are | Skins nat | natural f |
No model field in record. This line was not imported the World | has put t | sensitive | and simpl |
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported SKINS are | Skins nat | natural f |
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported teat ende | made from | Ribbed | Warming;T |
No model field in record. This line was not imported warming a | Ribbed | Warming;T |
No model field in record. This line was not imported Ribbed | Warming;T |
No model field in record. This line was not imported Durex Per | Ribbed | Warming;T |
No model field in record. This line was not imported Ribbed | Warming;T |
No model field in record. This line was not imported Ribbed | Warming;T |
No model field in record. This line was not imported our studd | Ribbed | Warming;T |
No model field in record. This line was not imported Ribbed | Warming;T |
No model field in record. This line was not imported for extra | Ribbed | Warming;T |
No model field in record. This line was not imported Ribbed | Warming;T |
No model field in record. This line was not imported teat ende | made from |
No model field in record. This line was not imported 40percent |
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported
Upload Complete 

You can view the CSV File here, please just check this to see if I'm making any glaring errors - http://tinyurl.com/q5x58lr
(Please note, the CSV File contains adult goods, I Run an adult store so just be aware)

I am using windows 7 and Open Office Calc for the editing.

Any advice would be appreciated.

Okay, have looked at the file now. Couple of things: the fields are not comma separated, they are semi-colon separated. I think that's the first thing that may be an issue with the code, unless you modify the separator in the EP4 code or as part of OO creating the file. The other is that there appears to not be any quotes around the field data. This may be the way the file got downloaded from the storage location provided, or they may be missing. Some have had success without the quotes, but with them and the appropriate separator EP4 is successful.

To clarify for anyone else, essentially EP4 is detecting a row of data, but the row is being considered as one entire string and not separate pieces of information to incorporate into ZC. So it is not picking up any particular field especially the products_model field which does have data in it and therefore providing the error of no model number.

Let us know what ended up working for you or if there is more assistance needed. Welcome to zen Cart by the way!

[ChrisUren]

Thanks for your help mc12345678, I googled a bit more and found out the .csv file needs to be saved as a tab delimited text file, Open Office was saving it as something else, and was filling the fields with randomly generated data when saving, so Easy Populate couldn't read it.

Needless to say once I found that out it was such an easy process, I've got just over 4000 products in my store and it took about 2 hours! Plus importing images was so easy, this was the one thing I was worried about, but it took a few minutes :)

[mc12345678]

Thanks for your help mc12345678, I googled a bit more and found out the .csv file needs to be saved as a tab delimited text file, Open Office was saving it as something else, and was filling the fields with randomly generated data when saving, so Easy Populate couldn't read it.

Needless to say once I found that out it was such an easy process, I've got just over 4000 products in my store and it took about 2 hours! Plus importing images was so easy, this was the one thing I was worried about, but it took a few minutes :)

More than welcome. I thought atthe beginning of this thread there was a lot about how OpenOffice should be setup to handle a majority of the process, (though understand thatthere is still an issue possibly with a few of the languages and getting them to work with EP4), but glad you got it to work. Ihesitated from saying that it wasn't a true csv file, because I know some of the spreadsheet applications use other characters to identify a separator.

2 hours? Is that total time from start to finish of "recreating" your store, or was this EP4 processing time? There is areview going on to identify areas of improvement and if the 2 hour time frame had to do with EP4 pprocessing time, then perhaps some additionnal optimization should be sought.

[ChrisUren]

It took 2 hours to edit the files (From Spreadsheets to the correct .csv format) and upload them to my site.

[icecold]

Hi,

i'm trying to see if there is a way to integrate an MSRP field, into the plugin, as I have tried with different approaches and now all prices are not displaying, in my test site!, I have a VPS, so that's not a problem, I am testing several ways to display list MSRPs as list prices and my price as a saving. I downloaded and tried the MSRP module, the 1.5.1 specific version, but it's messing things up as described, I just need a way to do this and to do it fast. A new field in the csv will speed things up, but I am not sure what approach I have to follow to include that in a way the EasyPopulate4.x reads it correctly.

[mc12345678]

Hi,

i'm trying to see if there is a way to integrate an MSRP field, into the plugin, as I have tried with different approaches and now all prices are not displaying, in my test site!, I have a VPS, so that's not a problem, I am testing several ways to display list MSRPs as list prices and my price as a saving. I downloaded and tried the MSRP module, the 1.5.1 specific version, but it's messing things up as described, I just need a way to do this and to do it fast. A new field in the csv will speed things up, but I am not sure what approach I have to follow to include that in a way the EasyPopulate4.x reads it correctly.

I haven't downloaded the plugin you're talking about, but where is a field added to support MSRP (what database table) and what is the field name?

If the mod affects the products tble, then simply need to include the field name from the EP4 admin panel. (Do not prepend a v_ or other character that doesn't exist in the database field name). If the field is added to another table, then would need to modify EP4 to handle it.

But unless I misunderstood, it seems that the installation of the MSRP has an issue? Be sure to review the applicable discussion thread for that plugin, there may be fixes posted that haven't been incorporated.

[mc12345678]

Forgot to mention/answer the last part of your post. If the field name falls in line with the direction previously provided then would export the database and the field name will be included, then update/insert the values desired however chosen and then upload the newly modified file.