• Home
  • Products
    • CRD
    • MARS
    • SQL-RD
  • Member Area
    • CRD
    • MARS
    • SQL-RD
    • Forgotten Password
  • Contacts
  • Support 
    • CRD
    • MARS
    • SQL-RD

.

  • Back to MARS
  • Bookmark this page

 

 





1.
Single Report Schedule
Schedule a simple Access Report to export to HTML every weekday at specified times of the day.
2.
Packaged Schedule
Schedule a number of reports as a "package" to export to HTML every Monday and Friday at specified times of the day.
3.
Automation Schedule
Schedule to create a specified folder on the first Monday of every month.
4.
Event-Based Schedule
Fire off and deliver reports automatically when an event occurs.  Here are some examples.
    
  • If a file exists
  • If a file has been modified
  • If a database record exists
  • If a database record changes
  • If an unread email is present

 

  • Advanced: If a new database record exists, use  the data in the record to send an email to a recipient
  • Advanced: If an unread email is present use data in the email to create a new database record.

 

5.
Event-Based Package
Group a number of event-based activities and determine timing, order of execution and more
6.
Dynamic Schedule
MARS will reel through a list of parameter values, generate a unique report for each value, and deliver each report to a unique destination (e.g. email address, folder, etc). Saves you from having to write and maintain multiple schedules.
 
  • Simple Dynamic Schedule
  • Advanced Dynamic Schedule
7.
Dynamic Package
Same as Dynamic Schedules, but multiple reports to specified destinations.
   
  • Simple
  • Advanced
 
8.
Calendar
Create your own scheduling frequencies using Custom Calendars (e.g. 4-4-3).  Or use Exception Calendars to skip special days (e.g. public holidays)
  
  • Custom Calendar
  • Exception Calendar
9.
Report Options
Set up logon credentials for the report, linked table and other options. Keep copies of exported reports for x days.
10.
Report Parameters
How to tell MARS what report parameter values to use.
11.
Exception Handling
Retry x times on failure. What to do if the report "hangs". Take some action if the report returns no data.
12.
Destinations
MARS will send your reports to a number of destinations.
   
  • Printer
  • Fax
  • Email
  • FTP
  • Disk
  • SMS (Cell phone text)
13.
Default Destinations
Set up a number of destinations (email, printer, fax, SMS, folder and FTP) and use them over and over again.
14.
Output Formats
Learn how to quickly set up schedules to export to pdf, tiff, xls, and many more formats.  Also shown are output features e.g. custom report naming, zipping the export, zip encryption, deferred delivery, and lots more.
   
  • Acrobat with images (PDF)
  • Acrobat without images (PDF)
  • dBase II, III and IV (DBF)
  • HTML (HTML)
  • Lotus 1-2-3 : WK1, WK3, WK4, WKS
  • Microsoft Excel (XLS)
  • Microsoft Word (DOC)
  • Rich Text (RTF)
  • Data Interchange Format (DIF)
  • Microsoft Access Data Access Pages (HTM)
  • Microsoft Active server pages (ASP)
  • Microsoft IIS (HDX)
  • Snapshot Format (SNP)
  • Text (TXT)
  • TIFF (TIF)
  • Character Separated (CSV)
15.
Custom Tasks
When the report has been delivered, run a batch file, update a database, send an email and more.
16.
MARS Constants
Insert Constants (e.g. Yesterday's Date, CurrentScheduleName, ExportedFileName) to automate otherwise repetitive and mundane processes.
17.
User Management
   
  • Setup and manage users
  • Assign schedules to users
  • Remove users
  • Setup Security roles and groups
18.
Using Outlook (MAPI)
Set up MARS to use MAPI to send emails.
19.
Integrating the NT service Exchange Server
Set up the MARS NT service to use Exchange Server to send emails.
20.
Using MARSMail
Set up MARS to use MARSMail to send emails.
21.
Using SMS text
Set up MARS to send SMS text alerts.
22.
Using SMTP
Set up MARS to use SMTP to send emails.
23.
Using GroupWise
Set up MARS to use GroupWise to send emails.
24.
Auto System Backup
Automatically backup the MARS system and files.
25.
Application Scheduler
Set up MARS to use the Application Scheduler.
26.
NT Service Scheduler
Set up MARS to use the Windows (NT) Service.
27.
Address Book
   
  • Setting up Contacts & Groups
  • Exporting & Importing
  • Editing Contacts & Groups
  • Deleting Contacts & Groups
28.
Smart Folders
Use smart folders to group schedules and to report on schedule activity
29.
User Defaults
Don't type the same password, email body, signature etc over and over again.  With User Defaults you can enter than once, and reuse them each time your write a schedule.
30.
Audit Trail
Set up an audit trail showing activities that have happened in SQL-RD.
31.
Remote Administration
Connect to and administer remote installations of MARS from your PC.
32.
Housekeeping
Set up folder housekeeping and other automated processes to help keep your system and pc robust and stable.
33.
Clustering
Use multiple PCs to schedule hundreds of reports.  The "Master" controls a bank or "cluster" of PCs ("slaves") and instructs them what to run and when.  See how easy it is to set this up.
34.
Migrating the MARS database from file system to an ODBC compliant database
The MARS data (schedule info etc) is stored in a Access database locally.  Migrating to a SQL, Oracle or other ODBC compliant database gives you enterprise scalability and reliability - and gives you the ability to write triggers, stored procedures and add custom functionality.

Important:  Click here and read this document before you begin the process.

35.
Migrating from an ODBC compliant database back to the local file system
Migrate back to the local file system.  Useful if you know your server is going to be down for maintenance.

 

© Copyright 2002-2008 ChristianSteven | All Rights Reserved | Website Design by Inverse-Logic