CSV import / export
Import
Rows are matched on their natural key and updated or created; a file with any bad row is rejected as a whole. Periods are created from the period column. Import in the order listed below.
Datasets
| Dataset | Columns | Export |
|---|---|---|
| departments | name, kind | departments.csv |
| pools | period, account, department, amount | pools.csv |
| service | from_department, to_department, percent | service.csv |
| activities | name, department, target, driver, method, unit_time_min, capacity_minutes, practical_pct | activities.csv |
| drivers | department, activity, weight | drivers.csv |
| cost_objects | kind, code, name, channel | cost_objects.csv |
| consumption | period, activity, code, quantity | consumption.csv |
| sales | period, product, customer, quantity, revenue, direct_cost, labor_hours | sales.csv |