Re: XMLTOCURSOR

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Try this,

Format the xml to remove the <ReportMessage> tag and its contents.
(use the XML DOM object)

<?xml version="1.0" encoding="UTF-8"?>
<Report>
<Summary Process="3" Success="3" Reject="0">
</Summary>
</Report>

XMLTOCURSOR( "MyXml.XML", "fXmlFile", 512 + 4)

Even the below will now work:

<?xml version="1.0" encoding="UTF-8"?>
<Report>
<Summary Process="3" Success="3" Reject="0">
</Summary>
<Summary Process="13" Success="6" Reject="2">
</Summary>
<Summary Process="24" Success="8" Reject="9">
</Summary>
</Report>

Or you could try to use XSLT to transform the XML file to a format easily
recognized by XMLTOCURSOR.

"Scott" <Scott@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:C71D6926-170B-404E-A45D-AE525A6D9474@xxxxxxxxxxxxxxxx
We recieve files offsite. Here is one such file:

<?xml version="1.0" encoding="UTF-8"?>
<Report>
<ReportMessage>Successful without rejections - Succès sans
rejets</ReportMessage>
<Summary Process="3" Success="3" Reject="0">
</Summary>
</Report>

To the average joe, is can be confusing so, of course, I want to pull it
into a cursor so I can present it better.
When I use XMLTOCURSOR on this, I get "unable to infer xml schema". I
can't
seem to find the problem. Help?


.

Relevant Pages

  • XSLT: Newbie needs help please.
    ... I'm very new to XML/XSLT but from what I've seen I really like ... I'm building a 'report generation wizard' for an in-house ... The drop down lists are dependent on one another ... represented by XML. ...
    (comp.text.xml)
  • Export report with grouping to XML
    ... We need to export a data set to a web page that needs to be formatted ... I set up a report that has a group header for the records based on a ... since the query will export the entire field to XML just ... Or does anyone have a better way to format ...
    (microsoft.public.access.reports)
  • Re: Hard Copy reports
    ... DoD has mandated that all data interchange between system be in XML. ... Report Writer can even be used to generate XML, although it's output is not the most efficient. ... Again, although many/most "customers" like real-time online access to the current state of their accounts/bills, at least in the US, I still see that most such buisness still provide a hard-copy version of monthly bills/statements. ...
    (comp.lang.cobol)
  • RE: convert report to infopath form
    ... there is no official method to convert an access report ... > to an infopath form directly because they have different presentation ... > When you design a form based on an existing XML document, Microsoft Office ...
    (microsoft.public.access.reports)
  • RE: convert report to infopath form
    ... there is no official method to convert an access report ... to an infopath form directly because they have different presentation ... When you design a form based on an existing XML document, ...
    (microsoft.public.access.reports)