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

[LadyoftheCave]

Sorry, I am almost there, but still one question 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

[lankeeyankee]

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.

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

[lat9]

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?

[torvista]

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

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

[lat9]

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.

[LadyoftheCave]

Thank you :)

[LadyoftheCave]

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, it saves a lot of time

[boomy]

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