Import Excel  (ETL proces)

Import Excel  (ETL proces)

  
LS

Is there a way to import excel data to an entity while transforming the data (field x to field y, text to date conversion, etc.) ? I noticed the ExcelToRecordList action, but can't figure out how to do the above?

Regards, Harry
Yes its possible, 1st you need to create a structure with the same data type as your excel file, then import it normally with the ExcelToRecordList action.
Then, you iterate the ExcelToRecordList  output list and assign it to a Record of the same data type as your database entity, on that assign you can do the conversions you need.

Regards,
Cipriano Teibão
Cipriano,

First of all, thanks for pointing me in the right direction. I've created a test espace for it, but I cannot seem to get it right. When I test I get no errorrs but no records are imported. I've attached the oml and excel (zipped), can you see why this isn't working?

Regards, Harry