6 Replies Latest reply: Mar 23, 2012 4:36 PM by Michal Roman RSS

    Export file Attachments in Siebel

    619699
      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
          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
            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
              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
                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
                  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
                    Michal Roman
                    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.