EXPEDIENT SOFTWARE

Going beyond software performance.

Creating Parts – File Load

If you have a Parts File, you can upload this file via menu via Sundry > Down Load Data Files > Load Parts File (AU) or via Down Load Data Files > Load Parts File (NZ).  

This option is also available from the Supplier Invoice and Pre-Job Supplier Invoice Options menu.

The format for the CSV file is configured in this screen.

Select the pre-existing template for the load file or create a new template. The templates must include all the mandatory columns, which are indicated with a ‘*’ in the name.

The columns can be in any order. The file does not require column headings in the first row.

Once loaded the Import Log will display a summary of the details loaded. Use to see more in depth information.

 

Field Name

Description

Validation

Default

Data File Location

User the Browse button to locate the file in your system

Mandatory

Blank

Column No

This indicates where the column is found in the file. Select from the pull down list.

Mandatory

Blank

Field

This is the information contained in the column. Select a column from the pull down list. ‘*’ indicates that the column must be included in the file template.

Mandatory

Blank

Templates

This is the list of available templates. If you want to set up a new template enter the name of the new template in the field below and . Use to remove unwanted templates.

Mandatory

Default

Updated: March 23, 2016 — 2:15 am
EXPEDIENT SOFTWARE GUIDE © 2015