XML.au3 - BETA - Support Topic

[mLipok]

Thanks again. You have right, there was an inconsistency.

Function should be named: _XML_ValidateFile

[mLipok]

Have a nice reading.

A Beginner's Guide to the XML DOM
https://msdn.microsoft.com/en-us/library/aa468547.aspx
 

[blumi]

I have tried to use 1.1.1.13

When I include the XML.au3 to the script und run the script, I get errors

"C:\Program Files (x86)\AutoIt3\Include\XML.au3"(6,10) : warning: already included file: C:\Program Files (x86)\AutoIt3\Include\ADO_CONSTANTS.au3
#include "ADO_CONSTANTS.au3"

Tried to incluce the ADO_CONSTANTS.au3 in the xml.au3 with "<>" instead of ""

Now I get the following error

"C:\Program Files (x86)\AutoIt3\Include\XML.au3"(2619,42) : warning: $ADO_adReadAll: possibly used before declaration.
  $sXML_Return = .ReadText($ADO_adReadAll)

Edited December 13, 2017 by blumi

[mLipok]

at the top of ADO_CONSTANTS.au3 please add 

#include-once

 

[blumi]

Have still this one

"C:\Program Files (x86)\AutoIt3\Include\XML.au3"(2619,42) : warning: $ADO_adReadAll: possibly used before declaration.
  $sXML_Return = .ReadText($ADO_adReadAll)

Edited December 14, 2017 by blumi

[mLipok]

Which version of ADO.au3 and XML.au3  you have ?

 

[blumi]

1 hour ago, mLipok said:

Which version of ADO.au3 and XML.au3  you have ?

 

Now all works fine. Found my mistake.

[blumi]

Is it possible with the XML.au3 make a list with movie title, runtime, language and subtitle.

I tried some things, the most work fine, but I have problems with the language and subtitle.

Sometimes there are one, two or more languages or subtitles in the XML file.

Of course I Can post my code, but first I would like to know if it is possible?

Here is a short versione of a videodb.xml created with kodi.

https://www.dropbox.com/s/r48wjpno0qk0fn7/videodb_short.xml?dl=0

[mLipok]

21 minutes ago, blumi said:

I tried some things, the most work fine, but I have problems with the language and subtitle.

Sometimes there are one, two or more languages or subtitles in the XML file.

You mean this snippet:
 

Quote

                <subtitle>
                    <language>ger</language>
                </subtitle>
                <subtitle>
                    <language>eng</language>
                </subtitle> 

?

 

[blumi]

Yes, and the Audio sections.

They are often different, cause the movie has one, two or more audios.

Quote

                <audio>
                    <codec>mp3</codec>
                    <language>eng</language>
                    <channels>2</channels>
                </audio>

 

[mLipok]

How you are trying to handle this case ?

Quote

                <audio>
                    <codec>mp3</codec>
                    <language>ger</language>
                    <channels>2</channels>
                </audio>
                <audio>
                    <codec>mp3</codec>
                    <language>eng</language>
                    <channels>2</channels>
                </audio>  
                <subtitle>
                    <language>ger</language>
                </subtitle>
                <subtitle>
                    <language>eng</language>
                </subtitle>  

 

[blumi]

I tried all in one run.

Take all titles, runtimes, etc.

Make an Multi Array and later write to Excel.

But so I got only the first language and subtitle from the "streamdetails"

$titel = _XML_GetValue($oXmlDoc, "/videodb/movie/title")
    _ArrayDelete($titel, 0)
    
    $originaltitel = _XML_GetValue($oXmlDoc, "/videodb/movie/originaltitle")
    _ArrayDelete($originaltitel, 0)    

    $breite = _XML_GetValue($oXmlDoc, "/videodb/movie/fileinfo/streamdetails/video/width")
    _ArrayDelete($breite, 0)

    $hoehe = _XML_GetValue($oXmlDoc, "/videodb/movie/fileinfo/streamdetails/video/height")
    _ArrayDelete($hoehe, 0)
    
    $dauer = _XML_GetValue($oXmlDoc, "/videodb/movie/fileinfo/streamdetails/video/durationinseconds")
    _ArrayDelete($dauer, 0)    

    $sprache = _XML_GetValue($oXmlDoc, "/videodb/movie/fileinfo/streamdetails/audio/language")
    _ArrayDelete($hoehe, 0)
    
    $CounterMovie = _XML_GetNodesCount($oXmlDoc, "/videodb/movie")    
    Local $xarray[$CounterMovie][6]    
    
    For $i=0 To UBound($xarray) -1

        $xarray[$i][0] = $titel[$i]
        $xarray[$i][1] = $originaltitel[$i]
        $xarray[$i][2] = $breite[$i]&"x"&$hoehe[$i]     ; Breite x Höhe
        $xarray[$i][3] = Int(Round($dauer[$i]/60, 1))           ; Dauer in Sekunden umrechnen in Minuten, runden und in INT umwandeln
        $xarray[$i][4] = $pfad[$i]

    Next

 

Edited December 14, 2017 by blumi

[mLipok]

This following snippet will give you somethink to thing about:

Local $CounterMovie = _XML_GetNodesCount($oXmlDoc, "/videodb/movie")
For $iMovie_idx = 0 To $CounterMovie -1
    $titel = _XML_GetValue($oXmlDoc, "/videodb/movie[" & $iMovie_idx & "]/title")
    _ArrayDisplay($titel,'$titel')
    $originaltitel = _XML_GetValue($oXmlDoc, "/videodb/movie[" & $iMovie_idx & "]/originaltitle")
    _ArrayDisplay(...
    $breite = _XML_GetValue($oXmlDoc, "/videodb/movie[" & $iMovie_idx & "]/fileinfo/streamdetails/video/width")
    _ArrayDisplay(...
    $hoehe = _XML_GetValue($oXmlDoc, "/videodb/movie[" & $iMovie_idx & "]/fileinfo/streamdetails/video/height")
    _ArrayDisplay(...
    $sprache = _XML_GetValue($oXmlDoc, "/videodb/movie[" & $iMovie_idx & "]/fileinfo/streamdetails/audio/language")
    _ArrayDisplay(...
Next

 

EDIT: 
I hope that I do not screw up something in XPath.

Edited December 14, 2017 by mLipok

[blumi]

Yeah, this looks very nice, I will do some tests the next days.

Thank you very much.

[blumi]

Did some tests, now I could use codec and channels, too.

Local $CounterMovie = _XML_GetNodesCount($oXmlDoc, "/videodb/movie")

    For $iMovie_idx = 0 To $CounterMovie -1
    $titel = _XML_GetValue($oXmlDoc, "/videodb/movie[" & $iMovie_idx & "]/title")
    ;_ArrayDisplay($titel,'$titel')
    $originaltitel = _XML_GetValue($oXmlDoc, "/videodb/movie[" & $iMovie_idx & "]/originaltitle")
    ;_ArrayDisplay($originaltitel)
    $breite = _XML_GetValue($oXmlDoc, "/videodb/movie[" & $iMovie_idx & "]/fileinfo/streamdetails/video/width")
    ;_ArrayDisplay($breite)
    $hoehe = _XML_GetValue($oXmlDoc, "/videodb/movie[" & $iMovie_idx & "]/fileinfo/streamdetails/video/height")
    ;_ArrayDisplay($hoehe)
    $codec = _XML_GetValue($oXmlDoc, "/videodb/movie[" & $iMovie_idx & "]/fileinfo/streamdetails/audio/codec")
        $sprache = _XML_GetValue($oXmlDoc, "/videodb/movie[" & $iMovie_idx & "]/fileinfo/streamdetails/audio/language")
        $channels = _XML_GetValue($oXmlDoc, "/videodb/movie[" & $iMovie_idx & "]/fileinfo/streamdetails/audio/channels")

    ;_ArrayDisplay($sprache)
        _ArrayDisplay($codec)

        For $i = 0 To UBound($sprache) - 1
            If $sprache[$i] = "1" Then
                MsgBox(64, $ScriptName, "1: " & $sprache[$i+1] & " " & $codec[$i+1] & " " & $channels[$i+1])
            ElseIf $sprache[$i] = "2" Then
                MsgBox(64, $ScriptName, "1: " & $sprache[$i+1] & " " & $codec[$i+1] & " " & $channels[$i+1] & ", " & $sprache[$i+2] & " " & $codec[$i+1] & " " & $channels[$i+1])
            EndIf
        Next

Next

 

[blumi]

Why is the MsgBox not shown?

$titel is an Array and I want to Show the value with index 1

For $iMovie_idx = 0 To $CounterMovie -1
  $titel = _XML_GetValue($oXmlDoc, "/videodb/movie[" & $iMovie_idx & "]/title")
  _ArrayDisplay($titel)
  MsgBox(64, "", $titel[1])

==> Subscript used on non-accessible variable.:
MsgBox(64, "", $titel[1])
MsgBox(64, "", $titel^ ERROR

[blumi]

Help please

[mLipok]

On 15.12.2017 at 0:50 PM, blumi said:

Why is the MsgBox not shown?

$titel is an Array and I want to Show the value with index 1

For $iMovie_idx = 0 To $CounterMovie -1
  $titel = _XML_GetValue($oXmlDoc, "/videodb/movie[" & $iMovie_idx & "]/title")
  _ArrayDisplay($titel)
  MsgBox(64, "", $titel[1])

==> Subscript used on non-accessible variable.:
MsgBox(64, "", $titel[1])
MsgBox(64, "", $titel^ ERROR

Try this:

For $iMovie_idx = 0 To $CounterMovie -1
  $titel = _XML_GetValue($oXmlDoc, "/videodb/movie[" & $iMovie_idx & "]/title")
  _ArrayDisplay($titel)
  if UBound($titel[1], $UBOUND_DIMENSIONS) =1 and UBound($titel[1], $UBOUND_ROWS) >0 Then MsgBox(64, "", $titel[1])

 

[TheDcoder]

Has anyone managed to parse HTML with this UDF? I am having problems with "void tags" (tags which don't have the closing counterpart), I get errors during parsing... msxml complains about the mismatching closing tag (</head>) for <link>

Edited July 12, 2018 by TheDcoder

[mLipok]

Could you please prepare example file to reproduce this problem ?