Skip to Content
This question has been flagged
importcsvformattimesheetduration
3 Respostes
9181 Vistes
Avatar
Ermin Trevisan

How do I have to format the duration of an activity in order to avoid this error message when validating the import file?


Avatar
Descartar
Avatar
Niyas Raphy (Walnut Software Solutions)
Best Answer

Hi Ermin,

Here in your case you have to replace the 04:00 with just 4 and check.  


Checking the image you have added, in the following lines,

04:30 -> 4.5 and so, all lines has to be adjusted


In case of importing data i will suggest first export a record from the same model and see how it comes, and based on this adjusting will give solution all the time.


Thanks

Avatar
Descartar
Ermin Trevisan
Autor

Stupid me, I did not realize the format change in the export file.

Avatar
Ermin Trevisan
Autor Best Answer

Excel-Hint: If the column containing the duration is formatted as datetime, then you can create the proper import format (hours in real number format) simply by multiplying the duration with 24.

Avatar
Descartar
Related Posts Respostes Vistes Activitat
Timesheet Import Task Matching Problem in Odoo 16
import timesheet
Avatar
0
de set. 24
1679
Disable automatic follow when importing res.partner csv
import csv
Avatar
Avatar
Avatar
3
de juny 20
5092
Enable/disable import rights?
import csv
Avatar
Avatar
1
de nov. 18
10557
'utf8' codec can't decode byte error when importing a list of products as a CSV file Solved
import csv
Avatar
Avatar
Avatar
Avatar
Avatar
11
de febr. 17
65268
Import contacts through CSV Solved
import csv
Avatar
Avatar
2
de març 15
12369