Page 287 of 362 FirstFirst ... 187237277285286287288289297337 ... LastLast
Results 2,861 to 2,870 of 3612
  1. #2861
    Join Date
    Jul 2012
    Posts
    16,746
    Plugin Contributions
    17

    Default Re: EasyPopulate 4.0 Support Thread

    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.
    ZC Installation/Maintenance Support <- Site
    Contribution for contributions welcome...

  2. #2862
    Join Date
    Aug 2014
    Location
    Lisbon
    Posts
    594
    Plugin Contributions
    0

    Default Re: EasyPopulate 4.0 Support Thread

    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
    “Though the problems of the world are increasingly complex, the solutions remain embarrassingly simple.” ― Bill Mollison

  3. #2863
    Join Date
    Dec 2016
    Location
    Edmonton
    Posts
    25
    Plugin Contributions
    0

    Default Re: 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')
    Last edited by jkenwell; 30 Jan 2018 at 06:29 PM.

  4. #2864
    Join Date
    Jul 2012
    Posts
    16,746
    Plugin Contributions
    17

    Default Re: EasyPopulate 4.0 Support Thread

    Quote Originally Posted by mesnitu View Post
    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
    ZC Installation/Maintenance Support <- Site
    Contribution for contributions welcome...

  5. #2865
    Join Date
    Jul 2012
    Posts
    16,746
    Plugin Contributions
    17

    Default Re: EasyPopulate 4.0 Support Thread

    Quote Originally Posted by jkenwell View Post
    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.
    ZC Installation/Maintenance Support <- Site
    Contribution for contributions welcome...

  6. #2866
    Join Date
    Dec 2016
    Location
    Edmonton
    Posts
    25
    Plugin Contributions
    0

    Default Re: EasyPopulate 4.0 Support Thread

    Quote Originally Posted by jkenwell View Post
    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?

  7. #2867
    Join Date
    Dec 2016
    Location
    Edmonton
    Posts
    25
    Plugin Contributions
    0

    Default Re: EasyPopulate 4.0 Support Thread

    Quote Originally Posted by mc12345678 View Post
    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.

  8. #2868
    Join Date
    Dec 2016
    Location
    Edmonton
    Posts
    25
    Plugin Contributions
    0

    Default Re: EasyPopulate 4.0 Support Thread

    Quote Originally Posted by mc12345678 View Post
    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.

  9. #2869
    Join Date
    Jul 2012
    Posts
    16,746
    Plugin Contributions
    17

    Default Re: EasyPopulate 4.0 Support Thread

    Quote Originally Posted by jkenwell View Post
    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.
    ZC Installation/Maintenance Support <- Site
    Contribution for contributions welcome...

  10. #2870
    Join Date
    Dec 2016
    Location
    Edmonton
    Posts
    25
    Plugin Contributions
    0

    Default Re: EasyPopulate 4.0 Support Thread

    Quote Originally Posted by mc12345678 View Post
    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?

 

 

Similar Threads

  1. Hebrew Support - latest release [Support Thread]
    By eranariel in forum Addon Language Packs
    Replies: 19
    Last Post: 23 Jan 2023, 08:04 AM
  2. BackUp ZC [Support Thread]
    By skipwater in forum All Other Contributions/Addons
    Replies: 285
    Last Post: 23 Dec 2020, 10:40 AM
  3. Wordpress On ZC [Support Thread]
    By hira in forum All Other Contributions/Addons
    Replies: 1858
    Last Post: 17 Jan 2014, 01:24 AM
  4. ZJ Black 2 support thread
    By Liamv in forum Addon Templates
    Replies: 1
    Last Post: 15 Feb 2010, 02:53 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR