Panorama X includes full support for industry-standard regular expressions, enabling powerful and lightning fast pattern match based searches and search/replace. Data can be automatically restructured as it is imported or exported to match up with external programs (for example re-arranging, merging or splitting fields as the data is imported or exported). Export supports the same formats plus HTML. Panorama X can import text files in comma-separated (csv), tab-separated (tsv), or json format. (One of the databases shown in the demo movie contains registration details for all 314,000 aircraft in the United States in only 81 megabytes.) In fact, Panorama databases can typically store five to ten thousand records per megabyte of RAM, allowing Panorama to easily handle extremely large databases. Panorama X databases contain no indexes, so they are extremely space efficient (high speed RAM operation makes indexes unnecessary). Panorama can also look up the city and state for a zip code. Databases that contain latitude/longitude data can be searched for proximity to specific locations - what airports are within 200 miles of San Francisco? If a database contains addresses within the United States, approximate proximity searches can be performed based on the zip code (lat/long data not required). If your data contains addresses, Panorama X can display it on a map. Relational keys are not limited to a single field, and can even be defined with a formula. Panorama's relational model supports one record-to-one record links, range-to-one record (shipping and tax tables, for example), and one record-to-many records. Panorama X streamlines data entry with features like Clairvoyance™ (auto-complete), automatic capitalization, input and output patterns, default values and the unique smart date feature that understands human friendly dates like today, friday or last monday. Proposed modifications are previewed in real time as they are changed, and actual database manipulation occurs at 10k-50k records per second. Multiple parsing/manipulation rules can be chained together for complex transformations, and sets of parsing/manipulation rules can be saved for later re-use. Modify all fields in a single operation.Recalculating entire field (with formula).Search & replace words, phrases or regular expression patterns.Splitting combined names into separate first/last names.Entire datasets can be rapidly altered based on parsing/manipulation rules set up from pop-up menus (advanced users can also use arbitrary formulas and regular expressions). Fields can be added, removed, rearranged, hidden, merged or split at any time. Panorama allows huge data sets to be bent, reshaped or refactored at will. You can even integrate code written in AppleScript, shell script, Python, Ruby, PHP and more. Programmabilityįor advanced users, Panorama X includes a full-featured programming language, including conditional logic, subroutines, alerts and dialogs, full menu control, background timers, asynchronous internet access, and much much more. It can also be attached to a button, or set up to trigger when a specific event occurs. The recorded code is automatically added to the Action menu, where it can be played back at any time. Just turn on the "watch me" recorder and Panorama will automatically write the code for you as you search, sort, and perform other database tasks. Recordabilityīasic automation doesn't require any programming at all. That's why every aspect of Panorama X operation can be automated - database manipulation, modifying database structure, even graphical layout tasks can be automated. If a task is going to be performed more than 2 or 3 times, automation is the best way to ensure that the task is performed rapidly and accurately. Here at ProVUE, we're big believers in automation.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |