Import Data From Single Excel File to Multiple Entities

Import Data From Single Excel File to Multiple Entities

  

Hi,


Thank you for reading this post. The logic I have created for "Importing Data from Excel" seem to be incorrect. May I ask for assistance on this little project I'm doing? 


BASICALLY:

1. I have an excel file that I want to import. Here is the structure below.

2. The Data model is this. The [Name] column is to be stored into an entity called Students while the [Subjects] column is to be stored into another entity called StudentSubjects.

3. THE PROBLEM; my logic doesn't seem to store/import all the subjects (Science, History, Math, Health) into the StudentSubject entity. I used String_Split action to split (",") the [Subject] column from the excel file.

When I import the excel, THE OUTCOME is that only one subject is created on the StudentSubject entity.


I have attached the .oml file and the excel file I used as a test for importing for your review.


Thank you and best regards,

Jane

Hey Jane, Happy to help you here...

What you need to do is, just after the String_Split, loop its result, and than do the Get/Assign/Create StudentSubjects objects.

Hope it's clear now.. ;)

João Melo wrote:

Hey Jane, Happy to help you here...

What you need to do is, just after the String_Split, loop its result, and than do the Get/Assign/Create StudentSubjects objects.

Hope it's clear now.. ;)

Hi Mr. João,


Thank you for taking the time to answer my question but I'm afraid I don't follow. I'm new to Outsystems and can't seem to understand the logic you want me to do. Can you please explain more clearly?


Thank you and best regards,

Jane



Sure... See oml attached and image bellow...