Adding new records in entity from excel within same name
120
Views
3
Comments
New
Service Studio

While importing entities from excel it would be nice to have an update of number of records when we upload a file which contains Entity name used before. I imagine It would have all records previous and it would add new ones which will be different from previous ones within same entity and not within different Entity

It is great idea that the enhancing the Excel import feature to add only new records to existing entities will improve data management in OutSystems. It will organize the import process and reduce the need for manual intervention.  

If there is no proper checks it will be always a risk of importing duplicate records and comparing large datasets to identify new entries may affect performance.

If implementing duplicate detection and showing clear import summaries would help make this feature both powerful and user friendly. 

Enhancing the Excel import functionality to support inserting only new records into existing entities would significantly improve data management within OutSystems. This enhancement would streamline the import process, minimize manual data cleansing, and reduce the risk of data inconsistencies. 

There should be proper validation in place to prevent the insertion of duplicate data. If duplicates are detected, the system should update the existing records instead of creating new ones. However, for large datasets, this process could impact performance, so any such enhancement should also consider optimization to maintain efficiency at scale. 

Implementing efficient duplicate detection along with clear import summaries would provide a robust and user-friendly solution, ensuring both data integrity and operational efficiency during bulk imports. 

his is a practical and time-saving idea! Allowing the ability to add new records to an entity directly from an Excel file with the same name streamlines the process and significantly reduces manual data entry.

 It would also enhance efficiency when working with large datasets, making data management more seamless and less prone to errors. A great way to improve usability and speed for developers and users alike