Hi Folks,
I have created a rude powershell script to transform get item to global_value as in the example below.
I use it to create the global values for a table.
You fell free to get it and improve it.
https://github.com/angeloluciani/powershell
FROM
get-item 2001 | get-property "values['RemitNotificationStep']" | equals "" | verify-true
get-item 2001 | get-property "values['CpidCodeType']" | equals "*LEI" | verify-true
get-item 2001 | get-property "values['LoadType']" | equals "*BL" | verify-true
get-item 2001 | get-property "values['OtherCPEEA']" | equals No | verify-true
get-item 2001 | get-property "values['Deleted']" | equals No | verify-true
get-item 2001 | get-property "values['VenueOfExecution']" | equals XXXX | verify-true
get-item 2001 | get-property "values['CommercialorTreasury']" | equals Yes | verify-true
get-item 2001 | get-property "values['ReasonText']
TO
global [val property_CpDomicile "values['CpDomicile']"]
global [val property_ModifyUser "values['ModifyUser']"]
global [val property_EmirNotificationStep "values['EmirNotificationStep']"]
global [val property_TradeStartDate "values['TradeStartDate']"]
global [val property_Regulation Set "values['Regulation Set']"]
global [val property_ExecutionDate "values['ExecutionDate']"]
global [val property_BeneficiaryId "values['BeneficiaryId']"]
global [val property_EmirReportMode "values['EmirReportMode']"]
[Updated on: Mon, 19 October 2015 04:50] by Moderator
Home