File Format
The input data file should be a CSV-formatted text file. A comma (“,”) will be used to separate each column. A carriage-return+line-feed character combination will be used to terminate each row. If a carriage-return+line-feed character combination must be included as part of the data of a single column, the column’s data should be enclosed in double-quotes. The same is true if a comma must be included as part of the data of a column. If a double-quote character must be included as part of the data of a column, then it should be “escaped” by being immediately proceeded by another double-quote character. (e.g. "Hello world" would be encoded as ""Hello World"" if the double-quotes were required as part of the value for a field.)
High-Level File Structure
The file will consist of one header row for the voucher data elements. Ffollowed by one or more data rows. The header rows explicitly state which fields will be updated.
Immediately following the header rows there should be one or more data rows. Each data row shall contain the necessary command, key and data values needed to import one row of data into the database table.
Header Row Details
The first non-blank row in the import file shall be interpreted as the header rows. The header rows shall be used to define which fields will be imported for the voucher . There are 7 fields in the header: VoucherID, Voucher Status Name, Wire Number, Wire Date, Check Number, Check Date, Note.
Data Row Details
Following the header row are one or more data rows. All subsequent columns, should contain data (or be blank when appropriate). The field order should exactly match the field order specified in the header row, as should the field count. Each data row for the voucher shall contain seven mandatory columns:
VoucherID - You will want to enter the VoucherID for the voucher you are updating.
Voucher Status Name – Supply a value from the NAME column of the VOUCHER_STATUS table such as APPROVED, PAID, assigning the status will follow the same transition rules as the manual entry screen.
Wire Number – Specify the Wire Number if one is available. (This field can be left blank)
Wire Date – Specify the Wire Date if one is available. (This field can be left blank)
Check Number – Specify the Check Number if one is available. (This field can be left blank)
Check Date – Specify the Check Date if one is available. (This field can be left blank)
Note – Provide note details if applicable. (This field can be left blank)
Any field which is left blank in the data row will be ignored. Such fields will not be given blank values in the database (they will not be updated at all). If you need the field to be set to “null” in the database, then specify the literal text “<blank>” in the value of the field. In the case of inserts, blank fields and fields that contain the text “<blank>” will both result in null values in the database.