How to mass upload Access Type for Contacts in contact Table

Products

• SUPPORT AUTOMATION- SERVER
• CA Service Desk Manager - Unified Self Service
• CA Service Desk Manager
• CA Service Management - Asset Portfolio Management
• CA Service Management - Service Desk Manager

Issue/Introduction

Customer has users in CA_CONTACT table, however there are no correspondece in usp_contact table with an "Access Type" code. How to mass update all the access type for all thos contacts?

Environment

Service Desk manager 14.x / 17.x

Resolution

Customer can do the following query to see all the Contact id that are present in ca_contact table and are not present in the usp_coontact table:

select a.contact_uuid "CNT", b.contact_uuid "USP" from usp_contact B FULL OUTER JOIN ca_contact A on b.contact_uuid=a.contact_uuid

This quesry will show what are the ca_contact id that don't exist in usp_contact table (and vice-versa).

For all those contacts that are present in the ca_contact table and are missing in usp_contact table, he can do an input file format to be uploaded in the usp_contact, like:

TABLE usp_contact
    c_acctyp_id c_available c_cm_id1 c_cm_id2 c_cm_id3 c_cm_id4 c_domain c_email_service
    c_nx_ref_1 c_nx_ref_2 c_nx_ref_3 c_nx_string1 c_nx_string2 c_nx_string3
    c_nx_string4 c_nx_string5 c_nx_string6 c_parent c_schedule c_service_type
    c_timezone c_val_req c_vendor c_ws_id1 c_ws_id2 c_ws_id3 c_ws_id4 confirm_save
    cost currency_type id integration_cnt ldap_dn profile_picture sap_personID
    
    { "10005" ,"" ,"" ,"" ,"" ,"" ,"" ,"" ,"" ,"" ,"" ,"" ,"" ,"" ,"" ,"" ,"" ,"", "" ,"" ,"" ,"" ,"" ,"" ,"" ,"" ,"" ,"" ,"" ,"", "16226C765005B94E957E0F477DEF1B1C" ,"1" ,"" ,"" ,"" }

This may contain one row for each contact id that need to be inserted with the correct "Access type" (in this case "10005" is "employee").

The command line to run to import the rows is:

pdm_load -v -i -f <input-file.txt> -n 

Important: to keep the id exact the same as the ca_contact table, the "-n" is REQUIRED