multiple file path open

[slipstick]

I have some code that will open the files I want inside a folder, do some appending to a spreadsheet file and close down. I am trying to expand it to open every file inside a set of subfolders within a main folder. I have it pretty close, as you can see by the attached image, but the last bit eludes me. Any ideas on what I am missing?

Tay

Message Edited by slipstick on 07-03-2007 09:27 PM

[Dennis_Knutson]

There is no reason to have a build array function inside the for loop. When you exit the loop, you have a 2D array that you then index out the first row. Just wire the path out the for loop. This will create a 1D array. Wire this to another for loop where you have the rest of the code.

[mikeporter]

I'm not sure why you have the array builder inside the loop or the indexer outside the loop, but if you move the second List Directory function inside the loop you will get all the files in all the subdirectories, one subdirectory at a time.

Mike...

[Dennis_Knutson]

Mike,

We seem to be answering the same questions at about the same time.  

[slipstick]

Hey I have it working! Almost.

It compiles the data I want, but generates the error I have shown. I suspect it is a loop count mismatch or some such thing. I am not sure how to trap for this. I had the list functions trapping and it wasn't coming out of any of them, and I'm not educated enough as yet to add error trapping for other parts of the code that don't automatically provide for trapping.

By the way, I had to do the 'for' loops this way because if I did it any other way, wires would break and I became hopelessly ensared trying to make them match.

Tay

[jjcimon]

1. what do you want to do?

[mikeporter]

First of all take out the array builder and the indexer and wire straight from the output of the first Build Path function to the path input to the second List Directory function. They aren't doing anything.

Second, I can't comment on the error because nothing looks like it is set up incorrectly - but I can't be sure exactly where the wires are connected on the List Directory functions. It would be very helpful if you could post your code for us to look at. It is very hard to troubleshoot code from pictures.

Mike...

[jjcimon]

solution:

[slipstick]

Ok, here's the code. I have included the two spreadsheet vi's as they are a bit customized. Also a couple of files to play with.

And thanks in advance for the help!

Tay

[mikeporter]

Attached is your code cleaned up. At least this looks like what you were trying to accomplish (all the seleced files appended onto one larger file...

The reason that you were getting the error is that you were telling the read VI to read 4 rows starting after the 132nd character. The only trouble is - the file only had 130 bytes in it, hence the error. My suspicion is that if the file had more than 132 chracters but less than 4 rows, you'd get another error.

Mike...