XML.au3 - BETA - Support Topic

mLipok · October 11, 2017

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

Function should be named: _XML_ValidateFile

mLipok · October 20, 2017

Have a nice reading.

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

blumi · December 13, 2017

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 · December 13, 2017

at the top of ADO_CONSTANTS.au3 please add

#include-once

blumi · December 13, 2017

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 · December 14, 2017

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

blumi · December 14, 2017

1 hour ago, mLipok said:

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

Now all works fine. Found my mistake.

blumi · December 14, 2017

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 · December 14, 2017

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 · December 14, 2017

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 · December 14, 2017

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 · December 14, 2017

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 · December 14, 2017

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 · December 14, 2017

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

Thank you very much.

blumi · December 15, 2017

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 · December 15, 2017

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 · December 20, 2017

Help please

mLipok · January 11, 2018

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 · July 12, 2018

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 · July 12, 2018

Could you please prepare example file to reproduce this problem ?

XML.au3 - BETA - Support Topic

Recommended Posts

Link to comment

Share on other sites

Top Posters In This Topic

Top Posters In This Topic

Popular Posts

mLipok

TheXman

guinness

Posted Images

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Create an account or sign in to comment

Create an account

Sign in

Recently Browsing 0 members

Similar Content