Hey,
I would like to import an Excel file and I have columns with different number of data rows (see example attached).
I would appreciate if you could help me. The number of questions is not always constant and can change from file to file (specified by column "NumberOfQuestions").
Kind regards
Hi Derek,I think there is nothing special, just drag and drop your Excel file and you will get all data and Entities available in your Outsystems App.Then all you need is to check data, and if needed delete the non-required Entities.Kind regards,Sirajeddine
Hi @DerekOF
If I understand you correctly, do you basically want to add the Excel data to your OutSystems entity?
You can have a look at the following OML + Excel file that I have made.
I basically created my CustomersDetails entity and bootstrapped the data from Excel to OutSystems.
Hope this can guide you a bit.
RegardsAndrew_Smith
Thank you very much for your help. This is a great example and I am currently adapting my app accordingly and trying out your suggestion. I'll let you know when I get it working :-).
Derek
In addition to all the answers you can check below outsystems document and watch out sample video for the same.
https://success.outsystems.com/Documentation/11/Developing_an_Application/Use_Data/Bootstrap_an_Entity_Using_an_Excel_File
Hope it helps you.
Thanks,
Ajit Kurane.
@DerekOF Moreover, I suggest that you put the Questions in a separate sheet (tab) of your Excel file, this will ensure you will get a separate Entity Question that you can link to the Customer Entity by 1-to-Many relationship, or Many-to-Many relationship (according to your use case)
Thank you so much for your help. I am trying to implement it exactly the same way. I have the main information in the "Main" tab and the list of all questions in the "Questions" tab. I'm currently building the appropriate server action, using the tips and Andrew's example (see above), and I'm curious if it will read in cleanly. I'll let you know when I get it working :-)