What format is The Dude’s database?
When I run the files thru TriIDNET it says its “XMill compressed XML.”
I would like to get access directly to the configuration data without having to export it to a XML file for read-only purposes. I would like to use The Dude as my main documentation system and be able to export information for my own purposes.
Any help would appreciated,
Tom
aea9tthompson - If you get an answer on this or you find a way to do it otherwise, please let me know! I’m very interested in this also.
MicroTik - If you’re watching, it would be a great feature if you could allow The Dude to store data in an external SQL. Thanks!
Bryan
Hi guys,
did you find some info about database format?
Best regards,
I am interested, too. This would allow me to import lots of device names, locations, configs, instructions and other helpful things into the config of a device/service.
I do this manually which works fine but I am lazy 
Andreas
It appears to be SQLite 3 - http://www.sqlite.org/
You probably want to use an ODBC connection so try http://www.ch-werner.de/sqliteodbc/
I downloaded the suggested ODBC driver and can import all but one table into Access or Exel. Unfortunately the table I can’t get (objs) seems to be the one that links everything together. All the other tables just have values and ID references 
. Has anybody had any success with this?
XMill is a user-configurable, easy to use XML compressor. It separates structure, layout and data and distributes data elements into separate data streams. If you want to download odbc driver then try from: http://www.datadirect.com/products/odbc/index.html
I downloaded the 64 bit. It installed a driver. I went to ODBC config, and point it to dude.db and cannot find any tables. Suggestions?
Thanks
did you have any luck with this in the end ?
Not me. I am not certain of others.
Apparently it’s not possible. Mikrotik confirmed this.