{"id":6566,"date":"2013-09-25T09:45:19","date_gmt":"2013-09-25T14:45:19","guid":{"rendered":"http:\/\/www.mrc-productivity.com\/docs\/?page_id=6566"},"modified":"2023-04-27T16:58:20","modified_gmt":"2023-04-27T21:58:20","slug":"data-upload-maintenance-template-2","status":"publish","type":"ht_kb","link":"https:\/\/www.mrc-productivity.com\/docs\/knowledge-base\/data-upload-maintenance-template-2","title":{"rendered":"Data Upload Maintenance Template"},"content":{"rendered":"\n<p>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.<\/p>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\">\n<h2 class=\"wp-block-heading\">Runtime Walkthrough<\/h2>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-4-3 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe title=\"Convert Excel files to database\" width=\"643\" height=\"482\" src=\"https:\/\/www.youtube.com\/embed\/tco5UmbZZ6k?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n<\/div><\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><a id=\"special notes\" class=\"anchor\"><\/a>Notes on Creating a Data Upload Maintenance Application<\/h2>\n\n\n\n<p>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.<\/p>\n\n\n\n<p>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.<\/p>\n\n\n\n<p class=\"wp-block-ht-blocks-messages wp-block-hb-message wp-block-hb-message--withicon is-style-info\">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.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><a id=\"notes\" class=\"anchor\"><\/a>Template Features<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">Tables\/Fields<\/h3>\n\n\n\n<p>Here you will see\/modify the table you have selected for your application. This template only allows a single table to insert data into, therefore joining to additional tables is not supported.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong><a id=\"fieldSettings\" class=\"anchor\"><\/a>Field S<\/strong>ettings<\/h4>\n\n\n\n<p class=\"wp-block-ht-blocks-messages wp-block-hb-message wp-block-hb-message--withicon is-style-alert\">The dimension key(s) are required to be listed first in the field settings and the order of the fields listed in field settings <strong>must <\/strong>match the order of the fields listed in your spreadsheet file. If the order is not correct, use the re-order tool to fix it.<\/p>\n\n\n\n<p>Here you will find the settings for all the fields in the application. You can find out more in detail about these options <a rel=\"noreferrer noopener\" href=\"\/docs\/knowledge-base\/field-settings\" target=\"_blank\">here<\/a>.<\/p>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-constrained wp-block-group-is-layout-constrained\">\n<h3 class=\"wp-block-heading\"><a id=\"sequencing\" class=\"anchor\"><\/a>Dimensions<\/h3>\n\n\n\n<p>When building maintenance applications, a developer\u2019s sequencing selection is analogous with selecting a Primary Key. This selection will tell m-Power how this table is unique.<\/p>\n\n\n\n<p class=\"wp-block-ht-blocks-messages wp-block-hb-message wp-block-hb-message--withicon is-style-alert\">The dimension keys in this template must be the first fields listed in the application. See the Field Settings section for more information.<\/p>\n<\/div><\/div>\n\n\n\n<p>To learn more about Dimensions, please see <a rel=\"noreferrer noopener\" href=\"https:\/\/www.mrc-productivity.com\/docs\/knowledge-base\/dimensions\" target=\"_blank\">here<\/a>.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Filters<\/h3>\n\n\n\n<p>Filters are not supported with the Data Upload Maintenance template.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Calculations<\/h3>\n\n\n\n<p>Calculations are not supported with the Data Upload Maintenance template.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">External Objects<\/h3>\n\n\n\n<p>External Objects are not supported with the Data Upload Maintenance template.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">SmartLinks<\/h3>\n\n\n\n<p>SmartLinks are not supported with the Data Upload Maintenance template.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Template Properties<\/h3>\n\n\n\n<p>The Template Properties screen allows you to adjust specific settings applicable to the template. Depending on the template, some options may or may not be available.<\/p>\n\n\n\n<p>For more on Template Properties, please see <a rel=\"noreferrer noopener\" href=\"\/docs\/knowledge-base\/template-properties\" target=\"_blank\">here<\/a>. <\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Edit Properties<\/h2>\n\n\n\n<p>The Edit Properties section allows you to control the behavior of the application. Every m-Power application has properties, however the list of available properties will be different depending on the template selected.<\/p>\n\n\n\n<p class=\"wp-block-ht-blocks-messages wp-block-hb-message wp-block-hb-message--withicon is-style-info\">This section below will only focus on properties that are specific to the Data Upload template. A complete list of globally shared properties between all templates can be found <a rel=\"noreferrer noopener\" href=\"https:\/\/www.mrc-productivity.com\/docs\/knowledge-base\/application-properties-overview\" target=\"_blank\">here<\/a>.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Program Options<\/h4>\n\n\n\n<p><strong>File Upload Max Size (xlsx)<\/strong> &#8212; Maximum size of upload file for .xlsx (in Mb).<\/p>\n\n\n\n<p><strong>Max Rows for Error<\/strong> &#8212; Maximum number of errors allowed before upload process stops.<\/p>\n\n\n\n<p><strong>Allow Null Dates<\/strong> &#8212; Allow blank date cells to be loaded as null values in the table.<\/p>\n\n\n\n<p><strong>Default File to Upload<\/strong> &#8212; Specify the directory and filename on the m-power server to be used when automating the data upload maintainer. More information can be found <a rel=\"noreferrer noopener\" href=\"http:\/\/m-power.us\/scheduled-file-upload\" target=\"_blank\">here<\/a>.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"parameters\">URL Parameters<\/h2>\n\n\n\n<p><strong>run<\/strong> &#8212; This parameter allows your Data Upload template to run automatically (such as on a schedule) using the &#8220;Default File to Upload&#8221; property.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>0: Do not run automatically <\/li>\n\n\n\n<li>2: Run automatically<\/li>\n<\/ul>\n\n\n\n<p><strong>topLineIsHead<\/strong> &#8212; This parameter controls whether the spreadsheet you are uploading has data or column headers in the first row.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>0: Top line is data<\/li>\n\n\n\n<li>1: Top line contains column headers<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\"><\/ul>\n\n\n\n<ul class=\"wp-block-list\"><\/ul>\n\n\n\n<p><strong>load_action<\/strong> &#8212; This parameter controls how the maintainer will load the data to the table.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>0: Add<\/li>\n\n\n\n<li>1: Clear and add<\/li>\n\n\n\n<li>2: Add new and update existing rows<\/li>\n\n\n\n<li>3: Add new and skip existing rows<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>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&#8230;<\/p>\n","protected":false},"author":1,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"footnotes":""},"ht-kb-category":[252],"ht-kb-tag":[],"class_list":["post-6566","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-maintainer"],"_links":{"self":[{"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb\/6566","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/comments?post=6566"}],"version-history":[{"count":27,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb\/6566\/revisions"}],"predecessor-version":[{"id":12746,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb\/6566\/revisions\/12746"}],"wp:attachment":[{"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/media?parent=6566"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb-category?post=6566"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb-tag?post=6566"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}