Config Schema Upload

Configuration Schema refers to the Database Schema that is referred by all information domains to access data related to Metadata, System Configuration, Administration Security, and so on. Configuration Schema stores the user security information and metadata used within the applications which are deployed on OFSAA Infrastructure.

To navigate to this screen, go to the Objects Administration tab, expand Translation Tools and click Config Schema Upload from the LHS menu.

The Config Schema Upload window facilitates you to upload data to the configuration schema table either by appending incrementally or complete re-load on the existing data, in Microsoft Excel 2003/2007 format. During upload, all the referential Constraints (Foreign Key Constraints) enabled on the selected database object (table) are disabled and enabled back post upload. In case of any errors while enabling the referential constraints or inserting the new data, the selected database object (table) will be reverted back to its original state.

The Config Schema Upload window has restricted access and you should have Config Excel Advanced user role mapped to your user group to upload configuration schema data.

To upload Config Schema Data:

1. Select the table from the drop-down list. The list consists of those database objects (tables) which are mapped to Configuration Schema based on a specific configuration.
2. In Select the File to Upload field, click Browse. In Choose File to Upload dialog box, navigate and specify the path of the data file (Microsoft Excel 2003/2007) which you want to upload. If the excel contains multiple sheets, you can select the sheet from which data is to be uploaded. Otherwise, by default the first sheet data is selected for upload.
3. In Select the Sheet field click button, the Sheet Selector pop-up window is displayed. Select the required sheet from the drop-down list and click OK.
4. In the Upload Type options, select one of the following:

   • Incremental - In this type of upload, the data in Excel sheet is inserted / appended to the target database object. The upload operation is successful only when all the data in the selected Excel Sheet is uploaded. In case of any error, the uploaded data will be rolled back.

   • Complete - In this type of upload, the data present in the selected database object is overwritten with the data in selected Excel sheet. In case of an error, data in the selected database object will be reverted back to its original state.

5. In Source Date Format field, specify the date format used in the data that you are uploading. An insert query is formed based on the date format specified.
6. Select Upload. If you have selected Complete upload type, you will need to confirm to overwrite data in the confirmation dialog box. An information dialog box is displayed with the status of upload. You can click on View Log to view the log file for errors and upload status. The log file contains the following information:

   • Database object (table) to which the data is uploaded.

     Name of the excel file from which the data is uploaded.

     Number of records uploaded successfully.

     Number of records failed during upload and reason of failure.

     Upload Status (Success/Fail).