PC SOFT

GRUPOS DE DISCUSSÃO PROFISSIONAL
WINDEV, WEBDEV e WINDEV Mobile

Inicio | Mensagens recentes | Conecte-se... |  | Português FR
Inicio → WINDEV 2024 → XML issues
XML issues
Iniciado por kel, dez., 20 2019 1:34 AM - 2 respostas
#1
Publicado em dezembro, 20 2019 - 1:34 AM
Hi I am having trouble with XML. I have imported and xsd file (All good)
-<MainRoot>
-<Consignment>
<ConsignmentNumber>CPA3AY0080235</ConsignmentNumber>
<ConsignmentDate>2019-12-17</ConsignmentDate>
<SenderName>Coty Australia Pty Ltd - CB</SenderName>
<SenderStreetAddress>LEVEL 31</SenderStreetAddress>
<SenderStreetAddress1/>
<SenderSuburb>SYDNEY</SenderSuburb>
<SenderState>NSW</SenderState>
<SenderPostcode>2000</SenderPostcode>
<Pickup>No</Pickup>
<Delivery>Yes</Delivery>
<DangerousGoods>YES</DangerousGoods>
<ReceiverName>Chemist WH Vic Point B157</ReceiverName>
<ReceiverStreetAddress>Shopj02 Victoria Point Lakesid</ReceiverStreetAddress>
<ReceiverStreetAddress1>11-13 Bunker Road</ReceiverStreetAddress1>
<ReceiverSuburb>VIC POINT</ReceiverSuburb>
<ReceiverState>QLD</ReceiverState>
<ReceiverPostcode>4165</ReceiverPostcode>
<TimeSlotDate>2019-12-11</TimeSlotDate>
<TimeSlotDate2>2019-12-20</TimeSlotDate2>
<Comments>2019-12-11 To 2019-12-20</Comments>
<ChargeTo/>
<CarrierService>BEP</CarrierService>
<TotalWeight>57.626</TotalWeight>
-<LoadDetails>
<ItemReference>26498223512</ItemReference>
<NumberOfUnits>1</NumberOfUnits>
<LogisticUnit>CARTON</LogisticUnit>
<Weight>7.992</Weight>
<Length>0.275</Length>
<Width>0.380</Width>
<Height>0.245</Height>
<Cubic>0.026</Cubic>
</LoadDetails>
-<LoadDetails>
<ItemReference>264982235</ItemReference>
<NumberOfUnits>1</NumberOfUnits>
<LogisticUnit>CARTON</LogisticUnit>
<Weight>2.564</Weight>
<Length>0.275</Length>
<Width>0.380</Width>
<Height>0.245</Height>
<Cubic>0.026</Cubic>
</LoadDetails>
-<LoadDetails>
<ItemReference>2649822356</ItemReference>

I use the following code
FOR EACH LoadDetails OF xmldocumnentone.MainRoot

detcons.LineNumber = nCurrentlinenumber
nCurrentlinenumber ++
detcons.id = sTempid
detcons.Reference = Consignment.LoadDetails.ItemReference
detcons.Items = Consignment.LoadDetails.NumberOfUnits
detcons.Description = Consignment.LoadDetails.LogisticUnit
detcons.weight = Consignment.LoadDetails.Weight
rSLenstring = Consignment.LoadDetails.Length
rSWidthstring = Consignment.LoadDetails.Width
rSHeightstring = Consignment.LoadDetails.Height
detcons.Length = (rSLenstring * 1000)

detcons.Width = (rSWidthstring * 1000)
detcons.Height = (rSHeightstring * 1000)
detcons.LineCubic = Consignment.LoadDetails.Cubic
detcons.LabelsPrinted = 1

Cons.CUBIC += detcons.LineCubic
HAdd(detcons)
The problem is it keeps reading the same record over and over
any help would be grate
#2
Membro registado
52 mensagems
Popularité : +3 (3 votes)
Publicado em dezembro, 20 2019 - 9:56 AM
after the last line "<ItemReference>2649822356</ItemReference>" you must "close" the XML, so you must have

<ItemReference>2649822356</ItemReference>
</LoadDetails>
</Consignment>
</MainRoot>

also I think you can not use:

FOR EACH LoadDetails OF xmldocumnentone.MainRoot

because MainRoot doesn't owns a node "LoadDetails", but "Consignment" so you must use

for each Consignment OF xmldocumnentone.MainRoot

or

for EACH LoadDetails OF xmldocumnentone.MainRoot.Consignment
Mensagem modificada, dezembro, 20 2019 - 10:20 AM
#3
Publicado em dezembro, 23 2019 - 9:33 AM
hi it takes the same record again and again . Walk through it withthe debeugger and you will see that

use : Consignment.LoadDetails[ counter ].ItemReference

in your case I guess ===> nCurrentlinenumber ==> Consignment.LoadDetails[ nCurrentlinenumber ].ItemReference


regards
→ Voltar para WINDEV 2024