Jpegger Export CSV has columns out of sequence for FDLE, Police Report, OHDPS, etc.
Some versions of jpegger have the VIN and TagNbr columns out of sequence in the images_data table. Those columns should appear at the end of the field list and not at the beginning. There are two ways to resolve the issue.
1. Upgrade to the latest jpegger.
2. Rearrange the columns.
To rearrange the columns, edit the jpeggerschema.txt file which is in the c:\program files (x86)\jpegger\data folder. Locate the table images_data. If the field definitions for the VIN and TagNbr are the first in the list, cut them and paste them at the end of the field list for this table. The first field definition for the images_data table should be capture_seq_nbr. Save the file.
In SQL Management Studio, find those columns in the Images_data table and delete them. It is okay, we don't use them in Scrap Dragon.
Restart the jpegger service. This should rearrange the columns and resolve the problem with the jpegger Export command.
Related Articles
How to create a suspect list for Jpegger
The suspect list is one of the most powerful tools available for reviewing images in Jpegger. The suspect list is a CSV formatted list that can be generated from any source. It must have at least two fields and the first field must be the ticket ...
Unresolved BI report file names
When running a BI report you may get a message 'Unable to resolve file name' with a specific file name specified. Some of the shipping report files are not included and need to be added to the Stand Alone Report Server. A zip file of known shipping ...
Formatting Receipts, Reports, and Forms
User Menu - Edit Reports Copy the existing Receipt, Report, From, etc. that you will want to update. Edit Report option appears when selecting the newly created file Edit Report launches the Telerik application for updating the newly created form ...
UPLOADING THE TEXAS DPS REPORT
To export the report: User Menu > Export – Texas DPS Report. Fill out your Certificate ID Specify the date range for the report. Because the entire file will be rejected if any data is invalid, we recommend doing just one day at a time. Note where ...
Setting up Cameras/Devices in JPEGger
After logging into JPEGger click on the "CAMERAS" button. Click on "New" Fill out "Camera Name", "Device Name", and "Camera Type". -Choose the yard location from the dropdown menu. Even if the yard only has one location, or it will not show in Scrap ...