Not able to import excel data

I am trying to import excel data but I am getting the below error

Excel read error in row 5: Column 'Project End Date' has an invalid type. Expected a 'DateTime' but received a 'String'.

Can you please give me the solution?

Dear Densingh,

Will it be possible for you to provide the OML for your application?

Shounak

Hi,

this is datatype error entity have datetime but you are passing string .

you can convert sting to datetime  from Built-in Function.

TexToDateTime() 



Hope this will help you.

Regards

Deepa

Hi,

The error you are facing is because of the different data type in excel sheet and in entity attribute.

Please go through this videos of data modeling training 

https://www.outsystems.com/training/lesson/1913/demo-how-to-bootstrap-entity-data-from-excel?LearningPathId=18

https://www.outsystems.com/training/lesson/1914/demo-how-to-bootstrap-entities-and-data-from-excel?LearningPathId=18

you will get idea of how to import data from excel in Reactive.

Regards,

Komal

Hi.

You can convert text to date-Time using TextToDateTime() function or you can change the format of the cells to a DateTime format and import again.

Regards

Gonçalo Almeida

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.