2.7.2.3 Configurable Bulk Upload
In the process of configurable bulk upload of data, the input file delimiter is configurable to required value and data is processed based on the column definitions defined. This option is supported for Transactions and Collateral uploads to create new transactions and asset records in bulk.
For bulk upload of data, the input CSV (comma separated values) file is to be constructed in specific format as defined in Setup > Data Files > Input screen’s Input Data File Definitions and Column Definitions sections.
Table 2-30 Column Definition Details
| Seq | Column Name | Column Description | Data Type | Length | Sort |
|---|---|---|---|---|---|
| 1 | ASE_OPERATION_ IND | OPERATION IND | CHARACTER | 30 | 1 |
| 2 | ASE_NBR | ASSET NUMBER | NUMERIC | 30 | 2 |
| 3 | ASE_REGN_DT | REGISTRATION DATE | DATE | 30 | 3 |
If the delimiter in Input Data file definitions is set as ‘,’ (comma), then the csv can be constructed in same format and sequence of column definition as indicated below with each row as one record:
ASE_OPERATION_IND,ASE_NBR,ASE_REGN_DT
NEW,20151200010476,12/08/2015
EXISTING,20111300010468,13/10/2011
NEW,20101400010812,14/11/2016
The CSV file is to be paced in the directory path/work area which is the base path
defined in system parameter - UIX_INCOMING_FILE_PATH (INCOMMING
FILE PATH OF APP SERVER) by the system administrator and further appended by the
configurable sub folder name such as ITU or ICC. For example:
/scratch/work_area/<domain name>/input/itu.
Table 2-31 Lookup Code
| Process Type | Lookup Code | Description |
|---|---|---|
| Transaction File Upload | ITU | TRANSACTION UPLOAD |
| Asset File Upload | ICC | INPUT CREATE COLLATERAL |
- For Transaction File Upload, only one csv file can be created with multiple records and on processing, the data is populated into Servicing > Customer Service > Transaction > History > Transactions tab.
- For Asset File Upload, separate csv files are to be created to upload the data into Collateral Management screen’s Collateral details, Valuation, Addons/Attributes, and Tracking sections respectively.
On executing the scheduled batch job in SET-IFP, IDDPRC_BJ_000_02 (BULK INPUT DATA INSERTION), the data in csv file is processed and is displayed in Servicing Customer Service > External Interfaces tab. Such data does not need authorization and is directly uploaded on validating the sequence, position, and format.
The status of batch job can be viewed in DashBoard > System Monitor > Batch Jobs screen. The records which resulted in error are listed in the bad file.
Parent topic: Input tab