Step 2.2 : Create Excel Export Adapter

Before you proceed through this step, if you have your own excel form, you should prepare it. You have to create FTP OUT Adapter first to use with the Excel Export Adapter.

Create Transport Layer : FTP OUT Adapter 

  1. Go to SSQUARE Adapter through http://YOURDOMAIN:8380/adapter e.g. http://ssq.techberry.com:8380/adapter (Google Chrome is recommended)
  2. Select FTP OUT on sidebar 
  3. Click + to create a new FTP OUT adapt
  4. Fill the information of FTP OUT adapter

  1. Click Test Connection
  2. Specify directory and name/name pattern of file in Output File Configuration section

  1. If test connection successfully, click Create

Create Adapter Layer : Excel Export Adapter

  1. Go to SSQUARE Adapter through http://YOURDOMAIN:8380/adapter e.g. http://ssq.techberry.com:8380/adapter (Google Chrome is recommended)
  2. Select Excel Export on sidebar 
  3. Click + to create a new Excel Export adapter
  4. Fill the information of Excel Export adapter and select FTP OUT

  5. In Basic Configuration section, define the details:

  1. Option 1: Using excel form

6.1) Prepare your excel form and create the column that you need to map with the database

6.2) Add you basic configuration and import your excel file


** The Sheet Name should be EXACTLY THE SAME as the sheet name in excel file

6.3) Select file and click Import

6.4) Template configuration will show the fields of the excel file but if you need to change the name, you can click at that field and add new name replace it.

  1. Option 2: No excel form

7.1) Click at the add sign to add new field in the template configuration

7.2) Select the field and add the field name in it and select Promote to Field which you would like to show.

  1. Click Create
  2. Run the test: See more Excel Export Adapter
  3. Test condition and run the local test to check the result


Example of test results