2761653 - Simple & Calculated File Names - SuccessFactors Integration Center

This KBA has been drafted to review the options available for Integration Center file names for simple outbound jobs

In Integration Center, we have two variations of file naming functionality available:

• Simple File Naming
• Calculated File Name 

Please review the below 'Resolution' section for an in-depth review of each of these functionalities.

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."

• SuccessFactors BizX
• Integration Center 

In the 'Destination Settings' section of Integration Center:

 Simple File Name:

• Simple File naming conventions can be used for most integrations 
• Using simple filenames, we can append date and datetime suffix, to uniquely identify files based upon each execution
• The date time suffix can be implemented down to the millisecond level (this will suffice for most integrations)

• For the 'File Extension' option, we can define the file extension / format the output file should use (.csv  .txt  .xml  .dat)
• The File Folder' is a required field and is used to define the destination of the output file

Calculated File Name:

•  The 'Calculated File Name' functionality was introduced primarily for Attachment output
• i.e. each output record comes in the form of an attachment and requires individual / unique filename

Procedure outlined in the Integration Center Guide:

1. Go to Admin Center > Integration Center.
   
   
2. From Integration Center landing Page, select My Integrations.
   
   
3. From the Integration Center > My Integrations page, choose + Create More Integration Types.
   
   
4. From the Choose Integration Type page, select the following:
• Trigger type as Scheduled.
• Source Type as SuccessFactors.
• Destination Type as SFTP.
• Format as Attachment
  
  
5. Select Create. When you select Create button, you are directed to the Integration Center - Create a New Scheduled ATTACHMENT File Output Integration page.
   
   
6. Select the Starting Entity.
• Let us consider an example of selecting the Starting entity as Candidate and fetching the resume
• PLEASE NOTE: To be compliant with data privacy laws, you cannot use attachment or photo as the starting entity. You must use the navigation properties to access any attachment.
  
  
7. Enter the integration name and select Configure Fields tab.
   
   
8. Go to Filter and Sort [page 56] if you want to filter for any specific Candidates.
   
   
9. Go to Destination Settings [page 61] page to enter the SFTP details. Use Calculated File Names to generate unique file names per attachment.
• Let us consider an example of creating a file name for Carla Grant user.
• In the New Calculated Field Name popup, select Field Value = and associate the Operand as Candidate Id, by selecting Associate Field Entity Tree View Candidate Id.
• Select the Operator as Concatenate/Append from the dropdown and enter the Operand as _.
• Again select the Operator as Concatenate/Append from the dropdown and enter the Associated Field as FileName, by selecting Associate Field Entity Tree View JobsApplied Resume FileName. 
• You can see the Calculated Value as 1_CarlaGrant.doc, where 1 is the Candidate Id and CarlaGrant.doc is the file name.
• Click Ok
  
  
10. Schedule the integration (if needed) and provide the frequency, start and End dates. Refer Scheduling [page 80] for more information.
    
    
11. Go to Review and Run [page 83] and check the details. Save the integration and click Run Now to run immediately. Save and click Set Schedule to run at a specific scheduled time.

Please note that using calculated fields you can use the following options:

• Concatenate/Append
• To Upper Case = Convert the current value to upper case text
• To Lower Case = Convert the current value to lower case text
• Truncate = Truncate the current value to the number of characters specified by the max length setting
• Trim Whitespace = Remove all occurrences of a string
• Remove All = Remove all occurrences of a string
• Replace All = Replace all occurrences of one string with another string
• Prepend Text
• Truncate from Left = Trim from left keeping only specified number of characters
• Truncate from Right = Trim from right keeping only specified number of characters
• Substring = Extract the specified portion of the string
• Split = Split at the specified character, returning the part specified

Integration Center IC, Complex File Name, Calculated File Name, Simple File Name, Attachment, HCM Suite, SuccessFactors , KBA , LOD-SF-INT-INC , Integration Center , LOD-SF-INT , Integrations , Problem