XMLTOCURSOR problem - Level Extreme

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

XMLTOCURSOR problem

Message

From

26/07/2011 06:29:52

Tore Bleken (Online)
Vear, Norway

26/07/2011 06:22:23

Bernhart Milcent
Amline S.A.
Oupeye, Belgium

General information

Forum:

Visual FoxPro

Category:

Coding, syntax & commands

Title:

Re: XMLTOCURSOR problem

Environment versions

Visual FoxPro:

VFP 9 SP2

OS:

Windows Server 2008

Miscellaneous

Thread ID:

01519156

Message ID:

01519157

Views:

See Message ID: 1406289

>i have this file MR.XLM
>
>
>

><?xml version="1.0" encoding="ISO-8859-1"?>
><MR>
>  <groups>
>    <group>
>      <group-id>1</group-id>
>      <group-Name>Aides soignants</group-Name>
>    </group>
>    <group>
>      <group-id>2</group-id>
>      <group-Name>Infirmiers</group-Name>
>    </group>
>    <group>
>      <group-id>3</group-id>
>      <group-Name>Service technique</group-Name>
>    </group>
>  </groups>
>  <AllStaff>
>    <Staff>
>      <Staff-id>31</Staff-id>
>      <Staff-code>458</Staff-code>
>      <Staff-fname>Angela</Staff-fname>
>      <Staff-lname>Carobbio</Staff-lname>
>      <group-id>1</group-id>
>    </Staff>
>    <Staff>
>      <Staff-id>28</Staff-id>
>      <Staff-code>233</Staff-code>
>      <Staff-fname>Anne</Staff-fname>
>      <Staff-lname>Carton</Staff-lname>
>      <group-id>2</group-id>
>    </Staff>
>    <Staff>
>      <Staff-id>17</Staff-id>
>      <Staff-code>143</Staff-code>
>      <Staff-fname>SABINE</Staff-fname>
>      <Staff-lname>CHEVALIER</Staff-lname>
>      <group-id>3</group-id>
>    </Staff>
>    <Staff>
>      <Staff-id>27</Staff-id>
>      <Staff-code>99</Staff-code>
>      <Staff-fname>Claude</Staff-fname>
>      <Staff-lname>Deleuze</Staff-lname>
>      <group-id>1</group-id>
>    </Staff>
>  </AllStaff>
>  <srvs>
>    <srv>
>      <srv-id>1</srv-id>
>      <srv-Name>1er étage</srv-Name>
>    </srv>
>    <srv>
>      <srv-id>2</srv-id>
>      <srv-Name>Rez</srv-Name>
>    </srv>
>  </srvs>
>  <doctors>
>    <doctor>
>      <doctor-id>1</doctor-id>
>      <doctor-fName>Bruno</doctor-fName>
>      <doctor-lName>Cambier</doctor-lName>
>      <doctor-phone>0123456789</doctor-phone>
>    </doctor>
>    <doctor>
>      <doctor-id>2</doctor-id>
>      <doctor-fName>Christophe</doctor-fName>
>      <doctor-lName>Durieux</doctor-lName>
>      <doctor-phone>066998855</doctor-phone>
>    </doctor>
>  </doctors>
>  <beds>
>    <bed>
>      <bed-id>940</bed-id>
>      <bed-room>12</bed-room>
>      <bed-num>1</bed-num>
>      <bed-srv>2</bed-srv>
>    </bed>
>    <bed>
>      <bed-id>970</bed-id>
>      <bed-room>105</bed-room>
>      <bed-num>2</bed-num>
>      <bed-srv>1</bed-srv>
>    </bed>
>    <bed>
>      <bed-id>18</bed-id>
>      <bed-room>118</bed-room>
>      <bed-num>1</bed-num>
>      <bed-srv>1</bed-srv>
>    </bed>
>    <bed>
>      <bed-id>237</bed-id>
>      <bed-room>18</bed-room>
>      <bed-num>1</bed-num>
>      <bed-srv>2</bed-srv>
>    </bed>
>   </beds>
>  <boarders>
>    <boarder>
>        <boarder-id>123</boarder-id>
>        <boarder-fName>Denise</boarder-fName>
>        <boarder-lName>Goret</boarder-lName>
>        <boarder-bed>940</boarder-bed>
>        <boarder-doctor>2</boarder-doctor>
>     </boarder>
>    <boarder>
>      <boarder-id>244</boarder-id>
>      <boarder-fName>Pierre</boarder-fName>
>      <boarder-lName>Dupont</boarder-lName>
>      <boarder-bed>970</boarder-bed>
>    </boarder>
>    <boarder>
>      <boarder-id>180</boarder-id>
>      <boarder-fName>Coraline</boarder-fName>
>      <boarder-lName>Lison</boarder-lName>
>      <boarder-bed>18</boarder-bed>
>      <boarder-doctor>1</boarder-doctor>
>    </boarder>
>  </boarders>
>  <cares>
>    <care>
>      <care-id>1</care-id>
>      <care-Name>Plan de soins</care-Name>
>    </care>
>    <care>
>      <care-id>10</care-id>
>      <care-Name>Habillage</care-Name>
>      <care-up>1</care-up>
>    </care>
>    <care>
>      <care-id>101</care-id>
>      <care-Name>Aide partielle</care-Name>
>      <care-value>0</care-value>
>      <care-groupsOK>
>        <group-id>1</group-id>
>        <group-id>2</group-id>
>      </care-groupsOK>
>      <care-up>10</care-up>
>    </care>
>    <care>
>      <care-id>102</care-id>
>      <care-Name>Aide totale</care-Name>
>      <care-value>0</care-value>
>      <care-groupsOK>
>        <group-id>1</group-id>
>        <group-id>2</group-id>
>      </care-groupsOK>
>      <care-up>10</care-up>
>    </care>
>    <care>
>      <care-id>11</care-id>
>      <care-Name>Toilette</care-Name>
>      <care-up>1</care-up>
>    </care>
>    <care>
>      <care-id>111</care-id>
>      <care-Name>Douche</care-Name>
>      <care-value>0</care-value>
>      <care-groupsOK>
>        <group-id>1</group-id>
>      </care-groupsOK>
>      <care-up>11</care-up>
>    </care>
>    <care>
>      <care-id>112</care-id>
>      <care-Name>Toilette au Lavabo</care-Name>
>      <care-value>0</care-value>
>      <care-groupsOK>
>        <group-id>1</group-id>
>      </care-groupsOK>
>      <care-up>11</care-up>
>    </care>
>    <care>
>      <care-id>113</care-id>
>      <care-Name>Mettre au WC</care-Name>
>      <care-value>0</care-value>
>      <care-groupsOK>
>        <group-id>1</group-id>
>        <group-id>2</group-id>
>      </care-groupsOK>
>      <care-up>11</care-up>
>    </care>
>    <care>
>      <care-id>12</care-id>
>      <care-Name>Alimentation</care-Name>
>      <care-up>1</care-up>
>    </care>
>    <care>
>      <care-id>121</care-id>
>      <care-Name>Conduire au restaurant</care-Name>
>      <care-value>0</care-value>
>      <care-groupsOK>
>        <group-id>1</group-id>
>        <group-id>2</group-id>
>      </care-groupsOK>
>      <care-up>12</care-up>
>    </care>
>    <care>
>      <care-id>128</care-id>
>      <care-Name>Hydrater</care-Name>
>      <care-value>0</care-value>
>      <care-groupsOK>
>        <group-id>1</group-id>
>        <group-id>2</group-id>
>      </care-groupsOK>
>      <care-up>12</care-up>
>    </care>
>    <care>
>      <care-id>2</care-id>
>      <care-Name>Biométries</care-Name>
>    </care>
>    <care>
>      <care-id>21</care-id>
>      <care-Name>Température</care-Name>
>      <care-value>2</care-value>
>      <care-min>35</care-min>
>      <care-max>45</care-max>
>      <care-unit>°C</care-unit>
>      <care-groupsOK>
>        <group-id>1</group-id>
>        <group-id>2</group-id>
>      </care-groupsOK>
>      <care-up>2</care-up>
>    </care>
>    <care>
>      <care-id>23</care-id>
>      <care-Name>Tension</care-Name>
>      <care-value>3</care-value>
>      <care-unit>mmHg</care-unit>
>      <care-groupsOK>
>        <group-id>2</group-id>
>      </care-groupsOK>
>      <care-up>2</care-up>
>    </care>
>  </cares>
>  <products>
>    <product>
>      <product-id>0</product-id>
>      <product-Name>Produits</product-Name>
>    </product>
>    <product>
>      <product-id>1</product-id>
>      <product-Name>Boissons</product-Name>
>      <product-up>0</product-up>
>    </product>
>    <product>
>      <product-id>11</product-id>
>      <product-Name>Eau 25 cl</product-Name>
>      <product-cost>1.00</product-cost>
>      <product-groupsOK>
>        <group-id>2</group-id>
>      </product-groupsOK>
>      <product-up>1</product-up>
>    </product>
>    <product>
>      <product-id>12</product-id>
>      <product-Name>Coca 33 cl</product-Name>
>      <product-cost>1.25</product-cost>
>      <product-groupsOK>
>        <group-id>2</group-id>
>      </product-groupsOK>
>      <product-up>1</product-up>
>    </product>
>    <product>
>      <product-id>2</product-id>
>      <product-Name>Fruits</product-Name>
>      <product-up>0</product-up>
>    </product>
>    <product>
>      <product-id>21</product-id>
>      <product-Name>Pomme</product-Name>
>      <product-groupsOK>
>        <group-id>1</group-id>
>        <group-id>2</group-id>
>      </product-groupsOK>
>      <product-up>2</product-up>
>    </product>
>    <product>
>      <product-id>22</product-id>
>      <product-Name>Raisin</product-Name>
>      <product-cost>1.50</product-cost>
>      <product-groupsOK>
>        <group-id>2</group-id>
>      </product-groupsOK>
>      <product-up>2</product-up>
>    </product>
>  </products>
></MR>
>

>
>when i try to import into a cursor ,
>
>

>XMLTOCURSOR('MR.xml','Temp',512)
>set
>SELECT temp
>browse
>

>
> i have this result :
>http://www.amline.be/UT_DOC/ut1.jpg
>
>The result is strong...
>why ?
>
>thank in advance for help
>
>
>bernhart

Gone phishing

How to create sample data

Map

View

Click here to load this message in the networking platform