How can I import time entries into Gryzzly?
Please note: you must have the administrator role to access this section.
To access the imports, go to the administration > import page to import your data. Choose the Leaves section. You can import your data with a .csv or .xslx file !
👉 Important: The accepted column separator is the comma [ , ] and the character format is UTF8. For decimals on numbers, use [ . ].
Structuring your import file
You will find an example of the structure to adopt at the bottom of your import page:
Please note: you must respect the names of the columns and the order of the columns so that we can take them into account. The columns with red asterisks [ * ] are mandatory columns for the import. Furthermore, the dates must be in the following format: Year-Month-Day (2023-02-22).
The [description] object is the comment you'd like to import.
The [description] object is optional.
The [date] object must be in this format: Year-Month-Day, with dashes.
The objects must appear in the same order as they appear in the documentation, i.e. :
[email]: the email address of the user.
[start at]: the day when the leave begins
[start type]: the time of day when the leave begins ("am: morning" "pm: afternoon" "full: all day")
[end at]: the day when the leave ends
[end type]: the time of day when the leave ends ("am : matin" "pm : après-midi" "full : toute la journée")
[description]: a non mandatory comment
👉 Once your file is ready to be imported, upload it in .XLSX or .CSV format and enter it in the file part of the page and click Import. ✅
In case of an import error
If the import fails, you will be notified of known errors in your file. We will give you the line number where your error occurs, the type of error, and further information.
Several errors may appear, and you will have to correct them before trying to import your file again:
[missing_value]: for one of your columns, one of the mandatory fields is not filled in.
[invalid_header]: for one of your columns, the format is not the right one (for example: wrong date format).
[invalid_value]: for one of your columns, the format is correct, but the data is not recognized (user email does not exist for example).
[missing_header]: In your file, a mandatory column is not filled in.