Thank you Sebastian, I wasn't using the insert option. It is now loading.
Original Message:
Sent: Sep 17, 2024 12:25 PM
From: Sebastian Nagy
Subject: Load Multiple contacts using pdm_load or RestAPI
Hi Arnab,
First of all, contact `15718`is not a valid id.
Seconds, try "pdm_load -i -f D:\ContactLoadTest.txt"
Sebastian
Original Message:
Sent: Sep 17, 2024 11:20 AM
From: Arnab M
Subject: Load Multiple contacts using pdm_load or RestAPI
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