This will show you how to import your agreement data into Martian Logic via an excel spreadsheet
Importing New Agreement Data
To import your agreement data into the agreement section in Martian Logic, create an Award/Agreement name first by clicking on Org Chart > Agreements > Add Agreement.
Enter your agreement name, then click Create
Once that is created, click on the 3 dots on the right of the new agreement and click Add job family.
After providing the Job family details, click on Import.
An example of how it should be formated, as well as an example file has been provided. Click on Download example file.
Open the example file. You will see some examples listed in the format that is required. Start entering your data here.
When all your pay levels are entered. Save the file, and upload it into the Upload file section by clicking Choose file.
The import summary should give you all ticks and a summary of how many rows are found and can be imported. If it is all correct, click on Start import.
You will now get this import in progress screen which will take a few minutes.
When it is done importing, you will get an email to let you know it is complete and you can view it in the Agreements section.
Updating Current Agreement Data
To update current agreement data, simply edit a current job family. Then click import.
Download the example file and add in your data.
Once done, upload the file.
Same as above, make sure you get green check marks. Then click Start Import.
The job family will now have the updated rates that you have imported.