Re : Import Static Entity Records

Britni Fletcher

Solved

Question

Is it possible to import records from an Excel file to a static entity?

This would be used for more than one thing, but for example ... creating a country drop-down list. Is there an easier way to add all the countries as static records instead of entering 200+ manually? Also, for this specific example only, would it be better to have a regular entity and import the records in the web application? If so, I know how to do that.

In other cases where it would be better to have a static entity, is importing possible? Or is there an easier way? I saw an option to Import from Database, but I'm not sure how that works and I couldn't find any information about it.

07 Sep 2011

Nelson Baptista

Staff

Solution

Hi Britni,

As far as I know, it's not possible to import an excel for a static entity directly. But it's possible achive what you need, I'll explain.

Step 1 - Create an Entity with the atributes that you want.

Step 2 - Do the import action

Step 3 - The excel need to have the same format that the entity.

Step 4 - After Import the excel file, check the values in the entity

The values are in the entity, now you will convert the entity as static entity

Step 5 - Import the values from database, click in the"import from database" button, the values that was stored in the entity were imported to the static entity.

If you want know more about the "import from database" feature check the link bellow

https://www.outsystems.com/help/servicestudio/6.0/Using_Data/Static_Entity_Records_Tab.htm

Regards,
Nelson Baptista

08 Sep 2011

Nelson Baptista

Staff

Addicional info

You can use the feature "Create Action to Bootstap Data from Excel" to create the import action, the action will be placed inside the "Actions" folder and the excel file that you choosed will be placed in the "Resources" folder.

Regards,
Nelson Baptista

08 Sep 2011

Justin James

MVP

Britni -

In this *particular* instance, it's already been solved for you, in 6.0 there is a "Country" eSpace with this data. I think you may need to install one of the sample apps to get it though.

Alternatively, I could provide you with an OML that has a "Country" entity in it, that I spent the better part of a night copy/pasting together a while back. :D

J.Ja

08 Sep 2011

Britni Fletcher

Thank you both!

Nelson,

That worked perfectly. I tried something very similar to that before I posted, but I missed one very important step that I wouldn't have thought about if you hadn't explained it. Thank you for being very thorough. :)

08 Sep 2011

Daniel Marcelino

Staff

Hi guys, just a quick update regarding this subject (new users on OS Platform asked for this use-case), for OS P10 there's a quick GIF with the steps needed in order to accomplish this (Import from Excel file to Static Entity):

As Nelson mentioned for the previous versions, I will recap the steps:

1- Create your Excel file with the data you need to bootstrap;
2- Create an entity inside Service Studio with the name you want and add an attribute with the same name as the column in your excel file (format must be the same).
3- Right click on the entity and select "Advanced"-> "..action to bootstrap"
4- Publish (F5)
5- Right click on the new entity and go to "Advanced"-> "convert to static entity"
6- On the new static entity(created in step 5), double-click on it and select the tab "Record", then "Import from Database" that way you will add the previous data from the "Entity" to the "static entity".

Regards,

Daniel Marcelino

12 Jul 2017

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

See the full guidelines