EasyPopulate 4.0 Support Thread

After flawlessly using EasyPopulate 4 for almost a year, today there suddenly is an error, despite no (obvious) changes having been made to the import file. I am not a coder, and I am not familiar with what this means. This below error suddenly impacts all non-taxable items in my import file. Could anyone offer help how I can fix this? Thank you.

File Import Completed with issues.
An SQL error has occured. Please check your input data for tabs within fields and delete these. If this error continues, please forward your error log to the Easy Populate maintainer

MySQLi error 1366: Incorrect integer value: '' for column 'products_tax_class_id' at row 1
When executing:
UPDATE zenvv_products SET
products_price = '6.65',alt_number = '',product_group = 'ACE Bake Your Own 210-460 g',brand = 'Ace',shop_easy = '',shop_easy_special = '',no_frills = 'N/A',no_frills_special = '',superstore = '5.29',superstore_special = '',wholesale_club = 'N/A',wholesale_club_special = '',walmart = 'N/A',walmart_special = '',loblaws = '4.99',loblaws_special = '',sobeys = 'N/A',sobeys_special = '',save_on_foods = 'N/A',save_on_foods_special = '',base = '5.29',products_base_cost = '4.99',vendor = '',products_image = '20660168.jpg',
products_weight = '0',
products_discount_type = '0',
products_discount_type_from = '0',
product_is_call = '0',
products_sort_order = '-1',
products_quantity_order_min = '1',
products_quantity_order_units = '1',
products_priced_by_attribute = '0',
product_is_always_free_shipping = '0',
products_tax_class_id = '',
products_date_available = NULL,
products_date_added = '2016-01-27 06:44:39',
products_last_modified = CURRENT_TIMESTAMP,
products_quantity = '-1',
manufacturers_id = '3963',
products_status = '1',
metatags_title_status = '0',
metatags_products_name_status = '0',
metatags_model_status = '0',
metatags_price_status = '0',
metatags_title_tagline_status = '0' WHERE (products_id = '31429')

mesnitu:

Thanks
After all with a "search and replace" dot by comma does the trick, and then I can format the numbers.

Another question, I now realize that if a products is "linked" ( two categories) , it exports in two different lines. Is there a "simple" way not to do it?

Thanks

The modification is simple, unfortunately it was buried in a commit with several other changes, this is something to be implemented in the next version (still doing some testing and want to be sure addressed the same concept(s) in all places not just here or there.

https://github.com/mc12345678/EasyPopulate-4.0/commit/7b1410f2d0d30c5c593bd26b316862661d58438b

jkenwell:

After flawlessly using EasyPopulate 4 for almost a year, today there suddenly is an error, despite no (obvious) changes having been made to the import file. I am not a coder, and I am not familiar with what this means. This below error suddenly impacts all non-taxable items in my import file. Could anyone offer help how I can fix this? Thank you.

File Import Completed with issues.
An SQL error has occured. Please check your input data for tabs within fields and delete these. If this error continues, please forward your error log to the Easy Populate maintainer

MySQLi error 1366: Incorrect integer value: '' for column 'products_tax_class_id' at row 1
When executing:
UPDATE zenvv_products SET
products_price = '6.65',alt_number = '',product_group = 'ACE Bake Your Own 210-460 g',brand = 'Ace',shop_easy = '',shop_easy_special = '',no_frills = 'N/A',no_frills_special = '',superstore = '5.29',superstore_special = '',wholesale_club = 'N/A',wholesale_club_special = '',walmart = 'N/A',walmart_special = '',loblaws = '4.99',loblaws_special = '',sobeys = 'N/A',sobeys_special = '',save_on_foods = 'N/A',save_on_foods_special = '',base = '5.29',products_base_cost = '4.99',vendor = '',products_image = '20660168.jpg',
products_weight = '0',
products_discount_type = '0',
products_discount_type_from = '0',
product_is_call = '0',
products_sort_order = '-1',
products_quantity_order_min = '1',
products_quantity_order_units = '1',
products_priced_by_attribute = '0',
product_is_always_free_shipping = '0',
products_tax_class_id = '',
products_date_available = NULL,
products_date_added = '2016-01-27 06:44:39',
products_last_modified = CURRENT_TIMESTAMP,
products_quantity = '-1',
manufacturers_id = '3963',
products_status = '1',
metatags_title_status = '0',
metatags_products_name_status = '0',
metatags_model_status = '0',
metatags_price_status = '0',
metatags_title_tagline_status = '0' WHERE (products_id = '31429')

What is the version number/date of the download and/or source of the install? Basically there is expected to be a "converter" that would ensure that the value to be entered is an integer as a '0' and not as a string where false or null become a blank space. This occurs in the latest version for download from the ZC website.

jkenwell:

After flawlessly using EasyPopulate 4 for almost a year, today there suddenly is an error, despite no (obvious) changes having been made to the import file. I am not a coder, and I am not familiar with what this means. This below error suddenly impacts all non-taxable items in my import file. Could anyone offer help how I can fix this? Thank you.

File Import Completed with issues.
An SQL error has occured. Please check your input data for tabs within fields and delete these. If this error continues, please forward your error log to the Easy Populate maintainer

MySQLi error 1366: Incorrect integer value: '' for column 'products_tax_class_id' at row 1
When executing:
UPDATE zenvv_products SET
products_price = '6.65',alt_number = '',product_group = 'ACE Bake Your Own 210-460 g',brand = 'Ace',shop_easy = '',shop_easy_special = '',no_frills = 'N/A',no_frills_special = '',superstore = '5.29',superstore_special = '',wholesale_club = 'N/A',wholesale_club_special = '',walmart = 'N/A',walmart_special = '',loblaws = '4.99',loblaws_special = '',sobeys = 'N/A',sobeys_special = '',save_on_foods = 'N/A',save_on_foods_special = '',base = '5.29',products_base_cost = '4.99',vendor = '',products_image = '20660168.jpg',
products_weight = '0',
products_discount_type = '0',
products_discount_type_from = '0',
product_is_call = '0',
products_sort_order = '-1',
products_quantity_order_min = '1',
products_quantity_order_units = '1',
products_priced_by_attribute = '0',
product_is_always_free_shipping = '0',
products_tax_class_id = '',
products_date_available = NULL,
products_date_added = '2016-01-27 06:44:39',
products_last_modified = CURRENT_TIMESTAMP,
products_quantity = '-1',
manufacturers_id = '3963',
products_status = '1',
metatags_title_status = '0',
metatags_products_name_status = '0',
metatags_model_status = '0',
metatags_price_status = '0',
metatags_title_tagline_status = '0' WHERE (products_id = '31429')

Ok, in the meantime I have exported a category, which worked fine, and tried to import the same category to see if it would accept the data as exported, and it did not. The same error occurred and I am unable to import non-taxable products. Solutions?

mc12345678:

What is the version number/date of the download and/or source of the install? Basically there is expected to be a "converter" that would ensure that the value to be entered is an integer as a '0' and not as a string where false or null become a blank space. This occurs in the latest version for download from the ZC website.

I have been using Easy Populate 4.0.30 - Beta 06-27-2015 since about March last year, which I got off this site, and it's been fine until today.

mc12345678:

What is the version number/date of the download and/or source of the install? Basically there is expected to be a "converter" that would ensure that the value to be entered is an integer as a '0' and not as a string where false or null become a blank space. This occurs in the latest version for download from the ZC website.

Am I understanding correctly that 4.0.36.ZC would not fix this? Which version would fix this issue then? (It's just that I am puzzled why this would happen all of a sudden, without any changes to the installed Zen Cart version or Easy Populate. Even yesterday I still imported just fine.

jkenwell:

Am I understanding correctly that 4.0.36.ZC would not fix this? Which version would fix this issue then? (It's just that I am puzzled why this would happen all of a sudden, without any changes to the installed Zen Cart version or Easy Populate. Even yesterday I still imported just fine.
Incorrectly understood. 4.0.36.ZC does not have this issue. I'll have to go look at what 4.0.30 was doing, but changes have been made to ensure that the proper datatype would be applied. Things that may have changed and possibly brought this to light in that version would be php version on the site has changed, the mysql database version may have changed, or possibly some configuration on the server. The code though has continued to be updated to prevent such issues and to maintain compatibility with its existing breadth of ZC versions.

mc12345678:

Incorrectly understood. 4.0.36.ZC does not have this issue. I'll have to go look at what 4.0.30 was doing, but changes have been made to ensure that the proper datatype would be applied. Things that may have changed and possibly brought this to light in that version would be php version on the site has changed, the mysql database version may have changed, or possibly some configuration on the server. The code though has continued to be updated to prevent such issues and to maintain compatibility with its existing breadth of ZC versions.

Do you recommend I update to 4.0.36.ZC at this point and see if that solves the issue?

Yeah, "back then", the code simply assigned a "quoted" version of whatever the result for $v_tax_class_id was. In this case, a value of zero, false, or null would result in a pair of empty single quotes. Also "back then", databases would convert this to either an empty value if the field supported it or as should have been the case to convert it to the number type associated to the field. The products_tax_class_id is an integer, so again "back then" it would change that "empty" to a zero and store the zero. Now though (because of whatever background change that occurred at some point) the system reports an error rather than do the conversion.

So, if were #@!! bent on continuing to use that version, search for:

products_tax_class_id			= '".$v_tax_class_id."',

And replace with:

products_tax_class_id			= '".[b](int)[/b]$v_tax_class_id."',

In two places.

But... there are a lot of other fields that were populated that way and would cause a problem too and need either similar updates or better yet, upgrade of the software which doesn't suffer that issue.

jkenwell:

Do you recommend I update to 4.0.36.ZC at this point and see if that solves the issue?
Yup. I sure do. Use of the most up-to-date software compatible with one's operating system is always advised. (sometimes even changing operating systems to ensure the most up-to-date.)

Should be as simple as uploading the files then clicking the update link in the upper right hand corner of the tools->EasyPopulate v4 screen.

mc12345678:

Incorrectly understood. 4.0.36.ZC does not have this issue. I'll have to go look at what 4.0.30 was doing, but changes have been made to ensure that the proper datatype would be applied. Things that may have changed and possibly brought this to light in that version would be php version on the site has changed, the mysql database version may have changed, or possibly some configuration on the server. The code though has continued to be updated to prevent such issues and to maintain compatibility with its existing breadth of ZC versions.

I have installed the latest version and it appears that the error has disappeared. Perhaps a change was made on server side that created the error. Thank you very much for your contributions and your help with this issue.

jkenwell:

I have installed the latest version and it appears that the error has disappeared. Perhaps a change was made on server side that created the error. Thank you very much for your contributions and your help with this issue.
Glad that solved the problem for you.

mc12345678:

Glad that solved the problem for you.

I'm very sorry, now a new problem has arisen that was not a problem before. This is with a custom Numinix field. Can you think of a way to solve this?

MySQLi error 1366: Incorrect string value: '\x96 1.99' for column 'loblaws_special' at row 1
When executing:
UPDATE zenvv_products SET
loblaws_special = '31/01/2018 – 1.99'

jkenwell:

I'm very sorry, now a new problem has arisen that was not a problem before. This is with a custom Numinix field. Can you think of a way to solve this?

MySQLi error 1366: Incorrect string value: '\x96 1.99' for column 'loblaws_special' at row 1
When executing:
UPDATE zenvv_products SET
loblaws_special = '31/01/2018 – 1.99'
Does this occur on export followed by immediate import of the same file, or only after saving the file from the spreadsheet editor?

The cause of this appears to be that the file was stored using latin1, while your store is using or capable of using utf8.

mc12345678:

Does this occur on export followed by immediate import of the same file, or only after saving the file from the spreadsheet editor?

The cause of this appears to be that the file was stored using latin1, while your store is using or capable of using utf8.

No issue with export/import file. I am trying to find out how I can change the Openoffice csv file to utf8, but so far I don't see anything.

jkenwell:

No issue with export/import file. I am trying to find out how I can change the Openoffice csv file to utf8, but so far I don't see anything.

Save as, check the box at the bottom left to edit filter settings, progress forward and then should be shown the current encoding as well as an option to change how it is to be saved.

mc12345678:

Save as, check the box at the bottom left to edit filter settings, progress forward and then should be shown the current encoding as well as an option to change how it is to be saved.

It appears all issues are now resolved. I wouldn't likely have been able to do it without your guidance. Thank you again. Also, if you are the developer of EasyPopulate 4.0 is there a way to "donate"? These mods certainly save a lot of time.

jkenwell:

It appears all issues are now resolved. I wouldn't likely have been able to do it without your guidance. Thank you again. Also, if you are the developer of EasyPopulate 4.0 is there a way to "donate"? These mods certainly save a lot of time.
I am not the original developer of EasyPopulate 4.0, but picked up the reigns from chadderuski at a time when he was no longer able to support at the level he used to and to incorporate changes that would allow this plugin to continue to function. He developed EP4 based off of older code and concepts where such concepts remain relatively central to any variation. I have made/published my share of mistakes (and continue to occasionally do so) but have been taking the input and requests of users to try to further build out the plugin.

I do not know how many other ways it is used or has been modified, but do know that another user has been able to incorporate functionality to support the bookx product type which comes with its own operational requirements. There are also other variations of this module either with a similar name or some other, but they all tend to have a common goal of updating many records of the database in a single operation.

That said, developers and those offering their support tend to have information either in their signature or profile through which one may find a way to offer back something in return for their work and effort. (ie. To buy a cup of coffee.) As an open source forum and program I would like to think that offering support back to Zen Cart and it's primary developers would be considered acceptable as well. I can not speak for everyone on that. I would think though that showing support in any way would be appreciated, whether it is through finance, assistance, or any other legal action/exchange.

Is it possible to recognize bold strings? Without using <b> or <strong> ?
I do remember that many years ago, that I did upload CSV file and it recognize those "tags"... But I don't recall if it was me who put them, or the code accept then.

Thanks

mesnitu:

Is it possible to recognize bold strings? Without using <b> or <strong> ?
I do remember that many years ago, that I did upload CSV file and it recognize those "tags"... But I don't recall if it was me who put them, or the code accept then.

Thanks
Recognize them in what way? What is to be done if "recognized"? If there is a "character" or character sequence that initiates bolding and one that ends it, there is a sort of conversion function that could substitute the html bold character sequence as applicable. Though most csv generating processes remove character formatting so that it is only text. If though there is a utf8 character code for a bolded character then that would be most likely to what you are/were referring. I could be wrong, though the above question also is a little loosey goosey as well. :)