Delete while import

[former_member283645]

Hi Experts,

I have a table with multiple fields init.

I need to syndicate the data init end of every day.

Once syndicated i need to clear the table.

Any ideas!!!

PI will pick the file which is syndicated and sends it to end user.

I asked PI to drop it again in the inbound folder so that in the import map i can configure like If i find matching records then delete the destination records.

Is it possible??

In the matching records tab i can see all the records are in ''EXACT'' and i dont see a delete option!!

Moreover if i manually select the Delete option in the Destination records table which is in the bottom of the same TAB, this will not work in Automatic import mode becoz i am changing the status manually to 'delete'

Can anyone help me..

Kind Regard

Eva

[Former Member · Accepted solution]

Hey

One solution could be to trigger the syndication through a workflow.

Configure a workflow and add a Syndication and then an Assignment step to it, in the syndication step, send the file to ready folder, in the assignment step, assign Null or 0 to the init fields.

Thanks

Aamir

[Former Member]

Hi Eva,

The best way to delete the records from MDM after syndication would be the use of API's.

You could read this article:

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/c0ac4844-02a5-2c10-eca3-c249fd01d...

Update the records syndicated by re-importing the file. Use a flag field for this purpose. And with the API delete only those records have the flag set to true.

Hope this helps.

Regards,

Aditya

[former_member283645]

Hi all,

Problem solved.

But instead of using API'S, I played a small trick in Import manager.

Well As i mentioned my requirement is to delete all the records in the table when they are syndicated to Ecc via PI.

I asked PI to send the same file syndicated to MDM inbound folder.

I have a field called STATUS which has value as ACTIVE for all the records.

So once i import the file In Import manager I converted the value 'ACTIVE' to 'INACTIVE' (at value mapping tab).

And in matching fields i selected STATUS FIELD and Filtered with 'ACTIVE'.

Now in Default Import actions box i selected Destination - Match type, Delete - Default Import Action.

Once i press Import all the records in My table are deleted.

Thanks for the support

Kind Regards

Eva

[Former Member]

Hi ,

I have a requirement to delete the Sub tables which is of both Lookup [Flat] and Lookup [Hierarchy]

For the Lookup[Flat], it is easy to select all the records and delete. But for Lookup [Hierarchy], i am couldnt able to do in that fashion

I have tried deleting using import manager, the delete option is disabled.

Can u please me on this regard

Regards,

Antony

[Former Member]

Hi,

I think you can use the functionality destination record import action.You can set the import action for destination records and override the inhertiance from both the default import actions grid and the matching source record.In the destination records grid, you can select the delete option for the records which you want to delete.

Please go through 376 page (Setting a destination record import action) under Part 11:Matching Records in import manager reference guide.

Thanks,

Narendra

[former_member207367]

Hi Eva

If your table is a qualified table you can delete by right click on your qualified table and selecting the option SET QUALIFIED TABLE UPDATE.you can select your Matching fields under the options NEW select SKIP which will not create any entry and under option EXISTING LINKS option select DELETE. Which will delete your matching records

Hope this helps you.....

Thanks

Sowseel