What do I need to learn???

[big_tiger]

What do I need to learn to create a website that lets people login, set up appointments, and the site automatically round robins it to a tech in there area (maybe send a fax as well). Then the tech can confirm the appointment and tell the customer everything is ready to go. The database would need to hold at least 5000 techs and 10000 customers.

Doesn't need to be fancy looking, just easy to use, make appointments, and easy to upload a Access database to the new one. :)

[Stang2be]

hire a web developer. I don't think reading teach yourself html in 21 days is gonna cover that :)

[Viper]

Ask Jared. I hear he has mad skillz.

[big_tiger]

hire a web developer. I don't think reading teach yourself html in 21 days is gonna cover that :)

I know a little, and time isnt a concern. I am a certified Webmaster apprentice. (4 years ago, lol).

[Hunt4m3x]

pm AbecX.

[big_tiger]

PM sent

[Skidmark]

What do I need to learn to create a website that lets people login, set up appointments, and the site automatically round robins it to a tech in there area (maybe send a fax as well). Then the tech can confirm the appointment and tell the customer everything is ready to go. The database would need to hold at least 5000 techs and 10000 customers.

Doesn't need to be fancy looking, just easy to use, make appointments, and easy to upload a Access database to the new one. :)

PM usmcluke as well.

[big_tiger]

^done

[big_tiger]

Still waiting on PMs back, anyone else?

[Hunt4m3x]

pm hunt4m3x. i heard he is good at that shit.

[usmcluke]

What do I need to learn to create a website that lets people login, set up appointments, and the site automatically round robins it to a tech in there area (maybe send a fax as well). Then the tech can confirm the appointment and tell the customer everything is ready to go. The database would need to hold at least 5000 techs and 10000 customers.

Doesn't need to be fancy looking, just easy to use, make appointments, and easy to upload a Access database to the new one. :)
This isn't by any means "hard" for someone with experience but for a beginner to build something on this level will be a challenge. I will give you a few pointers based on what I have read.

1. Forget Access. You need a true database to handle the amount of data you are talking about. MySql or SQL....pick your poison.

2. There aren't really any out of the box web-apps that are going to accomplish this for you. You have two options for a jumping off point:
A. A CMS such as DotNetNuke (DNN), Mambo, Drupal, etc. (Google Content management system).
B. A free trouble ticket system such as OTRS, trouble ticket express, etc. Getting all your customer data and tech data in there is going to time consuming unless you already have a database with that info and you are good with SQL commands.

Let me know if you have any other questions.

[big_tiger]

This isn't by any means "hard" for someone with experience but for a beginner to build something on this level will be a challenge. I will give you a few pointers based on what I have read.

1. Forget Access. You need a true database to handle the amount of data you are talking about. MySql or SQL....pick your poison.

2. There aren't really any out of the box web-apps that are going to accomplish this for you. You have two options for a jumping off point:
A. A CMS such as DotNetNuke (DNN), Mambo, Drupal, etc. (Google Content management system).
B. A free trouble ticket system such as OTRS, trouble ticket express, etc. Getting all your customer data and tech data in there is going to time consuming unless you already have a database with that info and you are good with SQL commands.

Let me know if you have any other questions.

1. I was going to convert the Access database to Mysql. I was just saying hopefully it is an easy convert.
2. I really see where you are going with the OTRS. It is a bitch to install anything on my computer at home (Ubuntu 8.10), so I need to find something different. Completely different story though. :rolleyes:
With the look of OTRS, I don't need to change much to make it match what I want to do with it. I just need learn how to change it. :o