Marco Arede wrote:

I faced same issue , how do we use structures to import using bootstrap ? looks like this action is only available for database table. attached are dummy xls created and following is screen capture for tables. Will it be possible to share some example code on this ? 

Nilesh Rokade wrote:

attaching 2nd xls 

Marco Arede wrote:

Hi Marco,

Thanks for the reply but it didn't immediately resonate so I'll try breaking it down:

1.  "Maybe you could try to have the foreign keys in excel as integers" - if you look at the image I have provided, that is what I have already.

2.  "then use a structure to import those attributes as integers" - are you suggesting I create a matching structure in Outsystems that matches the excel spreadsheet and bootstrap to that instead of bootstrapping directly to the original target entity ?

3.  "and then finally when iterating results interpret each one to convert into correspondent identifiers" - by this I assume that you are suggesting creating a preparation that uses the bootstrap to the structure to populate the original target entity ?

Cheers, Richard. 

Hi Nilesh Rokade,

After that initial step (bootstrap from excel file), modify your bootstrap action to include a structure.

Hi Richard Pearce,

My suggestion is to not use the identifiers, because they are assigned automatically and can change. The safer and standard solution is to lookup for records by name.

However responding directly to your first question, you could import identifiers by using a structure, just adapt a bootstrap action, and create a structure to be mapped later to your entity.

Marco Arede wrote:

The identifiers for my static entities don't change because they are not auto-generated.  I tried using integers in my Excel spreadsheet and used the data conversion function to convert the integers to identifiers.  There are no errors reported but still no data loaded into the target entity.  The search for a solution continues...

Eduardo Jauch wrote:

I managed to work out all the above instructions through trial and error and it didn't work, until I found that the identifiers for my target entity were not auto-generated.  Fixed this and it now works and it is pretty simple once you understand a few key things i.e. you need to ignore a few of the warning messages and fill the missing gaps in once you've created the bootstrap.  One thing I would add to your steps above - for (1) add the foreign key IDs as integers in excel (and convert to identifiers in step 4).

Thanks to everyone for the help in getting me over the line !

Cheers, Richard.

Hi Richard Pearce ,

Interesting point, great to know it worked. Cheers!

Eduardo Jauch wrote:

I used integer in the structure because the static entities don't use long integers.  But it looks like it works both ways.

Cheers, Richard.

Eduardo Jauch wrote:

Hi Eduardo,

When I first encountered the problem, I looked at the Outsystems documentation article on bootstrapping.  Didn't find an answer, so searched through a lot of forum articles but didn't find the explicit references there, although in hindsight I understand some of the comments I found there better now.

It would be good if the issue with the foreign keys was explicitly referenced in the Outsystems documentation article.  Better still, because Outsystems has implemented integer based surrogate keys for the identifiers, the bootstrapping process could quite easily be modified to match the appropriate integer column in Excel with the identifier in Outsystems.  There shouldn't be too much of an issue with doing this and we are effectively doing it manually every time.  It would also benefit the majority of bootstrapping processes and increase productivity because let's face it, the bootstrapping process is an important part of pre-seeding the data for any Outsystems application.

What do you think ?

Cheers, Richard