IMPORTING INVENTORY- BISAC FILES

Inventory records in BISAC format may be imported.

The line that must be entered in the MLE box is:

INVENTORY,keyword-1,keyword-2,keyword-3,…

Where keyword may be entered in any sequence and may be any of the following codes:

LOCN=nn or LOCATION=nn where nn is the Location code that is going to be used when the Item is registered to the current shop. This parameter is mandatory.

SUPPLIER=mm or SUPPL=mm where mm is the Supplier code to be assigned to all inventory records. This parameter is mandatory.

IGNOREDUP If this parameter is present, then all input data will be ignored if a match is found i.e. if the Item is already on file, then the input record will be ignored.

Note that the keywords are not case sensitive.

The records in this file are fixed in length i.e. the fields are not delimited.

In addition, the first and last records on the input file are ignored.

The fields in the input record are defined below:

FieldActual Length
  
ISBN code10
Ignored5
Title30
Ignored1
Author30
Ignored3
RRP (in cents i.e. no decimal point)7
Ignored1
Publication date (as YYMMDD)6
Ignored1
Publisher Code10
Ignored1
Imprint14
Ignored5
Edition2
Ignored1
Binding2