Rigel Tips

TopicTipApplies to
Importing Excel spreadsheetsRigel can import crime/suspect data from Excel spreadsheets in xls, xlsx, or exported csv format. You can select which sheet to import if there are multiple sheets. Your data should have at most one header line, follwed by identically-formatted data rows with no empty rows and no rows in a different format. Be sure to check the automatic field assignment in the Rigel import box and correct it if necessary before proceeding with the import. If the data does not appear to import correctly, go back and check your spreadsheet format and field assignment. If there are any issues with Excel, you might be able to resolve them by exporting the sheet from Excel to csv file format. Caution: spreadsheets originating from Mac Excel versions prior to 2011 may incur a 4-year date offset when moved to Windows Excel.All
Lat/long coordinate formatsWhen entering site lat/long coordinates in the program, Rigel expects either Decimal degrees format (example 49.215 N) or Deg Min Sec format (example 49° 16' 22" N). A leading negative is equivalent to West or South. Separators can be any of: -, space, °, ', ", N, n, S, s, W, w, E, e. When importing coordinates from csv or Excel files, minutes and seconds are also allowed to have a decimal fraction, so for example 49° 11.117' would be an allowed format.All
Importing duplicate crimesSometimes you may wish to import new crime data which overlaps with existing crime data in the database, either because the import file contains some new crimes mixed with old crimes, or because it contains new data for existing crimes. Rigel recognizes duplicate crimes by Crime ID, so if you want the crimes to be recognized as duplicates and not simply imported as new crimes, you must include the correct Crime IDs in the import file.
When Rigel recognizes a duplicate Crime ID in the import file, a prompt pops up asking you how you want to handle it. You may choose to keep the database version, replace the database version with the new import, make the import a new crime with a different crime ID, or Smart Merge, where new crime data from the import file is merged with existing data for that crime in the database. You can check the box to automatically repeat the same action for all crimes in the import file.
Importing duplicate casesYou can create a duplicate case with a different Case ID by right-clicking on the case in the All Cases database table and selecting the option "Save case as...". The new case will include the same crimes from the database as the original (not duplicate copies).
You can also create a duplicate case by exporting the case to an xml file and then re-importing it as a new case. When you attempt to import a case that has a duplicate Case ID, a prompt will pop up to tell you that there is a conflict with an existing case in the database. Select the option "Import as new data" and the import will be assigned a new Case ID, appending a sequence number suffix to the existing Case ID.
When it comes to importing the crimes, again a prompt will pop up saying that there is a duplicate crime ID already in the database, and asking what you want to do. Select the "Import as new data" option to import it with a new crime ID and check the box to perform this action for all crimes in the import file. This will create the new case with separate new copies of all the crimes.
Beaches and other boundariesWhen you prepare a geoprofile in a location where there is a hard boundary forming one side of the hunting area, such as a body of water, and the pattern suggests that the offender may live close to the boundary (for example on the waterfront of a seaside town), your profile may have to take into account that the offender is constrained to find targets to one side only. You can do this by mirroring the crimes across the boundary. That is, you add a duplicate of each actual crime site an equal distance on the other side of the boundary, so that a line drawn between the crime site and its mirror site crosses the boundary at a right angle. In the example case of a seaside town, this would cause the profile to center on the town rather than some distance inland.All
Customizing report templatesYou can edit the default Rigel report templates or create new ones. You will find the report template files in the Rigel data directory under Data\Reports\Templates. These are editable files in standard formats such as Word docx, PowerPoint pptx, or html.
The fields that Rigel fills in when you generate a report are indicated by placeholder tags in the text such as R#caseName#R. You will find in the Templates folder the file Report Tag Test Document.docx that describes all of the available tags.
The standard default report template is Default.docx. If you select a different report template when generating a report in Rigel, that is remembered as the new default template choice. You can edit the default template docx file without changing the name if you wish, but it is recommended that you copy it to a new file name and edit that in order to preserve the original for reference.
Of course you can always edit the report file after it has been generated if you just want to make a change that is unique for the current case.
Annotating mapsIn Rigel you can draw annotations on the map to illustrate features of the case. Rigel provides access to the built-in drawing capabilities of the specific map service you are using (e.g., Google Maps, MapPoint, ArcGIS ...), so the capabilities will differ depending on which service you are using. With ArcGIS you can edit the base map independently in the ArcMap editor. while MapPoint provides a built-in drawing toolbar, and map modifications made in Rigel are saved as a ptm file with the case. Version 2.3 of Rigel adds new drawing tools to the Google Maps toolbar (polyline, circle, rectangle, polygon, color picker) to let you annotate the map, but the annotations can only be saved by map image capture.All
Custom map symbolsRigel has a Symbology Manager where you can create and edit your own custom symbol sets for crimes. You can assign symbols to correspond to any crime database criteria. For example you can assign custom map symbols for different crime types. A built-in example is the Day-of-Week symbol set, which assigns different symbols to crimes based on the day of the week on which they occurred. The Symbology Manager can be found under Database on the main menu.
To apply a custom symbology to your crimes, select the Crimes layer in the map layers manager, and choose the Symbology from the dropdown list in the layer properties at the bottom of the layers manager window.
To add additional symbols beyond those built in to Rigel, add your own icon image files to the folder ProgramData\ECRI\Images\pushpins
Crime ID versus Crime NumberRigel assigns a unique alphanumeric Crime ID to each crime to identify it in the crime database. It may correspond to your agency's incident record ID, or you can allow Rigel to assign it automatically on import or creation. No two crimes can have the same ID, even in different cases.
When working within a case you may wish to refer to the crimes in a simpler way, usually by a crime number 1 to n. Rigel also allows crimes to have a Crime Number which applies only within that one case. You can renumber the crimes within the case at any time (menu function Data > Crimes > Renumber crimes). If you prefer to hide the Crime ID and work with Crime Number within a case, go to Tools > Preferences > Element IDs, and un-check the option "Show Element IDs".
State Planar CoordinatesRigel supports the use of State Planar coordinates for locations within the United States, as these coordinates are frequently used by state maps and records systems. When importing State Planar coordinates, you must be sure to assign the fields correctly in the Import dialog box. You must identify the SPC Zone field, or else Rigel will assume that a field labeled "Zone" is a UTM zone. You must also correctly select Feet or Meters as the SPC units. If your crimes show up in the wrong place on the map after import, then you have not selected these fields correctly during import, and you should delete the import data set and try again.All
Database BackupsRigel can make a complete database backup on demand (Tools > Backup Database). You can assign your own name and description to such backups, which will appear in the Restore list. The database backup includes all of your crime and suspect data for all cases, your database lists, and many of the case settings and options.
You can restore a previous backup by selecting Tools > Restore Database, and selecting the specific backup you want to restore.
Rigel makes an automatic database backup on startup, and whenever you perform a major operation that affects a lot of data. These backups can be viewed by opening Restore Database and selecting the Automatic Backups option at the top of the list. If you get into trouble, you can use these automatic backups to restore your database to an earlier state.
Database backups are saved as .bak files in the folder ProgramData\ECRI\Data\DBBackups. You can archive them offline, move them to another system to move your Rigel installation, or send them to another Rigel user.
For more information, see "Database Backups" in the Rigel Help file.
Where is my data?Most of your data is stored in the Rigel SQL Server database. By default the database is stored locally on your computer, but it can be on a network database server if you have set it up that way in the Database Connection settings under Tools > Preferences > Database. The database is unique to your Windows user profile, so if Rigel is installed for multiple Windows accounts on a computer, each Windows user would have their own separate Rigel database.
You can back up the database contents to a local file (see the above topic), or restore it from a previous backup file. You can also create a new empty database and give it a new name in the Rigel database settings any time you want to start fresh.
Some Rigel data is not stored in the database, generally based on two principles:
- You should be able to open another user's Rigel database without overriding your personal preferences;
- Large image files should not be stored in the database to keep the size down.
Specifically the following types of data are not stored in the Rigel database:
- Some program settings are stored in the Windows registry, such as data format preferences.
- User names and passwords are part of the program installation files.
- Report image files are stored in the data directory under the individual case folder in ProgramData\ECRI\Data\CaseFiles
- Custom screen layouts for each case are also stored in the individual case folder in ProgramData\ECRI\Data\CaseFiles
- Custom symbol sets are stored under ProgramData\ECRI\Images\
Therefore if you restore a Rigel database on another computer and then open the case files, you may find that the layouts are different, the report images are missing, and custom symbols are replaced by generic symbols if you have not also copied those items separately.
Lost passwordIf you lose or forget your Rigel password, the easiest way to recover is to simply re-install the program if you have your original license information. You won't lose any data by re-installing - it's equivalent to installing a software update.
If you don't have your original software license information, contact ECRI to obtain it.
Auto-saved import queryWhen you import a new set of crimes or suspects, Rigel automatically creates a Query matching that data set. If you subsequently want to view or delete the data you imported, open a Search dialog, select Load Query, and find the Query corresponding to the data set you imported.All