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

[lat9]

Yes, all caps ADD Used the same file that I sent to you but with 0 zero inserted into the prod_id field

Crap, the screen paste doesn't work.

Rick, I'll see what's up a bit later. I've got a bunch of paid work that's got to be done.

[RixStix]

No problem. I understand paid dollars being first in line.

[shrimp-gumbo-mmmhhh]

1.5.7c
latest and greatest DBIO

I am getting this error on just 5000 rows (7.25mb) to upload:

Warning: File is larger than allowed sizes. See "Maximum Values" settings.

I am able to process like 40,000 records with the other I/O module ... albeit there are some errors happening with some records.

Is there some way I can open it up to process more rows or am I doing something wrong? How many rows would you estimate it should be able to upload at one time?

Also, would be great if it could spit out the SEO url associated with each product.

Thank you!

[DrByte]

The Maximum Values settings are probably your server's PHP configuration, specifically upload_max_size and post_max_size
You can see their current settings via Admin->Tools->Server Info.
To change them, talk to your hosting company's support team.

[lat9]

1.5.7c
latest and greatest DBIO

I am getting this error on just 5000 rows (7.25mb) to upload:

Warning: File is larger than allowed sizes. See "Maximum Values" settings.

I am able to process like 40,000 records with the other I/O module ... albeit there are some errors happening with some records.

Is there some way I can open it up to process more rows or am I doing something wrong? How many rows would you estimate it should be able to upload at one time?

Also, would be great if it could spit out the SEO url associated with each product.

Thank you!

The Maximum Values settings are probably your server's PHP configuration, specifically upload_max_size and post_max_size
You can see their current settings via Admin->Tools->Server Info.
To change them, talk to your hosting company's support team.

As DrByte indicated, it's not the number of rows being processed, it's the size of the .csv file itself.

I'll also look at including a v_products_link (export-only) value for the Products output.

[lat9]

As DrByte indicated, it's not the number of rows being processed, it's the size of the .csv file itself.

I'll also look at including a v_products_link (export-only) value for the Products output.

That updated version of /admin/includes/classes/dbio/DbIoProductsHandler.php can be downloaded here (https://raw.githubusercontent.com/la...ctsHandler.php) while I prepare a v1.6.6 release.

[lat9]

I've just submitted v1.6.6 of the Database I/O Manager for the Zen Cart moderators' review and will post back here when it's available for download.

This release contains changes associated with the following GitHub issues:

#184: PHP 8.1+ preparation.
#185: Correcting PHP Fatal error (Uncaught ArgumentCountError) for DbIoProductsHandler.
#186: Add 'v_products_link' (storefront link) to the DbIoProductsHandler.

[shrimp-gumbo-mmmhhh]

The Maximum Values settings are probably your server's PHP configuration, specifically upload_max_size and post_max_size
You can see their current settings via Admin->Tools->Server Info.
To change them, talk to your hosting company's support team.

Thank you DrByte! Good thought. The Database I/O has a few more fields than the Populate mod has .... but for my files the extra fields are empty so there is not too much difference in size.... I am able to load and import okay (at least without a message that the file is too big) about 37,000 products, I think at least 30,000 are getting put in????. I think I might be doing something wrong because I have gone down to 5000 rows and still not get it in....

Thank you for thinking on my issue!

[shrimp-gumbo-mmmhhh]

I've just submitted v1.6.6 of the Database I/O Manager for the Zen Cart moderators' review and will post back here when it's available for download.

This release contains changes associated with the following GitHub issues:

#184: PHP 8.1+ preparation.
#185: Correcting PHP Fatal error (Uncaught ArgumentCountError) for DbIoProductsHandler.
#186: Add 'v_products_link' (storefront link) to the DbIoProductsHandler.

Thank you so much! Excited to give it a try.

[lat9]

Thank you DrByte! Good thought. The Database I/O has a few more fields than the Populate mod has .... but for my files the extra fields are empty so there is not too much difference in size.... I am able to load and import okay (at least without a message that the file is too big) about 37,000 products, I think at least 30,000 are getting put in????. I think I might be doing something wrong because I have gone down to 5000 rows and still not get it in....

Thank you for thinking on my issue!

Noting that you can use the DbIo's Templates feature for your Products handling, reducing the number of fields exported to only those that you're manipulating. That will further cut down on the size of that imported .csv.