+ Start a Discussion
nishanth0208nishanth0208 

Way to recognize a record inserted using Dataloader?

Hi All,

Is there a way to detect a particular record whether it was uploaded from Data loader or inserted through standard SF layout?

Ritesh AswaneyRitesh Aswaney

If you use a different User to load records in via DataLoader, then the CreatedBy would be  a way to tell. If not, then no.

The KnightThe Knight

Since anyone(profile) with API enabled permission  and the  create  permissions on the object can use Data loader and insert records.

1.If you are using External Ids only to be populated when data is created through dataloader, then you can have Not Null check on those fields.

2. If the above is not true then

    Create a field in each object like 'IsfromDataloader'

    Provide 'setvisibility' access to only those profiles which can access data loader. i.e those profiles which has API enabled and

    make sure that they populate this field when inserting records from dataloader.

 

These whatsoever fields should be visible(use field level security) to only those users who can access Dataloader and create records  through it.