EPWP Support build 4.0.25 - kwantu/platformconfiguration GitHub Wiki

back

Data migration issues for EPWP

Page documenting the actions to be taken for data migration purposes.

Actions to take to update to version 4.0.25

  1. Migrate and fix the kwantuObjectId that is in the incorrect sequence

  2. Migrate and update the community configs

  • Map centroids
  • Community Permissions
  1. Update the data structure for the Apex role assignment For each community execute the following service. (Note that due to the time that it takes to
curl --noproxy "*" "http://localhost:8080/exist/rest/db/kwantu-resource/_tools/insertNewFieldIntoAllSDO.xql?setId=EPWPApexPublicbodyAuthorisers&setId_version=1&communityId=962dd628-36b5-4a41-b959-a6e8827b6a7e" >> curl.out

#prepare with the following query
SELECT CONCAT('curl --noproxy "*" "http://localhost:8080/exist/rest/db/kwantu-resource/_tools/insertNewFieldIntoAllSDO.xql?setId=EPWPApexPublicbodyAuthorisers&setId_version=1&communityId=',communityid,'" >> curl.out')
FROM community WHERE communityid NOT IN ('29000')



curl --noproxy "*" "http://localhost:8080/exist/rest/db/kwantu-resource/_tools/insertNewFieldIntoAllSDO.xql?setId=EPWPLocality&setId_version=1&communityId=962dd628-36b5-4a41-b959-a6e8827b6a7e" >> curl.out

#prepare with the following query
SELECT CONCAT('curl --noproxy "*" "http://localhost:8080/exist/rest/db/kwantu-resource/_tools/insertNewFieldIntoAllSDO.xql?setId=EPWPLocality&setId_version=1&communityId=',communityid,'" >> curl.out')
FROM community WHERE communityid NOT IN ('29000')



curl --noproxy "*" "http://localhost:8080/exist/rest/db/kwantu-resource/_tools/insertNewFieldIntoAllSDO.xql?setId=EPWPBudgetControl&setId_version=1&communityId=962dd628-36b5-4a41-b959-a6e8827b6a7e" >> curl.out

#prepare with the following query
SELECT CONCAT('curl --noproxy "*" "http://localhost:8080/exist/rest/db/kwantu-resource/_tools/insertNewFieldIntoAllSDO.xql?setId=EPWPBudgetControl&setId_version=1&communityId=',communityid,'" >> curl.out')
FROM community WHERE communityid NOT IN ('29000')


EPWPMontlyAttendanceReversal
curl --noproxy "*" "http://localhost:8080/exist/rest/db/kwantu-resource/_tools/insertNewFieldIntoAllSDO.xql?setId=EPWPMontlyAttendanceReversal&setId_version=1&communityId=962dd628-36b5-4a41-b959-a6e8827b6a7e" >> curl.out

#prepare with the following query
SELECT CONCAT('curl --noproxy "*" "http://localhost:8080/exist/rest/db/kwantu-resource/_tools/insertNewFieldIntoAllSDO.xql?setId=EPWPMontlyAttendanceReversal&setId_version=1&communityId=',communityid,'" >> curl.out')
FROM community WHERE communityid NOT IN ('29000')