CA SDM Loading group members pdm_load

Document created by TMACUL Champion on Sep 4, 2015Last modified by TMACUL Champion on Sep 4, 2015
Version 2Show Document
  • View in full screen mode

The first thing what you need know: VERY Important! Using pdm_load can be destructive so always back up your database before you perform a pdm_load, and use pdm_userload unless instructed to use pdm_load.


Important! Make a backup copy of the database before running pdm_load with this option. After old database records are removed, you must restore the CA SDM database with this backup copy if you want to recover any deleted records, use pdm_extract for this procedure.


BACKUP COMMAND - pdm_extract
pdm_extract grpmem > grpmem.txt

2. Structure table

bop_sinfo -dq grpmem

Factory grpmem < Group_Member >


  id                  INTEGER UNIQUE

  producer_id          LOCAL STRING(20)

  persistent_id        LOCAL STRING(60)

  group group_id      SREL -> SERVICE_PROVIDER_ELIGIBLE

  member              SREL -> SERVICE_PROVIDER_ELIGIBLE

  manager_flag        INTEGER REQUIRED

  notify_flag          INTEGER REQUIRED

  tenant              SREL -> REQUIRED

3. Standard for Load file

Structure load: pdm_extract Group_Member

TABLE Group_Member

        group_id id manager_flag member notify_flag tenant

        { "4C69D3C49215714D950A612868EA7AC4" ,"400101" ,"0", "A65ECAF15EEA77408CF6D6619633E7C5" ,"1" ,"E4B34CE60B85894190B2B693834E8502" }



SQL Commands - Group member

select * from grpmem

select grpmem.*,

  grp.last_name as group_name ,


from grpmem

inner join ca_contact as grp on grpmem.group_id = grp.contact_uuid

inner join ca_contact as mem on grpmem.member = mem.contact_uuid


4. Load procedure to ready file


TABLE Group_Member

        group_id manager_flag member notify_flag tenant

        { "4C69D3C49215714D950A612868EA7AC4" ,"0",

"A65ECAF15EEA77408CF6D6619633E7C5" ,"1" ,"E4B34CE60B85894190B2B693834E8502" }

1. Create the load file load_grpmem.txt
2. pdm_load -i  -f load_grpmem.txt


5. Load Procedure using names


TABLE Group_Member

email group

{"","Group name"}

01. Building origin file grpmem_origin.txt



input = email

output = member

rule = "select id FROM ca_contact WHERE email_address=?"


02.Building  spec file grpmem_cnt_spec.txt for contacts (analyst)

TABLE Group_Member

      member group



     { "3E55B7C5F73ACC43A970D6BB3ADF923A", "Group name" }

03. pdm_deref -v -s grpmem_cnt_spec.txt < grpmem_origin.txt > grpmem_step_02.txt
go to second phase
04. Using the last exit the grpmem_step_02.txt file



input = group

output = group_id

rule = "select id FROM ca_contact WHERE last_name=?"


05. Bulding spec file grpmem_grp_spec.txt for groups

TABLE Group_Member

      member group_id



     { "3E55B7C5F73ACC43A970D6BB3ADF923A",

     "7471CB24ADE7A340B1E631F4141DF99F" }

06. pdm_deref -v -s grpmem_grp_spec.txt < grpmem_step_02.txt > grpmem.txt

TABLE Group_Member

      member group_id manager_flag notify_flag



     { "3E55B7C5F73ACC43A970D6BB3ADF923A",

     "7471CB24ADE7A340B1E631F4141DF99F", "0", "0" }

07. include on file manager_flag notify_flag

08. pdm_load -i  -f load_grpmem.txt

if has tenant you can use:

pdm_load -i  -f load_grpmem.txt -t "Tenant Name"





CA SDM Loading groups pdm_load

CA SDM Loading contacts pdm_load

DEREF - pdm_deref - Everthing do you need know

CA SDM Load department using pdm_load - dept - ca_resource_department

CA Service Desk Manager Load Category using pdm_load - pcat - Prob_Category - User view Prob_Ctg Category.xlsx

3 people found this helpful