YHiFinance 5


 

SECTION 1.5.4.4.2 - UPDATE EXISTING TAXI CARDS ASCII IMPORT

 

USAGE: To import a file containing, all or a subset, of changed information to be posted to the Taxi master-file. The input file is required to be in a very strictly stylised format so that HiFinance can allocate data to the correct fields on the correct Taxi records. This function is only relevant for specific sites.

 

DISCUSSION: Make sure that you have a good backup of your data and that no-one is using HiFinance during the update. HiFinance may not update the files as you expected and the only completely safe way to correct the mistake is to restore your data from backup.

 

The import file required must be called taximf.csv, although case is not important in Windows. This file must reside in your data directory, eg \HF5DATA\COMP1. Also, the file must not be in use. This is important because if you have created the file from a spreadsheet and have saved it but not closed it, the file will still be locked by the spreadsheet program and HiFinance will not be able to open it.

 

The input file must be in CSV format. This is a comma-delimited file (without quotes) with one record per line. Exporting from Excel, choosing the CVS format, will produce the correct format automatically. Each alphanumeric field must be left justified. HiFinance will make no attempt to remove leading spaces (for names, etc.). Numeric fields should not have any dollar signs or commas. Do not use commas in any alpha fields. These will be treated as a field break and HiFinance will not import the row correctly. A blank cell will be treated as a valid entry, thus a blank alpha cell will clear the corresponding field in the master-file and a blank numeric cell will reset the corresponding field in the master-file to zero. Thus if you do not wish to change a field, either delete the row, delete the column or make sure that the cell contains the same information as the field in the master-file currently has.

 

The first line of the input file must contain only field names. These fields are mostly identical to those exported using TAXI CARDS ASCII EXPORT (see SECTION 1.5.3.7U.1). In fact the easiest way to create the initial file is to export it first using this program with the headings option turned on. This also has the advantage of accurately exporting the current information. There are some fields available in the Import program that are not created in the Export program. The full list is detailed below. Note the use of the underscore character instead of spaces. This format must be copied exactly.

 

CARD_NUMBER

DRIVER_REGO

LICENCE_NUMBER

ACTIVE_FLAG

AVAILABLE_FROM

AVAILABLE_TO

FIRST_NAME

LAST_NAME

SALUTATION

GENDER,DATE-OF-BIRTH

TRADING_NAME

ABN

ADDRESS_LINE_1

ADDRESS_LINE_2

ADDRESS_LINE_3

POSTCODE

WORK_PHONE

HOME_PHONE

FAX_PHONE

MOBILE_PHONE

EMAIL

OTHER_KEY1

OTHER_KEY2

OTHER_KEY3

PLUS_ALLOWED

PLUS_DISCOUNT

ULP_ALLOWED

ULP_DISCOUNT

DIS_ALLOWED

DIS_DISCOUNT

LPG_ALLOWED

LPG_DISCOUNT

PREMIUM_ULP_ALLOWED

PREMIUM_ULP_DISCOUNT

PREMIUM_100_ALLOWED

PREMIUM_100_DISCOUNT

E85_ALLOWED

E85_DISCOUNT

ADBLUE_ALLOWED

ADBLUE_DISCOUNT

PREDIS_ALLOWED

PREDIS_DISCOUNT

NOTES_P1

NOTES_P2

NOTES_P3

NOTES_P4

NOTES_P5

NOTES_P6

NOTES_P7

NOTES_P8

NOTES_P9

NOTES_P10

NOTES_P11

NOTES_P12

NOTES_P13

NOTES_P14

NOTES_P15

NOTES_P16

NOTES_P17

NOTES_P18

NOTES_P19

NOTES_P20

EXCEPTION_1

EXCEPTION_2

EXCEPTION_3

EXCEPTION_4

EXCEPTION_5

EXCEPTION_6

EXCEPTION_7

AVAILABLE_FROM

AVAILABLE_TO

 

Notes:

1)              The order of the columns is not important but they must not appear more than once.

2)              CARD_NUMBER must appear, as it is used to link the row to the Card Code as it currently exists on the Taxi master-file.

3)              Apart from CARD_NUMBER, you must have at least one more column.

4)              OTHER_KEYís are replaced by whatever you have defined it as in SYSTEM DEFAULTS.

5)              Some fields are only relevant to specific installations.

6)              If you try to import the raw file form the ASCII EXPORT program, it will not read in successfully unless you choose to export with comma delimiters between fields and without quotes around fields (numeric and alphanumeric). This can be set in the options part of the export program. Normally this is not the way this function is used, the purpose of this function being to manipulate the file in a spreadsheet program and importing the result.

7)              Most fields are not verified on import. You must enter valid information. For the field that are validated, invalid data will be ignored.

 

When the program starts, it will firstly check whether the import file exists and is accessible. Having established this, HiFinance will read the first line of the file and check for its correctness. If no obvious errors are found, you will be asked to confirm that you have made a backup and then you will be asked to confirm that you wish to proceed.

 

HiFinance will then read import lines one at a time confirming firstly that the CARD_NUMBER field corresponds to a Taxi Card code and then replacing the fields and records, as defined by the columns you have chosen. If an invalid or blank row is encountered, it will be skipped. HiFinance will continue processing until it reaches the end of the import file. Finally the import file will be renamed to taximf.old (to stop you from accidentally rerunning the program with used data) before returning you the MAIN MENU.

Description: Return to Table of ContentsReturn to Table of Contents