Odoo 11: CSV-import timesheet data: Column unit_amount (duration) contains incorrect values (value: 04:00)

Question

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

Niyas Raphy (Walnut Software Solutions) · Accepted 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

Ermin Trevisan · 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.

Related Posts	Odpovědi	Zobrazení
Timesheet Import Task Matching Problem in Odoo 16 import timesheet	0 zář 24	1679
Disable automatic follow when importing res.partner csv import csv	3 čvn 20	5092
Enable/disable import rights? import csv	1 lis 18	10557
'utf8' codec can't decode byte error when importing a list of products as a CSV file Vyřešeno import csv	11 úno 17	65268
Import contacts through CSV Vyřešeno import csv	2 bře 15	12369

This question has been flagged

Enjoying the discussion? Don't just read, join in!