Dear PI Community,
how to check AF DB export xml file for validness?
during the export, network connectivity issues happened.
I see XML file produced. How can I check if it is valid, no errors?
Maybe using the .xsd file that lies in AF Client folder. A really simple way would be to copy the xml and xsd file to the same folder and try to open it with MS XML Notepad, it will give you an error if the structure is not ok (but you must have a few GBytes of ram memory avaiable to open a large AF tree). Here you will find information on how to validate it using C# and VBA. Another way is using lxml library with python.
If i'm not wrong, the the xsd file has the structure rules for a xml that points towards it.
Just a quick followup for Notepad++ users; it has a plugin called XML Tools that can do validation as well.
Retrieving data ...