Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
XMLAdapter can't parse but XMLTOCursor can
Message
General information
Forum:
Visual FoxPro
Category:
XML, XSD
Title:
XMLAdapter can't parse but XMLTOCursor can
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP1
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01008651
Message ID:
01008651
Views:
90
Below is a short version of an xml document from SharePoint that can't be parsed by the XMLAdapter but handled easily (except for the date field) by XMLTOCursor.
I thought that XMLAdapter was more robust than XMLToCursor!, I'm using VFP9.

How it can be parsed with XMLAdapter? What I'm missing here?

TIA
<xml xmlns:s='uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882'
     xmlns:dt='uuid:C2F41010-65B3-11d1-A29F-00AA00C14882'
     xmlns:rs='urn:schemas-microsoft-com:rowset'
     xmlns:z='#RowsetSchema'>
<s:Schema id='RowsetSchema'>
   <s:ElementType name='row' content='eltOnly' rs:CommandTimeout='30'>
      <s:AttributeType name='ows_Author' rs:name='Created By' rs:number='1'>
         <s:datatype dt:type='string' dt:lookup='true' dt:maxLength='512' />
      </s:AttributeType>
      <s:AttributeType name='ows_CampusVue_x0020_Modules' rs:name='CampusVue Modules' rs:number='2'>
         <s:datatype dt:type='string' dt:maxLength='512' />
      </s:AttributeType>
      <s:AttributeType name='ows_Class_x0020_Modules' rs:name='Class Modules' rs:number='3'>
         <s:datatype dt:type='string' dt:maxLength='512' />
      </s:AttributeType>
      <s:AttributeType name='ows_Analysis_x0020_and_x0020_Design' rs:name='Analysis and Design' rs:number='4'>
         <s:datatype dt:type='string' dt:maxLength='512' />
      </s:AttributeType>
      <s:AttributeType name='ows_Type_x0020_your_x0020_question_x' rs:name='Applications and Servers' rs:number='5'>
         <s:datatype dt:type='string' dt:maxLength='512' />
      </s:AttributeType>
      <s:AttributeType name='ows_Business_x0020_applications' rs:name='Business applications' rs:number='6'>
         <s:datatype dt:type='string' dt:maxLength='512' />
      </s:AttributeType>
      <s:AttributeType name='ows_Other_x0020_Business_x0020_appli' rs:name='Other Business applications (one per line)' rs:number='7'>
         <s:datatype dt:type='string' dt:maxLength='512' />
      </s:AttributeType>
      <s:AttributeType name='ows_Architecture' rs:name='Architecture' rs:number='8'>
         <s:datatype dt:type='string' dt:maxLength='512' />
      </s:AttributeType>
      <s:AttributeType name='ows_Database_x0020_Technologies' rs:name='Database Technologies' rs:number='9'>
         <s:datatype dt:type='string' dt:maxLength='512' />
      </s:AttributeType>
      <s:AttributeType name='ows_Other_x0020_database_x0020_Techn' rs:name='Other Database Technologies (one per line)' rs:number='10'>
         <s:datatype dt:type='string' dt:maxLength='512' />
      </s:AttributeType>
      <s:AttributeType name='ows_Intranet_x002f_Internet' rs:name='Intranet/Internet' rs:number='11'>
         <s:datatype dt:type='string' dt:maxLength='512' />
      </s:AttributeType>
      <s:AttributeType name='ows_Type_x0020_your_x0020_question_x0' rs:name='Mobile and Wireless Technologies' rs:number='12'>
         <s:datatype dt:type='string' dt:maxLength='512' />
      </s:AttributeType>
      <s:AttributeType name='ows_Operating_x0020_Systems' rs:name='Operating Systems' rs:number='13'>
         <s:datatype dt:type='string' dt:maxLength='512' />
      </s:AttributeType>
      <s:AttributeType name='ows_Software_x0020_Development' rs:name='Software Development' rs:number='14'>
         <s:datatype dt:type='string' dt:maxLength='512' />
      </s:AttributeType>
      <s:AttributeType name='ows_Other_x0020_Software_x0020_Devel' rs:name='Other Software Development tools/languages' rs:number='15'>
         <s:datatype dt:type='string' dt:maxLength='512' />
      </s:AttributeType>
      <s:AttributeType name='ows_Start_x0020_Date_x0020_at_x0020_' rs:name='Start Date at Campus' rs:number='16'>
         <s:datatype dt:type='datetime' dt:maxLength='16' />
      </s:AttributeType>
      <s:AttributeType name='ows_Actual_x0020_Title' rs:name='Actual Title' rs:number='17'>
         <s:datatype dt:type='string' dt:maxLength='512' />
      </s:AttributeType>
      <s:AttributeType name='ows_Quality_x0020_Assurance_x0020_Me' rs:name='Quality Assurance Methodologies' rs:number='18'>
         <s:datatype dt:type='string' dt:maxLength='512' />
      </s:AttributeType>
      <s:AttributeType name='ows_Quality_x0020_Control_x0020_Meth' rs:name='Quality Control Methodologies' rs:number='19'>
         <s:datatype dt:type='string' dt:maxLength='512' />
      </s:AttributeType>
   </s:ElementType>
</s:Schema>
<rs:data>
   <z:row ows_Author='13;#Jaime xxxxxx' ows_CampusVue_x0020_Modules='Admissions;#+1#Financial Aid;#+1#Student Services;#+1#Contact Manager;#+1#Student Accounts;#+1#Academic Records;#+1#Placement;#+1#Loan Management;#+1#' ows_Class_x0020_Modules='Admissions;#+1#Financial Aid;#+1#Student Accounts;#+1#Administration;#+1#Default Prevention;#+1#Activities;#+1#' ows_Analysis_x0020_and_x0020_Design='CASE Tools;#+1#OO Analysis and Design;#+1#OO Techniques using the UML;#+1#Patterns;#+2#RUP;#+1#Structured Analysis and Design;#+1#' ows_Type_x0020_your_x0020_question_x='Commerce Server;#+1#BizTalk Server;#+1#IIS;#+2#Lotus Notes and Domino Office;#+1#SharePoint Portal Server;#+1#SharePoint Services;#+1#Site Server;#+1#SNA/Host Integration Server Speech Server;#+1#Terminal Server;#+2#Windows Scripting Host;#+2#' ows_Business_x0020_applications='Great Plains;#+1#Microsoft Small Business Accounting;#+3#Quickbooks;#+2#Inventory Systems;#+4#Finance Systems;#+3#Shipping/Billing;#+4#Office Automation;#+3#Outlook/Exchange Integration;#+2#' ows_Architecture='.NET Framework Architecture;#+3#.NET Framework Class Libraries;#+3#.NET Compact Framework;#+4#2 Tier Client/Server Development;#+4#64 bit architecture;#+2#Active Directory Planning;#+1#Installation and Support;#+4#ADO;#+3#ADO.NET;#+4#ClientServer and Distributed Computing;#+3#COM;#+3#DCOM;#+3#COM+;#+3#DNA Framework Architecture;#+2#Microsoft Solutions Framework (MSF);#+1#n-tier Distributed Computing;#+2#' ows_Database_x0020_Technologies='Data Mining and Data Warehousing;#+1#Database Analysis and Design;#+4#Database performance tuning and monitoring;#+3#SQL Language (ANSI);#+3#T-SQL;#+3#P-SQL;#+1#SQL Server 2005 (Yukon);#+3#MSDE;#+3#Visual Foxpro;#+4#Access;#+3#' ows_Intranet_x002f_Internet='ASP;#+3#ASP.NET;#+3#Client-side scripting;#+1#DHTML;#+1#HTML;#+2#Visual Interdev;#+3#Server side scripting;#+4#SharePoint Web Parts;#+1#Web services development;#+3#WSDL;#+1#' ows_Type_x0020_your_x0020_question_x0='Windows CE;#+3#Pocket PC;#+4#WAP;#+2#Wireless networking technologies;#+4#WML;#+1#' ows_Operating_x0020_Systems='DOS;#+4#Windows 95/98;#+4#Windows NT;#+4#Windows 2000;#+4#Windows XP;#+4#Windows 2003;#+4#Linux;#+1#Solaris;#+1#UNIX;#+1#' ows_Software_x0020_Development='64-bit Development;#+4#ActiveX;#+3#C programming;#+1#C# programming;#+1#Delphi;#+1#Java programming;#+1#VB programming;#+4#VB script;#+4#VBA;#+3#VB.NET programming;#+4#Visual FoxPro programming;#+4#Access programming;#+1#Visual Source Safe;#+3#OLE;#+2#ORACLE;#+1#XML;#+1#XPath;#+1#XSL;#+1#XSLT;#+1#' ows_Start_x0020_Date_x0020_at_x0020_='2004-02-02 00:00:00' ows_Actual_x0020_Title='Director of Special Projects' />
   <z:row ows_Author='193;#Scott yyyyyy' ows_CampusVue_x0020_Modules='Admissions;#+2#Financial Aid;#+2#Student Services;#+2#Contact Manager;#+2#Student Accounts;#+2#Academic Records;#+2#Placement;#+2#Loan Management;#+2#' ows_Class_x0020_Modules='Admissions;#+3#Financial Aid;#+3#Student Accounts;#+3#Administration;#+3#Default Prevention;#+3#Activities;#+3#' ows_Analysis_x0020_and_x0020_Design='CASE Tools;#+3#OO Analysis and Design;#+4#OO Techniques using the UML;#+2#Patterns;#+2#RUP;#+5#Structured Analysis and Design;#+4#' ows_Type_x0020_your_x0020_question_x='Commerce Server;#+2#BizTalk Server;#+2#IIS;#+3#Lotus Notes and Domino Office;#+1#SharePoint Portal Server;#+2#SharePoint Services;#+2#Site Server;#+1#SNA/Host Integration Server Speech Server;#+1#Terminal Server;#+3#Windows Scripting Host;#+3#' ows_Business_x0020_applications='Great Plains;#+1#Microsoft Small Business Accounting;#+1#Quickbooks;#+2#Inventory Systems;#+2#Finance Systems;#+2#Shipping/Billing;#+2#Office Automation;#+4#Outlook/Exchange Integration;#+3#' ows_Architecture='.NET Framework Architecture;#+2#.NET Framework Class Libraries;#+2#.NET Compact Framework;#+2#2 Tier Client/Server Development;#+4#64 bit architecture;#+1#Active Directory Planning;#+1#Installation and Support;#+1#ADO;#+2#ADO.NET;#+2#ClientServer and Distributed Computing;#+2#COM;#+3#DCOM;#+3#COM+;#+3#DNA Framework Architecture;#+3#Microsoft Solutions Framework (MSF);#+3#n-tier Distributed Computing;#+3#' ows_Database_x0020_Technologies='Data Mining and Data Warehousing;#+3#Database Analysis and Design;#+3#Database performance tuning and monitoring;#+3#SQL Language (ANSI);#+4#T-SQL;#+2#P-SQL;#+2#SQL Server 2005 (Yukon);#+2#MSDE;#+2#Visual Foxpro;#+4#Access;#+4#' ows_Intranet_x002f_Internet='ASP;#+2#ASP.NET;#+2#Client-side scripting;#+3#DHTML;#+3#HTML;#+3#Visual Interdev;#+3#Server side scripting;#+3#SharePoint Web Parts;#+2#Web services development;#+2#WSDL;#+2#' ows_Type_x0020_your_x0020_question_x0='Windows CE;#+1#Pocket PC;#+1#WAP;#+1#Wireless networking technologies;#+1#' ows_Operating_x0020_Systems='DOS;#+3#Windows 95/98;#+3#Windows NT;#+3#Windows 2000;#+3#Windows XP;#+3#Windows 2003;#+3#Linux;#+1#Solaris;#+1#UNIX;#+1#' ows_Software_x0020_Development='64-bit Development;#+1#ActiveX;#+3#C programming;#+2#C# programming;#+2#Delphi;#+1#Java programming;#+3#VB programming;#+2#VB script;#+2#VBA;#+2#VB.NET programming;#+1#Visual FoxPro programming;#+4#Access programming;#+2#Visual Source Safe;#+3#OLE;#+3#ORACLE;#+2#XML;#+3#XPath;#+2#XSL;#+2#XSLT;#+2#' ows_Start_x0020_Date_x0020_at_x0020_='2002-08-15 00:00:00' ows_Actual_x0020_Title='Class Product Manager' />
   <z:row ows_Author='216;#xxxxx' ows_CampusVue_x0020_Modules='Admissions;#+4#Financial Aid;#+2#Student Services;#+1#Contact Manager;#+3#Student Accounts;#+3#Academic Records;#+3#Placement;#+3#Loan Management;#+1#' ows_Class_x0020_Modules='Admissions;#+1#Financial Aid;#+1#Student Accounts;#+1#Administration;#+1#Default Prevention;#+1#Activities;#+1#' ows_Analysis_x0020_and_x0020_Design='CASE Tools;#+4#OO Analysis and Design;#+4#OO Techniques using the UML;#+4#Patterns;#+3#RUP;#+2#Structured Analysis and Design;#+4#' ows_Type_x0020_your_x0020_question_x='Commerce Server;#+1#BizTalk Server;#+1#IIS;#+4#Lotus Notes and Domino Office;#+1#SharePoint Portal Server;#+1#SharePoint Services;#+1#Site Server;#+1#SNA/Host Integration Server Speech Server;#+1#Terminal Server;#+3#Windows Scripting Host;#+1#' ows_Business_x0020_applications='Great Plains;#+1#Microsoft Small Business Accounting;#+1#Quickbooks;#+1#Inventory Systems;#+1#Finance Systems;#+1#Shipping/Billing;#+1#Office Automation;#+1#Outlook/Exchange Integration;#+1#' ows_Architecture='.NET Framework Architecture;#+4#.NET Framework Class Libraries;#+4#.NET Compact Framework;#+3#2 Tier Client/Server Development;#+4#64 bit architecture;#+1#Active Directory Planning;#+1#Installation and Support;#+1#ADO;#+3#ADO.NET;#+4#ClientServer and Distributed Computing;#+4#COM;#+2#DCOM;#+2#COM+;#+2#DNA Framework Architecture;#+1#Microsoft Solutions Framework (MSF);#+4#n-tier Distributed Computing;#+4#' ows_Database_x0020_Technologies='Data Mining and Data Warehousing;#+1#Database Analysis and Design;#+4#Database performance tuning and monitoring;#+3#SQL Language (ANSI);#+4#T-SQL;#+4#P-SQL;#+1#SQL Server 2005 (Yukon);#+3#MSDE;#+3#Visual Foxpro;#+1#Access;#+3#' ows_Intranet_x002f_Internet='ASP;#+3#ASP.NET;#+4#Client-side scripting;#+4#DHTML;#+4#HTML;#+4#Visual Interdev;#+3#Server side scripting;#+4#SharePoint Web Parts;#+1#Web services development;#+4#WSDL;#+3#' ows_Type_x0020_your_x0020_question_x0='Windows CE;#+1#Pocket PC;#+1#WAP;#+3#Wireless networking technologies;#+3#WML;#+1#' ows_Operating_x0020_Systems='DOS;#+4#Windows 95/98;#+4#Windows NT;#+4#Windows 2000;#+4#Windows XP;#+4#Windows 2003;#+4#Linux;#+2#Solaris;#+1#UNIX;#+1#' ows_Software_x0020_Development='64-bit Development;#+1#ActiveX;#+1#C programming;#+3#C# programming;#+4#Delphi;#+1#Java programming;#+2#VB programming;#+2#VB script;#+3#VBA;#+1#VB.NET programming;#+3#Visual FoxPro programming;#+1#Access programming;#+1#Visual Source Safe;#+3#OLE;#+3#ORACLE;#+1#XML;#+4#XPath;#+4#XSL;#+4#XSLT;#+4#' ows_Start_x0020_Date_x0020_at_x0020_='2003-08-25 00:00:00' ows_Actual_x0020_Title='Developer' ows_Quality_x0020_Assurance_x0020_Me='Metrics and Data Analysis;#+3#Risk Analysis (Risk-Based Testing);#+1#Equivalence Partitioning and Boundary Value Analysis;#+1#Test Case Design;#+2#Defect Tracking Administration;#+3#' ows_Quality_x0020_Control_x0020_Meth='Peer Reviews;#+4#Black Box Testing;#+4#White Box Testing;#+1#Grey Box Testing;#+1#Exploratory Testing;#+4#Regression Testing;#+4#Test Automation;#+1#Performance/Load/Stress Testing;#+3#' />
</rs:data>
</xml>

...Y soy feliz, bien feliz, asi lo grito;
Mira, que el mundo sepa, que se sepa:
Soy feliz....                       

...And I'm happy, quite happy, so do I yell it;
Look, so the world knows it, so be known:
I'm happy...
 

Ismael Rivera "Oye cosita linda"
Next
Reply
Map
View

Click here to load this message in the networking platform