MASS UPDATE IN MDM

[ShockerWil]

Hi Experts,

I would like to know if it is possible to mass update record based on vendor/customer/material no?

Is there a step-by-step guide or reference using Import manager to mass update?

Thanks!

[Former Member]

Hi,

Yes we can Mass upload the data on the basis of Customer/Product/Vendor Numbers.

I would like to one thing how do you want to make this changes happen ? is it once or there would be periodic uploads for this

if it is once then follow below process

Create the Upload file in excel or in text format and add all the data which you want to upload or update and also add Customer/Product/Vendor number as this would be unique filed and all the records would be identified by this numbere as defined your matching and merging strategy.

Once you have imported the data into import manager Map the fileds and do the value mapping and go to import step see for any error if no error and if system shows you that all records are exact match then just selct the import action as update match fields and then import the recrods

If you want periodic Mass updates then please follow below process

Through Java code or by file file transfer mechanism place the file in MDM's inbound folder, but before that please create Remote system and ports for this and then only place this file at regular time interval. Create the import the map and this map should be assigned to this port. by creating the import map you would be slecting the filed and value mapping and selecting the import action and make the necesary setting in data manager and in console like at what time interval you want to process this files.

if you have any doubts then please revert back.

Thanks and Regards

Praful

[former_member207367]

Hi

we can definetly do that, Mass update for a record can happen based on Material/Customer/Vendor Number

Step 1 : Get your source data in an Excel , Delemited File or in an XML format

Step 2: Open import manager and select your Source file type, remote system and your File Name of the source file

Step 3: Select your Source table and Destination table, in Source preview tab you can see the source data and count of records in the source file.

Step 4: Under your Map fields/Values tab Map your source fileds and destination fields. value mapping also need to be done if you have any lookup values in your data model.

Step 5: Under Matching Fields tab select your mapped destination fields in your case Material/Customer/ Vendor Number Automatically in Default import action's you can see your count of records(Which are unique) with Different Match Types.

If you are importing a record for the very first time you can see the Match Type as None, when you try to update some record which already exist in the repository your Match type will be Exact.

Based on the Match Type you can select what action to be taken. For update there are two option's

1. Update (NULL Fields Only)

It upates the Fields which has a "NULL" Value, it does not Update the records for which already there is an Field value.

2. Update (All Mapped Fields)

It updates the new values of the source file to all records which are mapped, in short it will replace the old value with new value(from your source file).

Please let us know if any help required.

Thanks

Sowseel