topic Re: Alteryx Gallery HTML Output in Alteryx Server Discussions

Alteryx Gallery HTML Output

maisonsteyer — Wed, 06 Oct 2021 01:32:54 GMT

Hi Everyone -

I have created a report in Alteryx that unfortunately will only be output in the correct format via HTML output. I have tried everything I can to get this formatting to work when outputting to a pdf, but to no avail. With that being said, when I upload the workflow to the gallery and attempt to run it, I get the error in the picture below. I know that the issue is related to the html output because I've tested the workflow with a pdf output being the only change and the workflow ran just fine.

Thanks in advance!

Re: Alteryx Gallery HTML Output

rkapoor — Wed, 06 Oct 2021 12:38:51 GMT

@maisonsteyer try outputting to a PCXML format in your workflow and run in the Gallery.

Re: Alteryx Gallery HTML Output

maisonsteyer — Wed, 06 Oct 2021 15:18:21 GMT

I've tried that and it isn't a good solution because the other options (pdf, excel, and word) are not formatted correctly and I want to limit the download option to just html. Is there a way to limit the download options to only html via the PCXML?

Re: Alteryx Gallery HTML Output

rkapoor — Wed, 13 Oct 2021 08:49:49 GMT

@maisonsteyer What methods of output in Alteryx have you explored as yet - as in have you tried this via the Render and Output tools and get the same sort of result?

Re: Alteryx Gallery HTML Output

maisonsteyer — Thu, 14 Oct 2021 15:47:29 GMT

I have tried pdf, excel, and html. The only output that I have had be successfully formatted is the html output.

Re: Alteryx Gallery HTML Output

Peachyco — Tue, 19 Oct 2021 12:23:47 GMT

How about this:

Use the Output Tool to create the HTML file in a folder. If this is a throwaway file, I'd create it in the temp folder.
Execute a BAT file using the Run Command tool to open the HTML file. Hopefully, it would open in the same browser.

Re: Alteryx Gallery HTML Output

maisonsteyer — Tue, 19 Oct 2021 23:19:43 GMT

Is the Run Command tool able to be used in the gallery? I was under the impression that tool wasn't able to be used in the gallery.

Re: Alteryx Gallery HTML Output

Peachyco — Wed, 20 Oct 2021 04:49:35 GMT

@maisonsteyer : The Run Command tool can be rather tricky to use with the Gallery, that's true.

I do have a process that works for my setup:

Include the code for the BAT file somewhere in the workflow. This can be written in an external file that I bring into the workflow, or hard-coded in the workflow itself.
Create the BAT file in the temp folder. I use the Output Data tool for this.
Execute the BAT file using the Run Command tool. I use the CReW macro tool Parallel Block Until Done to make sure that Step 2 finishes creating the BAT file before Step 3 executes it.

To illustrate, I have this portion of one particular app:

This is the configuration of the Output Data tool:

And this is for the Run Command tool:

Some context on this app:

The user runs this app on the Gallery. The app creates an Excel file as output, then puts it in a shared network folder.
One unintended by-product of this process is that the app also generates a BAK file alongside that Excel file - I have not found a way to prevent this. This BAK file only serves to confuse our users and clutters up the folder.
My solution is to create this BAT file that deletes that BAK file, much like a clean-up subroutine.

Re: Alteryx Gallery HTML Output

TimothyR — Thu, 23 Dec 2021 22:27:06 GMT

Hi all!

After working with @maisonsteyer, it appears that this is a documented defect (TGAL-2235) regarding the Render Tool outputting HTM/HTML files that have embedded image files. This is projected to be fixed in the major 2021.4 Server release.

Re: Alteryx Gallery HTML Output

maisonsteyer — Mon, 06 Jun 2022 23:59:40 GMT

@TimothyR My server version is now up to 2021.4.2.07064 and I am still encountering the issues stated above. The 2021.4 release notes claim that this has been fixed in that version, however, it remains unfixed.