USING IMPORT MANAGER FOR MASS UPDATE

[ShockerWil]

Hi Experts,

Is there any step-by-step instruction on how to implement a mass update using the Import Manager? Creation of maps for destianation field and source field. I am currently using Excel.

Many thanks!

[Former Member · Accepted solution]

Hello SHOCKER_WDR

Mass update is the same process as standard import process.

Defference is only in import action conditions:

when you did first pass to import data usually you used import action "Create" for new records.

when you did another pass to import data usually you used import action "Update (NULL Fields Only)"

if you want to fill some empty fields in record which already present in repository

or "Update (All Mapped Fields)" if you want to update all mapped field

or "Replace" if you want to clear all records which already present in rerpository and rewrite it with new data from source.

Regards

Kanstantsin Chernichenka

[ShockerWil · Accepted solution]

Kanstantsin,

Do I need to create a remote port to have the import manager work?

Thanks!

[Former Member · Accepted solution]

Hello SHOCKER_WDR

Srini answered your question.

if you are working with Import manager .i don't think which you will have some problem in mass upload process.

Regards

Kanstantsin Chernichenka

[ShockerWil · Accepted solution]

Hi Kanstantsin,

Is there a guide for matching strategy?

Many thanks!

[Former Member · Accepted solution]

Hello SHOCKER_WDR

I don't know exacly what is you mean as "matching strategy".

List of your activities depend of list of your task:

System integration?

Harmonization?

Do you use unique keys from external systems in your repository or not?

Have you similar records from different external systems in repository or not?

Would you like harmonize master data to external system or not?

ets.

I can give you some recomentdations fo manual import:

1) prepare as-is to-be model befor start importing data

as-is - value from external system

to-be - value in your repository

2) when you make mapping(during the import) - save your map all times after make some changes

3) after you finished your import process export your map to file

4) two way for loading data with QLUT, LUT:

- loading QLUT than loading main table data with QLUT(LUT) links(one(or many) source for QLUT(LUT) one for main data)

- loading all from one source

5) check data after import by count of records, cound of LUT(QLUT) values.

In casee mass upload - use your saved map for that

Regards

Kanstantsin Chernichenka

Edited by: Kanstantsin Chernichenka on Feb 7, 2011 2:00 PM

[cweissheimer · Accepted solution]

Hello!

You can find lots of information on the MDM Import Manager Reference guide:

http://help.sap.com/saphelp_nwmdm71/helpdata/en/4b/72b8e7a42301bae10000000a42189b/MDMImportManager71...

Part 11: Matching Records - page 333

Regards,

Carlos

[Former Member]

Hi,

Please refer the article:

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/d0be83e4-a1e6-2a10-c1be-8395ae948...

Hope this may help you,

Regards,

Srini

[Former Member]

Hi,

For Manaual import using import manager inbound port is not required. You can connect to import manager and select excel file and do the import process.

For Automatic import using MDIS, inbound port to be created and import map to be attached to it.

Hope this may help you,

Regards,

Srinivas