MARS
|
MARS 5.6.080924 is a Database Management product from christiansteven.com, get 5 Stars SoftSea Rating, MARS is a dynamic, flexible, function-rich and intuitive automation tool for scheduling, exporting, distributing and delivering your Microsoft Access reports, queries and macros. Additionally, MARS contains strong system, event and process automation functions which will make an instant impact on the efficiency of your business. The merging of Business Process Automation and Access Queries & Reports Distribution makes MARS unparalleled as a unified Business Management Solution.
MARS is an software for Windows that saves time and money by making it easy to define single or packages of Access Reports, Queries, Macros & Tasks, schedule and run them automatically, and send them to print, fax, disk, ftp or email in a number of standard formats.
Simply set up a schedule stating how often you would like each report or query to run, whether youd like the output in Word, Excel, HTML, RTF, Acrobat, text format, and more and who it should be sent to.
Use standard frequencies like Daily, weekly, monthly or set up your own custom frequencies e.g. 4-4-3, every other day, third Monday of the month.
The same report or query can be scheduled to be run multiple times with different parameters, formats, frequencies, and destinations.
Respond to your business needs by setting schedules to run based on events rather than date. With MARS Event Based Schedules, you can have reports fired off when events occur e.g. database value is present, file is modified, window is present.
Use MARS unique Dynamic Schedule process to trawl through your database to find the parameter values to use and then generate and deliver a unique report for each value.
Once your schedule has been executed, why stop there? Use MARS unique Custom Actions to run another program, enter values in a database, modify a file and lots more.
MARS familiar Explorer-like interface makes it easy to define and schedule report packages.
The context (right-click) menus and full copy-and-paste support make it easy to create complex distribution schedules.
The scheduling service runs as a desktop application, or as an NT service. It will integrate with Exchange Server 5 (SP4) and above (2000 and 2003) or SMTP.
Whether youre spending too much time running and distributing Access reports or query output to line managers, or you need to provide corporate management with tailored reports on a regular schedule, MARS gives you the tools that you need.
Main Features:
Schedule Types
MARS' comprehensive set of job (schedule) types gives you the power you need for any occasion..
Scheduling Frequencies
No other automation tool provides the huge array of frequencies that MARS makes available at your fingertips.
Output Formats
With more output formats, and enhanced formatting & manipulation options than any other Microsoft Access scheduling tool, MARS gives you the flexibility to satisfy your formatting requirements with ease. Acrobat (PDF) Character Separated (CSV) MS Excel (XLS) MS Word (DOC) Tiff (TIF) Other available formats
* Data Interchange Format (DIF)
* dBase II, dBase III & dBase IV (DBF)
* HTML (HTM)
* Lotus 1-2-3 (WK1, WK3 & WKS)
* Rich Text (RTF)
* Text (TXT)
* Microsoft Access Data Access Page (HTM)
* Microsoft Active Server Pages (ASP)
* Microsoft IIS (HDX)
* Snapshot Format (SNP)
* Destinations
Flexible, highly customizable and function-rich destination functionality..
Printer:
* Output to a single printer.
* Multiple copies to a single printer.
* Output to multiple printers (bulk printing).
* Multiple copies to multiple printers.
Email:
* Set up & use one or multiple SMTP servers.
* Use different SMTP servers/accounts for different schedules.
* Nominate one or more SMTP servers as backup or fail over servers.
* Connect to Secure SMTP servers.
* Connect and send via GroupWise.
* Connect & send via MAPI.
* Silent integration with MS Outlook & MS Exchange.
* Use Outlook/Exchange address list.
* Use MARS' built in address list.
* CC & BCC
* Insert additional files as attachments.
* Read email addresses from a database.
* Read email address from a mailing list (text file).
* Insert individuated tags in email body. For example, Dear {tablename.firstname}.
* Send emails in plain text or HTML.
* Use raw HTML code to construct better looking emails
* Embed report into email body.
* Read Receipt Processing.
Disk:
* Output to local drives. For example C:\MyReports\Today.
* Output to network shares and UNC paths. For example \\MyServer\C\MyReports\Today.
* Output to a remote system by Dial-Up Networking or VPN.
* Choose to append to an existing file instead of overwriting it.
FTP:
* Upload reports to FTP server.
* Supports Secure FTP - SSL 3 & SSL 3.1 (TLS).
* Upload non-report files.
* Download files from FTP server.
FAX:
* Manual or automated output to fax driver.
* Choose to include a cover sheet.
* Single or multiple recipients per schedule.
ODBC:
* Export the query data directly to a database table via and ODBC DSN.
* Choose to overwrite if target table already exists.
SMS (Cell phone Text):
* Send a text alert or simply embed a text report body into an SMS message.
* Use a local GSM Phone or device.
* Use a service provider (SMSC) via standard modem.
Other Destination Options:
* Compress (ZIP) file before delivery.
* Password protect ZIP file using zip encryption level 128, 192 or 256.
* Customize the output file name
* Customize the output file extension. For example, a CSV file normally named myfile.csv can be exported as myfile.abc.
* Append a date/time stamp to the output file.
* Deferred delivery allows you to take environmental issues into account. For example, export the reports at 1am, but do not email them until 7am as the email server is unavailable during those hours.
* Use PGP Encryption to secure file before delivery.
* Select multiple destinations. For example, the same report can be emailed to one recipient and a copy saved to a folder on your server.
Custom Tasks:
* Give yourself outstandinger control by using MARS' Custom Tasks to create automation scripts. Use them as a complete automation process in automation schedules, or to provide additional enhancement as part of report export schedules.
Additional Report Schedules Task Actions
* Run Custom Tasks before report delivery.
* Run Custom Task after report production.
* Run Custom Task after report delivery.
* Run Custom Task before and after a report has exported.
* Use custom tasks to create Automation Schedules.
Available Custom Tasks:
* Run Program (bat, exe, com)
* Open, Print Document
* Wait/Pause
* Send SMS
* Execute Schedule
* Set, Delete Create Registry Key
* Copy, Rename, Move, Delete File
* Write to Text File
* Zip, Unzip Files
* Create, Rename, Move Folder
* Merge PDF Files.
Send an Email:
* Open a Web Address
* Upload to FTP
* Download, Delete from FTP
* Create, Delete FTP Directory
* Run Macro/Query
* Execute SQL Script
* Run Stored Procedure
* Insert, Update, Delete Database Record
* Create, Delete Database Table
* Create, Delete Table Column
* Compact Database The license of this business & finance software is Free Trial Software, the price is $2995.00, you can free download and get a free trial before you buy. If you want to get a full or nolimited version of MARS, you can buy this business & finance software.



