Skip to Content
author's profile photo Former Member
Former Member

Change/new/delete highlighting during import process

Hi everyone,

I intend to use SAP NW MDM to consolidate master data from external sources.

During the import process, I would like to see a highlighting of all new, of all deleted and of all changed records. The reason herefore is the following: before I actually load the imported data into my MDM repository, I want to check the data. Just in case, some corupt data was loaded.

Can I do this in the MDM Import Manager?

Best regards, Daniel

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 28, 2008 at 12:19 PM

    Hi Daniel,

    I dont think highlighting of records can be done in import manager.But might be it can be done in data manager with the help of workflows.

    Thanks,

    Minaz

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Daneil,

      Whenever a new record is added or updated MDM can show the time, create and user stamps for it. You just have to create three extra field in console with data type as Createstamp,Userstamp and Timestamp and assign it to the tables.

      And then whenever any changes are made it will show the stamps. Create stamp will happen only when a new record is added and it wont work if you are updating the records.

      If you want to run workflows on those newly added record or on updated records you can create workflows with the trigger action as Record Add(runs whenever records are added) and Record Update(runs when records are updated). This workflow can help you keep track of records with which you can afterwards either delete or make other changes to it according to your requirement.

      I hope I am able to solve your problem

      Regards

      Dilmit Kaur Chadha

  • author's profile photo Former Member
    Former Member
    Posted on Jan 28, 2008 at 02:30 PM

    hi,

    Whenever an imported record is new or changed, a timestamp could be set (which is most likely set already anyway). After importing the data I could run a routine which shows me all records that have not been updated. I could then delete these records or set them as "inactive".

    What do you think about this workaround? Is it feasible in MDM?

    Yes this is feasible in MDM. Whenever one record is changed / updated by user, the record will be updated along with the timestamp.

    you can view this in data manager.

    if you want to select some records and mark them as inactive, you have to create a field.

    hope this may help you,

    Regards,

    Srinivas

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 28, 2008 at 12:15 PM

    Hi Daniel,

    You can do this in Import Manager's "Record Matching" tab. It all depends on the field on which you are doing "Record Matching".

    There is "Match Type" column which will give you an idea if the record is a new record or is an updated version.

    All with "Match Type" None are new records coming into MDM and all with "Match Type" Exact are changed vesions of records in MDM.

    We cant make out for deleteed records.

    Regards,

    Amol.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 28, 2008 at 12:16 PM

    Hi Daniel,

    I dont think highlighting of all new, of all deleted and of all changed records is possible in Import Manager.

    But u can see in "Match Records" Tab how many new records are there & how many changed records are there,

    Thanks,

    Maheshwari.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.