Digital File Pro - Upload wizard

Dear Support, I'm creating a database of staff members - Fname, lname, etc. I want to include a field where they choose to upload a passport picture of themselves.

I've created the form and added a 'file field. I've then tried to use Wed Assist - File manipilation - upload wizard. The problem is I don't understand the process or what is heppening. I've done a few tests and I've successfully uploaded a picture to an images folder.

But, my questions are:
1. How does the wizard link the picture to the correct record in the database table?

2. What happens if one of the employee names their picture (on their computer) the same name (myphoto.jpg) as another employee (myphoto.jpg) and it goes into the image folder. Will the other employee photo be overwritten, thereby deleting his photo, or displaying the same photos for two employees.

1) see the "How to apply Digital File Pro to DataAssist Insert and Update pages" tutorial on the Digital File pro support page:
digital-file-pro/


2) In the Upload file settings there is a section for If the file exists. options include the renaming the New File, or renaming the old file, i suggest renaming the new file.

Okay, I've successfully uploaded the file and got it to insert the name of the file into the table. I uploaded another picture with the same name again to a new record and it successfully renamed the picture in the images file adding an '_1'. But the name in the table didn't get an underscore.

Also I attach a screenshot of 'page two' of the insert wizard. What do I put in in the File entry section/field where the default is [filename]

Leave the file name setting as is.

send a copy of the page so i can examine the code please.

Dear Jason, Attached is page and word doc with table showing image entries in last column.

As you can see the same name ha been inserted in the three different records.

you selected the option to rename the existing file if it exists.

you should select the option to rename the new file instead.

Okay, that upload worked very well. But I'm going through the motions, without really understanding some of the stuff I am doing - in particular on the 2n page of the upload Wizard, ie

1. In what circumstances do you change the name of the file from [filename] in the 'File' field?

2. Why is there a 'Default file' field available and when would you use it?

1) If you wanted to control the name of the uploaded file rather than just using the default name. some people prefer to rename the file to use a users name, or ID instead of the name of the file as it is.

2) The default file setting is a value that is given to the Server File Name binding if no file is uploaded.

the most common use of this is on the update page. on the update page, you create a hidden form element that contains the name of the file already stored in the database. you use the hidden element as the default file.

this way when a record is updated, but no new file is uploaded, the previous file name is retained.