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

hi,

After installing the latest version in the Plugins section in a test site I have, using ZC 1.5.5a, I was trying to upload my products from my live site, so I created an output file with the old version 1.0.0.1, the one in the test site is 1.4.1, as the interface has significant changes, I was hoping my exported file dbio.Products.x was readable by the new version but then I had an error message saying v_products_id wasn't found, which is weird because I usually use the app to export my products as a csv and then open the files in Excel and the column isn't there so it seems the new version can't read an old version export file, what can I do? I thought, it will be useful if I could use the export file as it's a real time saver.

Quote:

---

Originally Posted by icecold

hi,

After installing the latest version in the Plugins section in a test site I have, using ZC 1.5.5a, I was trying to upload my products from my live site, so I created an output file with the old version 1.0.0.1, the one in the test site is 1.4.1, as the interface has significant changes, I was hoping my exported file dbio.Products.x was readable by the new version but then I had an error message saying v_products_id wasn't found, which is weird because I usually use the app to export my products as a csv and then open the files in Excel and the column isn't there so it seems the new version can't read an old version export file, what can I do? I thought, it will be useful if I could use the export file as it's a real time saver.

---

You could try simply adding an empty v_products_id column to that "old version export" file. The import will locate the to-be-changed product by either its v_products_model (which the old export has) or its v_products_id.

ok hope that works

Nicely done as usual, Cindy. Any chance you could build a handler with both Customer data and the primary entry from address book so we could get an address too? Thanks again for this mod.

Quote:

---

Originally Posted by swguy

Nicely done as usual, Cindy. Any chance you could build a handler with both Customer data and the primary entry from address book so we could get an address too? Thanks again for this mod.

---

Thanks, Scott! I've noted your request as a DbIo GitHub issue: https://github.com/lat9/dbio/issues/118 and should have some traction on this in a week or so.

I'm testing the newest version on a near vanilla install of ZC 1.5.5f, I said "near", because what I've already installed is a custom template, that's it nothing else and now dbio 1.4.1

I had dbio running for a long time in my live 1.5.3 store, and without problems, well the new version is not working with my export files, I have files with 19,000 products that were handled fast and efficiently by the old dbio 1.1 but this new version gets stuck, as suggested I manually added the "v_products_id" column, and now the 10Mb file that works fine in the old ZC seems to get stuck at 33%, I checked the logs and nothing is there!!! So please tell me how to fix this as I am in the process of migrating my old 1.5.3 store into a new 1.5.5f

Quote:

---

Originally Posted by icecold

I'm testing the newest version on a near vanilla install of ZC 1.5.5f, I said "near", because what I've already installed is a custom template, that's it nothing else and now dbio 1.4.1

I had dbio running for a long time in my live 1.5.3 store, and without problems, well the new version is not working with my export files, I have files with 19,000 products that were handled fast and efficiently by the old dbio 1.1 but this new version gets stuck, as suggested I manually added the "v_products_id" column, and now the 10Mb file that works fine in the old ZC seems to get stuck at 33%, I checked the logs and nothing is there!!! So please tell me how to fix this as I am in the process of migrating my old 1.5.3 store into a new 1.5.5f

---

One of the things that was added to the ProductsHandler from DbIo 1.1.0 to 1.4.1 was the addition of a configuration setting Products: Auto-Create Categories on Import?, which defaults to No.

What is your setting for the DbIo "Max Execution Time"? I've reviewed the changes from 1.1.0 to 1.4.1 and don't see anything that "stands out" as possibly causing the issue that you're having.

If it's possible for you to zip-up that import file, let me know and I'll send you my direct email so that I can see for myself what is going on.

Well it was a nightmare uploading it into my server because I had to use cpanel, while the older version never got stuck ... can you tell me what's the best php.ini settings for your app to upload files between 10 and 20Mb? I went to the settings and set max upload size to 500Mb, and timeout to 600 secs which is crazy I know ...
So my guess is when I set up PHP 7.x something messed up the configuration of that particular php.ini ...

Quote:

---

Originally Posted by icecold

Well it was a nightmare uploading it into my server because I had to use cpanel, while the older version never got stuck ... can you tell me what's the best php.ini settings for your app to upload files between 10 and 20Mb? I went to the settings and set max upload size to 500Mb, and timeout to 600 secs which is crazy I know ...
So my guess is when I set up PHP 7.x something messed up the configuration of that particular php.ini ...

---

So, you're having issues uploading a .CSV file after the upgrade, too? Are you able to upload large-size image files for products using Catalog->Categories / Products? I ask because that uses the same built-in upload class for its handling.

A couple of php.ini settings that would apply are and file_uploads and upload_max_filesize. What version of PHP is the store running on?

Is it possible for me to call dbio from another program? "Hey, DBIO: Import this products file" is what I'd like to do, without the user having to go dbio, select products, and use the import form.