Community discussions

MikroTik App
 
kempoguy
just joined
Topic Author
Posts: 11
Joined: Wed Jul 27, 2016 6:05 am

Exporting Dude data

Fri Jul 29, 2016 5:38 am

Hi,

This is a question that has probably been asked 1000 times already, but...
I need to create a CSV (or similar) with all the details of the devices we have configured in our Dude install. 

The CSV function doesn't seem to do what I need - although that may be simple stupidity on my behalf also.

I think I saw somewhere that

Can someone shed some light on this? 

**EDIT**
I'll add that I want to extract the full details from each device. I have exported via the CSV function, but it only includes limited details - whereas I want all the config data. Reason being, in time, there is a chance that out IT department will force us to use a different product and it would be handy to be able to import the whole config via csv, xml or whatever
 
krisjanis
MikroTik Support
MikroTik Support
Posts: 432
Joined: Tue Feb 05, 2013 5:00 pm

Re: Exporting Dude data

Fri Jul 29, 2016 1:35 pm

CSV export button in client creates table of data that is displayed in that specific panel/window/tab. It cannot be used to export device config.
I suspect that at some point we will want to add such feature in the dude for easier backup/export.rsc file creation, but at the moment it's just an idea in planing stage.

For now I you should use Export/Import commands in ROS and scripts or API to automatize the whole export creation and upload/download to somewhere task 

Wiki articles on the topic:
http://wiki.mikrotik.com/wiki/Manual:Co ... Management
http://wiki.mikrotik.com/wiki/Manual:API
http://wiki.mikrotik.com/wiki/Manual:Scripting
http://wiki.mikrotik.com/wiki/Manual:System/Scheduler
http://wiki.mikrotik.com/wiki/Manual:Tools/Fetch
 
kempoguy
just joined
Topic Author
Posts: 11
Joined: Wed Jul 27, 2016 6:05 am

Re: Exporting Dude data

Mon Aug 01, 2016 6:09 am

Thanks KrisJanis for that - I have exported the config for backup purposes, then I unzipped and tried opening the file - What format is the DB in? I would like to get the full config data in an XML or something for import into other packages. One of our needs is to generate an asset register from the details contained in the Dude.

Any suggestions how this could be done?
 
krisjanis
MikroTik Support
MikroTik Support
Posts: 432
Joined: Tue Feb 05, 2013 5:00 pm

Re: Exporting Dude data

Mon Aug 01, 2016 11:36 am

Server uses sqlite3 db. Can't comment on data extraction/conversion tools as I haven't tried any custom ones. 

Who is online

Users browsing this forum: No registered users and 12 guests