Skip to Content
This question has been flagged
importcsvformattimesheetduration
3 Replies
9183 Views
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
Discard
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
Discard
Ermin Trevisan
Author

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

Avatar
Ermin Trevisan
Author 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
Discard
Related Posts Replies Views Activity
Timesheet Import Task Matching Problem in Odoo 16
import timesheet
Avatar
0
Sep 24
1679
Disable automatic follow when importing res.partner csv
import csv
Avatar
Avatar
Avatar
3
Jun 20
5092
Enable/disable import rights?
import csv
Avatar
Avatar
1
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
Feb 17
65268
Import contacts through CSV Solved
import csv
Avatar
Avatar
2
Mar 15
12369