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

  • 7723191
  • 02-Feb-2007
  • 26-Sep-2007

Resolution

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

fact
Exchange Migrator 2.x

fix
To export and manipulate a .CSV file to import into Exchange Migrator, refer to the following steps:
 
  1. Open 'Exchange Administrator'
  2. Select ToolsDirectory 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:



      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.

      Additional Information

      Formerly known as NETIQKB23191

      Feedback service temporarily unavailable. For content questions or problems, please contact Support.