Go to http://www.cedarhillsgroup.com/knowledge-base/kbarticles/deleting-rows-in-exceltoci to see How to modify delivered ExcelToCI template to delete rows which is not delivered by default. One of the use case is delete roles from user profiles in mass without using backend SQL . This uses delivered USER_PROFILE component interface. Tested in PT 8.53 and works fine. Make sure that you select Action as UPDATEDATA in Connect Information worksheet of ExcelToCI
In Summary, Go to Tools | Macros | Visual Basic Editor
Open StagingAndSubmission Module and Navigate to WriteCollectionHeader function do the following.
You will see a case statement “Select Case lScrollLevel”
Change the “Case 1” statement as PSROLEUSER is in level 1. If your target rows exist in other levels, you will need to modify that Case statement.
sXmlLine = sIndent & "<" & sXmlTag & ">"
To
sXmlLine = sIndent & “<” & sXmlTag & " CINodeAction=""DELETE"">"
4 comments:
Interesting tip. Keep up the good work!
Has anyone tested this in PT 8.54 and up? I can't seem to get it to work, though of course ExcelToCI says it does.
This worked out for Level 1 and so on. Can you guys let me know how to delete Level Zero?
My Page only has Level 0 only and planning to delete the data using ExceltoCI. is that possible?
Thanks for your post. But, it doesn't work in 8.56
Post a Comment