Description |
* Background
** Gasboy Provides a Report Layout Format that has multiple lines and sometime garbage lines from modem communication.
* Requirements
** #1 Header Lines/Blank/Garbage Lines
*** There could be one ore more lines in each file that meet the following scenarios of non-transaction data.
*** Skip all Lines where first 4 characters are are not numeric and Quantity is not numeric.
**** For a good transactions this is a sequential Tran # from 0 to 9999.
*** Skip Header Line where first 4 characters are "TRAN"
** #2 Site# on Separate Line
*** Add new Checkbox Field to Site Indicator - Site# on Header Line Y/N
*** During Import of File
**** Search for Line with Text that starts with "Transactions at site"
***** Occasionally there is multiple lines with "Transactions at site", but the message would always be the same.
***** Gasboy does not support multiple sites in the same import file.
**** Use Field Mapping to capture the Site # position from this line.
**** Check that Site # matches on first line to the site selected on Import Screen
**** If they do not match give error and +do no+t import any transactions.
**** If they do match, proceed with import and assign this site # to all transactions.
** #3 Date Formatting for No Year
*** When there is no Year, on the first couple of days in January we will be importing in transactions for December of the prior year.
*** Add Field Mapping Option for MM/DD
*** During Import if MM = December and System Date = January
**** Then Year = Current System Date Year - 1
**** Else Year = Current System Date Year
** Confirm that Date and Time can be combined from separate fields on mapping into Single Date/Time field (Has done before with Voyager)
** Confirm that Account # and Card can be combined from separate fields mapping into Single Card # Field (Has done before with Voyager)
|