Newbie Questions

Re: Reading from an external XML file.

davidair — Thu, 14 Jun 2007 15:11:25 GMT

Hey, you're welcome! I think the reason why these contorsions are needed is because there is some obscure bug with reading the XML directly.

Re: Reading from an external XML file.

seadsead — Thu, 14 Jun 2007 15:05:06 GMT

good point, lol, I think I'm losing it......

I just find it rediculous that,

To read XML, you have to convert to text then back to XML,
Why do we have to have a middle man??

anyways it works,

THANKS A BUNCH

Re: Reading from an external XML file.

davidair — Thu, 14 Jun 2007 14:48:14 GMT

I am not sure why it does not work - have not used the FSO in a while. But maybe you could just use ReadAll() instead of ReadLine() and not worry about while loops...

Re: Reading from an external XML file.

seadsead — Thu, 14 Jun 2007 14:40:08 GMT

Very Helpfull, thanks

would there be a reason why, I can't use ReadLine in a Loop statement??

ex:

tmpTxt = SoftwareXML.ReadLine ' <-- Works

do while true
if ( (tmpTxt = "") or (tmpTxt = EOF))then
Exit Do
else
tmpTxt = SoftwareXML.ReadLine ' <-- Doesn't Works
end if
loop

I just want to read through the file first

Re: Reading from an external XML file.

davidair — Thu, 14 Jun 2007 01:47:55 GMT

Well, loadXml takes an xml string of a form "<tag><anotherTag/>...</tag>", not a path to a file. So first you need to load the text from file using FSO and then you can load it into an xml document via loadXml

Re: Reading from an external XML file.

seadsead — Wed, 13 Jun 2007 19:26:57 GMT

I'm trying to have an external Software list(in XML format) to read from, that we can change if needed (New Specialty software available on our network)
Right now I just want to write to an external Text file to make sure I'm getting stuff(Testing only)

this is what I've got so far:

Dim xmlDoc, nodeList

Set xmlDoc = XDocument.CreateDOM()
xmlDoc.async = false xmlDoc.LoadXml(path to XML File)

      Set nodeList = xmlDoc.SelectNodes("descendant::SoftwareList[Software/sName = *]")
or
      Set nodeList = xmlDoc.GetElementsByTagName("sName")

                      BOTH WORKED IN PREVIOUS FORMS

Dim fso, testFile
Set fso = CreateObject("Scripting.FileSystemObject")
Set testFile = fso.CreateTextFile("C:\Temp\testfile.txt",True)

testFile.WriteLine(xmlDoc.GetElementsByTagName("sName").item(0).text) 'test for data
^--- this is where the errors are coming from

testFile.Close

The ERROR I'm getting is: Object required: 'xmlDoc.GetElementsByTagName(...).item(...)'

this is the test XML file.

<?xml version="1.0" encoding="ISO-8859-1" ?>
<SoftwareList>
<Software>
<sName>Adobe Reader 8</sName>
</Software>
<Software>
<sName>WinZip 11.1</sName>
</Software>
</SoftwareList>

I don't understand what I'm doing wrong?

Re: Reading from an external XML file.

davidair — Wed, 13 Jun 2007 18:47:37 GMT

So you can finally get your XML file into a DOM, right? Great!

If you share out our XML file and the code you use to read it maybe I could see why you're failing to read the data.

Re: Reading from an external XML file.

seadsead — Wed, 13 Jun 2007 18:27:22 GMT

LoadXml() seems to work great.

Now I'm having trouble reading nodes, or even getting a NodeList.

this is really starting to get on my nerves, lol

Re: Reading from an external XML file.

davidair — Wed, 13 Jun 2007 13:34:04 GMT

Well, if you can get it as text first then you can get it as XML by doing LoadXml(). Let me know if the load-as-text trick works!

Re: Reading from an external XML file.

seadsead — Wed, 13 Jun 2007 13:29:06 GMT

I've already tried this, and it works fine.

But my group would rather have it in XML. (Though, if I can't get this working with XML, then Txt it is, lol)

thanks again,
Let me know if you come across a way to get XML working maybe.

Re: Reading from an external XML file.

davidair — Tue, 12 Jun 2007 21:03:21 GMT

Hmm... this is strange... if you are running full-trust and the file is accessible, I am not sure what else could be wrong.

One thing you could try is to use the FSO object to load the file as text. Here is an MSDN example that shows you how to do this: http://msdn2.microsoft.com/en-us/library/t58aa4dd.aspx

If you can get the XML in this way then you can use the loadXml() method on the newly created DOM to suck the XML in.

Let me know if this workaround works!

Re: Reading from an external XML file.

seadsead — Tue, 12 Jun 2007 19:39:55 GMT

I can only get it to work when the XML file is in the same folder as the form(s).

I really hope there is a way around this

Re: Reading from an external XML file.

seadsead — Tue, 12 Jun 2007 19:25:26 GMT

Well,

#1 Works, so thats out.

And, I don't think the file is not accessible, because I'm modifying it. How can it not be accessible?

I have a feeling this is gonna take me a while, lol

thanks for the input aswell.

Re: Reading from an external XML file.

davidair — Tue, 12 Jun 2007 19:18:56 GMT

Couple of ideas:

1. There is a problem with the certificate and so the form is not *really* running as full trust. To check this, try to run Application.Quit() from your code - if this fails, the form is not really executing as full trust

2. The file is not accessible so you get a true "access denied" (this is less likely, I think #1 is the more likely culprit)

Re: Reading from an external XML file.

seadsead — Tue, 12 Jun 2007 18:59:43 GMT

I created a cert to test.

I am using IP2003, but I'm not trying to use the preview because of the trust problem.
I launch it from the form externaly.

It's been working fine until now.
It's only since i tried to load teh XML file that I've been getting this problem.
I've tried from Network drives and Localy (i.e. C: drive)

any clues?