Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length

 
Advanced search

2505 Posts in 648 Topics- by 1314 Members - Latest Member: Saudi Arabia

eTicket CommunityGeneralGeneral Discussion (Moderators: jason, Hummdis)Topic: Incremental Ticket Numbers
Pages: [1]   Go Down
Print
Author Topic: Incremental Ticket Numbers  (Read 2187 times)
0 Members and 1 Guest are viewing this topic.
alexbevi
New Member
*

Karma: +0/-0
Offline Offline

Posts: 3


« on: January 02, 2009, 03:12:22 AM »

Is there a way to change the ticket numbering to be incremental? I seem to remember this was available in OSTicket, but I can't seem to find it in eTicket.
Logged
Hummdis
Moderator
Super Member
*****

Karma: +13/-0
Offline Offline

Posts: 558



WWW
« Reply #1 on: January 02, 2009, 06:22:43 AM »

It's not available via the interface with eTicket, but you can modify the MySQL DB to be incremental. (I believe)

You should also post this in the feature request section so that it can be added to 2.0 if possible or has not been added already.
Logged

Don't PM me directly for help.  Post to the forums, that's what they are for after all.  PM's to me that request help will be ignored.

Hummdis Communications - Freelance Website Design & IT Consulting
alexbevi
New Member
*

Karma: +0/-0
Offline Offline

Posts: 3


« Reply #2 on: January 05, 2009, 09:49:28 AM »

It appears that the code from osticket to eticket is drastically different in some places Tongue The sequential ID support from osticket wasn't very well written (not me knocking the developers, just relaying what they wrote in the code), so it appears to have been completely dropped in eTicket.

The code appears to be in /inc/class.ticket.php:188

Code:
function get_ticket() {
    do {
        mt_srand((double)microtime() *1000000);
        $min = 100000;
        $max = 999999;
        $id = mt_rand($min, $max);
    }
    while (ValidID($id));
    return $id;
}
function ValidID($id) {
    global $db_table;
    $id = preg_replace('/\D+/', '', $id); //sanitise
    if (!empty($id)) {
        $res = mysql_query("SELECT ID FROM " . $db_table['tickets'] . " WHERE ID=" . $id);
        if ($res) {
            if ($array = mysql_fetch_assoc($res)) {
                return $array['ID'];
            }
        }
    }
}

I'm going to write my own id generator (since my company wants something more specific than just incremental or random), but if anyone wants to fart around with custom ID generation, this is the place to start Wink
« Last Edit: January 05, 2009, 09:52:47 AM by alexbevi » Logged
Hummdis
Moderator
Super Member
*****

Karma: +13/-0
Offline Offline

Posts: 558



WWW
« Reply #3 on: January 08, 2009, 10:08:11 AM »

I personally like the random side.  This way, customers have no idea just how many support tickets are created between their tickets.

If I open a ticket and get 100256 on 01/06/2009, then open a new ticket on 03/15/2009 and the ID is 100302, then I know that there have been 46 tickets opened by other people since my last ticket.

For smaller support departments, this could be bad if you are trying to appear larger than you really are. Smiley

Just my 2 cents.
Logged

Don't PM me directly for help.  Post to the forums, that's what they are for after all.  PM's to me that request help will be ignored.

Hummdis Communications - Freelance Website Design & IT Consulting
Ati
New Member
*

Karma: +0/-0
Offline Offline

Posts: 4


« Reply #4 on: January 10, 2009, 12:19:58 AM »

You could create ticket numbers with the DATE in them.

Such as [20090110-0001]

This way they only know how many tickets have been opened vefore them on that particular day.

Some people may not like this either.

But personally, if I got assigned a ticket number such as 676523, I would have a feeling that something is terribly wrong with that company... So many problems, oh my god, it may be best to just leave them. (Ie: I have no idea the ticket number is random, I migh think I'm the 676523th person to complain.)

I have the date-version working just fine on my site, but that's with an older version of eticket, not the current.
Logged
GeekDoc
New Member
*

Karma: +1/-0
Offline Offline

Posts: 3



« Reply #5 on: January 10, 2009, 10:23:15 AM »

You could create ticket numbers with the DATE in them.

Such as [20090110-0001]

This way they only know how many tickets have been opened vefore them on that particular day.


I like that idea.  If it's not in v2, then I may have to modify it for my install (I'll share, of course).
« Last Edit: January 10, 2009, 11:38:23 AM by GeekDoc » Logged
Hummdis
Moderator
Super Member
*****

Karma: +13/-0
Offline Offline

Posts: 558



WWW
« Reply #6 on: January 13, 2009, 08:51:52 AM »

You could create ticket numbers with the DATE in them.

Such as [20090110-0001]

This way they only know how many tickets have been opened vefore them on that particular day.

Some people may not like this either.

But personally, if I got assigned a ticket number such as 676523, I would have a feeling that something is terribly wrong with that company... So many problems, oh my god, it may be best to just leave them. (Ie: I have no idea the ticket number is random, I migh think I'm the 676523th person to complain.)

I have the date-version working just fine on my site, but that's with an older version of eticket, not the current.

Additionally, you could remove the hyphen so that it's not so obvious that it's the date that's there...this could hide the number of tickets created.

It's just that we've had users complain when we did use an incremental ticket system about how they know that they had ticket #6 of the day and are upset because they didn't get a response in 20 minutes or some other insanely stupid short time frame for an answer.
Logged

Don't PM me directly for help.  Post to the forums, that's what they are for after all.  PM's to me that request help will be ignored.

Hummdis Communications - Freelance Website Design & IT Consulting
eTicket Community
   

 Logged
Pages: [1]   Go Up
Print
eTicket CommunityGeneralGeneral Discussion (Moderators: jason, Hummdis)Topic: Incremental Ticket Numbers
Jump to: