CA Service Management

 View Only

CA Service Desk Manager Load Category using pdm_load - pcat - Prob_Category - Prob_Ctg 

Jun 24, 2015 11:12 AM

Everthing about pdm_load for CA SDM Categories

 

Do you have some tip, please comment this DOC and we´ll improving our knowledge.

 

ITIL Definition: Category (v2, v3) Category (ITILv3): A named group of things that have something in common. Categories are used to group similar things together. For example Cost Types are used to group similar types of Cost. Incident Categories are used to group similar types of Incident.

 

 

 

Category (ITILv2):    Classification of a group of Configuration Items, e.g., hardware, Changes, Problems

 

 

 

1. 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.

 

2. pdm_load updates a CA SDM database using an input file you specify, up to a maximum of 112 attributes.

 

3. Syntax

This command has the following format:

pdm_load [-c] [-h] [-m] [-r] [-u] [-v] -f filename

 

4. File Format

 

The input file entries follow this format:

TABLE table_name fieldname1 fieldname2 . . . . fieldnameN { "value11", "value12", . . . "value1N" } { "value21", "value22", . . . "value2N" } . . . { "valueN1", "valueN2", . . . "valueNN" }

 

Do you need use accents? Save text file in UTF-8 format.

ERROR for accents: Invalid character encountered in input

 

5. BACKUP

 

 

BACKUP COMMAND
pdm_extract Prob_Category > Prob_Category.txt

 

 

 

 

6. Bulding our input file (Download Excel input file Schema)

 

6.1 Required Fields (SYM and SS_INCLUDE)

       SS_INCLUDE ::. ERROR: error 8 on update: Table Prob_Category is missing value for ss_include

      

TABLE Prob_Category

sym ss_include

{"category.type.item", "0"}

 

For each "." we´ll see a new level.

 

{"Software.Environment.DOS", "0"}

CASDM_20150624_pcat.jpg

 

Save your file, example: load_category.txt

 

7. Input command

 

pdm_load -i -f load_category.txt

 

What means i and f?

 

-i ==> Insert

 

-f  ==>  filename Specifies an input ASCII file.

 

8. Do you have tenants?

 

Use t parameter

 

-t ==> Specify your tenant name, for example: -t CA (pdm_load -i -f load_category.txt -t CA)

 

9. Structure table

bop_sinfo -dq pcat

Factory pcat < Prob_Category >

Attributes:

   id                   INTEGER UNIQUE

   producer_id          LOCAL STRING(20)

   persistent_id persid STRING(30)

   delete_flag del      SREL -> actbool.enum REQUIRED

   sym                  STRING(1000) REQUIRED SKEY

   last_mod_dt          DATE

   last_mod_by          SREL -> cnt.id TENANCY_UNRESTRICTED

   description          STRING(500)

   organization         SREL -> org.id

   assignee             SREL -> agt.id SERVICE_PROVIDER_ELIGIBLE

   group group_id       SREL -> grp.id SERVICE_PROVIDER_ELIGIBLE

   properties           BREL <- cr_prptpl.owning_area {owning_area = ?}

   survey               SREL -> svy_tpl.id

   auto_assign          INTEGER

   service_type         SREL -> sdsc.code

   category_urgency     SREL -> urg.enum

   owning_contract      SREL -> svc_contract.id

   cr_flag              INTEGER

   in_flag              INTEGER

   pr_flag              INTEGER

   suggest_knowledge    INTEGER

   assignable_ci_attr   STRING(60)

   service_grps         BREL <- lrel_svc_grps_svc_pcat.pcat (LREL cnt) {pcat = ?}

   service_locs         BREL <- lrel_svc_locs_svc_pcat.pcat (LREL loc) {pcat = ?}

   service_schedules    BREL <- lrel_svc_schedules_pcat_svc.pcat (LREL wrkshft) {pcat = ?}

   ss_include           SREL -> bool.enum REQUIRED

   ss_sym               STRING(128)

   flow_flag            INTEGER

   caextwf_start_id     SREL -> caextwf_sfrm.id

   cawf_defid           STRING(40)

   cawf_defname         LOCAL STRING(0)

   cawf_desc            LOCAL STRING(0)

   cawf_active          LOCAL STRING(0)

   cawf_effective       LOCAL INTEGER

   cawf_cache           LOCAL DATE

   ebr_doc_blc <>       STRING(0)

   ebr_serial_num <>    STRING(0)

   ebr_relevance <>     STRING(0)

   ebr_ks_teaser <>     STRING(0)

   ebr_ks_concepts <>   STRING(0)

   ebr_search_in <>     STRING(0)

   ebr_fuzziness <>     STRING(0)

   ebr_match_type <>    STRING(0)

   ebr_search_text <>   STRING(0)

   ebr_primary_order <> STRING(0)

   ebr_order_direction <> STRING(0)

   ebr_search_type <>   STRING(0)

   sap_prop             INTEGER

 

 

Structure load: pdm_extract pcat

TABLE Prob_Category

assignable_ci_attr assignee auto_assign caextwf_start_id category_urgency cawf_defid cr_flag del description flow_flag group_id id in_flag last_mod_by

last_mod_dt organization owning_contract persid pr_flag sap_prop schedule service_type ss_include ss_sym suggest_knowledge survey sym tcode tenant

 

 

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

 

REFERENCES:

pdm_load 

https://support.ca.com/cadocs/0/CA%20Service%20Desk%20Manager%2012%207-ENU/Bookshelf_Files/HTML/CA_SDM_Admin_ENU/pdm_load_add_update_and_delete_database_records.html?intcmp=searchresultclick&resultnum=2492

 

 

http://www.itsmsolutions.com/newsletters/DITYvol6iss27.htm

 

http://www.knowledgetransfer.net/dictionary/ITIL/en/Category.htm

Statistics
0 Favorited
18 Views
0 Files
0 Shares
0 Downloads

Tags and Keywords

Comments

Aug 09, 2016 08:23 AM

This great doc and a detailed info on pdm_extract and load commands.

 

Great Work!

Aug 04, 2016 04:08 PM

Hi Airu ,

 

To load group on category: It's simple like type the group, using the example (CA Service Desk Manager Load Category using pdm_load - pcat - Prob_Category - User view Prob_Ctg Category.xlsx))

 

 

TABLE Prob_Category
sym ss_include in_flag cr_flag pr_flag ss_include group_id
{"Category.type.item","0","1","1","1""0", "XXXXXXXXXXXXXXXX"}

 

But to load the location, i need to build another document because it's a related table.

 

Regards

Tiago Macul

Aug 02, 2016 05:40 PM

Thanks for sharing this, Tiago.

 

But I would like to complement with a question: where we can load the configuration details of this table? For example, I need to load the locations and groups that this table can be used for auto assignment. How do I proceed in this case?

 

Regards.

Jul 30, 2015 04:18 PM

Thanks for sharing this.

Related Entries and Links

No Related Resource entered.