Adding a New Field to tickets: Page 7

Adding a New Field to tickets

berlinger

Hi sternen

i tried this also, no luck. my problem is to finde all the right "lines" and files to insert this bloody things :-)

berlinger

after many hours solved!

sternen

after many hours solved

:) :) :) :)

Josh_90

My Problem

Hello,

I've installed the osTicket and it works perfectly. I've decided to try and implement this mod and i run into difficulty. I've edited all the files as per the instructions, uploaded them to my webs-server and then the main index page doesn't load, its just blank. I've replaced the 'edited' files with those of a fresh osTicket install one by one and have narrowed the problem down to the support/include/class.ticket.php file. It seems when i edit this file and upload it to the server the webpage doesn't show, if i replace it with the file that came with the osTicket zip file the page loads again. I've attached a copy of the edited class.ticket.php file. I am trying to insert a new field called 'callsign' for your information.

Thanks in advance

Josh

[class.ticket.php file.zip](https://forum.osticket.com/assets/files/migrated/5/226b046e0051616bb18289a1c2ce7c8.zip)

loftinp

Sander

Help

Hi,

I've tried to insert the right code but i'm new to php and mysql.

I edited open.php and the new field shows. I've made a new table in mysql for the field. I've edited the class file but when i make a new ticket it doesn't write the data into the new field in the database. I'm afraid i've made an error changing the class file.

Is there anyone dutch on this forum who can explain to me what to insert and where to insert it ?

Thanks,

Sander

grafcom

Is there anyone dutch on this forum who can explain to me what to insert and where to insert it ?

Sander,

ik zal morgen proberen te reageren op je vraag, het is nu te laat.

Sorry this is in Dutch

grafcom

Sander,

did you receive my PM?

Grafcom

itelligent

Hello,

Just started out with osTicket a week ago, and still trying to integrate it into my website.. I was wondering if someone was able to help me?

I want to add a custom "Company" field to every ticket. Is there a fresh install file somewhere with this mod added I can grab? I have the latest version of osTicket.. not too familiar with it though. If needed, I will be willing to pay as I kind of need this ASAP.

Thanks.

grafcom

Hello,
Just started out with osTicket a week ago, and still trying to integrate it into my website.. I was wondering if someone was able to help me?
I want to add a custom "Company" field to every ticket. Is there a fresh install file somewhere with this mod added I can grab? I have the latest version of osTicket.. not too familiar with it though. If needed, I will be willing to pay as I kind of need this ASAP.
Thanks.

See my PM

Regards Grafcom

mathiask

I don't really get it ... what should I put where?

jkisner

Success in Creating the company field - included fixed files

Hey all,

I have successfully created the company field per the original poster's instructions and was able to get it to add the company field to the staff ticket list. All you have to do is add the column named company to your ost_ticket table.

I currently have a base os ticket install so if you to have a base install the attached files will add this field for you. The zip file has 6 files in it. When you unzip it it should create two directories one is clients the other is staff. One file should be outside these two directories.

This should make it a lot easier for anyone else trying to do this. If you want to see what i did just open the files and do a search for company and you will find my changes. The files go in the following locations:

Loose File

class.ticket.php /include

Client Folder in Zip

open.inc.php /include/client

viewticket.inc.php /include/client

Staff Folder in Zip

newticket.inc.php /include/staff

tickets.inc.php /incllude/staff

viewticket.inc.php /include/staff

I hope this helps everyone out there.

[osticket.zip](https://forum.osticket.com/assets/files/migrated/e/1ab232ea49cf34f133bd20a07c77295.zip)

musa

Hey all,
I have successfully created the company field per the original poster's instructions and was able to get it to add the company field to the staff ticket list. All you have to do is add the column named company to your ost_ticket table.
I currently have a base os ticket install so if you to have a base install the attached files will add this field for you. The zip file has 6 files in it. When you unzip it it should create two directories one is clients the other is staff. One file should be outside these two directories.
This should make it a lot easier for anyone else trying to do this. If you want to see what i did just open the files and do a search for company and you will find my changes. The files go in the following locations:
Loose File
class.ticket.php /include
Client Folder in Zip
open.inc.php /include/client
viewticket.inc.php /include/client
Staff Folder in Zip
newticket.inc.php /include/staff
tickets.inc.php /incllude/staff
viewticket.inc.php /include/staff
I hope this helps everyone out there.
J

Thanks J ...

Your post helped a lot.

Was wondering, would you also be having a solution if one wanted to create a drop down menu?

Thanks in advance.

jkisner

Musa,

How well do you know HTML?

All you would need to do is follow the same instructions but instead of creating an input field just create a select drop down field. Everything should be able the same. Give it a shot and let me know how it goes. If you want to see what all I changed just open the files that I attached here and do a search for company. You'll see the HTML and PHP changes I made. Then you would need to create a column that matches the drop down list name and add it to the mysql queries inside the php files.

dzilla

Now that I added those files, I have DB errors

After adding those files from the .zip file to the specified directories - I now have errors in the osticket logs when I log into the admin area. And I also cannot create a ticket now - it just gives an error when trying to create one.

Here is the error messages from the error log:

Unknown column 'ticket.company' in 'field list'

Any help would be much much appreciated. Thanks!

jkisner

dzilla

It looks like you forgot to add a column with the name company to you ost_ticket database table. Once you do that your errors will go away.

dzilla

Okay thanks for info...

However, I do not know how to edit the database columns. What do I do?

jkisner

I'm going to show you how to add the column from the command line. Make sure you read all the instructions before you do them. Everywhere you see <> you'll need to replace that information with your own.

1. On your server log in to mysql

mysql -u -p

2. You'll know you are logged in to mysql when your prompt changes to mysql>

3. Look up which database you have osticket installed in

show databases;

4. Once you know which one is your osticket databases connect to it.

use ;

5. Now add the company column

alter table ost_ticket add company varchar(50) null;

That should do it. Now all your php files will stop freaking out.

dzilla

Great, Thanks!

Thanks everybody. Problem solved.

djs11

Hi,

I've just followed jkisner mod (thanks) I've also done the column add in the database but i seeing this error in the osTicket logs.

Column 'email' in field list is ambiguous

Could anyone help please?

« Previous Page Next Page »