CA Service Management

Hi Team

how can i add some new record in my custom field on detail_chg form. Custom table name is 'zcr_module' in which we have 4 columns 'id', 'last_mod_by', 'last_mod_dt' and 'zcr_module_name' as shown below screenshot.

i extracted this table from pdm_extract command. and want to add new data and then upload it from pdm_load -f command. I am little bit confuse to add data as how the date n time i would define in it?  please guide...seems like its generated auto. or should i manually put current date n time??

pls advise

Hi La-Qa,

When you're using pdm_load you don't need to provide id, last_mod_by, and last_mod_dt.  Remove those three attributes from your file.  Then run pdm_load -i -f crmodules.txt

Hi Grant

Thanks for your quick reply.

the screenshot doesnt contain any addition in the text file as of now.. now i want to add following items in this table

1.Corp Watch
2.CDT
3.SAP ERP
4.SAP Success Factors
5.Mobile App (will be replaced by Mobile Development)

do you get me now?

so according to the text file script...should i add like this for example below (compare above screenshot)

{ "4400031" ,"" ,"" ,"Corp Watch" }

??? im confused about the date n time ...wt would it be?

the below screenshot is from sql...should i add it from sql also? if yes ..how?

Hi,

No the format would be like this..

TABLE zcr_module
    zcr_module_name
    { "Corp Watch" }
    { "CDT" }

ok...like below is it fine??

the last 5 entries are new entries...the above one already exist. cool?

I would remove the duplicates from the load file.  If you don't you may end up with duplicated in the UI, unless the zcr_module_name field has a unique index on it.  Safer to just remove what you don't want to add though.

I got you Grant

one  last thing

i normally uses pdm_load -f command...but u included one more arguement ...i.e  pdm_load -i -f ..... wt  function of -i?

Well I thought the -i was for Insert, but I don't see it in the documentation so I must have made that up.

ok

Aamir...........

Do you have any further questions regarding this thread?

If not, please mark one of the answers as correct so that this thread can be closed.