-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
chuckrey
So I just finished removing EP 4.0 and reinstalled the latest from Github. I did not have any luck, same result of not displaying the data from Basic Attributes.....
However.. I tested an older version I have on my hard drive. Specifically Easy Populate 4.0.30 - Beta 06-27-2015 and it worked where all data is now downloading without an issue. The version that was not allowing me to export Basic Attributes is Easy Populate 4.0.37.13 - 05-03-2021
The question remains (for clarity) the detailed attributes export from the same store that is having an issue with the basic attributes export, works or only a single record? Could also identify php version and zen cart version, please? Done any phpmyadmin query testing of the database? I'll go back and try to review such an old version but without understanding why this one is not displaying all of the data for you but is for others makes it difficult to diagnose or claim specifically is a problem with the software, especially when the same software was reported as installed in a different store and reported as fully functional.
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
JNR345
Issue with images ... I've tried everything to figure this out. When using a CSV file with Easy Populate everything works fine but the images remain small when clicking on the "larger image" link. The pop-up will only display a small image. The only way to fix this is through the admin by clicking the edit button for the product, click preview, and then save. That fixes the issue for every item. But why does "Easy Populate" cause this problem with every CSV import? I've tried making the image names and extension lowercase (and lowercase as well in the CSV file) so they all match but it doesn't help. Any ideas?
Only idea(s) that come to mind is that there is some other image handling software that does something when processing through the normal admin. Standard image processing reads the database file location for TY e base product image and then uses the "rules" for images to locate the large, additional, etc. Images for that product. I know that software such as image handler processes an image when it goes through the handler. I can't recall if the user doesn't see the results until the image is loaded a second time or if it's compression is observable on the first visit.
In other words, I have no explanation to why it happens on the site in question as there is nothing that is done that should cause or allow an issue such as that.
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
mc12345678
The question remains (for clarity) the detailed attributes export from the same store that is having an issue with the basic attributes export, works or only a single record? Could also identify php version and zen cart version, please? Done any phpmyadmin query testing of the database? I'll go back and try to review such an old version but without understanding why this one is not displaying all of the data for you but is for others makes it difficult to diagnose or claim specifically is a problem with the software, especially when the same software was reported as installed in a different store and reported as fully functional.
I am using php 7.2 and ZC 1.5.7c.
The Detailed Attributes is working without an issue as it exports all data. Basic Attributes exports one line of data. I checked the database and the data is all there and did not see any issue. I have another site that I can run the most recent EP and see if I have a different result, but will likely get that done in the morning.
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
mc12345678
Only idea(s) that come to mind is that there is some other image handling software that does something when processing through the normal admin. Standard image processing reads the database file location for TY e base product image and then uses the "rules" for images to locate the large, additional, etc. Images for that product. I know that software such as image handler processes an image when it goes through the handler. I can't recall if the user doesn't see the results until the image is loaded a second time or if it's compression is observable on the first visit.
In other words, I have no explanation to why it happens on the site in question as there is nothing that is done that should cause or allow an issue such as that.
Thanks for your help. I'm using the latest version of Zen Cart (version 1.5.7c) but this same thing has happened in the previous versions of Zen Cart as well (so which version doesn't seem to matter). Am I the only one experiencing this? So strange, as I've installed several Zen Cart stores and they all do this. I don't have any plugins other than Easy Populate. Why would clicking edit, then preview, and then save fix the problem? That's what I do to every product (hundreds of products). Very frustrating as I'm always importing new products (if I don't, the images remain small and never fix themselves). I think perhaps this problem may be happening to others but they aren't clicking on the "larger image" link so they don't realize the issue. Surely I'm not the only one?
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
chuckrey
I am using php 7.2 and ZC 1.5.7c.
The Detailed Attributes is working without an issue as it exports all data. Basic Attributes exports one line of data. I checked the database and the data is all there and did not see any issue. I have another site that I can run the most recent EP and see if I have a different result, but will likely get that done in the morning.
Okay, so when say "all the data is there" what query from EP4 was executed from within phpmyadmin to validate this statement? My question here is if there is a problem with the query or how the data is handled once the query has been executed. Further what about this store is causing a difference than the other store reported to work correctly.
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
JNR345
Thanks for your help. I'm using the latest version of Zen Cart (version 1.5.7c) but this same thing has happened in the previous versions of Zen Cart as well (so which version doesn't seem to matter). Am I the only one experiencing this? So strange, as I've installed several Zen Cart stores and they all do this. I don't have any plugins other than Easy Populate. Why would clicking edit, then preview, and then save fix the problem? That's what I do to every product (hundreds of products). Very frustrating as I'm always importing new products (if I don't, the images remain small and never fix themselves). I think perhaps this problem may be happening to others but they aren't clicking on the "larger image" link so they don't realize the issue. Surely I'm not the only one?
So as a "test". If you now export data that includes a product in your previous import and compare the v_products_image path between the two files, what is the difference?
If there are no other plugins installed, the images are loaded to the site via ftp or whatever and the database is updated e by either EP4 or stepping through the product update process, then the fields should be exactly the same and further neither process really does anything with the image itself. The browser on the other hand may operate differently and may require such a process to support sufficient display. What content is in the field space of the CSV file for that image field? It may be possible that "additional" information may be present that interferes with the browser's processing of the HTML. Perhaps could provide a link to one of these updated products that is not behaving properly.
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
mc12345678
Okay, so when say "all the data is there" what query from EP4 was executed from within phpmyadmin to validate this statement? My question here is if there is a problem with the query or how the data is handled once the query has been executed. Further what about this store is causing a difference than the other store reported to work correctly.
I misunderstood. I checked the data within phpmyadmin but did not run a query, sorry for my confusion. Can you please advise which query I can run and I will share the results?
Also, I checked the easypopulate_4_export.php file and replaced row 222-301 with the following and it worked, all data is showing when processing Basic Attributtes. Of course the code is coming from a previous version of EP4
/ these variables are for the Attrib_Basic Export
$active_products_id = ""; // start empty
$active_options_id = ""; // start empty
$active_language_id = ""; // start empty
$active_row = array(); // empty array
$last_products_id = "";
$print1 = 0;
$result = ep_4_query($filelayout_sql);
while ($row = ($ep_uses_mysqli ? mysqli_fetch_array($result) : mysql_fetch_array($result))) {
if ($ep_dltype == 'attrib_basic') { // special case 'attrib_basic'
if ($row['v_products_id'] == $active_products_id) {
if ($row['v_options_id'] == $active_options_id) {
// collect the products_options_values_name
if ($active_language_id <> $row['v_language_id']) {
$l_id = $row['v_language_id'];
$active_row['v_products_options_type'] = $row['v_products_options_type'];
$active_row['v_products_options_name_'.$l_id] = $row['v_products_options_name'];
$active_row['v_products_options_values_name_'.$l_id] = $row['v_products_options_values_name'];
$active_language_id = $row['v_language_id'];
} else {
$l_id = $row['v_language_id'];
$active_row['v_products_options_name_'.$l_id] = $row['v_products_options_name'];
$active_row['v_products_options_values_name_'.$l_id] .= ",".$row['v_products_options_values_name'];
$active_row['v_products_options_type'] = $row['v_products_options_type'];
}
continue; // loop - for more products_options_values_name on same v_products_id/v_options_id combo
} else { // same product, new attribute - only executes once on new option
// Clean the texts that could break CSV file formatting
$dataRow = '';
$problem_chars = array("\r", "\n", "\t"); // carriage return, newline, tab
foreach($filelayout as $key => $value) {
$thetext = $active_row[$key];
// remove carriage returns, newlines, and tabs - needs review
$thetext = str_replace($problem_chars,' ',$thetext);
// encapsulate data in quotes, and escape embedded quotes in data
$dataRow .= '"'.str_replace('"','""',$thetext).'"'.$csv_delimiter;
}
// Remove trailing tab, then append the end-of-line
$dataRow = rtrim($dataRow,$csv_delimiter)."\n";
fwrite($fp, $dataRow); // write 1 line of csv data (this can be slow...)
$ep_export_count++;
$active_options_id = $row['v_options_id'];
$active_language_id = $row['v_language_id'];
$l_id = $row['v_language_id'];
$active_row['v_products_options_name_'.$l_id] = $row['v_products_options_name'];
$active_row['v_products_options_values_name_'.$l_id] = $row['v_products_options_values_name'];
$active_row['v_products_options_type'] = $row['v_products_options_type'];
continue; // loop - for more products_options_values_name on same v_products_id/v_options_id combo
}
} else { // new combo or different product or first time through while-loop
if ($active_row['v_products_model'] <> $last_products_id) {
// Clean the texts that could break CSV file formatting
$dataRow = '';
$problem_chars = array("\r", "\n", "\t"); // carriage return, newline, tab
foreach($filelayout as $key => $value) {
$thetext = $active_row[$key];
// remove carriage returns, newlines, and tabs - needs review
$thetext = str_replace($problem_chars,' ',$thetext);
// encapsulate data in quotes, and escape embedded quotes in data
$dataRow .= '"'.str_replace('"','""',$thetext).'"'.$csv_delimiter;
}
// Remove trailing tab, then append the end-of-line
$dataRow = rtrim($dataRow,$csv_delimiter)."\n";
fwrite($fp, $dataRow); // write 1 line of csv data (this can be slow...)
$ep_export_count++;
$last_products_id = $active_row['v_products_model'];
}
// get current row of data
$active_products_id = $row['v_products_id'];
$active_options_id = $row['v_options_id'];
$active_language_id = $row['v_language_id'];
$active_row['v_products_model'] = $row['v_products_model'];
$active_row['v_products_options_type'] = $row['v_products_options_type'];
$l_id = $row['v_language_id'];
$active_row['v_products_options_name_'.$l_id] = $row['v_products_options_name'];
$active_row['v_products_options_values_name_'.$l_id] = $row['v_products_options_values_name'];
} // end of special case 'attrib_basic'
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
chuckrey
I misunderstood. I checked the data within phpmyadmin but did not run a query, sorry for my confusion. Can you please advise which query I can run and I will share the results?
Also, I checked the easypopulate_4_export.php file and replaced row 222-301 with the following and it worked, all data is showing when processing Basic Attributtes. Of course the code is coming from a previous version of EP4
Code:
// these variables are for the Attrib_Basic Export
$active_products_id = ""; // start empty
$active_options_id = ""; // start empty
$active_language_id = ""; // start empty
$active_row = array(); // empty array
$last_products_id = "";
$print1 = 0;
$result = ep_4_query($filelayout_sql);
while ($row = ($ep_uses_mysqli ? mysqli_fetch_array($result) : mysql_fetch_array($result))) {
if ($ep_dltype == 'attrib_basic') { // special case 'attrib_basic'
if ($row['v_products_id'] == $active_products_id) {
if ($row['v_options_id'] == $active_options_id) {
// collect the products_options_values_name
if ($active_language_id <> $row['v_language_id']) {
$l_id = $row['v_language_id'];
$active_row['v_products_options_type'] = $row['v_products_options_type'];
$active_row['v_products_options_name_'.$l_id] = $row['v_products_options_name'];
$active_row['v_products_options_values_name_'.$l_id] = $row['v_products_options_values_name'];
$active_language_id = $row['v_language_id'];
} else {
$l_id = $row['v_language_id'];
$active_row['v_products_options_name_'.$l_id] = $row['v_products_options_name'];
$active_row['v_products_options_values_name_'.$l_id] .= ",".$row['v_products_options_values_name'];
$active_row['v_products_options_type'] = $row['v_products_options_type'];
}
continue; // loop - for more products_options_values_name on same v_products_id/v_options_id combo
} else { // same product, new attribute - only executes once on new option
// Clean the texts that could break CSV file formatting
$dataRow = '';
$problem_chars = array("\r", "\n", "\t"); // carriage return, newline, tab
foreach($filelayout as $key => $value) {
$thetext = $active_row[$key];
// remove carriage returns, newlines, and tabs - needs review
$thetext = str_replace($problem_chars,' ',$thetext);
// encapsulate data in quotes, and escape embedded quotes in data
$dataRow .= '"'.str_replace('"','""',$thetext).'"'.$csv_delimiter;
}
// Remove trailing tab, then append the end-of-line
$dataRow = rtrim($dataRow,$csv_delimiter)."\n";
fwrite($fp, $dataRow); // write 1 line of csv data (this can be slow...)
$ep_export_count++;
$active_options_id = $row['v_options_id'];
$active_language_id = $row['v_language_id'];
$l_id = $row['v_language_id'];
$active_row['v_products_options_name_'.$l_id] = $row['v_products_options_name'];
$active_row['v_products_options_values_name_'.$l_id] = $row['v_products_options_values_name'];
$active_row['v_products_options_type'] = $row['v_products_options_type'];
continue; // loop - for more products_options_values_name on same v_products_id/v_options_id combo
}
} else { // new combo or different product or first time through while-loop
if ($active_row['v_products_model'] <> $last_products_id) {
// Clean the texts that could break CSV file formatting
$dataRow = '';
$problem_chars = array("\r", "\n", "\t"); // carriage return, newline, tab
foreach($filelayout as $key => $value) {
$thetext = $active_row[$key];
// remove carriage returns, newlines, and tabs - needs review
$thetext = str_replace($problem_chars,' ',$thetext);
// encapsulate data in quotes, and escape embedded quotes in data
$dataRow .= '"'.str_replace('"','""',$thetext).'"'.$csv_delimiter;
}
// Remove trailing tab, then append the end-of-line
$dataRow = rtrim($dataRow,$csv_delimiter)."\n";
fwrite($fp, $dataRow); // write 1 line of csv data (this can be slow...)
$ep_export_count++;
$last_products_id = $active_row['v_products_model'];
}
// get current row of data
$active_products_id = $row['v_products_id'];
$active_options_id = $row['v_options_id'];
$active_language_id = $row['v_language_id'];
$active_row['v_products_model'] = $row['v_products_model'];
$active_row['v_products_options_type'] = $row['v_products_options_type'];
$l_id = $row['v_language_id'];
$active_row['v_products_options_name_'.$l_id] = $row['v_products_options_name'];
$active_row['v_products_options_values_name_'.$l_id] = $row['v_products_options_values_name'];
} // end of special case 'attrib_basic'
I believe I have found the issue. Please answer at least the below first question. I ask that the second be answered only if the answer to the first is yes.
1. On the other site where EP4 basic attributes were expiring propelling, was the primary key set to the default of products_model?
2. To be answered if the above was yes. What custom field(s) are identified for import/export?
In either case, thank you for reporting this issue. I can see that as>was trying to simplify the code more and also offer additional options that some of the code changes were incomplete for use by the many as compared to the few.
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
mc12345678
I believe I have found the issue. Please answer at least the below first question. I ask that the second be answered only if the answer to the first is yes.
1. On the other site where EP4 basic attributes were expiring propelling, was the primary key set to the default of products_model?
2. To be answered if the above was yes. What custom field(s) are identified for import/export?
In either case, thank you for reporting this issue. I can see that as>was trying to simplify the code more and also offer additional options that some of the code changes were incomplete for use by the many as compared to the few.
1. - Yes, products_model
2. I am not certain as to which setting you are referring so I am going to send all settings. Sorry.
Uploads Directory - temp/
Uploads Directory Admin/Catalog - true
Import/Export Primary Key - products_model
Import Language Override - language_id
Import/Export CSV Delimiter - ,
Export Language Identifier - id
Export Price Decimals - 2
Upload File Date Format - m-d-y
Default Raw Time - 09:00:00
Export Filename Date - Y-m-d
Upload/Download Prices Include Tax - false
Verbose Feedback - true
Show all EP4 Filetypes with Files - true
Replace Blank Image - false
Activate Blank Featured - true
Remove Blank Specials - negative
Make Zero Qty Products Inactive - false
Smart Tags Replacement of Newlines - true
Advanced Smart Tags - false
Auto-extend fields - false
Debug Logging - true
Maximum Quantity Discounts - 0
Split On Number of Records - 2000
Script Execution Time - 60
Convert Curly Quotes, etc. - 0
Convert Character 0x92 - 1
Enable Products Meta Data - 1
Enable Products Music Data - 0
User Defined Products Fields [this field is blank]
Export URI with Prod and or Cat - 1
Thank you for all your work, EP is a necessity and I am surprised this is not included w/ the install.
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
chuckrey
1. - Yes, products_model
2. I am not certain as to which setting you are referring so I am going to send all settings. Sorry.
Uploads Directory - temp/
Uploads Directory Admin/Catalog - true
Import/Export Primary Key - products_model
Import Language Override - language_id
Import/Export CSV Delimiter - ,
Export Language Identifier - id
Export Price Decimals - 2
Upload File Date Format - m-d-y
Default Raw Time - 09:00:00
Export Filename Date - Y-m-d
Upload/Download Prices Include Tax - false
Verbose Feedback - true
Show all EP4 Filetypes with Files - true
Replace Blank Image - false
Activate Blank Featured - true
Remove Blank Specials - negative
Make Zero Qty Products Inactive - false
Smart Tags Replacement of Newlines - true
Advanced Smart Tags - false
Auto-extend fields - false
Debug Logging - true
Maximum Quantity Discounts - 0
Split On Number of Records - 2000
Script Execution Time - 60
Convert Curly Quotes, etc. - 0
Convert Character 0x92 - 1
Enable Products Meta Data - 1
Enable Products Music Data - 0
User Defined Products Fields [this field is blank]
Export URI with Prod and or Cat - 1
Thank you for all your work, EP is a necessity and I am surprised this is not included w/ the install.
Those are the settings from which store? The one where basic attributes export works or doesn't?
Thanks. Will note, one always has options about the tool to use to accomplish a task. There are other applications available to perform similar or subset tasks.
-
Re: EasyPopulate 4.0 Support Thread
Hi
I am having an issue with the module while updating quantity discounts. I have worked with this module earlier never faced any issue.
While updating products quantity pricing it shows but it does not reflect in the site. I checked the table zen_products_discount_quantity and see that the values are not updated.## I tried reinstalling etc. Still the same. Is there any idea what's happening?
Version of Zencart is## v1.5.7c
Easy Populate 4
Filename: priceqty-epDEC.csv
UPDATED! - v_products_model: AB144 | 1 | 1.52 | 2 | 0 | 100 | 1.44 | 301 | 1.34 | | |
UPDATED! - v_products_model: AB145 | 1 | 1.52 | 2 | 0 | 100 | 1.44 | 301 | 1.34 | | |
RegardsNisha
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
nishajh
Hi
I am having an issue with the module while updating quantity discounts. I have worked with this module earlier never faced any issue.
While updating products quantity pricing it shows but it does not reflect in the site. I checked the table zen_products_discount_quantity and see that the values are not updated.## I tried reinstalling etc. Still the same. Is there any idea what's happening?
Version of Zencart is## v1.5.7c
Easy Populate 4
Filename: priceqty-epDEC.csv
UPDATED! - v_products_model: AB144 | 1 | 1.52 | 2 | 0 | 100 | 1.44 | 301 | 1.34 | | |
UPDATED! - v_products_model: AB145 | 1 | 1.52 | 2 | 0 | 100 | 1.44 | 301 | 1.34 | | |
RegardsNisha
You mean a price breakdown import where instead of:
Code:
Filename: priceqty-epDEC.csv
Should be:
Code:
Filename: pricebreaks-epDEC.csv
-
Re: EasyPopulate 4.0 Support Thread
Thank you. That solved the issue
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
nishajh
Thank you. That solved the issue
No problem. Hope you have/had a Happy New Year!
-
Re: EasyPopulate 4.0 Support Thread
Sorry for the long delay, I was away w/ the family off the grid for a bit.
That is from the site where Basic Attributes was not working for me. Do you need the settings from the other site ?
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
chuckrey
Sorry for the long delay, I was away w/ the family off the grid for a bit.
That is from the site where Basic Attributes was not working for me. Do you need the settings from the other site ?
Please provide the same so that can see if those settings drive a different result on export or if there is another factor to consider. Thank you and no problem on the delay, thank you for taking the time to come back and address.
-
Re: EasyPopulate 4.0 Support Thread
Here are the settings for the other file.
Thanks.
Uploads Directory - temp/
Uploads Directory Admin/Catalog - true
Import/Export Primary Key - products_model
Upload File Date Format - m-d-y
Default Raw Time - 09:00:00
Upload/Download Prices Include Tax - false
Verbose Feedback - true
Show all EP4 Filetypes with Files - true
Replace Blank Image - false
Activate Blank Featured - true
Make Zero Qty Products Inactive - false
Smart Tags Replacement of Newlines - true
Advanced Smart Tags - false
Debug Logging - true
Maximum Quantity Discounts - 3
Split On Number of Records - 2000
Script Execution Time - 60
Convert Curly Quotes, etc. - 0
Convert Character 0x92 - 1
Enable Products Meta Data - 1
Enable Products Music Data - 0
User Defined Products Fields -
Export URI with Prod and or Cat - 0
-
Re: EasyPopulate 4.0 Support Thread
GitHub: there are many branches and the Master seems way behind others. Hard to know what to use, to feed back PRs....
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
torvista
GitHub: there are many branches and the Master seems way behind others. Hard to know what to use, to feed back PRs....
Without knowing what the suggestion is, I would say that the master branch should be used to then maybe incorporate into a further appropriate location.
-
Re: EasyPopulate 4.0 Support Thread
I just don't want to reinvent wheels....for things that are already addressed in another branch.
Suggestions could be many, or nothing show-stopping yet.
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
torvista
I just don't want to reinvent wheels....for things that are already addressed in another branch.
Suggestions could be many, or nothing show-stopping yet.
Perhaps could raise a an issue and if already addressed then can point out the where? Right now one of the issues is that there has been an overhaul of some central processing to then also address existing issues.
I can say that one "topic" that is being worked on though not yet shown in Github is identification of database field defaults to expand on improved import capability. Unfortunately for me I have been focusing on update operations more than insert and had lost out on addressing import of product where fields were omitted. I didn't want to implement something very short term that was going to need to be undone immediately so am trying to address it in a single modification with any issues identified to be corrected.
-
2 Attachment(s)
Re: EasyPopulate 4.0 Support Thread
i need help using Easy Populate V4
I am trying copy all my product from one store to another.
Easy populate installation was easy on both store.
I choose Complete product as an export but i am getting an error when trying to upload it to the new store.
The error is and goes for all products:
SKIPPED! - v_products_model: FI66 - No category provided for this new product
SKIPPED! - v_products_model: E8-4812P - No category provided for this new product
SKIPPED! - v_products_model: FI86 - No category provided for this new product
SKIPPED! - v_products_model: FD85 - No category provided for this new product
SKIPPED! - v_products_model: FW89 - No category provided for this new product
However the file has a v_category_name_1 and the new store is entirely blank ( see screenshot)
Any ideas on how to fix this? Thank you for your help
Attachment 19911
Attachment 19912
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
nicksab
i need help using Easy Populate V4
I am trying copy all my product from one store to another.
Easy populate installation was easy on both store.
I choose Complete product as an export but i am getting an error when trying to upload it to the new store.
The error is and goes for all products:
SKIPPED! - v_products_model: FI66 - No category provided for this new product
SKIPPED! - v_products_model: E8-4812P - No category provided for this new product
SKIPPED! - v_products_model: FI86 - No category provided for this new product
SKIPPED! - v_products_model: FD85 - No category provided for this new product
SKIPPED! - v_products_model: FW89 - No category provided for this new product
However the file has a v_category_name_1 and the new store is entirely blank ( see screenshot)
Any ideas on how to fix this? Thank you for your help
Attachment 19911
Attachment 19912
Sigh, let's try this a different way since about the last 5 to 6 pages haven't been read. So the file for input has a category designation that ends with a number. Do you know what that number means or what the significance is about it ending with a number? The number represents the language_id of the language that was exported. Now the program has two features, an import and an export. Each have independent controls. Based on the above description I'm pretty sure I know the cause unless information has been purposely withheld. That said, to learn to fish is better than being fed a fish. So export was fine but having an issue with import. Might there be some configuration settings related to the import that might relate to what is being experienced?
More importantly though.... why are you not using a standard zen Cart process to move and or upgrade the store? Why use any bulk product system to only transfer product to a blank store?
Sorry to make statement in the first paragraph with such tone. The mistake I made in my last upload of the software directly relates to this issue, has been described and discussed multiple times and in my opinion should be something easy to spot as a fix by reading just a few posts. It concerns me when the fix is so simple but takes so much. Yes if I upload a corrected copy it will fix that issue but I'm not really ready because I haven't fixed a separate issue yet that really would need a new version so kind of a waste to issue them in such small groups. Of course instead I talk about it lot... so lose lose in that. Anyways, please do the above homework. Post what you discover or what cannot be found. Glad to help figure things out even if it's something in the instructions. As I said, I took a different approach on trying to address this particular issue of what I expect to be related to my mess up with some settings in my last update.
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
mc12345678
Sigh, let's try this a different way since about the last 5 to 6 pages haven't been read. So the file for input has a category designation that ends with a number. Do you know what that number means or what the significance is about it ending with a number? The number represents the language_id of the language that was exported. Now the program has two features, an import and an export. Each have independent controls. Based on the above description I'm pretty sure I know the cause unless information has been purposely withheld. That said, to learn to fish is better than being fed a fish. So export was fine but having an issue with import. Might there be some configuration settings related to the import that might relate to what is being experienced?
More importantly though.... why are you not using a standard zen Cart process to move and or upgrade the store? Why use any bulk product system to only transfer product to a blank store?
Sorry to make statement in the first paragraph with such tone. The mistake I made in my last upload of the software directly relates to this issue, has been described and discussed multiple times and in my opinion should be something easy to spot as a fix by reading just a few posts. It concerns me when the fix is so simple but takes so much. Yes if I upload a corrected copy it will fix that issue but I'm not really ready because I haven't fixed a separate issue yet that really would need a new version so kind of a waste to issue them in such small groups. Of course instead I talk about it lot... so lose lose in that. Anyways, please do the above homework. Post what you discover or what cannot be found. Glad to help figure things out even if it's something in the instructions. As I said, I took a different approach on trying to address this particular issue of what I expect to be related to my mess up with some settings in my last update.
No offense or hard feelings but this is a really long thread ( over 340 pages )to digest and go thru. It is not really easy to understand or read some of it either.
And no I am not witholding any information.
I thought the error " no categories provided" related to the " category_name" not being provided in the csv file.
I do know and saw what the number 1 means and that is related to the language. My site is not multilingual so i don t think that s the issue.
I honestly thought using easy populate would be a cleaner way of upgrading/switching a store. I should probably go back to the standard upgrade process and leave easy populate alone until it is fixed.
Thanks for taking the timeto look over my issue.
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
nicksab
No offense or hard feelings but this is a really long thread ( over 340 pages )to digest and go thru. It is not really easy to understand or read some of it either.
And no I am not witholding any information.
I thought the error " no categories provided" related to the " category_name" not being provided in the csv file.
I do know and saw what the number 1 means and that is related to the language. My site is not multilingual so i don t think that s the issue.
I honestly thought using easy populate would be a cleaner way of upgrading/switching a store. I should probably go back to the standard upgrade process and leave easy populate alone until it is fixed.
Thanks for taking the timeto look over my issue.
Well it can be "foxed" by changing a configuration setting... hence why I asked what the import settings were in the configuration menu... add for reading... so in the works would read a thread that is more than 10 years old from the beginning to the end? Especially if using a recent version of the software? Start towards the back and read at most to the last release of it... if the question still can't be answered, then certainly need to ask.
The error did relate to the categories name. Directly so.
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
mc12345678
Well it can be "foxed" by changing a configuration setting... hence why I asked what the import settings were in the configuration menu... add for reading... so in the works would read a thread that is more than 10 years old from the beginning to the end? Especially if using a recent version of the software? Start towards the back and read at most to the last release of it... if the question still can't be answered, then certainly need to ask.
The error did relate to the categories name. Directly so.
mc12345678,
I owe you a sincere apology and thank you for pointing me in the right direction.
For anyone facing the same issue, the answer is in post #3294
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
nicksab
mc12345678,
I owe you a sincere apology and thank you for pointing me in the right direction.
For anyone facing the same issue, the answer is in post #3294
Well thank you. The issue was though described in a way different than those previously reporting the same type of problem and I know full well how it is always desirable for everything to work with zero additional change or adjustment. I still suggest using the standard zen Cart process to "move" the product though really am more concerned about the customer experience, but hope that you are able to accomplish what is needed.
If you do decide to continue using this to move product *and* retain product reference for customers or search engines, then there is another configuration switch that I suggest modifying away from default settings on both stores which is to use the Product's ID as the primary key instead of the default products model.
-
Re: EasyPopulate 4.0 Support Thread
Regarding the import of multiple categories for products, just done a 1000 line import and subsequently discovered errors in the csv that created unwanted categories.
Is there a switch to prevent the creation of new categories/only allow products to be assigned/linked to existing categories?
-
Re: EasyPopulate 4.0 Support Thread
When I upload a file the column v_categories_name_1 always has a category listed. I've never had a problem with wrong categories. If you have a category for example under men's shoes then sneakers your product category would look like men's shoes^sneakers
-
Re: EasyPopulate 4.0 Support Thread
I have two languages and in some products the second column for ES had the category name EN so it created those as new categories, as per design.
So if there is no switch to prevent this, I'll add one to prevent this in future.
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
torvista
Regarding the import of multiple categories for products, just done a 1000 line import and subsequently discovered errors in the csv that created unwanted categories.
Is there a switch to prevent the creation of new categories/only allow products to be assigned/linked to existing categories?
Quote:
Originally Posted by
keith z
When I upload a file the column v_categories_name_1 always has a category listed. I've never had a problem with wrong categories. If you have a category for example under men's shoes then sneakers your product category would look like men's shoes^sneakers
Quote:
Originally Posted by
torvista
I have two languages and in some products the second column for ES had the category name EN so it created those as new categories, as per design.
So if there is no switch to prevent this, I'll add one to prevent this in future.
Unfortunately, even with the above added information, there are still characteristics that are not identified. For example, did the file itself contain multiple rows that caused the generation of linked product or did the product already exist within the database and the file contained additional rows of data where the category didn't/no longer existed and would become new? There are also considerations to factor in especially with multiple languages such as why was the additional field present to include the new (linked product generating) category?
As has been the case as long as category linking has been incorporated, the control of this has been in the management of the original data. A single column is used as the primary key, having two records in the file that match that primary key offers an opportunity for "undesired" data to be import/modified. Not including the category column would prevent the generation of linked categories though would prevent that file from being used to import new product because of the absence of a category. Could something be added to the file to mark or indicate the need to process or exclude a row, sure. But if editing the file to include or otherwise flag a row to do something special, why have the row in the file to begin with instead of an additional file needed to perform that particular action?
The above is a little bit of an explanation of why such hasn't been previously developed and some of the issues or ways to work around them. Can a switch be added to prevent the generation of linked categories? Yes. So can one to use only the first row of data encountered, the last row, or anywhere in between. That bit of a facetious statement comes from trying to see the benefit and/or how adding such a feature would help others (with minimal further explanation/engagement). I made a mistake already and was concerned that there was an issue with the use of language_code versus language_id; however, the above says that it was all within a given language identifier (language_code), but in this case two languages were included and specifically a single field had data that was not desired to be at least "fully" included/considered. Interested in further understanding the situation so that can figure out incorporation in addition to responding to the items that were recently brought up.
-
Re: EasyPopulate 4.0 Support Thread
Quote:
For example, did the file itself contain multiple rows that caused the generation of linked product or did the product already exist within the database and the file contained additional rows of data where the category didn't/no longer existed and would become new?
The products already existed.
The categories already existed.
The import was to link the products to multiple other categories.
The problem-causing rows had the same category name (EN) in both the EN and ES column.
As that EN category-name did not exist in spanish, a new category was created having the same name in both languages.
I mainly use DBIO, which does not have category imports. That uses a command column for optional functionality, like expressly allowing creation or not.
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
eavinu
So I am happy to say that finally the Unknown CSV Delimiter issue was solved.
I don't know why I didn't try this before...
At first, since this was an upgraded website and had previous versions of EP (1.2....), there was a temp folder in the root and I left it there, changed in the EP4 configuration to false under Uploads directory Admin/Catalog.
Now I decided to move it to the Admin folder and changed the configuration to True and the Unknown CSV Delimiter indication turned to a "CSV ," indication.
Thank you so much for posting this solution!
I had the same problem ("Unknown CSV Delimiter" error although everything looked good to me) and initial setup.
Luckily I found your post, it would have taken me quite a long time to realize it otherwise, since the error message is quite misleading in this case.
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
marcopm
Thank you so much for posting this solution!
I had the same problem ("Unknown CSV Delimiter" error although everything looked good to me) and initial setup.
Luckily I found your post, it would have taken me quite a long time to realize it otherwise, since the error message is quite misleading in this case.
The real fix can be found in this post: https://www.zen-cart.com/showthread....80#post1385080
Changing the setting to access files off of the admin directory has its benefits, but for some that would mean they would have to provide that path name to another vendor. Again, unfortunately it had been developed to be too protective.
-
Re: EasyPopulate 4.0 Support Thread
I'm running in to the following error.
I am running ZC1.5.7d and Easy Populate 4.0.37.13 - 05-03-2021.
I just did a fresh install (with some mods for a custom product type). (Had problems with the install until I hit the "Install EP4" link but that's another problem :)).
I managed to get the files to be created however, I tried to import the file that was just created and was thrown this error.
Code:
[28-Apr-2022 03:13:10 America/New_York] PHP Fatal error: Uncaught Error: Call to undefined function mysql_query() in E:\xampp\htdocs\yyyy\easypopulate_4.php:819
Stack trace:
#0 E:\xampp\htdocs\yyyy\index.php(11): require()
#1 {main}
thrown in E:\xampp\htdocs\yyyy\easypopulate_4.php on line 819
[28-Apr-2022 03:13:10 America/New_York] Request URI: /yyyy/index.php?cmd=easypopulate_4, IP address: 127.0.0.1
--> PHP Fatal error: Uncaught Error: Call to undefined function mysql_query() in E:\xampp\htdocs\yyyy\easypopulate_4.php:819
Stack trace:
#0 E:\xampp\htdocs\yyyy\index.php(11): require()
#1 {main}
thrown in E:\xampp\htdocs\yyyy\easypopulate_4.php on line 819.
So here's where things get weird... I found the line that was referenced and it's part of a block that is testing for mysql vs. mysqli. For some reason, EP4 isn't seeing that mysqli should be used. (I'm running PHP 7.4.20.) I tried everything at this point... hell, I even tried setting line 62 to always true using:
PHP Code:
$ep_uses_mysqli = TRUE;
But... either way, after the page refreshes... the script resets itself to FALSE. (I can tell because I added the following to the "tests" under Configuration Settings on line 717(-ish):
PHP Code:
echo "Are you using MySQLi?: " . ($ep_uses_mysqli ? "TRUE" : "FALSE") . '<br />';
Before I try to import a CSV file this line tests TRUE. But afterwards and the page refreshes after an import attempt, this line sets itself to false. I am lost as to why that is or how to fix it. (Again, hardcoding this test to TRUE somehow sets it back to false :/)
Any help would be appreciated.
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
retched
:snip:
This attached post can be ignored. Evidently, I copied over code from an older EP4 that was always reverting $ep_uses_mysqli to FALSE. And it override the hard setting. Everything is working swimmingly for now.
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
retched
This attached post can be ignored. Evidently, I copied over code from an older EP4 that was always reverting $ep_uses_mysqli to FALSE. And it override the hard setting. Everything is working swimmingly for now.
Glad it has been sorted... I had looked through many portions of code and couldn't find what would have caused it in the above described version...
-
Re: EasyPopulate 4.0 Support Thread
Easy Populate is working great for me, with the exception of 1 issue. I can not get it to update the metatags_keywords_1 field. I am able to use EP4 to toggle the status (0/1) on the other Metatag fields (v_metatags_products_name_status,v_metatags_title_status) fine. It just seems to be the field where I can enter longer text that is the issue (metatags_keywords_1, metatags_description_1).
We recently upgraded to 1.5.7d and made sure all themes and modules are updated. I am able to manually enter the information for each item, and it does show when I download the store from EP4.
Any thoughts on where to start?
Thanks in advance for any help/thoughts.
Dan
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
DanMickle
Easy Populate is working great for me, with the exception of 1 issue. I can not get it to update the metatags_keywords_1 field. I am able to use EP4 to toggle the status (0/1) on the other Metatag fields (v_metatags_products_name_status,v_metatags_title_status) fine. It just seems to be the field where I can enter longer text that is the issue (metatags_keywords_1, metatags_description_1).
We recently upgraded to 1.5.7d and made sure all themes and modules are updated. I am able to manually enter the information for each item, and it does show when I download the store from EP4.
Any thoughts on where to start?
Thanks in advance for any help/thoughts.
Dan
See if the content at or further referenced back in the following post resolves the issue and please post back: https://www.zen-cart.com/newreply.ph...eply&p=1381450
-
Re: EasyPopulate 4.0 Support Thread
I went back through those threads and tried a few changes (language ID/Code, etc.) but they did not resolve the issue. I double-checked to make sure the "use products metadata" was enabled as well.
I did also verify because I thought I may have been mistaken when I first attempted a product update. I am able to update the following correctly (as well as the other standard fields):
v_metatags_products_name_status v_metatags_title_status v_metatags_model_status v_metatags_price_status v_metatags_title_tagline_status
however
v_metatags_title_1 v_metatags_keywords_1 v_metatags_description_1
will not update.
Maybe I am missing something in the past posts, so I am going back through them again. Thank you for taking the time and suggesting the post to start with.
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
DanMickle
I went back through those threads and tried a few changes (language ID/Code, etc.) but they did not resolve the issue. I double-checked to make sure the "use products metadata" was enabled as well.
I did also verify because I thought I may have been mistaken when I first attempted a product update. I am able to update the following correctly (as well as the other standard fields):
v_metatags_products_name_status v_metatags_title_status v_metatags_model_status v_metatags_price_status v_metatags_title_tagline_status
however
v_metatags_title_1 v_metatags_keywords_1 v_metatags_description_1
will not update.
Maybe I am missing something in the past posts, so I am going back through them again. Thank you for taking the time and suggesting the post to start with.
To ensure a full understanding, could you please identify the version of EP4 installed and then possibly the configuration settings (don't need to know anything about the path used for the upload/download folder)? Please be specific about identifying the version by its reported value.
Additionally, have you been successful with updating other records that are language based but not Metatag related?
-
3 Attachment(s)
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
mc12345678
To ensure a full understanding, could you please identify the version of EP4 installed and then possibly the configuration settings (don't need to know anything about the path used for the upload/download folder)? Please be specific about identifying the version by its reported value.
Additionally, have you been successful with updating other records that are language-based but not Metatag related?
I just tested with a record with two language-based (v_products_name_1) and (v_metatags_keywords_1) fields. The products_name_1 worked and the keywords_1 did not.
We are on versions:
- Easy Populate 4.0.37.13 - 05-03-2021
- Zen Cart 1.5.7d
- PHP 7.4.30 (Zend: 3.4.0)
I have attached screenshots.
-
3 Attachment(s)
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
mc12345678
To ensure a full understanding, could you please identify the version of EP4 installed and then possibly the configuration settings (don't need to know anything about the path used for the upload/download folder)? Please be specific about identifying the version by its reported value.
Additionally, have you been successful with updating other records that are language based but not Metatag related?
I just tested with a record using the v_products_name_1 and the v_metatags_keywords_1 fields. The v_products_name_1 updated correctly, and the v_metatags_keywords_1 did not update (field was blank to begin with).
We are currently on version:
Easy Populate 4.0.37.13 - 05-03-2021
Zen Cart 1.5.7d
PHP 7.4.30 (Zend: 3.4.0)
Screenshots of configs are attached.Attachment 20088Attachment 20089Attachment 20090
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
DanMickle
I just tested with a record using the v_products_name_1 and the v_metatags_keywords_1 fields. The v_products_name_1 updated correctly, and the v_metatags_keywords_1 did not update (field was blank to begin with).
We are currently on version:
Easy Populate 4.0.37.13 - 05-03-2021
Zen Cart 1.5.7d
PHP 7.4.30 (Zend: 3.4.0)
Screenshots of configs are attached.
Attachment 20088Attachment 20089Attachment 20090
Found the issue. Looks like additional effort to support independent update of each Metatag field hadn't been applied. E.g. on the call to minimize the number of columns in an import file or to support update of just one column, this set of data had been overlooked.
In the current code at least the title must be present, but, if all three Metatag fields are not provided, then the missing field(s) will be made blank.
In the interim to that being modified, suggestion is to include the title, description and keywords in the import file. For those that use software to read the content of this forum, the second image above showed an image of the file headers and one example of the attempted content. The headers were: v_products_model, v_products_name_1, and v_metatags_keywords_1.
In the course of this discussion, there has not been a statement that all three were attempted within a single file, so I can only assume that such had not been attempted and that the above is the issue. I have not yet run tests specific to that version and issue with a file that has all three fields that update the database. My response is based on reviewing the code while away from a computer.
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
mc12345678
Found the issue. Looks like additional effort to support independent update of each Metatag field hadn't been applied. E.g. on the call to minimize the number of columns in an import file or to support update of just one column, this set of data had been overlooked.
In the current code at least the title must be present, but, if all three Metatag fields are not provided, then the missing field(s) will be made blank.
In the interim to that being modified, suggestion is to include the title, description and keywords in the import file. For those that use software to read the content of this forum, the second image above showed an image of the file headers and one example of the attempted content. The headers were: v_products_model, v_products_name_1, and v_metatags_keywords_1.
In the course of this discussion, there has not been a statement that all three were attempted within a single file, so I can only assume that such had not been attempted and that the above is the issue. I have not yet run tests specific to that version and issue with a file that has all three fields that update the database. My response is based on reviewing the code while away from a computer.
That worked like a charm! Thank you firstly for helping and secondly for having me dig deeper before just handing me the answer. The historical info I went over gave me a better picture of how the module (and ZC) works, and that will obviously help in the future. I appreciate all your time and help.
-
Re: My CSV file uploads the categories, but not the products
v1.5.7d easypopulate 4.0
I am trying to use easypopulate to bulk delete products but am having issues. The process I have used is;
downloaded Model/Price/Qty file
opened the file in open office (OpenCalc)
changed v_status for products showing 0 to 9 (assumption being 9 means delete product)
a) saved file as .odt and uploaded with no result (products did not delete) and no warnings
then
b) saved file as .csv and uploaded with no result (products did not delete) with warning problem with delimiters (??) - in saving as .csv the delimiters selected were comma (,) and double quotes (")
There are no error logs
Have I gone about this the right way or is there a better way to delete products in bulk?
cheers, Mike
-
1 Attachment(s)
Re: My CSV file uploads the categories, but not the products
Quote:
Originally Posted by
shags38
v1.5.7d easypopulate 4.0
I am trying to use easypopulate to bulk delete products but am having issues. The process I have used is;
downloaded Model/Price/Qty file
opened the file in open office (OpenCalc)
changed v_status for products showing 0 to 9 (assumption being 9 means delete product)
a) saved file as .odt and uploaded with no result (products did not delete) and no warnings
then
b) saved file as .csv and uploaded with no result (products did not delete) with warning problem with delimiters (??) - in saving as .csv the delimiters selected were comma (,) and double quotes (")
There are no error logs
Have I gone about this the right way or is there a better way to delete products in bulk?
cheers, Mike
update ... as soon as a file is exported it shows up as 'CSV Unknown Delimiter' in the table as an import error in admin/tools/EP4 ... see image ... any ideas as to why?
Attachment 20093
-
Re: My CSV file uploads the categories, but not the products
Quote:
Originally Posted by
shags38
update ... as soon as a file is exported it shows up as 'CSV Unknown Delimiter' in the table as an import error in admin/tools/EP4 ... see image ... any ideas as to why?
Attachment 20093
If I had my guess correctly, because when I added the file location protection to the code, I made a mistake about handling files stored in the catalog side of the store and then subsequently the patch provided in this forum was not applied.
This is further described at this post and the link within the quote of that post: https://www.zen-cart.com/showthread....22#post1385422
To be clear, your previous post does or does not still apply? There are other reasons for what may have been seen or described there.
-
Re: My CSV file uploads the categories, but not the products
Quote:
Originally Posted by
mc12345678
If I had my guess correctly, because when I added the file location protection to the code, I made a mistake about handling files stored in the catalog side of the store and then subsequently the patch provided in this forum was not applied.
This is further described at this post and the link within the quote of that post:
https://www.zen-cart.com/showthread....22#post1385422
To be clear, your previous post does or does not still apply? There are other reasons for what may have been seen or described there.
Thanks for your response mc ... I updated admin/easypopulate_4.php with the code from github (using the above and below codes for verification my line numbers varied from that shown in the github but the code snippet was placed ti the correct sequence) .... but there is no change, i.e.
a) file when exported immediately shows in table as per figure previously posted with comment under 'import' tab "CSV Unknown Delimiter", and
b) upon uploading the file with data changes, clicking save in current format (v_status changed from '0' to '9' for about 100 products) this message appears in green across the top of the page "File uploaded Successfully: PriceBreaks-EP2022Aug05-104531.csv Issues with the CSV file delimiter(s)" - the exact same thing occurs in uploading an unmodified file, which would indicate that the exported file is the issue, not anything to do with modifying and reuploading?
c) products are not deleting ... ** the assumption here is that if the file was valid it would automativcally update the database (yes/no?)
downloaded files are opened in Open Office (OpenOffic Calc) and data changed in v_status column only then saved and upoladed. Because I need to change only v_status I have used only these file format requests Model/Price/Qty (with Specials) and Model/Price/Breaks (the latter to determine if the former file request was the issue)
The version installed is the LATEST downloaded from the EP4 plugin page - this is the configuration
Configuration Settings
Upload Directory: admin/temp/
Primary Key: products_model
Import Language Override: EASYPOPULATE_4_CONFIG_IMPORT_OVERRIDE
Verbose Feedback: TRUE
Split Records: 2000
Execution Time: 60
Convert Curly Quotes: No Change
Convert Char 0x92: Basic
Enable Products Metatags: 1
Enable Products Music: 0
Custom Products Fields
Product Short Descriptions: FALSE
Product Unit of Measure: FALSE
Product UPC Code: FALSE
Google Product Category: FALSE
Manufacturer's Suggested Retail Price: FALSE
Manufacturer's Advertised Price: FALSE
Group Pricing Per Item: FALSE
Exclusive Products Mod: FALSE
Stock By Attributes Mod: FALSE
CEON URI Rewriter Mod: TRUE
Dual Pricing Mod: TRUE
User Defined Products Fields:
Installed Languages
1-en: English
Default Language: 1-English
Internal Character Encoding: UTF-8
DB Collation: utf8mb4
Database Field Lengths
categories_name:64
manufacturers_name:32
products_model:32
products_name:64
products_url:255
artists_name:32
record_company_name:32
music_genre_name:32
-
Re: My CSV file uploads the categories, but not the products
Quote:
Originally Posted by
shags38
Thanks for your response mc ... I updated admin/easypopulate_4.php with the code from github (using the above and below codes for verification my line numbers varied from that shown in the github but the code snippet was placed ti the correct sequence) .... but there is no change, i.e.
a) file when exported immediately shows in table as per figure previously posted with comment under 'import' tab "CSV Unknown Delimiter", and
b) upon uploading the file with data changes, clicking save in current format (v_status changed from '0' to '9' for about 100 products) this message appears in green across the top of the page "File uploaded Successfully: PriceBreaks-EP2022Aug05-104531.csv Issues with the CSV file delimiter(s)" - the exact same thing occurs in uploading an unmodified file, which would indicate that the exported file is the issue, not anything to do with modifying and reuploading?
c) products are not deleting ... ** the assumption here is that if the file was valid it would automativcally update the database (yes/no?)
downloaded files are opened in Open Office (OpenOffic Calc) and data changed in v_status column only then saved and upoladed. Because I need to change only v_status I have used only these file format requests Model/Price/Qty (with Specials) and Model/Price/Breaks (the latter to determine if the former file request was the issue)
The version installed is the LATEST downloaded from the EP4 plugin page - this is the configuration
Configuration Settings
Upload Directory: admin/temp/
Primary Key: products_model
Import Language Override: EASYPOPULATE_4_CONFIG_IMPORT_OVERRIDE
Verbose Feedback: TRUE
Split Records: 2000
Execution Time: 60
Convert Curly Quotes: No Change
Convert Char 0x92: Basic
Enable Products Metatags: 1
Enable Products Music: 0
Custom Products Fields
Product Short Descriptions: FALSE
Product Unit of Measure: FALSE
Product UPC Code: FALSE
Google Product Category: FALSE
Manufacturer's Suggested Retail Price: FALSE
Manufacturer's Advertised Price: FALSE
Group Pricing Per Item: FALSE
Exclusive Products Mod: FALSE
Stock By Attributes Mod: FALSE
CEON URI Rewriter Mod: TRUE
Dual Pricing Mod: TRUE
User Defined Products Fields:
Installed Languages
1-en: English
Default Language: 1-English
Internal Character Encoding: UTF-8
DB Collation: utf8mb4
Database Field Lengths
categories_name:64
manufacturers_name:32
products_model:32
products_name:64
products_url:255
artists_name:32
record_company_name:32
music_genre_name:32
The latest file may be present but the updates to that version have not been executed. Obvious because of this line:
Import Language Override: EASYPOPULATE_4_CONFIG_IMPORT_OVERRIDE
In the upper right corner of that screen there should be a link offering to update the installation. After that is done then can talk about other aspects of operation.
-
Re: My CSV file uploads the categories, but not the products
Quote:
Originally Posted by
mc12345678
The latest file may be present but the updates to that version have not been executed. Obvious because of this line:
Import Language Override: EASYPOPULATE_4_CONFIG_IMPORT_OVERRIDE
In the upper right corner of that screen there should be a link offering to update the installation. After that is done then can talk about other aspects of operation.
So mc - updating the EP4 Database did the trick - for the life of me I didn't see that in any of the readme documents, must have missed it - live and learn I guess.
Again - many thanks for your help.
cheers, Mike
-
Re: EasyPopulate 4.0 Support Thread
Hi Everyone,
I have a fresh softaculous install of zencart 1.58 and cannot get easypopulate to install. When I click under Admin/Tools I get a whitescreen and nothing happens.
Please let me know if there is anything that I can do?
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
merlin57
Hi Everyone,
I have a fresh softaculous install of zencart 1.58 and cannot get easypopulate to install. When I click under Admin/Tools I get a whitescreen and nothing happens.
Please let me know if there is anything that I can do?
While auto installers typically introduce their own issues, I am not so sure that the softaculous installation is the cause. That said, I haven't yet tested any version of EP4 with zen Cart 1.5.8. That also said, other information would be helpful such as the php version involved, the origin of the version of EP4 installed and what the logs say related to the failed operation. Caution: before posting the log content, be sure to obscure data to remain private such as the admin folder name and anything else considered not appropriate to let the internet community see.
-
Re: EasyPopulate 4.0 Support Thread
v1.5.5f with latest version Easy Populate 4.0.37.13 - 05-03-2021
I am trying to import a products file, CSV, which imports, i.e. the file shows on the Admin Easy Populate page and then after clicking the import box I get the green success statement / tick at the top of the page (successfully imported) however none of the data imports - see this error message;
HTML Code:
Import Results
Filename: Products+to+add+to+cliponNETAU.csv
ERROR: Import file does not exist:/home/admin/cliponearrings.net.au/admin/temp/Products+to+add+to+cliponNETAU.csv
Finished Processing Import File
Updated records: 0
New Imported records: 0
Errors Detected: 0
Warnings Detected: 0
Memory Usage: 1247320
Memory Peak: 2422568
Execution Time: 0 seconds.
The file does actually exist in cliponearrings.net.au/admin/temp/Products+to+add+to+cliponNETAU.csv
I am getting a bunch of myDebug-admin errors that all seem to be related to the plugin_support.php - below is an example - the variation between then seems to be the 'line' number
Code:
[03-Nov-2022 10:11:16 Australia/Sydney] PHP Notice: CURL error checking plugin versions: in /home/admin/cliponearrings.net.au/includes/functions/plugin_support.php on line 41
[03-Nov-2022 10:11:16 Australia/Sydney] Request URI: /admin/easypopulate_4.php, IP address: 14.201.62.177
#1 trigger_error() called at [/home/admin/cliponearrings.net.au/includes/functions/plugin_support.php:41]
#2 plugin_version_check_for_updates() called at [/home/admin/cliponearrings.net.au/admin/easypopulate_4.php:374]
So needless to say I am stumped
cheers, Mike
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
shags38
v1.5.5f with latest version Easy Populate 4.0.37.13 - 05-03-2021
I am trying to import a products file, CSV, which imports, i.e. the file shows on the Admin Easy Populate page and then after clicking the import box I get the green success statement / tick at the top of the page (successfully imported) however none of the data imports - see this error message;
HTML Code:
Import Results
Filename: Products+to+add+to+cliponNETAU.csv
ERROR: Import file does not exist:/home/admin/cliponearrings.net.au/admin/temp/Products+to+add+to+cliponNETAU.csv
Finished Processing Import File
Updated records: 0
New Imported records: 0
Errors Detected: 0
Warnings Detected: 0
Memory Usage: 1247320
Memory Peak: 2422568
Execution Time: 0 seconds.
The file does actually exist in cliponearrings.net.au/admin/temp/Products+to+add+to+cliponNETAU.csv
I am getting a bunch of myDebug-admin errors that all seem to be related to the plugin_support.php - below is an example - the variation between then seems to be the 'line' number
Code:
[03-Nov-2022 10:11:16 Australia/Sydney] PHP Notice: CURL error checking plugin versions: in /home/admin/cliponearrings.net.au/includes/functions/plugin_support.php on line 41
[03-Nov-2022 10:11:16 Australia/Sydney] Request URI: /admin/easypopulate_4.php, IP address: 14.201.62.177
#1 trigger_error() called at [/home/admin/cliponearrings.net.au/includes/functions/plugin_support.php:41]
#2 plugin_version_check_for_updates() called at [/home/admin/cliponearrings.net.au/admin/easypopulate_4.php:374]
So needless to say I am stumped
cheers, Mike
Change the spaces in the filename to... well non-spaces. E.g, underscore, dash, squashed together, whatever... no extra effort was made to handle filenames with spaces.
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
shags38
v1.5.5f with latest version Easy Populate 4.0.37.13 - 05-03-2021
I am trying to import a products file, CSV, which imports, i.e. the file shows on the Admin Easy Populate page and then after clicking the import box I get the green success statement / tick at the top of the page (successfully imported) however none of the data imports - see this error message;
HTML Code:
Import Results
Filename: Products+to+add+to+cliponNETAU.csv
ERROR: Import file does not exist:/home/admin/cliponearrings.net.au/admin/temp/Products+to+add+to+cliponNETAU.csv
Finished Processing Import File
Updated records: 0
New Imported records: 0
Errors Detected: 0
Warnings Detected: 0
Memory Usage: 1247320
Memory Peak: 2422568
Execution Time: 0 seconds.
The file does actually exist in cliponearrings.net.au/admin/temp/Products+to+add+to+cliponNETAU.csv
I am getting a bunch of myDebug-admin errors that all seem to be related to the plugin_support.php - below is an example - the variation between then seems to be the 'line' number
Code:
[03-Nov-2022 10:11:16 Australia/Sydney] PHP Notice: CURL error checking plugin versions: in /home/admin/cliponearrings.net.au/includes/functions/plugin_support.php on line 41
[03-Nov-2022 10:11:16 Australia/Sydney] Request URI: /admin/easypopulate_4.php, IP address: 14.201.62.177
#1 trigger_error() called at [/home/admin/cliponearrings.net.au/includes/functions/plugin_support.php:41]
#2 plugin_version_check_for_updates() called at [/home/admin/cliponearrings.net.au/admin/easypopulate_4.php:374]
So needless to say I am stumped
cheers, Mike
Sorry for not addressing the other issue. For whatever reason the Zen Cart team changed the server name to support plugin version checks. A part exists in here from recent history about it. Also a future version of this plugin will perform the check only once per user while logged in. Hadn't been incorporated yet.
-
Re: EasyPopulate 4.0 Support Thread
I, too, am getting a blank page with Easy Populate with 1.5.8. The error message I get is as follows:
--> PHP Fatal error: Uncaught Error: Cannot access private property queryFactory::$link in /home/public_html/test/admin/includes/functions/extra_functions/easypopulate_4_functions.php:625
Thanks for any help.
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
JNR345
I, too, am getting a blank page with Easy Populate with 1.5.8. The error message I get is as follows:
--> PHP Fatal error: Uncaught Error: Cannot access private property queryFactory::$link in /home/public_html/test/admin/includes/functions/extra_functions/easypopulate_4_functions.php:625
Thanks for any help.
Yeah basically in the class declaration for asking the database to do something, one of the variables has been made private and no helper function has been provided for the variable declared at the following link.
https://github.com/zencart/zencart/b...actory.php#L22
Could possibly apply the following untested change:
From
Code:
private $link; // mysqli object
To
Code:
public $link; // mysqli object
That again is to modify the catalog file: includes/classes/db/mysql/query_factory.php
Will generate a github issue after further evaluation of the situation. Obviously there are other ways to interface with the Zen Cart code which could include development or copying of the same class file for use with EP4, rewrite of EP4 code, additional code in the Zen Cart core code or perhaps the above change.
-
Re: EasyPopulate 4.0 Support Thread
Thank you! That did the trick. Easy Populate works great now. I really appreciate the quick response.
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
JNR345
Thank you! That did the trick. Easy Populate works great now. I really appreciate the quick response.
The log data helped. Before posting my proposed solution I looked through the history of that change and it almost looks like it was at to private or rather remained private because no core code accessed that class member from outside the class. Glad that it resolved that issue though.
-
1 Attachment(s)
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
mc12345678
Change the spaces in the filename to... well non-spaces. E.g, underscore, dash, squashed together, whatever... no extra effort was made to handle filenames with spaces.
many thanks MC ... with filename change I get the file to upload and import but with error 'no category provided for this new item' - the category name column is complete for all entries - there are 194 products in the file, 36 are products that already exist on the site, 158 are 'new products' - the anomoly here is 'new products' - see the summary below. (new products data copied from another file from another site and added to this file - all columns are complete).
Not sure why it is not adding the new products??
Finished Processing Import File
Updated records: 36
New Imported records: 0
Errors Detected: 158
Warnings Detected: 0
Memory Usage: 1318792
Memory Peak: 1728704
Execution Time: 0 seconds.
Attachment 20142
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
shags38
many thanks MC ... with filename change I get the file to upload and import but with error 'no category provided for this new item' - the category name column is complete for all entries - there are 194 products in the file, 36 are products that already exist on the site, 158 are 'new products' - the anomoly here is 'new products' - see the summary below. (new products data copied from another file from another site and added to this file - all columns are complete).
Not sure why it is not adding the new products??
Finished Processing Import File
Updated records: 36
New Imported records: 0
Errors Detected: 158
Warnings Detected: 0
Memory Usage: 1318792
Memory Peak: 1728704
Execution Time: 0 seconds.
Attachment 20142
I have guesses, but need more info. Just about anything will help, but first thing that comes to mind is the settings in configuration for the module, then there is a list of the headers of your import file, and then an example of one of these existent field's data.
-
Re: EasyPopulate 4.0 Support Thread
Hiya MC12345678!!!
Fresh install of EP4 on clean install of Zen 1.5.8 and php 8.1:
First issue I had was the blank page... made the private to public change noted above in query factory but it did not fix blank page.
Checked error logs and there is some issue with ep4 error logging folder...
So I un-commented line 97 of easypopulate_4.php:
Code:
$ep_debug_logging_all = false; // do not comment out.. make false instead This is now controlled from admin.
and was able to run the EP4 installer.
I created a couple directories and test products with sub-categories manually.
Exported a FULL EP4 file, and turned around and was able to import and all "updated" correctly.
I then manually deleted these products and categories from the admin and re-ran the import and received this:
SKIPPED! - v_products_model: TEST_Model - No category provided for this new product
SKIPPED! - v_products_model: TEST_Model_2 - No category provided for this new product
Haven't looked any deeper yet. I'm going to have to sweep the cobwebs out of my brain and look at the code again. Been quite a few years since you adopted EP4! Glad to see you are still taking good care of it!
Almost 3500 posts! Holy Cow!
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
chadderuski
Almost 3500 posts! Holy Cow!
Yep, it's popular and complicated. The best way to help at this point (moving into 1.5.8) is to post in github witht the following in mind:
Quote:
**Describe the bug**A clear and concise description of what the bug is.
Be sure to explain the business problem that this bug is affecting.
**Version**
Zen Cart version:
PHP version:
MySQL version:
Plugins that may be related:
What older/newer versions were also tested?
**To Reproduce**
Steps to reproduce/demonstrate the behavior:
1. Go to '...'
2. Click on '....'
3. Scroll down to '....'
4. See such-and-such
**Expected behavior**
A clear and concise description of what the bug is preventing from happening correctly.
It's helpful also to explain why what you expected to happen is important. (eg: is this a "software bug" or a "this bugs me" situation?)
**Screenshots**
If applicable, add screenshots to help explain.
**Debug/Error Logs**
Include debug logs containing PHP and/or MySQL error details. These are often found in your /logs/ directory as myDebug-xxxxx.log files.
**Devices (please complete the following information):**
- Operating System: [e.g. Windows, Mac, Android, iOS]
- Browser [e.g. chrome, firefox] and version number
**Additional context**
Add any other context about the problem here.
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
chadderuski
Hiya MC12345678!!!
Fresh install of EP4 on clean install of Zen 1.5.8 and php 8.1:
First issue I had was the blank page... made the private to public change noted above in query factory but it did not fix blank page.
Checked error logs and there is some issue with ep4 error logging folder...
So I un-commented line 97 of easypopulate_4.php:
Code:
$ep_debug_logging_all = false; // do not comment out.. make false instead This is now controlled from admin.
and was able to run the EP4 installer.
I created a couple directories and test products with sub-categories manually.
Exported a FULL EP4 file, and turned around and was able to import and all "updated" correctly.
I then manually deleted these products and categories from the admin and re-ran the import and received this:
SKIPPED! - v_products_model: TEST_Model - No category provided for this new product
SKIPPED! - v_products_model: TEST_Model_2 - No category provided for this new product
Haven't looked any deeper yet. I'm going to have to sweep the cobwebs out of my brain and look at the code again. Been quite a few years since you adopted EP4! Glad to see you are still taking good care of it!
Almost 3500 posts! Holy Cow!
Yeah, bad assembly of a distribution package.
I was going to make all language based fields default to using the language code (en, es, de, etc.) Then realized how much trouble that would cause existing users, so went back in the code to default to language id (1, 2, 3, etc), but the sql install has already been set to default to language code basically.
Essentially, ensure alignment with language import configuration settings with what you have or want to have in your import file. There is also an export setting about how the fields will be titled (code, id, or both). It's been made versatile, but has a known initial installation problem to be fixed on the next update.
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
dbltoe
Yep, it's popular and complicated. The best way to help at this point (moving into 1.5.8) is to post in github witht the following in mind:
The quoted text of the above message is absolutely appropriate to report the associated issue; however, one could claim that the design of this module is why it is an issue and something I expect response to indicate that the module should either be revamped or dismissed. The central issue though is that the Zen Cart 1.5.8 redesign prohibits the use of any mysqli_xxx code that requires the mysql object of the database using the associated database. Based on the writeup by the individual that submitted the PR, reason and consideration as to why any of those features might be considered necessary or concerns of making the member public as compared to offering an access method to the member.
-
1 Attachment(s)
Re: EasyPopulate 4.0 Support Thread
Hello,
I'm running ZC 1.5.7d and php 7.4. Everything about EASYPOPULATE looks like it works correctly, except I cannot seem to successfully import the edited changes to the "v_products_name_1" column, which are the product titles.
The import message shows no errors - everything imports, but the product titles don't reflect the edits made to the CSV.
Has anyone else encountered this problem or can suggest where to start looking to resolve this?
Thanks in advance!
Attachment 20167
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
RoboPhung
Hello,
I'm running ZC 1.5.7d and php 7.4. Everything about EASYPOPULATE looks like it works correctly, except I cannot seem to successfully import the edited changes to the "v_products_name_1" column, which are the product titles.
The import message shows no errors - everything imports, but the product titles don't reflect the edits made to the CSV.
Has anyone else encountered this problem or can suggest where to start looking to resolve this?
Thanks in advance!
Attachment 20167
There are always a number of reasons that something may have gone wrong. Generally it is because of the configuration of something or another. Best to start with is to show the configuration settings for EP4 and identify the name of the file being used to import
-
1 Attachment(s)
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
mc12345678
There are always a number of reasons that something may have gone wrong. Generally it is because of the configuration of something or another. Best to start with is to show the configuration settings for EP4 and identify the name of the file being used to import
Thank you for the quick reply. These are my Easypopulate settings:
Uploads Directory eptemp/ 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 0 Info
Enable Products Music Data 0 Info
User Defined Products Fields Info
Uploads Directory Admin/Catalog true Info
Import/Export Primary Key products_model Info
Import Language Override language_code_only Info
Import/Export CSV Delimiter , Info
Export Language Identifier id Info
Export Price Decimals 2 Info
Export Filename Date Y-m-d Info
Show all EP4 Filetypes with Files true Info
Replace Blank Image false Info
Activate Blank Featured true Info
Remove Blank Specials negative Info
Auto-extend fields false Info
Export URI with Prod and or Cat 0
Attachment 20168
I should have expanded my original post and explain that the other numerical fields in the CSV, such as product weight, and stock quantity, can update via EASYPOPULATE successfully when I modify these values in the CSV. The only field that doesn't update, and does not show any error or warning messages after import is the v_products_name_1 field.
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
RoboPhung
Thank you for the quick reply. These are my Easypopulate settings:
Uploads Directory eptemp/ 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 0 Info
Enable Products Music Data 0 Info
User Defined Products Fields Info
Uploads Directory Admin/Catalog true Info
Import/Export Primary Key products_model Info
Import Language Override language_code_only Info
Import/Export CSV Delimiter , Info
Export Language Identifier id Info
Export Price Decimals 2 Info
Export Filename Date Y-m-d Info
Show all EP4 Filetypes with Files true Info
Replace Blank Image false Info
Activate Blank Featured true Info
Remove Blank Specials negative Info
Auto-extend fields false Info
Export URI with Prod and or Cat 0
Attachment 20168
I should have expanded my original post and explain that the other numerical fields in the CSV, such as product weight, and stock quantity, can update via EASYPOPULATE successfully when I modify these values in the CSV. The only field that doesn't update, and does not show any error or warning messages after import is the v_products_name_1 field.
It normally also helps to also know what other fields are in the import file, but I already can sort the issue based on the five or six ways that it has been described over as many or more page threads.
Change: Import Language Override language_code_only Info
Literally to any other value. Right now it only imports language type fields that are provided using the two letter language code. What is provided in your import file is the language field using the language_id. As recently described to chadderuski (basically the original developer of EP4) there is an alignment to be had between what is to be imported and what is allowed to be imported. I changed the plan on mid distribution development. The default setting for that option should have been: language_id_only.
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
mc12345678
It normally also helps to also know what other fields are in the import file, but I already can sort the issue based on the five or six ways that it has been described over as many or more page threads.
Change: Import Language Override language_code_only Info
Literally to any other value. Right now it only imports language type fields that are provided using the two letter language code. What is provided in your import file is the language field using the language_id. As recently described to chadderuski (basically the original developer of EP4) there is an alignment to be had between what is to be imported and what is allowed to be imported. I changed the plan on mid distribution development. The default setting for that option should have been: language_id_only.
Thank you! This worked. Sorry, I should have poured over the thread more carefully since the solution has already been talked about.
Thanks again for your quick replies and help!
-
Re: EasyPopulate 4.0 Support Thread
ZC 1.5.8
is our beloved plugin ready for this? i can't seem to get it to work under ZC 1.5.8 and php8.1
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
kernheimer
ZC 1.5.8
is our beloved plugin ready for this? i can't seem to get it to work under ZC 1.5.8 and php8.1
There are two known issues with the software grouping. One has been heavily discussed (but not truly publicly corrected because a new version hasn't been issued) the other as a result of how EP4, for previously described reasons, still uses base php/mysqli query calls instead of solely using $db methods.
For the 1.5.8 issue, see the file change(s) of Pull Request 5486, this was described/discussed in this post and that change is expected remain a part of ZC 1.5.8x to first appear in 1.5.8a. For the other (only an issue in upgrading EP4 to the version current as of today), perhaps one way to understand the situation is through this post or this post, though there are (multiple) others over the last year or so that direct the same action with a different explanation.
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
mc12345678
Yeah basically in the class declaration for asking the database to do something, one of the variables has been made private and no helper function has been provided for the variable declared at the following link.
https://github.com/zencart/zencart/b...actory.php#L22
Could possibly apply the following untested change:
From
Code:
private $link; // mysqli object
To
Code:
public $link; // mysqli object
That again is to modify the catalog file: includes/classes/db/mysql/query_factory.php
Will generate a github issue after further evaluation of the situation. Obviously there are other ways to interface with the Zen Cart code which could include development or copying of the same class file for use with EP4, rewrite of EP4 code, additional code in the Zen Cart core code or perhaps the above change.
For those that may have had interest in the "detail" of the above, an issue was opened on the Zen Cart Github site with the above offered as a solution that was incorporated and is expected in Zen Cart 1.5.8a or whatever next Zen Cart release. For further understanding of the issue, may I suggest reading some of the PR "background" related to the proposed change.
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
mc12345678
For those that may have had interest in the "detail" of the above, an
issue was opened on the Zen Cart Github site with the above offered as
a solution that was incorporated and is expected in Zen Cart 1.5.8a or whatever next Zen Cart release. For further understanding of the issue, may I suggest reading some of the
PR "background" related to the proposed change.
Dear mc12345678
I'm just finding it hard to read. my dyslexia comes running to me like a little child ...
i know you all do so much to get / keep it all up to date... but reading in english is not so my best subject :(
Eugénie
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
kernheimer
Dear
mc12345678
I'm just finding it hard to read. my dyslexia comes running to me like a little child ...
i know you all do so much to get / keep it all up to date... but reading in english is not so my best subject :(
Eugénie
Understand. For confirmation are you able to tell the difference between red and green? The code change to the Zen Cart 1.5 8 software needed for operation is at this link: https://github.com/zencart/zencart/pull/5486/files
The first highlighted text is red and has a dash of negative sign on the left side. That is what is the "problem" below that is green text with a plus. That is the code needed.
I can describe differently if still request.
-
1 Attachment(s)
Re: EasyPopulate 4.0 Support Thread
Friends, I'm using version v1.5.5e. (yeah, I know...) but I have like 50 sites and upgrading is going to be a massive undertaking, so I'm still there. Until a few days ago, this mod worked perfectly, has worked perfectly for years. Now I'm getting this error each time I choose "easy populate 4" from my tools menu:
Attachment 20202
Any ideas what may have changed on my hosting server perhaps? This behavior is consistent across ALL of my sites, and has been this way for several days. Everything else is working fine on the site.
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
cindygordon
Friends, I'm using version v1.5.5e. (yeah, I know...) but I have like 50 sites and upgrading is going to be a massive undertaking, so I'm still there. Until a few days ago, this mod worked perfectly, has worked perfectly for years. Now I'm getting this error each time I choose "easy populate 4" from my tools menu:
Attachment 20202
Any ideas what may have changed on my hosting server perhaps? This behavior is consistent across ALL of my sites, and has been this way for several days. Everything else is working fine on the site.
Check, or ask you host to check, modsecurity rules. They have have been updated. A 503 error will happen if modsecurity is blocking the action. There are, of course, many other reasons for a 503, but I have seen this happen.
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
cindygordon
Friends, I'm using version v1.5.5e. (yeah, I know...) but I have like 50 sites and upgrading is going to be a massive undertaking, so I'm still there. Until a few days ago, this mod worked perfectly, has worked perfectly for years. Now I'm getting this error each time I choose "easy populate 4" from my tools menu:
Attachment 20202
Any ideas what may have changed on my hosting server perhaps? This behavior is consistent across ALL of my sites, and has been this way for several days. Everything else is working fine on the site.
Check your logs directory to see what if any debug logs were generated while attempting access. If posting the content here, remember that the admin directory will be present and should be obscured.
Also, if the housing company for all sites is the same, they may be having a particular issue besides s what was previously suggested.
-
Re: EasyPopulate 4.0 Support Thread
Hello my Zen Cart version is 1.5.5e and using EasyPopulate 4.0.37.13 and have used EP for years without issue. For reasons unknown to me I can no longer import new products getting the error SKIPPED! - v_products_model: ??? - No category provided for this new product the categories heading in my csv file is v_categories_name_1 and is in the 27th column of my csv file or AA if using Excel. If I export Complete Products (with Metatags) the columns are identical. I do have categories entered in the column ... they are not blank and named correctly. What am I doing wrong.
Thanks in advance.
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
allmart
Hello my Zen Cart version is 1.5.5e and using EasyPopulate 4.0.37.13 and have used EP for years without issue. For reasons unknown to me I can no longer import new products getting the error SKIPPED! - v_products_model: ??? - No category provided for this new product the categories heading in my csv file is v_categories_name_1 and is in the 27th column of my csv file or AA if using Excel. If I export Complete Products (with Metatags) the columns are identical. I do have categories entered in the column ... they are not blank and named correctly. What am I doing wrong.
Thanks in advance.
Haven't read the post just 7 posts before on the same page of this original post when listed a default way: https://www.zen-cart.com/newreply.ph...eply&p=1392327
-
Re: EasyPopulate 4.0 Support Thread
trying to delete this, sorry
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
jeking
Check, or ask you host to check, modsecurity rules. They have have been updated. A 503 error will happen if modsecurity is blocking the action. There are, of course, many other reasons for a 503, but I have seen this happen.
Thank you, I'll check w/ godaddy.
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
mc12345678
Check your logs directory to see what if any debug logs were generated while attempting access. If posting the content here, remember that the admin directory will be present and should be obscured.
Also, if the housing company for all sites is the same, they may be having a particular issue besides s what was previously suggested.
I am not exactly sure how to check logs. I will call the hosting company tho, yes, it's the same host for all of the sites. Thank you!
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
allmart
Hello my Zen Cart version is 1.5.5e and using EasyPopulate 4.0.37.13 and have used EP for years without issue. For reasons unknown to me I can no longer import new products getting the error SKIPPED! - v_products_model: ??? - No category provided for this new product the categories heading in my csv file is v_categories_name_1 and is in the 27th column of my csv file or AA if using Excel. If I export Complete Products (with Metatags) the columns are identical. I do have categories entered in the column ... they are not blank and named correctly. What am I doing wrong.
Thanks in advance.
Quote:
Originally Posted by
mc12345678
Quote:
Originally Posted by
cindygordon
I am not exactly sure how to check logs. I will call the hosting company tho, yes, it's the same host for all of the sites. Thank you!
I have no idea why the link I pasted had been captured instead of this one: https://www.zen-cart.com/showthread....28#post1392328
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
cindygordon
Thank you, I'll check w/ godaddy.
They are going to give you a bunch of gibberish BUT, ask them about the MySQL connection that is being used for your sites.
Not only did they drop PHP 5.4 and 5.6 (later to reinstated after customers complained) , they also changed the database connections from MySQL to MySQLi. All without telling the customer.:censored:
It is a better connection BUT, for some reason, you get a 503 error with any PHP below 7
-
Re: EasyPopulate 4.0 Support Thread
My query_factory.php file has no such code as posted in the fix
private $link; // mysqli object
see below
/**
* Queryfactory - A simple database abstraction layer
*
*/
class queryFactory extends base {
var $link, $count_queries, $total_query_time, $dieOnErrors;
var $error_number = 0;
var $error_text = '';
function __construct() {
$this->count_queries = 0;
$this->total_query_time = 0;
}
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
allmart
My query_factory.php file has no such code as posted in the fix
private $link; // mysqli object
see below
/**
* Queryfactory - A simple database abstraction layer
*
*/
class queryFactory extends base {
var $link, $count_queries, $total_query_time, $dieOnErrors;
var $error_number = 0;
var $error_text = '';
function __construct() {
$this->count_queries = 0;
$this->total_query_time = 0;
}
The issue, based on your description is with the second problem identified in the previous discussion. It comes down to alignment of import language identifiers as compared to what the file contains. Your file has the language id (1), but the default install/upgrade for import incorrectly sets to language_code_only. This means that if a file had for example: categories_name_1 and categories_name_en columns, then only the data in categories_name_en would be imported. Not having that column in a default install causes no category names being found.
So, change the setting to literally anything else (recommendation is language_id_only) and that problem will be resolved. The issue quoted above about that file is in reference to the original distribution of Zen Cart 1.5.8.
-
Re: EasyPopulate 4.0 Support Thread
Thank you for this fix! :)
-
Re: EasyPopulate 4.0 Support Thread
hello all - I am creating a Google Merchant Center data file for ads/free listings that requires amongst other things full Image URL - I've searched the thread and checked the Github - I can see that to do this will require a code change/addition so;
a) wondering if anyone has done this successfully and if so are you willing to share the changes made?
or b) can someone give me a hint as to how to do this please, what file etc.
many thanks, Mike
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
mc12345678
The issue, based on your description is with the second problem identified in the previous discussion. It comes down to alignment of import language identifiers as compared to what the file contains. Your file has the language id (1), but the default install/upgrade for import incorrectly sets to language_code_only. This means that if a file had for example: categories_name_1 and categories_name_en columns, then only the data in categories_name_en would be imported. Not having that column in a default install causes no category names being found.
So, change the setting to literally anything else (recommendation is language_id_only) and that problem will be resolved. The issue quoted above about that file is in reference to the original distribution of Zen Cart 1.5.8.
Sorry for the late response, your fixed worked ... many thanks!!!
-
Re: EasyPopulate 4.0 Support Thread
HTTP error 500 when going to admin page/tools/Easy Populate 4.
I hope this is the correct place to post...been out of the game for 7-9 years and slowly working my way back in again....I uploaded all the files as stated in the install file and now I get a HTTP error 500 and easy populate does not show up under the configuration tab.
Running zencart 1.5.8
MySQL 5.7.23-23
Linux 4.19.150
PHP 7.4.33
Please help....
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
jtlswan
HTTP error 500 when going to admin page/tools/Easy Populate 4.
I hope this is the correct place to post...been out of the game for 7-9 years and slowly working my way back in again....I uploaded all the files as stated in the install file and now I get a HTTP error 500 and easy populate does not show up under the configuration tab.
Running zencart 1.5.8
MySQL 5.7.23-23
Linux 4.19.150
PHP 7.4.33
Please help....
Please take a moment to read the very recent previous posts. Should not have to read many more than 10.
-
Re: EasyPopulate 4.0 Support Thread
I'll look more closely again...most of the posts i looked at had to do with people being able to access EP, but then having errors...i can't even access EP after clicking on it under tools...Letcha know what I find. Thank you for the push in the right direction MC
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
jtlswan
I'll look more closely again...most of the posts i looked at had to do with people being able to access EP, but then having errors...i can't even access EP after clicking on it under tools...Letcha know what I find. Thank you for the push in the right direction MC
My how time flies. It is a few more than 10 posts back, but not by many as the same issue(s) seem to appear at least once per page of postings. The most summarized post of known issues which includes yours is: https://www.zen-cart.com/showthread....28#post1392328
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
mc12345678
I don’t know how you deal with idiots like me and keep your composure/patience. It worked. Thank you very very much! All in a days work for Superman MC
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
jtlswan
I don’t know how you deal with idiots like me and keep your composure/patience. It worked. Thank you very very much! All in a days work for Superman MC
I appreciate the credit, though have not 100% remained so composed. I'm human and have my moments. Thank you though.
For you and others, I have a change in the works, but am trying to test it thoroughly so as not to cause a further show of issues to address. These two are enough. :)
-
Re: EasyPopulate 4.0 Support Thread
Good news MC...it still working...thank you Sir...now, bad news...I'm sure I'm being a dumbass again and getting an upload error: SKIPPED! - v_products_model: gwpuldvd1361 - No category provided for this new product...
Obviously I have a category (categories) in the csv file:
v_products_model v_products_image v_products_name_1 v_categories_name_1
gwdvd103428 gwdvd103428.jpg DVD - Back to the Future Miscellaneous^Discontinued Items
ideas?
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
jtlswan
Good news MC...it still working...thank you Sir...now, bad news...I'm sure I'm being a dumbass again and getting an upload error: SKIPPED! - v_products_model: gwpuldvd1361 - No category provided for this new product...
Obviously I have a category (categories) in the csv file:
v_products_model v_products_image v_products_name_1 v_categories_name_1
gwdvd103428 gwdvd103428.jpg DVD - Back to the Future Miscellaneous^Discontinued Items
ideas?
Well as this is the last post of this page, for those listing 10 posts per page, groundhog day begins on the next post. The issue described above is the "second" issue with the current version of EP4. Please follow the guidance from the above link about ensuring the import of language dependent fields matches the filename fields. It is discussed in the thread previously shared where the statement was that there are two known issues. It looks like you've resolved the 1.5.8 issue, now the other one.
-
Re: EasyPopulate 4.0 Support Thread
Getting this errors after installation , kindly help
"PHP Fatal error: Uncaught Error: Cannot access private property queryFactory::$link
includes/functions/extra_functions/easypopulate_4_functions.php(447): ep_4_query('SHOW COLUMNS FR...')
the error shows in line 447 and 609 on the file easypopulate_4_functions.php
