DV Uploads - formatting issues
How to convert an Excel Disbursement Voucher Document to a .csv format.
- Edit the Excel spreadsheet, using Excel..
- Change Campus code(column D) to a text field with the value of 01. (format cells+text). I then hardcode a ’01 in the field.
- Change Due Date(column F) to a format of 99/99/99. (format cells+Date+03/14/01)
- Change Check Total (column G) to a format of 9999.99. (format cells+Number+1234.10)
- Change Invoice Date (column L) to a format of 99/99/99. (format cells+Date+03/14/01)
- Change Line Amount (column T) to a format of 9999.99. (format cells+Number+1234.10)
- Notes, Discount Amount, and Discount Type (columns U,V,W) must exist. Hardcode a single quote in each column.
- Save file as a .csv (comma delimited) format (Save As+Other Formats+CSV (Comma Delimited)).
- To verify that the file looks like it should, open file with WordPad. You will see strings of data, separated by columns. The fourth column will have 01 as the data. The last three columns will have three commas, unless the file is Dining Services. Dining services may have data in the last two columns, since these are the discount fields.
, multiple selections available,
Related content
Disbursement Voucher .csv File Format
Disbursement Voucher .csv File Format
More like this
Disbursement Voucher Unit Test Files
Disbursement Voucher Unit Test Files
More like this
Disbursement Voucher .xml File Format
Disbursement Voucher .xml File Format
More like this
Customer .csv File Format
Customer .csv File Format
More like this
Editing a Class Roster File in Excel
Editing a Class Roster File in Excel
More like this
Disbursement Voucher File Directories
Disbursement Voucher File Directories
More like this