Collaborators

To import an Excel file with collaborators into Beeple, configure your file according to these guidelines. Use the recommended columns and formats below. If needed, request a template from your customer success manager for reference.

General Requirements

Add one line per collaborator to import.
The columns 'First name', 'Last name', and 'Email address' are mandatory; all others are optional.
Rows with missing mandatory data will still upload, but users without full info must complete their profiles on first login.
Mandatory columns: First name, Last name, Email address.

Field Descriptions

Column	Description	Required	Format / Notes
First name	Collaborator’s given name.	Yes	Text
Last name	Collaborator’s family name.	Yes	Text
Beeple ID	Unique Beeple collaborator ID (from consultancy page). Blank = new collaborator, filled = update existing.	No	Text or blank
Email address	Unique and lower-case only; first duplicate email is uploaded.	Yes	Text, lower case only
Nationality	2-letter ISO code (ISO 3166-1).	No	For example, BE, NL
Citizen Service Number	Valid number, may have points or dashes.	No	Alphanumeric
Birth date	Date of birth.	No	dd/mm/yyyy
Country of birth	2-letter ISO code (ISO 3166-1).	No	For example, BE, NL
Mobile number	Valid mobile number; digits only.	No	Numeric
Telephone	Valid phone number; digits only.	No	Numeric
Sex	male' or 'female' (lower case only).	No	male / female
Social statute	Allowed values: student, work_student, working_class, working_class_blue_collar, flexijobs, functionary, retired, early_retired, unemployed, unemployed_waiting_period, career_pause, living_wager, incapacitated, entrepreneur, disabled_entrepreneur	No	Comma-separated values allowed
Contract types	Enum of contract types, separated by comma, no spaces. Permitted: volunteer, interim, freelancer, contractual, intern	No	E.g., interim,freelancer
Default contract type	Primary contract type, same values as above.	No
Departments	Enum of all departments (comma separated, no spaces, exact match as in Beeple).	No	E.g., Sales,HR
Language code	Only: nl, fr, en, de (lower-case).	No
IBAN-number	Valid IBAN number.	No
BIC code	Valid, letters & numbers only. Mandatory for foreign accounts. Automatically filled for Belgian accounts if left empty.	No
Street	Street and house number.	No
Street 2	Extra address info (e.g. bus number).	No
City	City of residence.	No
ZIP code	Postal code.	No
Country	2-letter ISO code (ISO 3166-1).	No	BE,NL,GB,...

Profile Properties: Type and Value Guidelines

Yes/No: Accepts two values per language: Nl (Ja/Nee), En (Yes/No), Fr (Oui/Non), Ge (Ja/Nein).
Multiple choice list: Comma-separated, use values in logged-in language.
1 choice list: One value, as listed in the logged-in language.
Numerical: Numbers only.
Text: Any alphanumeric value.
Date: dd/mm/yyyy (e.g. 29/12/2017).
Time: hh:mm (e.g. 14:02).
Date and time: dd/mm/yyyy hh:mm (e.g. 29/12/2017 14:02).

If required fields are missing, the user will be prompted to complete their profile upon first login.

Click here for an example

Collaborators

When the module 'Import data' is activated, you are able to import collaborator data on the one hand and planning data on the other hand.

Profile Properties: Type and Value Guidelines