|
<< Click to Display Table of Contents >> Navigation: Employees > Import employees > Excel import file for employees |
Automatically translated from Dutch. Some wording may be inaccurate.
You can import employees from an Excel file.
The following rules apply:
•Fields are matched using the column names in the first row of the file. The list below shows the names Regelneef recognises. Matching is not case-sensitive.
•The order of the columns does not matter.
•The file does not have to contain every column in the list.
•The file must contain at least the Achternaam field.
•The first worksheet is read. To use a different worksheet, name that worksheet 'regelneef'.
•Boolean (yes/no) fields: yes = 'J', no = 'N' or empty
After reading the file, Regelneef reports any columns that could not be matched. This prevents a column from being silently omitted because of a spelling error in its name. You can ignore the message if those columns are not intended for import.
Supported import column names for employees
BSN
Personeelsnr
Filiaal
Roepnaam
Geslacht
Voorletters
Tussenvoegsel
Achternaam
Straat
Huisnr
Toev
Postcode
Plaats
Land
StraatAfw
HuisnrAfw
ToevAfw
PostcodeAfw
PlaatsAfw
LandAfw
Nationaliteit
Inschrijfdatum
Geboortedatum
Geboorteplaats
Geboorteland
Telefoon1
Telefoon2
Telefoon3
IDnr
IDGeldig
VerblijfsvergunningNr
VerblijfsvergunningGeldig
RijbewijsNr
RijbewijsGeldig
Rijbewijs_A
Rijbewijs_B
Rijbewijs_BE
Rijbewijs_C
Rijbewijs_CE
Rijbewijs_D
Rijbewijs_DE
Rijbewijs_T
Eigenvervoer
ZorgVerzekeraar
ZorgPolisNr
Brutoloon
Bemiddelaar
Uitlener
Functie
Functie2
Functie3
Functie4
Functie5
Niveau
Waarschuwen
IBAN
BIC
BetalingNaam
BetalingPlaats
Contact
Certificate name followed by ' nr' (multiple columns are possible; see below)
Certificate name followed by ' geldigtot' (likewise)
Importing certificate details
To import an employee's certificate number and/or expiry date, the columns must have specific names. Use the exact certificate name (description), followed by ' nr' or ' geldigtot'. For example, if the table contains a VVA-1 certificate and you want to import its number and date, provide these two columns:
•VVA-1 nr
•VVA-1 geldigtot
You can supply extra Excel columns in this way for each certificate. Regelneef reports any unrecognised code when reading the file.