Support Forums
Converting DBD to CSV from command line

Hello,

Does anyone know the commanded needed in a batch file to tell DeView to convert .dbd files to .csv files? I have a batch file set up to import data into MS Access, but MS Access can only import text files (hence *.csv).

I know you can do that conversion by manually opening up DeView and click through the menu options to convert data, but I don't want to do that for each data file I have. Is there a simple command line argument for DeView I can use to perform this .dbd to .csv conversion?

Thanks in advance.

Hello, Does anyone know the commanded needed in a batch file to tell DeView to convert *.dbd files to *.csv files? I have a batch file set up to import data into MS Access, but MS Access can only import text files (hence *.csv). I know you can do that conversion by manually opening up DeView and click through the menu options to convert data, but I don't want to do that for each data file I have. Is there a simple command line argument for DeView I can use to perform this *.dbd to *.csv conversion? Thanks in advance.

Good afternoon JackQiu,

DeView does not have a command line, you can use dump_DBD software instead. C++ code is also in the zip file.

Cheers,
Roger

Good afternoon JackQiu, DeView does not have a command line, you can use dump_DBD software instead. C++ code is also in the zip file. Cheers, Roger

Thanks Roger,

dump_DBD.exe works well without any need of modification to the source code. I had generated some data using DB80 and renamed the file to "test.dbd". The cmd lines I entered into my batch file consisted of:
(assuming batch file is in the same path as the exe and the test.dbd)

REM -- for alarm csv
DUMP_DBD.exe -a test.dbd > alarm.csv

REM -- for data csv
DUMP_DBD.exe -d test.dbd > data.csv

I'll test DUMP_DBD to see if it requires modification, I'll let you know how I go.

Cheers,
Jack

Thanks Roger, dump_DBD.exe works well without any need of modification to the source code. I had generated some data using DB80 and renamed the file to "test.dbd". The cmd lines I entered into my batch file consisted of: (assuming batch file is in the same path as the exe and the test.dbd) ~~~~~~ REM -- for alarm csv DUMP_DBD.exe -a test.dbd > alarm.csv REM -- for data csv DUMP_DBD.exe -d test.dbd > data.csv ~~~~~~ I'll test DUMP_DBD to see if it requires modification, I'll let you know how I go. Cheers, Jack

Hi Jack,

For additional information to run dump_DBD:

  • Copy paste DBD files to your dump_dbd installation directory
  • From command prompt go to dump_dbd installation directory 5dd5ca1c3806c

Best regards,
Rudy Gunawan

Hi Jack, For additional information to run dump_DBD: - Copy paste DBD files to your dump_dbd installation directory - From command prompt go to dump_dbd installation directory ![5dd5ca1c3806c](serve/attachment&path=5dd5ca1c3806c) Best regards, Rudy Gunawan
edited Nov 20 '19 at 11:19 pm
625
3
3
live preview
enter atleast 10 characters
WARNING: You mentioned %MENTIONS%, but they cannot see this message and will not be notified
Saving...
Saved
With selected deselect posts show selected posts
All posts under this topic will be deleted ?
Pending draft ... Click to resume editing
Discard draft