Migrate Excel Upload

To migrate, follow these steps:
  1. Open PL/SQL Developer and logon to the source setup's configuration (CONFIG) schema by entering the appropriate username and password.
  2. In a new SQL window, query the data of table EXCEL_MAPPING_MASTER.
  3. Open a new session in the PL/SQL developer and logon to the target setup's configuration (CONFIG) schema by entering the appropriate username and password.
  4. Insert the records from Step 1 into this table.
  5. In the V_INFODOM column of the EXCEL_MAPPING_MASTER table, update the infodom name with the target infodom name.

    Note:

    If all the mappings can work out of the single target Infodom, update the same Infodom value across all rows. If only a few mappings will work out of the target infodom, update the infodom value for selective records. Excel upload mappings will work only if the target infodom has the same data model entities as used in the mappings defined on the source setup.
  6. Update the V_CREATED_BY column with the name of any user present in the target setup that has appropriate roles to perform Excel Upload tasks.

    Note:

    It is mandatory to update values for V_INFODOM and V_ CREATED_BY columns.
  7. Open WinSCP and log in a new session by entering the host name, port number, user name, and password to access the source setup.
  8. Navigate to the directory referred to as FTPSHARE.
  9. Copy the excel-entity mapping xml file(s) which are located in this directory according to their directory structure on to your desktop.
    For example: /ftpshare/STAGE/ExcelUpload/$SOURCE_INFODOM_NAME/$EXCEL_FILE_NAME.xml

    Note:

    The actual file name of the Excel Sheet is mentioned in the V_EXCEL_ NAME column of the EXCEL_MAPPING_MASTER table.
  10. Copy the excel templates (.xls/ .xlsx) file(s) which are located in this directory according to their directory structure on to your desktop. For example:
    /ftpshare/STAGE/ExcelUpload/TEMPLATE/*.xls or *.xlsx

    Note:

    xls/.xlsx files must be copied to the path as per the local path given in your webserverinfo table of config schema. Ignore this step if files are not present at the location.
  11. Log into a new session in WinSCP by entering the host name, port number, user name, and password to access the target setup.
  12. Copy the XML file(s) from Step 3 to the following location in the target setup.
    For example: /ftpshare/STAGE/ExcelUpload/$TARGET_INFODOM_NAME/$EXCEL_FILE_ NAME.xml.

    Note:

    $TARGET_INFODOM_NAME must be target setup infodom in which you have uploaded the appropriate data model and the name must be the same as the V_INFODOM column value updated in EXCEL_ MAPPING_MASTER table.
  13. Copy the xls/ xlsx file(s) from Step 3 to the following location in target setup.
    For example: /ftpshare/STAGE/ExcelUpload/TEMPLATE/*.xls or *.xlsx.

    Note:

    Ignore this step if files are not present at the location.