After reading this article you will be able to:
- Add the Outbound File Transfer tab
- Navigate to the outbound file transfer
- Export custom files
- Explain the outbound file transfer fields
Attention! Before starting this article you will need to Enable the dealer.Udate Outbound File Transfer. Read Enable Custom Permissions to learn how.
Step One: Add the Outbound File Transfer Tab
- Click the setup gear icon.
- Select Setup.
- Enter Tabs in the quick find area.
- Click Tabs.
- Click New.
- Select Outbound File Transfer as the Object value.
- Select a value for the Tab Style.
- Click Next.
- Select the Profiles the Tab will be visible for and click Next.
- Select the Apps the Tab will be available on and click Save.
Step Two: Navigate to Outbound File Transfers
- Click the App Launcher icon.
- Enter Outbound File Transfers in the quick find area.
- Click Outbound File Transfers.
Step Three: Export Custom Files
- Click New.
- Enter the SOQL Statement.
- Fill out the Configuration fields.
- Check Active.
- Click Save.
- Click Run OFT.
To view historical runs click View All on the related Outbound File Transfer History.
Outbound File Transfer Fields
|Destination File Name||The name of the string data written to the remote file system.|
|Export File Type||The type of file to be created on the remote file server.|
|Omit Header Row||If checked, the header row will be removed from the newly created remote file.|
|Delimiter||Select your default character to separate values. If left blank the default delimiter is comma.|
|Column Encapsulation||How to define the data columns.|
|Name||Label and link that appears in the list view.|
|SOQL statement||Contains SOQL Statement to be executed by the middlware. Ex: Select Id, Name From Account Where Site != null.|
|Active||Check this box to allow files to be exported.|
|Last Run Results||Contains the result of the last execution, success or error message.|
|Last Run Date||The date and time of the most recently completed OFT Job. Updated by trigger.|
|Last Run Status||The date and time of the most recently completed OFT Job. Updated by trigger.|
The SOQL Statement can point to any queryable object (not just Vehicle Inventory). Once the user attempts to save FTP job record, it will first automatically check the provided SOQL statement for validation, if there are errors in it, it will prevent saving of the record, and provide graphical error feed back.
An notification will appear if the SOQL statement is incorrect or has a syntactical error.
Here are some examples of working SOQL statements:
SELECT dealer__Store_Location__c, Blank_1__c, dealer__VIN__c, dealer__Stock_Number__c, dealer__Year__c, dealer__Make__c,dealer__Body_Type__c, FROM dealer__Vehicle_Inventory__c WHERE dealer__Publish_Vehicle_Info_To_Web__c = true AND dealer__In_Stock__c = true
SELECT dealer__Service_Vehicle__r.Name FROM dealer__Vehicle_Inventory__c FROM dealer__Vehicle_Inventory__c
|Transport Protocol||The protocol to use for the file transfer.|
|URN||Universal Resource Name, this should contain the IP address or DNS Entry for the resource endpoint.|
|Username||The username to connect to remote file server.|
|Port||The port used to connect to the remote file server.|
|Password||The password used to connect to remote file server.|
Schedule Outbound File Transfers to repeat. Learn how to by reading Schedule Apex Jobs.