About Image Files

Hi:

I'm successfully uploading image files to a specific directory and uploading the corresponding file name to a Php DB using Data Assist. However, I still have a couple of questions:

1) How can I have Data Assist store the record ID as file name in the DB? Right now it's storing the original file name, which is not what we want.

2) How can I display those image files once they're stored? Is there a Data Assist or a UE function that helps me do that?

Thank you for your attention.

1) the order of operation is to a) Upload the File then b) create the new record.

Since the record ID is not known at the time of upload, the record ID cannot be used as the file name.

2) In the "How to apply Digital File Pro to DataAssist Insert and Update pages" tutorrial on the DataAssist support page, see the "Displaying your upload images on DataAssist pages" section.

Jason:

Thank you for your reply.

1) Understood your point about the record ID. Is there a way to double check that the file name is not a duplicate of an existing file name in the DB before uploading?

2) I'll read that tutorial.

Thank you for your attention

Jason:

The tutorial was clear enough and I'm displaying the image files quite well. That's a very user-friendly little widget.

Now I would just need to know how to avoid file-name duplicates in the DB. Any ideas on how to do that?

Thank you for your attention.

the file upload behavior has settings to address file name duplication in the If File exists section.


you have the option of overwriting the existing file, renaming the existing file, renaming the new file or skip the upload.

I would suggest renaming the new file.

Jason:

Yes. In the "If" option I renamed the file to the user's email address, which has to be unique.

Thank you for your attention.