Data Upload Maintenance Template

The Data Upload template can be used to allow end users to upload Excel files directly into the database. End users can either upload data directly from an Excel file, or copy and paste it into an onscreen text area for ease of use. At run-time, users have various options including which datasheet to upload, defining whether the first row of data should be ignored (in case the dataset contains column descriptions), and selecting whether to replace or append records to the dataset. Applications created with this template will display a status window to track the progress of the upload, and these applications will display any errors in the upload process so the end user is aware of what data was not successfully submitted to the database.

Runtime Walkthrough

Notes on Creating a Data Upload Maintenance Application

Before using this template, the developer will need to create the database table that the template will upload the data (if one does not already exist). This requires that the developer know, ahead of time, the structure that the user will be submitting the data. Additionally, the user will not be able to change either the number of columns or the order of the columns once the table is created.

You can create the table using m-Power or any alternative method way you feel comfortable creating database tables. Once completed, ensure that the table has been registered to m-Power.

Tables created with m-Power can be easily modified within m-Power. For this reason, it is recommended to create your data table with m-Power.

Template Notes

Application Settings

Description: Allow developers to specify their application’s description/title.

 

Program Name: This will be the application’s number. By default, m-Power uses the letter M (Maintenance) followed by a five digit number.

Template: You can select a template by scrolling through the available templates. The templates define the general layout and functionality of the resulting application. This section will list all the available maintenance templates; you will see a small screenshot of what that template looks like at runtime. Learn more about templates.

Data Selection

Here you will see/modify the table you have selected for your application. Here you can create or modify joins to other tables as well. When tables are selected, only the primary table can be modified, by default. This is done to protect developers from accidental cascading changes. This behavior can be modified within the application properties.

Dimensions

When building maintenance applications, a developer’s sequencing selection is analogous with selecting a Primary Key. This selection will tell m-Power how this table is unique.

The dimension keys in this template must be the first fields listed in the application. See the Field Settings section for more information.

Field Settings

The dimension keys are required to be listed first in the field settings and the order of the fields listed in field settings must match the order of the fields listed in your Excel file. If the order is not correct, use the re-order tool to fix it.

Here you will find the settings for all the fields in the application. The options are:

Delete: You can delete fields by clicking the checkbox and clicking Accept. If a field has a red circle with a cross line, that means that the field is being used somewhere else in the application (sequence, calculation, etc.), and, due to this dependency, is not available for deletion. Note: Deleting a field will remove the field from the application only, the table will be unchanged.

Field Name: This is the same name the field has in the table.

Table: The name of the table where that field exists.

Field Description: This is the text that will appear in the column header for that field, you can modify this field to suit your needs. This field will populate with the field description from the table by default, but it can be customized at the application level.

Type: A drop down list that allows developers to designate whether a field is to be displayed (visible, but not edited on the database), hidden (no action), or updated. There may be situations where a field is needed for calculation purposes, but the field does not need to be displayed at runtime. Note: Sequence keys must be set to update to ensure your application functions properly

Size: This displays the length of a field. If a field has a length consisting of two numbers separated by a comma, the first number will be the integer length and the second the decimal length of the field.

Lowercase: This option determines whether or not an alpha field can be submitted to the database with lowercase letters. If this is set to “no,” the field will be converted to uppercase when it is submitted.

Record Selections

Record Selections are not supported with the Data Upload Maintenance template.

Calculations

Calculations are not supported with the Data Upload Maintenance template.

External Objects

External Objects are not supported with the Data Upload Maintenance template.

SmartLinks are not supported with the Data Upload Maintenance template.

Back to the Top

Template In-Action

The Data Upload Maintenance template only supports the PC presentation layer.

  • PC Output

Back to the Top

Application Properties

When accessing the Application Properties, a popup window will open with multiple tabs; let’s go through each of the tabs:

Back to the Top

Web Parameters

Back to the Top

Updated on September 30, 2021

Was this article helpful?

Related Articles

Need Support?
Can’t find the answer you’re looking for? Don’t worry we’re here to help!
Contact Support