The purpose of this article is to guide the process of smoothly importing employee, location and client data into PARiM.
Important factors to consider
Before importing, you need to make sure that the data is formatted correctly and consistently.
Consistent Dates
Here is a list of formats that the PARiM system accepts from your datasheet. Please ensure you use one of the formats listed below and that it is consistent throughout the document:
yyyy-mm-dd
yyyy.mm.dd
yyyy/mm/dd
dd.mm.yyyy
dd/mm/yyyy
mm-dd-yyyy
mm.dd.yyyy
mm/dd/yyyy
Once the data from the Date column is within the PARiM system it will be presented in one of the formats marked in bold above. The exact format depends on your settings within System Settings -> Company Settings -> General -> Date Format as shown below:
Email addresses
Please check that all email addresses are in the correct format without any extra symbols, such as: "," or "/" or "%" or "&".
An email address is mandatory when adding a new employee. If your employee does not have an email address, you can use dummy email addresses, for example - 1noemail@companyname.co.uk where the number will change.
Phone numbers
The phone number field should not contain any letters. The system will not see 00, therefore please use + instead.
Try to use a unified approach across your documents. Setting up phone numbers in a unified format will help you to avoid any discrepancies at a later stage.
For example:
all + country code and the number
all straight to number.
Empty fields
Try to avoid leaving any fields empty. You can enter "-" when you don't have the data.
Mandatory fields (*)
All Mandatory fields are marked with a * and have blue borders in the document templates. If mandatory fields are empty, you can't import the data.
Registration Number (Clients)
This field does not accept letters.
Helpful notes
There are notes within each template document for entering data. Before proceeding with the import, please delete those rows as these are not needed for the import.
This is an example of the template with the notes:
And this is how it should look when you are about to start importing the data:
Step 1 - Fill in the data
Please note that some data fields such as "Department" one can only be used if the appropriate features are included in your PARiM subscription plan.
Please open the Excel templates that you received via email or use the links below:
These documents contain all of the data fields that can be imported into PARiM.
Please fill them in and then save them on your computer.
Here is a list of data that can be imported:
PEOPLE/EMPLOYEES
* - mandatory fields
Basic Information | Address | Contract | Passport/ID Card | VISA | Additional Information |
Email* Full name* First Name* Last Name* Gender Title Date of Birth City Of Birth Country Of Birth Nationality NI no Tax Certificate Department Mobile Second Phone | Country City/Town* Street Address* House No Street No Street Name Postcode Development Name County | Contract No Contract Start Contract End Employment Type | Document Number Issuing Country Expiry Date Date of Issue | Visa Expiry Date Visa Description* | Drivers License Access to Car |
CLIENT
* - mandatory fields
Basic Information | Address | Contact Person |
Client Name* Phone Email* Reg No VAT no Website ID | Address Postcode City/town Country | Name Phone Job Title Title |
LOCATIONS
* - mandatory fields
Location Name* Location ID City* County or State Country Address Postcode Department* |
Step 2 - Save the document as a CSV file
Steps for Mac:
Path: File -> Export To -> CSV
Click Next
First double-check the naming (you may want to include “CSV” in the document title for quicker finding it). And then the place where you save the document and click Export.
Steps for Windows:
To save a document as a CSV file, please open the document, click on File, select Save as and then in the format drop-down list select the CSV format:
You may want to include the “CSV” in the title for a quick view and change the folder for saving it if needed:
Step 3 - Import the data
Here are the instructions on how to import Employees, Locations and Clients data in PARiM once the CSV file is prepared.
EMPLOYEES
Open PARiM and follow the path below:
People -> Employees -> Add a person -> Import from file -> Select a .csv file -> select the file you saved.
Drag and drop fields from left to the right to match:
During matching date fields, the system will ask you to select one of the formats it supports (covered earlier in this document).
This is the format that you have in your document.
Please ensure you select the same format each time for consistency in your data later on.
If by mistake you clicked on a field, it will turn into orange color. To cancel this, click on the field again and it will show you a red cross on the right side, click it to reset the field.
Once you complete matching fields, please click on the Preview button:
This will show you a page with the page summary, where all fields that do not match the formatting are highlighted. To correct these, please click on each line as shown below:
It will open the record with all fields where correction is needed marked in red.
Please correct as necessary:
The corrected version is below as an example. Then click Apply:
Once you are done with the review, click Finish. If you wish to ignore all errors, please tick the box below the Finish button and then click Finish:
Now you will be brought to a screen where you can select what you wish to do next.
Click on it and proceed:
LOCATIONS
Within PARiM follow the path below:
Locations -> Locations -> Import -> select CSV file you just saved.
Once you matched them all, click on Preview.
Should there be any errors, these will be listed in the yellow box. Adjust information as it was shown in the previous people section.
Once you are happy with everything, click Finish. As before, should you wish to skip any error, please tick the box and click Finish.
Now you can select what you wish to do next and proceed with it:
CLIENTS
Within PARiM follow the path below:
Locations -> Clients -> Import -> select the csv file you saved
Once you are ready with matching the fields, click Preview.
As before, any errors will be listed in the yellow box and to fix those just click on the lines as shown in the people section. Once the data is fixed, click Finish. Should you wish to ignore any errors, just tick the box below the Finish button and then click Finish.
If you have any follow-up questions after reviewing the guide, write to us via the chat bubble or send an email to support@parim.co.uk