EasyPopulate 4.0 Support Thread

[mc12345678]

So there are a couple of options...

Export could be by use of ZC currency style "conversion" as one.
Another is through instruction related to this libreoffice help article: https://help.libreoffice.org/Calc/Ce...urrency_Format
Though the cells may initially be in text or general format and need to be changed to a currency format.
Or by way of "equation" to build/rebuild the values through some sort of operation(s) like find and replace on the column.

Presumably though this is something you'd like to automate rather than have to manipulate on each such transfer. To accomplish that and not to disrupt the normal export process, a new field would be needed in the export file. That is accomplished by "adding" a field to the filelayout for the export type that is to have that field.

Then at some point after the price has been collected from the database, the field for the associated record would need to be "built" to contain your desired text. I don't know if you would be trying to export in every currency supported by the store or just the default currency, but for each such field, would need a filelayout field.

The currency could/would be exported using the $currencies variable/class which is declared in the easypopulate_4.php file. The currency class offers output "modules" to support providing the string version of the currency. Some manipulation may be necessary to append the three letter representation of the currency, but it is all something doable for any of the exports that offer the price of the product.

[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

[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')

[mc12345678]

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/EasyPo...6862661d58438b

[mc12345678]

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?

[jkenwell]

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.

[jkenwell]

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.

[mc12345678]

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.

[jkenwell]

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?