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

Dear lat9,

I have the same issue as one of the first topics. I receive the following message:
The DbIo Manager does not support your installation, due to a mismatch between your DB_CHARSET (DB_CHARSET) and CHARSET (utf-8) values.

You have given a solution in the beginning, to change the configure.php file (define ('DB_CHARSET', 'utf-8'); into define ('DB_CHARSET', 'utf8');)

But.. I do not have that line into my configure file, only in the dis-configure.php file, but there is already the following line:

define('DB_CHARSET', 'utf8');

, is there an another way to solve this?

Best Regards,

@LadyoftheCave, I just posted on the thread that brought you here ... what version of Zen Cart are you running?

Ohh thank you, I will check :) I have 1.5.4

Hmm, that's not right; for ZC 1.5.4, you *should *have a DB_CHARSET definition within both /includes/configure.php and /YOUR_ADMIN/includes/configure.php, towards the bottom, with the other database definitions.

You should check your database via phpMyAdmin to make sure that the "collation" setting for the tables is something on the order of **utf8_**general_ci. If that's the case, then just edit those two files to add the line

define('DB_CHARSET', 'utf8');

to each. Remember that the /includes/configure.php file is normally marked read-only, so you'll need to change those permissions before editing!

If the collations show latin1_{something}, then there are more corrections needed.

Converting from iso-8859-1 to utf8

LadyoftheCave:

Ohh thank you, I will check :) I have 1.5.4

I am guessing that you still use an old configure.php set, one maybe from ZC 1.3.9x, which has never been updated. If you do have a configure.php file with the definition as per above, then, yes, it is the correct one and only needs the definition updated.

frank18:

I am guessing that you still use an old configure.php set, one maybe from ZC 1.3.9x, which has never been updated. If you do have a configure.php file with the definition as per above, then, yes, it is the correct one and only needs the definition updated.

It could be, I have updated once from 1.3.9, I will check this, thank you :)

lat9:

Hmm, that's not right; for ZC 1.5.4, you *should *have a DB_CHARSET definition within both /includes/configure.php and /YOUR_ADMIN/includes/configure.php, towards the bottom, with the other database definitions.

You should check your database via phpMyAdmin to make sure that the "collation" setting for the tables is something on the order of **utf8_**general_ci. If that's the case, then just edit those two files to add the line

define('DB_CHARSET', 'utf8');

> to each.  Remember that the /includes/configure.php file is normally marked read-only, so you'll need to change those permissions before editing!
> 
> If the collations show **latin1_**{something}, then there are more corrections needed.
> 
> [Converting  from iso-8859-1 to utf8](https://www.zen-cart.com/content.php?313-should-i-convert-my-store-from-iso-8859-1-to-utf8)

Hi lat9,

I have added the lines to the configure.php files and now it works like a charm :)

Thank you :smile:

Hi lat9,

Sorry, I have still one more question. You told me that it was possible to select only order files from a certain period, but I cannot find it, could you tell me where I can select this?

Best Regards,

LadyoftheCave:

Hi lat9,

Sorry, I have still one more question. You told me that it was possible to select only order files from a certain period, but I cannot find it, could you tell me where I can select this?

Best Regards,
To export orders based on status, date- or id-range:

• Click Tools->Database I/O Manager
• Choose the *Orders *handler from the top-most dropdown
• Tick the Show/Hide filters box
• Make your selections from the form fields now exposed.
• Click the *Export *button

lat9:

To export orders based on status, date- or id-range:

• Click Tools->Database I/O Manager

• Choose the *Orders *handler from the top-most dropdown

• Tick the Show/Hide filters box

• Make your selections from the form fields now exposed.

• Click the *Export *button

ahhh that is great, I totally missed that one, thank you :)

Sorry, I am almost there, but still one question :blush: I am trying to upload the excel file into my bookkeeping program.

The bookkeeping program has problems with the date and time. I am trying to change the date_purchased. I thought that it would be in the dbio settings, I changed the dates into the dbio settings but that didn't work. It now shows first the year, then the month and then the day and then the time that the order was placed.


Is there a way to remove the time that the order has been placed, and show the date as d-m-y instead of y-m-d

In excel, you should be able to select all the cells with the dates, right click and select format cells, choose date, select the date format you prefer, and click ok. And that will get rid of the time. You can create a macro in excel to do this function for you so it's just a matter of a custom keystroke combination. This way you are not overwriting the module's file which will then be overwritten during updates. Lat9 might know a way that you can write an extra_function to do this in zen cart, I have never used this mod so I cannot say.

Hi lankeeyankee, thank you for your reply.

The problem is that if I import de dbio-file into excel, I do not see cells, only lines, so it is unfortunatelly not possible to select cell-columns. Only when I try to import the file into my bookkeepingsoftware, I see cells instead of lines, but these cannot be adjust, and because they cannot be adjust, the bookkeepingsoftware says sorry, cannot import this, the date is wrong.

LadyoftheCave:

Hi lankeeyankee, thank you for your reply.

The problem is that if I import de dbio-file into excel, I do not see cells, only lines, so it is unfortunatelly not possible to select cell-columns. Only when I try to import the file into my bookkeepingsoftware, I see cells instead of lines, but these cannot be adjust, and because they cannot be adjust, the bookkeepingsoftware says sorry, cannot import this, the date is wrong.
I noticed that you're importing the exported CSV into Excel, but you've got the DbIo's "CSV Encoding" set to utf8. Note that using Excel to view/modify the exported CSV normally requires that the DbIo's "CSV Encoding" be set to *latin1 *(since Excel doesn't understand utf8).

I don't understand your comment about not seeing cells, only lines. What version of Excel are you using?

...(since Excel doesn't understand utf8)
I only use Libreoffice Calc precisely for this reason. Excel's 1970's "handling" (joke) of CSVs, extended character sets, (non) control of import and export formats leaves me speechless that it still has any user base in any country that has accents in its language. It is utter rubbish.

Using Calc will remove some of the unnecessary problems you may come across with Excel.

Off topic-ish
If you want to automate conversions from anything to anything in any format you like (including any db source or destination) whether a known format or your own, I recommend Pentaho Data Integration community.

Thank you all for the info :)

Do I understand it right that there is no way to export the dbio-file with the right date? (d-m-y and without the time), that the only way is to change it manually into a excel-alike program?

Best Regards,

LadyoftheCave:

Thank you all for the info :)

Do I understand it right that there is no way to export the dbio-file with the right date? (d-m-y and without the time), that the only way is to change it manually into a excel-alike program?

Best Regards,
Currently, that is correct. I'll create a change-request (so I remember!) on the plugin's GitHub repository, adding an output-date format selection to the Orders handler.

Thank you :)

Just wanted to tell you that, with a few adaptations in OpenOffice, it works great to import the file into my bookkeeping software :)

I am very happy, :D :D it saves a lot of time

Can anyone offer any advise - im trying to import products from zencart 1.3.9h to zencart v1.5.5e

2 different webhosts also

1.3.9h
Maximum Upload File Size: 32M
Internal Character Encoding: iso-8859-1
Database Character Encoding: DB_CHARSET
Default Language: en

v1.5.5e
System Settings
Maximum Upload File Size: 24M
Internal Character Encoding: utf-8
Database Character Encoding: utf8
Default Language:

ive managed to upload it but i get the following -

483 errors and 0 warnings. 0 records were inserted or updated.

what can i do to make it work ..is there way? any help greatly appreciated