Export/import file description

Export and import files can be delimited text files or Excel spreadsheets. For delimited text files, you can use any character as a delimiter. When imported, the data is stored in four different tables:

• Employees
• Event_Base
• Employees_X_GlobalEvents
• Asset_Base

The Employees table stores the employee names and IDs.

The Event or Event_Base table stores the details about employee salaries, increases, bonuses, etc.

The Asset or Asset_Base table stores all the details about assets.

The Employees_X_Global Events table stores data for the employees with global events.

Each import file requires these header lines. Existing import files that do not have these header lines can be manually updated to include the header lines.

[Detail Budgeting]
Version=<member name>
Columns=<col 1>,<col 2>,<col 3>, …

The Version parameter value can also be Multiple, which means that multiple versions are included in the file. The Columns parameter values represent a list of the fields in the import file.