Re: Database I/O Manager (DbIo) Plugin [Support Thread]
Quote:
Originally Posted by
mc12345678
Huh? Not sure which version of EP to which you are referring, but if there is a version of EP that *doesn't* support adding a product, then it is definitely defunct. EP4 does this by providing a new line of data that has a new primary key (default is products_model, but also has the ability to not identify a products_model or use a duplicate products_model and instead use the products_id or whatever is decided to be the primary key).
You misunderstood. What I'm saying is that this function is IN EP but not DBIO. I'm asking if that was intentionally left out, if I missed the function in DBIO that's already there, or if it's planned and not yet implemented.
Re: Database I/O Manager (DbIo) Plugin [Support Thread]
@badarac, there's a Products handler that enables you to import/export any fields present in the products/products_descriptions tables.
Re: Database I/O Manager (DbIo) Plugin [Support Thread]
Quote:
Originally Posted by
badarac
Oh and I really like the templates and the ability to create new ones. A suggestion is to add v_dbio_command to the pull down so it can be added to a template
Good suggestion; let me see what's up with that.
Re: Database I/O Manager (DbIo) Plugin [Support Thread]
Quote:
Originally Posted by
lat9
@badarac, there's a Products handler that enables you to import/export any fields present in the products/products_descriptions tables.
The way it seems to work though is it needs an existing product id and/or model. That would seem to indicate that it can only update information for existing products. Am I wrong?
Re: Database I/O Manager (DbIo) Plugin [Support Thread]
If the product is not found (by id or model), it's added during any import processing. You just need a unique model number to identify the product.
Re: Database I/O Manager (DbIo) Plugin [Support Thread]
Quote:
Originally Posted by
lat9
If the product is not found (by id or model), it's added during any import processing. You just need a unique model number to identify the product.
I exported the products, deleted all but one row (and the headers), deleted the product id, and made a unique model number. When I import the csv file with the single record it gives an error[*] products.products_id, line #2: Value () is not an integer. Is there a unique integer value that must be entered in the products_id column? Bug?
Re: Database I/O Manager (DbIo) Plugin [Support Thread]
Installed on 1.5.5e btw. Site is installed in a subdirectory for testing so I can make changes without harming anything if you want me to test a change.
Re: Database I/O Manager (DbIo) Plugin [Support Thread]
Quote:
Originally Posted by
badarac
You misunderstood. What I'm saying is that this function is IN EP but not DBIO. I'm asking if that was intentionally left out, if I missed the function in DBIO that's already there, or if it's planned and not yet implemented.
Yes, I did misread the statement placing the wrong emPHAsis on something missing from EP instead of something in EP considered missing from DbIO as a variant of EP.
Re: Database I/O Manager (DbIo) Plugin [Support Thread]
Quote:
Originally Posted by
badarac
Installed on 1.5.5e btw. Site is installed in a subdirectory for testing so I can make changes without harming anything if you want me to test a change.
My guess would be that the products_id column would need to be removed to support adding such a new product or a value of 0 maybe. Otherwise it identifies that there is nothing present as reported.
Re: Database I/O Manager (DbIo) Plugin [Support Thread]
Quote:
Originally Posted by
mc12345678
My guess would be that the products_id column would need to be removed to support adding such a new product or a value of 0 maybe. Otherwise it identifies that there is nothing present as reported.
One of those was a good guess!:D
To insert a product via import, you'll need to have both the v_products_id and v_products_model fields present in the to-be-imported CSV. Set the products_id value to 0 (not blank) and the products_model to the new product's unique model number.