Need to import time entries into Gryzzly? Let's find out how it works! 💥
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 declarations 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 of times. Furthermore, the dates must be in the following format: Year-Month-Day (2023-02-22).
Each time must correspond to a project and a task.
The [description] object corresponds to the comments you wish to import.
The [description] and [subtask] objects are optional.
The [date] object must be in this format: Year-Month-Day, with dashes.
The objects must be in the same order as they appear in the documentation:
[email]: the email address of the person who entered the time.
[date]: the date to which the time entry corresponds.
[description]: the comment corresponding to the time to be imported.
[duration]: the time to be imported in hours.
[project]: the exact name of the project to be attached.
[subtask]: the exact name of the subtask to attach.
[task] : the exact name of the task to attach.
👉 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 (project does not exist for example or user email).
[missing_header]: In your file, a mandatory column is not filled in.