ADD FIELDS TO PDM_UPLOAD

[Amosu Babatunde]

Hi everyone,
Good day and trust we are doing good today,
Please I need assistance on pdm_upload functionality. I intend to load categories on CA SDM 17.1 with Service Type field, Group and some other major fields populate automatically.
What we mostly do after we have uploaded the request categories is that we manually opened each category and attach service type and groups to it which takes us sometimes more than 2days to complete because we uploads almost 200 requests areas weekly for now.
It will be appreciated if someone out there could help save a brother with necessary syntax to add in my script to accommodate the required field rather than spending productive hours doing manual work.

Thanks while I awaits prompt responses.
Warm Regards,
Amosu

[Brian Mathato]

Hi Amosu,

The basics are that you cannot reference any other records if they don't exists. So when you look at your final data that you want to upload, if there are several fields that reference other tables, then those records\tables being referenced must be loaded first. Once that is done the you can use the deref command\utility. There are various classic examples that you can follow. See below links:

https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/business-management/ca-service-management/17-2/administering/configure-ca-service-desk-manager/managing-your-database/how-to-use-pdm-deref-example.html

https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/business-management/ca-service-management/17-2/administering/configure-ca-service-desk-manager/managing-your-database/data-dereferencing.html





------------------------------
Kind Regards,
Brian
------------------------------