Page 58 of 59 FirstFirst ... 84856575859 LastLast
Results 571 to 580 of 581
  1. #571
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    13,393
    Plugin Contributions
    94

    Default Re: Simple Instructions for Import

    Quote Originally Posted by chadlly2003 View Post
    I found a bug.

    when importing products if your text has a characteristics it does not like it still will import. But when you go to export file it looks or distorted within the excel sheet.


    The issue is 'product_desc' table

    If you open in excel and trim / clean formula in the description it will solve the issue and everything import/export fine.

    This can really mess things up if people forgot to clean there html during the import process.
    Without further information, it sounds like a "Garbage in, garbage out" scenario.

    That "characteristics" are you referring to and what is "it" that doesn't like them?

    Are you using Microsoft Excel? If so, what is your setting for Configuration / Database I/O Manager Settings / CSV: Encoding? Note that for Microsoft Excel, that should be set to 'latin1'.

  2. #572
    Join Date
    Jan 2015
    Posts
    501
    Plugin Contributions
    0

    Default Re: Simple Instructions for Import

    Quote Originally Posted by lat9 View Post
    Without further information, it sounds like a "Garbage in, garbage out" scenario.

    That "characteristics" are you referring to and what is "it" that doesn't like them?

    Are you using Microsoft Excel? If so, what is your setting for Configuration / Database I/O Manager Settings / CSV: Encoding? Note that for Microsoft Excel, that should be set to 'latin1'.

    I had it set to utf8

    change it to

    latin1

    thank you

  3. #573
    Join Date
    Aug 2020
    Location
    Richarson
    Posts
    141
    Plugin Contributions
    0

    Default Re: Simple Instructions for Import

    Quote Originally Posted by lat9 View Post
    Yep, as noted in our discussion above, the current implementation of the handler for the importing of options' values is quite messed up.

    I should have an update (essentially a total rewrite) available within a couple of days.
    Just an update in effort to have DBIo working for me.. I checked the table products_options_values_to_products_options on another site then extracted the data (the products are the same) I then went to the website where I have DBIo installed for testing purposes and imported the table (this table was empty even after I initially uploaded Option values via DBIo). After the table import via phpMyadmin the fields are displaying within admin. Is there another file within DBIo I am suppose to upload for the products_options_values_to_products_options table to be populated?

  4. #574
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    13,393
    Plugin Contributions
    94

    Default Re: Simple Instructions for Import

    Quote Originally Posted by chuckrey View Post
    Just an update in effort to have DBIo working for me.. I checked the table products_options_values_to_products_options on another site then extracted the data (the products are the same) I then went to the website where I have DBIo installed for testing purposes and imported the table (this table was empty even after I initially uploaded Option values via DBIo). After the table import via phpMyadmin the fields are displaying within admin. Is there another file within DBIo I am suppose to upload for the products_options_values_to_products_options table to be populated?
    Nope, it'll happen 'organically' in the correct DbIoProductsOptionsValuesHandler.

  5. #575
    Join Date
    Aug 2020
    Location
    Richarson
    Posts
    141
    Plugin Contributions
    0

    Default Re: Simple Instructions for Import

    Quote Originally Posted by lat9 View Post
    Nope, it'll happen 'organically' in the correct DbIoProductsOptionsValuesHandler.
    Started fresh once again and downloaded the DBIo plugin w/ the recent changes made in GitHub and so far so good. My final update will be prices to attributes.
    Just wanted to provide an update in case anyone else is having a similar issue. The latest GitHub files seemed to help resolve my issue. Thanks!

  6. #576
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    13,393
    Plugin Contributions
    94

    Default Re: Simple Instructions for Import

    Quote Originally Posted by chuckrey View Post
    Started fresh once again and downloaded the DBIo plugin w/ the recent changes made in GitHub and so far so good. My final update will be prices to attributes.
    Just wanted to provide an update in case anyone else is having a similar issue. The latest GitHub files seemed to help resolve my issue. Thanks!
    Thanks for the update! I'll get that updated version packaged up and released.

  7. #577
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    13,393
    Plugin Contributions
    94

    Default Re: Simple Instructions for Import

    v2.0.2 of the Database I/O Manager (DbIo) is now available for download: https://www.zen-cart.com/downloads.php?do=file&id=2091

    This release contains changes associated with these GitHub issues:

    #221: E_USER_ERROR is deprecated in PHP 8.4.
    #222: Can't remove a DbIo template, once created.
    #223: Remove zc1.3.x-era boxes file and subdirectory.
    #224: Initialize inserted categories' sort-order to 0 (was null).
    #225: Correct DbIoOptionsValuesHandler, was creating uneditable option-values.
    #226: Pre-define all class properties in the DbIoHandler class.
    #238: Remove unwanted centered-text styling from the customization tool.
    #239: Add links to the GitHub wiki in the main admin tools' instructions.

  8. #578
    Join Date
    Dec 2005
    Location
    Perth, Western Australia, Australia
    Posts
    780
    Plugin Contributions
    0

    Default Re: Database I/O Manager (DbIo) Plugin [Support Thread]

    Hi,


    In EP4, I could do the following but I seem to have trouble with this module. Perhaps I am missing something.
    1. How to import products using unique products_id without products_model (blank)? In other words, can products_id be set as the primary key used for import of the data?
    2. How to import products with same products_models? Setting "Allow Duplicate Models" to Yes didn't work.
    3. How to auto-create categories if they don't pre-exist? Setting "Auto-Create Categories on Import" to Yes didn't work.
    The error was "Product not inserted; category id (x) has categories."

    Thanks
    The Team Behind DealByEthan.com | Curating unique finds for a discerning community. Committed to a seamless and inspiring shopping experience. Connect with us: https://linktr.ee/dealbyethan


  9. #579
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    13,393
    Plugin Contributions
    94

    Default Re: Database I/O Manager (DbIo) Plugin [Support Thread]

    Quote Originally Posted by dealbyethan.com View Post
    Hi,


    In EP4, I could do the following but I seem to have trouble with this module. Perhaps I am missing something.
    1. How to import products using unique products_id without products_model (blank)? In other words, can products_id be set as the primary key used for import of the data?
    2. How to import products with same products_models? Setting "Allow Duplicate Models" to Yes didn't work.
    3. How to auto-create categories if they don't pre-exist? Setting "Auto-Create Categories on Import" to Yes didn't work.
    The error was "Product not inserted; category id (x) has categories."

    Thanks
    1 and 2. Just export the products (so you've got both the v_products_id and v_products_model). The combination of those two values provides a unique 'key' for the import.

    2 (maybe). To force a product record to be inserted, use the ADD v_dbio_command.

    3. The message you received says it all: The category name you specified has categories, so products cannot be added.

  10. #580
    Join Date
    Dec 2005
    Location
    Perth, Western Australia, Australia
    Posts
    780
    Plugin Contributions
    0

    Default Re: Database I/O Manager (DbIo) Plugin [Support Thread]

    Quote Originally Posted by lat9 View Post
    1 and 2. Just export the products (so you've got both the v_products_id and v_products_model). The combination of those two values provides a unique 'key' for the import.

    2 (maybe). To force a product record to be inserted, use the ADD v_dbio_command.

    3. The message you received says it all: The category name you specified has categories, so products cannot be added.

    Hi, thanks for your responses.

    More tests were done but there are still some issues.
    This module prioritises products_model as the primary key during import and ignore products_id by creating a new one. Is it possible to have an option in the configuration for choosing the import/export primary key: products_id or products_model, like in EP4? The main reason is that products_id always has an automatic unique number no matter what; whereas products_model has to be manually made unique but some suppliers use the same model numbers for products with different colors.

    Although command ADD may work for adding products with the same products_model, it adds the linked product as a new product instead. Turning it on and off in configuration can be confusing and inconvenient.

    Is there a way to bulk create categories before importing products?
    The Team Behind DealByEthan.com | Curating unique finds for a discerning community. Committed to a seamless and inspiring shopping experience. Connect with us: https://linktr.ee/dealbyethan


 

 
Page 58 of 59 FirstFirst ... 84856575859 LastLast

Similar Threads

  1. Support Thread for CKEditor Plugin
    By DivaVocals in forum Addon Admin Tools
    Replies: 213
    Last Post: 18 Nov 2024, 04:17 AM
  2. Back to Top Plugin [Support Thread]
    By picaflor-azul in forum All Other Contributions/Addons
    Replies: 31
    Last Post: 6 Feb 2016, 10:52 PM
  3. v151 Plug 'n' Pay plugin [Support Thread]
    By KetchRescue in forum Addon Payment Modules
    Replies: 5
    Last Post: 28 Nov 2015, 04:56 AM
  4. Justuno Plugin [Support Thread]
    By JustunoApp in forum All Other Contributions/Addons
    Replies: 8
    Last Post: 24 May 2015, 11:00 PM
  5. VendingBox Plugin Support Thread
    By vb_support in forum All Other Contributions/Addons
    Replies: 31
    Last Post: 10 Feb 2013, 07:24 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