SFTP download of CSV file does not seem to be UTF-8 encoded - is there an option for this?

Automise Discussion
21

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.

1 Like
22

That will allow me to turn off the Powershell script, if it works. That would be great.

23

Please try this build

24

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.

25

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.

26

Ok, this build should do the trick

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/AutomiseRunner500_1372.exe

1 Like
27

I have installed this, and reverted my action lists to my previous logic. We’ll see tonight if things succeed.

28

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.