TranAct Knowledgebase
Search:     Advanced search

Jpegger Export CSV has columns out of sequence for FDLE, Police Report, OHDPS, etc.

Article ID: 128
Last updated: 21 Oct, 2016

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.

Article ID: 128
Last updated: 21 Oct, 2016
Revision: 1
Views: 0
Comments: 0
Print Export to PDF Subscribe Email to friend Share Add comment
This article was:   Helpful | Not helpful
Also listed in
folder Software Products -> Scrap Dragon -> Scrap Dragon Buy Side
folder Software Products -> Scrap Dragon -> Scrap Dragon Government Reporting

Prev   Next
OLE ERRORS     Scrap Dragon Xtreme