Discussion
Data table import csv file in 7.1.7
Hello Team,
I'm using Pega 7.1.7 version. I have a requirement of validating data instances when they are added via data type portal or through Excel thru import.
As we all know, in 7.1.7, Data tables are replaced with local storage. So when i try to save any data instances on data type rule form on records tab, its validating as expected(This is achieved by having an activity on that class).
Similarly when i import csv file its not validating...any help will be highly appreciated.
When i implement the same functionality in 6.3SP1, whenever data is edited in excel and clicked on Add-ons feature, I'm able to validate the data instances before saving to pega data base...but this is not happening in Pega 7.1.7.
Is this is a product bug or do we have any alternate solution for this.
Regards,
Zakir
**Moderation Team has archived post**
This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.
Zakir,
You are correct, in 7.1.7 instances added via import from excel are bypassing standard validation. They are not skipping validation entirely, basic property type validation is still being executed. So for instance, if you had defined a local list of acceptable values on one of the properties then the system would still ensure that the value of that property was in the list for each record imported from excel. However they are not being run through the validate rule of that class.
This will be fixed in Pega 7.1.8. All records saved by the record editor, whether through the UI or through import, will be validated the same way - with the validate rule of that class.
-Michael