Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

[CONTRIBUTION] osC Helpdesk v1.0


Snowman

Recommended Posts

I got a question:

 

For checking the status of a ticket, what is it what I have to write for the 'name' field? Email address? Person name? What is it? Because whatever I try I always get an error that the ticket doesn't match with the username?

 

-------------------------------------

I'm now able to send a ticket and see it on admin section. Close it and everything.

In a trial, I try to see the status of a ticket by clicking on check status. However, I receive an error.

 

I was checking the help_status.php file and it looks like if name field for status respond to $name? am I right? But what is it response to? Whatever I try it doesn't work! I believe it should respond to email address of the customer. That will makes it easier I guess.

 

Thanks,

 

Brian

Link to comment
Share on other sites

  • Replies 58
  • Created
  • Last Reply

Top Posters In This Topic

Some more features would be very useful like:

 

Adding the name, email and ticket number of the user to the email notification would be great if not that then:

 

The user's account - email, name and ticket number.

 

Ticket activity email notifications. On hold, re oped and complete ticket notifications.

 

Also, being able to delete a ticket.

 

Last one if possible is fixing the constant re-login issue when you use the HelpDesk links in the left collum.

Maybe a login and out feature would fix this.

Link to comment
Share on other sites

  • 3 weeks later...

I got the helpdesk to work to a point, but I know I am supposed to do something to the MySQL database, but i cant figure out what, anyone help me on this?

 

thanks

Link to comment
Share on other sites

Would anyone mind telling me why customers continue to receive Notification emails (from Helpdesk) that do not include the entire URL?

The URL's are missing the http://www.mycompany.com

See sample below...

_______________________________________

Your request for support has been completed.

Your ticket number is: 1

 

To view the solution to your request, please go to:

/helpdesk_status.php

_________________________________________

 

Any thoughts on what is causing this? I have put on the configure.php files the location of the http and https servers to http://www.mycompany.com

 

I am stumped. Cannot find a thread on this issue.

Jared Geesey

Link to comment
Share on other sites

  • 3 weeks later...

Here is the sql file for Help Desk. This works for me.

 

DROP TABLE IF EXISTS helpdesk;

CREATE TABLE helpdesk (ticket_id int(255) UNSIGNED NOT NULL AUTO_INCREMENT, name VARCHAR(255) NOT NULL, email TEXT NOT NULL, problem TEXT NOT NULL, solution TEXT NOT NULL, status TEXT NOT NULL, date TEXT NOT NULL, priority TEXT NOT NULL, PRIMARY KEY (ticket_id));

 

DROP TABLE IF EXISTS helpdesk_members;

CREATE TABLE helpdesk_members (

? ?username VARCHAR(255) NOT NULL,

? ?password TEXT NOT NULL,

? ?email TEXT NOT NULL,

? ?signature TEXT NOT NULL,

? ?PRIMARY KEY (username)

);

INSERT INTO helpdesk_members VALUES ('admin','password','[email protected]','Your Name<BR>Technical Support<BR>http://www.yourstore.com');

 

INSERT INTO configuration VALUES ('', 'Support Email Address', 'SUPPORT_EMAIL_ADDRESS', '[email protected]', 'Support email address', 1, '99', '', '', NULL, NULL);

Jared Geesey

Link to comment
Share on other sites

  • 2 weeks later...

ive read through the thread very extensively but manage to find no solution to my problem

 

im experiencing the same probs as the other guys here

 

click on the link and nothing appears

 

i did as cc said but in my account.php there is this line

$breadcrumb->add(NAVBAR_TITLE, tep_href_link(FILENAME_ACCOUNT, '', 'SSL'));

 

which is not at all same with the suggestions given

pls advise me through

Link to comment
Share on other sites

ok guys problem fixed

 

patience as the ancients said is a great virtue

 

im experiencing a small problem now

the labels all appear as this

 

TEXT_NAME

TEXT_EMAIL

TEXT_PROBLEM

TEXT_PRIORITY

 

any hints???

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...