How To Search A Directory on the webserver + return filenames for possible download?

[-Jinx-]

I can't quite wrap my head around where to start with this and I was hoping someone here would have a suggestion.

Here's what I've got right now:

I have a grid that contains a file location field. Within that field I have a full path and file name. I'm currently using it to download a .pdf drawing via a button and it's working fine for that.

Besides the .pdf, there are also other files in another directory that are related. These files are the actual CAD files that can only be opened with the proper CAD program. There is always a drawing file in this directory with the same name as the one in the file location field except with the extension being .slddrw instead of .pdf.

I'm able to get the .slddrw file with a little change to the file download javascript code in alpha 5. The below works:

window['{grid.componentName}_D__UNBOUND_BUTTON_4_1'] = function(rowNum,rowId,objEle) {

if({grid.object}._embeddedMode) {
	alert('File download is not supported when the Component is running on the Desktop.');
	return false;
}

var e = $('{grid.componentName}.__IFRAME1');
var filename = ({grid.object}.getValue('D','FILE_LOCATION',rowNum));
var testFilename = filename.split('://')[0];
var oldn = filename.split('\\').pop();
var newname = 'P:\\Secured\\Tooling\\' + oldn.substring(0,3) + '\\' + oldn.split('.').shift() + '.sldprt';
if(testFilename.toLowerCase() == 'http' || testFilename.toLowerCase == 'https') {
	e.src = filename;
} else { 
	filename = urlencode(newname);
	e.src = '__A5FileDownload.a5w?c=%5fa5filedownload&action=Display%20message&message=File%20%7bfilename%7d%20not%20found%2e&fileToDownload='+filename+'';
};
}

When I use the above (basically to change the file path to the correct one) I can get my drawing file to download to my machine.

Now, here's my problem.
The drawing file is no good if I can't get the part and assembly files that may go with it. They may have the same name or they may have the same name plus "-1" or "-03" etc.

So, what I'd like to do is make some sort of function via xBasic, javascript or a combination of both that searches the directory, returns file names that might match, and then allows the user to pick which ones to download to their machine.

Let's take this example.

My file location for the .pdf file is : P:\Secured\ReleasedPDF\Tooling\060\06000.pdf (Currently, I have no problem turning that into : P:\Secured\Tooling\060\06000.slddrw)

I want to search P:\Secured\Tooling\060\ for files (to use SQL terms just for explaination) LIKE '06000%'
I want to return the results of that search to the user.
I want to then allow the user to choose among the results.
I want to then send the users choices to the users machine via download.

What do you guys think is the best/easiest way to do this?

Thanks in advance!

[-Jinx-]

Re: How To Search A Directory on the webserver + return filenames for possible downlo

Come on guys! No bites at all? Maybe I should start posting in the programming puzzles area after I figure these out.

Anyway; I'M CLOSE!

I just need a little help with some funky issues.

Here's what I've got so far.

A user searches my main grid. When he finds a tool number that the user wants to download the files for he opens the detail view in the grid and there is a button waiting for he/she.

That button opens up a dialog component.
In the OnDialogInitialize Event I have this code:

'---------- Simulate a user value passed to the dialog
dim id as c = "43755"


'To edit this action, place insertion point anywhere in the command, then click the 'Action Scripting' button'.
ExecuteServerSideAction("Populate Dialog from Tables::Populate_a_Dialog_with_data_from_Tooling_Card_Info")

dim filepath as c
dim filesrc as c
dim files as c

'filepath = e.rtc._data.file_location
'below filepath is for testing in working preview.
filepath = "P:\Secured\ReleasedPDF\Tooling\060\06004.pdf"
filesrc = word(filepath,-1,chr(92))
	filesrc = word(filesrc,1,chr(46))
		filesrc = "P:\Secured\Tooling"+chr(92)+left(filesrc,3)+chr(92)+filesrc+"*.*"

files = filefind.Get(filesrc,0,"N|PN")

'---------- Set up variable to populate the 'UserRoles' radio control
dim e.rtc.filechoices as c

'---------- populate the variable for my checkbox
e.rtc.filechoices = files
'debug(1)

This populates my dialog correctly and pulls it up in a dropdown window in the grid.
The dialog consists of a check box populated on the initialize event with the file choices for the user.
The user may pick multiple files. (still working on a zip function but for now I've got to figure this out.)
After picking the files there is a download button, and within it is this code:

var e = $('{dialog.componentName}.__IFRAME1');
var filedl = ({dialog.Object}.getValue('FILES_TO_DOWNLOAD'));
//alert(filedl);
var cnt = ''+filedl+'';
var filedl2 = ''+filedl+'';
var filestodl = ''+filedl+'';
var cnt = (cnt.split(",").length);
//alert(cnt);
if (cnt>1)
{
	
	for (var i=0; i<cnt; i++)
		{
		filedl2 = filestodl.split(",").shift();
		alert('filedl2 '+filedl2);
		filestodl = filestodl.replace(filestodl.split(",").shift()+',','');
		alert('filestodl list '+filestodl);
		e.src = '__A5FileDownload.a5w?c=%5fa5filedownload&action=Display%20message&message=File%20%7bfilename%7d%20not%20found%2e&fileToDownload='+filedl2+'';
		}

}
else
{
alert('single file');
e.src = '__A5FileDownload.a5w?c=%5fa5filedownload&action=Display%20message&message=File%20%7bfilename%7d%20not%20found%2e&fileToDownload='+filedl+'';

}

It Works!......mostly....

My problems are:
When a user clicks on a single file, it appears to work correctly as the file is downloaded; however, as soon as the dialog dropdown is closed it wants do download the file again. Also, after it's closed, if I open the dialog dropdown it will want to download that file again right away

When a user clicks on multiple files, the problems are the same as the above with the exception that it will only try to download the last file that was clicked on.

I know the problem has something to do with how I'm most likely; wrongly, using the e.src or the IFRAME.

Hopefully the solution is simple.

[-Jinx-]

Re: How To Search A Directory on the webserver + return filenames for possible downlo

Well, after about 26 hours of messing about I figured it out.....no thanks to you losers.....
If anyone has interest in doing something like this I can give them a heads up.

I'd just post it here but maybe this should go in the programming puzzles forum now that I have the answer?...hmmm

[Al Buchholz]

Re: How To Search A Directory on the webserver + return filenames for possible downlo

Well, after about 26 hours of messing about I figured it out.....no thanks to you losers.....
If anyone has interest in doing something like this I can give them a heads up.

I'd just post it here but maybe this should go in the programming puzzles forum now that I have the answer?...hmmm

We had complete confidence that you would solve the problem.....

[-Jinx-]

Re: How To Search A Directory on the webserver + return filenames for possible downlo

We had complete confidence that you would solve the problem.....

Likely story...........

[Garry Flanigan]

Re: How To Search A Directory on the webserver + return filenames for possible downlo

Hi -Jinx-
I am investigating a document management app and would be extremely grateful to see your solution.
Our files (PDF's, Word, Excel) are stored on a server with a folder for each client. I was planning to use filefind.Get to generate a list in a dialog then use response.sendfile to download the selected file.

This is an Intranet application so I would like to open the file for editing but from the posts I have read so far this does not seem possible. Is this your understanding also?