Import to OutSystems Entity from Excel columns into Entity records

Import to OutSystems Entity from Excel columns into Entity records

  

Hi Team,

We have a requirement, where we need to import data from Excel file ( shown below) into OS entity.

Basically from column format (in excel) to row format( in OS).

Excel format,

Outsystem Entity,


After Import there should be record for each month from July 2016 to June 2017, with Fact Type= Actuals

Similarly, there should also be record for each month from July 2016 to June 2017, with Fact Type= Budget

 Can you please advise on how to achieve this.

hi Z M,

If the image represents the file you need to import, the system action to convert excel into list will not work at all (it accepts only a single line with header).

You will have to resort to one of the components available in forge to open an excel and read the content, or create your own extension to do it.

Cheers,

Eduardo Jauch

Eduardo Jauch wrote:

hi Z M,

If the image represents the file you need to import, the system action to convert excel into list will not work at all (it accepts only a single line with header).

You will have to resort to one of the components available in forge to open an excel and read the content, or create your own extension to do it.

Cheers,

Eduardo Jauch

Thanks Eduardo,

do you know which component from Forge can I used. 

Is Advance Excel component will help to achieve this requirement.


Thanks,


Hi Z M,

Never used any of them, so really don't know. You'll have to do a little search on them to see which ones fit your needs.

Cheers

Eduardo Jauch