Exporting Data by FTP with xTuple Connect

Quick tutorial showing readers how to use the export to FTP capabilities of xTuple Connect.

xTuple Connect provides users with the ability to export ERP data to external FTP (file transfer protocol) sites, using a preset file type for query sets. In this article, we will give you a brief tutorial on how this is done. Meanwhile, to learn more generally about how xTuple Connect handles EDI (electronic data interchange), please see the xTuple Connect Product Guide.

To use export to FTP, you will be using the standard EDI profile distributed with the software.

  1. Go to System > Setup > Master Information
  2. Select the EDI Profiles option
  3. Select xTupleQuerySetEmail
  4. The click EDIT:

1-exportFTP01_0

xTuple QuerySet Email

To use FTP you will need to modify the type from EMail to FTP. In the drop down list next to EDI Type, select the FTP option:

2-exportFTP02

EDI Type selection

You should only have to change the EDI type. Please note the EDI profile for QuerySets can only be used for either EMail or FTP never both. Save the EDI profile with the type set as FTP.

To initiate an FTP transfer, follow these steps:

  1. Go to System > Utilities > Export Data.
  2. This will open the Export Data screen, as shown in the next screenshot.

3-exportFTP03

List of query sets

This window will list your existing query sets. To create a new query set, click the NEW button to open the Query Set window:

4-exportFTP04

Creating a new query set

Once you've created a new query set, follow these steps:

  1. Save the new query set.
  2. Select the query set to use for the FTP export.
  3. Then click on the SCHEDULE button.
  4. This will open an EDI transmission window.

Once you are in the Review EDI Before Sending screen, you will need to enter in the FTP connection information under the Message tab, as shown below:

5-exportFTP05

FTP connection information input

After filling in that information, click on the Attachments tab to set the attachment options (delimited text for CSV files). The PREVIEW button will preview the file you will be sending to FTP.

6-exportFTP06

FTP Attachment Options

Once all these options have been set correctly, you can then select the OK button to commit. You may now close this window.

The scheduled export will not be managed by xTuple Connect. Check the xTuple Connect Console to verify the export has been scheduled. Once you have verified the export is working as desired, you may reschedule the export to be repetitive from the xTuple Connect Console.