How to export a complete address book to CSV from command line
-
I know I can export an address book from inside the MDaemon interface on the server.
I need a way to export a complete address book to CSV from command line since the export must be unattended at regular intervals during the day.
Can someone help?
-
Arron Staff
I don't believe we have a command line tool to convert an address book to CSV.
However, address book data is stored in an XML like file and there are numerous 3rd party tools available to convert from XML to CSV. I have not tried any of them so I cannot suggest one.
You could use a scripting language such as powershell to convert the data.
If you need the process to happen on another machine, you can retrieve a list of contacts from the XML-API and convert the data.
I'm sure there are also other options that I have not thought of.
-
Thank you Arron, thank you.
Following your suggestion, I have found what I was looking for: XMLWizard.
It happens that we use internally the Firebird SQL database server, and we need to import MDaemon's Address Books in it.
Given this assumption XMLWizard is the perfect tool for it as I am able to map each field of MDaemon's Address Book to a field in a Firebird's table field.
I hope this would be useful to other MDaemon users too.
Please note that the tool is not free but it cost only $39.99 so I think the price is not a problem.
https://www.guacosoft.com/xmlwizard/
As stated from their website:
About XMLWizard
XMLWizard is a tool used to import and compare data from files against Firebird databases. It supports XML, CSV and flat (fixed-width column) textual files.