Within minutes from downloading ExportR, the software can be installed and running against all data tables – a process that could otherwise take months of detailed work by expensive legacy system experts.
The ExportR data extraction tool is used to unlock data 'trapped' in the multivalue Pick-based environments used by Revelation ROS files and Advanced Revelation (ARev) and OpenInsight .LK and .OV files. Extracting data from these Revelation and ARev environments is notoriously difficult due to non-standard characteristics such as variable length records, variable length fields, repeating field values and unfamiliar delimiter implementation.
As these unique features do not conform with the more widely understood relational database format, many otherwise technically competent IT personnel struggle in identifying the underlying metadata and in extracting this data into a usable and meaningful structure. We have developed and perfected our ExportR software to solve these data extraction needs by providing easy to use software that will produce usable data in familiar formats, for example CSV files or Microsoft Access tables. A task that could have taken months without the use of our specialised software can be completed within hours or even minutes. Because the ExportR extract is automated, the process is repeatable and gives a higher degree of accuracy.
Although alternate Revelation Database and OpenInsight Database extract solutions exist, none of these options compare with ExportR's ease of use. Alternate methods include third party products or using the basic functions that already exist within Revelation and OpenInsight. Using any of the options other than ExportR requires identifying table names, field names and the associated data types. These options also rely on a very good working knowledge of the Revelation, Advanced Revelation or OpenInsight environment and command set.
Amon Consulting are able to provide the following software and services to assist with data extraction from multivalue based ROS, LK and OV files originating from OpenInsight, Revelation G2B (or earlier) or Advanced Revelation (Arev) databases.
The table, field and data type structures can be output as specified in the source OI/Revelation/Arev database (this is the default) or output can be mapped to an alternate database structure. Output data options include CSV, MS Access, Microsoft SQL Server or MySQL.
The ability to view the exported data in MS Access format facilitates the identification of wanted tables and fields, allows for reporting requirements and also provides a platform from which to reformat data for upload into the destination application's database structure.
Approximate elapsed time for a full data extraction and conversion to MS Access format is 30 minutes per zipped megabyte.
Up to three CSV files are created for each Revelation table exported.
For further information regarding the extensive output options available and for additional technical detail, please request a copy of our ExportR manual. In 90% of cases the manual will not be required as data extraction requirements are usually straight forward and the standard defaults are usually all that is needed.
RevelationG data, Revelation G2B data, Advanced Revelation (Arev) data and Open Insight data (LK & OV files) can easily be extracted from the following software platforms, applications and packages using the ExportR automated data export software.
ADP * American Business Management Systems (ABMS) * American Business Networking * Angel Systems AVENUES * Argus * Ceridian Encore * Ceridian Ensemble * Ceridian Repertoire * COBRA * Comcheq * Comsense Advantage * Comsense Cecommand * Counterpoint Systems, Inc * Debtmaster * EXXIS * Furniture Retail Operations Group (F.R.O.G.) * GAAP * GPMate * Harmony Solutions HRM-ONE * HPMS * HR/PC Payroll * HR-1 * HR2000 Technologies * HR-InfoNet * HRIS * HRPro * IDEAS/OGS * Immigration AIDE * Infosphere * iTMS Software * J C Henry & Co * Jones Microcomputing Services Software * Maestro * MAPCON * Megamation * Meridian Data Systems * Mills & Murphy HPMS * National Software Systems * New Century Accounting Modules * PayDay Manager * PANDORA taxonomic database * Paylink * Powerforce Time & Attendance (T&A) * Powerforce Occupational Safety and Health Incident Management (OH&S) * Royal Bank * RetailWare (including ScubaWare) * Social Software ACE, UMIS, YOIS * Source 100 * Solution Specialties Tracker * Spectrum * SRP Computer Solutions Software * SurveyIt! * TD Bank * Totally Integrated Management System (TIMS), TPS, and more.