

#WING FTP SERVER EXPORT ARCHIVE#
The files will stay on the FTP server, and if the export process runs again, the same files will be exported again.īackup files path: Enter a value relative to the root directory, if you want to archive a copy of the exported files. Leave file on server: If you set this field to True integrator.io will NOT delete files from your FTP server after your export completes. This feature gives you the ability to group records by field (column1, column2, column3…), and sort the records in ascending or descending order (ASC or DESC).ĭecrypt files: This option is enabled if your connection is configured to use PGP encryption/decryption.ĭecompress files: Set this field to True if you're exporting compressed files. The Sorting and Grouping drop-down menu allows you to manage your flow’s files by sorting and grouping records by field. How would you like to group and sort records? You must specify the file extension for this filter to work correctly. For example, if you set this value to test.csv then only files where the name ends with test.csv will be transferred (like myFile-test.csv). For example, if you set this value to test then only files where the name starts with test will be transferred (like test-myFile.csv).įile name ends with: Use this field to specify a file name postfix to filter which files in the FTP server Directory path will be transferred. You can (optionally) configure integrator.io to leave files in the folder, or to transfer files that match a certain starts with or ends with file name pattern.įile name starts with: Use this field to specify a file name prefix to filter which files in the FTP server Directory path will be transferred. integrator.io will transfer all files from the folder path specified, and delete them from the folder once the transfer completes. Where would you like to transfer from?ĭirectory path (required): Specify the path of the FTP folder that contains the files to be transferred. XML parser helper: The XML parser will give you immediate feedback on how your parse options are applied against raw XML data. If the first row of your XLSX file is reserved for column names (and not actual data), then check this box. XLSXįile has header: Check this box if the files you are exporting contain a top level header row. Resource path: You can use this field optionally to define the JSON path to the resources you are exporting from the JSON file with handlebars syntax. Fixed Widthįormat (required): Select the Fixed width file format that matches the files you are exporting from Amazon S3. EDIFACTĮDIFACT format (required): Select the EDIFACT file format that matches the files you are exporting from Amazon S3. EDI X12ĮDI x12 format (required): Select the EDI X12 file format that matches the files you are exporting from Amazon S3. Click Choose file and navigate to a sample version of the files you will be exporting.ĬSV parser helper: The CSV parser helper can be used to visualize and experiment with how integrator.io parses CSV files (or any other delimited text files) into the JSON records/rows that then get processed by your flow. Choose a sample file to define the record structure. Sample file (that would be parsed) (required): This field only displays if you choose CSV, JSON, XLSX, or XML as a file type. The file type you select changes the fields available on the Create export panel. For example, choose CSV if you are exporting a flat, delimited text file, or XLSX for a binary Microsoft Excel file. How would you like to parse files?įile type (required): Choose the type of file to be exported from the FTP server. Select No if you want to transfer the files in the exact same format as they are stored on the FTP server.

Parse files being transferred : If you need to parse CSV, XML, or JSON files into records before sending them to other applications, select Yes. As you make changes to the resource, be sure to keep this description up to date. Be sure to highlight any nuances that a user should be aware of before using this import in a flow. You will have the option to choose this export throughout integrator.io, and a unique identifier will prove helpful later when selecting among a list of imports that you’ve created.ĭescription (optional): Describe your export so that you and others can quickly understand its purpose.

Name (required): Provide a clear and distinguishable name.
