CA Service Management

Dears;

iam trying to update more than 24000 contacts with notification methods as email; but i can't do that.

my file is looks like the follow

TABLE usp_contact
id c_cm_id1 c_cm_id2 c_cm_id3 c_cm_id4
{"0x00017EDCC10B3D47A26CA4E91CB8FA39","1800","1800","1800","1800"}

i ran the following command:

pdm_load -u -f c:\usp_contacts2.txt

but i got the below error

Null field in logical key --cannot be used for update:
id: [00]
c_cm_id1: [1800]
c_cm_id2: [1800]
c_cm_id3: [1800]
c_cm_id4: [1800]

your help is highly appreciated.

Best Regards;

Mohamed El-Fahd

Hi Mohamed,

The issue is with the format of the id field.The format should be U'xxxx. So update your input file to look as follows:

TABLE usp_contact
id c_cm_id1 c_cm_id2 c_cm_id3 c_cm_id4
{"U'17EDCC10B3D47A26CA4E91CB8FA39","1800","1800","1800","1800"}

Kind Regards,

Brian

Thnx brian for your update, i tried your suggestion and replaced all the 0x00 with U' and any 0x0 with U' but sill doesn't work

Best Regards;

Mohamed El-Fahd  

Hi Mohamed,

Remove the U. Sorry my bad.

Did you try with 'pdm_userload' as well?

Also have a look at this tech doc which might help:

How can I load new users in bulk directly in the MDB database? 

Loading data with the pdm_load utility into an object that is linked to more than 1 table creates UUID conflicts. 

===

Kind Regards,

Brian

Hello,

I just tried this and it worked fine.  The syntax of my load file:

TABLE usp_contact
id c_cm_id1 c_cm_id2 c_cm_id3 c_cm_id4
{ "016BBC2CE538094F8C77F4DF26AB3C89" ,"1800" ,"1800" ,"1800" ,"1800" }
{ "16226C765005B94E957E0F477DEF1B1C" ,"1800" ,"1800" ,"1800" ,"1800" }
{ "17DEA1027C7C3746B6F25DB6604EEE23" ,"1800" ,"1800" ,"1800" ,"1800" }

I was wondering if you could confirm if the id values you are feeding in are valid.  

The following is an alternative approach to potentially addressing the problem of the data load but should only be done after you have fully backed up your existing database.

One thing I also did to reverse engineer the content being loaded was to do a full extract of all usp_contact records and modify the resultant output to update the notification methods across the board.

First, I ran:

pdm_extract -f "Select id, c_cm_id1, c_cm_id2, c_cm_id3, c_cm_id4 from usp_contact" > mod1.dat

Then I edited the generated mod1.dat file and changed the four text fields at the end of each line to have the notification methods set, and then loaded the updated mod1.dat file back in.

Hello

I tried the suggested solution but still not working

On Tue, Oct 10, 2017 at 8:32 PM ritri01 <

Mohamed, the error told you what was the problem:

Null field in logical key --cannot be used for update:
id: [00]

...

that is, pdm_load was not able to read and validate the id entry here ("0x00017EDCC10B3D47A26CA4E91CB8FA39")...how you got this value?

can you try "00017EDCC10B3D47A26CA4E91CB8FA39"? Thanks _Chi

Thnx chi for ur reply I got this value through running pdm_extract usp_contact > usp.txt

I will try your suggestion tomorrow and I will keep you updated

Sent from my iPad

Please try this in a TEST environment

Back up usp_contact table first by running

pdm_extract usp_contact > uspContact_bak.txt

The following pdm_extract command will give you all the current records with their notification methods. Note that the commands below will not copy and paste well, due to ‘smart quotes’ and other non-ASCII characters. Re-type rather than copying and pasting:

pdm_extract –f “select id, c_cm_id1, c_cm_id2, c_cm_id3, c_cm_id4 from usp_contact” > myUspData.txt

Replace all of the c_cm_idx fields with “1800” and then run

pdm_load –vf myUspData.txt

Hi m.fahd,

Have you been able to test this in a test environment as per Paul's advisement?  Please let us know if it worked or if you still need help with it.

Thanks,

Jon I.

Thank you all guys, its working like charm now... much appreciated

On Wed, Oct 11, 2017 at 9:28 PM Jon_Israel <

You are welcome sir!  Any time