Hey.
I am experiencing more and more that we want to use XML to parse and store specific data between tasks and jobs.
However, we have two issues which bothers us, and hopefully your infinite wisdom can follow us on this:
A) Add support for XML namespaces. A lot of XML between programs are done using namespaces in the XML, which is currently not support by VisualCron (it returns a standard .NET error: Exception in Task: Namespace Manager or XsltContext needed. This query has a prefix, variable, or user-defined function.). Namespaces should be add'able from the XML task GUI. An example of the .NET code to support XML namespaces is:
Dim ns As New XmlNamespaceManager(Data.NameTable)
ns.AddNamespace("soap", "http://schemas.xmlsoap.org/soap/envelope/");
ns.AddNamespace("default", "https://service.leads360.com");
Data.LoadXml(Document.SelectSingleNode("/soap:Envelope/soap:Body/default:GetReportResultsResponse/default:GetReportResultsResult", ns).InnerXml)
MsgBox(Data.SelectSingleNode("FirstName").InnerText)Notice that it should be possible to add more than one namespace
B) An error occurs in the XML read task, if a tag contains special characters. Example:
<name>René</name>...the é raises an error. Tried all kinds of encodings, but to no difference.
Li