Hi, I am new to Odoo. Trialing the email marketing. 

I am attempting to upload a CSV file (excel sheet) with 800 contacts. The sheet was exported from mailchimp and the field headings don't match. 

There are some important fields (such as OPTIN_TIME) that I want to transfer across. 

Most import functions allow you to either keep the original field name or set a new one. It seems I can only select from a pre defined list? 

Odoo is not allowing a date and time upload eg 

OPTIN_TIME   21/03/2022 16:07 

or CONFIRM_IP  00.000.000.000 

or numerical value  eg member rating scale of 1 to 5 for how engaged a client is - 

very useful info for marketing purposes!!!

MEMBER_RATING  3  

Does anyone know a way around this please? 

Many Thanks in advance Craig