pcsoft.us.windevCopyright 2026, PC SOFT12 Jul 2018 21:35:00 Z12 Jul 2018 15:39:00 ZHello All, Trying to read a xml file with 37,000 lines to Import into data files the data will go in 5 different files OrderHeader OrderDetail OrderOptions PackingListItems PackingList First tried to use hImportxml but this has issues because the way the scheme of the xml file is set up. So I need to loop thru and get each data set separate. -?xml version="1.0" encoding="ISO-8859-1"?- (OrderAndShipments) Root Node (OrderHeaders) First Order Header (SONumber)00333861-00(/SONumber) (PONumber)N43510WL1(/PONumber) (OrderDate)060118(/OrderDate) (/OrderHeaders) (OrderHeaders) (SONumber)00333871-00(/SONumber) (PONumber)N43506WL1(/PONumber) (OrderDate)060118(/OrderDate) (/OrderHeaders) (OrderDetails) First Order Detail (SONumber)00341237-00(/SONumber) (OrderLineNumber)16.00(/OrderLineNumber) (Quantity)1.000(/Quantity) (ProductCode)B27(/ProductCode) (ProductDesciption)BASE 27 DRW(/ProductDesciption) (CabinetType)CB(/CabinetType) (Tag)ICP-815KIT-RS(/Tag) (OptionLines)3(/OptionLines) (/OrderDetails) (OrderDetails) (SONumber)00341237-00(/SONumber) (OrderLineNumber)17.00(/OrderLineNumber) (Quantity)1.000(/Quantity) (ProductCode)B30(/ProductCode) (ProductDesciption)BASE 30 DRW(/ProductDesciption) (CabinetType)CB(/CabinetType) (Tag)ICP-815KIT-RS(/Tag) (OptionLines)3(/OptionLines) (/OrderDetails) (OrderDetailOptions) (OrderDetailOptions) (SONumber)00341553-00(/SONumber) (OrderLineNumber)2.00(/OrderLineNumber) (OptionText)MITER RIGHT: MITRER(/OptionText) (/OrderDetailOptions) (OrderDetailOptions) (SONumber)00341553-00(/SONumber) (OrderLineNumber)2.00(/OrderLineNumber) (OptionText)MITER RIGHT: MITRER(/OptionText) (/OrderDetailOptions) (PackingListItems) (LoadNumber)4117127(/LoadNumber) (BOLNumber)101091240100(/BOLNumber) (TopLevelPackageID)(/TopLevelPackageID) (PackageID)003384550290000001(/PackageID) (PackageItemCount)1(/PackageItemCount) (PackageType)BOX(/PackageType) (PackageItemType)CABINETS(/PackageItemType) (SONumber)00338455-0(/SONumber) (OrderLineNumber)29.00(/OrderLineNumber) (ShippedQuantity)1(/ShippedQuantity) (LoadedDate)180626202433(/LoadedDate) (/PackingListItems) (PackingListItems) (LoadNumber)4117127(/LoadNumber) (BOLNumber)101091240100(/BOLNumber) (TopLevelPackageID)(/TopLevelPackageID) (PackageID)003384550310000001(/PackageID) (PackageItemCount)1(/PackageItemCount) (PackageType)BOX(/PackageType) (PackageItemType)CABINETS(/PackageItemType) (SONumber)00338455-00(/SONumber) (OrderLineNumber)31.00(/OrderLineNumber) (ShippedQuantity)1(/ShippedQuantity) (LoadedDate)180626223336(/LoadedDate) (/PackingListItems) (PackingListItems) (LoadNumber)4117127(/LoadNumber) (BOLNumber)101091240100(/BOLNumber) (TopLevelPackageID)(/TopLevelPackageID) (PackageID)003384550310000002(/PackageID) (PackageItemCount)1(/PackageItemCount) (PackageType)BOX(/PackageType) (PackageItemType)CABINETS(/PackageItemType) (SONumber)00338455-00(/SONumber) (OrderLineNumber)31.00(/OrderLineNumber) (ShippedQuantity)1(/ShippedQuantity) (LoadedDate)180626221706(/LoadedDate) (/PackingListItems) with this code IF sFile <> "" THEN XMLDoc is a xmlDocument // Open the XML file XMLDoc = XMLOpen(sFile) nCounter is int=1 MainNode is a xmlNode EntryNode is a xmlNode FOR EACH MainNode OF XMLDoc.OrderAndShipments // Browse the children of the STARTERS node IF XMLDoc.OrderAndShipments.OrderHeaders..Name = "OrderHeaders" FOR EACH EntryNode OF XMLDoc.OrderAndShipments.OrderHeaders Trace(XMLDoc.OrderAndShipments.OrderHeaders..Name + TAB + EntryNode..Name + TAB + EntryNode..Text) END END nCounter+=1 Trace(nCounter) END END The issue is it only reads the first set of OrderHeaders. There are 576 Order Headers then 12,000 Order Deatils and then 12,000 PacklistItems30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/66141-read-xml-file-wd23/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/66141-read-xml-file-wd23-66149/read.awp12 Jul 2018 21:35:00 ZHi Dennis what I was saying: - import the xml file in the analysis - code the REAL import with MyFile.MyField=MyXMLFile=M…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/66141-read-xml-file-wd23-66149/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/66141-read-xml-file-wd23-66149/read.awpRead XML File WD23guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/66141-read-xml-file-wd23-66147/read.awp12 Jul 2018 18:59:00 ZHello Fabrice, Do not not get what you are telling me but I did come to a solution. One thing I noticed about the conversion…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/66141-read-xml-file-wd23-66147/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/66141-read-xml-file-wd23-66147/read.awpRead XML File WD23guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/66141-read-xml-file-wd23-66145/read.awp12 Jul 2018 17:55:00 Zwell... Now that the files are described in your analysis, you can just do a changedir to read the daily files in whatever di…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/66141-read-xml-file-wd23-66145/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/66141-read-xml-file-wd23-66145/read.awpRead XML File WD23guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/66141-read-xml-file-wd23-66144/read.awp12 Jul 2018 17:24:00 ZHello Frabice, Yes I did that and it works like a charm. Now if I can only reproduce that in code because I need to do it eve…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/66141-read-xml-file-wd23-66144/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/66141-read-xml-file-wd23-66144/read.awpRead XML File WD23guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/66141-read-xml-file-wd23-66143/read.awp12 Jul 2018 15:54:00 ZDd you try with the code provided in this help page: https://doc.windev.com/en-US/?3081042&name=Example_for_using_the_XML_typeshttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/66141-read-xml-file-wd23-66143/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/66141-read-xml-file-wd23-66143/read.awpRead XML File WD23guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/66141-read-xml-file-wd23-66142/read.awp12 Jul 2018 15:53:00 ZHi Dennis, you can try to add the files directly into the analysis (xml IS a supported format)... You should end up with y…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/66141-read-xml-file-wd23-66142/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/66141-read-xml-file-wd23-66142/read.awpRead XML File WD23