Automap Values feature for Manual Import

[Former Member]

Hello Experts,

We have a Import Map, which the end users uses to do Mass inserts into the Main table as & when required. The end user runs the Import manually from the Import Manager.

We have about 20-25 columns which are of type lookup flat. Hence every time any new values are added to these columns in the source, the user would have to manually go and click on the Automap for values for all the necessary fields.

Is there any property which we can set so that, the Import map automatically performs an value Automap for all the lookup fields when it is loaded?

The source file format is an excel template provided to the user.

We are currently using SAP MDM 5.5 SP06 (Version 5.5.63.73)

Thanks in Advance

Regards,

Uday

[Former Member · Accepted solution]

Hi Uday,

Just check if this happens for all the lookup tables or the only ones used for Matching Records. For second case, use some different matching keys and try the import. Automap feature is available for MDIS only.

Regards,

Jitesh Talreja

[Former Member · Accepted solution]

Hi Jitesh,

The lookup fields I'm referring to are not part of Match fields.

Thanks for confirming that Automap does not work for manual imports.

Regards,

Uday

[former_member189669]

Hi Uday,

Refresh all the lookup tables in MDM with remote key mappings.

Then perform perform manual import to Main table. All the Lookup field values will auto map.

Regards,

Vinay M.S

[Former Member]

Hi Vinay,

Thanks for the reply.

We are not using the remote keys or key mappings.

There is a property in Configuration Options where we can set the Value Autmap functioanlity for MDIS Imports. I want to know if a simillar feature exists for Manual Imports as well.

Thanks & Regards,

Uday

[former_member189669]

Hi Uday,

Under same configuration optiosn choose and select appropriate values for -

Default MDIS Handling > a. Automap Unmapped handling > Yes

b. Unmapped Value handling > Add

Regards,

Vinay M.S

Edited by: Vinay Simha on Nov 5, 2009 7:30 PM