upload file using aftervalidate event

[rching]

I'm currently trying to allow the user the option of uploading file, along with filling out other various information. I'm currently using a dialog and have the following code in one of the textboxes in the freeform layout:

<b>File Upload </b><input type="file" name="FileToUpload" >

I'm trying to utilize the aftervalidate event to obtain the filename that the browse button comes back with.

Here's the code I tried so far and it comes Argument is incorrect data type


aftervalidate

if FileToUpload.filename = ""
fn="No file"

else
fn = "[PathAlias.ADB_Path]\images\\" + FileToUpload.filename
file.from_blob(fn, FileToUpload.data)
end if

tbl = table.open("[PathAlias.ADB_Path]\issue.dbf")
tbl.enter_begin()
tbl.file = fn
tbl.enter_end(.t.)
tbl.close()

[Steve Wood]

Re: upload file using aftervalidate event

This trick could do it. Open your A5W page and insert the part in red as follows. However, what you have in AfterValidate, I have in my A5W page, following code originally available in the Alpha Help. I do, like you, divert from that help and have my form fields in the Dialog under a Freeform area.
Note below that x_upload would be replaced with the name of your component, consistent with other x_mycomponent tags in the page.

Please let me know if it works. I worked very hard to get this upload feature in to a dialog component so I could use other A5 features not available using the method shown in the Alpha help.

 
?x_upload.Output.Head.JavaScript
?x_upload.Output.Head.CSS_Link
%>
<%a5
[B][COLOR=darkred]'MY FORM REPLACEMENT CODE
x_upload.Output.Body.Dialog_HTML = stritran(x_upload.Output.Body.Dialog_HTML,"method=\"post\"","method=\"post\" enctype=\"multipart/form-data\"")
%>[/COLOR][/B]
<!--Alpha Five Temporary Code Start - Will be automatically removed when page is published -->

[rching]

Re: upload file using aftervalidate event

Attached is what I tried. It comes back with a statement "false". Do I have it right place?

[Steve Wood]

Re: upload file using aftervalidate event

I don't think so. You actually replaced an existing piece of code, you should just be adding what I provided. Return that line to what it was before, and ADD in the line I gave. The position for it probably does not matter, but you should be able to find the exact place I put mine from the example.

Note - I'm not an expert with the code in the A5W page, everything I know I lifted from other examples, mostly provided by Jerry.

[Steve Bovino]

Re: upload file using aftervalidate event

Steve:

I was able to get this to work using Rching's example along with your added code. I would like to see how you did this by placing all the code on the a5w page. I am also trying to provide the user some feedback when the file is succesfully uploaded as demonstrated in the help file. I am getting somewhat confused going back and forth between the aftervalidate code in the dialoge and the a5w page code. Thanks for any insight!

Steve

[den1s]

Re: upload file using aftervalidate event

Hi,

I have configured this on my application. Works great. However, how can i prevent the whole path being stored? All i need is the filename itself.

Denis

[Scholin]

Re: upload file using aftervalidate event

Dennis,

Did you get this to work? I too need to allow my clients to upload a couple of files and list the file name and date in a field that could be downloaded by another person if they click on it.

If you got yours to work, would you mind posting the code (and its location) for me to examine so I can figure this out?

Thanks,

Mike Scholin

[den1s]

Re: upload file using aftervalidate event

Michael,

This one was never resolved. Sorry.

Denis

[Lenny Forziati]

Re: upload file using aftervalidate event

If you simply need to remove the path from the filename, look at file.filename_parse()

[den1s]

Re: upload file using aftervalidate event

Hi,

I have used the code supplied by rching and Steve Wood. I now have a grid with two fields;

Document_Name (Text)
VIEW (Link field)

The problem i now have is;

1. When i upload a file, how can a user view it. As normally, i would have to upload it in Alpha and publish it.

2. The app is based on a user_id value which determines who can see what. How can i store the files in seperate directories. e.g.

USER 1 = /images/user1
USER 2 = /images/user2
USER 3 = /images/user3

2. With the LINK, how can i point it to the file which is related to the 'document_name'?

1-DOCUMENT_NAME --------- VIEW
2-DOCUMENT_NAME --------- VIEW
3-DOCUMENT_NAME --------- VIEW
4-DOCUMENT_NAME --------- VIEW

This is a new area for me, any help will be really appreciated.

Denis

[jlps]

Re: upload file using aftervalidate event

This trick could do it. Open your A5W page and insert the part in red as follows. However, what you have in AfterValidate, I have in my A5W page, following code originally available in the Alpha Help. I do, like you, divert from that help and have my form fields in the Dialog under a Freeform area.
Note below that x_upload would be replaced with the name of your component, consistent with other x_mycomponent tags in the page.

Please let me know if it works. I worked very hard to get this upload feature in to a dialog component so I could use other A5 features not available using the method shown in the Alpha help.

 
?x_upload.Output.Head.JavaScript
?x_upload.Output.Head.CSS_Link
%>
<%a5
[B][COLOR=darkred]'MY FORM REPLACEMENT CODE
x_upload.Output.Body.Dialog_HTML = stritran(x_upload.Output.Body.Dialog_HTML,"method=\"post\"","method=\"post\" enctype=\"multipart/form-data\"")
%>[/COLOR][/B]
<!--Alpha Five Temporary Code Start - Will be automatically removed when page is published -->

I tried using this code to add a 'file upload' function on my page but the page I've added it to also has 3 drop down boxes that link to each other (i.e. the list in the 2nd drop down box depends on the selection from the 1st drop down box, etc.). These drop down boxes were working fine before I added the new line of code to make the file upload function work, now the drop down boxes come up with the following error:

Error creating list :Expected value

Does anyone know how I can fix this? I'm VERY new to Alpha Five and need all the help I can get!