Odoo Help


How i can upload date data in dd-mm-yyyy H-m format from CSV file

on 12/31/15, 11:49 PM 3,194 views

17-12-2015 7:05' does not seem to be a valid date for field 'Order Date' 

at row 2 

Use the format '2012-12-31'     -- >  while i was use field.Date


'17-12-2015 7:05' does not seem to be a valid datetime for field 'Order Date' 

at row 2

Use the format '2012-12-31 23:59:59'  -- >  while i was use field.Datetime

how i can upload dd/mm/yyyy / H/M format   from CSV file
my actual date like that 

17-12-2015 8:38


Ray Carnes

--Ray Carnes--
| 9 7 9
Keyport, United States
--Ray Carnes--

Senior ERP Analyst

OpenERP 6.1, 7.0; Odoo 8.0, 9.0, 10.0 and 11.0.

Completed Odoo Functional and Technical Training.

Functional Areas:

  • CRM/Sales

  • Inventory

  • Manufacturing

  • Accounting

  • Purchasing

Major Skills:

  • Business Process Reengineering

  • Efficiency Consulting

  • User Needs and GAP Analysis;

  • Functional and Technical Design;

  • Prototyping and Proof of Concepts;

  • Requirements Specifications;

  • Agile Implementation;

  • Data Migration;

  • Configuration & Customization (UI and code);

  • Integration - Odoo and non Odoo Applications and Services;

  • Training and Knowledge Transfer;

  • Go Live Support;

  • Helpdesk;

  • Version Upgrades and Migration.

  • Accounting Expert.

I have over 20 years of experience empowering and enabling users with enterprise information systems that make a real and measurable difference in their ability to proactively manage their businesses and organizations. 

I am a skilled Communicator and I only take the serious things seriously!

Ray Carnes
On 1/1/16, 11:16 AM

CSV import expects dates in a specific format - and it tells you this - they need to be in the format "2012-12-31 23:59:59".

Unless you can change the format of the date fields in your files, you can't import them via CSV.

Krupesh is advising either to run a script, or to use Excel/Open Office to change the format of the field into the correct format.

Krupesh Laiya
On 1/1/16, 6:36 AM

write one script in python and create new csv file for the date format:

suppose you have customer csv open it using below code and format date as per requirement I had split the date with . (dot) you have to format the code as per your requirement.

from new csv file copy whole column to the original csv file you get the formatted date as per requirement.

import csv

csv_rd = csv.reader(open("customer"+".csv"), delimiter=';')

count = 0

for rec in csv_rd:

fields = rec


all_datas = []

for rec in csv_rd:


a = []

for rec in all_datas:

print rec[7]

print rec[7].split('.')

s = rec[7].split('.')[2] + '-' + rec[7].split('.')[1] + '-' + rec[7].split('.')[0]

print s


with open('eggs.csv', 'wb') as csvfile:

spamwriter = csv.writer(

csvfile, delimiter=' ', quotechar='|', quoting=csv.QUOTE_MINIMAL)

for val in a:


@krupesh is this every time task or a single time task ? bcoz i want daily upload 5-10 file with more the 2000 record in every file ... every time i(we) can't upload multiple time file like first change the date and then after upload in main place can you know about any date field which can directly convert date in dd-mm-yyyy h-m format without upload another place upload file

shivam dudhat, Shivam
on 1/1/16, 6:50 AM

Please try do it from property of the column you can change property of the column may be this is help full to you.

Krupesh Laiya
on 1/1/16, 7:08 AM

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


Asked: 12/31/15, 11:49 PM
Seen: 3194 times
Last updated: 1/8/16, 1:52 AM