Community Add-Ons

Some small changes to lane's version from 26. Aug 2005. This works with my MS2 installation.

osc_mail2db.php: replaced "osC:" with DEFAULT_HELPDESK_TICKET_PREFIX in ereg

admin/helpdesk.php: replaced tep_array_merge() with array_merge()

admin/includes/boxes/helpdesk.php: fixed menu link

This is a re-packaging of the contribution and all additions since. I also re-did much of the pop3 handling so that it's easier to run as a cron job and easier to figure out what the problem is when things don't work.

PLEASE NOTE: although this is a packaging of the code running successfully on my server, it is UNTESTED and should only be used for experimental purposes. I have not had time to ready this for public use, but several people have asked for it so here it is.

Again, if you are looking for product quality code, this is NOT for you!

Here is the support forum:

http://forums.oscommerce.com/index.php?showtopic=122171

Enjoy!

For those of you who are experiencing problems with the Help Desk not deleting emails from the POP server once they are retrieved, the zipped helpdesk_pop3.php file should do the trick (it worked for me). It simply inserts the command when the emails are being retrieved one by one:
imap_delete($conn, $i);

I have changed nothing else. Full credit remain with the author of this contribution Harald Ponce de Leon and Mario Hebert to which my fix immediately succeeds.

Hope this is helpful to others.

Cheers,
Mike
michaelbc@gmail.com

The original contribution requires that you use a php binary to execute the osc_mail2db.php
script to parse the incoming email into the osCommerce database.

This contribution is a ADDON to the existing contribution and involves the following changes:

* The emails are retrieved through POP3 following a end-user synch request.
* The helpdesk can be configured through the admin side.
- POP3/IMAP/NNTP server
- Protocol specification
- Mailbox name
- Mark emails as seen
- Limit email body to a particular size
- Delete emails from server
- Ticket prefix (no longer limited to osC:
* Password field is added to table in order to connect

I found that the contact_us.php file included with the package did work for me, because i was using a slightly older snapshot from mid November. This file goes in the /catalog directory.

The problem was due to the linking to $breadcrumb, which isnt in the older snapshots.

Further updates include:

* emails being inserted in correct department
* html emails being stored as plain text in the database

This update fixes two errors on the original osc_mail2db.php script.

1) The call to parse_output() should be renamed to osc_parse_mime_decode_output()

Depending on how the incoming email was parsed, a php error would have been generated since parse_output() was not defined as a function

2) In the example displayed incase no arguments were provided, the php binary was added to the recipe.

A helpdesk add-on for osCommerce that has the capability to keep track of communication via emails.

The thread of communication is stored in the database where a ticket number is assigned to a thread.

It is possible to create template responses which can be used when replying to a ticket entry.

Departments are setup to handle different areas of communication (help, sales, information, etc).

[This is a separate work to other helpdesk feature contributions currently available]