Excel Migration Job - Help to delete/remove records

Basically you can execute any procedure from the Migration Job. So what you did should be possible. However you do need to map the right keys into the remove procedure. e.g. it's asking for OBJID, OBJVERSION and ACTION (Action is ‘DO’). But they are not mapped. Both Source Column and Default value are empty. If you map the columns i think it should work.

Hi @MiLeNL 

I didn’t manage to create an excel_migration job which can delete records for scanner users. I tried to use a different migration job and was able to delete records with it. Instead i used a MIGRATE_SOURCE_DATA job and created two sql codes for deleting all records or only some of the users to a specific scanner. 

Appreciate your input - even though i didn’t manage to make it work through the excel_migration job. Thanks!

Br

@Christian Cordius I know this is late, pasting the solution that i draw here in case someone else is looking into this  :)

 

 go to method list attributes in the remove method 

and finally your source mapping should look like below

this will remove the sites as needed, what happens when you run the job is using the first method system will try to run an update then take the objid and version and pass it to the second method  (remove__). and using the objid and version system will remove the record that you want.

in the excel adding you can pass the USER id and contract that you want to remove  :).

Hope this helps.

kind Regards

Niyomal.