How can I update my Entity data after updating the excel sheet associated with it?
Application Type
Traditional Web
Service Studio Version
11.10.5 (Build 37061)

I am relatively new to OutSystems. I am trying to create a form that users can submit so that the data is output into a new excel sheet. I have imported all of the data that I want for the dropdown options, and have everything wired up correctly (I believe). But now I realized that I want to change some of the dropdown options from the excel sheet, and potentially add new ones, and I'm not sure how to update the entity without completely scrapping the entity and starting over from scratch.

I was attempting to play around with CreateOrUpdate, but it's asking me for an Id and I'm not sure where I would even find that information. Some insight into any of this would be very helpful.

Screenshot20210113145014.png

Solution

Hi, Joseph.

I am reviving this forum post to tell you that since Service Studio version 11.10.16 editing your data is at least 10x faster! You don't need to jump into SQL or create a form/full back-office anymore. You can now quickly add, change and delete your entities data directly in Service Studio under environments with a "non-production" purpose. 

Let us know what you think! :-) 

Have a nice weekend,

Ângela

This is the best new feature ever! :D

Hi Angela.. This is the awesome feature in outsystems.. Now you can easily add, update and delete the entity data.. 

mvp_badge
MVP

Hi Joseph,

You need to create one Record type variable and it should be same as FavoriteRunningJoke as i am seeing.

assign variable from excel.current.label to FavoriteRunningJoke  attribute  one by one.

at last you need to assign FavoriteRunningJoke in source of CreateOrUpdate action.

see below image-


Hope this will help you.

Regards

Rahul

Rahul, I am confused by your response. I already have a Bootstrap that was set up by OutSystems and looks just like yours. This was used to create the initial entity as far as I'm aware. But now I'm trying to update the entity so that it changes any changed data and adds any new data. Where do I incorporate the CreateOrUpdate action? And how do I get it to run?


mvp_badge
MVP

Hi Joseph,

basically you using Outsystem bootstrap action which is make default Create entity action only.

if you need to update data then you have to do things on same action-

1. use createOrUpdate action instead of createaction 

2. Add filter on a aggregate based on a unique column

3. Assign Source Identifier 



In this case Data identified by aggregate than data update else Create new.


Hope this will help you.

Regards
Rahul

Do you want to keep maintaining those tables through excel files?

Because if not, you can very easily just generate some screens that allow you to manage the values directly in your application, without the need of ever using that excel file anymore.

(I know the image is for reactive web apps, but the process is the same on traditional web)

Solution

Hi, Joseph.

I am reviving this forum post to tell you that since Service Studio version 11.10.16 editing your data is at least 10x faster! You don't need to jump into SQL or create a form/full back-office anymore. You can now quickly add, change and delete your entities data directly in Service Studio under environments with a "non-production" purpose. 

Let us know what you think! :-) 

Have a nice weekend,

Ângela

This is the best new feature ever! :D

Hi Angela.. This is the awesome feature in outsystems.. Now you can easily add, update and delete the entity data.. 

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.