Wednesday, July 25, 2012

Export Process Parameters in IFB

These are the parameters which are only applicable to EIM Export process and are written with in the Process section in an IFB file used for export process. They are :-

ATTACHMENT DIRECTORY

  • Optional parameter that specifies the directory path to where the attachments have to be exported.
  • This directory path should exist on one of the Siebel server machine.
  • In case of remote machine, map the path to a drive and specify the drive name to this parameter.
  • Default value is <SIEBEL_HOME>\OUTPUT
  • Example: ATTACHMENT DIRECTORY = X:, Where X: is mapped to \\CRMDEV02\siebsrvr\OUTPUT


CLEAR INTERFACE TABLE

  • Optional parameter that specifies whether to remove the old records from the EIM table whose batch number corresponds to, as defined in the IFB file.
  • Valid values are TRUE or FALSE.
  • Default value is TRUE.
  • Example: CLEAR INTERFACE TABLE = FALSE
  • If this parameter is set to false, and some rows already exist in the EIM table for the specified batch, EIM will throw a warning.


EXPORT ALL ROWS

  • This parameter specifies whether to export all rows from the Siebel base tables that were mapped to the particular EIM table specified in the IFB file.
  • Valid values are TRUE or FALSE. Default value is FALSE.
  • Example: EXPORT ALL ROWS = FALSE
  • When you do an export on party EIM tables, set this parameter to FALSE. If not EIM will export all party records.


EXPORT MATCHES

  • This parameter optionally specifies criteria that need to be satisfied before exporting the data from the base tables.
  • Example: EXPORT MATCHES = S_ORG_EXT, (NAME LIKE “HP%”)
  • The literal specified, is the condition that occurs after the WHERE clause in an SQL statement.

3 comments:

  1. Hi,

    I'm trying to export attachments Data from Siebel through EIM, and my IFB has all the parameters mentioned above. The attachments are getting succesfully imported, but the corresponding data is not getting written to the corresponding EIM table. Can you please help me as to what could ve gone wrong. Thanks a lot for your help in advance.

    Thanks,
    Sri

    ReplyDelete
    Replies
    1. Hi Sri,

      You are trying to export the attachments right? Then what you mean by saying 'The attachments are getting successfully imported'? Did you mean, you got the attachments extracted but data didn't get populated in the EIM table? Can you share the ifb used to look this issue further. You can mail me on eimtoolbox@gmail.com

      Regards,
      Varun

      Delete
  2. Hi,

    I need to export data for 6 months and repeat this export activity every month (for 6 month's data). As a result my data will be duplicate for 5 months. Do we have any provision to overwrite the existing file in Export as I know it creates a new file with '_1' in the file name for files that are already existing.

    Regards,
    Ruby

    ReplyDelete