Silverbucket's instructions and documentation has moved to a new address:
https://manual.silverbucket.com
It is possible to import company’s data to Silverbucket. This document describes the data structures of the entities that can be imported.
The import interface reads csv files (data separated by a semicolon, not colon).
There are eight separate csv files:
- Organization
- People
- Projects
- Work records
- Project invoices
- Project expenses
- Project reservations
- User absences
Fields marked with X are mandatory; other fields can be filled if available.
Organization CSV
x | Organization level’s code | Short code for the organization level, visible in Silverbucket |
x | Organization level’s name | The name of the organization level |
x | Code of the parent organization level | Parent level (empty if top level) |
The organization CSV should always contain full export of organization structure. This CSV is optional: if not delivered, the organization should be maintained manually in Silverbucket.
People CSV
x | Person’s unique identifier | E.g. a unique identifier from a backend system (e.g. SAP). It can also be the same as username. |
x | Person’s first name | Person’s first name |
x | Person’s last name | Person’s last name |
x | Person’s username | This is used for login in Silverbucket. Usually it is firstname.lastname |
| Person’s email address | Required, if the person needs access to Silverbucket. |
Code of person’s organization level. | Delivered in organization CSV | |
Cost price | This is used e.g. in cost forecasts. | |
Is external | 0=own personnel (default), 1=external | |
Is active account | 0=Closed, 1=Active (default) | |
Workday’s length | Default 7,5 | |
Employment start date | In ISO format YYYY-MM-DD | |
Employment end date | In ISO format YYYY-MM-DD |
The people CSV should always contain full export of the source system user database.
Projects CSV
x | A unique identifier for a project | E.g. an identifier from a backend system (e.g. SAP). |
x | Project name | Project name in Silverbucket |
A unique identifier for a program | E.g. an identifier from a backend system (e.g. SAP). | |
Program name | A program can contain several projects | |
Customer’s unique identifier | Note! If no id provided, the project will be linked to a customer by customer’s name. | |
x | Customer’s name | Customer name. |
x | Project manager’s username | The username value given in person import. |
Project’s organization level’s code | Delivered in organization CSV | |
Project’s budget in currency (own personnel) | Project budget in currency for own personnel. | |
Project’s budget in currency (externals) | Project budget in currency for externals. | |
Project’s budget in currency (other income) | Project budget in currency for other income. | |
Project invoicing type | 1=Fixed, 2=Time and material, 3=Ceiling | |
Project type | 1=Billable, 2=Internal | |
Project’s hour budget (own personnel) | Project budget in hours for own personnel. | |
Project’s hour budget (externals) | Project budget in hours for own personnel. | |
Is active | 0=Closed, 1=Active (default) | |
Project start date | In ISO format YYYY-MM-DD | |
Project end date | In ISO format YYYY-MM-DD |
The project CSV should always contain full export of the source system project database, but containing only active projects. Closed projects are transferred for a short period (e.g. 1 month) after closing, then left out of the export file.
Work records CSV
x | Project’s unique identifier | Identifier from Projects CSV |
x | Person’s unique identifier | Identifier from Person CSV |
x | The date of the work record | In ISO format YYYY-MM-DD |
The name of the task | If no name is provided, the project name will be used. | |
x | Hours | Actual hours for a task |
Hourly rate | Invoicing hourly rate for the work record. |
The work records CSV should always contain full export of the work records from 60 days in the history.
Project Invoices CSV
x | Project’s unique identifier | E.g. an identifier from a backend system (e.g. SAP). |
x | Invoice number | Invoice number |
x | Invoice date | In ISO format YYYY-MM-DD |
x | Sum of the invoice | Sum excluding VAT |
The project invoices CSV should always contain full export of the source system invoices.
Project Expenses CSV
x | Project’s unique identifier | E.g. an identifier from a backend system (e.g. SAP). |
x | Expense date | In ISO format YYYY-MM-DD |
x | Sum of expense | Sum excluding VAT |
The project expenses CSV should always contain full export of the source system expenses.
Project reservations CSV
x | Project’s unique identifier | E.g. an identifier from a backend system (e.g. SAP). |
x | Person’s unique identifier | Identifier for Person (username, email or name) |
x | Start date | Start date of reservation period in ISO format, e.g. 2016-07-01 |
End date | End date of reservation period in ISO format, e.g. 2016-07-31. If end date is not provided, it’s assumed to be the same as start date. | |
x | Reservations for the time period | Amount of reservations for the person in the project for the time period in percentage. E.g. 50, which means half of the user’s working capacity for the whole July. |
Old reservations for the user in the project for the time period are always deleted before new reservations are imported.
User absences (long) CSV
x | Person’s unique identifier | Identifier for Person (username, email or name) |
x | Start date | Start date of absence period in ISO format, e.g. 2016-01-01 |
x | End date | End date of absence period in ISO format, e.g. 2016-03-31 |
Description | Optional description for the absence. |
ALL absences from the Silverbucket are deleted before any new absences are imported, which means the complete dataset must be provided in each CSV file.