Is there a way to List Folder Contents?

[coleresources]

I want to give the ability to my users to open files in folders I designate for my web app. I want them to be able to upload to this location as well. Any direction you can provide is much appreciated!

Thank you!

[christappan]

Re: Is there a way to List Folder Contents?

Do you want to give them full directory browsing or search by filename, keywords, access to only certain files, etc?

If the latter, when files are uploaded, you'll want a column in a table with the relative file path, e.g. Documents/mydoc1.doc (which is physically at C:\MyWebrootFolder\Documents\mydoc1.doc). Then in a grid, you can either make this column a hyperlink or you can use Action Javascript to open a "webpage" where the filelocation is {FilePath}.

FileID|FileClientID|FileType|FilePath
1     |65          |Contract|Documents/mydoc1.doc
2     |456         |Invoice |Documents/Invoices/myinvoice.pdf

There's Action Javascript for uploading as well. Read up on that.

[coleresources]

Re: Is there a way to List Folder Contents?

Full directory browsing would be fine

[christappan]

Re: Is there a way to List Folder Contents?

I don't actually allow that on our application, so you'll have to read up on Directory Browsing (search the forum, documentation).

[Pat Bremkamp]

Re: Is there a way to List Folder Contents?

I do a similar thing, but before I go into a lengthy explanation, I'd like to see if this is what you mean...
My client has projects and each project has it's own project directory. Inside that are 5 sub-directories. The pic shows two of the 5. The action buttons at the bottom allow files to be uploaded and downloaded. Note that there is no table, this is a display of what is in the directories. So, there is no searching and no filtering available.
Capture1.PNG

[coleresources]

Re: Is there a way to List Folder Contents?

Pat,

That is exactly what I am looking for.

[Pat Bremkamp]

Re: Is there a way to List Folder Contents?

Josh,

OK, we'll go through this step by step....it'l take a few posts to get it all laid out.
First, what you see in the pic is a grid. Like I said, there are 5 sub-directories, so I have 5 dropdown controls, one for each sub-directory. The controls are set up like this:
Capture1.PNG
Mine are 25 rows high because that's what fits on my client's screens.
The static text is, for example, "<span style="font-size:10pt;font-weight:bold;">ClientDocs Directory</span>"
and the button labels are set up like "<img src="led-icons\arrow_up.png" />&nbsp;Upload To ClientDocs"

The dropdown choices are set up as a variable that holds a crlf delimited list of choices, for example a variable named "ClientDocsList"
The variables, in turn are defined in the OnGridExecute server side event, for example

vPath = "c:\enefen\000_NFN_Projects"
vProjectname = Session.JOBNAME

vCDFilelist = filefind.get(vPath+chr(92)+vProjectname+chr(92)+"ClientDocs\*.*",FILE_FIND_NOT_DIRECTORY,"N")
if vCDFilelist = ""
e.rtc.ClientDocsList = "No files found"
else
e.rtc.ClientDocsList = vCDFilelist
end if

vINFilelist = filefind.get(vPath+chr(92)+vProjectname+chr(92)+"Inspection\*.*",FILE_FIND_NOT_DIRECTORY,"N")
if vINFilelist = ""
e.rtc.InspectionList = "No files found"
else
e.rtc.InspectionList = vINFilelist
end if

and so on.

When you get that done, I'll show you the buttons

[coleresources]

Re: Is there a way to List Folder Contents?

Pat,

Do you store information in a table that you base your grid on? Just wondering how you create the controls in the grid if they are not bound to a table. Sorry for the dumb question and thanks for your help!

[coleresources]

Re: Is there a way to List Folder Contents?

Hey Pat,

I've got this working. Would you be willing to show me the code for the buttons to upload/download?

Thank you!

[Pat Bremkamp]

Re: Is there a way to List Folder Contents?

Josh,
Sure. For upload, I use the File Upload - User Defined action javascript set up like
Capture1.PNG

The server side event, then is just
function saveInClientDocs as v (e as p)
vPath = "c:\enefen\000_NFN_Projects"
vProj = Session.JOBNAME
for i = 1 to e.fileCount
if e.fileArray[i].file.dataType = "text"
file.from_string(vPath+chr(92)+vProj+chr(92)+"ClientDocs"+chr(92)+e.fileArray[i].fileName,e.fileArray[i].data)
elseif e.fileArray[i].file.dataType = "binary"
file.from_blob(vPath+chr(92)+vProj+chr(92)+"ClientDocs"+chr(92)+e.fileArray[i].fileName,e.fileArray[i].data)
end if
next
e.javascript = "window.parent.{grid.object}.refresh();"
end function

For download, I use the File Download action javascript set up like
Capture2.PNG

Code for that is
function getFromClientDocs as c (e as p)
dim vPath as c
dim vProj as c
dim vFileName as c
vPath = "c:\enefen\000_NFN_Projects"
vProj = Session.JOBNAME
e.ajaxCallBackType = "FileDownload"
vFileName = vPath+chr(92)+vProj+chr(92)+"ClientDocs"+chr(92)+e._currentRowDataNew.dir_ClientDocs
e.fileToDownload = vFileName
e.javascript = "{grid.object}.isDirty=false;"
end function

[coleresources]

Re: Is there a way to List Folder Contents?

Pat this is a really slick solution for handling files in a web app. Thank you for sharing it!

[coleresources]

Re: Is there a way to List Folder Contents?

Pat,

I am hoping for some advice. I am using a dialog (is that ok) and am able to populate the list of documents...Works great.

The difference in my application is that I can't base the file bath on a session variable because I am displaying documents based on selections from a drop down list. I am using javascript to reload the page with the projcode and lot variables and am then using the request variable method inside of the onDialogInitialize event to create the path and populate the document list.

My issue is that I can't use the request variables inside of the ajax callback for downloading and uploading. Can you think of a way for me to handle this? I was wondering if I can use a request variable to create a session variable? I was also wondering if e._currentRowDataNew.dir_ClientDocs will work inside of a dialog? I don't know if I have access to the same objects in this type of ajax callback. I looked at the prototype and it looked pretty limited and that may be why youre using a grid?

[Pat Bremkamp]

Re: Is there a way to List Folder Contents?

Josh,

Sorry, I can't answer your questions because I don't use a dialog. The reason I don't use a dialog is because it didn't offer the file upload_user defined ability. If that had been available, I'd rather have used a dialog.

Pat

[coleresources]

Re: Is there a way to List Folder Contents?

Understood, Thanks