Skip to Content (Press Enter)
UserImage.jpg
Harry de Boer
6Views
2Comments
Import Excel  (ETL proces)
Question
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
0
0
20 Jun 2011
Copy Link
2011-06-15 10-51-52
Cipriano Teibão
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
0
0
20 Jun 2011
Copy Link
UserImage.jpg
Harry de Boer
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

importdata.zip
0
0
22 Jun 2011
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.