Posted: 4 May 2015 5:44 EDT Last activity: 4 Oct 2018 11:08 EDT
Data table import csv file in 7.1.7
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.
**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.
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.
I have one query with respect to importing a file for data table values updations. Is it possible to update the existing values or including a new data values into the data tables? If so, could you please explain me to proceed further? Thanks in advance.
Posted: 2 years ago
Updated: 2 years ago
Posted: 30 May 2018 5:51 EDT Updated: 30 May 2018 5:50 EDT
Thank you for posting your query in the PSC. This looks like an inactive post and hence, we suggest you create a new post for your query. Click on the Write a Post button that’s available on the top right pane of this page. Once created, please reply back here with the URL of the new post.
You may also refer this discussion link as a reference in the new thread.