This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
12-18-2018 09:05 AM - edited 07-23-2021 05:14 PM
Question
With the introduction of Python SDK, Alteryx Designersupports the installation of YXI files for Python-based tools. What happens during the installation process for one of these tools?
Answer
Note:The following is based on 2018.4. Each command is assumed to be prefixed with %ALTERYXDIR%\bin\Miniconda3\python.exe.
Example: C:\Program Files\Alteryx\bin\Miniconda3\python.exe -m venv c:\temp\my_tool
General Process after running a YXI file
1. The contents of the YXI fileare uncompressed(unzipped) in%DESTINATION_PATH%(seeTools Location). Please note thatmultiple tools could be installed with a single YXI.
2.A Python environment is created for the tool.
-m venv %DESTINATION_PATH%
Note: Following this step, the tool folder shouldhave the following structure:
If any of these components are missing, the tool is not installed correctly.
3.pip (the Python package manager) is upgraded in the Python environment.
-m pip install --upgrade pip
4.setuptools(a library for Python package support)is upgraded in the Python environment.
-m pip install --upgrade setuptools
5.Any tool dependencies are installed in the Python environment.
-m pip install --disable-pip-version-check -r requirements.txt --log PythonDependencyInstall.log
Errors and Cancellation
Tool folder will be deleted if:
Logs
FilePythonDependencyInstall.log contains the logs for tool installation
By default, tools are installed under:
%APPDATA%\Alteryx\Tools (ex: C:\users\My_Account\AppData\Roaming\Alteryx\Tools) for current user
%PROGRAMDATA%\Alteryx\Tools (ex: C:\ProgramData\Alteryx\Tools) for all users
Following is only provided as an example.Should you face an error during the installation of one of the tools, please contact Alteryx Customer Support (support@alteryx.com).
Imagine that want to investigate the following error message during the installation ofazure_data_lake_input_v1.0.2.yxi.
Asthe installation window only returns the last error message, you may need to dig further.
Byproceeding with a manual installation, you can obtain more details.
The process is as follows:
1. Renameazure_data_lake_v1.0.2.yxi toazure_data_lake_v1.0.2.zip and uncompress folderazure_data_lake_input_v1.0.2to C:\users\%Your_Account%\AppData\Roaming\Alteryx\Tools\azure_data_lake_input_v1.0.2 (%Your_Account% should match your Windows login)
2. Open a command prompt (cmd.exe)
3.Create the Python environment for the tool (based on default path):
C:\Program Files\Alteryx\bin\Miniconda3\python.exe -m venv C:\users\%Your_Account%\AppData\Roaming\Alteryx\Tools\azure_data_lake_input_v1.0.2
4.Change to tool folder and proceed with package updates and dependency installations:
cd C:\users\%Your_Account%\AppData\Roaming\Alteryx\Tools\azure_data_lake_input_v1.0.2
Scripts\python.exe -m pip install --upgrade pip Scripts\python.exe -m pip install --upgrade setuptools Scripts\python.exe -m pip install --disable-pip-version-check -r requirements.txt --log PythonDependencyInstall.log
In this particular example your trace showed the following error:
This message indicates there was a problem confirming the SSL certificate from pypi. It is a clue regarding the cause of the issue and its solution.
This specific issue can be fixed with the following steps:
[global]
trusted-host = pypi.python.org
pypi.org
files.pythonhosted.org
3. Install tool again
Hi @sathiya,
Thank you for your message and happy new year.
The article is specific to the installation process and therefore does not cover your 2 questions. I can see that your first point is already in progress with a Customer Support Engineer. Any tools installed with Alteryx will be available via right click.
Kind regards,
Paul Noirel
Sr Customer Support Engineer, Alteryx
Good catch @cam_w!
I have amended the post.
Thanks again!!
Paul Noirel
Sr Customer Support Engineer, Alteryx
Hi,
I am having this same issue as described in the post (for the google big query connector not azure). However, I have tried the solution and it is still giving the same error. Any idea what else I can try?
Many thanks,
Ed
Hi @EdwardNSG,
Thank you for posting!
Could you please post a screenshot of your pip.ini file and of the error on the command line please?
Thanks,
PaulN
My thinking is this has something to do with a firewall. Do you know where I can find an offline connector?