CRM On Demand - Administration (MOSC)

MOSC Banner

Data loader inserts duplicate records

edited Dec 12, 2011 8:17PM in CRM On Demand - Administration (MOSC) 1 commentAnswered
Hi,  
There is an import that we need to run everyday in order to load data from another system into CRM On Demand . I have set up a data loader script which is scheduled to run every morning. The script should perform insert operation.
 Every morning a file with new insert data is available in the same location(generated by someone else) & same name. The data loader script must insert all records in it.

One morning , there was a problem in the other job and a new file was not produced. When the data loader script ran , it found the old file and re-inserted the records (there were 3 in file). I had specified the -duplicatecheckoption parameter as the external id, since the records come from another system, but I came to know that the option works in the case of update operations only.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center