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.
1. BACKUP
| BACKUP COMMAND - pdm_extract |
|---|
| pdm_extract grpmem > grpmem.txt |
2. Structure table
| bop_sinfo -dq grpmem |
|---|
Factory grpmem < Group_Member > Attributes: id INTEGER UNIQUE producer_id LOCAL STRING(20) persistent_id LOCAL STRING(60) group group_id SREL -> grp.id SERVICE_PROVIDER_ELIGIBLE member SREL -> cnt.id SERVICE_PROVIDER_ELIGIBLE manager_flag INTEGER REQUIRED notify_flag INTEGER REQUIRED tenant SREL -> tenant.id REQUIRED |
3. Standard for Load file
|
TABLE Group_Member group_id id manager_flag member notify_flag tenant { "4C69D3C49215714D950A612868EA7AC4" ,"400101" ,"0", "A65ECAF15EEA77408CF6D6619633E7C5" ,"1" ,"E4B34CE60B85894190B2B693834E8502" } |
|
select * from grpmem |
select grpmem.*, grp.last_name as group_name , mem.last_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
| code | Description |
|---|
TABLE Group_Member email group {"my@emailaddress.com","Group name"} | 01. Building origin file grpmem_origin.txt |
Deref { 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 |
Deref { 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