Migration Tab

This tab allows you to complete the migration tasks. Using this tab, you can:

To see this tab, you must be assigned the role of National Migrator. See Identity Management for more information on roles.

Migrate Formulary Designator Data

Use this tab to migrate formulary designator data.

If the user tries to import a file and a required field is left blank, the user will see this error message: "The import file data is formatted incorrectly: for input string 'xx'".  

If the user exports the file from the database, please the instructions below:

  1. Export the file into a comma separated file (CSV).

  2. Open an Excel file that will be the import spreadsheet and go to the Data tab and select From Text.

  3. Pick the CSV file in the Import Text File popup window.

  4. After the file has been selected, it will ask for a delimeter (comma) and then another page will let the user select each column and specify the data type.

Note: The EPL_ID column in the import spreadsheet must be formatted as "text" in Excel, not as a number, to ensure that the correct values are imported (Excel rounds any number longer than 15 digits to zero in right-most digits, which makes the EPL IDs invalid).

 

The structure of the file should be in the following format:

 

To Migrate:

  1. Click the Migration tab, and then click the Migrate Formulary Designator Data tab.

  2. Click the Browse button. The system opens a navigation dialog.

  3. Navigate to and select the file you want to migrate.

  4. Click the Open button. The system adds the file name to the Formulary Designator Data  file field.

  5. Click the Upload button. The system uploads the file.

  6. Once the migration process has completed, click the Download button to view migration results