SFTP Export using .txt

Ask the Community
1

Hello Team,

Kindly can you let me know how to use .txt files as an output export from SFTP?
Currently in Holistics I only find 2 files format (Excel & CSV)

image
image972×254 22.5 KB

Can you please let me know if we have an txt option?

Thanks

2

Hi Hamza,

Thank you for the question.

Could you please elaborate on the data format that you expect in such TXT files?

3

Hi and thanks for your response,

Our client asked me to create a report and send it via SFTP, and we must follow the requirements below:

image
image920×680 26.5 KB

I believe I can use the CSV format to meet their needs, but I’m not sure how to handle the .txt extension requirement. They are using a software system that only accepts .txt files.

Could you please confirm if it would be acceptable to generate a pipe-delimited or comma-delimited file with a .txt extension instead of .csv ?

Best Regards,
Hamza

4

Hi @Hamza_Rashed1,
Thanks for your sharing. Currently we don’t support .txt file extension on SFTP exports. Because your client software system only accepts .txt files, you’ll need to handle the conversion pipeline on your side.

One approach is to use an automation tool such as Zapier or n8n to handle this. The pipeline works something like this:

  • Holistics exports the data as a pipe-delimited .csv into your remote folder (via SFTP)
  • The automation tool then picks up that file, renames it to .txt, and re-uploads it to the folder your client’s system reads from

Let me know if you need to clarify further on the implementation.