Community discussions

MikroTik App
 
aea9tthompson
just joined
Topic Author
Posts: 14
Joined: Sat Jan 05, 2008 12:55 am

The Dude database format

Wed Mar 11, 2009 12:04 am

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
 
geekybryan
just joined
Posts: 1
Joined: Mon Mar 30, 2009 8:40 pm

Re: The Dude database format

Mon Mar 30, 2009 8:44 pm

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
 
franzcro
just joined
Posts: 1
Joined: Mon Dec 28, 2009 4:12 pm

Re: The Dude database format

Wed Jan 27, 2010 2:20 pm

Hi guys,

did you find some info about database format?

Best regards,
 
User avatar
blackpaw
newbie
Posts: 37
Joined: Thu Jan 28, 2010 7:19 pm
Location: Amsterdam, NL

Re: The Dude database format

Fri Jan 29, 2010 9:28 am

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
life is one of the hardest
 
nohomo
just joined
Posts: 1
Joined: Tue Nov 16, 2010 5:46 pm

Re: The Dude database format

Tue Nov 16, 2010 6:19 pm

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/
 
User avatar
geoffsmith31
Member Candidate
Member Candidate
Posts: 151
Joined: Fri Nov 05, 2010 6:08 am
Location: Toowoomba, Australia

Re: The Dude database format

Tue Mar 22, 2011 5:05 am

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?
 
petersmith
just joined
Posts: 1
Joined: Tue Feb 07, 2012 2:19 pm

Re: The Dude database format

Tue Feb 07, 2012 2:37 pm

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
 
hwmonkey
Member Candidate
Member Candidate
Posts: 115
Joined: Wed Feb 08, 2012 9:50 pm

Re: The Dude database format

Fri Mar 23, 2012 8:13 pm

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 64 bit. It installed a driver. I went to ODBC config, and point it to dude.db and cannot find any tables. Suggestions?

Thanks
 
davidw
Frequent Visitor
Frequent Visitor
Posts: 91
Joined: Fri Apr 27, 2007 11:11 pm

Re: The Dude database format

Tue Aug 07, 2012 6:29 am

did you have any luck with this in the end ?
 
hwmonkey
Member Candidate
Member Candidate
Posts: 115
Joined: Wed Feb 08, 2012 9:50 pm

Re: The Dude database format

Fri Aug 17, 2012 10:16 pm

did you have any luck with this in the end ?
Not me. I am not certain of others.
 
davidw
Frequent Visitor
Frequent Visitor
Posts: 91
Joined: Fri Apr 27, 2007 11:11 pm

The Dude database format

Sat Aug 18, 2012 5:18 am

Apparently it's not possible. Mikrotik confirmed this.

Who is online

Users browsing this forum: No registered users and 12 guests