Google Auto Translate Macro

[#1]

If you need to translate your text from one language to another, the process can be quite painful. The current Google Translate tool requires an API key, and billing information to get started. I thought it would be great to have a tool you can download, and not have to worry about where to get an API key or have credit card information at the ready.

This tool uses a free to use Python library called deep_translator (https://pypi.org/project/deep-translator/) that also uses Google translate to translate text. However, it avoids the need for billing information or any setup. Just download the tool, hit save, and translate away!

On a first time setup, you may need to right click and open Alteryx Designer as Administrator, in order to install the Python libraries required to use the tool. Following this, you will not need to run as Administrator to use the tool.

Let me know below if there are any suggestions, or found bugs within this tool. 

[IraWatt]

Nice icon cant wait to try out !

[TheOC]

Thanks @IraWatt 

Let me know what you think 😁

[kevinlin001]

Thanks TheOC for making this tool. I downloaded it and open it as admin but the workflow seems stuck at formula tool before python tool. What gives? 

[TheOC]

hey @kevinlin001 

Have you saved it as a macro and using it within a workflow? 

Are you able to screenshot the issue you are having? 

Cheers,
TheOC

[rcarmody]

Hey,

Thanks for this tool! I am attempting to use it on alot of data - not sure if I downloaded the tools improperly but it wont load past 45%. Idk if it takes a while or I am missing something to finish the workflow. Any advice or suggestion would be greatly appreciated! 

[TheOC]

hey @rcarmody 

can you give me some insight into how much data you have? I'll give it a test on mine.

does it work on 1 row of data at a time/a smaller subset of the data?

[rcarmody]

@TheOC

Can you walk me through how to properly download the python library and then use it within a workflow? Because I think the issue is with that library. Thanks! 

[TheOC]

hey @rcarmody 

Ofcourse!

1. Open Alteryx as Administrator:

2. Open my tool:

3) Hit file, save as, save into your macro folder (it should open by default).

4) Open your workflow with text you want to translate:

5) Find my tool that you have just saved, in the 'Bulien Tools' section of your tool pallete:

6) Drag the tool onto your canvas:

7) Specify the language you want to translate to, and your field. In this case, i want to translate to Spanish:

8) Hit run, inspect the results:

You should see a new field called 'translated', which has your translated text.

Hope this helps, let me know if you have any issues.
I'd recommend starting with a sample dataset like this so you can test it works on one, before rolling it out to a larger dataset. However - i did test this on larger datasets before publishing, so i would be surprised if it doesn't work.

Cheers,
TheOC

[Shifty]

I am loving this tool, @TheOC - so many applications.

[kevinlin001]

Hi @TheOC ,

I tried again following all the steps you gave above, but the workflow just showing running forever... Any idea what might cause it? Thanks so much!

Kevin

[Saraabdi955]

Hi,
I got this error:
" Google Auto Translate (1) Tool #1: Failed to find virtual env named: "designerbasetools_venv""

How can I fix it?

[sireeshagandam]

Good