Import time field within Excel to Rollbase 2.0.0.4

Posted by bakar on 04-Dec-2013 14:11

It looks like that we cannot import the format hh:mm:ss within a excel (XLS) column into Rollbase. I have tried to import into a "text" object field and a "time" object field and both situations cause a strange behaviour. Could you confirm this?

All Replies

Posted by bakar on 13-Dec-2013 17:44

Is there any update? I have also checked the hosted cloud. Try to put the value 12:32:55 in a Excel column and import it to a "text" field in Rollbase. Rollbase changes the value into a date format...

Posted by Rajkumar Mateti on 16-Dec-2013 01:23

Hi Bakar,

Yes we also observed the same.

But we are able to import the value 12:32:34 in a excel column into rollbase text filed by changing that field format in excel to text.

Thanks,

Rajkumar

Posted by Santosh Patel on 27-Dec-2013 04:00

Hi Bakar,

Values of type hh:mm:ss are auto-formatted to time by Excel. I suggest you to prepend the text with a single quote forcing the cell to have a text value. When importing such a field, Rollbase will keep it as a text field and not auto-convert to Date/Time field.

E.g. Current cell value in excel (auto-converts to time format) -    12:33:30

       New cell value in excel      (formats the cell to text type)    -     '12:33:30

Regards,

Santosh

This thread is closed