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.
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.
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.
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.
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.
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 are not supported with the Data Upload Maintenance template.
Calculations are not supported with the Data Upload Maintenance template.
External Objects are not supported with the Data Upload Maintenance template.
SmartLinks are not supported with the Data Upload Maintenance template.
The Data Upload Maintenance template only supports the PC presentation layer.
When accessing the Application Properties, a popup window will open with multiple tabs; let’s go through each of the tabs: