Posts Tagged ‘Integration’

Siebel – How To Extract Attachments Using EIM

 

 

Scenario

During upgrade process, over 11,000 Opportunities were identified for migration. Also there were attachments associated with these opportunities.

 

Approaches

I short-listed following two ways to pull out the attachment files:

  1. Client-side Business Service
  2. EIM export

After initial POC, I settled down with EIM export option.

Reason – EIM job extracts the attachment files and place them at specified location. Now suppose if there are multiple files with the same name, what will happen? In this scenario, EIM job automatically appends file name with numerals (like 1, 2, 3 and so on) and further saves the file.

But with the client-side scripting, this scenario needs to be handled explicitly.

 

Solution

To download the required IFB file (enclosed in word document), click here >> ExtractOptyAttachments – IFB

Limitation: Only 1000 Row Ids can be specified at maximum in each IFB file. Therefore to extract attachment files for 11,000 opportunities, I had to prepare 11 IFB files and run each of them.