Results 1 to 23 of 23
Thread: web based database
Hybrid View
-
09-30-2009, 07:06 PM #1Web Hosting Master
- Join Date
- Sep 2008
- Location
- Sydney Australia
- Posts
- 580
web based database
Hey all,
At work we current have a spreadsheet on a shared drive that is filled out whenever someone takes a call. Needless to say it gets messy. What I want to do is replace it with a web based form that writes all the info to a database that can be searched by an administrator.
How can I go about this? or alternatively are there and programs or scripts that can do this?
-
09-30-2009, 07:37 PM #2How Can I Help You Today?
- Join Date
- Oct 2002
- Location
- Langley, BC
- Posts
- 2,045
I suppose making it your own would be the best approach? That form looks rather simple, a one file php script with MySql database should do the trick.
██ We Have Generated Over 7 Million cPanel Backups Come Dance Together With Us Y'all!
██ Offer Your Own Backup Hosting Service - SiteAutoBackup.Com (Private Label / WHMCS Ready)
██ WebHostingBusinessBook.Com | YouTube.com/WebHostingTutorial | NowOpenOnline.Com
-
09-30-2009, 08:31 PM #3Web Hosting Master
- Join Date
- Sep 2008
- Location
- Sydney Australia
- Posts
- 580
how would I do that? I'm not really much of a code monkey
-
09-30-2009, 09:38 PM #4Web Hosting Guru
- Join Date
- Jan 2004
- Location
- NJ, USA
- Posts
- 288
You could hire someone from this forum and pay them some sort of fee (it wouldn't be much because what you're asking is rather simple). I know that I'd be willing to do this, but this thread isn't about hocking myself out to potential customers.
-
10-01-2009, 02:11 AM #5Junior Guru
- Join Date
- Oct 2008
- Posts
- 184
You can get a few articles here to help you do that.
-
09-30-2009, 09:42 PM #6Retired Moderator
- Join Date
- Feb 2005
- Location
- Australia
- Posts
- 5,849
Even if your needs are simple, it's probably going to be easier and cheaper to use a tiny part of a standard application than to roll your own from scratch. Take a look at some of the groupware packages demoed at opensourcecms.
Chris
"Some problems are so complex that you have to be highly intelligent and well informed just to be undecided about them." - Laurence J. Peter
-
09-30-2009, 10:07 PM #7Web Hosting Master
- Join Date
- Nov 2007
- Location
- Dallas, TX
- Posts
- 9,064
-
10-01-2009, 12:34 AM #8Newbie
- Join Date
- Sep 2009
- Posts
- 15
-
10-01-2009, 02:06 AM #9Web Hosting Master
- Join Date
- Mar 2009
- Posts
- 2,222
Are you sure that's a good idea?
Right now, all the info about all the calls is available to anyone who can view the spreadsheet.
The data can be sorted, so if one of the columns is the caller's name, the info about all the calls from that caller can be seen together.
And information can be cut and pasted from one call into another.
What exactly is the problem you want to solve?
-
10-01-2009, 08:28 AM #10Web Hosting Master
- Join Date
- May 2009
- Posts
- 766
Um...what's NOT the problem? Even if you can successfully manage file-locking so only one person can open the file for writing at a time, what happens when that guy accidentally leaves it open and then goes into a 4-hour meeting? Everyone else is stuck with read-only access?
Web-based solutions can be very elegant, and you have a lot of control over user access and any special functionality you need (such as the copy-and-pasting "advantage" above). At the same time, if you're not a "code monkey" and don't want to hire a programmer, you may find that an access database suits your needs just fine. That will certainly solve your multiple-user issue, and you don't have to go through the rigmarole of hiring/contracting someone.
Especially when you're dealing with client information, you don't want to just get it up on a website without having someone who is well versed in web application security. Your clients will not appreciate it if you accidentally publicize private information. I would not consider this a "DIY" project.
-
10-01-2009, 11:22 AM #11Junior Guru Wannabe
- Join Date
- Jun 2005
- Posts
- 73
It sounds like you may need a Customer relationship management software (search google "crm") I would take a look at sugarcrm
A few other alternatives:
Top 10 Open-Source CRM Solutions
let us know how it goesDorian George
-
10-01-2009, 10:54 PM #12Web Hosting Master
- Join Date
- Mar 2009
- Posts
- 2,222
-
10-02-2009, 11:17 AM #13Web Hosting Master
- Join Date
- May 2009
- Posts
- 766
-
10-02-2009, 12:03 PM #14Web Hosting Master
- Join Date
- Mar 2009
- Posts
- 2,222
-
10-05-2009, 02:17 AM #15Web Hosting Master
- Join Date
- Sep 2008
- Location
- Sydney Australia
- Posts
- 580
sorry for the delay in replying.
the main problems were only one person being able to be in the spreadsheet at once and also the tidyness of it.
I had a look at some of the crm's but they all look to go WAY beyond what we need.
-
10-05-2009, 08:30 AM #16Web Hosting Master
- Join Date
- Mar 2009
- Posts
- 2,222
What do you mean by "tidyness"?
Do the rows in the spreadsheet have any relation to each other, or is each row a distinct entity that can be viewed and updated independently of other rows; is the information about a call contained in a single row?
What kinds of updates do people make to the spreadsheet?
And what else do they use the spreadsheet for? Do you expect the web-based form to provide that function?
What are the searches you want the administrator to be able to carry out? Will that be web-based too?
You can do what you want with a web-based form and database; but how simple it is to do really depends on what you need to achieve.Last edited by tim2718281; 10-05-2009 at 08:41 AM. Reason: corrrected typos
-
10-05-2009, 04:39 AM #17Web Hosting Guru
- Join Date
- Oct 2005
- Posts
- 292
How about Google Docs?
http://docs.google.com
Spreadsheets - easily importable
Shared Access - you just need a Gmail account, and assign access as needed
A custom solution might be an overkill if what you want is just "Shared Spreadsheet".
-
10-05-2009, 08:06 AM #18Web Hosting Master
- Join Date
- May 2009
- Posts
- 766
While google docs is a good solution to the simultaneous access problem, it doesn't help with the "messiness" of the contents, hence my original suggestion to use an Access database.
-
10-05-2009, 10:17 AM #19Disturbed
- Join Date
- Dec 2002
- Location
- Jackson, MI
- Posts
- 1,525
A small custom app might work well for you. I would look around at the employment threads for developers looking for work.
I would think you could probably have a decent app designed for this for ~$500 - $750, maybe less with some of the low prices some offer here.
Good luck.
PS: It may be a good idea to have a server setup with wamp or just a small linux server to run this off with intranet access only, that way you are not risking data breach.
-
10-05-2009, 10:34 AM #20Web Hosting Master
- Join Date
- Nov 2001
- Location
- Vancouver
- Posts
- 2,422
There are many options available to you, depending on whether you are willing to roll up your sleeves or not. Beyond developing an application yourself, or paying someone to do it, another option would be to look at outsourcing the entire thing - host the "application" elsewhere. There are a number of database-builder apps that offer a more familiar spreadsheet interface; depending on your requirements these may be workable.
One example is the well regarded Dabble DB -- http://dabbledb.com/ is quite powerful and you can try it for free (don't use sensitive data for this free view).“Even those who arrange and design shrubberies are under
considerable economic stress at this period in history.”
-
10-05-2009, 02:17 PM #21Web Hosting Master
- Join Date
- Apr 2009
- Location
- Pittsburgh, Pennsylvania
- Posts
- 583
I suggest looking into filemaker pro.. i believe it would help you wonders.. very customizable.
I do understand you said a web-based database, this would work just as well.
Unless your workers are not in the same building and at home.. then it may be difficult, and a web based database would be much better.
-
10-12-2009, 03:53 AM #22WHT Addict
- Join Date
- Apr 2009
- Posts
- 107
I'sugget looking at Google Docs. They have some king of form IMHO.
-
10-13-2009, 12:58 AM #23Web Hosting Master
- Join Date
- Sep 2008
- Location
- Sydney Australia
- Posts
- 580
thanks for the replies,
we've found someone to write something custom.
Similar Threads
-
Web based or offline database needed.
By lochie in forum Employment / Job OffersReplies: 6Last Post: 02-10-2006, 04:41 PM -
Web based Database Software.
By Darman in forum Programming DiscussionReplies: 3Last Post: 06-24-2005, 01:10 PM -
Access Database To Unix Based Scipt
By hekwu in forum Programming DiscussionReplies: 3Last Post: 11-09-2003, 02:46 AM -
Web Based DataBase Script Needed
By BasinWebGURU in forum Employment / Job OffersReplies: 4Last Post: 01-15-2003, 09:31 AM