CSV Import
The import tool is meant for batch creating assets, e.g. for importing a list from a spreadsheet application. Since CSV is a poorly defined "standard" which comes in many different flavors, TradeTrax makes a best effort attempt to parse the input, potentially guessing and auto correcting were needed/possible. Therefore the resulting asset list must be double checked carefully.
The input to the CSV tool should not exceed a few hundred lines. Anything larger should either be split into independent chunks or be entered into the database directly.
In order to make sense of the CSV records, TradeTrax requires that the input data must always start with a column map header. The column map is simply a CSV record that tells the parser which column contains what value. The following column names are supported:
- name
- Always required. Assets cannot be created without at least a name
- variant
- Optional
- actuired
- The date when the asset was acquired. This can either be in SQL timestamp format or the medium date format of your locale (e.g. "dd.mm.yyyy") or left blank.
- units
- Number of units. Optional, defaults to 1.
- cost
- How much acquisition of a single unit did cost. Optional, defaults to 0. May be a fractional value in the locale specific format (e.g. "1,0"). No currency symbol.
- liquidation
- When the asset was liquidated. Same rules as for "acquisition".
- returns
- How much a single unit of the asset was sold for. Same rules as for "cost".
Important: The order of columns may be changed and any column (except "name") may be omitted. There may not be any spaces in the header line.