220.127.116.11.7.2- GAS DELIVERY TABLE ASCII IMPORT – COLES PRICES
USAGE: To import a file containing, all or a subset, of new or changed pricing from Coles. The file location, name and structure are very specific and cannot be changed without modifying the import program. The structure is designed to make it easy to save the pricing table, which is an Excel file.
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 coles.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 import program is expecting a header record, and this will be skipped. Any line that does not start with a number will be skipped. Therefore, any blank lines will be ignored.
When you start the program, the import file will be searched for. If HiFinance cannot locate and open the file, an error will be displayed and you will be returned to the MENU.
Next, you will asked for a date to apply the changed to. This is the CUT-OVER-DATE as seen in the CARRER MAINTENACE screen. The date you enter here must be within the Calendar.
Having entered a valid date, HiFinance will scan the import file and test each line, as far as possible. Typically, invalid site numbers will be rejected. Also, all relevant sub-accounts will be tested for. Any errors will be reported and you will be returned to the MENU. You will then need to correct the file and resave it.
If HiFinance finds no obvious error, you will be asked:
UPDATE THIS BATCH?
You must enter YES to proceed.
HiFinance will rescan the import file, this time updating the pricing file for Coles customers (ie those starting with Debtor code COLES.)
The fields expected are:
Coles Site ID
Freight Price Ex ExxonMobil Altona
Freight Price Ex ExxonMobil LIP
Freight Price Ex Shell Lara
GST Incl Price Ex ExxonMobil LIP
Freight Price Ex LIP to Tasmania
Santos Port Bonython-Mix
xGST Price Ex ExxonMobil Altona
xGST Price Ex ExxonMobil LIP
xGST Price Ex Shell Lara
xGST Price Ex Santos Port Bonython
xGST Price Ex LIP to Tasmania-LIP Mix
Apart from the SITE ID, none of the fields are compulsory, but if there are no prices at all on a line, this will generate an error.