Can someone please share the required date format for the CSV enrollment field? The documentation in Docebo University suggests that the template contains the required format, but I keep getting “Please enter a valid date format string for: active_until” errors.
I also noticed that when I upload my template, the process does not see or recognize my course courses. It doesn’t appear as one of the options to move over to the right. Is there a minimum character requirement for course codes?
Best answer by anne.bucci
Make sure you are mapping course codes and not course IDs to your data fields. Course ID is the internal Docebo field where Course Code is the one you enter when creating a course.
As for the date format, yes it is yyyy-mm-dd hh:mm:ss. If the time is 00:00:00 (midnight) I would suggest making the times 12:00:00 with a simple Replace command. That way if timezones are different, the date would remain the same and not a day prior.
I believe you need to enter them in yyyy-mm-dd but the formatting makes it look differently.
+5This is definitely something that needs some better documentation. I think I got some guidance pdfs from support early on in deployment, but once I had a few configurations good never looked again.
Make sure you are mapping course codes and not course IDs to your data fields. Course ID is the internal Docebo field where Course Code is the one you enter when creating a course.
As for the date format, yes it is yyyy-mm-dd hh:mm:ss. If the time is 00:00:00 (midnight) I would suggest making the times 12:00:00 with a simple Replace command. That way if timezones are different, the date would remain the same and not a day prior.
+5Make sure you are mapping course codes and not course IDs to your data fields. Course ID is the internal Docebo field where Course Code is the one you enter when creating a course.
As for the date format, yes it is yyyy-mm-dd. If the time is 00:00:00 (midnight) I would suggest making the times 12:00:00 with a simple Replace command. That way if timezones are different, the date would remain the same and not a day prior.
Excellent point on the timezones! I always forget about this as it is like second nature by now.
I have the somewhat similar issue. Regardless of how I format the date and time, whenever you save to csv - microsoft excel changes the format to your systems format. For example if I set the active_until to 2024-01-01 05:00:00 PM or 2024-01-01 17:00:00 - when the files is converted to csv it is changed to 01/01/2024 17:00
I have the somewhat similar issue. Regardless of how I format the date and time, whenever you save to csv - microsoft excel changes the format to your systems format. For example if I set the active_until to 2024-01-01 05:00:00 PM or 2024-01-01 17:00:00 - when the files is converted to csv it is changed to 01/01/2024 17:00
Same here
+5I have the somewhat similar issue. Regardless of how I format the date and time, whenever you save to csv - microsoft excel changes the format to your systems format. For example if I set the active_until to 2024-01-01 05:00:00 PM or 2024-01-01 17:00:00 - when the files is converted to csv it is changed to 01/01/2024 17:00
Same here
It actually isn’t, it is when you re-open a CSV file in excel that the conversion happens. If you just save it, don’t open, it will retain your format. If you use a non-excel program to open the file (like notepad++ or sublime, or even normal notepad) you can open to confirm this. You have to be careful with csv generation if using excel, basically treat the save as step as the final output and don’t open it unless you have a way to read it without transformation.
When creating the import file - it typically starts as Excel, in Excel - you change the format using Format Cells and then you do a Save As .csv. Even when I save and don’t open as soon as I drag it to import - it still rejects the date format. As an alternative - I tried to change it to Text to keep the date format intact - which obviously gets rejected in Docebo.
Microsoft sets the date/time based on your PC system settings. The only way I have successfully gotten this to work is to change my system settings. Settings > Time and Language > Language and Region. Expand the Regional Format section to expose the Format Settings. Change the short date to YYY-MM-DD. And it still doesn’t respect the time.
This traick, however, changes the format for the system as a whole and so all your excel files will use that format
+5When creating the import file - it typically starts as Excel, in Excel - you change the format using Format Cells and then you do a Save As .csv. Even when I save and don’t open as soon as I drag it to import - it still rejects the date format. As an alternative - I tried to change it to Text to keep the date format intact - which obviously gets rejected in Docebo.
Microsoft sets the date/time based on your PC system settings. The only way I have successfully gotten this to work is to change my system settings. Settings > Time and Language > Language and Region. Expand the Regional Format section to expose the Format Settings. Change the short date to YYY-MM-DD. And it still doesn’t respect the time.
This traick, however, changes the format for the system as a whole and so all your excel files will use that format
Yikes, don’t change you’re PC settings, using the =text() formula in your cells instead and put the right format in, when you save csv out as long as you don’t open that csv in excel again(as the formula is gone) it will hold the format.
Enter your email address or username and password below to log in to Docebo Community. No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
