-
Title
What is the format of an Import file when selecting objects for processing with a wizard like AD, -
Description
What is the syntax for an import file which can be used to select objects for processing with a wizard like AD, SQL or Exchange Processing Wizard?
-
Resolution
When selecting objects all objects can be selected and Exported to a txt file.
The same file can be modified and then used when importing the selection, the syntax is the same as in exported file.
The header should remain as it was and the syntax could look like:
--------------------------------------
Src_name Trg_name Src_objectClass Trg_objectClass
User Name User Name user user
--------------------------------------
Important: the file (all entries) is tab delimited, it is a good idea to use Excel and save the file as tab delimited txt file. -
Additional Information
When using Excel to edit the import file and saving the results in a tab separated Excel file then Excel adds quotes around any field that has a comma. Often objects have commas because of the naming format, eg. "Lastname, Firstname". If this happens the quote characters need to be removed. As workaround the file can be opened with Notepad and quote characters can be replaced with nothing (empty space) by using the Edit - Replace feature.
If an object has non-regular characters in its name like an apostrophe then the import of such a file can fail with an error "The format of the specified file is invalid. Please specify a valid file."
Removing such an entry from the import file allows to use the file successfully, and the object can then be selected manually.