Skip to Content mrc logo mrc logo
  • What is m-Power?
    Overview Demos Build Process Case Studies Specs Pricing Trial
    m-Power Resources
    Overview How-To Videos Webinars & Podcasts White Papers Fact Sheets
  • What does m-Power build?
    Solutions by Industry
    Overview Database Front-Ends AI Reporting CRM Systems Business Intelligence Dashboards Inventory Management Mobile Apps ERP Enhancements Modernization
    Spreadsheets to the Web MS Access to the Web B2B/Web Portals Scheduling Embedded Analytics Web Forms Workflow Data Exploration Budgeting & Forecasting APIs & Web Services Db2 Web Query Alternative
    Solutions by Industry
    Overview Manufacturing Government Foodservice Software Vendors Logistics & Supply Chain Software Consultants Healthcare
  • Development Services Training Mentoring
  • Overview Partners Press Releases Careers Events Contact Blog
  • Support Home FAQ Documentation Customer Portal Enhancements Updates Roadmap Techblog
Try m-Power

m-Power Manual

Browse:

  • Home
  • Security
  • Promote Menu Data
Back to Manual

Promote Menu Data

This document is applicable for m-Power clients who connect to different databases for their development and production applications. In this case, developers often have challenges in migrating their menu data from their development database to their production database. This documentation will cover how to achieve this.

Exporting Menu Data

To begin, ensure that your "Application Menu and Security" looks like the following:

If it does not, please consult this document to learn about converting your menu.

Click on the "Promote Menu Data" button.

You will most likely want to promote all of your menuing data, so click the "Select all" link, then press "Export Selected Data." Once successful, you will see a green success message.
Note: If you've modified any of your MRCSEC objects to be views, please do not select them as this will cause the import process to fail.

On your m-Power server, we have created for you a file in /mrcjava/WEB-INF/data/ with a name of "menu-export" plus an EPOCH time. This file should not be edited. You will need to move this file into the same location within your production instance.

Importing Menu Data

The process of allowing data to be imported into your production instance is disabled by default. To enable it, please add the following code to your production /WEB-INF/web.xml file, directly before the tag:

<servlet>
<servlet-name>ImportData</servlet-name>
<servlet-class>mrc.ImportData</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>ImportData</servlet-name>
<url-pattern>/servlet/mrc.Migrate</url-pattern>
</servlet-mapping>
<security-constraint>
<web-resource-collection>
<web-resource-name>mrc Data Migration</web-resource-name>
<url-pattern>/servlet/mrc.Migrate</url-pattern>
</web-resource-collection>
<auth-constraint>
<role-name>manager-gui</role-name>
</auth-constraint>
</security-constraint>
<login-config>
<auth-method>DIGEST</auth-method>
<realm-name>mrc Data Migration</realm-name>
</login-config>

Once completed, save your changes and restart Tomcat.

Assuming your production instance is at 1.2.3.4, direct your browser to: https://1.2.3.4/mrcjava/servlet/mrc.Migrate
You will be prompted to log in. Unless you have already changed (recommended), the user of mrcuser/mrcuser will allow access.
Note: Any user in the manager-gui role as defined in /m-power/tomcat/conf/tomcat-users.xml will have access.

Once authenticated, you will see the following screen:

Select the file you would like to import into the production database, and click Import. During this process, m-Power will create the files on your production database, if they don't already exist. If they do, m-Power will adjust the existing data accordingly and update the production database.

Created: February 9, 2018 | Modified: April 10, 2020

Search


Browse By Category

Build Process (13)
Starting with m-Power (8)
Retrievals (10)
Reports (15)
Summaries (4)
Maintainers (17)
Graphs (8)
m-Power Data Explorer (4)
General (24)
Calculations (5)
Utilities (9)
m-Power Administration (23)
Security (11)
Freemarker (6)
m-Painter (29)
Form Validation (5)
External Objects & UDFs (12)
Deprecated Documentation (23)
Bootstrap Templates (7)

Popular Tags

Maintainer Dropdowns Calculations Freemarker Admin External Objects Excel Maintainers Data Dictionary Report Graphing Email Build Process Production App Properties Getting Started Bootstrap Templates Retrieval SQL Video RPG Dates Compiling mrc-Productivity Series Java Performance Advanced Bar Graphs Popular Parameters Summaries Prompt Screens m-Painter DB2 Form Validation Security Graphs Reports Application Properties Administration Database Tomcat Retrievals Record Selections Graph Properties

See all tags »

mrc

Build the custom apps and AI tools your business needs with m-Power, or have our Chicago-based team build them with you. One platform, one team that makes sure you succeed.

Since 1981 · 1,500+ customers · 4.7/5 on G2

m-Power
Overview Demos Build Process Licensing Specs Get a Demo
Solutions
Database Front-Ends Reporting AI Tools Dashboards ERP Enhancements Modernization See all solutions
Company
Case Studies Services About Blog Careers Contact Support

Privacy Policy Cookie Policy Cookie Settings

michaels, ross & cole, ltd. (mrc)
US: 2001 Midwest Road, Suite 310, Oak Brook, IL 60523 · 630-916-0662
UK: Mortlake Business Centre, 20 Mortlake High Street, London, SW14 8JN · +44-20-335-59566
© mrc. All rights reserved.