Exporting Data using SQL

LDAP Browser allows you to export data in LDIF file format using SQL like syntax.

 

To Export the data in ldif format just type the sql statement in the sql editor and click the Export Button. When you click the export button an export dialog will open displaying the current sql or you can type the sql directly in the export dialog

 

Options

Description

 

Export Format (LDIF)

Select the data export format

 

File Name

The file to export to. Type in the full path or browse, to select the path on the file system. The drop-down list provides a history of recently used files.

Replace file if Exists

If the export file already exists, you must permit to overwrite the file or it will ask when you click Export.

Export DN

To export entry DN, check this box.

 

 

 

»         (CSV and Excel Format only) In the exported file, if any attribute has multiple values the values will be grouped together using Pipe (|) delimiter for example: top|person|organizationalPerson|inetOrgPerson|AIXAdmin.

»         (CSV Format Only) Any value with comma (,) in it will be surrounded by double quotes for example: "uid=test555503test222,uid=1062test444,cn=users,cn=test,cn=testuser,DC=LDAPSOFT,DC=COM".

 

Related tasks

 

Ldif Export

 

 

 


Ldapsoft Home page LDAPSoft Ldap Browser Home Page