Defaulting Encoding Type on Output File

[johnnykoung]

Hi,

I have an application on the server that outputs a csv file. When outputting, there's always a prompt to select encoding type. Is there a way for me to default this encoding type to specific selection? I want to default it to unicode UTF-8

Thanks,

Johnny

[apathetichell]

yes! but it's not intuitive - you need to blob convert to UTF-8. Then blob output as a file with a .csv extension.

[johnnykoung]

I have multiple columns in my file. Do I have to blob convert each column using the configuration below? And then how to I use the blob output tool? I'm not sure how I can export the whole file as .csv.

[apathetichell]

no. you add a record id transpose and then create a concatenated field of your values using summarize tool separated by your delimiter. Then you convert that field.

I can't remember if blob output downloads automatically but you create a dummy filename like "my.csv" and it isn't much work to add a filebrowse/action tool to that if you need to.

[csmith11]

Unfortunately, this does not work for me. I still get a drop down asking me to choose an encoding type.

I believe the best options are:

1.Train users to pick the appropriate encoding type

2. Output to a shared drive with a link to the output location displayed in the result window in Gallery.

[apathetichell]

@csmith11  That's with a blob conversion and blob output? Can you share a screengrab of your workflow? Can you try changing the extension filename to test.txt and see if you still get that?

[csmith11]

txt works just fine.

\\

Works with CSV too, but we might as well just write out to a normal CSV output since the result is the same.

Fortunately, Alteryx has already accepted the idea to default the encoding option.

https://community.alteryx.com/t5/Alteryx-Server-Ideas/Disable-or-Default-CSV-Encoding-Type-at-Output...

[csmith11]

Here's a copy of my workflow. 

Have you tested this already? Did it work as expected? What version of Gallery are you on?