Personnel Export & Import Files

When first entering information into Personnel Budgeting, it is often easier to use the export and import process to load large amounts of data at once.

There are three types of imports within Personnel Budgeting:

• Pay Data File - This is the most comprehensive file and allows for importing of all information within Personnel except for Allocations. The best use of this file is for adding employees and positions.
• Pay Item Grid - This is the best file to import the compensation for positions.
• Allocation File - This is the only way to import allocations and is usually used when an organization has a lot of allocations.

Note: It is imperative that an organization utilize the export from within their system in order for the import process to work as expected. Do not try to create a file for import from the documentation in this section.

Import notes

• The Excel tab names should not be changed.
• The Excel header row names should not be changed.
• For multi-tabbed files, you can remove unneeded tabs and import only the desired tabs.
• Imports only update or add information; they will never remove positions, employees, allocations, pay items or any other data within Personnel Budgeting. 
• All imports will be queued in the background; utilize the Dashboard > Updater page to ensure they have been completed successfully.
• Do not re-order the tabs. The Import process will work from left to right through the tabs in the worksheet. Some tabs are dependent on others; for example, please make sure that the Employees tab is to the left of Positions as the Positions tab requires the Employees to be imported.
• Excel formulas in fields that are to be imported will be replaced with the cell value. However, best practice is to copy and paste as values if needed. NOTE: ID fields and Date fields do not support formulas.
• All Martus file imports have a limit of 15MB.

If you experience errors when uploading files,  please create a ticket through the Knowledge Base if you are a direct Martus customer, or contact your Martus reseller if you are supported through one of our Martus partners.