Export and Import product attachments (Doc ID 499581.1)

Last updated on JANUARY 12, 2016

Applies to:

Siebel Enterprise Integration Manager - Version 7.5.3.2 [16168] and later
z*OBSOLETE: Microsoft Windows 2000
Product Release: V7 (Enterprise)
Version: 7.5.3.2 [16168]
Database: Microsoft SQL Server 2000 SP3
Application Server OS: Microsoft Windows 2000 Server SP 3
Database Server OS: Microsoft Windows 2000 Server SP 3

This document was previously published as Siebel SR 38-2580551761.
***Checked for relevance on 23-Jun-2014***


Symptoms

I need help in importing attachments for Products.
I have many versions of attachments attached to each product. In our current production we have no versions on the products but we have versions on product attachments.
Now we also introduced version on Products and we want to remove the attachments from our old products and add corresponding version attachments under new products with version.
I would like to do this using EIM.
I would like to Export all product attachments with current product and then associate the attachments with new product version and import into Siebel then delete the attachments from old products.
I referred bookshelf and found the steps but I do not understand how row in S_PROD_ATT associated to file in File system. Attachments in fs\att folder have files in the format of ‘S_PROD_INT_ATT_1-22OW-156_1-22OR-4Q.SAF’.
Please let me know steps to achieve this functionality.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms