Importing images from excel.
I am working SRM MDM Catalog 2.0 and we need to publish the Catalog. Now the problem is we have to import the data from excel sheet and in the picture column only the name of the image file is stored.
That is suppose for a specific record in the picture column it may have only the imagename.jpg
I need to know that how do I import the images from excel sheet coz i guess Image Manager is also not available for SRM MDM Catalog.
Tell me if I can use MDM 5.5 SP4 Image Manager.
Thanx in advance
Serguei Zabrodski replied
Let me clarify. You need to import/upload image <b>files</b> into the Images table via <b>Data Manager</b>. Then you can import image <b>file names</b> (for appropriate records) via <b>Import Manager</b>. Here're the steps you need to go through in detail:
1. In Data Manager, table Images, Add a record.
Data Manager will display a dialogue box "Add Images". Here you can specify multiple image files to upload. Ensure the radio button "Store in Repository" is selected. Optionally, specify a Data group (to help organize your image file records in MDM - e.g., by supplier). Click OK - Data Manager will upload all your image files into MDM.
At this point, your image files reside on the MDM server, but are not associated with product records yet. I.e., you can view them in Images table, but not in Catalog Items table. On to the next step.
2. In Import Manager, connect to your source (e.g. Excel sheet with records), and import as normal. Note: in your source file, specify an image file name (e.g. "image.jpg") in the Image column against each product record for which an image file was uploaded earlier into MDM.
After the import is done, you'll be able to see the images in the Catalog Items table.
Hope this clarifies things.