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

DannyVarley:

When I try the ADD in the command I get the issues:

✗ products.products_id, line #2: Value () is not an integer
✗ products.products_date_added, line #2: Value (0000-00-00 00:00:00) is not a recognized date value; the default value for the field will be used.

not sure if I need to put something in the products id or I need to sort the issue with the date value?

Im missing something somewhere im sure :(
Use a v_products_id of 0 and either remove the v_products_date_added column or change the date value to be a real date.

Just wanted to say this is awesome. I have been using a custom easypopulate version for years and after updating Maria a couple days ago it had error log issue and altering the code was taking longer than 2 minutes to fix so I got annoyed and found this. Its actually better than what I had been using once you setup a custom file creation. Weird it has so few downloads given how good it is. So thank you !!!

JimmyV:

Just wanted to say this is awesome. I have been using a custom easypopulate version for years and after updating Maria a couple days ago it had error log issue and altering the code was taking longer than 2 minutes to fix so I got annoyed and found this. Its actually better than what I had been using once you setup a custom file creation. Weird it has so few downloads given how good it is. So thank you !!!
Thanks for your kind words!

Certainly

Now if I wanted to bring all the special prices into the products feed to make it one huge csv I'd put that where? Looking in classes appears right. So into the ability to create a "custom" report I'd want to add
v_specials_new_products_price
v_specials_new_products_group_a_price
v_specials_new_products_group_b_price
v_specials_new_products_group_c_price
v_specials_new_products_group_d_price
to compliment the various group pricing tiers

In which table do the specials_new_products_group_x_price fields exist?

specials table...

its where if you have a special date designated sku it goes there on sale for x expiring on y and so forth

Hmm, the DbIoSpecialsHandler could be 'cloned' to handle those additional fields.

Yes working on learning how this was done/written and expanding that function.

Anyone using this plugin successfully in Zencart 2.0.1 or will it need updating?

yes, no

CSV not appearing in process area.
Hello. I have a problem that seems sort of like I am missing something. Spreadsheet is not showing for processing.
Zencart v1.5.8a
DBio 2.0.1
PHP version: 8.1.30
Mysql 8.1.30
No errors logs

Just started using the Plugin and tested first:
Actions:

1. Added product manually, and exported said product to get sheet.
2. Manually deleted same product and imported same exported sheet Ran test to get a feel for test interface and proceeded with import. Import succeeded fine.
3. Decided to clean up imports and deleted them from the GUI
4. Imported 1473 row CSV. Site reported a successful import but no file appeared in the GUI interface for processing. I tried again before launching a full scale investigation. Same effect.

Things I have done:

• Refreshed
  *Logged out logged in
• cleared cache
• looked for logs,
• tried to read nearly every post on this thread (sorry missed the last 4 pages I think)
• checked my version statuses
• upped processing time (for just in case)
• retested with a site produced spreadsheet (it also doesn't appear)
• checked the folder on the server, and the file exists. Permissions are fine (hence it working before)

I am at a loss! This seems like such a simple ...."something".. not sure.

I'm not sure what you were expecting. On an import, DbIo takes the CSV that you selected and modifies the database based on information present in that CSV.

There's no CSV output; that's what's created on an export.

lat9:

I'm not sure what you were expecting. On an import, DbIo takes the CSV that you selected and modifies the database based on information present in that CSV.

There's no CSV output; that's what's created on an export.

I guess I didn't explain that right or something. The CSV is not visible in the area where they are supposed to be visible when you import them (see attached example). It doesn't appear here to be processed. Before I deleted the other used ones, they were visible and could be processed as such.
I know how to use plugins (and hope I can predict most behavior.. lol) been using Zen Cart for a blue million years. This is a great program.. I am just missing something in my "scientific method" analysis to figure what the heck is going on.

That screenshot shows files associated with an "Orders" export, not product-related. When you choose the type of import/export you're trying to perform, DbIo displays the .csv/.log files associated with the selected I/O type.

lat9:

That screenshot shows files associated with an "Orders" export, not product-related. When you choose the type of import/export you're trying to perform, DbIo displays the .csv/.log files associated with the selected I/O type.

Thank you for your reply. I think somehow I am still not communicating this issue,

The screenshot I sent was was the Docs area of the actual program. Not MY screenshot. I was using it as an example of the area in which the correct imports/exports would appear. When using whatever handler, would match the handlers type import. Just an example of where ii goes when it goes .. that is all.

Please understand that I understand how the program is supposed to work.This is not matter of me not understanding. It worked just fine until I deleted old imports. Then nothing new will appear in that area after uploading (and getting a success report)
At this point, I feel like all that is happening is you are confused about the problem I am having and I was just looking for help with this specific issue to see if anyone had ANY idea why my imports would not appear here.

You're right, we're not communicating. If you could post two screenshots, one of the site's file-system showing the file contents of the /admin/dbio subdirectory and another of the Database I/O Manager page (the full page, please).

I'm unable to reproduce your issue based on your various descriptions.

After taking a few months off, I'm back trying to load more products using DBIO. I previously had no issues uploading databases, and have made no changes to my website since. Now, I have updated my .csv file and am trying to import the database. But, when I select the file to upload and click Upload, nothing happens. No files upload. I can export/download just fine, but can't upload the changes I've made. The only log entries I found show:

#1  require_once(/home/thecoinauthority/public_html/ADMIN/includes/init_includes/init_numinix_product_fields.php) called at [/home/thecoinauthority/public_html/includes/autoload_func.php:40]
#2  require(/home/thecoinauthority/public_html/includes/autoload_func.php) called at [/home/thecoinauthority/public_html/ADMIN/includes/application_top.php:42]
#3  require(/home/thecoinauthority/public_html/ADMIN/includes/application_top.php) called at [/home/thecoinauthority/public_html/ADMIN/dbio_manager.php:8]
#4  require(/home/thecoinauthority/public_html/ADMIN/dbio_manager.php) called at [/home/thecoinauthority/public_html/ADMIN/index.php:11]
--> PHP Warning: Undefined array key "gID" in /home/thecoinauthority/public_html/ADMIN/includes/init_includes/init_numinix_product_fields.php on line 79.

What am I missing? Why won't it upload anything? Thanks in advance!

V 1.5.8a
DBIO 2.0.1

Uploading a .csv file simply (er) uploads the file to your server. You then need to select the uploaded file to "Import" the changes.

lat9:

Uploading a .csv file simply (er) uploads the file to your server. You then need to select the uploaded file to "Import" the changes.

Thanks, lat9 but it wasn't even uploading the file to the server. After some extensive troubleshooting, I discovered it was a filesize error (for whatever reason it was not generating/showing the error message when failing to upload). I modified the max upload size on my host server, and then also had to modify settings in Maximum Values. Now it seems to be working as intended, but will report back if any unforeseen issues.

mcqueeneycoins:

Thanks, lat9 but it wasn't even uploading the file to the server. After some extensive troubleshooting, I discovered it was a filesize error (for whatever reason it was not generating/showing the error message when failing to upload). I modified the max upload size on my host server, and then also had to modify settings in Maximum Values. Now it seems to be working as intended, but will report back if any unforeseen issues.
Thanks for the update. I've created a GitHub issue (https://github.com/lat9/dbio/issues/220) to remind myself to check and correct!