Tom G
05-31-2002, 02:24 PM
Sorry about that first blank post... hit the enter key by mistake.
I need to export a list of user data from my Active Directory into a file so that I can import it into an Informix database. There is already a shell script running on a Unix server that imports data from another directory using CSV files. I've experimented with CSVDE and was able to export the directory listing to a file. But CSVDE puts the Distinguished Name in the output file, which I will need to remove. It also arranges the output values in alphabetical order according to the attribute, and I will need to have the output in a certain order. I know I can manipulate the CSV file in Excel manually, but I need to automate this. Anyone know how I can do this? Alternately, anyone know of a tool that can manipulate LDIF files?
TIA,
Tom
I need to export a list of user data from my Active Directory into a file so that I can import it into an Informix database. There is already a shell script running on a Unix server that imports data from another directory using CSV files. I've experimented with CSVDE and was able to export the directory listing to a file. But CSVDE puts the Distinguished Name in the output file, which I will need to remove. It also arranges the output values in alphabetical order according to the attribute, and I will need to have the output in a certain order. I know I can manipulate the CSV file in Excel manually, but I need to automate this. Anyone know how I can do this? Alternately, anyone know of a tool that can manipulate LDIF files?
TIA,
Tom