LinuxQuestions.org
Did you know LQ has a Linux Hardware Compatibility List?
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices

Reply
 
Search this Thread
Old 03-13-2003, 07:34 PM   #1
heathpitts
Member
 
Registered: Feb 2003
Location: Florence, AL
Distribution: Debian
Posts: 157

Rep: Reputation: 30
Service call tracking/billing software


I work at a small computer repair/network troubleshooting company. I recently made the switch to running linux for my desktop at work. I am currently trying to reduce the number of time I have to boot into XP to do things.

What I want is this. We have a small Access database that the technicians use to track service calls by customer, hours worked, parts used, services performed. I want to get rid of this database entirely.

I have another pc running linux that will be designated as a server for the purpose of running this database. I want to find a program (meaning php programming through a web browser) that uses php, mysql, postgre sql, etc.... I want to be able to access the database no matter what operating system we are using whether it be xp, linux or just through a web browser. The web browser would be the best bet probably.

The program does not necessarily have to track accounts receivable or anything like that, it is simply used for us to print out our hours and services as techs and to have a record as to what was performed on a customer's system. This is then printed out for the accounting dept. to make the actual invoice and track AR.

If you know of any pre built databases and php pages that does this, please let me know. If not, could someone point me to a site that would teach me how to write this in PHP and MYSQL so I could create it on my own.

I would really love not to have to boot up into windows.

Thanks,

Last edited by heathpitts; 03-13-2003 at 07:36 PM.
 
Old 03-13-2003, 11:10 PM   #2
Aussie
Senior Member
 
Registered: Sep 2001
Location: Brisvegas, Antipodes
Distribution: Slackware
Posts: 4,590

Rep: Reputation: 56
Do a search on freshmeat, I recall seeing a few projects that seem to be what your looking for.
 
Old 03-13-2003, 11:16 PM   #3
Tinkster
Moderator
 
Registered: Apr 2002
Location: in a fallen world
Distribution: slackware by choice, others too :} ... android.
Posts: 22,986
Blog Entries: 11

Rep: Reputation: 880Reputation: 880Reputation: 880Reputation: 880Reputation: 880Reputation: 880Reputation: 880
I'm not very proficient with Abscess (didn't touch it
in ... 7 years?) but I would imagine you should be
able to just map the tables structures into MySQL
or PostgreSQL and the rest is probably just a little
bit more of programming than in the MS thing.

Cheers,
Tink
 
Old 03-14-2003, 09:00 AM   #4
heathpitts
Member
 
Registered: Feb 2003
Location: Florence, AL
Distribution: Debian
Posts: 157

Original Poster
Rep: Reputation: 30
Thanks!

These links look pretty good. I found one called WebInvoice. It seems to do what I need.

I may still try to write one in php though. I would like to "try" to do one for myself also. Any good PHP programming links or how to do MySQL links?
 
Old 02-12-2009, 04:21 PM   #5
cliffordsfleas
LQ Newbie
 
Registered: Feb 2009
Posts: 2

Rep: Reputation: 0
Quote:
Originally Posted by heathpitts View Post
Any good PHP programming links or how to do MySQL links?
In case anyone else lands here searching for the same - the best starter resource around IMO is Tizag.

http://www.tizag.com/mysqlTutorial/mysqlconnection.php

Under the mysql tutorial section you'd want to know everything from the connect statement on down to the delete statement.

Unfortunately Tizag only demonstrates the most basic best case scenario's. While this is great for quickly showing you the fundamentals it doesn't show the ropes of some of the tricky caveats and pitfalls you're going to find when you need to code a real world application.

For that you'll have to find more specialized php discussion threads specific to what you're trying to do at the time.

Of course there's always an abundance of info available at mysql.org - if you know what you're looking for.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Free billing software roopunix Linux - Networking 5 04-17-2007 09:03 AM
Internet Billing Software Duke of Lions Linux - Software 1 06-16-2006 09:27 AM
acounting and billing software ali_dd15 Linux - Software 0 11-02-2005 05:41 AM
billing & telemanagement software bobothecrock Slackware 0 04-21-2005 08:46 AM
not install cybercafe billing software popula Linux - Software 0 11-22-2004 10:14 PM


All times are GMT -5. The time now is 04:29 PM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration