CA Service Management

 View Only
  • 1.  Load Multiple contacts using pdm_load or RestAPI

    Posted 27 days ago
    Edited by Arnab M 27 days ago

    Hello,

    I need to load new contacts which will include only the last_name and contact_type "Vendor". I tried to use pdm_load and I see the below error. I believe there is additional information I need to provide in the import. The data is available only in excel. Is there another way to load this data? 

    ```

    TABLE ca_contact
        last_name contact_type 
        { " Achini" ,"2305" }
        { "22ND STREET SO. OFF RAMP" ,"15718" }

    C:\Windows\system32>pdm_load -f D:\ContactLoadTest.txt
    command = D:\PROGRA~1/CA/SERVIC~1\bin\dbload  D:\CONTAC~2.TXT
    ca_contact: Incomplete logical key.
    ERROR: Cannot create mapping for table (ca_contact)
    ERROR: Skipping table.

    ```

    Thank You,

    Arnab



  • 2.  RE: Load Multiple contacts using pdm_load or RestAPI
    Best Answer

    Broadcom Employee
    Posted 27 days ago

    Hi Arnab,

    First of all, contact `15718`is not a valid id.
    Seconds, try "pdm_load -i -f D:\ContactLoadTest.txt"

    Sebastian




  • 3.  RE: Load Multiple contacts using pdm_load or RestAPI

    Posted 27 days ago

    Thank you Sebastian, I wasn't using the insert option. It is now loading.