| Data Juggler Registered User's Community | |
| Your Upgrade and Technical Support Plan (UTSP) | Useful Documents |
|
Data Juggler Information Packet
|
| Click to Download | Description |
 |
Version 2008.4.1 (djsetup.exe, 63MB, released 11/11/2008) A new installation is required for this version. |
 |
Version 2008.4.1 (data juggler.exe, 3MB, released 11/11/2008) If you already have Data Juggler version 2007, you can simply download this upgrade file. No administrator privaleges are necessary. |
 |
Trimmer (trimmer.exe, 32k) Run the Trimmer against any Microsoft Access or ATAC database to remove those pesky spaces. Don't allow them to throw off your queries or skew your statistics - clean them! |
 |
Scheduler (scheduler.zip, 77k) Schedule Data Juggler or GeoGenie operations automatically and routinely backup files and directories. Unzip the two files, place them in the same directory, and run the Scheduler.exe file. |
| Click on a version to view details | |
Email Support: Unlimited | If you have version 2007 or newer just download the “data juggler.exe” file and overwrite your existing one to receive the new features. This is because there were no major system changes between the 2007 and 2008 versions.
For those with older versions of DJ (2006 or older), this upgrade process may be a bit more tricky, so feel free to contact us so we may help you through the process.
2008.4.1 Improvements:
- Significant speed improvements in reordering and selecting Data Translation Statements.
- Ability to halt the translation when an error is encountered.
- Ability to compact and repair a database as part of a Routine.
- Automatically inserts line feeds when concatenating database rows.
- User interface improvements.
We hope the new version makes the translation from your RMS easier.
Thanks for your continued support!
The Bair Software Team
Load Word Document into Synopsis - If your RMS stores the police report or any other narrative information as a path in a database variable, you can now use Data Juggler to open that Word document, copy the contents and paste it into a Memo field!
Clean ATAC Database - Now you can create a DTS that will automatically clean your ATAC database right from within Data Juggler
Save ATAC Database As - And of course, once the data is clean, you'll want to save the newly downloaded records into an ongoing crime analysis database - now you can.
Parse Last Name - Some RMS systems store the person's name in a single field (e.g. Bair, Sean M.) This of course makes it difficult to break apart to store or use. Hence, you can now run a DTS that will parse the last name out and place each component into the appropriate Last Name, First Name and Middle Name field.
Combine Records - New feature that allows those with an RMS that store each line of a police report to combine them into one field. HTE Users should like this feature.
Enhanced User Interface - now provides more information right at the main screen.
Getting Started Wizard! - If you have never developed a translation, simply create a new Routine with the Wizard option and let him walk you through the basics.
Introduction of the "Wait", "Execute Stored Queries", and "Trim" data translation statements.
Wait = wait 5 seconds for other operations to complete
Executed Stored Queries = execute queries contained in your database
Trim = Trim the extraneous spaces from all variables in a table
Enhanced the user interface to expand the text boxes when resizing the windows.
Provided the ability to only query the top 100 rows of a large table or query. This significantly increases the speed at which records are returned to the grid.