Export/import file description
Export/import files are delimited text files. You can use any character as a delimiter, unless it is included in a member name. When imported, the data is stored in these tables:
| Database tables | Stores structure for |
|---|---|
| ADMIN_SPREADMETHODS | Spread methods and weights per period |
| ADMIN_HOURSTYPES | Hour types, descriptions, and units per year |
| ADMIN_EMPTYPES | Employee types, pay types, spread methods, and hour types |
| ADMIN_ASSETTYPES | Asset types, depreciation methods, asset lives, depreciation lag, minimum costs, capitalization rules, total units, spread methods, residual value percents, and additional cost percents |
| VIEWTYPES | View IDs, view types, view names, decimal precision, Totals column, and global views |
| ADMIN_GLOBALEVENTS | Global event IDs, global event names, view IDs, event types, amounts, limits, employee ranges, and calendar basis |
| ADMIN_EVENTTYPES | Event IDs, event types, treatments, allocations, usages, and view ID's |
| VIEWTYPES_X_LINE | View IDs, line IDs, unit IDs, and secondary dimension IDs |
| VIEWFILTERS | Line IDs and filter information |
| ADMIN_GLOBAL | Starting budget period, number of periods to budget, number of periods in a budget cycle, main dimension ID and name, secondary dimension ID and name, period ID, year ID, application name, database name, and version ID |
| SECOND_X_ALLOCATION | Second allocation IDs |
| SECONDALLOCATION | Second allocation IDs, member IDs (member names from import file are mapped into member IDs in database table), and allocation percents |
Each import file requires these header lines (you can manually update existing import files that do not have these header lines to include the header lines). The Columns parameter values represent a list of the fields in the import file.
[<Name of Administrator Table>]
Columns=<col 1>;<col 2>;<col 3>; …