topic Parsing error from XML files generated by Python and Alteryx Server in Alteryx Server Discussions

Parsing error from XML files generated by Python and Alteryx Server

Tina1 — Fri, 12 Feb 2021 09:10:17 GMT

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?

Re: Parsing error from XML files generated by Python and Alteryx Server

mathieuf — Mon, 15 Feb 2021 19:28:46 GMT

Hi @Tina1,

Could you share the workflow or a print screen? That would help?

If you are running a Python script, does the Server have all libraries installed (same as your computer)?

Re: Parsing error from XML files generated by Python and Alteryx Server

Tina1 — Tue, 16 Feb 2021 08:53:44 GMT

Hi @MathieuF,

Thanks for you help. I have no idea if the Server have all libraries installed.

All I can say is there is no problem in the validation of the workflow so I assumed the Server had everything it needed...

You'll find attached the workflow which only contains a python tool.

Thanks again for your help!

Re: Parsing error from XML files generated by Python and Alteryx Server

mathieuf — Wed, 17 Feb 2021 08:50:35 GMT

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?

Re: Parsing error from XML files generated by Python and Alteryx Server

Tina1 — Wed, 17 Feb 2021 09:35:04 GMT

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 !

Re: Parsing error from XML files generated by Python and Alteryx Server

mathieuf — Wed, 17 Feb 2021 14:01:21 GMT

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.