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
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:Configuration_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
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?
Server uses sqlite3 db. Can’t comment on data extraction/conversion tools as I haven’t tried any custom ones.