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.

 

8 responses to this post.

  1. Posted by Babita on July 12, 2012 at 8:19 PM

    Hi,
    I am unable to extract the IFB file from the word file. Can you please email me urgently.
    Thanks and Regards,
    Babita

    Reply

    • Hello Babita

      I have updated the word file and added the IFB code directly in it. Please download it again.

      Let me know in case of any concern.

      Thanks
      Suansh

      Reply

  2. Posted by msvr on May 21, 2013 at 3:48 PM

    This is great – i have one other question – is there any way to rename the extracted the file with custom file name? I mean I want the extracted attachment (from .SAF) to be appended with its row_id… how can I achieve this?

    Reply

    • Dear Reader,

      In that case you would need to follow the custom script approach.

      I did my research on this approach long time back but the performance was very poor for 1000+ attachments. You can download a sample e-script at: http://wp.me/a17snX-9a

      You can further modify the move (mv) command in this script to specify custom file name as per your requirements.

      Let me know in case you need additional information.

      Regards
      Suansh

      Reply

    • As next steps – you would need to verify the details of extracted attachment files against the details in S_OPTY_ATT table, so as to be sure that none of the file is missing.

      If your attachment files have been extracted on a windows machine, then you can easily convert the windows file system information into an excel sheet using our File Enumerator tool at https://crackingsiebel.com/2011/01/30/utility-tool-file-enumerator/

      Regards
      Suansh

      Reply

      • Posted by vamsi. on February 5, 2014 at 3:46 PM

        Hi,

        I need to archive the SR’s along with the attachments and should be able to reload the same in siebel when needed. How this can be achieved? Will it have any impact in future releases.

        Also, if the attachments extracted what will be the attachment names in the extracted folder (ouput) and how can we identify which file is pointing to which SR.

        Regards,
        Vamsi.

  3. Posted by Shauryanaditya Singh on January 10, 2017 at 2:24 PM

    Hi,

    Can you guide me with steps on how to do this?
    I am confused where to use iFB code given by you.

    Reply

    • Posted by Kaushik on March 9, 2017 at 9:46 AM

      Hi Shauryanaditya,
      It seems you don’t know EIM. If you learn how to perform data operations using EIM, you will know how to use the IFB code. Hope this helps.
      Let me know if you have any more doubts.
      Thanks and regards,
      Kaushik

      Reply

Appreciate your feedback

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: