Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

If you need to capture costs from devices like photocopy machines of phone systems you can import the data from CSV files.

The process is fairly straight forward:

  1. Create a "Disbursement Import Specification" to map the fields in the CSV file to the associated Actionstep fields
  2. Import CSV files and select the appropriate import specification

Creating Import Specifications

Go to Admin > Timekeeping > Disbursement Import Specs and create a new specification (see screenshot).

Fields

FieldDescription
Specification NameSomething to identify the spec in a list e.g. "Xerox 2105"
Use TemplateIf you select an existing disbursement template the imported will use those values as defaults and save you having to include these in the import file. If you specify a template then the only mandatory fields in the file are Disbursement Date and Quantity
Date FormatAlways use a 4-digit date and either "-" or "/" as delimiters. So for DMY you could specify 23-02-2015 or 23/02/2015
List PositionIf you have more than one Import Specification then this will govern the order they will display on lists when selecting them
Total Header RowsHow many rows before the data rows
Total Footer RowsHow many rows after the data rows
[[Action Alias]] IDAction ID (note that depending on your alias settings this may display as Matter ID or Project ID, etc). This will be the action the disbursement will be posted to
External ReferenceOptional unique identifier for each row set by the source (e.g. the reference ID from the photocopier)
Disbursement DateDate the disbursement was created (see Date Format above)
Associated User IDThe Actionstep user doing the import

 

 

 

  • No labels