mrc logo mrc logo
  • m-Power m-Power
    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
  • Solutions Solutions
    What does m-Power build?
    Overview Database Front-Ends 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 and Web Services Db2 Web Query Alternative
    Solutions by Industry
    Overview Manufacturing Government Foodservice Software Vendors Logistics & Supply Chain Software Consultants Healthcare
  • Services Services
    Development Services Training Mentoring
  • About About
    Overview Partners Press Releases Careers Events Contact Blog
  • Support Support
    Support Home FAQ Documentation Customer Portal Enhancements Updates Roadmap Techblog
Try m-Power

m-Power Manual

Browse:

  • Home
  • Utilities
  • Scheduled FTP Tasks
Back to Manual

FTP and Scheduled Tasks

This documentation covers how to use m-Power to send from an m-Power server to a remote server via FTP. One use case of this feature would be to couple this with scheduled reports and have m-Power output reports to an output queue, then FTP them elsewhere.

As a quick note, an FTP process (File Transfer Protocol) requires that the remote host to have FTP software installed and configured on the server. This documentation below will assume you want to generate a report, the FTP it to a different server.

Creating a scheduled FTP task

Developers will configure and schedule their FTP process in the same step. When triggered, the FTP process will examine the selected queue on the m-Power server and move all files found to the FTP server. This process will occur at the selected frequency chosen by the developer. To configure, navigate to the Messaging and Scheduled Tasks, then Messaging Menu –> Scheduled Task. All scheduled tasks can be viewed here if previously created. Select ‘Create New Scheduled Task’.

The Schedule Task Definition menu appears as below:

-Scheduled Type-: There are three selectable types from the dropdown menu. Task Group, Business Rules Process, and FTP Queue. Select FTP Queue
-Frequency: Determines how often you would like the scheduled task to be executed, and poll the queue based on this specified interval
-FTP Type: There are two options; FTP and SFTP. Selecting SFTP will remove the Password field and displays a “Key File” input field where you can specify the location of your SFTP key file. Known Hosts Field is also displayed for SFTP, but is optional.
-FTP Address: The web address of your target server for your FTP. This will be where you are looking to move the files generated from your scheduled task (ex. www.myserveraddress.com)
-FTP Port: The specified port number for which the FTP protocol will be initiated. The receiving server must be listening on this port in order to receive files
-Remote File Location: This field will specify the remote locations in the target server for your target applications. This step is important, as you will need to know the directory path specified in your created queue. For example, my created queue has a directory path of C:\temp. If I want to FTP my file to C:\temp, then I do not need to write anything in this field, as my queue is already set up for this path. If I would like my target application to be placed within the C:\temp on the target server, then I will specify this in Remote File Location field as /folder1/folder2/folder3/etc.
-Username: Username to be passed that verifies the user on the target server
-Password (FTP only): Password to be passed that verifies the password for the above user on the target server
-Key File (SFTP only): This file, provided by your server, provides the necessary authentication/authorization for connectivity.
-Known Hosts File (optional, SFTP only): If your server requires this for connectivity, please detail here.
-Queue: Select the queue from the saved queues dropdown list that you would like to use for this scheduled task

Note:
• More information on scheduled tasks may be found here.
• It is assumed for the FTP scheduled task, that the configuration of the Messaging and Scheduled Tasks Utility is already configured. Help on configuring the scheduler can be found here.

Created: August 28, 2017 | Modified: August 29, 2017

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

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

See all tags »

michaels, ross & cole, ltd. (mrc)

Privacy Policy Cookie Policy Cookie Settings Notice at Collection Do Not Sell or Share My Personal Information

mrc (US)

2001 Midwest Road
Suite 310
Oak Brook, IL 60523
630-916-0662

mrc (UK)

Mortlake Business Centre
20 Mortlake High Street
London, SW14 8JN
+44-20-335-59566


© 2024 mrc. All rights reserved.