ExcelToRecordList - Unable to fetch data from Time datatype column

ExcelToRecordList - Unable to fetch data from Time datatype column

  
Hello,

ExcelToRecordList - Unable to fetch data from Time datatype column

I am trying to use ExcelToRecordlist for importing data from excel to my entity.
My entity has one column whose datatype is Time, and in my excel file I have columns data as 01:30:00:000  And outsystem is not recognizing this data as time datatype.
Please help me in this regards.
Either guide me how to convert this excel data type for that column dynamically - on the fly or is there any other way.

Please help me.

hi Hemlata Nerurkar,

i think you should use DateTime datatype instead of Time.
Regards,
MJ
Manish Jawla wrote:
hi Hemlata Nerurkar,

i think you should use DateTime datatype instead of Time.
Regards,
MJ
 Hello Manish,

Thank you for your suggestion. But this is not working.
Still getting the same error as:
Excel read error in row 2: Column 'StartTime' has an invalid type.
 

Hemlata Nerurkar wrote:
Manish Jawla wrote:
hi Hemlata Nerurkar,
in you excel keep that column as text type and while inserting it use TextTodatetime conversion function and try!

Hi Hemlata,

Please provide sample Excel and OML file.
Suraj Borade wrote:
Hi Hemlata,

Please provide sample Excel and OML file.
 Please get attached file.
 
Hi Hemlata,

01:30:00:000 is not a valid timestamp in Excel. As you can see in the cell's properties, it is stored as text. A valid timestamp in Excel looks like 01:30:00.000, so with a dot separating the seconds and microseconds. If you can't alter the input format, you'll need to import it as text, and convert it yourself.

That said, the file looks very weird, e.g. the column "Take Down" has a timestamp of 23:60 in it - not a valid time.