Skip to Content
0
Former Member
Apr 20, 2010 at 12:37 PM

Mass update in MDM

103 Views

Hi All.

Request your solution on mass update in MDM as per following scenario. We are maintaining Supplier master in MDM. We are using MDM 5.5 SP06 version.

We want to update Master Data based on excel sheet we are getting from the business. That excel sheet typically contains the vendor numbers for which some field need to be deleted. E.g. sheet will contain 100 records. For 60 records we have to delete field value say u201CTax code1u201D and for 40 records we have delete say u201CTax code 2u201D.

Please note that these fields keep changing and we cannot save maps for each field separately

These updates are handled by another team which is not from MDM capabilities (Typically backend team). So we donu2019t want the team to actually open the Import manager and do the mappings every time. Also the excel sheet used by business is having standard format (as per repository) but they will populate only vendor numbers in that sheet.

Can we automate the importing of such excel sheet and use the some workflow to take care of these updates.

Request your solution for this scenario.

Thanks in advance

Rahul Kulkarni

Edited by: Rahul Kulkarni on Apr 20, 2010 2:40 PM