Madbit's XML Plugin - More Questions

Author

Message

freight hopper

22

Years of Service

User Offline

Joined: 26th Dec 2003

Location: Just beyond the Dunsmuir yard limits

Posted: 28th Mar 2012 18:29

Link

Posting here because his Program Announcements entry is now locked.

Hi Madbit. Want to start using your plugin on some large, real-world xml files but

have a few questions and problems.

The first is that when I run the example code provided for the XML GET NEXT ELEMENT

command,

XML OPEN DOCUMENT "test.xml", 1

XML INSERT DECLARATION 1, "1.0", "UTF-8", "yes"

XML SET ELEMENTS ABSOLUT 1, "root/folder1/folder2", 2

XML SET ELEMENTS RELATIVE 2, "folder3"

XML GET PARENT ELEMENT 2, 2

XML SET ELEMENTS RELATIVE 2, "folder3"

XML GET PARENT ELEMENT 2, 2

XML SET ELEMENTS RELATIVE 2, "folder3"

XML GET PARENT ELEMENT 2, 2

XML INSERT COMMENT 2, "This Element has three Childs with the same Name."

XML SET ELEMENT TEXT 2, "This element contains text. ;)"

XML DUPLICATE ELEMENT 2, 2

XML SAVE DOCUMENT 1

XML RELEASE ELEMENT 1

XML RELEASE ELEMENT 2

XML CLOSE DOCUMENT 1

XML OPEN DOCUMENT "test.xml", 1

XML LOAD DOCUMENT 1

XML GET ROOT ELEMENT 1, 1

XML GET ELEMENT 1, "folder1/folder2", 2

PRINT "Rootelement: "+XML GET ELEMENT NAME (1)

PRINT "Element: "+XML GET ELEMENT NAME (2)

PRINT " Numbers of Childs: " + str$(XML COUNT CHILDS (2))

PRINT " Childlist:"

XML GET CHILD ELEMENT 2, 3

WHILE XML IS VALID ELEMENT (3)

PRINT " >" + XML GET ELEMENT TYPE (3) + "< " + XML GET ELEMENT NAME (3)

XML GET NEXT ELEMENT 3, 3

ENDWHILE

XML RELEASE ELEMENT 1

XML RELEASE ELEMENT 2

XML RELEASE ELEMENT 3

XML CLOSE DOCUMENT 1

WAIT KEY

+ Code Snippet

XML OPEN DOCUMENT "test.xml", 1

XML INSERT DECLARATION 1, "1.0", "UTF-8", "yes"

XML SET ELEMENTS ABSOLUT 1, "root/folder1/folder2", 2




XML SET ELEMENTS RELATIVE 2, "folder3"

XML GET PARENT ELEMENT 2, 2

XML SET ELEMENTS RELATIVE 2, "folder3"

XML GET PARENT ELEMENT 2, 2

XML SET ELEMENTS RELATIVE 2, "folder3"

XML GET PARENT ELEMENT 2, 2

XML INSERT COMMENT 2, "This Element has three Childs with the same Name."

XML SET ELEMENT TEXT 2, "This element contains text. ;)"




XML DUPLICATE ELEMENT 2, 2

XML DUPLICATE ELEMENT 2, 2




XML SAVE DOCUMENT 1

XML RELEASE ELEMENT 1

XML RELEASE ELEMENT 2

XML CLOSE DOCUMENT 1




XML OPEN DOCUMENT "test.xml", 1

XML LOAD DOCUMENT 1

XML GET ROOT ELEMENT 1, 1

XML GET ELEMENT 1, "folder1/folder2", 2

PRINT "Rootelement: "+XML GET ELEMENT NAME (1)

PRINT "Element: "+XML GET ELEMENT NAME (2)

PRINT " Numbers of Childs: " + str$(XML COUNT CHILDS (2))

PRINT " Childlist:"

XML GET CHILD ELEMENT 2, 3

WHILE XML IS VALID ELEMENT (3)

PRINT " >" + XML GET ELEMENT TYPE (3) + "< " + XML GET ELEMENT NAME (3)

XML GET NEXT ELEMENT 3, 3

ENDWHILE




XML RELEASE ELEMENT 1

XML RELEASE ELEMENT 2

XML RELEASE ELEMENT 3

XML CLOSE DOCUMENT 1




WAIT KEY

I get an unexpected result. It reports 5 children. I would expect 3 (see attached graphic on this entry and another on the following)

Back to top

Profile PM Email

freight hopper

22

Years of Service

User Offline

Joined: 26th Dec 2003

Location: Just beyond the Dunsmuir yard limits

Posted: 28th Mar 2012 18:32

Link

Attached is a graphic of the "tree". Looks like 3 children to me.

Back to top

Profile PM Email

MadBit

VIP Member

Gold Codemaster

17

Years of Service

User Offline

Joined: 25th Jun 2009

Location: Germany

Posted: 28th Mar 2012 21:15

Link

Hi,
so far everything is correct. Each comment-node and text-node is also a child. So 5 Children are shown (3 elements, 1 comment and 1 text).

With Computers you can solve Problems that you have never befor.
Share your knowledge. It's a way to achieve immortality. (Tenzin Gyatso)

Back to top

Profile PM Email

freight hopper

22

Years of Service

User Offline

Joined: 26th Dec 2003

Location: Just beyond the Dunsmuir yard limits

Posted: 28th Mar 2012 22:09

Link

OK, thanks for the clarification.

Another question. In the example below, I want the 5th element and can get its name and text just fine.

+ Code Snippet

global docnum = 1
global rootnum = 1

XML OPEN DOCUMENT "zoo4.xml", docnum

XML LOAD DOCUMENT docnum
XML GET ROOT ELEMENT docnum, rootnum

name$ = XML GET ELEMENT NAME(rootnum)

PRINT "name of root: " + name$

PRINT "Number of Children: " + STR$(XML COUNT CHILDS (1))

want = 5
GetChildByNumber(1, 2, want)
PRINT "child: " + XML GET ELEMENT NAME (2) + "  " + xml get text (2)

WAIT KEY
END



FUNCTION GetChildByNumber(parent AS INTEGER, result as INTEGER, number as INTEGER)
	XML GET CHILD ELEMENT parent, result

	count = 1
	WHILE count < number
		XML GET NEXT ELEMENT result, result
		INC count
	ENDWHILE
ENDFUNCTION

remstart
use following for zoo4.xml

<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<ZOO>
	<DESERT>Mojave</DESERT>
	<JUNGLE>Indian</JUNGLE>
	<JUNGLE>Brazilian</JUNGLE>
	<JUNGLE>Congo</JUNGLE>
	<SAVANNAH>African</SAVANNAH>
	<SAVANNAH>California Oak</SAVANNAH>
</ZOO>
remend

In the following example, which has "mixed content" (sub-elements and text), I can't seem to get the text.

global docnum = 1
global rootnum = 1

XML OPEN DOCUMENT "zoo3.xml", docnum

XML LOAD DOCUMENT docnum
XML GET ROOT ELEMENT docnum, rootnum

name$ = XML GET ELEMENT NAME(rootnum)

PRINT "name of root: " + name$

PRINT "Number of Children: " + STR$(XML COUNT CHILDS (1))
want = 5

GetChildByNumber(1, 2, want)
PRINT "child name: " + XML GET ELEMENT NAME (2) + "   child text: " + xml get text (2)

WAIT KEY
END

FUNCTION GetChildByNumber(parent AS INTEGER, result as INTEGER, number as INTEGER)
	XML GET CHILD ELEMENT parent, result

count = 1
	WHILE count < number
		XML GET NEXT ELEMENT result, result
		INC count
	ENDWHILE
ENDFUNCTION

remstart
use the following for zoo3.xml

<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<ZOO>
	<DESERT>
		<BIRD>Roadrunner</BIRD>
		<BIRD>Wren</BIRD>
		<MAMMAL>Coyote</MAMMAL>
		<REPTILE>Rattlesnake</REPTILE>
		Mojave
	</DESERT>
	<JUNGLE>
		<BIRD>Peacock</BIRD>
		<MAMMAL>Chital</MAMMAL>
		<MAMMAL>Tiger</MAMMAL>
		<REPTILE>Cobra</REPTILE>
		Indian
	</JUNGLE>
	<JUNGLE>
		<BIRD>Toucan</BIRD>
		<MAMMAL>Coati</MAMMAL>
		<MAMMAL>Anteater</MAMMAL>
		<REPTILE>Anaconda</REPTILE>
		Brazilian
	</JUNGLE>
	<JUNGLE>
		<BIRD>Guineafowl</BIRD>
		<MAMMAL>Gorilla</MAMMAL>
		<MAMMAL>Civit</MAMMAL>
		<REPTILE>Green Mambo</REPTILE>
		Congo
	</JUNGLE>
	<SAVANNAH>
		<BIRD>Ostrich</BIRD>
		<MAMMAL>Zebra</MAMMAL>
		<MAMMAL>Lion</MAMMAL>
		<REPTILE>Crocodile</REPTILE>
		African
	</SAVANNAH>
</ZOO>
remend

+ Code Snippet

global docnum = 1
global rootnum = 1

XML OPEN DOCUMENT "zoo3.xml", docnum

XML LOAD DOCUMENT docnum
XML GET ROOT ELEMENT docnum, rootnum

name$ = XML GET ELEMENT NAME(rootnum)

PRINT "name of root: " + name$


PRINT "Number of Children: " + STR$(XML COUNT CHILDS (1))
want = 5

GetChildByNumber(1, 2, want)
PRINT "child name: " + XML GET ELEMENT NAME (2) + "   child text: " + xml get text (2)

WAIT KEY
END



FUNCTION GetChildByNumber(parent AS INTEGER, result as INTEGER, number as INTEGER)
	XML GET CHILD ELEMENT parent, result

	count = 1
	WHILE count < number
		XML GET NEXT ELEMENT result, result
		INC count
	ENDWHILE
ENDFUNCTION

remstart
use the following for zoo3.xml

<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<ZOO>
	<DESERT>
		<BIRD>Roadrunner</BIRD>
		<BIRD>Wren</BIRD>
		<MAMMAL>Coyote</MAMMAL>
		<REPTILE>Rattlesnake</REPTILE>
		Mojave
	</DESERT>
	<JUNGLE>
		<BIRD>Peacock</BIRD>
		<MAMMAL>Chital</MAMMAL>
		<MAMMAL>Tiger</MAMMAL>
		<REPTILE>Cobra</REPTILE>
		Indian
	</JUNGLE>
	<JUNGLE>
		<BIRD>Toucan</BIRD>
		<MAMMAL>Coati</MAMMAL>
		<MAMMAL>Anteater</MAMMAL>
		<REPTILE>Anaconda</REPTILE>
		Brazilian
	</JUNGLE>
	<JUNGLE>
		<BIRD>Guineafowl</BIRD>
		<MAMMAL>Gorilla</MAMMAL>
		<MAMMAL>Civit</MAMMAL>
		<REPTILE>Green Mambo</REPTILE>
		Congo
	</JUNGLE>
	<SAVANNAH>
		<BIRD>Ostrich</BIRD>
		<MAMMAL>Zebra</MAMMAL>
		<MAMMAL>Lion</MAMMAL>
		<REPTILE>Crocodile</REPTILE>
		African
	</SAVANNAH>
</ZOO>
remend

I don't see "African" like I would expect.

Back to top

Profile PM Email

MadBit

VIP Member

Gold Codemaster

17

Years of Service

User Offline

Joined: 25th Jun 2009

Location: Germany

Posted: 29th Mar 2012 10:50

Link

Put your text-node as the first node of all your other children in your parent-element. Than it works.

XML GET TEXT -> get the first child. If this child a text-node than return the text in it. Otherwise it return a clear string.

Here the corrected xml file.

+ Code Snippet

<?xml version="1.0" encoding="utf-8"?>
<ZOO>
	<DESERT>
		Mojave
		<BIRD>Roadrunner</BIRD>
		<BIRD>Wren</BIRD>
		<MAMMAL>Coyote</MAMMAL>
		<REPTILE>Rattlesnake</REPTILE>
	</DESERT>
	<JUNGLE>
		Indian
		<BIRD>Peacock</BIRD>
		<MAMMAL>Chital</MAMMAL>
		<MAMMAL>Tiger</MAMMAL>
		<REPTILE>Cobra</REPTILE>
	</JUNGLE>
	<JUNGLE>
		Brazilian
		<BIRD>Toucan</BIRD>
		<MAMMAL>Coati</MAMMAL>
		<MAMMAL>Anteater</MAMMAL>
		<REPTILE>Anaconda</REPTILE>
	</JUNGLE>
	<JUNGLE>
		Congo
		<BIRD>Guineafowl</BIRD>
		<MAMMAL>Gorilla</MAMMAL>
		<MAMMAL>Civit</MAMMAL>
		<REPTILE>Green Mambo</REPTILE>
	</JUNGLE>
	<SAVANNAH>
		African
		<BIRD>Ostrich</BIRD>
		<MAMMAL>Zebra</MAMMAL>
		<MAMMAL>Lion</MAMMAL>
		<REPTILE>Crocodile</REPTILE>
	</SAVANNAH>
</ZOO>

With Computers you can solve Problems that you have never befor.
Share your knowledge. It's a way to achieve immortality. (Tenzin Gyatso)

Back to top

Profile PM Email

freight hopper

22

Years of Service

User Offline

Joined: 26th Dec 2003

Location: Just beyond the Dunsmuir yard limits

Posted: 29th Mar 2012 18:53

Link

Good to know. Actually, I was imitating the order I saw in the XML GET NEXT ELEMENT example code, which has the text below the sub-elements. I am an XML noob. Hopefully, the real-world files I'm working with will all have text above sub-elements in any mixed content. If not, it could get messy. Not trying to be critical. If not already there, your plugin is approaching awesome.

Need to know a bit more about the XML RELEASE ELEMENT command, since I will be processing very large files and want to avoid a million memory leaks.

Q1. Since the same "ToElement" number can be "re-used" for successive operations, is releasing that same element number one time at the end sufficient?

Q2. It seems that if I release an element number that has already been released, it fails silently (good thing). It also seems that if I release an element number that has never been used, it fails silently (good thing). Put another way, in the absence of a "release all" command, do you see any problems with the following code?

+ Code Snippet

for i = 1 to 1000
	XML RELEASE ELEMENT i
next i

XML GET NEXT ELEMENT. This has two forms. I will have a need to parse an unknown number of the same element name. There could be ten or ten thousand of them. With the following code I can get the text of the first instance of "JUNGLE" and all successive "JUNGLE"s.

+ Code Snippet

xml get child element 1, "JUNGLE", 2
message xml get text (2)

do
     XML GET NEXT ELEMENT 2, 2
     if xml get element name (2) = "JUNGLE"
          message xml get text (2)
     else
          exit
     endif
loop

The second form of the command seems applicable but will always error out after the last one is reached.

+ Code Snippet

xml get child element 1, "JUNGLE", 2
message xml get text (2)

do
     XML GET NEXT ELEMENT 2, "JUNGLE", 2
     if not (xml is valid element (2)) then exit
          message xml get text (2)
loop

Q3. Is there any way to intercept the error? Maybe an option to turn it off?

Back to top

Profile PM Email

MadBit

VIP Member

Gold Codemaster

17

Years of Service

User Offline

Joined: 25th Jun 2009

Location: Germany

Posted: 29th Mar 2012 21:29

Link

Q1: YES

Q2: Listing 1: It is a better way to check of valid xml node before you release an element. but your code works fine, too.

+ Code Snippet

for i = 1 to 1000
    IF XML IS VALID ELEMENT (i)
        XML RELEASE ELEMENT i
next i

Q2: Listing 3: mmh, try this code. remains the error? What error message. I have no one implemented.

+ Code Snippet

XML GET CHILD ELEMENT 1, "JUNGLE", 2

WHILE XML IS VALID ELEMENT (2)
	message XML GET TEXT (2)
	XML GET NEXT ELEMENT 2, "JUNGLE", 2
ENDWHILE

Listing2: This code have a problem with mixed locations.
example:
a xml-file with elements
JUNGLE
JUNGLE
DESSERT
JUNGLE

you can only access the first two jungles the last one will never reached. Better use Listing 3 or better my version of listing 3.

With Computers you can solve Problems that you have never befor.
Share your knowledge. It's a way to achieve immortality. (Tenzin Gyatso)

Back to top

Profile PM Email

freight hopper

22

Years of Service

User Offline

Joined: 26th Dec 2003

Location: Just beyond the Dunsmuir yard limits

Posted: 30th Mar 2012 01:07 Edited at: 30th Mar 2012 01:13

Link

Thanks, for the corrections. The following code is admitedly lame, but at least it will generate the error message (at least the __ invalid element id __ part).

+ Code Snippet

global docnum = 1
global rootnum = 1

XML OPEN DOCUMENT "zoo4.xml", docnum

XML LOAD DOCUMENT docnum
XML GET ROOT ELEMENT docnum, rootnum

xml get child element 1, "JUNGLE", 2
print xml get text (2)

do
     XML GET NEXT ELEMENT 2, "JUNGLE", 2
     if not (xml is valid element (2)) then exit
     print xml get text (2)
loop

message "after the loop: " + xml get text (2)
end

remstart
Use below for zoo4.xml

<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<ZOO>
	<DESERT>Mojave</DESERT>
	<JUNGLE>Indian</JUNGLE>
	<JUNGLE>Brazilian</JUNGLE>
	<JUNGLE>Congo</JUNGLE>
	<SAVANNAH>African</SAVANNAH>
	<SAVANNAH>California Oak</SAVANNAH>
</ZOO>
remend

I have attached a jpg of the message to this entry. Thanks for listing 3. I now get XML IS VALID ELEMENT.

The files I'll be working with don't seem to have any mixed locations. If they do, I can always inspect each element. Thank you, this has been most helpful.

Back to top

Profile PM Email

freight hopper

22

Years of Service

User Offline

Joined: 26th Dec 2003

Location: Just beyond the Dunsmuir yard limits

Posted: 30th Mar 2012 02:15

Link

Here is example code that enables one to concentrate on a particular element name.

+ Code Snippet

`code to get a particular element name
global docnum = 1
global rootnum = 1

XML OPEN DOCUMENT "zoo4.xml", docnum

XML LOAD DOCUMENT docnum
XML GET ROOT ELEMENT docnum, rootnum

xml get child element 1, "JUNGLE", 2

WHILE XML IS VALID ELEMENT (2)
     print xml get element name (2) + ":  " + xml get text (2)
	XML GET NEXT ELEMENT 2, "JUNGLE", 2
endwhile

print "wow got thru the loop"
wait key
end

remstart
Use below for zoo4.xml

<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<ZOO>
	<DESERT>Mojave</DESERT>
	<JUNGLE>Indian</JUNGLE>
	<JUNGLE>Brazilian</JUNGLE>
	<JUNGLE>Congo</JUNGLE>
	<SAVANNAH>African</SAVANNAH>
	<SAVANNAH>California Oak</SAVANNAH>
</ZOO>
remend

Back to top

Profile PM Email

MadBit

VIP Member

Gold Codemaster

17

Years of Service

User Offline

Joined: 25th Jun 2009

Location: Germany

Posted: 30th Mar 2012 09:58

Link

Quote: " The following code is admitedly lame, but at least it will generate the error message (at least the __ invalid element id __ part)."

Now I understand what you mean. That's less than an error message. That indicates the retrieved element-id is invalid. Your and my loop go throug the elements as long as the id is valid. Then when you retrieve the text of this element-id, you get the text shown above. The solution is, fill the id with a valid element. Or before you query this id, do you check the validity of it.

At first i thought the messagebox would be mine.

With Computers you can solve Problems that you have never befor.
Share your knowledge. It's a way to achieve immortality. (Tenzin Gyatso)

Back to top

Profile PM Email

Sorry your browser is not supported!

DarkBASIC Professional Discussion / Madbit's XML Plugin - More Questions