EasyPopulate 4.0 Support Thread

Quote:

---

Originally Posted by su35

Is the 4.0.26 compatible with ZC 1.5.1? or it is for 1.5.3 only?

---

There has been no compatibility change in the software. While it is in the best interest of a store owner to upgrade to the most recent/stable version for many reasons, the software is written to continue support for all versions that it has previously been written, which I believe at this time is considered 1.3.9 through 1.5.3 with exception that 1.5.2 was not factored into the compatibility as it was not a formal release and really should not be used in a production environment anyways.

So, short answer, yes it is compatible with 1.5.1 also.

Quote:

---

Originally Posted by mc12345678

Update 4.0.26 has been loaded to https://github.com/mc12345678/EasyPopulate-4.0 with a pull request to https://github.com/chaddro/EasyPopulate-4.0. Follow the same process as identified in post 1 of this thread; however, until merged use the first link above. Category sort_order information is loaded to and from the Categories Only (with Metatags) option.

---

That's awesome MC, thank you so much. I was expecting you to come back and say "No, it can't be done", I wasn't expecting a new release that addresses my problem perfectly! Thanks again, I love your work :cheers:

Kind Regards

John

Quote:

---

Originally Posted by jrobbo

That's awesome MC, thank you so much. I was expecting you to come back and say "No, it can't be done", I wasn't expecting a new release that addresses my problem perfectly! Thanks again, I love your work :cheers:

Kind Regards

John

---

Though I'm likely to regret saying this. :) there is little that can't be done with the code to do what is desired within ZC. Some things just take longer than others. :) and some things are just not within the capability of the individual, but that's also what this whole open source stuff is about, can't do personally (for any number of reasons: on vacation, doing other paying work, need to learn something, etc...), someone else probably can. :)

And to be honest, I was a little surprised that the issue wasn't already covered seeing how much great stuff this little program already handles. I keep saying it's pretty powerful and chadderuski did a great job of converting the old stuff into this.

Quote:

---

Originally Posted by mc12345678

Though I'm likely to regret saying this. :) there is little that can't be done with the code to do what is desired within ZC. Some things just take longer than others. :) and some things are just not within the capability of the individual, but that's also what this whole open source stuff is about, can't do personally (for any number of reasons: on vacation, doing other paying work, need to learn something, etc...), someone else probably can. :)

And to be honest, I was a little surprised that the issue wasn't already covered seeing how much great stuff this little program already handles. I keep saying it's pretty powerful and chadderuski did a great job of converting the old stuff into this.

---

Just wanted to report back and let you know that the update worked perfectly. Thanks very much again MC (and of course to Chad) :cheers:

Quote:

---

Originally Posted by jrobbo

Just wanted to report back and let you know that the update worked perfectly. Thanks very much again MC (and of course to Chad) :cheers:

---

Glad to hear back that it works. I did notice this week that there is a minor coding error. Users of version 4.0.25+ will see the SBA options even if SBA is not installed. A $ is missing in the admin's easypopulate_4.php file at the check before displaying the menu option(s). Will update to 4.0.26a to address that. In the meantime, choosing any of those options without SBA installed will generate EP4 errors.

Version 4.0.26a has been uploaded to github, the update now correctly hides the SBA options for those that don't hve SBA installed.

Didn't mention it before, but the files just needed to be replaced. No uninstall/reinstall necessary.

https://github.com/mc12345678/EasyPopulate-4.0

Hi mc 12345678
For the function "import basic attributes", is there a file name limitation? A file, if I named it as products_atti.csv, it wouldn't work. If I changed its name as "Attrib-Basic-EP2014Oct26-131918.csv", it worked fine.

Quote:

---

Originally Posted by su35

Hi mc 12345678
For the function "import basic attributes", is there a file name limitation? A file, if I named it as products_atti.csv, it wouldn't work. If I changed its name as "Attrib-Basic-EP2014Oct26-131918.csv", it worked fine.

---

Yes there is and is so with most of the files. Everything up to the EP helps the code identify the action to be taken with the file. The date information after that can be modified as desired.

If I'm understanding all the research I've read here in this thread there is no way to use this mod to import products that are priced by attributes, eg, size1- $5, size2 $10, size3 $15, etc...? And if no anyone have an answer how to import products when they are priced by attribute such as choose quantity?

Quote:

---

Originally Posted by thomaswhiteeagle

If I'm understanding all the research I've read here in this thread there is no way to use this mod to import products that are priced by attributes, eg, size1- $5, size2 $10, size3 $15, etc...? And if no anyone have an answer how to import products when they are priced by attribute such as choose quantity?

---

Don't know what led to that conclusion but it is wrong. EasyPopulate v4 can very easily handle price by attribute and other aspects of attributes... Suggestion is to export a few of the different downloads and take alook at the available data. Without modificatiion, most of that datacan be modified and then uploaded.

Version 4.0.27 to EP4 has been uploaded to https://github.com/mc12345678/EasyPopulate-4.0 which should eventually be mirrored to https://github.com/chaddro/EasyPopulate-4.0. This version adds the capability to export the URI as would be generated on the catalog side of the store when exporting products or categories with meta information. Again, no functionality is removed from the application, only increased. A new switch is added to the EP4 configuration menu; however, this would require either an uninstall/install sequence or manual SQL addition.

Hello, I have tried to install this into my zen cart 1.5.3 but when I go to my admin area I don't see easy populate 4 anywhere, nor did the error screen come on when I log into admin? Any ideas.
Thank you
Ron

Quote:

---

Originally Posted by RonGin

Hello, I have tried to install this into my zen cart 1.5.3 but when I go to my admin area I don't see easy populate 4 anywhere, nor did the error screen come on when I log into admin? Any ideas.
Thank you
Ron

---

Uploaded the one file that is applicable to zen cart 1.5.x and the contents of the applicable admin folder were in factloaded into the secret admin directory?

Not sure what error screen was expected...

Quote:

---

Originally Posted by mc12345678

Uploaded the one file that is applicable to zen cart 1.5.x and the contents of the applicable admin folder were in factloaded into the secret admin directory?

Not sure what error screen was expected...

---

Hello, thanks again for the reply, however I have been check for quite awhile now, and I still don't see this in the configuration in admin panel. Their is another includes/includes folder in this directory do you think I should put it in there?
Thanks
Ron

Quote:

---

Originally Posted by RonGin

Hello, thanks again for the reply, however I have been check for quite awhile now, and I still don't see this in the configuration in admin panel. Their is another includes/includes folder in this directory do you think I should put it in there?
Thanks
Ron

---

Once all the files are loaded into their correct folder(s), the firstindication that EP4 has been loaded is the option under tools. A configuration menu option will not appear until the install link has been selected from the window that appears from selecting tools->Easy Populate 4

As for file placement, allof the files for EP4 are admin files, the content of the admin directory of the EP4 plugin should be copied to your SECRET admin directory. That means in your SECRET admin directory there shouldbe easypopulate_4.php and four other files that start with the same name as that.

Quote:

---

Originally Posted by mc12345678

As for file placement, allof the files for EP4 are admin files, the content of the admin directory of the EP4 plugin should be copied to your SECRET admin directory. That means in your SECRET admin directory there shouldbe easypopulate_4.php and four other files that start with the same name as that.

---

Thank you, I have the program up and running now I did not upload all the files separately and had to go back and do that now it is running. I do have a question about the renaming of temp which I did and when I went to change the attributes in the new name, the temp and new name disappeared is that normal?
Thank you,
Ron :smile:

Quote:

---

Originally Posted by RonGin

Thank you, I have the program up and running now I did not upload all the files separately and had to go back and do that now it is running. I do have a question about the renaming of temp which I did and when I went to change the attributes in the new name, the temp and new name disappeared is that normal?
Thank you,
Ron :smile:

---

Not sure I follow. The values in the configuration panel do not adjust to the folder structure seen while ftping the site. If the value was changed in say myphpadmin or by changing the SQL and running it again, then all of those things could in a sense cause what you saw. At the same time I don't fully understand a) what was seen, b) what was done that may have caused what was seen.

BTW, glad that you were able to get the files loaded and to be able to access the software.

Quote:

---

Originally Posted by mc12345678

Not sure I follow. The values in the configuration panel do not adjust to the folder structure seen while ftping the site. If the value was changed in say myphpadmin or by changing the SQL and running it again, then all of those things could in a sense cause what you saw. At the same time I don't fully understand a) what was seen, b) what was done that may have caused what was seen.

BTW, glad that you were able to get the files loaded and to be able to access the software.

---

Hello, I am having trouble with putting in the temp file: This is what I have done, I have renamed the folder "papa/" moved it to secret admin, I see it but under the tools-easypopulate 4- I am getting a message-

Code:

---

Warning Easy Populate "Uploads Folder" missing!
Your uploads folder is missing. Your configuration indicates that your uploads folder is named store/papa/, and is located in /home/erbornb2/public_html/.

---

Is the file there or not I am not sure what it is saying, sorry for all the trouble, I have always had a very hard time with this type of file transfer but I have to understand it now:blush:

Thank you,
Ron

Quote:

---

Originally Posted by RonGin

Hello, I am having trouble with putting in the temp file: This is what I have done, I have renamed the folder "papa/" moved it to secret admin, I see it but under the tools-easypopulate 4- I am getting a message-

Code:

---

Warning Easy Populate "Uploads Folder" missing!
Your uploads folder is missing. Your configuration indicates that your  uploads folder is named store/papa/, and is located in  /home/erbornb2/public_html/.

---

Is the file there or not I am not sure what it is saying, sorry for all the trouble, I have always had a very hard time with this type of file transfer but I have to understand it now:blush:

Thank you,
Ron

---

Ahh, now I understand the situation. For EP4 to know where the folder is now located, it must be entered/changed in the configuration section for EP4. Now that the folder temp has been renamed to say papa AND moved to the secret admin directory, the data in the field should reflect what it takes to get from the store's directory to the folder in the secret admin. So if the admin directory is for example named storeadmin and the papa folder is inside there then the path that should be entered in the configuration area is storeadmin/papa.

So if 'store' is your admin directory, then it should be renamed as it is/was posted here for all to see.

Quote:

---

Originally Posted by mc12345678

Ahh, now I understand the situation. For EP4 to know where the folder is now located, it must be entered/changed in the configuration section for EP4. Now that the folder temp has been renamed to say papa AND moved to the secret admin directory, the data in the field should reflect what it takes to get from the store's directory to the folder in the secret admin. So if the admin directory is for example named storeadmin and the papa folder is inside there then the path that should be entered in the configuration area is storeadmin/papa.

So if 'store' is your admin directory, then it should be renamed as it is/was posted here for all to see.

---

I finally have it working thanks for your help, this will help me tremendously, I will rename the directory now, hopefully nothing changes after I do so.

I am using EP4 in a 1.5.3 site. Using Open Office and comma delimited... Saving as a CSV file. Upload and import. Getting the following error for all products: No model field in record. This line was not imported. Attaching csv file for you to see.
Thanks for any help you can give me....
~anne

Records are not saved correctly...

Each column (v_products_model for example) is not properly delimited...

Right now everything is separated by a tab, and instead of a double quote, the text is surrounded by a single quote. These differences cause issues for the upload.

What seems like the "easy" way to correct the example that was uploaded is to open the file, selecting:
Character Set: Unicode (UTF-8) seemed to work
Language: Default - English (USA)
From row: 1
separated by: Tab
With Text Delimiter as the single quote.
Checkbox for Quoted field as text marked.
No other indicators.

Then, the first column will have a " at the beginning of each cell which should be removed.
The values in the v_products_name_1 column should have extra spaces removed (LL. Bean bag-Small for example)
The last column has extra data at the end of each row for that column. (",,,) Those could be mass removed with a search and replace..

Then once all of the issues have been corrected perform a save as: file type: Test CSV (.csv) (*.csv)
check the checkbox for Edit filter settings. Select Save and then in the questions asked save it the following way:
Character Set: Unicode (UTF-8)
Field delimiter: , (comma)
Text delimiter: " (double quote)
I set it to Quote all text cells and Save cell content as shown, but wasn't sure about the quote all text cells. I believe chadderuski had some good guidance about how to save the file(s).

The above "directions" are from working with Open Office Version 4.1.1.

Thanks! I will try this tomorrow.

Quote:

---

Originally Posted by stellarweb

So I set up an admin area in a separate folder that ties into the current database and EP works fine! Not the greatest solution, I am sure, but the best I know of for now until USU gets updated.

---

I have the exact same problem. Please help as I have no idea how to do what you described.

Tried removing and reinstalling easy populate with no luck. I am using ZC 1.53

Quote:

---

Originally Posted by keith z

I have the exact same problem. Please help as I have no idea how to do what you described.

Tried removing and reinstalling easy populate with no luck. I am using ZC 1.53

---

Please see this post: http://www.zen-cart.com/showthread.p...54#post1260554

The issue is not fully/properly incorporating USU into the store. There are instructions on how to do that. The solution offered above was to create a new admin subdirectory with all of the same configure.php settings, but only offering EP4 in that admin directory.

hi

i want upload a description data with easy populate

i can use i file whit simple file csv with fileds: v_products_model and v_products_description_2 ???


i have a error and dont possible atachement csv file!!! where is the error log of easy populATE4 ??

THANKS

Quote:

---

Originally Posted by salvo72

hi

i want upload a description data with easy populate

i can use i file whit simple file csv with fileds: v_products_model and v_products_description_2 ???


i have a error and dont possible atachement csv file!!! where is the error log of easy populATE4 ??

THANKS

---

Errors captured/documented by EP4 are in an errorlog listed in the files to be imported/downloaded. New errors are added to the end of the file. If this file has been in the file list for a long time it may contain multiple errors that do not relate to the current issue.

Btw, I am not entirely sure that the code currently supports only a total of two columns being in the upload file. I would have to look to see what changes might be necessary to support that.

Hi, I have installed EP4 on a 1.5.3 zencart site. I have noticed I get the following when using this add-on

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

When I check my logs folder, the error is as follows.
"[29-Nov-2014 16:01:47 Europe/London] PHP Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in /home/izzy/public_html/ZC153-test5/renamedaddy/easypopulate_4_import.php on line 881"

I don't know what I have done wrong :(
I do not get this error on a 1.5.1 site.

All help appreciated!

Quote:

---

Originally Posted by izzysoup

Hi, I have installed EP4 on a 1.5.3 zencart site. I have noticed I get the following when using this add-on

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

When I check my logs folder, the error is as follows.
"[29-Nov-2014 16:01:47 Europe/London] PHP Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in /home/izzy/public_html/ZC153-test5/renamedaddy/easypopulate_4_import.php on line 881"

I don't know what I have done wrong :(
I do not get this error on a 1.5.1 site.

All help appreciated!

---

Which ver of EP4 was installed on ZC 1.53 and what plugins are also installed on the ZC site?

I also was having the language error

EP4 FATAL ERROR: No default language set.

and followed the posts here looking for the fix. The quote below didnt really explain to me how it was done. BUT overwriting the query_factory.php file with the default 1.5.3 file worked. I will just replace it with the SEO one later but Im posting here to perhaps ask how the below method works exactly? Is it an entire extra ZC install or just an extra admin folder? I tried an extra admin folder with default ZC 1.5.3 files but that didnt work for me.

Perhaps the fix can come from within the query_factory.php file ?

Im also running 1.5.3 and USU and EP4.

Quote:

---

Originally Posted by stellarweb

Happy dance! The site has Ultimate SEO URL's installed and one of the files includes/classes/db/mysql/query_factory.php is what was causing the problem. Unfortunately, since this mod has not been updated yet for 1.5.3, I have to use that file for the USU to work. So I set up an admin area in a separate folder that ties into the current database and EP works fine! Not the greatest solution, I am sure, but the best I know of for now until USU gets updated.

---

Quote:

---

Originally Posted by Chargin

I also was having the language error

EP4 FATAL ERROR: No default language set.

and followed the posts here looking for the fix. The quote below didnt really explain to me how it was done. BUT overwriting the query_factory.php file with the default 1.5.3 file worked. I will just replace it with the SEO one later but Im posting here to perhaps ask how the below method works exactly? Is it an entire extra ZC install or just an extra admin folder? I tried an extra admin folder with default ZC 1.5.3 files but that didnt work for me.

Perhaps the fix can come from within the query_factory.php file ?

Im also running 1.5.3 and USU and EP4.

---

The proper fix is to install USU correctlly... Core files and overrides should be 1) compared against default versions of the version used in the plugin. 2) those changes should be incorporated into the store's 1.5.3 version of the file(s).

As for the separate admin directory, if the file that is an issue truly is includes/classes/db/mysql/query_factory.php then it would require a separate install of the entire fileset with the daatabase pointing to the same as thelive store.

Also, I thought that in this thread which is about how EP4 operates and how to install it (not how to install other plugins) there were some links to posts in the USU thread to resolve this issue, ie. One was to a set of files modified/incorporating the ZC 1.5.3 changes. BTW, while whatever file is replaced with the default ZC 1.5.3 version, how functional is the site? Any issues?

Some of the below links apply:
Diva Vocal's summary on the issue: http://www.zen-cart.com/showthread.p...te#post1260554
Mc12345678 response to a similar question with a link to USU where an "updated" set of files for ZC 1.5.3 was posted on the USU thread: http://www.zen-cart.com/showthread.p...49#post1260149
Mc12345678 post on USU with files merged for ZC 1.5.3: http://www.zen-cart.com/showthread.p...48#post1260148

Hi, thanks for your reply.
In answer to your question about how the site worked with the 1.5.1 version of query_factory.php that is included in USU, it works to a point, clicking products gives a page not found and I didnt do much to test it, I havent added new products for example. No errors popup at least. Replacing the query_factory.php file with 1.5.3 version and it all works again.

I tried the files you linked to but I do still have the language error. query_factory.php is very different from 1.5.3 to the USU 1.5.1 version, I compared the 2 and its vast. Seems to me the fix would be within changes to that file? The zip linked from your post replaced a few other files but not query_factory.php.

Looking at the differences between the standard 1.5.1 version and the modified for USU 1.5.1 version theres not much difference, more than I could edit with my php knowledge though. Ill ask if perhaps the author can supply a 1.5.3 version of that file.

Quote:

---

Originally Posted by mc12345678

The proper fix is to install USU correctlly... Core files and overrides should be 1) compared against default versions of the version used in the plugin. 2) those changes should be incorporated into the store's 1.5.3 version of the file(s).

As for the separate admin directory, if the file that is an issue truly is includes/classes/db/mysql/query_factory.php then it would require a separate install of the entire fileset with the daatabase pointing to the same as thelive store.

Also, I thought that in this thread which is about how EP4 operates and how to install it (not how to install other plugins) there were some links to posts in the USU thread to resolve this issue, ie. One was to a set of files modified/incorporating the ZC 1.5.3 changes. BTW, while whatever file is replaced with the default ZC 1.5.3 version, how functional is the site? Any issues?

Some of the below links apply:
Diva Vocal's summary on the issue: http://www.zen-cart.com/showthread.p...te#post1260554
Mc12345678 response to a similar question with a link to USU where an "updated" set of files for ZC 1.5.3 was posted on the USU thread: http://www.zen-cart.com/showthread.p...49#post1260149
Mc12345678 post on USU with files merged for ZC 1.5.3: http://www.zen-cart.com/showthread.p...48#post1260148

---

Hi, hoping someone will be able to help. I am using v1.5.3 of zen and EasyPop v4.
My file is reporting as imported successfully however on in the database only 3 items appear out of a possible 10?
I have tried to test out if some field names are too long but it seems fine, so not sure why no all products are in the category. The only that populates is BEST WESTERN PLUS THE GONVILLE HOTEL

"v_products_model","v_products_type","v_products_image","v_products_name_1","v_p roducts_description_1","v_products_url_1","v_specials_price","v_specials_date_av ail","v_specials_expires_date","v_products_price","v_products_weight","v_product _is_call","v_products_sort_order","v_products_quantity_order_min","v_products_qu antity_order_units","v_products_priced_by_attribute","v_product_is_always_free_s hipping","v_date_avail","v_date_added","v_products_quantity","v_manufacturers_na me","v_categories_name_1","v_tax_class_title","v_status","v_metatags_products_na me_status","v_metatags_title_status","v_metatags_model_status","v_metatags_price _status","v_metatags_title_tagline_status","v_metatags_title_1","v_metatags_keyw ords_1","v_metatags_description_1"
"Gourmet",1,"http://assets.redletterdays.co.uk/images/img435/productLarge/AFC","Arsenal Emirates Stadium Tour","The magnificent Emirates Stadium has become a landmark piece of modern architecture dominating the north London skyline. Marvel at the building from the outside and then follow in the footsteps of your Arsenal heroes by joining the Emirates Stadium Tour. You will see all the areas which are crucial to the team on a match day - from a walk down the players' tunnel, to a seat in the first team dressing room. Visit the Directors Box and press conference facilities. Along with state-of-the-art facilities, the club have incorporated some stunning features from the hallowed Highbury ground as well as some extra personal touches from inspirational and long-term Arsenal manager, Arsene Wenger. This tour is a must for any true fan of the Gunners.","www.awin1.com/pclick.php?p=102695293&a=123486&m=1983",,,,20,0,0,20,1,1983,0,0,,"12/03/14 12:11",0,"Red Letter Days","Gifts, Gadgets & Toys^Experiences","--none--",1,0,0,0,0,0,,,
"Gourmet",1,"http://assets.redletterdays.co.uk/images/img435/productLarge/MRS","Moorhill House Afternoon Tea","Enjoy an afternoon tea for two at Moorhill House - a hotel and restaurant on the outskirts of Burley in the New Forest. The hotel overlooks splendid gardens and lawns and provides a quiet atmosphere in which to relax. Head to the hotel restaurant (or if the weather is fine","www.awin1.com/pclick.php?p=3168928567&a=123486&m=1983",,,,27,0,0,20,1,1,0,0,,"26/11/14 18:46",0,"Red Letter Days","Gifts, Gadgets & Toys^Experiences","--none--",1,0,0,0,0,0,,,
"Accommodation",1,"http://images.bestwestern.co.uk/awa2/image3/83007/grounds-and-hotel-/moor-hall-hotel-grounds-and-hotel-22-83007.jpg","Moor Hall Hotel Spa","Come on in to the country character... and the unrivalled hospitality offered by the family run BEST WESTERN PREMIER Moor Hall Hotel & Spa! Surrounded by greenery (and exceptional staff), you'll have ample opportunity to enjoy the great outdoors of Sutton Coldfield and nearby parkland, within easy reach of Birmingham, the NEC, the motorway network and attractions such as Drayton Manor Park and Cadbury World. We're the business as far as business guests are concerned, not only offering well equipped ensuite bedrooms, but taking care of the ins and outs of organising your conferences in one of 7 rooms too! We have four poster rooms for those special occasions, and a choice of 2 restaurants will leave you spoilt for choice. And as for leisure facilities, our indoor pool, jacuzzi, sauna, steam room, aerobics room and spa with four treatment rooms will take care of your pampering preferences. Address: Moor Hall Drive,Four Oaks,Sutton Coldfield,West Midlands,B75 6LN,England","www.awin1.com/pclick.php?p=105706645&a=123486&m=2671",,,,101,0,0,101,1,2671,0,0,,"27/11/14 18:46",0,"Best Western Hotels","Accommodation^Hotels UK","--none--",1,0,0,0,0,0,,,
"Accommodation",1,"http://images.bestwestern.co.uk/awa2/image3/83027/grounds-and-hotel-/lansdowne-hotel-grounds-and-hotel-07-83027.jpg","Lansdowne Hotel","This traditional privately owned seafront hotel lies close to shops and theatres, so buying handbags and putting on your glad rags is par for the course here in Eastbourne! BEST WESTERN Lansdowne Hotel has sea view lounges and a welcoming foyer. Individually furnished bedrooms are a delight to behold (and sleep in!), while our South Coast setting puts you 2 miles from Beachy Head and within easy reach of Brighton too. For indoor entertainment guests are invited to play games galore... or aim for a high break during their break in our two snooker rooms. High standards and friendly service are ever present. Address: King Edward’s Parade,Eastbourne,East Sussex,BN21 4EE,England","www.awin1.com/pclick.php?p=105706646&a=123486&m=2671",,,,35,0,0,35,1,2671,0,0,,"28/11/14 18:46",0,"Best Western Hotels","Accommodation^Hotels UK","--none--",1,0,0,0,0,0,,,
"Accommodation",1,"http://images.bestwestern.co.uk/awa2/image3/83294/grounds-and-hotel-/wroxton-house-hotel-grounds-and-hotel-52-83294.jpg","BEST WESTERN PLUS Wroxton House Hotel","A blissful Banbury break lies in store here at BEST WESTERN PLUS Wroxton House Hotel! In the comfortable cosiness of our 17th Century thatched manor house - dating in parts from 1649 - you'll be perfectly placed in this unspoilt Cotswold village location. Though we're a mere 14 miles from Shakespeare's Stratford-upon-Avon, 25 miles from Oxford and 4 miles from junction 11 of the M40, our idyllic retreat will win your heart in the Heart of England! All 32 bedrooms, most of which were completely refurbished in 2009, are simple, luxurious and welcoming. A truly memorable dining experience awaits in our AA rosette award winning Restaurant '1649'. And if you're visiting on business or arranging a special gathering, we also have a dedicated team to take the headaches out of hosting a big event! Address: Silver Street,Wroxton,Banbury,Oxfordshire,OX15 6QB,England","www.awin1.com/pclick.php?p=105706675&a=123486&m=2671",,"2014-12-03","2014-12-03",85,0,0,85,1,2671,0,0,,"28/11/14 18:46",0,"Best Western Hotels","Accommodation^Hotels UK","--none--",1,0,0,0,0,0,,,
"Accommodation",1,"http://images.bestwestern.co.uk/awa2/image3/83296/grounds-and-hotel-/salford-hall-hotel-grounds-and-hotel-02-83296.jpg","BEST WESTERN Salford Hall Hotel","Tudor, yet timeless, the romantic BEST WESTERN Salford Hall Hotel is a delightful manor house that opens up the gateway to Shakespeare country and the Cotswolds. "To stay or not to stay", that is the question. Though our delightful setting, amiable staff and four-poster beds in some rooms should make it an easy one to answer! We're also blessed (and proud as punch) to be able to offer charming accommodation in Tudor Court, a lovingly restored coach house and granary. Good food and even better company can be found in our friendly award-winning restaurant, and we'll do everything possible during your break to make it an unforgettable one. Address: Abbots Salford,Stratford upon Avon,Warwickshire,WR11 8UT,England","www.awin1.com/pclick.php?p=105706676&a=123486&m=2671",,"2014-12-03","2014-12-03",60,0,0,60,1,2671,0,0,,"28/11/14 18:46",0,"Best Western Hotels","Accommodation^Hotels UK","--none--",1,0,0,0,0,0,,,
"Accommodation",1,"http://images.bestwestern.co.uk/awa2/image3/83315/grounds-and-hotel-/duke-of-cornwall-hotel-grounds-and-hotel-04-83315-OP.jpg","BEST WESTERN Duke of Cornwall Hotel","We're proud of our individuality here at BEST WESTERN Duke of Cornwall Hotel, and we're sure you'll be hugely impressed by it! In Plymouth, close to the centre and waterfront, this beautiful Victorian-Gothic building provides the ideal base for exploring Devon, Cornwall and The Eden Project, with equally tempting attractions waiting for you on your return in the elegant surroundings of our 1 AA rosette restaurant. All bedrooms are uniquely designed with stylish interiors. For foreign forays, our hotel is the closest to the cross channel Ferryport, and you'll be just half a mile from Portsmouth Hoe and even closer to the famous Pavillions if you want to keep things British! Business travellers, families and couples will be more than welcome, so whatever your reason for relaxing here on the South Coast, you can look forward to an unforgettable break. Address: Millbay Road,Plymouth,Devon,PL1 3LG,England","www.awin1.com/pclick.php?p=105706677&a=123486&m=2671",,"2014-12-03","2014-12-03",76,0,0,76,1,2671,0,0,,"28/11/14 18:46",0,"Best Western Hotels","Accommodation^Hotels UK","--none--",1,0,0,0,0,0,,,
"Accommodation",1,"http://images.bestwestern.co.uk/awa2/image3/83346/grounds-and-hotel-/old-tollgate-hotel-grounds-and-hotel-07-83346.jpg","BEST WESTERN Old Tollgate Hotel and Restaurant","Join us for a stay in Steyning! Just 10 miles from Brighton, amidst glorious countryside and a village setting of Bramber, BEST WESTERN Old Tollgate Hotel and Restaurant has an award-winning carvery, described by critics as 'visual a la carte', comfy-cosy rooms and standards of service that are as high as your spirits will be. We're also within easy reach of Gatwick Airport, which is handy for holidaymakers, and mainline stations. Many historic houses and gardens nearby can be found nearby (via motorway links) but at the foot of South Downs hills now a National Park with miles of walking, riding, fishing and golf nearby you might be tempted to stay closer to home! Address: The Street,Bramber,Steyning,West Sussex,BN44 3WE,England","www.awin1.com/pclick.php?p=105706682&a=123486&m=2671",,"2014-12-03","2014-12-03",76,0,0,76,1,2671,0,0,,"28/11/14 18:46",0,"Best Western Hotels","Accommodation^Hotels UK","--none--",1,0,0,0,0,0,,,
"Accommodation",1,"http://images.bestwestern.co.uk/awa2/image3/83351/grounds-and-hotel-/the-gonville-hotel-grounds-and-hotel-23-83351.jpg","BEST WESTERN PLUS The Gonville Hotel","Let us be the architects of a wonderful stay here in the centre of Cambridge! Overlooking a 25 acre open park, BEST WESTERN PLUS The Gonville Hotel offers easy access to the impressive buildings and stunning designs that make this university city, with free car parking an added bonus for getting out and about to points of interest such as Anglesy Abbey and Duxford Imperial Museum (both just 6 miles away). Our accessible accommodation is an ideal base for your stay or event, so whether you want to tour on foot or by public transport (or online with free WiFi!), you'll be perfectly placed to explore our wonderful surroundings. For entertainment value, Cambridge offer both! Pubs, restaurants and cafes cater for a wide range of tastes, and there are numerous nightlife opportunities all over the city from clubs and theatres to multiplex cinemas. Address: Gonville Place,Cambridge,Cambridgeshire,CB1 1LY,England","www.awin1.com/pclick.php?p=105706683&a=123486&m=2671",,"2014-12-03","2014-12-03",199,0,0,199,1,2671,0,0,,"28/11/14 18:46",0,"Best Western Hotels","Accommodation^Hotels UK","--none--",1,0,0,0,0,0,,,

Because the model number is the same causing the follow on model information to replace whatever was previous.

Must have unique model numbers to prevent that.

I am not creating unique data for v_products_model (ps anyone know how I can remove the data from the above post?)

Quote:

---

Originally Posted by mc12345678

Because the model number is the same causing the follow on model information to replace whatever was previous.

Must have unique model numbers to prevent that.

---

Hi thanks, yes suddenly found that, (should have looked better) apologies. Many thanks for confirming.

Quote:

---

Originally Posted by hols.club

I am not creating unique data for v_products_model (ps anyone know how I can remove the data from the above post?)

---

In your data setup, the first column.

how modified the file php for this...

you can give me a support or customize the file?

Quote:

---

Originally Posted by mc12345678

Errors captured/documented by EP4 are in an errorlog listed in the files to be imported/downloaded. New errors are added to the end of the file. If this file has been in the file list for a long time it may contain multiple errors that do not relate to the current issue.

Btw, I am not entirely sure that the code currently supports only a total of two columns being in the upload file. I would have to look to see what changes might be necessary to support that.

---

how modified the file for this

how delete the control

you can give me a support or customize?

Quote:

---

Originally Posted by salvo72

how modified the file for this

how delete the control

you can give me a support or customize?

---

Definitely the easypopulate4_import.php file in the admin directory would need revision. The extra_functions file may need some revision as well as possibly the main admin file... There are a few fields that were considered to be always present and were to be loaded at the start of processing. (The description field was one of them, but thtgot modified to preload, but ignore if not present in the data.) There were a few others that made sense and were a good practice to keep in the upload file because they made the line understandable to someone reviewing the file in the future. I think product name was one of them. Can that be coded out? Yes, but to include as an always situation leading to muliple users of the software being confused about the data that is maintained in the file, well that may cause more confusion for the masses instead of the few that would like to only upload two columns...

That may be more of a "one" site item to address instead of something to distribute for all. The description field was made not required because of the problems that were experienced by trying to upload very large amounts of information that wasn't changing each time. That was seen as a problem, not as an inconvenience. I would think that a strong case of removing the few required fields that are currently identified wouuld be appropriate to make that change.

Afterall, it seems that the data was there before, otherwise what was the process used to identify the rows that needed to be revised with the new data?

Quote:

---

Originally Posted by mc12345678

Definitely the easypopulate4_import.php file in the admin directory would need revision. The extra_functions file may need some revision as well as possibly the main admin file... There are a few fields that were considered to be always present and were to be loaded at the start of processing. (The description field was one of them, but thtgot modified to preload, but ignore if not present in the data.) There were a few others that made sense and were a good practice to keep in the upload file because they made the line understandable to someone reviewing the file in the future. I think product name was one of them. Can that be coded out? Yes, but to include as an always situation leading to muliple users of the software being confused about the data that is maintained in the file, well that may cause more confusion for the masses instead of the few that would like to only upload two columns...

That may be more of a "one" site item to address instead of something to distribute for all. The description field was made not required because of the problems that were experienced by trying to upload very large amounts of information that wasn't changing each time. That was seen as a problem, not as an inconvenience. I would think that a strong case of removing the few required fields that are currently identified wouuld be appropriate to make that change.

Afterall, it seems that the data was there before, otherwise what was the process used to identify the rows that needed to be revised with the new data?

---

yes
the data you have loaded a year ago

you can change the fiel import and delete the control that requires me to have more fields validated?

we need to import files for certain products of which we have the description

if you give me your email and if I can give you support sending the file to upload

thanks

For some reason the Model/Price/Qty does not import data, quantity or price!

I exported the PriceQty-EP2014Dec10-103644.csv, modified and imported it via PriceQty-EP2014Dec10-103644-TEST.csv. As you can see it did not update anything.
Where can I start to find out what is causing this?

Quote:

---

Import Results

Filename: PriceQty-EP2014Dec10-103644-TEST.csv
Finished Processing Import File

Updated records: 0
New Imported records: 0
Errors Detected: 0
Warnings Detected: 0
Memory Usage: 6688720
Memory Peak: 6938216
Execution Time: 0.00019407272338867 seconds.

---

ps. I am using Easy Populate 4.0.22 - Beta 6-10-2012 version.

Quote:

---

Originally Posted by Kevin205

For some reason the Model/Price/Qty does not import data, quantity or price!

I exported the PriceQty-EP2014Dec10-103644.csv, modified and imported it via PriceQty-EP2014Dec10-103644-TEST.csv. As you can see it did not update anything.
Where can I start to find out what is causing this?



ps. I am using Easy Populate 4.0.22 - Beta 6-10-2012 version.

---

My suggestion would be to review the csv file that is being provided to EP4/ZC using a plain text editor. Extra spaces before/after a column header, extra row from the top, etc... These types of things can cause the code to bail out. The code does not specifically look for that filename (yes was looking at the version described), but does have some fields that are expected as well. So could maybe provide a line or two from your file captured between code tags that are made by clicking the # symbol in the posting toolbar.

Quote:

---

Originally Posted by salvo72

yes
the data you have loaded a year ago

you can change the fiel import and delete the control that requires me to have more fields validated?

we need to import files for certain products of which we have the description

if you give me your email and if I can give you support sending the file to upload

thanks

---

Provided I still have a clickable link in my signature, contact can be made/initiated there to address potential customization of the code.

I am having an issue importing new files using Easy Populate 4.

When I import, it gives me errors for my new products. When I take a look at the debug log, it appears as though it has duplicated my v_products_upc column for each of my entries.

If there is an entry that already exists on my cart, it will update that one correctly, it's only giving an issue for the ones that are new.

I have attached the CSV file in question, as well as a screenshot of the debug log with the upc error. Help!

Attachment 14767
Attachment 14766

Quote:

---

Originally Posted by themusicstore

I am having an issue importing new files using Easy Populate 4.

When I import, it gives me errors for my new products. When I take a look at the debug log, it appears as though it has duplicated my v_products_upc column for each of my entries.

If there is an entry that already exists on my cart, it will update that one correctly, it's only giving an issue for the ones that are new.

I have attached the CSV file in question, as well as a screenshot of the debug log with the upc error. Help!

Attachment 14767
Attachment 14766

---

Have you added the upc field as an additional user defined column in your configuration panel? The code should automatically take care of considering that field if it has identified that you have the UPC mod installed (which I would presume you do). So you would remove that field from your configuration area in the admin and now should not have the field populated twice on the import... As for why it doesn't appear twice on the output is because, well, it already was in the data array initially and then when the system checked against the user defined field, it didn't have to do anything because it already existed...

Quote:

---

Originally Posted by mc12345678

My suggestion would be to review the csv file that is being provided to EP4/ZC using a plain text editor. Extra spaces before/after a column header, extra row from the top, etc... These types of things can cause the code to bail out. The code does not specifically look for that filename (yes was looking at the version described), but does have some fields that are expected as well. So could maybe provide a line or two from your file captured between code tags that are made by clicking the # symbol in the posting toolbar.

---

Copied using Notepad++

Code:

---

v_products_model,v_status,v_specials_price,v_specials_date_avail,v_specials_expires_date,v_products_price,v_products_msrp,v_products_quantity
XTO-7SS420524,1,,,,50,,1
JADI-P00059,1,,,,100,,119
JADI-P00060,1,,,,100,,82
JADI-P00061,1,,,,100,,68

---

Thank you.

Quote:

---

Originally Posted by Kevin205

Copied using Notepad++

Code:

---

v_products_model,v_status,v_specials_price,v_specials_date_avail,v_specials_expires_date,v_products_price,v_products_msrp,v_products_quantity
XTO-7SS420524,1,,,,50,,1
JADI-P00059,1,,,,100,,119
JADI-P00060,1,,,,100,,82
JADI-P00061,1,,,,100,,68

---

Thank you.

---

Not sure if somewhere in the process of providing the data for posting or if at all present, but there are no double quotes used. Not saying it is a must, but files do get successfully imported when they are there. I would suggest trying the following.m
Keep the first row and the second row. Place double quotes " around each word and double quotes without a space between empty commas with a final "" at the end of each line. Save that file (two lines) and try to upload it and report results. Also can compare the file to be uploaded to the file that was downloaded to see what differences exist in general fomatting.

Quote:

---

Originally Posted by mc12345678

Not sure if somewhere in the process of providing the data for posting or if at all present, but there are no double quotes used. Not saying it is a must, but files do get successfully imported when they are there. I would suggest trying the following.m
Keep the first row and the second row. Place double quotes " around each word and double quotes without a space between empty commas with a final "" at the end of each line. Save that file (two lines) and try to upload it and report results. Also can compare the file to be uploaded to the file that was downloaded to see what differences exist in general fomatting.

---

Sorry for the trouble. Issue fixed!
They use excel to export the .CSV files, and saved as type MAC instead of MS-DOS. Even though they look the same in Notepad++, it wasn't importing.

Furthermore files export with "", but it can be imported without the "".


Thank you.

Quote:

---

Originally Posted by Kevin205

Sorry for the trouble. Issue fixed!
They use excel to export the .CSV files, and saved as type MAC instead of MS-DOS. Even though they look the same in Notepad++, it wasn't importing.

Furthermore files export with "", but it can be imported without the "".


Thank you.

---

No problem, glad the issue has been resolved. Biggest issue I've seen with using Excel and EP4 has been the date format needs to be properly situated so that ZC accepts the input. OO seems to address it without issue. :)

Love this plugin and have used it for many years! I have it installed and working on my newly upgraded version 1.5.3. Thank you! I've downloaded my complete products file of almost 23,000 items - Complete Products (with Metatags). In the past I have used this file to modify and send to google, bing, etc. using the the Froogle download option. Of course they ask for the item URL. Since the v_products_url_1 column is not populated it will not work. Is there a way to download URLs for each product in the file? I've seen the Google product feeder but want to sort and submit different items to each search engine.

Keith z,
If not mistaken, the version 4.0.27+ discussed at this post: http://www.zen-cart.com/showthread.p...74#post1263574
Offers the capability to export the uri of the product. By default (after installation of EP4) this option is actually turned off. The product_uri_1 field you are seeing is the uri field at the bottom of a product entry form that would be displayed near the product when the product page is shown. It is not the uri that the browser displays say from the categories section to get to the product. Further the number 1 at the end identifies which language version of the field is being displayed. The product_uri field is available in multiple languages depending on what is installed to the cart.

So, to export the uri that is found in the browser when navigating to a product, would need to go to the admin's configuration for EP4 and turn the switch on ('Export URI with Prod and or Cat') that relates to displaying the product's uri. :) This option should be the last in the list of configuration options for EP4.

Thank you mc12345678. I am having trouble finding that switch. Here are the choices I have from my configuration screen. The last one allows me to enter User Defined Products Table Fields (comma delimited, no spaces). It is currently blank. Should I enter the header row columns here?


Title Value Action
Uploads Directory temp/ Info
Upload File Date Format m-d-y Info
Default Raw Time 09:00:00 Info
Upload/Download Prices Include Tax false Info
Verbose Feedback true Info
Make Zero Qty Products Inactive false Info
Smart Tags Replacement of Newlines true Info
Advanced Smart Tags false Info
Debug Logging true Info
Maximum Quantity Discounts 3 Info
Split On Number of Records 2000 Info
Script Execution Time 60 Info
Convert Curly Quotes, etc. 0 Info
Convert Character 0x92 1 Info
Enable Products Meta Data 1 Info
Enable Products Music Data 0 Info
User Defined Products Fields

Quote:

---

Originally Posted by keith z

Thank you mc12345678. I am having trouble finding that switch. Here are the choices I have from my configuration screen. The last one allows me to enter User Defined Products Table Fields (comma delimited, no spaces). It is currently blank. Should I enter the header row columns here?


Title Value Action
Uploads Directory temp/ Info
Upload File Date Format m-d-y Info
Default Raw Time 09:00:00 Info
Upload/Download Prices Include Tax false Info
Verbose Feedback true Info
Make Zero Qty Products Inactive false Info
Smart Tags Replacement of Newlines true Info
Advanced Smart Tags false Info
Debug Logging true Info
Maximum Quantity Discounts 3 Info
Split On Number of Records 2000 Info
Script Execution Time 60 Info
Convert Curly Quotes, etc. 0 Info
Convert Character 0x92 1 Info
Enable Products Meta Data 1 Info
Enable Products Music Data 0 Info
User Defined Products Fields

---

Nope.

Goto tools->Easy Populate v4
Top right corner select uninstall (this will lead to the default settings of the menu just posted above),
Then select install from the center of the screen. Goto the configuration menu for EP4 and as necessary re-enter the values shown above.
The last option is as described.

You do see that while in the tools->ep4 menu option that the version is 4.0.27 (or higher) correct?
Alternatively, it is possible to run a single sql statement for that one option, but the above process is preferred.

Mine is Easy Populate 4.0.24 - Beta 7-15-2014. Sorry show have listed that before.

Quote:

---

Originally Posted by keith z

Mine is Easy Populate 4.0.24 - Beta 7-15-2014. Sorry show have listed that before.

---

No problem, follow the link posted above to download version 4.0.27 (or whatever has been incorporated/posted by me) unfortunately chadderuski and I do not pay for service on that site, so we can't upload each other's content to the other site. Therefore, for now the code is a little out of sync between the two of us. I keep mine up-to-date with whatever is posted to the "main" version, but continue to add functionality as identified.

Most of the upgrades recently did not affect configuration menu options and therefore the code could simply be copied over the existing, but this upgrade added a menu option and at the moment that requires a soft "uninstall" and reinstall without removing the files.

Hi everyone, new to the forum.

I have EP4 and it is great except for working out the categories. In my old shop I have v_categories_name_1 and v_categories_name_2. Example is

v_categories_name_1..........v_categories_name_2
Audio & Video.....................Acoustic Foam
Audio & Video.....................Acoustic Foam
Audio & Video.....................Acoustic Foam

There are about 1350 items and many categories and sub categories. I understand how the Audio & Video^Acoustic Foam works but how can I import all these items without having to edit 1300+ lines of my spread sheet?

Is there a way to add the other category and upload like I did with the old version of Easy Populate? The reason I am using EP$ is that the other will not work on my new server due to the PHP version etc.

Hope someone can help.

Mike :)

I found a solution. Using excel formula like this one: =CONCATENATE(A1," ",C1) and also adding the ^ to the first row first using a simple formula.Attachment 14813

Quote:

---

Originally Posted by Mikec87

I found a solution. Using excel formula like this one: =CONCATENATE(A1," ",C1) and also adding the ^ to the first row first using a simple formula.Attachment 14813

---

To be carefule/cautious/clear, the goal is for the entire v_category_name text to be one word without spaces. Because we're sort of talking about math here, there are a number of ways to accomplish the task. The concatenate function is certainly one of them. In the case of joining two fields (columns) with a caret between the two, the following would be appropriate.

If v_category_name_1 is in column F and v_category_name_2 is in column G, and perhaps the last column of the spreadsheet is column V, then in column W row 2 one could place the following equation. =CONCATENATE(F2,"^",G2) then copy that equation down to the last row. Another such equation could be: =F2&"^"&G2
Then the values generated should be copied and special pasted back to either the original v_category_name_1 or back to itself so that the result (value) remains not the equation. If pasted back to itself, then be sure to remove the old version(s) of the column(s) before uploading.

If there are more subcategories such as v_category_name_3 in the old data, then it should be appended as well to the result from above.

A series of checks could be included in a single cell to address the multiple columns if they exist, hopefully not too deeply. Could test for the existence of content in a cell, and if there is, then concatenate that text, otherwise return the text from the earlier process.

For example without using exact code if there is appropriate content in cat_3, then concatenate(cat_1,"^",cat_2,"^",cat_3), else if there is appropriate content in cat_2, then concatenate(cat_1,"^",cat_2), else cat_1. (This method doesn't assign product(s) to "non-category" as if there is a cat_1, then every product must be in a cat_1 as all categories are to contain either categories or products, not both and that includes the root of the category tree.)

So, sum and total, one reason I posted the above is that if the equation in the OP's message is used, then a space is going to be added to the category name on one side or the other. Per the image, the sub-category will have a space before it. This is not desired and could lead to issues...

Quote:

---

Originally Posted by mc12345678

To be carefule/cautious/clear, the goal is for the entire v_category_name text to be one word without spaces. Because we're sort of talking about math here, there are a number of ways to accomplish the task. The concatenate function is certainly one of them. In the case of joining two fields (columns) with a caret between the two, the following would be appropriate.

If v_category_name_1 is in column F and v_category_name_2 is in column G, and perhaps the last column of the spreadsheet is column V, then in column W row 2 one could place the following equation. =CONCATENATE(F2,"^",G2) then copy that equation down to the last row. Another such equation could be: =F2&"^"&G2
Then the values generated should be copied and special pasted back to either the original v_category_name_1 or back to itself so that the result (value) remains not the equation. If pasted back to itself, then be sure to remove the old version(s) of the column(s) before uploading.

If there are more subcategories such as v_category_name_3 in the old data, then it should be appended as well to the result from above.

A series of checks could be included in a single cell to address the multiple columns if they exist, hopefully not too deeply. Could test for the existence of content in a cell, and if there is, then concatenate that text, otherwise return the text from the earlier process.

For example without using exact code if there is appropriate content in cat_3, then concatenate(cat_1,"^",cat_2,"^",cat_3), else if there is appropriate content in cat_2, then concatenate(cat_1,"^",cat_2), else cat_1. (This method doesn't assign product(s) to "non-category" as if there is a cat_1, then every product must be in a cat_1 as all categories are to contain either categories or products, not both and that includes the root of the category tree.)

So, sum and total, one reason I posted the above is that if the equation in the OP's message is used, then a space is going to be added to the category name on one side or the other. Per the image, the sub-category will have a space before it. This is not desired and could lead to issues...

---

Thank you for the reply. It worked the way I did it but I think the way you showed is faster.

My shop has all 1380+ items listed and it imported without a hitch. Thanks again :) Below is a link to my store.

http://www.southerncrossemporium.com.au/

Quote:

---

Originally Posted by Mikec87

Thank you for the reply. It worked the way I did it but I think the way you showed is faster.

My shop has all 1380+ items listed and it imported without a hitch. Thanks again :) Below is a link to my store.

http://www.southerncrossemporium.com.au/

---

Haven't been able to check the site for what I would like to try to verify, the mobile version of the template pretty much makes the site useless at least on my device as all that can be seen is the top banner of the menu with logo, etc... There is no room remaining to see product or other information, even the "menu" button "slides" out as one tries to scroll down which just takes up even more of the screen landscape. Otherwise, the code may include a trim of each category when importing to prevent a space from being prepended or appended to the category name. Otherwise, the number of categories in the store could grow by simply adding/removing a space.

For some, this utility is frequently used and having say an "equation" or a macro in one's back pocket can make the upload process go so smoothly whereas not having that extra "functionality" readily available can make the task seem tedious. If the upload is going to begin from the same format offile each time, then additional coding could be done to join those categories say based on the prefix of the filename and to ignore that the number typically corresponds to a language.

i have having problems installing EP1.2.5.7 on zencart 1.5.3
i uploaded everything in temEP folder to my zencart root folder, and everything in YOUR_ADMIN to my admin folder.

1, when i go to tools>easy populate, i get "Strange but there is no default language to work... That may not happen, just in case...
Warning 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"

2, there is no EP under the "configuration" tab.

3, i had to create an upload folder in the zencart root folder. i am unable to use /upload outside the zencart folder? where is the location of the upload folder specified?

i use sql patch to run the lines in install_sql line by line, but i cannot run the last 3 lines?

please help. thanks

Had the same issue I think it is bacaues it is not using MSQLI. I have moded the files to work for me.
note changed to use MSQLI and $db->link and default the custom fields.
I have attached a zip of the changed files. Attachment 14828
Back up the old Ezpopulate files then unzip the attached file.
Change the name of the admin file to your admin file name.
Copy over the changed files.

This is just the changes I made not a full set of ezpopulate file so you will need to install ezpopulate first.
Mark

Quote:

---

Originally Posted by w2e

i have having problems installing EP1.2.5.7 on zencart 1.5.3
i uploaded everything in temEP folder to my zencart root folder, and everything in YOUR_ADMIN to my admin folder.

1, when i go to tools>easy populate, i get "Strange but there is no default language to work... That may not happen, just in case...
Warning 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"

2, there is no EP under the "configuration" tab.

3, i had to create an upload folder in the zencart root folder. i am unable to use /upload outside the zencart folder? where is the location of the upload folder specified?

i use sql patch to run the lines in install_sql line by line, but i cannot run the last 3 lines?

please help. thanks

---

Quote:

---

Originally Posted by brittainmark

Had the same issue I think it is bacaues it is not using MSQLI. I have moded the files to work for me.
note changed to use MSQLI and $db->link and default the custom fields.
I have attached a zip of the changed files. Attachment 14828
Back up the old Ezpopulate files then unzip the attached file.
Change the name of the admin file to your admin file name.
Copy over the changed files.

This is just the changes I made not a full set of ezpopulate file so you will need to install ezpopulate first.
Mark

---

Also, recognize that the files disccused in these two posts have nothing to do with EP4, but an entirely different version of code that does something similar as the code discussed in this thread... Further discussion ofthe above should be taken to it's own thread either: http://www.zen-cart.com/showthread.p...-2-5-4-support or a new one.

The file changes posted above have no relation to EP4 and may (or may not) cause issues if "blindly" implemented with EP4... Truly the files have no business of being in this thread at all. EP4 has alreadybeen modified to workwith Zc 1.5.3, it still needs at least a minor tweak to work with ZC 1.5.4 as well aspossibly some added code to worrk along one of the new "tracking" features of ZC 1.5.4... But the first part is relatively easy/straight forward, the second needs some inspection still.

in the install file (EP4), it recommends i move the temp folder into admin, but never says what i need to do after i move?
now it cannot find my temp folder?

Quote:

---

Originally Posted by w2e

in the install file (EP4), it recommends i move the temp folder into admin, but never says what i need to do after i move?
now it cannot find my temp folder?

---

So, you obviously have your choice of tools, but you want to create a new folder or use an existing folder within the admin directory... Once the folder is created or the existing folder is identified, then you go into the configuration settings for EP4 and update the directory for the files entering the path to the folder as it relates to the root of your store. So, if in YOUR_ADMIN/EP4, then that is what would be entered where I have used YOUR_ADMIN to represent actual folder name of the secret admin directory that you use.

The reason for this is that 1) EP4 is an admin only plugin, 2) your admin directory is not known to anyone other than you and those granted access, 3) there are already protections in place for the admin directory to minimize prying eyes getting to the data, 4) the content and detail of the products may not be desirable to have available to all (ie, if the store is setup to require login, or if values are entered pre-markup, etc...)

That help? If still having issues, please provide the content of your configuration settings without divulging admin specific information (please identify what is taking the place of the secret admin info ie. The folder admin represents my admin directory and I have verified that the name I have entered in exists.)

how to i choose a download directory on my pc when i download from EP4?
i do not see any settings in configuration, and it automatically downloaded without asking me?

Quote:

---

Originally Posted by w2e

how to i choose a download directory on my pc when i download from EP4?
i do not see any settings in configuration, and it automatically downloaded without asking me?

---

If the download from your site to your local pc is what you are referring, that is more of a browser specific issue... Some browsers automatically download to the download directory of the user's profile, some ask the user what they would like to do with the file: ie, open it with a specific program, save it, save it to a specific directory, etc... If you are talking about that you are currently "running" the site on a local computer and you have selected to export a file type, then it will download to the directory identified in the configuration settings that of course is on your local computer (as the site is on your local computer.) To answer the question a little better, would need more detailed information.

how come when i export a file, it is automatically owned by "nobody"?
when i click download, i get "You don't have permission to access *.* on this server?" even if i chown, and chmod to 777, i still cannot download the file?
(i moved /temp into admin, and i have no problem opening EP4)

Quote:

---

Originally Posted by w2e

how come when i export a file, it is automatically owned by "nobody"?
when i click download, i get "You don't have permission to access *.* on this server?" even if i chown, and chmod to 777, i still cannot download the file?
(i moved /temp into admin, and i have no problem opening EP4)

---

Believe either in the little bit of direction provided or definitely in this forum, if you check your .htaccess rules and ensure that you are not preventing .csv files from being transferred/read... Would look for/see: jpg |gif etc...

Quote:

---

Originally Posted by w2e

how come when i export a file, it is automatically owned by "nobody"?
when i click download, i get "You don't have permission to access *.* on this server?" even if i chown, and chmod to 777, i still cannot download the file?

---

That's a consequence of how your hosting company configured your webserver. Contact them for help in understanding why they did that. (It's an old-style configuration, which might suggest your server could use some modernization to keep up with the times.)

Quote:

---

Originally Posted by DrByte

That's a consequence of how your hosting company configured your webserver. Contact them for help in understanding why they did that. (It's an old-style configuration, which might suggest your server could use some modernization to keep up with the times.)

---

Or perhaps a BETTER more MODERN webhost is in order..

Quote:

---

Originally Posted by DrByte

That's a consequence of how your hosting company configured your webserver. Contact them for help in understanding why they did that. (It's an old-style configuration, which might suggest your server could use some modernization to keep up with the times.)

---

thing is that after i manually chown and chmod, i still cannot download...?

Not surprised. User 'nobody' has restrictions.
It's a server thing.

The root user might have to alter the permissions in order to have them take effect.
Or, the hosting company could change the way Apache is configured so that stops happening, but that change affects other users and has security implications, and if the server administrator doesn't know much about security then they'll probably refuse to make the change.

Quote:

---

Originally Posted by w2e

thing is that after i manually chown and chmod, i still cannot download...?

---

In the meantime (and sorry to push through for operation) it should be possible for you to ftp the file(s) off of the server, or if the utility to edit the file(s) is able to "safely" do so they could be manipulated remotely. Whatever the case, it appears that cause of the current problem has been identified to be unrelated to EP4, is a server side issue, and something is to be done about it. I say though, why stop progress when it is possible to move on even if it has some difficulties for now... :) just your friendly neighborhood cheer crowd to keep you going. :)

Version 4.0.28 has been posted to github. This version accomplishes two actions. 1) will bypass the use of mb_internal_encoding if it is not activated. A message (although not large) will be present on the EP4 admin tools window.. The effects of not having this functionality implemented (site/server/php.ini related) does not appear to be heavily documented; however, routine functionality remains. 2) The code has been modified to open (extend) functionality to all versions of ZC at or above 1.5.3. Again, this is an extension of functionality, no functionality has been removed from previous versions of ZC... There are 2 new files that will need to be installed if not previously installed by other plugins. They are based/named from what was published by lat9. There were a few minor corrections made to the commented text, but no change to functionality. EP4 will send tracking requests for all insertion and update actions made to the database.

Anyways, 4.0.28 may be obtained from: https://github.com/mc12345678/EasyPopulate-4.0 currently, but hopefully from: https://github.com/chaddro/EasyPopulate-4.0. General directions are provided in the first post of this thread.

There are no configuration window changes made from 4.0.27; however, if the option to Export URI with Prod and or Cat is not in your list of configuration options, then upon copy of the files to your server, it would be recommended to select the uninstall followed by install links when at the tools->Easy Populate 4 window.

Otherwise, file replacement/upload is all that is necessary to upgrade from 4.0.27 to 4.0.28. Again, the updated code will still work on older versions of ZC, but now will also work on ZC 1.5.4.

Hello,

I am adding new products to my site, I am adding the model and image manually and then doing an update with Easy Populate 4 to fill in the name, description, quantity, weight, and price in that order using open office with.

Character set: Unicode (UTF-8)
Separated by: Comma Text delimiter "

Everything except the description is updating fine. I am using v_products_description_1 with no spaces before or after, every once in awhile it will update properly.

I am using

Zen Cart 1.5.3
Easy Populate 4.0.24 Beta 7-15-2014
PHP 5.4.29 (zend2.4.0)
MySQL 5.5.36-cll-lve
Host Webdev Fish

I had my store installed by New Age Wholesale, from the best I can tell they used Zen Cart 1.5.0 on 5/27/2012 and then updated to 1.5.1 then 1.5.2 then to 1.5.3 all updates were performed on 7/17/2014. I had the store installed about 2 months ago.
I have found no debug logs.

If you need it my URL is www.3rdips.com
This is my first website and I am and I am very new at this so I don't know if I am making a mistake or if there is some other issue

Thank you.

Quote:

---

Originally Posted by Third Eye

Hello,

I am adding new products to my site, I am adding the model and image manually and then doing an update with Easy Populate 4 to fill in the name, description, quantity, weight, and price in that order using open office with.

Character set: Unicode (UTF-8)
Separated by: Comma Text delimiter "

Everything except the description is updating fine. I am using v_products_description_1 with no spaces before or after, every once in awhile it will update properly.

I am using

Zen Cart 1.5.3
Easy Populate 4.0.24 Beta 7-15-2014
PHP 5.4.29 (zend2.4.0)
MySQL 5.5.36-cll-lve
Host Webdev Fish

I had my store installed by New Age Wholesale, from the best I can tell they used Zen Cart 1.5.0 on 5/27/2012 and then updated to 1.5.1 then 1.5.2 then to 1.5.3 all updates were performed on 7/17/2014. I had the store installed about 2 months ago.
I have found no debug logs.

If you need it my URL is www.3rdips.com
This is my first website and I am and I am very new at this so I don't know if I am making a mistake or if there is some other issue

Thank you.

---

Thank you for the detail. A quick sidenote, the various versions of update that all happened on one day is a result of a database upgrade (expected output); however, the timing doesn't seem right with the rest of the description. I don't think though that the fact that they passed on a previously built database is the cause of your current issue.

Would you be able to provide at least two rows of data (plus headers), where at least one row is successful and at least one row is not with regards to the description_1 field? My guess is that there are special characters included in the unsuccessful row that are not properly escaped before saving the file.

Asked in another forum:

Quote:

---

Originally Posted by w2e

so what is the column v_products_url_1 (EP4) for?

---

This is the language specific uri that is available at the bottom of a product info page to typically be used for taking a customer to another page related to the product.

i am having a hard time getting the product urls for google data feed.

i use the 'v_products_url_1' column to assign URL for upload/import.
the uri mapping evidently does not use the url i assign. e.g., 6.5" is converted to '6.5-' instead of '6.5in-' i assigned in the upload file. (not to mention for each and every product to have uri mapping, i have to go to catalog/product and preview/save?)

when i export and download, i get exactly what i uploaded, which are not the working urls.
so how do i get the product urls?

Quote:

---

Originally Posted by w2e

i am having a hard time getting the product urls for google data feed.

i use the 'v_products_url_1' column to assign URL for upload/import.
the uri mapping evidently does not use the url i assign. e.g., 6.5" is converted to '6.5-' instead of '6.5in-' i assigned in the upload file. (not to mention for each and every product to have uri mapping, i have to go to catalog/product and preview/save?)

when i export and download, i get exactly what i uploaded, which are not the working urls.
so how do i get the product urls?

---

A lot going on in that statement... I'll take a stab at what I understand, but please, more clarification is necessary...

v_products_url_1 is a field that is truly products_uri in I think the products_description table of the database. That field is language specific. It is a field available at the bottom of a standard ZC installation where it says: products_url typically with a flag adjacent to it. There are admin options to display that field on the product information page of the store...

So, now comes the use of that field in EP4...

if you are entering 6.5" as part of your text in Open Office, Open office will not convert that into inches or anything else.. And in fact, it may cause a problem, because it is not escaped (6.5\"). The version of EP4 that is discussed/provided in this forum does not do URI remapping... A version of EP4 exists that does, but that's about as much as I'm allowed to state here..

If you want to obtain the URI that one sees from the store, there has been a feature implemented (I forget which version somewhere between 4.0.24 and 4.0.28 (most current), that will add an additional field to the end of the product export field list which uses the ZC code of creating the store side URI. I think the field created is v_uri, but I could be wrong as it's been a while since I added that feature... The option to export such a URI is provided in the configuration settings after said version (or more recent) has been installed. Because the change affects the configuration menu, the program is to be uninstalled and reinstalled via database action only (top right corner of the tools->EP4 window, followed by the install option in the middle of the same window) This action will reset the configuration settings back to their default, so take note of them before uninstalling... (ie. folder for file storage/retrieval as well as the other settings).

the version i use is 4.0.24 which was just downloaded/installed a few days ago.
i exported/downloaded complete products/specific category/active, but i only see 'v_products_url_1' right after the description column.

so i have to reinstall newer version of EP4?

Quote:

---

Originally Posted by w2e

the version i use is 4.0.24 which was just downloaded/installed a few days ago.
i exported/downloaded complete products/specific category/active, but i only see 'v_products_url_1' right after the description column.

so i have to reinstall newer version of EP4?

---

Yes, the github repository that is referenced at the beginning of this thread (and identified at least once on the previous page) has been updated (I think it was yesterday) to the current version of 4.0.28 which is also ZC 1.5.4 compatible. That version includes the export feature as well as other features discussed over the past couple of pages. Assuming there has been no personalized modifications the file reinstall will simply be an overwrite of the existing core files (no need to reupload the 1.5.x special file) as well as the additional files that are present (folder structure is as necessary), then uninstall/reinstall as provided in my previous post. Previous ZC compatibility and functionality remains the same, the code now supports additional features.

PS, the version was 4.0.27 as discussed a couple pages back: http://www.zen-cart.com/showthread.p...99#post1267699

BTW, a correction, the field generated is: v_html_uri

After export, that field name can be renamed to whatever is necessary for subsequent upload to whatever utility/tool, but remember that if it will match an existing field, that other "non-desired" field/column needs to be renamed/removed...

how do i keep admin panel logged in?
i set it in config to be 86400 sec, but it still keeps logging me out some every 10-20 minutes?

Quote:

---

Originally Posted by w2e

how do i keep admin panel logged in?
i set it in config to be 86400 sec, but it still keeps logging me out some every 10-20 minutes?

---

And in further effort to potentially make the site unsecure, turned off the pci timeout requirements that became available in ZC1.5.4 under configuration->my store?

I've downloaded a cvs sheet and added an additional category column v_categories_name_2
I tried uploading the test product with Easy Populate 4.0.22 - Beta 6-10-2012. but the second category is not showing up on the listing.
I've tested it a couple different ways with no success.
Am I configuring the column correctly?

Quote:

---

Originally Posted by mc12345678

Thank you for the detail. A quick sidenote, the various versions of update that all happened on one day is a result of a database upgrade (expected output); however, the timing doesn't seem right with the rest of the description. I don't think though that the fact that they passed on a previously built database is the cause of your current issue.

Would you be able to provide at least two rows of data (plus headers), where at least one row is successful and at least one row is not with regards to the description_1 field? My guess is that there are special characters included in the unsuccessful row that are not properly escaped before saving the file.

---

Here are a few lines that did not work

BBBLGOD Goddess leather w/ latch Bound in hand-stitched, green dyed leather, this book displays two images of the Goddess, portraying her as both the nurturing mother of life and the vengeful destroyer. Contains 280 unlined pages. 5" x 7" 11 1.1 39.95
BBBLGRI45 Griffins leather w/ latch Hand tooled blank leather journal with embossed Griffins. Border & rear cover embossing may vary. Sizes vary slightly. Leather, handmade paper. 220 pages, latch closure. 4 1/2ﾔ x 5ﾔ 15 0.55 18.95
BBBLGRIXL Fighting Griffin leather w/ latch Leather bound, this blank book seems fit for a library of ancient codex with finely tooled scrollwork and the image of a rearing Griffin on its cover. This makes a fantastic setting for your Book of Shadows, diary, or journal. Contains 240 unlined pages. 10" x 13". 5 2.5 50


Here are a couple that did work

BBBLEPO45 Epona leather w/ latch Hand tooled blank leather journal with Celtic horses circling on the front. Border & rear embossing may vary. Sizes vary slightly. Leather, handmade paper. 240 pages, latch closure. 4 1/2ﾔ x 5ﾔ 5 0.55 18.95
BBBLF448 Fairy leather w/ latch Hand tooled blank leather journal with a fairy picking flowers on the front. Border & rear embossing may vary. Sizes vary slightly. Leather, handmade paper. 240 pages, latch closure. 6ﾔ x 8ﾔ 36 1.2 34.95
BBBLF710 Fairy leather w/ latch Hand tooled lined leather journal with embossed fairy. Border & backside embossing may vary. Size may vary slightly. Leather, handmade paper. 240 pages, latch closure. 7ﾔ x 10ﾔ 6 1.6 28.95
BBBLFLO Flower leather w/ latch Hand tooled blank leather journal with varied floral embossing. Border embossing may vary. Size may vary slightly. Leather, handmade paper. 240 pages, latch closure. 3 1/4ﾔﾔ x 4ﾔ 36 0.4 12
BBBLFOX Fox leather w/ latch Hand tooled blank leather journal with heavily embossed covers showing foxes, leaves and knot work. Art by Jen Delyth. Sizes vary slightly. Leather, handmade paper. 272 pages, latch closure. 5ﾔ x 7ﾔ 24 1.21 39.95

Quote:

---

Originally Posted by Third Eye

Here are a few lines that did not work

BBBLGOD Goddess leather w/ latch Bound in hand-stitched, green dyed leather, this book displays two images of the Goddess, portraying her as both the nurturing mother of life and the vengeful destroyer. Contains 280 unlined pages. 5" x 7" 11 1.1 39.95
BBBLGRI45 Griffins leather w/ latch Hand tooled blank leather journal with embossed Griffins. Border & rear cover embossing may vary. Sizes vary slightly. Leather, handmade paper. 220 pages, latch closure. 4 1/2ﾔ x 5ﾔ 15 0.55 18.95
BBBLGRIXL Fighting Griffin leather w/ latch Leather bound, this blank book seems fit for a library of ancient codex with finely tooled scrollwork and the image of a rearing Griffin on its cover. This makes a fantastic setting for your Book of Shadows, diary, or journal. Contains 240 unlined pages. 10" x 13". 5 2.5 50


Here are a couple that did work

BBBLEPO45 Epona leather w/ latch Hand tooled blank leather journal with Celtic horses circling on the front. Border & rear embossing may vary. Sizes vary slightly. Leather, handmade paper. 240 pages, latch closure. 4 1/2ﾔ x 5ﾔ 5 0.55 18.95
BBBLF448 Fairy leather w/ latch Hand tooled blank leather journal with a fairy picking flowers on the front. Border & rear embossing may vary. Sizes vary slightly. Leather, handmade paper. 240 pages, latch closure. 6ﾔ x 8ﾔ 36 1.2 34.95
BBBLF710 Fairy leather w/ latch Hand tooled lined leather journal with embossed fairy. Border & backside embossing may vary. Size may vary slightly. Leather, handmade paper. 240 pages, latch closure. 7ﾔ x 10ﾔ 6 1.6 28.95
BBBLFLO Flower leather w/ latch Hand tooled blank leather journal with varied floral embossing. Border embossing may vary. Size may vary slightly. Leather, handmade paper. 240 pages, latch closure. 3 1/4ﾔﾔ x 4ﾔ 36 0.4 12
BBBLFOX Fox leather w/ latch Hand tooled blank leather journal with heavily embossed covers showing foxes, leaves and knot work. Art by Jen Delyth. Sizes vary slightly. Leather, handmade paper. 272 pages, latch closure. 5ﾔ x 7ﾔ 24 1.21 39.95

---

As suspected,characters are included in the ones that don't work that need to be escaped while the content is still in OpenOffice or whatever spreadsheet/text editor is being used. For example:
10" x 13"
Should be:
10\" x 13\"

When viewed in the editor. This way when the content is read in, the quotes aren't treated as other characters...

Now I'm not sure why the ones that do work look so odd in this forum, but they are obviously not straight characters for lack of correct terminology.

Another question asked about this program earlier:

Quote:

---

Originally Posted by 14all41

I've downloaded a cvs sheet and added an additional category column v_categories_name_2
I tried uploading the test product with Easy Populate 4.0.22 - Beta 6-10-2012. but the second category is not showing up on the listing.
I've tested it a couple different ways with no success.
Am I configuring the column correctly?

---

Besides being rather significantly old/missing additional features and still compatible with the existing software, as described several times in this forum (even as recently as the previous page), the number at the end of a field name represents the language to which that field is associated... So, if you have a second language that has a language id of 2, then upload of that information would populate that language's version of that field...

Perhaps you could 1) explain what it is you are trying to do, or 2) export your current database, perform the action you want to see happen to/for a product, then export the database again and compare the records applicable to the change(s), then duplicate those actions/changes to the data that is to be uploaded...

Quote:

---

Originally Posted by mc12345678

As suspected,characters are included in the ones that don't work that need to be escaped while the content is still in OpenOffice or whatever spreadsheet/text editor is being used. For example:
10" x 13"
Should be:
10\" x 13\"

When viewed in the editor. This way when the content is read in, the quotes aren't treated as other characters...

Now I'm not sure why the ones that do work look so odd in this forum, but they are obviously not straight characters for lack of correct terminology.

---

I just uploaded and imported this in open office, I had no errors and everything indicated that it updated properly, but the description still did not update. any other ideas?

v_products_model v_products_name v_products_description_1 v_products_quantity v_products_weight v_products_price
BBBLG229 Greenman leather w/ latch Hand tooled blank leather journal with a large Greenman on the front. Border & rear embossing may vary. Sizes vary slightly. Leather, handmade paper. 240 pages, latch closure. 6\” x 8\” 6 1.2 34.95
BBBLGOD Goddess leather w/ latch Bound in hand-stitched, green dyed leather, this book displays two images of the Goddess, portraying her as both the nurturing mother of life and the vengeful destroyer. Contains 280 unlined pages. 5\" x 7\" 11 1.1 39.95
BBBLGRI45 Griffins leather w/ latch Hand tooled blank leather journal with embossed Griffins. Border & rear cover embossing may vary. Sizes vary slightly. Leather, handmade paper. 220 pages, latch closure. 4 1/2\” x 5\” 15 0.55 18.95
BBBLGRIXL Fighting Griffin leather w/ latch Leather bound, this blank book seems fit for a library of ancient codex with finely tooled scrollwork and the image of a rearing Griffin on its cover. This makes a fantastic setting for your Book of Shadows, diary, or journal. Contains 240 unlined pages. 10\" x 13\". 5 2.5 50
BBBLHEA Hearts leather w/ latch Hand tooled lined leather journal with heavy, medieval styled embossing, may vary. Size may vary slightly. Leather, handmade paper. 240 pages, Latch closure. 5 1/2\” x 8 1/4\” 8 1.3 39.95
BBBLOWL Owl leather w/ latch Hand tooled blank leather journal showing an Owl & Lady connected by knot work. Art by Jen Delyth. Size may vary slightly. Leather, handmade paper. 272 pages, latch closure. 5\” x 7\” 33 1.1 39.95
BBBLP284 Pentagram leather w/ latch Hand tooled blank leather journal with embossed, interwoven pentacle & flower. Border embossing may vary. Sizes vary slightly. Leather, handmade paper. 240 pages, latch closure. 7\” x 10\” 24 2.2 49.95

So, I was wrong about how to resolve this issue. It is clear that generally speaking the upload works as some descriptions get uploaded, but some do not. Therefore there is something "wrong" with the ones that do not upload. Fom what can be seen of the records pasted into the forum there is a difference in symbols used after numbers intended to represent dimensions.

I have asked via PM to be forwarded a copy of a file containing records that don't work and a few that do to try to resolve locally duplicating the conditions identified above. I will post my findings upon resolution. Thank you for your understanding, it seemed like the escape code would work, but again, I was wrong as it didn't.

Quote:

---

Originally Posted by mc12345678

Another question asked about this program earlier:


Besides being rather significantly old/missing additional features and still compatible with the existing software, as described several times in this forum (even as recently as the previous page), the number at the end of a field name represents the language to which that field is associated... So, if you have a second language that has a language id of 2, then upload of that information would populate that language's version of that field...

Perhaps you could 1) explain what it is you are trying to do, or 2) export your current database, perform the action you want to see happen to/for a product, then export the database again and compare the records applicable to the change(s), then duplicate those actions/changes to the data that is to be uploaded...

---

Now I'll admit that I don't spend time reading this thread, but that would be because I haven't had any issues with this old version of EP. It still works great. I'm just trying something different than what I've done in the past.
Let me add the searching the forum has not answered my question either.
It is good to know that there have been many improvements to EP. Thank you for sharing that.
I do plan to upgrade to EP the latest version. Perhaps you could briefly describe
how to layout the cvs sheet columns for (EP 4) to have an item display in a sub category and then also display in the parent category (if possible).

Quote:

---

Originally Posted by 14all41

Now I'll admit that I don't spend time reading this thread, but that would be because I haven't had any issues with this old version of EP. It still works great. I'm just trying something different than what I've done in the past.
Let me add the searching the forum has not answered my question either.
It is good to know that there have been many improvements to EP. Thank you for sharing that.
I do plan to upgrade to EP the latest version. Perhaps you could briefly describe
how to layout the cvs sheet columns for (EP 4) to have an item display in a sub category and then also display in the parent category (if possible).

---

No disagreement there that even the older version(s) work well. It's one reason I stuck with using it and doing what I could to keep it functional.

As for searching? Yeah I believe there are some things in the site left to be desired, but it works.

So, regarding the question at hand. Please correct me if I misunderstood, but it seems as if you would like to have a product listed in a category that has subcategories. If that is the case, ZC doesn't support that. Perhaps though you are asking for a product to be linked?

Explanation: categories either contain products or sub-categories, not both

Quote:

---

Originally Posted by mc12345678

No disagreement there that even the older version(s) work well. It's one reason I stuck with using it and doing what I could to keep it functional.

As for searching? Yeah I believe there are some things in the site left to be desired, but it works.

So, regarding the question at hand. Please correct me if I misunderstood, but it seems as if you would like to have a product listed in a category that has subcategories. If that is the case, ZC doesn't support that. Perhaps though you are asking for a product to be linked?

Explanation: categories either contain products or sub-categories, not both

---

Yes you understood correctly and i agree zen cart does not support that. Which I did not realize until today, never tried it before.
Is there a way to list the product in a two different subcategories at the same time?
IE list in, category: apple, subcategory: iphone4. Also list the product in category: apple, subcategory: all apple
What would that look like on the cvs sheet?

Quote:

---

Originally Posted by 14all41

Is there a way to list the product in a two different subcategories at the same time?

---

Yes. In the database, the extra subcategories would be reflected as additional records in the products_to_categories table.

Quote:

---

Originally Posted by DrByte

Yes. In the database, the extra subcategories would be reflected as additional records in the products_to_categories table.

---

I get 4.0 installed and try that out. Thank you.

Quote:

---

Originally Posted by 14all41

Yes you understood correctly and i agree zen cart does not support that. Which I did not realize until today, never tried it before.
Is there a way to list the product in a two different subcategories at the same time?
IE list in, category: apple, subcategory: iphone4. Also list the product in category: apple, subcategory: all apple
What would that look like on the cvs sheet?

---

Been a little while since I have looked at how/if linked products are supported (properly), but may need to include the mastercategories field may be necessary, but when creating a product, the categories are populated with the main/top category followed by the sub-category of that category with a single carat (^) between the two. I thought that if you added a new row with all of the same information, and thenmodified the categories structure then that product would be populated in that subcategory as well... The problem comes in if on export, both "products" are provided, and a change made to the first "product". The second occurrence of the same product will overwrite the original change with a new change when the file is uploaded with both rows still in the database.

So, in answer to the question if not mistaken, to create a linked product, export the database, change the category information for the product to be linked, import the database/or changed line, and now the product appears in two sub-categories.

Quote:

---

Originally Posted by Third Eye

I just uploaded and imported this in open office, I had no errors and everything indicated that it updated properly, but the description still did not update. any other ideas?

v_products_model v_products_name v_products_description_1 v_products_quantity v_products_weight v_products_price
BBBLG229 Greenman leather w/ latch Hand tooled blank leather journal with a large Greenman on the front. Border & rear embossing may vary. Sizes vary slightly. Leather, handmade paper. 240 pages, latch closure. 6\” x 8\” 6 1.2 34.95
BBBLGOD Goddess leather w/ latch Bound in hand-stitched, green dyed leather, this book displays two images of the Goddess, portraying her as both the nurturing mother of life and the vengeful destroyer. Contains 280 unlined pages. 5\" x 7\" 11 1.1 39.95
BBBLGRI45 Griffins leather w/ latch Hand tooled blank leather journal with embossed Griffins. Border & rear cover embossing may vary. Sizes vary slightly. Leather, handmade paper. 220 pages, latch closure. 4 1/2\” x 5\” 15 0.55 18.95
BBBLGRIXL Fighting Griffin leather w/ latch Leather bound, this blank book seems fit for a library of ancient codex with finely tooled scrollwork and the image of a rearing Griffin on its cover. This makes a fantastic setting for your Book of Shadows, diary, or journal. Contains 240 unlined pages. 10\" x 13\". 5 2.5 50
BBBLHEA Hearts leather w/ latch Hand tooled lined leather journal with heavy, medieval styled embossing, may vary. Size may vary slightly. Leather, handmade paper. 240 pages, Latch closure. 5 1/2\” x 8 1/4\” 8 1.3 39.95
BBBLOWL Owl leather w/ latch Hand tooled blank leather journal showing an Owl & Lady connected by knot work. Art by Jen Delyth. Size may vary slightly. Leather, handmade paper. 272 pages, latch closure. 5\” x 7\” 33 1.1 39.95
BBBLP284 Pentagram leather w/ latch Hand tooled blank leather journal with embossed, interwoven pentacle & flower. Border embossing may vary. Sizes vary slightly. Leather, handmade paper. 240 pages, latch closure. 7\” x 10\” 24 2.2 49.95

---

Quote:

---

Originally Posted by mc12345678

So, I was wrong about how to resolve this issue. It is clear that generally speaking the upload works as some descriptions get uploaded, but some do not. Therefore there is something "wrong" with the ones that do not upload. Fom what can be seen of the records pasted into the forum there is a difference in symbols used after numbers intended to represent dimensions.

I have asked via PM to be forwarded a copy of a file containing records that don't work and a few that do to try to resolve locally duplicating the conditions identified above. I will post my findings upon resolution. Thank you for your understanding, it seemed like the escape code would work, but again, I was wrong as it didn't.

---

Ugh.. So, it should have been obvious to other users of this module, but it appears that the majority of the issues have been addressed regarding the above partial list of records. Sometimes when thinking the data is working or not, it's possible to overlook other aspects of the file. For example, the column heading for product_name looks correct; however, after further consideration, that data field is a language dependent field. In EP4, language dependent fields are to include a language identifier. Currently that identifier is a number that corresponds with the number adjacent to the language in the admin panel.

So, in this case, with v_product_name renamed to v_product_name_1, the issue was resolved... Ideally

This type of problem is avoidable by exporting a file to obtain the headers before making changes to be uploaded.