How to populate cmn_location table with external application data

[Tamil5]

Hi All,

In our SNOW instance, location values are stored in cmn_location table.

Two lookup fields 'Caller Location' in Incident form & 'Location' field in the user(sys_user) form uses cmn_location reference and showing values (it has hierarchy as well. I really don't know how it is working).

Am not sure currently how the data is imported in this table. I could see some recently updated records, it might be a manual/systematic update.

Even I'm not sure, generally how 'cmn_location' table will be populated in SNOW.

My requirement is, I have all location details in our own custom application. With the help of API I'm able to retrieve the location details from that application.

I just tried to populate those data into my custom table(in SNOW).

Now I need to import the same data into 'cmn_location' table. Also I need to schedule the import process.

Every day a script should execute & get the data from my application & do insert/update the cmn_location records.

Any idea ?? Please advice.

Thanks

Prici

[Tamil5]

Update:

I just noticed that, there is a 'Table Transform Maps (Transform Maps)' with source table as 'imp_location' & Target table as 'cmn_location'.

But where it is scheduled & how it is executed every day and transferring data to 'imp_location' to 'cmn_location' ?

One more thing is, currently 'imp_location' is blank & how did 'cmn_location' got values ????

[Tamil5]

No reply yet...

[Giancarlo Perei]

I have exact the same question!