Thanks for the quick reply!
@Renato: I sadly dont have a working version to exportand i'm concerned that the OML file contains people data? (Its against the law in the EU to publish this data in any way..).
@George & Indra: Thanks, I found these alredy, but they dont help my issue.
I will try to explain in more detail:
I need to create a continues update stream between to systems so i need to update te DB with info from the excel file.
My steps were as follows:
Created an import action to pick a file and import it. This works! So there are no empty columns and the Attribute names are consistent with the excel file. The import works fine, I have the data in the outsystems DB.
Then I added an Attribute 'DepartmentId' to the People entity. This Also works fine and I can choose a department in the PeopleDetail screen.
After this if i read another excel file into the system I get the error. So I suspect I need to tell Outsystems to expect an Attribute less then is in the excel file and fill that last attribute after reading the row from excel with a local variable?
regards,
Willem