# SFTP download of CSV file does not seem to be UTF-8 encoded - is there an option for this? **URL:** \ **Category:** Discussion\ **Created:** [March 21, 2022, 2:24pm UTC](https://www.finalbuilder.com/forums/t/sftp-download-of-csv-file-does-not-seem-to-be-utf-8-encoded-is-there-an-option-for-this/7193 "2022-03-21T14:24:06Z")\ **Posts on this page:** 8\ **Page:** 2
**Author:** ![Vincent](https://www.finalbuilder.com/forums/user_avatar/www.finalbuilder.com/vincent/32/938_2.png) [@Vincent](https://www.finalbuilder.com/forums/u/Vincent)\ **Post date:** [March 25, 2022, 12:41am UTC](https://www.finalbuilder.com/forums/t/sftp-download-of-csv-file-does-not-seem-to-be-utf-8-encoded-is-there-an-option-for-this/7193/21 "2022-03-25T00:41:30Z")
We did consider that, however that would be painful for some users when working with filesets etc. I will have build uploaded shortly that will behave a lot better - the trick was to try opening with the fallback (for no bom scenarios) as utf-8 - if that fails then try again with the fallback being Encoding.Default - that did work for all my test files. I’m not sure this will be the end of this issue for some users though, as Encoding.Default can be different on different machines. ---
**Author:** ![jonathanmeltzer](https://www.finalbuilder.com/forums/letter_avatar_proxy/v4/letter/j/34f0e0/32.png) [@jonathanmeltzer](https://www.finalbuilder.com/forums/u/jonathanmeltzer)\ **Post date:** [March 25, 2022, 2:21am UTC](https://www.finalbuilder.com/forums/t/sftp-download-of-csv-file-does-not-seem-to-be-utf-8-encoded-is-there-an-option-for-this/7193/22 "2022-03-25T02:21:57Z")
That will allow me to turn off the Powershell script, if it works. That would be great. ---
**Author:** ![Vincent](https://www.finalbuilder.com/forums/user_avatar/www.finalbuilder.com/vincent/32/938_2.png) [@Vincent](https://www.finalbuilder.com/forums/u/Vincent)\ **Post date:** [March 25, 2022, 2:26am UTC](https://www.finalbuilder.com/forums/t/sftp-download-of-csv-file-does-not-seem-to-be-utf-8-encoded-is-there-an-option-for-this/7193/23 "2022-03-25T02:26:29Z")
~~Please try this build~~ ---
**Author:** ![jonathanmeltzer](https://www.finalbuilder.com/forums/letter_avatar_proxy/v4/letter/j/34f0e0/32.png) [@jonathanmeltzer](https://www.finalbuilder.com/forums/u/jonathanmeltzer)\ **Post date:** [March 25, 2022, 2:35am UTC](https://www.finalbuilder.com/forums/t/sftp-download-of-csv-file-does-not-seem-to-be-utf-8-encoded-is-there-an-option-for-this/7193/24 "2022-03-25T02:35:33Z")
Much appreciated. I am off tomorrow, but I will work on getting this in next week. My workarounds will hold for the weekend, I think. I am glad I stayed up to converse with you. ---
**Author:** ![Vincent](https://www.finalbuilder.com/forums/user_avatar/www.finalbuilder.com/vincent/32/938_2.png) [@Vincent](https://www.finalbuilder.com/forums/u/Vincent)\ **Post date:** [March 25, 2022, 2:41am UTC](https://www.finalbuilder.com/forums/t/sftp-download-of-csv-file-does-not-seem-to-be-utf-8-encoded-is-there-an-option-for-this/7193/25 "2022-03-25T02:41:21Z")
We may not be done with this just yet, the mitigation I put in place has flaws that a collegue just pointed out. More investigation needed. ---
**Author:** ![Vincent](https://www.finalbuilder.com/forums/user_avatar/www.finalbuilder.com/vincent/32/938_2.png) [@Vincent](https://www.finalbuilder.com/forums/u/Vincent)\ **Post date:** [March 25, 2022, 3:47am UTC](https://www.finalbuilder.com/forums/t/sftp-download-of-csv-file-does-not-seem-to-be-utf-8-encoded-is-there-an-option-for-this/7193/26 "2022-03-25T03:47:20Z")
Ok, this build should do the trick [https://downloads.finalbuilder.com/downloads/automise/500/AT500\_1372.exe](https://downloads.finalbuilder.com/downloads/automise/500/AT500_1372.exe) [https://downloads.finalbuilder.com/downloads/automise/500/ATCMD500\_1372.exe](https://downloads.finalbuilder.com/downloads/automise/500/ATCMD500_1372.exe) [https://downloads.finalbuilder.com/downloads/automise/500/AutomiseRunner500\_1372.exe](https://downloads.finalbuilder.com/downloads/automise/500/AutomiseRunner500_1372.exe) ---
**Author:** ![jonathanmeltzer](https://www.finalbuilder.com/forums/letter_avatar_proxy/v4/letter/j/34f0e0/32.png) [@jonathanmeltzer](https://www.finalbuilder.com/forums/u/jonathanmeltzer)\ **Post date:** [March 28, 2022, 8:49pm UTC](https://www.finalbuilder.com/forums/t/sftp-download-of-csv-file-does-not-seem-to-be-utf-8-encoded-is-there-an-option-for-this/7193/27 "2022-03-28T20:49:15Z")
I have installed this, and reverted my action lists to my previous logic. We’ll see tonight if things succeed. ---
**Author:** ![jonathanmeltzer](https://www.finalbuilder.com/forums/letter_avatar_proxy/v4/letter/j/34f0e0/32.png) [@jonathanmeltzer](https://www.finalbuilder.com/forums/u/jonathanmeltzer)\ **Post date:** [March 29, 2022, 1:35pm UTC](https://www.finalbuilder.com/forums/t/sftp-download-of-csv-file-does-not-seem-to-be-utf-8-encoded-is-there-an-option-for-this/7193/28 "2022-03-29T13:35:45Z")
Looks like it worked. Some of the batch processes will not be run until later in the week, but there were no issues that I can see with existing nightly processes. Thank you for working with me to turn this around. [Previous page](https://www.finalbuilder.com/forums/t/sftp-download-of-csv-file-does-not-seem-to-be-utf-8-encoded-is-there-an-option-for-this/7193.md?page=1)