Adding a New Field to tickets: Page 2

Adding a New Field to tickets

oriecat

Hi, I just installed osticket and did this mod and it seems to work great. One thing I would like to do is also add the new field to the table view of tickets in the admin panel. Is that something that could be easily done?

blorenzo

resolved

I have found the issue and resolved it. Thank you for your willingness to help.

I think I should have no more problems adding fields. I've added a total of 3 so far. There are a few more mods I would like to make however, I shall search the forum for the answer.

Any idea how to import emails from a csv file to the MySQL DB so when we take a service call we can begin typing their email and then their name appears?

micro3d

Hi, I just installed osticket and did this mod and it seems to work great. One thing I would like to do is also add the new field to the table view of tickets in the admin panel. Is that something that could be easily done?

While there isn't a "blank template" MOD for displaying new fields into the SCP Ticket View, you might be able to derive some code from the following mods that add new columns to the view. I have not inspected these in depth but would imaging that you would simply need to just change where you are pulling the data from (from your new field in the DB).

Next to respond mod:

http://osticket.com/forums/showthread.php?t=736&highlight=respond(http://osticket.com/forums/showthread.php?t=736&highlight=respond)

Assigned to Who:

http://www.osticket.com/forums/showthread.php?t=1068(http://www.osticket.com/forums/showthread.php?t=1068)

micro3d

I have found the issue and resolved it. Thank you for your willingness to help.
I think I should have no more problems adding fields. I've added a total of 3 so far. There are a few more mods I would like to make however, I shall search the forum for the answer.

What was the fix? It might help someone else.

Any idea how to import emails from a csv file to the MySQL DB so when we take a service call we can begin typing their email and then their name appears?

Importing the contact information into the DB is easy with phpMyAdmin. I think the problem you will run into is you will need to create an AJAX script that will query that list as you change your text box.

AJAX Live Search // Auto Complete

http://www.w3schools.com/php/php_ajax_livesearch.asp(http://www.w3schools.com/php/php_ajax_livesearch.asp)

oriecat

While there isn't a "blank template" MOD for displaying new fields into the SCP Ticket View, you might be able to derive some code from the following mods that add new columns to the view. I have not inspected these in depth but would imaging that you would simply need to just change where you are pulling the data from (from your new field in the DB).

Thank you. I did find that thread later and was able to make the change as shown there. :)

blorenzo

Response

The problem I ran into was actually being caused by my Skype. It did not effect computers that did not have skype installed. Basically if you have used it before it automatically detects phone numbers and converts them to links that you can call by clicking on them. Some how the serial number field I made was conflicting with the phone number field, which caused my computer to make the phone number field vanish. It was quite odd tho because it only effected the fields at certian times. And if you did not enter a phone number or serial the problem would not occure. It was a strange problem, but by repositioning the field (several times) it has gone away.

AJAX Live Search // Auto Complete

http://www.w3schools.com/php/php_ajax_livesearch.asp(http://www.w3schools.com/php/php_ajax_livesearch.asp)

Thanks micro3d, extremly helpfull. I will be using this to do what my bosses want.

I have a new issue, I have been trying to add the Serial field to the ticket.php page and have succedded in creating the collum and row. However it is not pulling up the serial number information from the database. What must I modify/add to make it do so? I usually search for the other fields and copy them and make the modifications needed to make it pull the proper information. In this case I am having difficulty finding that.

EDIT:

I have discovered that if i enter in "name" where i have the serial var, it will pull the names into the colum but not the serial. And when i enter serial into another colum it will not pull it. This leaves me to beleive its a problem with the database. But how come on all other screens (newticket,viewticket,open) it pulls the serial number and displays it. but not on tickets.php? what am i missing??

this is the code i am using.... and it does not work.

<?=Format:($row,22,strpos($row,'@'))?>

but if I enter this

<?=Format:($row,22,strpos($row,'@'))?>

It displays names in the serial colum I made. So the code is grabbing information. And there is information because on other pages it is displaying the serial... this is driving me crazy :(

marius

modded

does n e use osticket for IT support like a computer shop, and have succesfully added fields? and will b willing to send it to me

unix4linux

micro3d,

I followed your instructions perfectly in regards to creating a new field in the ticket system called "Domain Name or Company:"

I edited all the mentioned files in the different locations and added the filed in my database:

mysql> alter table hd_ticket add domain_name varchar(255) after email;

Query OK, 51 rows affected (0.09 sec)

Records: 51 Duplicates: 0 Warnings: 0

mysql> show columns from hd_ticket from my_helpdesk;

+-------------+-----------------------------+------+-----+---------------------+----------------+

+-------------+-----------------------------+------+-----+---------------------+----------------+

| ticketID | int(11) unsigned | NO | MUL | 0 | |

| dept_id | int(10) unsigned | NO | MUL | 1 | |

| priority_id | int(10) unsigned | NO | MUL | 2 | |

| staff_id | int(10) unsigned | NO | MUL | 0 | |

| isoverdue | tinyint(1) unsigned | NO | | 0 | |

| created | datetime | NO | | 0000-00-00 00 | |

| updated | datetime | NO | | 0000-00-00 00 | |

+-------------+-----------------------------+------+-----+---------------------+----------------+

18 rows in set (0.00 sec)

When creating the ticket, you can see the option to enter the info but I have two problems...I don't know how to make it a required field AND once the ticket is created, when viewing the ticket, there is no field in the ticket itself specifying "Domain Name or Company:"

What could I be missing?

unix4linux

Could anyone assist me with this one?

micro3d

Could anyone assist me with this one?

Sorry for the long wait. I try to check these forums as often as I can.

Let me review the problem and I'll post something back.

EDIT:

To Make the field required changed the code you added in this file include\class.ticket.php to

$fields = array('type'=>'text', 'required'=>1, 'error'=>'Provide a location, address, or directions'); //mod080722_new_ticket_field

'required'=>1 being the important part. 1 = required, 0=optional

EDIT:

To view your new field from the ticket itself you need to edit code here:

include\client\viewticket.inc.php for the Client Side

include\staff\viewticket.inc.php for the Staff Side

NEW FIElD:

<?=Format:($ticket->getNEWFIELD())?>

micro3d

I have discovered that if i enter in "name" where i have the serial var, it will pull the names into the colum but not the serial. And when i enter serial into another colum it will not pull it. This leaves me to beleive its a problem with the database. But how come on all other screens (newticket,viewticket,open) it pulls the serial number and displays it. but not on tickets.php? what am i missing??

I have PM'd this user and asked for copies of his/her files. I will post findings.

unix4linux

micro3d

Thanks so much for the help so far. I am close to getting this to work. The only problem now is that when I add

Domain / Company:

<?=Format:($ticket->getdomain_name())?>

....everything AFTER that point won't display on the page. I added it after the getName variable and even tried it after other variables and it won't display the value requested nor anything after. I get a blank page after that point.

Never mind....I added the wrong var name to 'get'....it's working great now...thanks a million :-D

blabley

Works great but...

Hi,

Great mod and works really well, the only issue i have i've changed open.ini.php so that it if the client is logged in it remembers there company details. So I used this as the code;

<tr>

<th width="20%">Company:</th>

<td>

<?if ($thisclient && ($company=$thisclient->getCompany())) {

?>

<input type="hidden" name="company" value="<?=$company?>"><?=$company?>

<?}else {?>

<input type="text" name="company" size="25" value="<?=$info?>">

<?}?>

 <font class="error">* <?=$errors?></font>

</td>

</tr>

but the page then wont load. If i use this (as listed on first post);

<tr>

<th>Company:</th>

<td>

<input type="text" name="company" size="25" value="<?=$info?>">

 <font class="error">* <?=$errors?></font>

</td>

</tr>

it loads fine but i would like to have it remeber the new field

Any ideas please people?

Many thanks in advance,

Brad

efuzone

hello sir its working realy good i have done all things not u know what how do i change drop down menu like there is written suppot, billing like this i want to change it how its possible in Help Topic:

pineapplepete01

MySQL field not getting populated.

Hey guys. Ive got all the code in place as descried in the first post of this topic however its not working. For some reason the MySQL field created is not being populated by the web form. Any ideas why?

Does the file class.client.php need to be edited?

neo.sunny

As a favor, can someone help us with adding that new field to the "tickets.inc.php" page?!?! It would be greatly appreciated. We'd like to be able to see Company in that table as a column where you see the ticket id, date, department, priority etc.

Any news on this?

pewe

neo.sunny - yes, you should add

function getNewvar(){

return($this->Newvar);

}

to your class.client.php

It will work for sure ...

Pete

PvtDeath

What does it mean when i get this error?

* Forum Name Required (type not set)

Triple-Clones

Hi,
Great mod and works really well, the only issue i have i've changed open.ini.php so that it if the client is logged in it remembers there company details. So I used this as the code;
<tr>
<th width="20%">Company:</th>
<td>
<?if ($thisclient && ($company=$thisclient->getCompany())) {
?>
<input type="hidden" name="company" value="<?=$company?>"><?=$company?>
<?}else {?>
<input type="text" name="company" size="25" value="<?=$info?>">
<?}?>
 <font class="error">* <?=$errors?></font>
</td>
</tr>
but the page then wont load. If i use this (as listed on first post);
<tr>
<th>Company:</th>
<td>
<input type="text" name="company" size="25" value="<?=$info?>">
 <font class="error">* <?=$errors?></font>
</td>
</tr>
it loads fine but i would like to have it remeber the new field
Any ideas please people?
Many thanks in advance,
Brad

In include\class.client.php

Working on new var being company change following:

Line 29 add:

var $company;

Line 45 add "company" between "name," and "email"

function lookup($id,$email=''){

$sql='SELECT ticket_id,ticketID,name,company,email FROM '.TICKET_TABLE.' WHERE ticketID='.db_input($id);

if($email){ //don't validate...using whatever is entered.

$sql.=' AND email='.db_input($email);

}

Line 60 add:

$this->company = $row;

Line 84 add:

function getCompany(){

return($this->company);

}

Hope that helps.

Triple-Clones

Email var

FYI

I wanted to use the new field I created in the staff emails so I have just added the following:

\include\class.ticket.php

Line 549:

$body = str_replace("%company", $this->getCompany(),$body);

Line 1015:

$body = str_replace("%company", $ticket->getCompany(),$body);

Now I can %company to my staff email templates

Seems to work for me.

« Previous Page Next Page »