What is LDIF Converter?

LDIF Converter is a piece of software that has two main modules. These modules allow you to easily:

(i) convert files from LDIF to CSV
Unlike other conversion tools, there is no need to know the structure of your LDIF file before conversion
(ii) convert from CSV to LDIF
Easily create LDIF files from a standard CSV file. Again, no need to create configuration files before conversion
The tool itself does not carry out any data comparison, but does extract and present the data in a very user friendly manner, ensuring that the data can be easily and quickly imported into spreadsheet or database tools for later comparison.

If you work with LDIF files you will know that although they are easy to understand at a record level, it is almost impossible to find patterns in the data across numbers of records.  It is also difficult to accurately compare data that has been input through various sources, or from one LDAP directory to another. The genesis of this tool was being confronted with the need to test the implementation of a large identity management system across a number of  LDAP directories, with a large number of connected systems.

This page will attempt to describe what the tool can do and give examples of how it might help in your day to day work.

Convert text files from LDIF to CSV format

Several tools that are available to convert or extract LDIF files require large amounts of input during the conversion process. You need to know all the attribute names before you start conversion. This tool does most of this work for you whilst still allowing you input into the conversin process. The graphical interface allows you to easily choose only those attributes you want to convert. Once you start using the tool, you will wonder what you ever did without it. Once you have converted the file to a CSV format, you can use a spreadsheet or database product to view the data.

Testing
This tool has been developed to enable you to thoroughly test the contents of your LDAP directory. How do you look for issues and faults in LDIF files? You cannot see patterns in data or even what the attributes are. Whether the data is loaded automatically from several feeder systems or manually, you need to ensure that the data and rules are being followed correctly to provide accurate, correctly formatted data and as a consequence, enable consistent Identity Management processes.

Most directories allow you to extract the data in LDIF format – but how do you test that output? How do you find patterns, confirm data formats, single and multi-attribute values etc.? That was the situation that confronted the developer of this application. This tool has been developed (and used) for exactly the purposes listed above. LDIF converter data once converted to CSV format is imported easily into spreadsheets or databases for the actual comparison. In fact, the tool continues to be used long after implementation to ensure ongoing data integrity. LDAP directories and their feeder systems are never static. Something is always changing and introducing potential new problems. Because the tool is used on a daily basis, it is constantly updated and made increasing relevant and easy to use for the directory administrator.

The eDirectory LDIF export exports all attributes – single or multi-value. The eDirectory CSV extract will only extract one of each attribute. If you want to see all multi-value attributes, you can only do this by exporting to LDIF.

Data Cleansing
Convert only those attributes you are interested in.

Convert very large files currently has been successfully tested with up to 200MB files

If you have made schema changes, this also enables you to test data in the directory to ensure it still meets the schema rules.

Convert text files from CSV to LDIF format

Using the LDIF and CSV capabilities together gives you the ability to export data from a directory, modify it and then re-load into a test environment or a new production environment.

This tool includes a very easy to use interface to convert CSV files to LDIF for importing into a directory.  Using a spreadsheet format allows simple cration of an import file - using the tools available in the spreadsheet.  Once completed, simply save the file as CSV and then convert that CSV to LDIF format. There is no requirement to list the attributes or link files. Simply open the CSV file with the conversion tool, and your LDIF file will be created for you.

Specialized conversions (LDIF to CSV)

Every now and again, LDAP applications are implemented in ways which mean that require specialized conversion processes. If required, these can be created for you. An additional fee will be charged for this service.

More information

If you would like more information, please Email us at LDIFConverter