Defaulting Encoding Type on Output File

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

Server

Accepted answers

All comments

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-on-Gallery/idc-p/883160#M2807

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?

CSV OUT.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703