Have Excel To Record List read 0's and 1's as booleans!

Adam Alt

#4 186

in Community Rank

Backend

On our radar

I was wondering if the Excel to List function could read 1's and 0's and translate them into booleans. Apparently it can't right now, so I had to manually change all my 0's to "False" and all my 1's to "TRUE" like you see above in the last columns.

Created on 2 May 2011

Comments (2)

- -

7 May 2011

- -

+ 2

#12

in Community Rank

What if the user wanted to insert the actual digit 0 and 1?

Adam Alt

9 May 2011

Adam Alt

#4 186

in Community Rank

The user could use 1's and 0's in an integer column, but where a column is typed as a boolean and it shows up in the excel spreadsheet at that position, it should read 1's and 0's like true and false. the reason for this is that databases store booleans as a BIT column(either 1 and 0), so when you export a database table to excel it shows up as 1's and 0's and outsystems should be able to read that. The Excel to Record List function takes an entitiy, so it shoudl know where booleans show up.

views

104

Followers