Can I append data to an existing file on an SFTP server?

EZ Exporter supports an "Append to existing file" option for the SFTP (SSH) export destination.

A couple notes:

  1. This option will only work with text files (i.e. file format in EZ Exporter is set to "Delimited Text (CSV, TSV, TXT)" without compression).
  2. If the file doesn't exist on the server, a new file will be created.

Here's what this setting looks like in the app:

One use case for append is if your ERP system requires generating order files with varying data structures, but they need to be combined in a single file.

For example, one merchant that uses our app configured 5 separate formats for order data:

  1. OHDR (order header)
  2. ONAC (billing)
  3. OPAY (payment)
  4. ONAC (shipping)
  5. OLIN (order lines)

Every day, they need to basically concatenate them together because their ERP software requires it. This new setting gives them the ability to automate this process as each of those exports will be appended automatically to the existing daily file on the SFTP server.


Related Articles:


App: EZ Exporter

Tags: erp, sftp, ssh