This discussion is archived
6 Replies Latest reply: Mar 23, 2012 2:36 PM by 915392 RSS

Export file Attachments in Siebel

619699 Newbie
Currently Being Moderated
hi ,

we have a requirement to export siebel attachment from Siebel eclinical application. The entity relation is between activity and attachments.
When i am trying to export the files attachments using the following IFB code

[Siebel Interface Manager]

     USER NAME = "sadmin"
     PASSWORD = "****"
     PROCESS = "EXPORTATTACHMENTS"

[EXPORTATTACHMENTS]

     TYPE = EXPORT
     TABLE = EIM_ACT_DTL
     BATCH = 2
     ATTACHMENT DIRECTORY = "f:\sia81\CTMS\siebsrvr\OUTPUT"
     EXPORT ALL ROWS = FALSE
     EXPORT MATCHES     = S_ACTIVITY_ATT,( FILE_NAME LIKE "MarcRendell-PS%")

When runnign this ifb following is the observation
1) the process is extracting all the reocrds activity table to EIM tables and seems like EXPORT MATCHES condition is kinda ignored as there were less numbers of recprds which were expedted.
2) the files are not getting exported to the location ( also tried with SiebFS)


Could you please help me with your inputs which will help me to solve this issue.

Warm Regards
Ashutosh
  • 1. Re: Export file Attachments in Siebel
    jiyong Pro
    Currently Being Moderated
    I never got this to work, so I created a query that creates the lines for a batch file for Windows.
    You can search for sseunzip and see how you should construct the command line.
  • 2. Re: Export file Attachments in Siebel
    619699 Newbie
    Currently Being Moderated
    Thanks a lot for your response.

    we have tried this approach .Just one question here " do we have some method to retain the name of original attachment as what i observed is this utility is generating some random name"

    thanks
    Ashutosh
  • 3. Re: Export file Attachments in Siebel
    Penky Journeyer
    Currently Being Moderated
    works for me with the following ifb (different table though)


    [Siebel Interface Manager]
    USER NAME = "SADMIN"
    PROCESS = "EXPORT Attachments"

    [EXPORT Attachments]
    TYPE = EXPORT
    ATTACHMENT DIRECTORY = D:\Siebel\siebsrvr\OUTPUT
    BATCH = 20100906
    TABLE = EIM_ACCNT_DTL
    EXPORT MATCHES = S_ORG_EXT, (BU_ID = '1-6U9TF')
    ONLY BASE TABLES = S_ORG_EXT, S_PARTY, S_ACCNT_ATT

    a difference I can see is the quotes around the export path.
  • 4. Re: Export file Attachments in Siebel
    619699 Newbie
    Currently Being Moderated
    hi
    when i used this IFB without quotes still i could not manange to get the files in the OUTPUT folder.

    [Siebel Interface Manager]

         USER NAME = "sadmin"
         PASSWORD = "sadmin"
         PROCESS = "EXPORTATTACHMENTS"

    [EXPORTATTACHMENTS]

         TYPE = EXPORT
         ATTACHMENT DIRECTORY = G:\sia81\CTMSTG\siebsrvr\OUTPUT
         BATCH = 2
         TABLE = EIM_ACT_DTL
         EXPORT MATCHES     = S_EVT_ACT,(ACTIVITY_UID LIKE "1-36RUP%")
         ONLY BASE TABLES = S_EVT_ACT,S_EVT_ACT_X,S_ACTIVITY_ATT



    I could see the following error in the log file.

    rem Unzip G:\sia81\CTMSTG\siebsrvr\OUTPUT\XXXXX_104 - Dr XXX - XXX FUL -
    EIMSQL     EIMSQLSubEvent     4     00000fee4f2f03c0:0     2012-02-08 05:39:11     rem 13 Oct 2009.pdf failed.

    please suggest probable cause.

    Thanks
    Ashutosh
  • 5. Re: Export file Attachments in Siebel
    jiyong Pro
    Currently Being Moderated
    The original name is in the table. You might want to add the row id to make sure you always have a unique file name.
    More info here: http://siebel.ittoolbox.com/groups/technical-functional/siebel-analytics-l/open-saf-199758
  • 6. Re: Export file Attachments in Siebel
    915392 Newbie
    Currently Being Moderated
    Could be silly answer but check if siebel application has access to that folder - try to use on of the Siebel file system sub-folder - I gues it is shared drive across all app servers.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points