Panorama 5.5.0
Developer : ProVUE Development Inc
License : Demo , price : 299 $ to buy $
Size : 45.1 MB , OS : Mac OS X 10.3 or later
Date added: 2008-07-08
Category : Business Mac
Description
Panorama is a powerful tool for storing, organizing and analyzing information. It uses RAM for storage of data instead of slow hard drives. And it is able to compact 100,000 records of data in less than 10MB of storage.
Since 1988 Panorama has been in use all over the world for everything from custom accounting to medical research, from church directories to college track meets. Panorama's unique RAM based technology makes it the fastest and most flexible database available.
When writing Panorama, ProVUE engineers decided to rethink the fundamental disk based database technology that had been in use since the 1960's. Other database programs like FileMaker and Microsoft Access rely on your computer's relatively slow hard drive instead of the nanosecond access time RAM chips on your motherboard. That means these programs can't take full advantage of the tremendous increases in processor speed and RAM capacity over the past decade.
Panorama uses a completely different RAM based approach. The slow hard drive is used only for saving. All searching, sorting and data manipulation is done directly in the computer’s high speed RAM. The result is pure blazing speed -- you'll think your data has broken the sound barrier! Even better, Panorama's highly efficient storage algorithims can pack over 100,000 records in less than 10 megabytes, so there's no reason not to turbocharge all of your databases today!
Here are some key features of "Panorama":
Super fast searching and sorting.
· Panorama’s RAM based speed makes searching and sorting faster and more flexible than ever before. Searching is not limited to full word or “begins with” matches — you can search for data that contains a word or phrase or even perform formula based searches (for example “find all names longer than 12 characters” or “find all invoices where shipping is more than 10% of the order total.” Searches can also be expanded to multiple fields or even all fields in a database. The Live Clairvoyance feature allows you to perform “live” searches on any Panorama database. The search results are updated dynamically as you type, allowing you to “hone in” on just the information you are looking for.
Easy to learn and use.
· Intuitive and powerful user interface: Don't take our word for it ... "interfaces, features, and performance blow FileMaker Pro out of the water" says MacWorld "easy things are easy and hard things are not that hard" says TidBITs.
· New Database Wizard: Includes two dozen ready-to-use templates for mailing lists, invoices, financial databases and more, or create database from text file.
· Data Sheet: Get started right away with Panorama's easy “spreadsheet” like database view. You can start entering (or importing) data in seconds, and the data sheet's "wide angle" view helps you keep the big picture in focus.
· (Almost) Painless Data Entry: Powerful features like Clairvoyance® (auto-complete - we invented this in 1984 and it still isn't available in any competing database product), Smart Dates (understands dates like may 4, yesterday or last tuesday), automatic capitalization and duplicate checking make keyboard data entry fast and accurate. Panorama can even use speech synthesis to read back your input to verify accuracy (Mac OS only).
· Undo & Revert to Saved: Panorama databases aren't just easy to change, they are easy to un-change! Go ahead and experiment with confidence — slice up your data, change graphics, even make major database structural changes. If it doesn't work out just step back and try another approach.
· Auto-Save: Keep your work safe and secure — let Panorama automatically save for you at specified intervals. Or save manually for complete control. Either way Panorama saves your work to disk almost instantaneously.
· Comprehensive Documentation: Whether you're a newbie or a pro Panorama's documentation will guide you every step of the way. Unlike most printed documentation our PDF files have thousands of full size screen shots and comprehensive cross references.
High speed import/export of text, HTML, QIF, QFX OFX and Excel files.
· Tab & CSV Text Files: Panorama features extremely fast import and export of industry standard ASCII text files in both tab and comma delimited (CSV) formats. Fields can be re-arranged as the data is imported or exported. Data can be imported into a new or existing database.
· HTML Tables: Panorama can export database information as an HTML table, and can also import HTML tables into a new or existing database.
· Excel Spreadsheets: Panorama's Excel wizard (MacOS only) can directly exchange data between Panorama and Excel, with no text file required as an intermediary. The wizard can directly transfer the current Excel selection into a new database or an existing database, or it can directly transfer current the Panorama selection into the currently selected cells in an Excel worksheet.
· VCards: Exchange contact information (addresses, phone numbers, etc.) with other VCard compatible applications (Apple's Address Book, etc.)
· Financial Data: Panorama's Financial Data wizard makes it easy to import data from your Quicken files and from your bank or other financial institutions. This wizard supports the three most popular financial data formats: QIF (Quicken Interchange Format), OFX (Open Financial eXchange) and QFX (Quicken variation of OFX).
Built-in connectivity.
· Phone Dialing: Database full of phone numbers? Panorama can automatically dial for you — saving time and ensuring accuracy. Options include DTMF tones, modem, bluetooth, Vonage, Skype, Gizmo, Asterisk and more (some options require third party software).
· Maps: Add interactive maps (US addresses only) to any database with a single line of code. Maps are zoomable and resizeable, and you can open multiple map windows simultaneously .
· White Pages: Look up addresses and phone numbers and automatically add them to your database. This feature can be built into your database or use our pre-built wizard.
· Address Verification: Check US addresses, add Zip+4 and other geographical information via the official US Post Office web site. This feature can be built into your database or use our pre-built wizard.
· FedEx Tracking: Track progress of FedEx shipments via Panorama's pre-built wizard (or add to your database with a few lines of code).
· Automatic Email: Panorama can send e-mail to individual or bulk recipients. You can program e-mail transmission into your own database (for example setting up an invoice database to automatically e-mail a copy of each invoice) or use the Bulk Email wizard. The wizard makes it easy to send and keep track of bulk emails, keeping previous e-mails you've sent organized, and automatically extracting e-mail addresses from one or more other databases.
Powerful data analysis tools (including data outlines, crosstabs, charts, and statistics).
· Data Outlines (with Live Summaries): Panorama’s data outlining feature is a powerful tool for analyzing financial data, and unlike other database programs is totally interactive. You can hide and reveal different levels of subtotals, identify problems or opportunities and then zoom in on specific details, and can even perform further operations or calculations on subtotals as if they were data.
· Raw Data Summary Records with Subtotals Collapsing the Data Outline (summaries only) Expanding Individual Summaries
· Crosstabs: Now you can quickly and automatically convert raw data into a tabular summary (for instance turning raw checkbook data into a monthly budget). Crosstabs are one of the most powerful tools yet for analyzing financial data.
· Charts: Panorama's built in charts (bar, line, area, pie, and scatter) can visually reveal trends and relationships that
· are often hidden in a conventional report.
· Statistics Wizard: Panorama's Mini Statistics wizard can calculate the mean (average), median, and standard deviation of a data set. In addition the wizard can plot a normalized chart showing how the data is distributed around the mean. You can easily see how this distribution compares with the standard gaussian distribution (the famous bell shaped curve). Here is an example of an analysis performed by this wizard.
Super fast bulk data modification.
· Unlike most databases Panorama isn't limited to modifying one record at a time. Panorama's RAM-based index free database technology makes possible bulk modification of tens of thousands of record per second. Your data and data structure is no longer carved in stone — morph it as needed to meet changing database needs.
· Find and replace: Locate and replace a word or phrase anywhere in a field. Nearly instantaneous even with tens of thousands of records.
· Formula Based Transformations: Panorama includes a full suite of functions and operators for manipulating text. These functions can be used to automatically modify a single cell or an entire database of information — all in seconds. Typical applications include: Joining multiple fields into a single field; Splitting a field into multiple fields (for example Name into FIrst and Last names); Convert text to upper case, lower case, or first letter capitalized; Extracting data from a field (for example street name from addresses); Unit conversions (miles into kilometers, gallons into liters, etc.); Normalizing and denormalizing data
· Remove duplicates: Panorama can automatically locate and remove duplicate information, or you can review the duplicates for manual conflict resolution.
Fully relational links between databases.
· One to One: Panorama supports one-to-one links for applications like linking invoices to customers (one customer per invoice), invoice items to inventory (one product per line) etc.
· Range-to-One: Panorama supports range-to-one links for looking up shipping rates, tax rates, and other applications where each entry in a table corresponds to a range of value.
· One-to-Many: Panorama supports one-to-many links for applications like looking up previous invoices to a customer (many invoices per customer), checks written to a vendor (many checks per vendor), etc.
Specialized graphic tools for on-screen forms & printed reports.
· Complete Layout Tools: Panorama has all the tools you need for precision graphics and layout. Customize your forms with standard or custom pushbuttons, checkboxes, radio buttons, pop-up menus and lists.
· Elastic Forms: One size fits all? Not with Panorama — elastic forms adjust automatically as the window size changes. Traditional fixed sized forms can be made elastic in seconds. You can even create elastic images that resize intelligently for borders, variable sized buttons and more.
· Matrix Grid Objects: Panorama includes a special matrix grid tool for creating custom matrixes like calendars, photo thumbnails, invoice line items and more. Simply create a template for each cell and specify the dimensions of the grid and Panorama does the rest!
· Word Processor: Panorama includes a built in word processor so that you can create and edit fully formatted and styled text within your database. Make your own form letters with built-in mail-merge for print or e-mail. Perfect for organizing correspondence, catalogs, and much more.
· Multimedia: Include images, movies and sound in your layouts. Images can be added simply by dragging from the Finder to a database (Mac OS X only).
· Powerful Printing Tools: Need to print labels? Panorama includes templates for 26 Avery™ labels, or you can create your own. Panorama's report tools give you full control over report appearance including data, summaries, headers and footers, even widow and orphan control. Reports can include multiple pages per record (for multi-page tax forms, invoices, etc.), or you can set up variable height records that adjust automatically for height of text and/or images in each record. Panorama can control what printer reports are sent to and can even automatically generate PDF files (Mac OS X only).
Fully programmable (including AppleScript, Shell Scripts, Perl, Ruby, Python & PHP).
· "Watch me" Recorder: Let Panorama write the code for you — the built-in recorder automatically watches your actions and records them for later playback. (Recorded programs can be edited later.)
· Program Editor: Text based editor Includes multiple windows, undo, automatic indenting, search/replace, bookmarks and a searchable language reference.
· Debugging Tools: You don't want to spend any more fixing bugs than you have to, so Panorama comes with a full suite of debugging tools including breakpoints, single stepping, debug trace log and error reporting wizard. Panorama also has a cross-reference tools to help you keep a handle on large programming projects.
· Flexible Triggering: Programs can be configured to run based on almost any type of event, including clicking on menus, clicking on buttons, any keystroke combination, database open/close, at specified intervals and more.
· Customizable User Interface: Panorama lets you control almost every aspect of the UI, including full control over the menu bar, window appearance, custom dialogs and alerts. On Mac OS X Panorama also supports Growl for for transparent, non-modal notifications.
· Extensible Language: If one of Panorama's 1500+ statements and functions doesn't do the job for you then write your own! Your custom statements and functions can be used in any database and work exactly like Panorama's built in statements and functions.
· Perl, Ruby, Python, PHP, Shell Script and AppleScript: Panorama's language is powerful, but it is only one of many galaxies in the programming universe. Panorama 5.5 allows programmers to embed six different languages directly into a Panorama program. Panorama's support for embedded languages is more than skin deep. Data can be be passed back and forth between Panorama and the embedded code, and Panorama integrates with external tools to help you debug your embedded code.
· Learn from Tons of Source Code: Experienced programmers know that studying source code is one of the best ways to learn, so Panorama comes with thousands of lines of code you can examine and experiment with. There's also a vibrant on-line community that programmers can participate in.
Built in security.
· 256 Access Levels: Panorama lets you define up access levels from 0 (minimum) to 255 (administrator). Access levels can be used to limit access to specific operations, commands and groups of commands. For example, you can set up a database so that only users with access levels above 100 can print the database, or so that only users with access levels above 150 can create a form.
· Restricted Data Access: The ability to see or change data can be restricted on a field-by-field basis.
· Security Groups: A user can belong to one or more security groups and have different privileges when accessing databases in different groups. For example, authorized employees in the personnel department need high access levels when they are using the employee database, but low access levels when they are using the general accounting database. Accounting clerks, on the other hand, need the reverse: high access levels for the accounting database but a low levels for the employee database.