Data Entry Image Uploading

Problem

During employee information collection, you often need to upload images of the employees. In this case, how to achieve the function of uploading images?

Solution

You can use file widgets to upload images. The supported image formats include JPG, PNG, and GIF, as shown in the following figure.

Note:

The images uploaded are stored in the database table in the form of binary encoding.

Template Preparation

Create a template in the designer. For details about template creation, see Free Report Data Entry. Design the table style, as shown in the following figure.

Widget Setting

1. Add a file widget for cell H6. Since each employee needs to upload only one image, tick Only Support Single File Uploaded, as shown in the following figure.

Note:

If Only Support Single File Uploaded is ticked, the image and file name will be displayed directly after you upload the image. If not, only the file name will be displayed.

2. Choose Widget Setting > Mobile Terminal and set the image upload mode for mobile preview, as shown in the following figure.

3. The uploaded image will be stored in the Photo field of the employee table in the form of binary encoding. Therefore, the field type of Photo in the data table needs to be modified to a type that can store binary data, as shown in the following figure.

Note:

You may not be able to preview BLOB-type data in the dataset. In this case, you can use other database table query software to check if the image is successfully uploaded.

Image Display

If you need to display the image stored in the database, you can select Display by Image.

Select the cell, choose Cell Element > Others, and select Display by Image in Display Content, as shown in the following figure.

Image Layout Setting

Too large images may not be displayed properly. In this case, you can set Image Layout to address this problem.

Select the cell, choose Cell Attribute > Style > Custom > Alignment, and select Adapt from the drop-down list of Image Layout, as shown in the following figure.

Effect Display

PC

Save the template, click Data Entry Preview, click the photo box, and upload the image. The following figure shows the effect.

Mobile Terminal

You can also upload the image on the DataAnalyst app and the HTML5 terminal. The following figure shows the effect.

For details, you can download the template Free Report Data Entry.cpt.

After you upload the image, a prompt "String or binary data will be truncated." may appear, as shown in the following figure.

This is caused by the insufficient length of the table field in the database. In this case, you only need to increase the length of this field.