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 Hazardous Waste Data

Use this tab to migrate hazardous waste 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 Hazardous Waste 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 Hazardous Waste 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 the migration results.

To run the query to dump the products from the database to generate the input file for hazardous waste is below.  After creating the file, the user will have to modify the values in the hazardous waste columns of the file to reflect what the products should have and then they can feed it into the migration.

 

select p.VUID as VUID, p.EPL_ID as EPL_ID, CMOP_ID, NDF_PRODUCT_IEN, VA_PRODUCT_NAME, gn.GENERIC_NAME as GENERIC_NAME, fs.SCHEDULE_NAME as SCHEDULE_NAME, DF.DF_NAME as DF_NAME, HAZARDOUS_TO_HANDLE, HAZARDOUS_TO_DISPOSE, PRIMARY_EPA, WASTE_SORT_CODE, DOT_SHIPPING_NAME
from ppsnepl.epl_products p,
ppsnepl.epl_orderable_items oi,
ppsnepl.epl_dosage_forms df,
ppsnepl.EPL_CS_FED_SCHEDULES fs,
ppsnepl.EPL_VA_GEN_NAMES gn
where
oi.epl_id =P.EPL_ID_OI_FK AND
df.epl_id =OI.DOSAGE_FORM_ID_FK AND
fs.epl_id =P.CS_FED_SCHED_ID_FK AND
gn.epl_id = P.VA_GEN_NAME_ID_FK;