Jobs Data Import
- 9 Minutes to read
- Print
- DarkLight
- PDF
Jobs Data Import
- 9 Minutes to read
- Print
- DarkLight
- PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
Important
This can only be done by an Admin.
Manatal allows the mass creation of jobs through the import of CSV or JSON files. This can be particularly useful when performing a data migration to Manatal for example.
Important
When importing jobs, an "Organization" name (Client/Department) must be attached to each job to define to which Organization each job should be attached too. Note that Manatal is case insensitive when looking at organization names.
During the import, for each job:
- if Manatal finds exactly one existing organization with the same name, it will attach the job to it.
- if Manatal finds several existing organizations under your account with the same name, the import will fail and the user will need to correct any errors.
- if Manatal doesn't find any existing organization under your account with the same name, the import will fail and the user will need to correct any errors.
Import your Jobs
- Head to the following page. Alternatively, click on "Administration" from your side menu, open the "Data Management" category and then the "Data Import" category then click on "Upload file".
Select the Jobs data set and click "Next".
Select the file type and click "Next". For a CSV file, continue reading below, for a JSON file follow these instructions.
CSV File
- Select a file to upload, click "Next" and then "Upload". Manatal will analyze the file and extract all the information it contains.
- Map your file's columns according to Manatal's fields.
Important
- Fields marked with a red asterisk in the "Field Name" dropdown menu are required in order to proceed.
- Any column mapped to a required field must not contain any blank cells otherwise the import will not succeed.
Info
Unmapped columns will not be imported to the platform.
- 1. Column Name: Content of the first cell of each column in your CSV file. If the cell has no content, the column name will be "Unnamed: n", where n refers to the column's number.
- 2. Field Name: Name of the field in Manatal. Match the field name with the relevant column (i.e. match the "Website" column with the "Organization Website" field).
- 3. Field Type: Data type as required by Manatal. Ensure the data contained in each column meets the requirements of each field. Data will fail to be imported to Manatal if it doesn't meet the data type's constraints. Learn more about field type constraints in the table below.
- 4. Sample Data: Sample data extracted from each columns. Can be used to confirm the column's data corresponds to the Manatal field.
To match a column with a field, simply click on "Select field to map to" next to the column's name, and select the relevant field from the dropdown menu.
Below are all the default Manatal fields that can be mapped and their respective requirements.
Info
The word "Organization" in the table below refers to either Clients or Departments depending on whether your Manatal account is in the Agency or Company mode.
Important
If you are planning on importing Matches at a later stage, Manatal will require a Job Source ID in order to connect the right job to the right match. It is recommended to assign this value to jobs during the job data import using the Job Source ID field. Refer to this article for more information on matches, and to this article for importing matches.
| Field Name | Required | Field Type | Constraints |
|---|---|---|---|
| Job Name | Yes | Text | ≤ 255 char. |
| Job Source ID | No | Whole Number | |
| Job Organization | Yes | Text | Must match the name of an existing Organization |
| Job Description | No | Long text | |
| Job Creator | No | Email Address | Must be an existing user |
| Job Owner | No | Email Address | Must be an existing user |
| Country | No | Text | ≤ 255 char. |
| City | No | Text | ≤ 255 char. |
| Office Address | No | Text | ≤ 255 char. |
| Job Status | No | Text | Either "active", "on_hold", "won" or "lost" |
| Open Date | No | Date and Time | Format must be YYYY-MM-DDThh:mm:ssZ |
| Close Date | No | Date and Time | Format must be YYYY-MM-DDThh:mm:ssZ |
| Minimum Salary | No | Whole Number | ≥ 0 |
| Maximum Salary | No | Whole Number | ≥ 0 |
| Currency | No | ISO Currency Code | Must be 3 char. currency code |
| Package Details | No | Long text | |
| Contract Details | No | Contract Type | Either "full_time", "part_time", "temporary", "freelance", "internship", "apprenticeship", "contractor", or "consultancy" |
| Remote | No | Boolean | "true" or "false" |
| Experience Level | No | Experience Level | Either "junior", "middle" or "senior" |
| Job Tags | No | List of Text | Only available via JSON import. See below for more details. |
| Notes | No | Notes | Only available via JSON import. See below for more details. |
Important
All time fields imported will be considered in the UTC timezone.
- If your file contains data that doesn't have its default Manatal field, it is possible to create "custom fields" by following these instructions. Once created, custom fields become visible in the "Field Name" dropdown menu and can be mapped to columns.
Custom fields in Manatal can be create using a wide range of type of fields (number, date, text, multiple choice,...). Below are all the type of fields available and their respective requirements for a successful import.
| Field Type | Format | Constraints |
|---|---|---|
| Text | Text | ≤ 255 char. |
| Long Text | Long text | |
| Date | Date | Format must be YYYY-MM-DD |
| Number | Decimal Number | ≥ 0 |
| Percentage | Whole Number | ≥ 0 |
| Boolean | Boolean | true / false |
| Dropdown | Text | Must be among choice list |
| Multiple Choice | Text | Must be among choice list |
| Multiple Select Dropdown | List of Text | Only available via JSON import. See below for more details. |
| Checkbox | List of Text | Only available via JSON import. See below for more details. |
Once you have mapped all the columns that need to be imported, click "Next".
Select whether you want to be notified via email once the import is complete then click "Upload".
From here you can resume your work as usual, your file will be processed in the background. To check the import's status, please visit the Data Import History page.
JSON File
- Select a file to upload, click "Next" and then "Upload". Manatal will analyze the file and extract all the information it contains.
- Map your file's columns according to Manatal's fields.
Important
Fields marked with a red asterisk in the "Field Name" dropdown menu are required in order to proceed.
Info
Unmapped columns will not be imported to the platform.
- 1. Column Name: All the variables contained in your JSON file.
- 2. Field Name: Name of the field in Manatal. Match the field name with the relevant column (i.e. match the "website" column with the "Organization Website" field).
- 3. Field Type: Data type as required by Manatal. Ensure the data contained in each column meets the requirements of each field. Data will fail to be imported to Manatal if it doesn't meet the data type's constraints. Learn more about field type constraints in the table below.
- 4. Sample Data: Sample data extracted for each column. Can be used to confirm the column's data corresponds to the Manatal field.
To match a column with a field, simply click on "Select field to map to" next to the column's name, and select the relevant field from the dropdown menu.
Below are all the default Manatal fields that can be mapped and their respective requirements.
Info
The word "Organization" in the table below refers to either Clients or Departments depending on whether your Manatal account is in the Agency or Company mode.
Important
If you are planning on importing Matches at a later stage, Manatal will require a Job Source ID in order to connect the right job to the right match. It is recommended to assign this value to jobs during the job data import using the Job Source ID field. Refer to this article for more information on matches, and to this article for importing matches.
| Field Name | Required | Field Type | Constraints |
|---|---|---|---|
| Job Name | Yes | Text | ≤ 255 char. |
| Job Source ID | No | Whole Number | |
| Job Organization | Yes | Text | Must match the name of an existing Organization |
| Job Description | No | Long text | |
| Job Creator | No | Email Address | Must be an existing user |
| Job Owner | No | Email Address | Must be an existing user |
| Country | No | Text | ≤ 255 char. |
| City | No | Text | ≤ 255 char. |
| Office Address | No | Text | ≤ 255 char. |
| Job Status | No | Text | Either "active", "on_hold", "won" or "lost" |
| Open Date | No | Date and Time | Format must be YYYY-MM-DDThh:mm:ssZ |
| Close Date | No | Date and Time | Format must be YYYY-MM-DDThh:mm:ssZ |
| Minimum Salary | No | Whole Number | ≥ 0 |
| Maximum Salary | No | Whole Number | ≥ 0 |
| Currency | No | ISO Currency Code | Must be 3 char. currency code |
| Package Details | No | Long text | |
| Contract Details | No | Contract Type | Either "full_time", "part_time", "temporary", "freelance", "internship", "apprenticeship", "contractor", or "consultancy" |
| Remote | No | Boolean | "true" or "false" |
| Experience Level | No | Experience Level | Either "junior", "middle" or "senior" |
| Job Tags | No | List of Text | Each item must be unique and ≤ 255 char. |
| Notes | No | Notes | See more details below |
Important
All time fields imported will be considered in the UTC timezone.
Notes
Below are the requirements for the notes type field and a code snippet.
| Data Point | Required | Type | Constraints |
|---|---|---|---|
| content | Yes | Text | |
| created_at | No | Date and Time | Format must be YYYY-MM-DDThh:mm:ssZ |
| creator | No | Email Address | Must be an existing user |
Important
All time fields imported will be considered in the UTC timezone.
Code snippet:
[
{
"content": "reassess recruitment needs early Q2"
},
{
"content": "Reassess recruitment needs early Q2",
"creator": "joseph.staline@testy.com",
"created_at": "2010-09-15",
},
]
JSON File Example
[
{
"id":30001,
"position_name":"Executive Sous Chef",
"organization_name":"Everland Suite Hotel",
"description":"Resposible for all kitchen including: Cuisine, Pastry, and Bekery",
"creator":"jane.doe@example.com",
"owner":"john.doe@example.com",
"country":"France",
"city":"Bordeaux",
"address":"7 Permanent Snow Avenue",
"status":"on_hold",
"open_at":"2020-10-01",
"close_at":"2021-02-28",
"salary_min":8000,
"salary_max":9000,
"currency":"EUR",
"package":"Insurance, Paid Holiday",
"contract_details":"full_time",
"is_remote":true,
"seniority":"senior",
"tags":[
"Highest Priority",
"Confidential",
"Urgent"
],
"note":[
{
"content":"The first round interview will be held online",
"creator":"jane.doe@example.com",
"created_at":"2021-01-16"
},
{
"content":"Technical interview needed"
}
]
},
{
"id":30002,
"position_name":"Customer Support",
"organization_name":"Starporium",
"description":"Night Shift",
"creator":"jane.doe@example.com",
"owner":"john.doe@example.com",
"country":"Germany",
"city":"Frankfurt am Main",
"address":"7 Permanent Snow Avenue",
"status":"won",
"open_at":"2019-12-20",
"close_at":"2020-09-09",
"salary_min":2500,
"salary_max":3000,
"currency":"EUR",
"package":"Insurance, Paid Holiday",
"contract_details":"part_time",
"is_remote":false,
"seniority":"junior",
"tags":[
"Lowest Priority",
"Not Important"
],
"note":[
{
"content":"The candidate profiles are submitted to the manager",
"creator":"jane.doe@example.com",
"created_at":"2020-05-12"
},
{
"content":"Many interesting candidates."
}
]
}
]
- If your files contains data that doesn't have its default Manatal field, it is possible to create "custom fields" by following these instructions. Once created, custom fields become visible in the "Field Name" dropdown menu and can be mapped to columns.
Custom fields in Manatal can be create using a wide range of type of fields (number, date, text, multiple choice,...). Below are all the type of fields available and their respective requirements for a successful import.
| Field Type | Format | Constraints |
|---|---|---|
| Text | Text | ≤ 255 char. |
| Long Text | Long text | |
| Date | Date | Format must be YYYY-MM-DD |
| Number | Decimal Number | ≥ 0 |
| Percentage | Whole Number | ≥ 0 |
| Boolean | Boolean | true / false |
| Dropdown | Text | Must be among choice list |
| Multiple Choice | Text | Must be among choice list |
| Multiple Select Dropdown | List of Text | Must be among choice list |
| Checkbox | List of Text | Must be among choice list |
Once you have mapped all the columns that need to be imported, click "Next".
Select whether you want to be notified via email once the import is complete then click "Upload".
From here you can resume your work as usual, your file will be processed in the background. To check the import's status, please visit the Data Import History page.
Was this article helpful?