N Migrating for Excel Upload Functionality

This section provides detailed instructions to migrate excel upload functionality.

Prerequisites

The following are the prerequisites for migration:

  • "Data model in ATOMIC schemas should be same on the source and target setups
  • "OFS AAI (platform) patch level version should be same on the source and target setups.
  • "PL/SQL Developer to connect and query the database.
  • "WinSCP to connect and access server file system.

Migrating Excel Upload

To migrate, follow these steps:

  1. Open PL/SQL Developer and log in 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 PL/SQL developer and log in to the target setup's configuration (CONFIG) schema by entering the appropriate username and password.
  4. Insert the records from Step 1 above into this table.
  5. In V_INFODOM column of 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 same Infodom value across all rows. If only few mappings will work out of the target infodom, update the infodom value for selective records. Kindly note, excel upload mappings will work only if the target infodom has same data model entities as used in the mappings defined on source setup.
  6. Update 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 login a new session by entering the host name, port number, user name and password to access the source setup.
  8. Navigate to the folder referred as FTPSHARE.
  9. Copy the excel-entity mapping xml file(s) which are located in this folder according to their folder structure on to your desktop. For example: /ftpshare
    /STAGE/ExcelUpload/$SOURCE_INFODOM_NAME/$EXCEL_FILE_NAME.xml

    Note:

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

    Note:

    Ignore this step if files are not present at the location.
  11. Login 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 below location in the target setup.

    For example: /ftpshare/STAGE/ExcelUpload/$TARGET_INFODOM_NAME/$EXCEL_FILE_NAME.xml.

    $TARGET_INFODOM_NAME must be target setup infodom in which you have uploaded the appropriate data model and the name should be 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 below location in target setup.
    For example: /ftpshare/STAGE/ExcelUpload/TEMPLATE/*.xls or *.xlsx.

    Note:

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