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
Dear ,
What would improve your OutSystems Community experience? Let us know by taking this 2-minute survey.
Pick up the survey
Community
›
Forums
›
Technology & Integration
Excel file upload and append to existing data
ExcelAppend
ExcelAppend
New Post
New Post
Sunil Gupta
Posted on 2016-05-05
Sunil Gupta
Rank: #26341
Posted on 2016-05-05
I created an initial Entity using the Excel import feature. Which I then went ahead and modified by creating Additonal static entities. E.g. Employee.DepartmentName was changed to Employee.DeptId which points to a static entity, called Department with a Name field.
I now would like to be able to upload and append data to this database from an excel file, which has the original data as Employee.DepartmentName, and it has nothing about the department Id.
How would I go about doing this.
Nuno Rolo
Posted on 2016-05-05
Nuno Rolo
Rank: #121
Posted on 2016-05-05
Solution
Hi Sunil,
Know you have to create your own import action.
Where you use the
DepartmentName to search the right ID in the Department table.
Hope that helps.
Solution
Login to reply
New Post
Available Forums
Technology & Integration
News and Announcements
Forge Discussions
Meta
Hints and How-To Guides
Usability
Installation Troubleshooting
Personal Environment Troubleshooting
Forum Notifications
Email Digest Settings
Loading...
(hidden) New Badge Popup