(ASP & XML) reading files too fast? **Resolved**

[msimmons]

I'm looping through some xml files, adding (or updating) the data to the database, then moving the file to a different folder. I think it is going to fast and messing up... is there a way to slow it down?
my loop is just a for loop (for each item in objFolder.Files)
thanks
michael

[techgnome]

***?!
Too fast?! Usually it's the other way around. What are you smoking? (and why aren't you sharing?)

[msimmons]

Originally posted by techgnome
***?!
Too fast?! Usually it's the other way around. What are you smoking? (and why aren't you sharing?)

lol. no seriously I don;t know what the problem is but it works fine if I manualy move the files into the directory one at a time but if I throw them all in at one it messes up and reads some twice. the only explanation I could come up with is that maybe it is reading it a second time before it moves it.

[techgnome]

What about keeping track of which onese have bee --- wait... how are you getting the list in the first place.....

[msimmons]

set objFS=Server.createobject("Scripting.FileSystemObject")
set objFolder = objFS.GetFolder("D:\inetpub\wwwroot\lxr\AutoRes\import")
 
for each item in objFolder.Files
    strFilePath = item.path
    strFilePath = replace(strFilePath, "D:\Inetpub\WWWroot\lxr\AutoRes\import\", "")
    strFilePath =  "import/" & strFilePath
 
    Set objXML = Server.CreateObject("Microsoft.XMLDOM")
    Set objList = Server.CreateObject("Microsoft.XMLDOM")
    objXML.async = False
    objXML.Load (Server.MapPath(strFilePath))

[techgnome]

What about
1) Keeping track of what's been loaded and only load it once.
or,
2) Adding some sort of For x= 1 to 100000 do nothing loop between files?

[msimmons]

I think I'm going to have to work on a 'keeping track' solution... the problem with that is this app is going to be running 24/7 365 and processing alot of files (right now we manualy process 100+ but with this system we hope to do more) so the tracking it may get quite extensive.
this is running on my web server so I think the 'wait loop' would bog it down some.
Michael

[techgnome]

What about moving it to a new folder after reading the file?

[msimmons]

Originally posted by msimmons
I'm looping through some xml files, adding (or updating) the data to the database, then moving the file to a different folder.

it seems to be fine now though... I was just writing my 'alert' wrong (oops)

[techgnome]

pfffft....
PEBKAC.....sheesh....

[msimmons]

Originally posted by techgnome
pfffft....
PEBKAC.....sheesh....

? I don't understand

[techgnome]

Problem
Exists
Between
Keyboard
And
Chair

in other words, user error.

[msimmons]

I just now figured it out... I was writing to the screen what i did with each file when I was done but my logic was a little out of order and i was duplicating what i was writing as I appended

like this

processed file 1
processed file 1
processed file 2
processed file 1
processed file 2
processed file 3
processed file 1
processed file 2
processed file 3
processed file 4

so I was thinking it was processing them like that... sorry to waste your time