-
Re: EasyPopulate 4.0 Support Thread
Hi Stellarweb,
I've been reading through what you guys have been doing to try and solve your problem. I've of the mind that we should take a phpMyAdmin full sql backup and try to restore that into another site's testing database. This should tell us if we have:
1. code related issue
2. database related issue
3. server related issue.
not everything would be perfect for this test since you might have other mods installed, but it may help to diagnose your issue.
Did you attempt to install zencart in a new sub-directory, install only EP4 and test?
-
Re: EasyPopulate 4.0 Support Thread
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
chadderuski
Hi Stellarweb,
I've been reading through what you guys have been doing to try and solve your problem. I've of the mind that we should take a phpMyAdmin full sql backup and try to restore that into another site's testing database. This should tell us if we have:
1. code related issue
2. database related issue
3. server related issue.
not everything would be perfect for this test since you might have other mods installed, but it may help to diagnose your issue.
Did you attempt to install zencart in a new sub-directory, install only EP4 and test?
-
Re: EasyPopulate 4.0 Support Thread
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.
BTW, at this time Ultimate SEO URL's is not considered compatible with ZC 1.5.3 or at least hasn't been updated to be compatible. The latest author has a BETA version in testing, but the ZC site version does not yet include the revisions that were made to integrate with the latest database handling and other changes to the "common" core files. (Discovered this last part by performing a merge with the latest ZC 1.5.3 files to see what was different/needed.) Haven't looked as to why these replaced files caused the result(s) that we saw, but certainly did not support proper operation of ZC 1.5.3 to use the files of an older version of ZC (Files from ZC 1.5.1 and below that manage/interact with the database require updating to work under ZC1.5.3)
-
Re: EasyPopulate 4.0 Support Thread
When I export Model/Price/Qty (PriceQTY-EP) through EP4; it pulls 14 duplicates records with the same "v_products_model". When I check table zen_products, there are only 14 unique of those products_model!
What could cause this?
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
Kevin205
When I export Model/Price/Qty (PriceQTY-EP) through EP4; it pulls 14 duplicates records with the same "v_products_model". When I check table zen_products, there are only 14 unique of those products_model!
What could cause this?
Without reviewing the code for tht specific query, if the product(s) are linked then this is the likely cause. That would not be identifiable from looking at the product(s) table.
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
mc12345678
Without reviewing the code for tht specific query, if the product(s) are linked then this is the likely cause. That would not be identifiable from looking at the product(s) table.
That's it. It is pulling the additional 14 records from the linked products.
Thank you.
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
Kevin205
That's it. It is pulling the additional 14 records from the linked products.
Thank you.
Glad to help. It does raise the question of if there is any value in the query returning all linked products/if there is enough information available in the query response to modify it to return a distinct result?
That said, for uploading, you can keep the entire list of duplicates present, just realize that the last entry is the one that will "stick". Not ideal for processing time, but the microseconds involved and the additional queries to the database, mmay be shorter in time than the editing/filtering involved on each export.
-
Re: EasyPopulate 4.0 Support Thread
I created custom text fields using phpMyAdmin. I added the field names under Admin>Configuration Management>Easy Populate 4>user Defined Fields making sure to include a comma without any spaces between each field name. I then went through the steps to import the data from the newly created fields. EP 4.0 indicated that all of the records were updated without any errors; but, when I went into phpMyAdmin to confirm, I discovered that none of the custom data was imported. What am I missing?
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
FoodSourceDirect
I created custom text fields using phpMyAdmin. I added the field names under Admin>Configuration Management>Easy Populate 4>user Defined Fields making sure to include a comma without any spaces between each field name. I then went through the steps to import the data from the newly created fields. EP 4.0 indicated that all of the records were updated without any errors; but, when I went into phpMyAdmin to confirm, I discovered that none of the custom data was imported. What am I missing?
1) Into which table(s) were custom fields entered?
2) When populating the configuration field was the v_ incorrectly included or was it correctly removed. Ie. products_id (correct) instead of v_products_id (incorrect)
3) Which import/export type was performed? (Btw, the field(s) should also export if all things are correct for the applicable data dump.)
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
mc12345678
If you are trying to export an additional field that is located in your products table and you are using EasyPopulate ver 4, that is not the way to do it. If you look in the admin panel, configuration, Easy Populate 4. There is a custom field text box. In that text box, enter the field name which appears to be products_price_w. Then on export/import that field will populatein both directions. If you need more than one field added, then separate the field(s) with a comma.
Thank you. I went to admin panel > config > EP and added products_price_w. It worked perfectly :)
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
nesum18
Thank you. I went to admin panel > config > EP and added products_price_w. It worked perfectly :)
Glad that worked out for you! And thank you for reporting back.
-
2 Attachment(s)
Re: EasyPopulate 4.0 Support Thread
Hi MC:
I imported the data into the product table.
The "v_" was not included.
I used the FULL-EP template. The CSV file that I created and used was formated ( a ##############) of the FULL-EP "Complete Products (with Metatags)" under "Product & Pricing Export/Import Options:"
I have included a screenshot of the user defined fields as entered in the 1.5.3 ZC Configuration and a screenshot of the the fields as named and listed in the database. Not sure what is the best format to use, therefore I chose "TEXT" as the field type; since, all I am trying to do is provide additional product information for each product. BTW. I was able to successfully install TPP 1.10. I thought that I would import the data from the custom data fields and then try to figure out how to get TPP to show the custom product field data in tabs. So I need to figure out what I am doing wrong.
Attachment 14446Attachment 14447
AJ
Quote:
Originally Posted by
mc12345678
1) Into which table(s) were custom fields entered?
2) When populating the configuration field was the v_ incorrectly included or was it correctly removed. Ie. products_id (correct) instead of v_products_id (incorrect)
3) Which import/export type was performed? (Btw, the field(s) should also export if all things are correct for the applicable data dump.)
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
FoodSourceDirect
Hi MC:
I imported the data into the product table.
The "v_" was not included.
I used the FULL-EP template. The CSV file that I created and used was formated ( a ##############) of the FULL-EP "Complete Products (with Metatags)" under "Product & Pricing Export/Import Options:"
I have included a screenshot of the user defined fields as entered in the 1.5.3 ZC Configuration and a screenshot of the the fields as named and listed in the database. Not sure what is the best format to use, therefore I chose "TEXT" as the field type; since, all I am trying to do is provide additional product information for each product. BTW. I was able to successfully install TPP 1.10. I thought that I would import the data from the custom data fields and then try to figure out how to get TPP to show the custom product field data in tabs. So I need to figure out what I am doing wrong.
Attachment 14446Attachment 14447
AJ
Okay, so two things still, after adding some datato atleast one product through whatever means you have (say myphpadmin) try exporting the data, modifying what needs to be then importing it again.
In parallel with that, what is the filename that you have for your current import file? (Don't need the path, just the filenaame.)
-
2 Attachment(s)
Re: EasyPopulate 4.0 Support Thread
Here is the file info:
Attachment 14448
Added a new "test" product through the ZC Admin>Catalog. Exported the file using EP 4.0. I noticed that all the fields exported including the user defined / custom product fields but they were empty. Yet they are listed under Tools>Easy Populate 4.0.
Attachment 14449
I noticed that the information that I entered in one of the custom product fields of the test product that I created actually imported. (I entered the data into the custom product field using phpMyAdmin.)
Quote:
Originally Posted by
mc12345678
Okay, so two things still, after adding some datato atleast one product through whatever means you have (say myphpadmin) try exporting the data, modifying what needs to be then importing it again.
In parallel with that, what is the filename that you have for your current import file? (Don't need the path, just the filenaame.)
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
FoodSourceDirect
Here is the file info:
Attachment 14448
Added a new "test" product through the ZC Admin>Catalog. Exported the file using EP 4.0. I noticed that all the fields exported including the user defined / custom product fields but they were empty. Yet they are listed under Tools>Easy Populate 4.0.
Attachment 14449
I noticed that the information that I entered in one of the custom product fields of the test product that I created actually imported. (I entered the data into the custom product field using phpMyAdmin.)
Been a while since I have looked through the various exceptions, but as provided that filename is not the format expected by EP4 to process the records into the database. Take note of the filename format of the exported file. When you said that one "imported" from what was entered in myphpadmin, did you mean that one exported? (From database to the csv file.)
-
Re: EasyPopulate 4.0 Support Thread
Hi MC:
This is weird. I looked at the file that I exported from Easy Populate 4.0 and noticed that a v_ was inserted at the beginning of each of the column header names of the custom product fields. Did phpMyAdmin do that or did Easy Populate? Could that be the problem.?
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
FoodSourceDirect
Hi MC:
This is weird. I looked at the file that I exported from Easy Populate 4.0 and noticed that a v_ was inserted at the beginning of each of the column header names of the custom product fields. Did phpMyAdmin do that or did Easy Populate? Could that be the problem.?
The headings of the exported csv file are prepended with v_ and that same prefix is expected upon upload. Unfortunately, those that become familiar with that information, tend to also include it in the customized list. So there is no problem that it exists in the csv file and is an indication that the code is processing.
Still unsure if your issue has been resolved. The only other thing I can think of at the moment if it hasn't is that the database manipulated in myphpadmin is not the same as referenced in the admin/EP4 which wouldn't be unheard of when bouncing back and forth between the variious locations.
-
1 Attachment(s)
Re: EasyPopulate 4.0 Support Thread
Attachment 14450Yes. I typed information into the "product_information" custom product field from within phpMyAdmin. Then under Product & Pricing Export / Import Options, I chose Complete Products with Metatags to export my products. A look at the exported file revealed that the data that was typed using phpMyadmin was exported.
[FONT=Verdana, sans-serif]Product & Pricing Export/Import Options:
[/FONT]
Complete Products (with Metatags)
[FONT=Verdana, sans-serif]The attachment is very interesting.[/FONT]
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
FoodSourceDirect
Attachment 14450Yes. I typed information into the "product_information" custom product field from within phpMyAdmin. Then under Product & Pricing Export / Import Options, I chose Complete Products with Metatags to export my products. A look at the exported file revealed that the data that was typed using phpMyadmin was exported.
[FONT=Verdana, sans-serif]Product & Pricing Export/Import Options:
[/FONT]
Complete Products (with Metatags)
[FONT=Verdana, sans-serif]
The attachment is very interesting.[/FONT]
Interesting indeed, (if I was able to open it). I highly suggest you rename your admin directory right now. It is included in the posted link. :/
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
mc12345678
Interesting indeed, (if I was able to open it). I highly suggest you rename your admin directory right now. It is included in the posted link. :/
Hi MC:
Something you said gave me a tip. I changed the beginning of the name of my csv file from FULL to Full and pre-pended the custom product field names in my csv file I created with "v_", redid the upload and it worked... Thanks
-
Re: EasyPopulate 4.0 Support Thread
renamed. Thanks for the heads-up
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
FoodSourceDirect
Hi MC:
Something you said gave me a tip. I changed the beginning of the name of my csv file from FULL to Full and pre-pended the custom product field names in my csv file I created with "v_", redid the upload and it worked... Thanks
Welcome, though the thanks should go to Chadderuski as it is has been his suggestion to export first to see how things look and respond before trying to upload. Also to back up back up, back up before making changes to the database. :)
-
Re: EasyPopulate 4.0 Support Thread
Can a product be moved from one category to a newly desired category and subcategory using "FUll-EP_" import?
Example:
Move from: Products^T-Shirts
To: Clearance^T-Shirts
I did this by changing the v_categories_name_1 column from Products^T-Shirts to Clearance^T-Shirts. By doing this it retained the "Product Master Category" and created a linked product.
Furthermore even though it says it has created a linked product, the linked product can NOT be found in the cart. When the product model is searched in the cart, it only shows up in the master category.
The idea was to bulk move products from one category to another!
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
Kevin205
Can a product be moved from one category to a newly desired category and subcategory using "FUll-EP_" import?
Example:
Move from: Products^T-Shirts
To: Clearance^T-Shirts
I did this by changing the v_categories_name_1 column from Products^T-Shirts to Clearance^T-Shirts. By doing this it retained the "Product Master Category" and created a linked product.
Furthermore even though it says it has created a linked product, the linked product can NOT be found in the cart. When the product model is searched in the cart, it only shows up in the master category.
The idea was to bulk move products from one category to another!
My thought on this would be to delete the product (status of 9) and then re-upload the product with the desired category. I believe that because assigning the product to more than one category that this creates (or is supposed to create) a linked product and that the statement has been made that EP4 doesn't play well with linked products that the method used will not work.
The problem with what I suggest above is that the existing product(s) will lose their original product I'd and therefore may cause some other issues.
Orriginally I thought that perhaps the category import/export would be the right way to go, but perusing the code I didn't see that it was mandatory or would do anything extra/different. :/
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
mc12345678
My thought on this would be to delete the product (status of 9) and then re-upload the product with the desired category. I believe that because assigning the product to more than one category that this creates (or is supposed to create) a linked product and that the statement has been made that EP4 doesn't play well with linked products that the method used will not work.
The problem with what I suggest above is that the existing product(s) will lose their original product I'd and therefore may cause some other issues.
Orriginally I thought that perhaps the category import/export would be the right way to go, but perusing the code I didn't see that it was mandatory or would do anything extra/different. :/
If EP4 can't do this task, then to retain products_id; products have to be moved manually, one by one through Zen Cart's move function.
Thanks for the reply. :no: :yes:
-
Re: EasyPopulate 4.0 Support Thread
For the lack of time to browse 163 pages, I will post my issue:
I am trying to import a list of categories from a CSV file.
I have the following columns:
v_categories_name_1, v_metatags_keywords_1
I tried before with those two and including the v_categories_id column to specify my own category ID but I took it out. Even after taking it out I still got the same errors.
Every time I try to import, I get nothing but 'No model field in record. This line was not imported' errors for every row.
All I want to do is import categories with no products yet.
Can someone help me please? I have opened the CSV file in Notepad and verified it is comma-delimited (no tabs, blank spaces at end, etc).
Thank you!
-
Re: EasyPopulate 4.0 Support Thread
I have installed ZC 1.5.3.
Installed EP 4.0
Added 13 custom product fields to the products table.They are all in TEXT format.
Installed TPP 1.10
I plan to install Image Handler 4.
I need TPP to be able to pull content / data from custom fields so that the custom data is displayed in tabs in the product information page of my store.
I read Crazy_Chris' post that was submitted in 2007 which seems to be the easiest to follow instructions so far. But. I am not sure if there have been changes in ZC since 2007, or if the TPP 1.10 Global Tabs instructions are sufficient to pull the data. Or do I need to make the changes that Crazy_Chris outlines and the TPP Global Instructions. I'm not a programmer; but, I am good at following instructions, provided they are clearly written.
I have looked at Numinix 3.0 but most of the custom field names are different than the ones I have created and it modifies ZC 1.5.3 core files.
AJ
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
jokkah
For the lack of time to browse 163 pages, I will post my issue:
I am trying to import a list of categories from a CSV file.
I have the following columns:
v_categories_name_1, v_metatags_keywords_1
I tried before with those two and including the v_categories_id column to specify my own category ID but I took it out. Even after taking it out I still got the same errors.
Every time I try to import, I get nothing but 'No model field in record. This line was not imported' errors for every row.
All I want to do is import categories with no products yet.
Can someone help me please? I have opened the CSV file in Notepad and verified it is comma-delimited (no tabs, blank spaces at end, etc).
Thank you!
I believe it is in the first page and in the limited provided documenatation, but may I recommend that you first export the two category options, review the produced file, remove data that is not applicable for what you are going to upload, for the most part leave the fields intact at the top of the file, add the desired data, upload, and then import the file. The category file you will want to use is one without a products model field in it. The filenme can be modified upon save as so that the date/time information is different. Otherwise the filename is both case sensitive and character sensitive.
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
FoodSourceDirect
I have installed ZC 1.5.3.
Installed EP 4.0
Added 13 custom product fields to the products table.They are all in TEXT format.
Installed TPP 1.10
I plan to install Image Handler 4.
I need TPP to be able to pull content / data from custom fields so that the custom data is displayed in tabs in the product information page of my store.
I read Crazy_Chris' post that was submitted in 2007 which seems to be the easiest to follow instructions so far. But. I am not sure if there have been changes in ZC since 2007, or if the TPP 1.10 Global Tabs instructions are sufficient to pull the data. Or do I need to make the changes that Crazy_Chris outlines and the TPP Global Instructions. I'm not a programmer; but, I am good at following instructions, provided they are clearly written.
I have looked at Numinix 3.0 but most of the custom field names are different than the ones I have created and it modifies ZC 1.5.3 core files.
AJ
While this appears like a "fun" problem to attempt to correct, I'm afraid that it is not specific to EP4. As well, since you have been able to successfully use EP4 to populate this portion of your tables, I would suggest that you begin a new thread with all of the details above plus a link to the 2007 thread you are referrring to. That way you will receive assistance that is more applicable to your issue. If you like, please post a link here to the new thread so that those interested may follow up with your issue. Regarding various software and versions, it is suggested that you ensure the software you are using is applicable to the version of ZC that you have installed, so it may be necessary to use the version 3.0 if the existing version is not considered compatible with 1.5.3.
Wish you good luck though.
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
Kevin205
If EP4 can't do this task, then to retain products_id; products have to be moved manually, one by one through Zen Cart's move function.
Thanks for the reply. :no: :yes:
It maybe time to incorporate a status marker to perform the same move functionality that is performed in ZC. Ideally chadderruski and I can finish our documentation of the existing program first then conquer other aspects of functionality.
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
jokkah
For the lack of time to browse 163 pages, I will post my issue:
I am trying to import a list of categories from a CSV file.
I have the following columns:
v_categories_name_1, v_metatags_keywords_1
I tried before with those two and including the v_categories_id column to specify my own category ID but I took it out. Even after taking it out I still got the same errors.
Every time I try to import, I get nothing but 'No model field in record. This line was not imported' errors for every row.
All I want to do is import categories with no products yet.
Can someone help me please? I have opened the CSV file in Notepad and verified it is comma-delimited (no tabs, blank spaces at end, etc).
Thank you!
Jokkah,
The Category import/export does is not used to create the category tree, it is only used to UPDATE the category info like if you want to add descriptions, images, etc.
The categories are only created automatically using the FULL import sheet. You would need at least 1 product in each category, but you could trim out much of the sheet columns to make it simple.
-chadd
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
mc12345678
It maybe time to incorporate a status marker to perform the same move functionality that is performed in ZC. Ideally chadderruski and I can finish our documentation of the existing program first then conquer other aspects of functionality.
To add a move feature would not be hard, but would by necessity be a new sheet design.
In the past (and with older version of EP) the "move" was accomplished by first deleting the item with "status = 9" and then
having the same product listed in it's new category with "status = 1"
NOTE: WHEN YOU USE THIS TECHNIQUE, IT WILL ALSO DELETE THE PRODUCT IMAGE! So you will have to reupload them.
Yes, this does create a new products_id in the table.
To add a "move" she is quite possible, but we really need to get this documented and submitted before make more changes/additions.
No ETA on that yet either, sorry.
-chadd
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
chadderuski
To add a move feature would not be hard, but would by necessity be a new sheet design.
In the past (and with older version of EP) the "move" was accomplished by first deleting the item with "status = 9" and then
having the same product listed in it's new category with "status = 1"
NOTE: WHEN YOU USE THIS TECHNIQUE, IT WILL ALSO DELETE THE PRODUCT IMAGE! So you will have to reupload them.
Yes, this does create a new products_id in the table.
To add a "move" she is quite possible, but we really need to get this documented and submitted before make more changes/additions.
No ETA on that yet either, sorry.
-chadd
Agree, significant design changes should wait for the documentation. I've started working on the SBA portion of the instructions, but just about that much of it... Started...
Btw, thank you for clarifying the category discussion above I almost can't remember what I was doing at the timme I unsuccessfully tried to help with that one.
Not so certain that a new sheet would be necessary, but that's for future development speak, and perhaps the community would have a weigh-in.
-
Re: EasyPopulate 4.0 Support Thread
Just wanted to thank to Chad and MC for all they have done.
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
Kevin205
Just wanted to thank to Chad and MC for all they have done.
I second the motion i.e. DITTO
AJ
-
Re: EasyPopulate 4.0 Support Thread
Hi Guys
I am unable to import 3 columns from the Detailed Attributes file. Once I click on the import hyperlink the page it goes to a blank page with this url in the address bar
http://www.books.com/zencart/admin/e...led-EP2014.csv
These are the columns that wont import ,with some data.
v_products_attributes_filename /Books/Chapter1/HarryPottere.pdf
v_products_attributes_maxdays 7
v_products_attributes_maxcount 10
I use the same format as the exports from easypopulate, Full/Basic/Detailed
Is there an error log or something that can help me understand why its not importing
Thanks Paul
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
Hasher
Hi Guys
I am unable to import 3 columns from the Detailed Attributes file. Once I click on the import hyperlink the page it goes to a blank page with this url in the address bar
http://www.books.com/zencart/admin/e...led-EP2014.csv
These are the columns that wont import ,with some data.
v_products_attributes_filename /Books/Chapter1/HarryPottere.pdf
v_products_attributes_maxdays 7
v_products_attributes_maxcount 10
I use the same format as the exports from easypopulate, Full/Basic/Detailed
Is there an error log or something that can help me understand why its not importing
Thanks Paul
So, EP4 does provide some error logging with the log file stored in the directory used for your import/export files; however, a blank screen error will typicallybe logged into the ZC error log file which for ZC versions <=1.5.0 is in the stores cache directory and versions >= 1.5.1 is in the logs folder.
Btw, ion a mobile device so I was redirected when I attempted to follow that link, but hopefully that is not a true/valid path to the software. If it is, the admin folder should be renamed. (Possible to have an admin folder named admin in earlier versions of ZC and the version being used was not identified.)
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
Hasher
Hi Guys
I am unable to import 3 columns from the Detailed Attributes file. Once I click on the import hyperlink the page it goes to a blank page with this url in the address bar
http://www.books.com/zencart/admin/e...led-EP2014.csv
These are the columns that wont import ,with some data.
v_products_attributes_filename /Books/Chapter1/HarryPottere.pdf
v_products_attributes_maxdays 7
v_products_attributes_maxcount 10
I use the same format as the exports from easypopulate, Full/Basic/Detailed
Is there an error log or something that can help me understand why its not importing
Thanks Paul
Quote:
Originally Posted by
mc12345678
So, EP4 does provide some error logging with the log file stored in the directory used for your import/export files; however, a blank screen error will typicallybe logged into the ZC error log file which for ZC versions <=1.5.0 is in the stores cache directory and versions >= 1.5.1 is in the logs folder.
Btw, I am on a mobile device so I was redirected when I attempted to follow that link, but hopefully that is not a true/valid path to the software. If it is, the admin folder should be renamed. (Possible to have an admin folder named admin in earlier versions of ZC and the version being used was not identified.)
Just attempted first an export from a database, no modifications made, and then an import of the same file that had a name of Attrib-Detailed-EP as a prefix. No white screen result.
Also then went in and modified one value in those three, uploaded, and the value was shown as changed.
Hopefully the issue with the "local" machine can be rectified.
-
Re: EasyPopulate 4.0 Support Thread
Perhaps I am missing something, but I just added products via Easy Populate 4 and assumed that the new lines in my product descriptions would be converted to <br /> once uploaded. This was not the case. Now I have to manually go into each product to re-format all my descriptions. Is this normal behaviour?
In Admin my settings for Smart Tags Replacement of Newlines and Advanced Smart Tags are both set to True.
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
k1ra
Perhaps I am missing something, but I just added products via Easy Populate 4 and assumed that the new lines in my product descriptions would be converted to <br /> once uploaded. This was not the case. Now I have to manually go into each product to re-format all my descriptions. Is this normal behaviour?
In Admin my settings for Smart Tags Replacement of Newlines and Advanced Smart Tags are both set to True.
Also, when adding <br /> tags in EP4, they do not stick when uploaded. However, <br / > tags that were generated when creating products via Admin, do export into EP4.
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
k1ra
Perhaps I am missing something, but I just added products via Easy Populate 4 and assumed that the new lines in my product descriptions would be converted to <br /> once uploaded. This was not the case. Now I have to manually go into each product to re-format all my descriptions. Is this normal behaviour?
In Admin my settings for Smart Tags Replacement of Newlines and Advanced Smart Tags are both set to True.
Looking at the configuration options for those two options, it appears in the description that the code is disabled and therefore wouldn't do anything. That is assuming that the menu option description has been kept up-to-date.
In fact, I don't see that those settings are even used in the code, they are set, but nothing uses them.
What's the settings for curly quotes?
-
Re: EasyPopulate 4.0 Support Thread
Hi just installed on Linux in a new cart 1.5.3 and all seems well except i'm not seeing my test Category import.
I downloaded OpenOffice to open and edit the sample file I exported to add new categories and i do get a success notice that the file has uploaded successfully. I generated some numbers to fill in for the Category ID. But only the original categories are showing. I've not changed any of the defaults and used the comma and quotes as instructed. Anything I can tell you that may help you let me know what I'm missing? This is a straight forward install and no core changes were made.
-
Re: EasyPopulate 4.0 Support Thread
Ok just saw this... Will work on it...
Quote:
Originally Posted by
chadderuski
jokkah,
the category import/export does is not used to create the category tree, it is only used to update the category info like if you want to add descriptions, images, etc.
The categories are only created automatically using the full import sheet. You would need at least 1 product in each category, but you could trim out much of the sheet columns to make it simple.
-chadd
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
athena
Ok just saw this... Will work on it...
Thank you for looking through the thread for your answer and glad you found it. Please let us know how things go and if you have any further questions.
-
Re: EasyPopulate 4.0 Support Thread
I have 300 items listed under one main category (Songs) and none of the items are linked. I'd like to add two sub-categories (vocal & piano) under the Songs category. My plan is to use easy populate 4 to remove all of the items and then re-upload them again with the new categories names (Songs^vocal & Songs^piano) I'm sure ZC will give all of these items new id#'s and am just curious if there is anything I'm missing that may cause complications. I'd hate to have to edit each one of them, that's for sure. Thx
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
mrcastle
I have 300 items listed under one main category (Songs) and none of the items are linked. I'd like to add two sub-categories (vocal & piano) under the Songs category. My plan is to use easy populate 4 to remove all of the items and then re-upload them again with the new categories names (Songs^vocal & Songs^piano) I'm sure ZC will give all of these items new id#'s and am just curious if there is anything I'm missing that may cause complications. I'd hate to have to edit each one of them, that's for sure. Thx
While I advocate EP4 (though also have been known to discuss another similar application), the right tool for the right application. I would actually suggest a rather easier route, especially if you are going to be moving aall of the items, or at least all items in a particular category.
Come to think of it, if that is the only aspect you are looking at changing at the moment it probably would be better to just work with the particular tables that need changing instead. I thought basically the products_to_categories table would be the only thing that would need to be changed to actually do the move of the product from it's current category to the new one. I mean, I might suggest using ep4 to download the data, help identify which should go into which of the other two categories, maybe sort the daata in some way, then download the above table and modify it to match the new location(s) and then upload the new data directly into the database.
Okay, I'm sorry, I'm in a heavy programming mentality at the moment, basically, if the products are deleted, then some of the aspects of the customers history will be lost, but at least a huge time savings can be seen over doing it all manually. On the other hand I am still thinking that I thought I saw a way to move objects in an entire category to another. And if that is the case,I would move them all to one of the two new categories, then would use Ep4 to create a linked version to the second category of those items that should be in the second category, then I thought there waas a way to either reset the master category or in a way remove a linked product from a category or something similar, but in either case, do lots of changes in multiple steps rather than sort of two... :)
It'll provide the end desired result of all the products in two new categories as a sub-category to where they were.
-
Re: EasyPopulate 4.0 Support Thread
Can products_model be edited/revised using EP4? If yes which module?
Thank you.
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
Kevin205
Can products_model be edited/revised using EP4? If yes which module?
Thank you.
No, EP4 does not offer a method to create or modify products_model at this time. The expectation in using it is that the products_model is identified already for each product or upon insert of new products that the products_model be identified.
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
mc12345678
No, EP4 does not offer a method to create or modify products_model at this time. The expectation in using it is that the products_model is identified already for each product or upon insert of new products that the products_model be identified.
Thank you
-
Re: EasyPopulate 4.0 Support Thread
Hi there, I'm having a fairly bizarre issue with the latest version of EP4 downloaded from Github. Recently upgraded the cart from 1.5.1 to 1.5.3, thus needed to upgrade to the latest EP4. After uploading the new files, the EP page appears to load correctly and exports products fine.
However, once I re-upload the changed file and click "Import"... the product information changes *temporarily* but then reverts back to the original once EP import is complete. For example, if I change the product price from $5 to $6, and while the file is being imported/processed, I refresh the front end store product page in another browser tab, and the product price is correctly $6. But as soon as EP finishes importing and says "File Import Completed", I refresh the product page and it's right back to $5.
Any ideas?
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
jackie.taferner
Hi there, I'm having a fairly bizarre issue with the latest version of EP4 downloaded from Github. Recently upgraded the cart from 1.5.1 to 1.5.3, thus needed to upgrade to the latest EP4. After uploading the new files, the EP page appears to load correctly and exports products fine.
However, once I re-upload the changed file and click "Import"... the product information changes *temporarily* but then reverts back to the original once EP import is complete. For example, if I change the product price from $5 to $6, and while the file is being imported/processed, I refresh the front end store product page in another browser tab, and the product price is correctly $6. But as soon as EP finishes importing and says "File Import Completed", I refresh the product page and it's right back to $5.
Any ideas?
Verify that the model for that product isn't listed more than once and that the model number of the item that follows isn't blank.
As for the need to view on a different tab, that basically is more than likely a sessions/cache issue.
-
Re: EasyPopulate 4.0 Support Thread
Yes, that seemed to be the issue - duplicate products because they are in different categories. I've sorted all products by model number, and now I can see the duplicates and apply changes as needed. Thanks!
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
Kevin205
Can products_model be edited/revised using EP4? If yes which module?
Thank you.
Quote:
Originally Posted by
mc12345678
No, EP4 does not offer a method to create or modify products_model at this time. The expectation in using it is that the products_model is identified already for each product or upon insert of new products that the products_model be identified.
Quote:
Originally Posted by
Kevin205
Thank you
Forgot to mention that there are some relatively simple sql queries that can either be made or run to make changes or to create products_model information for items that are to have a new model number or to change it.
-
Re: EasyPopulate 4.0 Support Thread
Hi, can someone please help me? There are several Easy Populate downloads available. How do I access the most recent plug in? I am running v1.5.3. I had a look at github but I'm not sure what link to select to download. Thank you.
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
joyjoy
Hi, can someone please help me? There are several Easy Populate downloads available. How do I access the most recent plug in? I am running v1.5.3. I had a look at github but I'm not sure what link to select to download. Thank you.
Oops! Nevermind. I didn't see the "Download Zip" button off to the side. :blink:
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
joyjoy
Hi, can someone please help me? There are several Easy Populate downloads available. How do I access the most recent plug in? I am running v1.5.3. I had a look at github but I'm not sure what link to select to download. Thank you.
Quote:
Originally Posted by
joyjoy
Oops! Nevermind. I didn't see the "Download Zip" button off to the side. :blink:
Glad it was easily resolved!
-
1 Attachment(s)
Re: EasyPopulate 4.0 Support Thread
someone please help,i transfer my website from one sever to other,the EP is not working,it only show some information,but there is no area for download,upload ,please refer to this pictureAttachment 14530
I don't know what's going on and how to fix it.
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
e-standard
someone please help,i transfer my website from one sever to other,the EP is not working,it only show some information,but there is no area for download,upload ,please refer to this picture
Attachment 14530
I don't know what's going on and how to fix it.
Two things come to mind. 1. Check the error logs directory because of a partial screen display (ZC version < 1.5.1 is cache directory, >= 1.5.1 is logs directory)
2. Select the uninstall link on upper right and then the install option that will become available.
If that still doesn't work, then would help to know/understand how the transfer was performed and other related issues.
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
mc12345678
Two things come to mind. 1. Check the error logs directory because of a partial screen display (ZC version < 1.5.1 is cache directory, >= 1.5.1 is logs directory)
Where to see the error log?in which file?
2. Select the uninstall link on upper right and then the install option that will become available.
I have tried uninstall and install,even upload the new file,not working.
If that still doesn't work, then would help to know/understand how the transfer was performed and other related issues.
I use cpanel backup the main dir file and import to the new sever,do not make any change on it,btw,the zencart version is 1.3.9
-
Re: EasyPopulate 4.0 Support Thread
Here is the error code
[19-Sep-2014 07:02:05 UTC] PHP Fatal error: Call to undefined function mb_internal_encoding() in /home/estanda1/public_html/1246/easypopulate_4.php on line 315
-
Re: EasyPopulate 4.0 Support Thread
problem solved,i did not install mbstring on the sever
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
e-standard
problem solved,i did not install mbstring on the sever
Good work figuring it out. That seemed most likely, but easiest to identify by following the suggested reviews.
-
Re: EasyPopulate 4.0 Support Thread
Hi... I have repeatedly tried to install the module, Easy Populate 4.0. Obviously I'm doing something wrong. I am using Zen Cart 1.5.3
The instructions say to:
"1. Change the name of the "admin" directory to match your Zencart installation.
2. Upload all files in the "admin" directory to your site (I didn't know if "site" meant to my admin folder on the server OR site meaning my store files. (i.e. public_html/mystore/myadmin) maintaining directory structure.
No core files are changed" AND
"If you are using zencart 1.5, you need to also upload the additional
files in the "zencart 1.5 extra files folder". (Again, I am using ZenCart 1.5.3)
"Login and you will see Easy Populate at the bottom of the tools menu..."
So I have done all this: I have changed the admin file in Easy Populate to match my admin folder.
1. I have uploaded all the files inside the admin folder to "myadmin" on my server. I also uploaded the includes folder within the admin folder over to myadmin.
2. I also uploaded the file within the "zencart 1.5 extra files" folder' - which was another admin folder. I opened that admin folder and uploaded the only file there....another includes folder.
Can someone please look at what I've done and help me to know what is wrong or tell me what I've done wrong.
Thanks
Brenda
2.
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
msbfrnj
Hi... I have repeatedly tried to install the module, Easy Populate 4.0. Obviously I'm doing something wrong. I am using Zen Cart 1.5.3
The instructions say to:
"1. Change the name of the "admin" directory to match your Zencart installation.
2. Upload all files in the "admin" directory to your site (I didn't know if "site" meant to my admin folder on the server OR site meaning my store files. (i.e. public_html/mystore/myadmin) maintaining directory structure.
No core files are changed" AND
"If you are using zencart 1.5, you need to also upload the additional
files in the "zencart 1.5 extra files folder". (Again, I am using ZenCart 1.5.3)
"Login and you will see Easy Populate at the bottom of the tools menu..."
So I have done all this: I have changed the admin file in Easy Populate to match my admin folder.
1. I have uploaded all the files inside the admin folder to "myadmin" on my server. I also uploaded the includes folder within the admin folder over to myadmin.
2. I also uploaded the file within the "zencart 1.5 extra files" folder' - which was another admin folder. I opened that admin folder and uploaded the only file there....another includes folder.
Can someone please look at what I've done and help me to know what is wrong or tell me what I've done wrong.
Thanks
Brenda
2.
Generally speaking, what seems to be written above seems right. So, the next thing is to try to identify what is going on with a little more detail.
In the folder "myadmin" which is you're renamed admin folder off of the store's location, do you now have five files all beginning with easypopulate_4 and ending with .php ordo you have your "myadmin" folder there as well?
When addressing the extra 1.5 files (yes this plugin has been updated to work with 1.5.3) the includes folder was in fact placed into the "myadmin" folder again that is off of the store?
-
Re: EasyPopulate 4.0 Support Thread
Hi.... I uploaded all those 5 files to the "mystore" folder, along with the includes folder (in order). I did not upload the whole admin folder they were in, just the files themselves.
But I had already uploaded everything to the "myadmin" folder on my server the last time I tried installing EP, and was not successful. So I tried uploading everything to the "mystore" folder. At any rate, both times nothing happened. Easy Populate does not appear at the bottom of my admin>tools menu.
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
msbfrnj
Hi.... I uploaded all those 5 files to the "mystore" folder, along with the includes folder (in order). I did not upload the whole admin folder they were in, just the files themselves.
But I had already uploaded everything to the "myadmin" folder on my server the last time I tried installing EP, and was not successful. So I tried uploading everything to the "mystore" folder. At any rate, both times nothing happened. Easy Populate does not appear at the bottom of my admin>tools menu.
And it won't until the "special" file has been placed in the appropriate location. That is the other folder that has the one "includes" folder. That includes folder is copied to the "myadmin" folder. Then when the admin panelis next loaded the EP4 option will appear in the tools section.
-
Re: EasyPopulate 4.0 Support Thread
so are you saying that I should upload the five files (easypopulate_4 and ending with .php) to the "myadmin" folder on my server and the extra files 1.5 folder contents to the "mystore" folder on my server.
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
msbfrnj
so are you saying that I should upload the five files (easypopulate_4 and ending with .php) to the "myadmin" folder on my server and the extra files 1.5 folder contents to the "mystore" folder on my server.
Actually, go one folder deeper in the extra files 1.5 folder and then move those contents to "myadmin"
-
Re: EasyPopulate 4.0 Support Thread
Yes... one file deeper is the includes folder..... add the includes folder to myadmin..... Hopefully this works..... :praying
I am about to upload the five easy populate files to the mystore folder and the includes folder to the myadmin directory..... Thanks....
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
msbfrnj
Yes... one file deeper is the includes folder..... add the includes folder to myadmin..... Hopefully this works..... :praying
I am about to upload the five easy populate files to the mystore folder and the includes folder to the myadmin directory..... Thanks....
Ummm, that's not what was said/described. The five files and associated includes folder goes into the myadmin folder not the mystore folder...
-
Re: EasyPopulate 4.0 Support Thread
Ok...did this before but will try again....thanks
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
msbfrnj
Ok...did this before but will try again....thanks
If that still does not work, check your logs folder (zc 1.5.1+) or cache folder (1.5.0 and down) for any error messages. An action similar to what e-standard at the top of the previous page may be necessary.
-
Re: EasyPopulate 4.0 Support Thread
I am using a fresh new install of Zen Cart v1.5.3 and attempting to install easy_populate_csv_for_zencart_v1.5.x_v1.2.5.7c
I copy the files across to the correct folders, and when I go to Tools -> Easy Populate I get the following three lines at the top of the Admin main page:-
Strange but there is no default language to work... That may not happen, just in case...
Warning Easy Populate Configuration Missing. Please install your configuration by clicking here
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
I click to install the configuration and get a white screen with the error:-
WARNING: An Error occurred, please refresh the page and try again.
And I have tried again.
Any help on this would be great as it is an essential part to my shop creation.
-
Re: EasyPopulate 4.0 Support Thread
Update:
Reinstalled shop and DB with Zencart v1.5.1 and installed Easypopulate again.
No problems at all. Great little program :-)
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
syncunlimited
Update:
Reinstalled shop and DB with Zencart v1.5.1 and installed Easypopulate again.
No problems at all. Great little program :-)
Glad you were able to get that version of Easy Populate to work; however, that is a different version than what this forum is about.
That said, the problem with that particular fileset is that it isnot compatible with the changes made to ZC beginning with ZC 1.5.2. (should seek upgrading to the newest files.) Obviously you're welcome to switch to EP4 (the version discussed in this thread) or perhaps the version being used has a more recent update compatible with 1.5.3.
Regardless, glad you were able to find a way to continue operating your store at full capacity. :)
-
Re: EasyPopulate 4.0 Support Thread
Perhaps this has been asked before, but how do you delete attributes from products via Easy Populate?
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
k1ra
Perhaps this has been asked before, but how do you delete attributes from products via Easy Populate?
While I thought there might be a check possibly when using the attribute basic import, there does not appear to be a way for easypopulate v4 to remove attributes from a product at this time.
Btw, sorry for the delayed reply, have been away fromm the forums for the most part recently.
-
Re: EasyPopulate 4.0 Support Thread
I got the same error discussed here earlier : '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'
Yes, I am use Ultimate SEO URL's. stellarweb's walk around in the post #1620 is to set up an admin area in a separate folder that ties into the current database. Is there any better way to resolve this issue now? Thank you.
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
hzha
I got the same error discussed here earlier : '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'
Yes, I am use Ultimate SEO URL's. stellarweb's walk around in the post #1620 is to set up an admin area in a separate folder that ties into the current database. Is there any better way to resolve this issue now? Thank you.
I can't seem to find the correspondence associated with that issue that was had some other way (pm, email, another thread, etc...), but if not mistaken the issue was identified to be related to I think a file with the name general in it in the admin files. That it was not updated to 1.5.3 version or that it was modified in a way not to be fully compatible. I wish I could find the associated message.
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
mc12345678
I can't seem to find the correspondence associated with that issue that was had some other way (pm, email, another thread, etc...), but if not mistaken the issue was identified to be related to I think a file with the name general in it in the admin files. That it was not updated to 1.5.3 version or that it was modified in a way not to be fully compatible. I wish I could find the associated message.
Here is the previous discussion on my issue.
http://www.zen-cart.com/showthread.p...Thread/page159
You identified the issue is A URI rewriter incorrectly modified includes/classes/db/mysql/query_factory.php for ZC 1.5.3 in your post http://www.zen-cart.com/showthread.p...topped-Working
and stellarweb has a walk around in his post #1620.
http://www.zen-cart.com/showthread.p...Thread/page161
I am wondering what is the best way to resolve this issue. Thank you.
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
hzha
As I recall from the communication, a separate work-around was determined; however, in parallel I had worked on making the existing software "compatible" with 1.5.3. I did no testing for operations sake. I only had brought the code up-to-date to not to supposedly create the same errors. I will post the code in the Ultimate SEO URI thread. I believe it is not a complete set of software, but only the changes to the original software. As I stated in one of those post threads, a version of the URI rewriter is in a test status which I would fully consider the attached code as being. Truly the issue is with USU and should be addressed in that thread, it just happens to be observed when using this software.
See post 733 for the files that may resolve this issue when using Ultimate SEO URIs version 2.212.
-
Re: EasyPopulate 4.0 Support Thread
Using Zencart 1.53.... And Easy Populate 4
The manufacturer of my products has expressly set up the data file for Easy Populate and suggests using the program. The columns are all set up like the columns in Easy Populate. Since there are like 2000 products, I have uploaded a test csv file of about 6-8 products. I browsed for the test file in easy populate on my hard drive, then clicked the upload buttom. Easy Populate says file was uploaded successfully at the top. The test csv file appears at the bottom of the page in Easy Populate. So my question is: how does the products populate the store. Do they come in automatically or am I supposed to click something that says - populate or something.
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
msbfrnj
Using Zencart 1.53.... And Easy Populate 4
The manufacturer of my products has expressly set up the data file for Easy Populate and suggests using the program. The columns are all set up like the columns in Easy Populate. Since there are like 2000 products, I have uploaded a test csv file of about 6-8 products. I browsed for the test file in easy populate on my hard drive, then clicked the upload buttom. Easy Populate says file was uploaded successfully at the top. The test csv file appears at the bottom of the page in Easy Populate. So my question is: how does the products populate the store. Do they come in automatically or am I supposed to click something that says - populate or something.
Once the fileis identified as being in the file directory for EP4, adjacent to the filename is an option of import. EP4 will process the file as applicable for it's name/prefix. Essentially matching the file name for an uploaded file to the filenamme of a downloaded/exported file to include all of the letters up to the date will ensure that the file will be processed as "desired".
Ie: export file example Full-EP2013Jul09-073801.csv could be downloaded, modified then saved as Full-EP.csv and would still be functional/available for EP4 to process as a file for Full details to be modified.
-
Re: EasyPopulate 4.0 Support Thread
All of what you said has happened. I have browsed for the correctly set up test csv file. Uploaded it with the upload button.
The browsed for file then appeared next to the browse button. Next to the browse button is the upload button. I then click that. Momentarily after that.... A message appears at the top of the page saying file uploaded successfully. THEN... I did see the import button at the bottom of the screen. I click that. A message immediately appears at the top of the page stating - file imported successfully. I then go to "online catalog" and nothing is there!
Are you saying that I should download one of the default data files that EP puts out....put my data in it and then re-up load it.... Then it will populate. I know..... you are allowed to scream at me if you want.... But I don't get it... :( Could someone just look at it for me please.....
Humbly submitted,
Brenda
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
msbfrnj
All of what you said has happened. I have browsed for the correctly set up test csv file. Uploaded it with the upload button.
The browsed for file then appeared next to the browse button. Next to the browse button is the upload button. I then click that. Momentarily after that.... A message appears at the top of the page saying file uploaded successfully. THEN... I did see the import button at the bottom of the screen. I click that. A message immediately appears at the top of the page stating - file imported successfully. I then go to "online catalog" and nothing is there!
Are you saying that I should download one of the default data files that EP puts out....put my data in it and then re-up load it.... Then it will populate. I know..... you are allowed to scream at me if you want.... But I don't get it... :( Could someone just look at it for me please.....
Humbly submitted,
Brenda
No hootin' and hollarin' going on over here, except for the typical Saturday shenanigans. Your second paragraph sums it up exactly. You can add more to the filename if you wish to not replace the previous file and still have it available if a mistake is made.
Additionally, for the first one or two, recommend not adding fields to the file(s) until seems to work. (Ie. One step at a time. )
-
Re: EasyPopulate 4.0 Support Thread
I've been using EP4 for a while now, great utility.
I've just uploaded a new line of products where the quantity is implied, and so I want to turn the off the Quantity box in the product listing. Is there a way to toggle the Products Quantity Box Shows option in the products listing using EP4?
Many thanks for any suggestions
John
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
jrobbo
I've been using EP4 for a while now, great utility.
I've just uploaded a new line of products where the quantity is implied, and so I want to turn the off the Quantity box in the product listing. Is there a way to toggle the Products Quantity Box Shows option in the products listing using EP4?
Many thanks for any suggestions
John
Not by default, but it is easy to add...
In the admin->configuration->Easy Populate 4 there is a field (User defined products fields) to add additional fields for export/import. Fields associated with the products table can be added into this list. The fields should be identified as they appear in the products table separated by commas only (for more than one field). So for this case, if the products_qty_box_status field is listed then when it is set to zero (0) it appears that the option to choose a quantity for a product will be prevented.
One of those things that not everyone uses, so it seems that it was left off as a default like option, but is something still possible.
-
Re: EasyPopulate 4.0 Support Thread
Well that turned out to be a whole lot easier than I thought it was going to be! Thanks very much @mc123456578 for the excellent reply, works like a charm.
Cheers
John
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
jrobbo
Well that turned out to be a whole lot easier than I thought it was going to be! Thanks very much @mc123456578 for the excellent reply, works like a charm.
Cheers
John
Quite welcome, wouldn't have been possible without the rework done by chadderuski, all of the feedback of the users and the work of those leading up to this. :)
-
Re: EasyPopulate 4.0 Support Thread
looking at installing this, hoping to bring 1.3.9 products into a 1.5.3 store. Is there a summary of the steps or do I need to read 169 pages ?
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
johnniejetski
looking at installing this, hoping to bring 1.3.9 products into a 1.5.3 store. Is there a summary of the steps or do I need to read 169 pages ?
On a quick search, this is something I found, but if you still have the 1.3.9 database, then there is a zc process to import products other than using EP4 to import. It will work, but may not be the preferred method. http://www.zen-cart.com/showthread.p...47#post1251347
There's other occurrences of such a summary; however, I have not given the search time to find it...
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
mc12345678
As I recall from the communication, a separate work-around was determined; however, in parallel I had worked on making the existing software "compatible" with 1.5.3. I did no testing for operations sake. I only had brought the code up-to-date to not to supposedly create the same errors. I will post the code in the Ultimate SEO URI thread. I believe it is not a complete set of software, but only the changes to the original software. As I stated in one of those post threads, a version of the URI rewriter is in a test status which I would fully consider the attached code as being. Truly the issue is with USU and should be addressed in that thread, it just happens to be observed when using this software.
See post
733 for the files that may resolve this issue when using Ultimate SEO URIs version 2.212.
Truly the issue is NOT with USU. I have been using USU (2.212) under Zen Cart 1.5.3 (by following the instructions in the manual and in the support forum) without issue.
The issue's I have seen reported in this thread (and on the USU thread) appears to be caused install errors.. Namely replacing Zen Cart 1.5.3 files with files from USUS which are modified versions of files for PREVIOUS versions of Zen Cart. The manual for USU like most well written modules says to use / merge the modified core files matching the installed version of Zen Cart. The issues reported seem to crop up when that advice isn't followed..
The current stable release of USU was released BEFORE the Zen Cart 1.5.2 release. As such it does not include core files from Zen Cart 1.5.2+ pre-modified and ready to go for end users. The support thread DOES include some examples of modified core Zen Cart files from Zen Cart 1.5.2 RC2. The support thread also includes some additional information relating to the use of USU in Zen Cart 1.5.2 and 1.5.3.
THE ANSWER for people having difficulties with USU is to head over to the USU support thread.. Suggest these folks checkout the relevant posts - in this case #555, #706, and #717. The author is talented and FULLY supports his module..
OR
Folks can wait for the next version of USU (which is in beta testing now) to be released in a few weeks.. It will have all of the FULLY MODIFIED files Zen Cart v1.5.3 files so people who don't bother to merge (as suggested in the readme) can simply just drag and drop to their hearts content..
-
Re: EasyPopulate 4.0 Support Thread
FYI, uploaded a revision to EP4 that includes some compatibility with potteryhouse's version of Stock By Attributes (SBA) (in particular the customid). This is an expansion of capability that was previously included with an older version of SBA (compatibility with which still exists). A pull request has been made to incorporate the change into the version available from the first post of this thread.
In the mean time, if interested in testing this, please see:
https://github.com/mc12345678/EasyPopulate-4.0
Look for the "ZIP" button to download. To install, upload all files to your admin directory maintaining directory structure.
Also upload the additional files for your version of Zencart - be sure to put thes in their correct folder.
Or can download it directly from: https://github.com/mc12345678/EasyPo...ive/master.zip
-
Re: EasyPopulate 4.0 Support Thread
Is it possible to assign the sort order of categories using EP4? I currently populate all of my categories using the CategoryMeta file, but I can't find a way of assigning the sort order
Thanks in advance for any suggestions
Kind Regards
John
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
jrobbo
Is it possible to assign the sort order of categories using EP4? I currently populate all of my categories using the CategoryMeta file, but I can't find a way of assigning the sort order
Thanks in advance for any suggestions
Kind Regards
John
Category specific information should be available through the category export/import. I think that was also discussed within the last couple of pages or so as well.
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
mc12345678
Category specific information should be available through the category export/import. I think that was also discussed within the last couple of pages or so as well.
I went back 15 pages but was not able to find any relevant info.
I am using the Full Category export and import features to update my category meta data, but there is no field in either of the category import/export files to specify the category sort-order. Is there any way to add that field please?
John
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
jrobbo
I went back 15 pages but was not able to find any relevant info.
I am using the Full Category export and import features to update my category meta data, but there is no field in either of the category import/export files to specify the category sort-order. Is there any way to add that field please?
John
Will look into this later today.
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
mc12345678
Will look into this later today.
Thanks very much MC, I apprectae your efforts
Cheers
John
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
jrobbo
I went back 15 pages but was not able to find any relevant info.
I am using the Full Category export and import features to update my category meta data, but there is no field in either of the category import/export files to specify the category sort-order. Is there any way to add that field please?
John
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.
-
Re: EasyPopulate 4.0 Support Thread
Is the 4.0.26 compatible with ZC 1.5.1? or it is for 1.5.3 only?