EasyPopulate 4.0 Support Thread

mc12345678:

Okay, so another confusing statement, but no matter... :)

So, each field that has an underscore followed by a number (ie. _1) is a field that can be found in the (prefix)products_description table. And again, the number corresponds to an installed language. No two stores are guaranteed to have the same sequence of languages. (Meaning a random selection of websites that have multiple languages may put Spanish 2nd, 1st, 6th, etc... Assuming that another language was applied/installed at some point before...

So, regarding the field length... That is controlled within your mySQLadmin editor...
If you open the mySQLAdmin editor (most likely through your cPanel), then open your store's database, then open the table (prefix)products_description, then while on the Structure tab, select the products_name field and edit it.

The next window should show the various information related to the field. For example the Length/Values... Update though for this type of data to have the maximum that you want to be able to enter.

Hope that helps.

I'm so sorry I made my statement confusing. Thank you for the instructions. I followed them exactly, and unfortunately, this is the exact same thing I did previously which did not work.

Went to database>table: products_description>products_name and changed VARCHAR to 165 under Length/Values.

Went to database>table: orders_products>products_name and changed VARCHAR to 165 under Length/Values.

The Database Field Lengths are still listed as follows on the "Easy Populate 4.0.22 - Beta 6-10-2012" page from where I again imported the file to my test site:

Database Field Lengths
categories_name:255
manufacturers_name:32
products_model:32
products_name:128

After I re-imported the file, I got the same results on some of the products: "Warning! ...(product Model and info are listed)... exceeds max. length: 128"

Any more ideas? Is there a modification which has to be made to the EP4 code which is downloaded on my site? If so, where and how or is this not applicable?

Thank you for your help.

pdevo:

I'm so sorry I made my statement confusing. Thank you for the instructions. I followed them exactly, and unfortunately, this is the exact same thing I did previously which did not work.

Went to database>table: products_description>products_name and changed VARCHAR to 165 under Length/Values.

Went to database>table: orders_products>products_name and changed VARCHAR to 165 under Length/Values.

The Database Field Lengths are still listed as follows on the "Easy Populate 4.0.22 - Beta 6-10-2012" page from where I again imported the file to my test site:

Database Field Lengths
categories_name:255
manufacturers_name:32
products_model:32
products_name:128

After I re-imported the file, I got the same results on some of the products: "Warning! ...(product Model and info are listed)... exceeds max. length: 128"

Any more ideas? Is there a modification which has to be made to the EP4 code which is downloaded on my site? If so, where and how or is this not applicable?

Thank you for your help.

If you haven't modified the EP4 code, then there is nothing about EP4 that is hindering using more space in the field. I say this because EP4 reads the size of the field from the database and then reports (and uses) that size to display what you are seeing. It could be that the value was cached somewhere in the process. Suggest clearingcache/cookies and trying again, or trying to access from a different browser or machine (sort of like clearing those two without actually doing so for the first two tries or so.) Anyways, EP4 just didntsee the change at the tme of testing, perhaps when you read this next (if the change stays the way it is/was) EP4 will report a. Different result.

mc12345678:

If you haven't modified the EP4 code, then there is nothing about EP4 that is hindering using more space in the field. I say this because EP4 reads the size of the field from the database and then reports (and uses) that size to display what you are seeing. It could be that the value was cached somewhere in the process. Suggest clearingcache/cookies and trying again, or trying to access from a different browser or machine (sort of like clearing those two without actually doing so for the first two tries or so.) Anyways, EP4 just didntsee the change at the tme of testing, perhaps when you read this next (if the change stays the way it is/was) EP4 will report a. Different result.

Thank you so much for the follow up. Although I tried clearing the cache yesterday and didn't see a change, this morning when I booted up fresh for the day, the change showed up. It is not showing on my test site but I am taking steps to clear that up. Thank you so much for your help. I am without a developer right now (and desperately need one) and truly appreciate your assistance and that of the forum.

I see we can "buy you a cup of coffee" for your help. I would be happy to do that. Can you please direct me on how to get that done?

Thank you.

pdevo:

Thank you so much for the follow up. Although I tried clearing the cache yesterday and didn't see a change, this morning when I booted up fresh for the day, the change showed up. It is not showing on my test site but I am taking steps to clear that up. Thank you so much for your help. I am without a developer right now (and desperately need one) and truly appreciate your assistance and that of the forum.

I see we can "buy you a cup of coffee" for your help. I would be happy to do that. Can you please direct me on how to get that done?

Thank you.

You are quite welcome. It's good to know that EP4 was not the cause of the problem.

I'm not sure how close to the line of allowance I am on stating this. Some of those that offer assistance have a website in their signature section of their post(s). This is often a good way to find out more about what they do, or offer. Perhaps for some it is clearer than for others.

Coffee though, sure helps encourage productivity (or just make one jittery. :) )

pdevo:

Thank you so much for the follow up. Although I tried clearing the cache yesterday and didn't see a change, this morning when I booted up fresh for the day, the change showed up. It is not showing on my test site but I am taking steps to clear that up. Thank you so much for your help. I am without a developer right now (and desperately need one) and truly appreciate your assistance and that of the forum.

I see we can "buy you a cup of coffee" for your help. I would be happy to do that. Can you please direct me on how to get that done?

Thank you.
Someone is always willing to help:yes:

I apologize if this question has come up already, I have searched through over 50 pages of the thread before I decided to just send this question: I am currently using a temporary url (ip address/~sitename) and I cannot get ep 4.0 to upload my full complete file. I get directed strait to the admin login screen. I use ep 4.0 for every site and do not typically use a temp url, but I need to in this instance. I did find one post regarding this and it turned into a pm but a solution to the problem was not offered. I have updated my config file (both) to reflect the temporary url, but it's still not working. I also double checked for "//" and it is not there either. I am fairly confident there is something else I am missing in the config file or uploads directory but can't figure it out. Again, my apologies if I missed this somewhere else in this thread. Looking forward to assistance. Thanks.

creyesx6:

I apologize if this question has come up already, I have searched through over 50 pages of the thread before I decided to just send this question: I am currently using a temporary url (ip address/~sitename) and I cannot get ep 4.0 to upload my full complete file. I get directed strait to the admin login screen. I use ep 4.0 for every site and do not typically use a temp url, but I need to in this instance. I did find one post regarding this and it turned into a pm but a solution to the problem was not offered. I have updated my config file (both) to reflect the temporary url, but it's still not working. I also double checked for "//" and it is not there either. I am fairly confident there is something else I am missing in the config file or uploads directory but can't figure it out. Again, my apologies if I missed this somewhere else in this thread. Looking forward to assistance. Thanks.

When you say upload, do you mean import? Or do you mean that you are having problems getting the file to exist on the server to be processed via import?

How many items are you trying to process? Have you tried splitting the file? Have you tried using a single line item in a file and trying to import it? Does it work, or cause the same result? If there is a configure.php problem I would suggest addressing that through a different thread. Ideally you would use the install utility of ZC to create the configure.php file for your version. There are FAQs about that in the forum.

mc12345678:

When you say upload, do you mean import? Or do you mean that you are having problems getting the file to exist on the server to be processed via import?

How many items are you trying to process? Have you tried splitting the file? Have you tried using a single line item in a file and trying to import it? Does it work, or cause the same result? If there is a configure.php problem I would suggest addressing that through a different thread. Ideally you would use the install utility of ZC to create the configure.php file for your version. There are FAQs about that in the forum.

How many items are you trying to process? Have you tried splitting the file? Have you tried using a single line item in a file and trying to import it? Does it work, or cause the same result? If there is a configure.php problem I would suggest addressing that through a different thread. Ideally you would use the install utility of ZC to create the configure.php file for your version. There are FAQs about that in the forum.[/QUOTE]

Yes, I meant upload. I am unable to get the file to exist on the server. It just takes me to the admin login screen. I have tried to upload the Full/Complete file several times (more than 5) with making adjustments to the uploads directory. I can't get past the upload so am unable to import a single line item in a file (I tried to upload with a single line item though) nor am able to split the file since it doesn't upload. The export function is not working for me either. To double check my suspicion of thinking it had to do with using the ip address (using temporary url until domain name servers are changed), I tried to duplicate my efforts with another site that is using a temporary url and had the same result. The config files were created by zc via cpanel, but I am not certain if that is one in the same as the utility since this is the only way I have installed ZC with other sites. Thank you very much for responding, I typically don't post unless I am completely stuck.

creyesx6:

How many items are you trying to process? Have you tried splitting the file? Have you tried using a single line item in a file and trying to import it? Does it work, or cause the same result? If there is a configure.php problem I would suggest addressing that through a different thread. Ideally you would use the install utility of ZC to create the configure.php file for your version. There are FAQs about that in the forum.

Yes, I meant upload. I am unable to get the file to exist on the server. It just takes me to the admin login screen. I have tried to upload the Full/Complete file several times (more than 5) with making adjustments to the uploads directory. I can't get past the upload so am unable to import a single line item in a file (I tried to upload with a single line item though) nor am able to split the file since it doesn't upload. The export function is not working for me either. To double check my suspicion of thinking it had to do with using the ip address (using temporary url until domain name servers are changed), I tried to duplicate my efforts with another site that is using a temporary url and had the same result. The config files were created by zc via cpanel, but I am not certain if that is one in the same as the utility since this is the only way I have installed ZC with other sites. Thank you very much for responding, I typically don't post unless I am completely stuck.[/QUOTE]

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

mc12345678:

Yes, I meant upload. I am unable to get the file to exist on the server. It just takes me to the admin login screen. I have tried to upload the Full/Complete file several times (more than 5) with making adjustments to the uploads directory. I can't get past the upload so am unable to import a single line item in a file (I tried to upload with a single line item though) nor am able to split the file since it doesn't upload. The export function is not working for me either. To double check my suspicion of thinking it had to do with using the ip address (using temporary url until domain name servers are changed), I tried to duplicate my efforts with another site that is using a temporary url and had the same result. The config files were created by zc via cpanel, but I am not certain if that is one in the same as the utility since this is the only way I have installed ZC with other sites. Thank you very much for responding, I typically don't post unless I am completely stuck.

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.?[/QUOTE]

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!

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

creyesx6:

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]

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.

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.

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.

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.

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!

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 :)

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 :)

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.

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

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.

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.

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.

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.