Platform
Learn
Community
Support
Sign up
or
Log in
Profile
messages
Messages
logout
Logout
Platform
Home
Downloads
IPP
Licensing
Project Sizing
Beta
Learn
Training
Documentation
Evaluation Guide
Community
Jobs
Home
Forums
Forge
Ideas
Badges
Members
Support
Partner Guide
Resources Library
Opportunities
Account Management
Pre Sales Demos
Sign up
or
Log in
Home
Jobs
Forums
Forge
Ideas
Members
Badges
Community
›
Ideas
›
Have Excel To Record List read 0's and 1's as booleans!
Advanced Search
0
Followers
8
Likes
Have Excel To Record List read 0's and 1's as booleans!
Adam Alt
Adam Alt
at
#9 603
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
- -
at
+ 2
#28
in Community Rank
What if the user wanted to insert the actual digit 0 and 1?
Adam Alt
9 May 2011
Adam Alt
at
#9 603
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
314
Followers
0
Loading...
Loading
(hidden) New Badge Popup