HiFinance
5
7.2.3.3.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
Mobil
Altona-Mix
Mobil
LIP-MIX
Shell
Lara-Mix
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.
