If you have a spreadsheet of your crew members, you can import this into Rentman. 

You can also quickly add a single (or small number) of crew members in the Crew members module.

Available for: Lite Classic Pro

-

Before you start

Here's what you need before importing your crew member list:

  • An Excel or .csv file with your crew members' information. If you don't have this file prepared yet, download a sample file during the importing process: see step 4, on how to import your crew members. Read more on which information can I import in this section. 
  • (Optional) A logical folder structure in the Crew members module, so you can stay organized and find your crew members faster. In your file, the folder path should be specified in the Folder column:
    freelancers/lighttechnician or office/planners

Import your crew member file

  1. Go to the group Crew members module. 
  2. Click on more actions more_vert in the right corner, and click on import.
  3. Select here which type of import you want to do: 

    Import all rows as new item: 
    Rentman creates a new crew member for every row. 

    Update existing items with new data:
     If you want to update the crew members in your database (example: phone number), read how to do it in our article about updating data.

    Add new items and skip duplicate rows: 
    Rentman does not import crew members that are already in your database.
  4. Drag a file or click mceclip2.png to upload a file. 
    If you do not have a file with your crew members available yet, you can download our template above the upload button "Download a sample file here" 
  5. Select if your file contains a header, or not. If you select yes, the first row of your file will not be imported. 
  6. For each column, the system matches the header names with the column names in Rentman. Check if all matches have all been made,  and adjust/add where necessary.
  7. Click "Next step" when you've done this for all columns.
  8. Select a Root folder for your import. The root folder is the folder at the top, and it contains your folder structure. New crew members will be placed under this folder. If you have defined folders in your import file, these crew members will be placed under the chosen Root folder. Warning: If your crew members file doesn't contain a Folder column, all items will be placed in the same root folder. This means that your items will not be organized, and it may be difficult to find your crew. We recommend creating your own folder structure, and specify the correct folder path for your items in the Folder column.
  9. Optional when you selected: Skip duplicate rows. When you choose this option, you need to select which columns in your file Rentman can use to match the crew members in your import file with. Warning: These columns may not contain double values in the import file, as they are used during the import to identify which crew member should be skipped. 
  10. Choose Next step.
  11. Check your data in the preview. 
  12. Choose Import 
  13. View your "import results". If your data has been imported successfully, no further actions are required. If it partially or totally failed, please read the following section on the Import Result

Insight into your Import result

Sometimes it happens that the import might fail (partially or totally). If this happens you can find all your answers in the import result like: 

  • Which rows (crew member) failed. 
  • Why did these rows (crew members) failed. 
  • Which rows (crew members)have been imported successfully.

At the bottom of the import result, you can download a file that contains all rows that failed, accompanied by the reason of failure. This gives you direct insight per row what the reason of failure is. 

Which information can I import?

General
Description, Email, First name, Folder, Last name, Middle name, Phone

Details
Availability, Display in planner, Driving license, Emergency contact, Receive emails

Login information
Username
You cannot import passwords or crew rates.

Administrative
Bank account number, Birthdate, CoC number, Company name, Contract date, Hours in contract, Passport number, Social security number, VAT identification number

Address information
Address, City, Country, Extra address line, House number, Postal code, State/Province

Frequently asked questions

Can I import crew rates and passwords?
No, this is unfortunately not possible.

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.