I created an action to import excel file and triggering it by a button. And I am testing it now, the question is, Is it necessary to input all the attributes in the entity in the excel columns to be imported, or it is okay to include only the mandatory attributes?
Hi,
On excel import process I think we should allow to edit all fields that must be filled by the user
Hi RD.,
In excel import it is not necessary to provide all the column but yes you should provide the mandatory column values. OutSystems maps the columns with entity attributes based on the name and data type.
ThanksPankaj
Hello RD.
When you import data from an Excel file into an entity, you only need to include the attributes that are mandatory or required to be filled in the entity. However, it's important to note that any attribute not included in the Excel file will not be updated during the import process.
If there are attributes in the entity that are not mandatory but need to be updated with the imported data, you will need to ensure that those attributes are included in the Excel file. If the attribute is not present in the Excel file, then the value of that attribute in the entity will remain the same as it was before the import process.
It's also important to ensure that the column names in the Excel file match the attribute names in the entity. If the column name in the Excel file does not match the attribute name in the entity, the data will not be imported into that attribute.
In summary, it is not necessary to input all attributes in the Excel columns to be imported. Only the mandatory attributes need to be included in the Excel file for the data to be imported into the entity.