I'm using pega 7.2 version. Exported the proposition data to CSV file and making changes to a single row or a few rows. Irrespective of any changes, the following import shows all the records as modified. It is observed whatever change is introduced after export, boolean values true, false are converting to capital letters automatically on saving the sheet i.e. to TRUE, FALSE respectively.
We are looking for the below solution:
1. It shouldn't change any data to lower/upper or any format change. Only the modified rows should be considered as modified
2. Though we are using only a very few fields in our proposition form, during export it is exporting all unnecessary fields. How can we control to export only the fields that are in the proposition form (i.e.pyEditElement section)
3.Can we maintain a single common excel sheet that should contain all the fields from all issue/groups but while importing it should import the values of corresponding fields of that particular issue/group?
Thank you in advance
***Edited by Moderator: Pooja Gadige to add product details tag***
Are you exporting unversioned propositions from the propositions landing page or versioned propositions from a decision data rule?
Where do you see the change in the format of the data? is it in the CSV file after export or in the proposition after the import?
What are the unnecessary fields that you see on export?
And answer to your point 3 is that it is not a feasible solution. By design, the csv can be exported/imported from/to a decision data rule or if it is for an unversioned group, it is exported/imported for a particular issue/group.
I exported 150 propositions to a CSV file. I updated the data of just 1 proposition and saved the sheet. Started importing the sheet, selected the sheet to import, and before the final step it shows how many new rows are added, how many are modified, and how many are deleted. In this case, I should see 1 modified row, 0 new rows, 0 deleted rows but I see 150 rows updated, 0 rows added, 0 rows deleted.
2. I have around 50 fields in decision data but on proposition form (pyEditElement section), I'm just using 10 fields but when I export, it is exporting all the 50 fields