Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
XML to tables?
Message
From
04/12/2007 14:19:40
Elyse Pomerantz
Dynamic Data Concepts, Inc.
Brooklyn, New York, United States
 
General information
Forum:
Visual FoxPro
Category:
XML, XSD
Title:
Miscellaneous
Thread ID:
01273112
Message ID:
01273121
Views:
25
This is all I have - just the XML file.

>Do you have XML Schema (XSD) for it?
>
>>I haven't really worked with XML at all but now I need to get an XML file into VFP tables (and back). My XML file looks something like this (very simplified) - where do I start?
>>
>>
>><?xml version="1.0" encoding="windows-1252" ?>
>>   - <BATCH_FILE>
>>      - <CLASS>
>>           <ACTION>ADD</ACTION>
>>           <CLASS_CODE>ADY2107</CLASS_CODE>
>>           <CLASS_START_DATE>2006/01/19</CLASS_START_DATE>
>>           <CLASS_END_DATE>2006/06/15</CLASS_END_DATE>
>>           <CLASS_TYPE>NA</CLASS_TYPE>
>>           <LANGUAGE_TYPE>E</LANGUAGE_TYPE>
>>           <CLASSROOM_TYPE>1</CLASSROOM_TYPE>
>>         - <SEGMENT>
>>              <ACTION>ADD</ACTION>
>>              <MINISTRY_DFND_CRS>SBI3C</MINISTRY_DFND_CRS>
>>              <LOCAL_DEV_CRS />
>>              <CREDIT_VALUE>01.00</CREDIT_VALUE>
>>           </SEGMENT>
>>         - <SEGMENT>
>>              <ACTION>ADD</ACTION>
>>              <MINISTRY_DFND_CRS>SBI3U</MINISTRY_DFND_CRS>
>>              <LOCAL_DEV_CRS />
>>              <CREDIT_VALUE>01.00</CREDIT_VALUE>
>>           </SEGMENT>
>>      </CLASS>
>>    - <CLASS>
>>           <ACTION>ADD</ACTION>
>>           <CLASS_CODE>ADY2109</CLASS_CODE>
>>           <CLASS_START_DATE>2005/09/06</CLASS_START_DATE>
>>           <CLASS_END_DATE>2006/06/15</CLASS_END_DATE>
>>           <CLASS_TYPE>NA</CLASS_TYPE>
>>           <LANGUAGE_TYPE>E</LANGUAGE_TYPE>
>>           <CLASSROOM_TYPE>1</CLASSROOM_TYPE>
>>         - <SEGMENT>
>>              <ACTION>ADD</ACTION>
>>              <MINISTRY_DFND_CRS>SNC2D</MINISTRY_DFND_CRS>
>>              <LOCAL_DEV_CRS />
>>              <CREDIT_VALUE>01.00</CREDIT_VALUE>
>>           </SEGMENT>
>>         - <SEGMENT>
>>              <ACTION>ADD</ACTION>
>>              <MINISTRY_DFND_CRS>SNC2P</MINISTRY_DFND_CRS>
>>              <LOCAL_DEV_CRS />
>>              <CREDIT_VALUE>01.00</CREDIT_VALUE>
>>           </SEGMENT>
>>      </CLASS>
>>  </BATCH_FILE>
>>
Elyse Pomerantz
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform