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
  • 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

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

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.