This tab allows you to complete the migration tasks. Using this tab, you can:
Migrate DDI (Drug-Drug Interaction file)
Migrate Package Size
Migrate Copay Tier Data
Migrate Formulary Designator Data
Migrate Hazardous Waste Data
To see this tab, you must be assigned the role of National Migrator. See Identity Management for more information on roles.
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:
Export the file into a comma separated file (CSV).
Open an Excel file that will be the import spreadsheet and go to the Data tab and select From Text.
Pick the CSV file in the Import Text File popup window.
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:
Column A = EPL ID
Column B = Orderable Item Name
Column C = Formulary Designator
Column D = Orderable Item Text
To Migrate:
Click the Migration tab, and then click the Migrate Formulary Designator Data tab.
Click the Browse button. The system opens a navigation dialog.
Navigate to and select the file you want to migrate.
Click the Open button. The system adds the file name to the Formulary Designator Data file field.
Click the Upload button. The system uploads the file.
Once the migration process has completed, click the Download button to view migration results