Search: Advanced search
Please enter a keyword or ID
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.