Log in to AnswerLog in to Follow
UserImage.jpg
Joseph Kuhn
334Views
9Comments
Solved
How can I update my Entity data after updating the excel sheet associated with it?
Question
Import/Export Data
Traditional Web
New to OutSystems
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

0
0
13 Jan 2021
2018-05-03 18-12-54
Ângela Dinis
Staff
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

See solution in context
1
0
18 Jun 2021

This is the best new feature ever! :D

1
0
18 Jun 2021

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

1
0
18 Jun 2021
2022-09-12 11-09-13
Rahul Sahu
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

1
0
14 Jan 2021

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?


0
0
14 Jan 2021
2022-09-12 11-09-13
Rahul Sahu
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

1
0
15 Jan 2021

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)

0
0
15 Jan 2021
2018-05-03 18-12-54
Ângela Dinis
Staff
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

1
0
18 Jun 2021

This is the best new feature ever! :D

1
0
18 Jun 2021

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

1
0
18 Jun 2021

@Ângela Dinis, is this function only applicable in window service studio version. i am running on MAC and i don't see any possibility of changing the entities data. Thanks.



0
0
04 Oct 2021

Hi, Sowhuan!

Thank you for your question. 

Are you using the most recent Service Studio for MAC? You can download it here.

Edit data feature is available for Windows and for MAC as long as:

  • You're connected to an environment that uses Platform Server release 11.11.1 or later.

  • You're connected to an environment with Purpose set as Development or Non-Production.

  • Your IT user has Change and Deploy Applications or higher for the module that contains the entity you are editing.


Let me know if you've further questions.

Have a nice week!

Ângela

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