How do I export and manipulate a .CSV file to import into Exchange Migrator. (NETIQKB23191)

goal
How do I export and manipulate a .CSV file to import into Exchange Migrator.

fact
Exchange Migrator 2.x

fix

1. Open 'Exchange Administrator'
   
2. Select Tools | Directory Export
   
3. Export from 'GAL' or 'Recipient container'
   
4. Select Unicode
   
5. Verify that the ?separator? is a comma ?,? 

FOR MS ACCESS: 

1. Open 'MS Access'
   
2. Select New blank database
   
3. Select File | Get External Data | Import
   
1. Change ?Files of type? to ?Text Files' (*.txt,*.csv,*.tab,*.asc)
   
2. Browse to file, click Import
   
3. Import Text Wizard, leave as ?Delimited?
   
4. Click Next
   
5. Choose comma (,) for Delimiter
   
6. Choose double quote ( ? ) for Text Qualifier
   
7. Select First Row Contains Field Names , click Next
   
8.  Leave ?In a New Table? selected, click Next
   
9. Click Next (Field Options)
   
10. Select No primary key, click Next
    
11. Name the table, click Finish
    
4. Make changes to file as desired
   
   NOTE* - If the Exchange export was performed from the GAL you will need to add the ?Org? to the Obj-Container field.
   
1. Click the Obj-Container column header
   
2. Select Edit | Replace
   
3. Find ?/ou=? (no single quotes)
   
4. Replace with ?/o=orgname/ou=? (no single quotes)
   
5. Look in  ?Obj-Container?
   
6. Match ?Start of Field?
   
7. Click Replace All
   
5. Select File | Export
   
6. Export Text Wizard
   
1. Change ?Save as type? to ?Text Files' (*.txt,*.csv,*.tab,*.asc)
   
2. Click Save All
   
3. Leave ?Delimited? selected
   
4. Click Next
   
5. Choose comma (,) for Delimiter
   
6. Choose double quote ( ? ) for Text Qualifier
   
7. Select Include Field Names on First Row
   
8. Click Next
   
9. Verify file name, click Finish
   
10. Click Ok             

 

FOR MS EXCEL:

1. Open 'MSExcel'
   
2. Select New blank workbook
   
3. Select File | Open
   
1. Change 'Files Type' to ?Text Files' (*.prn,*.txt,*.csv)
   
2. Browse to exported .csv file
   
3. Click Open
   
4. Text Import Wizard
   
1. Leave ?Delimited? selected
   
2. Click Next
   
3. Change ?Delimiters? to comma (,)
   
4. Leave ?Text qualifier? as double quote (?)
   
5. Click Finish
   
   NOTE* - If the Exchange export was performed from the GAL you will need to add the ?Org? to the Obj-Container field.
   
6. Click the Obj-Container column header
   
7. Select Edit | Replace
   
8. Find ?/ou=? (no single quotes)
   
9. Replace with ?/o=orgname/ou=? (no single quotes)
   
10. Click Replace All
    
5. Select File | Save As
   
1. Change ?Save as type? to ?CSV' (Comma delimited)(*.csv)
   
2. Click Save

 

  FOR MS ACCESS and MS EXCEL : 

  Right-click the newly created file and select Open With to open it in Notepad. 

1. In Notepad:
   
1. Select Edit | Replace to Replace ?Mailbox? (with the quotes) with Mailbox (without the quotes)
   
2. Select File | Save As.
   | Filename name.csv
   
3. Save as type ?Text Documents' (*txt)
   
4. Select Encoding Unicode
   
5. Click Save

 

Now you are ready to import this file into Exchange Migrator!

.


note

Please refer to the following knowledge base article for more detailed information on exactly what columns are necessary:

• https://www.netiq.com/kb/esupport/consumer/esupport.asp?id=NETIQKB28085

note
Although we do not anticipate issues, please understand that the use of modified .CSV files has not been tested and therefore is not officially supported.

If any step is overlooked or performed incorrectly chances are, the file will not correctly import into Exchange Migrator.  Also keep in mind that an object can only exist in one project at any time, so if you have already imported a .CSV file or manually added Objects to another project those objects can not be added to a new project until they are removed from the original project.

Formerly known as NETIQKB23191