13
Views
2
Comments
Importing data from Excel to an entity
Question

Hi guys,

I'm trying to import data from Excel file to an entity. It's OK with all the fiels except the birth date.

I tryed everything but I'm not able to import the birth date.

Anyone with the same problem and could fix it?

Thanks

P.S.: Just solve it. In the excel file, one of the fields had a wrong date. Just fix it and I was able to import it. Thanks to all.

Rank: #177

Hi Luís, 

i think that your data format is the problem,

look this posts with example, maybe help you.

https://www.outsystems.com/forums/discussion/43885/bootstrapping-entity-with-excel-datatype-date/ 


https://www.outsystems.com/forums/discussion/9384/importing-data-from-excel-help-users/ 


see also how the date column is formatted in your excel.


Regards.

Hi,

please check this document and video, where you will find everything:

Cheers


NOTE: This two documents explain the opposite case: How to Export Entity Data to Excel and How to customize the export to Excel