Hello All,
I have refrence entities(Normal entity) with data populated from excel,
Excel may have some columns having dots ex.Country.states,Country.city,
The outsystems entity has state ,city as column,
1.When the data is imported in outsystems first time data populated But any modification or any addition of data in excel ,the updates does not happen and gives the message as well"Country.state not included in bootstarp"
2.This issue may happen when user will upload the excel file( from the portal(We can not ask the user to rename the columns)
Can suggest the approaches to handle this?
1.Can we export json of each entity and craete rest endpoint and allow the user to add ?But then how the modify data will work(Is this feasible option)
2.Can in outsystem we need to rename the excel columns Country.city to city,
Please suggest
Hi @Preeti zade ,
Please check this solution as well. In this approach, there is no explicit Timer invocation and no separate Upload/Staging Entity involved.
The user directly uploads the file, and the records are inserted into the target entity.
I have also attached a sample Excel file showing the expected column structure and content . for the upload, so you can use it as a reference while testing the implementation.
Hi @Preeti zade ,Can you share oml to see how you implement logic?Are you trying to bootstrap to data upload and next time you are not able to upload it?RegardsDeepa
Hi Deepa,
In the logic in timer already delete all nd add records is implemented but when doing the upload next time all the columns with dots ex country.states from excel are skipped nd data won't populate,it says not included in bootstarp action
Yes, that's because in the bootstrap approach, you're using the Entity as the Structure for ExcelToRecordList.
In that case, the Excel column names and the Entity attributes must match.
You can verify the mapping by comparing:
If any column name or data type doesn't match, the ExcelToRecordList mapping may fail or produce incorrect results.
Hi Deepa ,
Any possibility to connect with you on your Alternate number if any,
The above i m aware of as the column name mismatch with structure but in the excel when bootstrapped first time it has taken all column ex dependency.deoency_code excel column and created entity entity attribute as dependency_code first time,next time when I tried to update bootstrap action the column skipped,
We want to give use upload facility from ui,in that case column name will mismatch.
But user should not rename columns as per outsystems so how can we address
Thank you
Hi @Preeti zade ,I’m adding a solution for you. Please check whether this approach will work for your requirement.OMl and Excel file both are adding.RegardsDeepa
Hi,
For this use case, I would provide users with a standard Excel template and enforce its format during upload.
Before importing the file, validate its structure and content, including the column names and expected data.
For recurring imports, use create-or-update logic instead of deleting and reinserting all records each time.
Hello,
But I we do not want the user to rename columns ,and just upload excel,any other solution we can provide exposing rest for all data entities and creating form or they can submit data?
You can add validation for the excel file to have the matching columns by using Advanced Excel.