Hi Kevin
I use the below extracts for categoris and workflows. I also extract macros and behaviors data as they may also be associated with the Workflow Tasks
Let us consider you have 2 servers.
Server 1 : New Server where you want to load the data
Server 2 : Old Server where you have your entire Categories and Workflow Data
1. ON SERVER 2 RUN THE BELOW EXTRACT STATEMENTS TO GET YOUR DATA.
Its better you move them to a folder called "Server2_Data"
pdm_extract Change_Category > chgcat.txt
pdm_extract usp_change_type > chgtype.txt
pdm_extract Service_Desc > sdsc.txt
pdm_extract Workflow_Task_Template > wftpl.txt
pdm_extract Behavior_Template > bhvtpl.txt
pdm_extract Property_Template > prptpl.txt
pdm_extract Property_Validation_Rule > prpvalrule.txt
pdm_extract Property_Validation_Type > prpvaltype.txt
pdm_extract Property > prp.txt
pdm_extract Workflow_Task > wf.txt
pdm_extract Task_Type > tsktyp.txt
pdm_extract Task_Status > tskstat.txt
pdm_extract usp_lrel_status_codes_tsktypes > lrel_status_codes_tsktypes.txt
pdm_extract Active_Boolean_Table > actbool.txt
pdm_extract Spell_Macro > macro.txt
pdm_extract usp_lrel_true_bhv_true > lrel_true_bhv_true.txt
pdm_extract usp_lrel_false_bhv_false > lrel_false_bhv_false.txt
pdm_extract usp_lrel_att_ctplist_macro_ntf > lrel_att_ctplist_macro_ntf.txt
pdm_extract usp_lrel_att_cntlist_macro_ntf > lrel_att_cntlist_macro_ntf.txt
pdm_extract usp_lrel_att_ntflist_macro_ntf > lrel_att_ntflist_macro_ntf.txt
pdm_extract usp_lrel_false_action_act_f > lrel_false_action_act_f.txt
pdm_extract usp_lrel_true_action_act_t > lrel_true_action_act_t.tt
pdm_extract usp_lrel_ntfr_macrolist_att_ntfrlist > lrel_ntfr_macrolist_att_ntfrlist.txt
pdm_extract usp_lrel_svc_grps_svc_wftpl > lrel_svc_grps_svc_wftpl.txt
2. RUN THE ABOVE EXTRACT STATEMENTS ON SERVER 1 AS WELL. Its better you extract the files into a folder called "server1_data"
3. NOW ON SERVER 1 REMOVE THE EXISTING DATA
From the command prompt change the directory to "server1_data" and run the below commands to clear the data
pdm_load -r -f chgcat.txt
pdm_load -r -f chgtype.txt
pdm_load -r -f sdsc.txt
pdm_load -r -f wftpl.txt
pdm_load -r -f bhvtpl.txt
pdm_load -r -f prptpl.txt
pdm_load -r -f prpvalrule.txt
pdm_load -r -f prpvaltype.txt
pdm_load -r -f prp.txt
pdm_load -r -f wf.txt
pdm_load -r -f tsktyp.txt
pdm_load -r -f tskstat.txt
pdm_load -r -f lrel_status_codes_tsktypes.txt
pdm_load -r -f actbool.txt
pdm_load -r -f macro.txt
pdm_load -r -f lrel_true_bhv_true.txt
pdm_load -r -f lrel_false_bhv_false.txt
pdm_load -r -f lrel_att_ctplist_macro_ntf.txt
pdm_load -r -f lrel_att_cntlist_macro_ntf.txt
pdm_load -r -f lrel_att_ntflist_macro_ntf.txt
pdm_load -r -f lrel_false_action_act_f.txt
pdm_load -r -f lrel_true_action_act_t.tt
pdm_load -r -f lrel_ntfr_macrolist_att_ntfrlist.txt
pdm_load -r -f lrel_svc_grps_svc_wftpl.txt
4. Now you will have to move the folder "server2_data" that you created in Step1 to "Server1" and then
from server1 command prompt change the directory to "Server2_data" and run the below commands to load the data
pdm_load -f chgcat.txt
pdm_load -f chgtype.txt
pdm_load -f sdsc.txt
pdm_load -f wftpl.txt
pdm_load -f bhvtpl.txt
pdm_load -f prptpl.txt
pdm_load -f prpvalrule.txt
pdm_load -f prpvaltype.txt
pdm_load -f prp.txt
pdm_load -f wf.txt
pdm_load -f tsktyp.txt
pdm_load -f tskstat.txt
pdm_load -f lrel_status_codes_tsktypes.txt
pdm_load -f actbool.txt
pdm_load -f macro.txt
pdm_load -f lrel_true_bhv_true.txt
pdm_load -f lrel_false_bhv_false.txt
pdm_load -f lrel_att_ctplist_macro_ntf.txt
pdm_load -f lrel_att_cntlist_macro_ntf.txt
pdm_load -f lrel_att_ntflist_macro_ntf.txt
pdm_load -f lrel_false_action_act_f.txt
pdm_load -f lrel_true_action_act_t.tt
pdm_load -f lrel_ntfr_macrolist_att_ntfrlist.txt
pdm_load -f lrel_svc_grps_svc_wftpl.txt
Hope the above helps
Regards
Nas