Hi Jessica,

I think you missed something , let me explan again.

1.First in your entity remove foreign  key and make it simple Integer data type column.

2. in excel file upload data with integer column and check mapping column.

3. once data bootstraped, convert datatype in entity make foregin key of column .

4.after publish you need to able see data.

Hope this will help you.

Regards

Rahul Sahu

Hi Jessica,

I guess It was not possible to change the column type, as there is already data (zero 0) written to it. 

So, you will have to delete the column and create it again with another name and type Genre Identifier.

Regards,

Leandro.

Hello Jessica,

That error is ocurring because you have values associated to your GenreId attribute (in Work entity) that doesn't exist in the Genre entity.

For example, imagine this scenario. You have only 3 records in the Genre entity, with Ids 1, 2 and 3.

Since GenreId (in Work entity) is now an integer, you can assign any integer you like. But if you put a value that is not 1, 2 or 3, that value won't exist in the Genre table, and you will receive that error when you try to convert the GenreId attribute from an integer to a foreign key.

My advice is that you review your Excel and the values in the GenreId column, make sure that every single one of them exists in Genre entity and it should work afterwards.

Kind regards,

Rui Barradas

Hello Carlos Lessa, 

Here is my Test.oml

Regards, 

Jessica. 

Jessica, in the link you sent above

Here they status is a string (Label) in your case you hade a number

here in this loop, you need to query to find a match between a Label and the string you have in the excel

and finally after return a record that match the label you are getting the identifier of this record to assign to the record you are creating

In your specific case, you don't have a string, you already have the id, so you don't need to do that match(unless you are trying to match to check if the record exist, cuz if don't will also fail to save), so saying that you can assign directly without the extra query (but just remember with the data isn't correct may fail  because you can be trying to save an FK that doesn't exist )

Hope this explanation can give you some insight into what is happening

Best regards

Carlos Lessa

I believe that I need to study more about bootstrap Excel, and now my information is very confusing to obtain some Help. for this, I will close this post and try after, with the concept better structured.

Thanks for all help,

Best Regards, 

Jessica Marques

Don't worry, take your time to study, you are in the right way.

I advise you to make one of the Paths from the online Bootcamp, it will save you hours of your coding when you understand the basics and there are some example of the bootstrap

Traditional web: https://www.outsystems.com/learn/courses/114/developing-web-apps-outsystems-11/?LearningPathId=2

Reactive: https://www.outsystems.com/learn/paths/18/becoming-a-reactive-web-developer/

Mobile: https://www.outsystems.com/learn/courses/115/developing-mobile-apps-outsystems-11/

Good code

Hello,

I got it to include the data of a static entity in the table, but for that, it was necessary after inserting the table with bootstrap and to create a server action and a button to delete the data from the table, after that, when I update the page I can see the label of the static entity normally. 

There is probably an easier way to do this if anyone knows, I take suggestions; )

I followed these two paths:

https://success.outsystems.com/Documentation/How-to_Guides/Data/How_to_update_a_Bootstrap_Action_to_fetch_an_entity_identifier_from_Excel

https://success.outsystems.com/Documentation/How-to_Guides/Data/How_to_delete_data_from_Entities

Attached I present the oml file with the test I did

thank you so much for your help!

Best Regards, 

Jessica Marques.