Parsing error from XML files generated by Python and Alteryx Server

Question

Hi,

I have a problem with the generation of XML file with the Server.

I have written a script in python to generate XML. When I run the workflow on my desktop, I have as a result XML files that I can parse easily.

But I run it on the server after validation, the XML files generated can't be parsed. I get this message when I send the generated files to a parser:

I tried to run the workflow from the Designer of the server (both have the same version: 2020.4) but I got the same error on my XML when trying to parse it.

I found this thread on a community, don't know if I might have a similar problem:

https://communities.vmware.com/t5/ESXi-Discussions/Error-Unexpected-character-code-65279-0xfeff-in-prolog-expected/m-p/493641

I'm on Windows 10.

Any ideas of how I can solve this problem?

mathieuf · Answer

Hi @Tina1,

As discussed in private, the Python version as been updated from 2020.2 (your Designer) and 2020.4 (the Server).

Please see to upgrade your Designer in 2020.4 then it should all be ok.

Tina1 · Answer

Hi,

No there is no imput but you have to create a folder where you'll store the 3 csv files that I've joined.

Then in the script (in the main) you have to change the 3 links:

Here are the links of the folder containing the csv files (Mine are stored in the folder "Flux aller")

And here change it to a folder of your choice, the xml files generated will be stored in there.

And to answer your question, the Server has access to the datasources. The XML files are generated with the Server (you can open them with a notepad++, you'll see all the data), but when you try to parse them you get an error (see my first post).

Same when you try to open in Alteryx:

Thanks for your help !

T06_T2Q_Table6_11307_2020-12.csv

T10_T2M_Table10_11307_2020-12.csv

T01_T1M_Table1_11307_2020-12.csv

mathieuf · Answer

Thanks @Tina1 !

Is there an input before your python tool? I'm getting an error when running it.

Would it be possible to get a sample of that source (you can change the nature of the data if confidential)?

Another question I have in mind: does the Server have access to the datasources or web resources you reached with your workflow?