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

[fwood2]

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.

[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.

[fwood2]

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.

[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.

[fwood2]

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.

[lat9]

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.

[mcqueeneycoins]

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

[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.

[mcqueeneycoins]

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.

[lat9]

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!