FTP Attachments® Importer document

Modified on Sat, 8 Oct, 2016 at 4:15 PM

FTP Attachments® Importer

FTP Attachments® Importer Tool

FTP Attachments® Importer is a command line tool based on C# console application. It can import

files from your local computer to FTP Attachments®. This tool is ideal if you are migrating attachment

from Legacy system to your Salesforce. The Importer tool can also be used for automation.

Feature

Can import up to 1000 files in a single run.
Files successfully imported are moved to a success folder.
Detailed log output to find status of all records and errors if any.
Command based tool can be invoked from the Task Scheduler for automation.

You can download the Latest FTP Attachments® Importer build from the following link.

http://downloads.ftpattachments.com/builds/FTPAttachmentImporter.zip

How to use the tool?

Input.csv

Input.csv is an input file where you are required to store the information like Name of the

Object for the record, record id to which the attachment is to be attached, Storage Folder name and

Absolute path of the folder where the attachment is stored ( this is of the machine that will run the

Importer tool). This file will work as an input file that contains required data for the tool to

handle the request to store the attachments (at the path mentioned) for the record (identified

through Record Id).

PS: We have provided an illustration in the Input.csv file.

Command.txt

This file is for your reference, you will find the command in this file. Kindly make the necessary

changes as explained below and paste it on the command prompt.

Importer --input-file="d:\FTPAttachmentImporter\Input.csv" --log-

file="d:\FTPAttachmentImporter\Log.txt" --success-folder="d:\FTPAttachmentImporter\Success"

--max-size=1 –do-not-move = “true”

Above line is a command line which represent following things :

1. Input-file (highlighted in green color): This will give the path of the Input file stored on the

machine, for illustration we have provided sample records in the Input.csv file. You can create your

own input file and save it as .csv. Provide the absolute path of this input file here in this command.

2. Log file (highlighted in yellow color): This application Log file will contain events that are

logged by the applications. Events that are written to the application log are determined by the

developers of the software program, not the operating system. Provide the absolute path of this Log

file here in this command. Log.txt will maintain all the events that will execute in application to

your Log folder specified path.

PS: You can specify your own Log file path as well as name of Log file.

3. Success folder (highlighted in blue color): This folder will maintain all your records migrated

successfully. The above (highlighted in blue color) specified path is just for reference you can

change the path and name of folder as per your requirement.

Importer.exe.config

Importer.exe.config is a config file which has all settings of FTP Attachments®. Like URL,

Salesforce instance credential like username and password.

How to run the tool?

Fig: 1.

Open the command prompt and follow the steps given below.

Using basic command in command prompt go to the path where you have kept the FTP

Attachments® Importer folder. (For example : In above Fig: 1,D:\FTPAttachmentImporter>)

Copy the command from the Command.txt file and paste in the command prompt and press

enter (as shown in above Fig: 1).

You will see all your files are migrated successfully to the success folder.