59230_en-US

liliconcom

Odd XML formatting

Hi. Got an esoteric problem. I'm getting confident with JSL and need to build a custom importer for a strangely formatted XML file. I'm concerned that the JSL parser does not work on my formatting, as it is different from every example file I've found. 

 

XML examples are formatted like: 

x:FullRows="1">nameage ...  While mine looks like:04Y054F71538-01 Note that the data is stored between angled brackets, not inside the angled brackets. My testing code is as follows  xmlStr = Load Text File( My testing data above ); nt = New Table( "Testing Table", New Column("Lot Number", Character), New Column("PUID", Character) ); iRow=0; Parse XML( xmlStr, On Element( "LOT_REPORT_TRX", Start Tag( nt << add row(1); iRow++; ) ), On Element( "LOT_REPORT", Start Tag( nt:Lot Number[iRow] = XML Attr( "LOT_NUMBER" ); ) ), );But it returns only blank cells, and I can't figure out why. For now I'm just trying to pull out any data at all, so the code only covers one element. Any thoughts or documentation suggestions?  Re: Odd XML formatting

Fantastic, those are really helpful. 

 

Thanks

Re: Odd XML formatting

XML format uses nested tags, and the Parse XML() code is dependent upon the file structure.

 

Attached are 2 examples of simulated XML files.You did not provide enough detail to know the actual structure of your file.  For example one ex1.xml.txt there is one TRX (transaction and numerous Lot and Part tags). This emulates a by day or by persson type file.

 

The second file ex2.xml.txt emulates the scenario where each lot and each part is its own transaction TRX.  The attached script parses both. 

Note you wil need to rename the examples (drop the .txt).

 

There are times that XML files will have header information followed by many rows or column wise or cell wise.

 

Hope this helps.