Statistics Module Issue

Moderator: crythias

Locked
jfreeman2nc
Znuny advanced
Posts: 136
Joined: 04 Oct 2010, 14:14
Znuny Version: 3.0.10; 3.1.4
Location: US, SC
Contact:

Statistics Module Issue

Post by jfreeman2nc »

I ran a report using the statistics module and have found that the ticket number in the report does not match the ticket number in the system. I have to go into the system and search for the ticket by the ticket title, searching by the ticket number in the report always yields no results. Has anyone else encountered this issue?
OTRS 3.1.4
Windows Server 2008 R2
MySQL

OTRS 3.0.10 - soon to be 3.0.12 or 3.1.4
Windows Server 2008 R2
MySQL DB
jfreeman2nc
Znuny advanced
Posts: 136
Joined: 04 Oct 2010, 14:14
Znuny Version: 3.0.10; 3.1.4
Location: US, SC
Contact:

Re: Statistics Module Issue

Post by jfreeman2nc »

I just installed 3.0.10 in a test environment and ran a report from the statistics module. I just ran the report to show the open tickets and it pulled the default welcome ticket. However in the report the ticket number is shown as 2010080210123450, but looking in the actual system the ticket number is 2010080210123456. I obtained these results running the one of the pre-built reports stat# 10001.
OTRS 3.1.4
Windows Server 2008 R2
MySQL

OTRS 3.0.10 - soon to be 3.0.12 or 3.1.4
Windows Server 2008 R2
MySQL DB
jojo
Znuny guru
Posts: 15020
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: Statistics Module Issue

Post by jojo »

import the column as Text not as number in your Excel
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master

Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
Locked