Upload Files to Server

 

One feature of Maintainers is to allow the uploading of files from your client machine to the server. This feature is unique in the fact that it will also add a record to the database, as well as upload the specific file to the server.

To begin, create a maintenance application as you normally would. In “Field Settings”, find the field that will serve as the File Name for the uploaded file. In the User Defined Field Control, select the “U”. This will tell m-Power to create an upload button next to this field, and when the record is written to the table, write the File Name to this field.

Build your application as you normally would. Before running the application, let’s look at the application properties for this program. After you scroll to the bottom, you will see these two options:

The “upload_dir” is the location on the server that this file will be uploaded to. If the folder does not exist, it will be created.

Note: You must pick a valid drive.

The “upload_max_size” is the maximum size, in megabytes, that a file can be in order to be uploaded. If a file is too large, the user will see an error at runtime that they must pick a smaller file.

Make any necessary changes and click “OK”.

When I run my application, I see something like this:

Notice the new “Browse” button next to my File Name input box. Clicking on “Browse” brings up a view of my local machine. After I select a file, the location will be inserted.

Note: The upload feature is designed only to work in Addmode. This feature is not meant to remove files or modify files in any way, other than to add them to your server.

Error Checking

Below is a list of the common error checking that m-Power will do to ensure that the proper information is being uploaded:

If the file name is too long, this error is displayed:

If the file already exists, this error is displayed:

If a file exceeds the maximum size, this error is displayed:

Editor’s Note: The Maximum Size was changed in this example for practicality purposes. The default size is 100 MB.

Standard maintenance rules apply: Key fields must be unique. In addition, the Filenames must be unique and the number of characters in the file name can not exceed the length of the File Name field. For instance, if I want to upload the file “Damaged_goods.jpg” to a 15 alpha field, it would be rejected, as “Damaged_goods.jpg” is 17 characters long.