- Here are the steps to follow to Install this Customer
1. I configured Apache to treat a .pl file as executable perl scritp in
- My Postresql is the normal basic installation and you can
use the /custom/sql/custrack.sql
and sesscts.sql to get an idea of how i created a table 'custrack' and
'sesscts' with user as 'apache'.
- If you don't know how to go about creating the database,
use the custrack.bsh to create one for you, but remember you must login
in as postgres user and have custrack.bsh, custrack.sql and sesscts.sql
in the same directory.
- You would have to update the sections mentioned below in
csrtrack.pl, custrack.pl, getcsrpasswd.pl, getcuspasswd.pl pl_order.pl,
register.pl and SESS.pm
- Update between '##### Config Start' and '#### Config
End' section in all .pl and SESS.pm files to match your Web and
- Edit the all the .pl and SESS.pm files and make sure
the www.coreunix.com is properly replaced with your www.domainname.com
- Update between '##### Config Start' and '#### Config
End' section in custmail.prl to contain the correct path to the
- Edit the .pl files and make sure the coreunix.com is
properly replaced with your local Web ROOT Directory e.g. htdocs or html
- Make sure in all the .pl files 'DB', 'DBAUTH' and
$DB_TABLE match with the correct databaes and user as mentioned in
- Make sure 'use lib' in all .pl files files point to
the directory where SESS.pm resides.
- Make sure you edit the sessdel shell script and
executed using a cron job, otherwise your users will be able to login
after two hours of inactivity and also the sesscts table will get
overloaded with unneccessary session ids.
- Put the CSRs E-mail ids and their login passwords in
password.tech file so as to allow them
to view all the customers submitted records, the CSR is the person
replying to customers
Customer Tracking System1.2
This Customer Tracking System(CTS) has been running on my
Apache/Postgres, Windows-Cygwin workstation, as well as my Redhat 7.x
Basically the Customer Tracking System is a software, where customer
submit there requests
and a Customer Service Representative respond to the customer requests
by use of the CSR
There is a emailing notification which uses the sendmail program to
send E-mail notifications
to both the Customer and CSR upon updation of the tickets/request forms.
This is a pretty straight forward install, i.e. if you have an idea of
Apache and Postgres.
The Directory Structure is as below:
########## How to use the CTS Software #########
| |___ COPYING
--> This is the GPL license on CTS1.2
| |___ license.doc
--> This is the license on CTS1.2
| |___ SESS.pm
--> This is a Perl Shared Module
| |___ showcsr.pl
--> This is the Customer Service Representative(CSR) tracking script.
| |___ showcus.pl
--> This is the Customer requests view script.
| |___ custmail.prl
--> This is the e-mail sender script.
csrpasswd.pl --> This is the (CSR) password retrieve script.
cuspasswd.pl --> This is the Customer password retrieve script.
submitinfo.pl --> This is the Request form submission script.
| |___ signup.pl
--> This is the User Register/Sign up script.
| |___ usercnt.fl
--> This is the track of count of Users Registered in a day.
password.tech --> This is where you enter the entries "email passwd"
so CSRs can view all the Users records.
|___ contcards --> This is where all the new Requests Submitted, go
| |___ .htaccess
--> This is htaccess Apache Authorization file.
| |___ .htpasswd
--> This is the htpasswd file to the htaccess file.
| |___ sessdel
--> This is a shell script that is run by cron to clear
| sesscts table every hour.
| |___ biggreen.png
| |___ bigred.png
| |___ cal.gif
| |___ dotgreen.png
| |___ dotred.png
| |___ next.gif
| |___ prev.gif
| |___ spacer1.gif
| |___ spacer.gif
custrack.bsh --> This is a shell script to execute both below .sql
custrack.sql --> This is to create the CUSCTS Database with custrack
table in it.
| |___ sesscts.sql
--> This is to create the sesscts table.
|___ README --> This is the installation instructions file
|___ index.html --> The main page.
|___ showcus.html --> To show the Customer login page.
|___ showcus_none.html --> To show the Customer failure messages.
|___ showcsr.html --> To show the Customer Service
Representative(CSR) login page.
|___ showcsr_none.html --> To show the Customer Service
Representative(CSR) failure messages.
|___ cuspasswd.html --> To show the Customer password retrieve page.
|___ cuspasswd_got.html --> To show the Customer success message.
|___ cuspasswd_none.html --> To show the Customer failure message.
|___ csrpasswd.html --> To show the Customer Service
Representative(CSR) password retrieve page.
|___ csrpasswd_got.html --> To show the Customer Service
Representative(CSR) success message.
|___ csrpasswd_none.html --> To show the Customer Service
Representative(CSR) failure message.
|___ signup.html --> To show the Customer Registration/Signup page.
|___ signup_got.html --> To show the Customer Registration/Signup
|___ submitinfo.html --> To show the Customr Request Submission page.
|___ submitinfo_got.html --> To show the Customr Request Submission
- Customer Side Login and Viewing his Submitted requests:
The customer first registers/signs up by using the link "Sign Up" on
the menu bar. Then he submits a Request Form at the link "Get Support"
on the menu bar, where he uses his "User ID" and "Password" he used to
The customer can then view all submitted requests after he gets an
email from the CTS System when his request form has been update by a
Customer Service Representive(CSR). The customer logins at the link
"Customer-Login" on the menu bar. The customer can also request for his
password, if forgotten by using the link "Forgot Your User ID/PassWord
- Customer Service Representative(CSR) Login and Viewing
Customers Submitted requests:
The CSR is registered my manually entering his E-mail id and password
in the file /custom/cgi-bin/password.tech on a single line seperated by
spaces. Then the CSR logins in at the link "Login as CSR" provided on
the home page, using his Email-id and password as mentioned in the
password.tech file. The CTS System sends an email to Email-id mentioned
in the pl_order.pl file as below: my $TOMAIL = 'email@example.com';
when a customer submits a request from, then the CSR can login at the
link "Login in as CSR" on the Main web page to view the all the latest
submit requests. The CSR can even sort the customers' requests by Date,
Customer, ticket Status or by CSR(Agent). The CSR can also limit the
number of records to view in the CSR panel by setting the value
in the file /custom/cgi-bin/csrtrack.pl as show below: i.e 500 lines.
use constant SHOWNO => 500;
############# Trouble Shooting #############
- The common problems that arise are your files SESS.pl,
password.tech and usercnt.fl
are not found or do not have proper read write permissions.
Make sure that their relative paths are mentioned in all the .pl files
that use them.
- Make sure that the Database permission and database
information is properly mention
in the .pl and SESS.pm files.
############## Support #################
firstname.lastname@example.org --> make sure you don't ask for support after
major changes to your
Suggestion: Make sure you have Apache cgi and Postgres working before
questions. I have a life to ;-)
related to the searched query.