How to export open directory into csv file?

You might need to do a little extra work to get to a true csv, but you can use dsexport to output your OD account attributes to a flat file. For example, to dump everything:

sudo dsexport ~/Desktop/exportedUsers /LDAPv3/127.0.0.1 dsRecTypeStandard:Users

However, there are OD specific key/value pairs that you might not be interested in. You can use the -e and the key to exclude the value from the export. For example, a command I use quite frequent is:

dsexport ~/Desktop/exportedUsers /LDAPv3/127.0.0.1 dsRecTypeStandard:Users -e "dsAttrTypeStandard:AuthenticationAuthority" -e "dsAttrTypeStandard:Expire" -e "dsAttrTypeStandard:Change" -e "dsAttrTypeStandard:Password" -e "dsAttrTypeStandard:AltSecurityIdentities" -e "dsAttrTypeStandard:JPEGPhoto"

Please note that dsexport will not export passwords. However, if you are looking for an import file, you should likely be recreating password policy and entering them fresh.

Hope this helps,

Reid

Hi!

There is a tool named "Passenger". You can connect with it to the server and export the users. I use it for import of new users.

Take a look at (http://macinmind.com/?area=app&app=passenger&pg=info). But you have to pay for it... :-(

Good luck,

Peter.