keeping track of pbx extensions

[Henry Cabot Henhouse III]

Hi...

I maintain 4 switches (shared tenant) in 4 buildings, and have about 1600
did numbers to keep track of. Companies are always coming and going.

Can anyone suggest a simple database (other than fumbling around with
Access) that will let me keep track of things/sort on a per extension (4
digit), per company, per building basis, date history of when installed,
disconnected, notes as to the line equipment, house pair, etc. Windows
based, of course.

Thanks in advance!
Dave

[T]

Post by Henry Cabot Henhouse III
Hi...
I maintain 4 switches (shared tenant) in 4 buildings, and have about 1600
did numbers to keep track of. Companies are always coming and going.
Can anyone suggest a simple database (other than fumbling around with
Access) that will let me keep track of things/sort on a per extension (4
digit), per company, per building basis, date history of when installed,
disconnected, notes as to the line equipment, house pair, etc. Windows
based, of course.
Thanks in advance!
Dave

Well - since you're so dead set against Access you're going to have to
use open source.

The database should be built in MySQL (Runs on Windwos, Linux, etc.)

If you want to make it truly accesible and portable you'll need to learn
PHP and then build an apache web server being certain to compile it with
PHP support.

But then you could do an Access db. The beauty of Access is that the
data doesn't necessarily have to live in Access. You can link tables
from things like MySQL using their ODBC connector. The other beautiful
thing about Access is there are several ways to do things. One can be
table/query/macro based, the other can use table/query/VBA (My prefered
method)

If you need help with any of the above contact me.

[Eugene Blanchard]

MS Works has a simple database program that is easy to setup and is pretty
much point and click. I've taught people in 15 min and then they were up
and making there own database.

Post by Henry Cabot Henhouse III
Hi...
I maintain 4 switches (shared tenant) in 4 buildings, and have about 1600
did numbers to keep track of. Companies are always coming and going.
Can anyone suggest a simple database (other than fumbling around with
Access) that will let me keep track of things/sort on a per extension (4
digit), per company, per building basis, date history of when installed,
disconnected, notes as to the line equipment, house pair, etc. Windows
based, of course.
Thanks in advance!
Dave

[T]

Post by Eugene Blanchard
MS Works has a simple database program that is easy to setup and is pretty
much point and click. I've taught people in 15 min and then they were up
and making there own database.

It does? First I've ever heard of it but then I've always used Office at
some point or another.

Access is also very simple if you first plan out your data.

For what he actually seems to want, Excel would be more than capable but
using a relational database would enable him to expand in the future.

As I said, I'll help any way I can.

Post by Eugene Blanchard

Post by Henry Cabot Henhouse III
Hi...
I maintain 4 switches (shared tenant) in 4 buildings, and have about 1600
did numbers to keep track of. Companies are always coming and going.
Can anyone suggest a simple database (other than fumbling around with
Access) that will let me keep track of things/sort on a per extension (4
digit), per company, per building basis, date history of when installed,
disconnected, notes as to the line equipment, house pair, etc. Windows
based, of course.
Thanks in advance!
Dave

[Ted]

With the amount of DID's, he would be better off with access than excel.
While there are some things that require a good amount of knowledge in
access, by planning it first, taking his time and a little reading first, he
should be able to do this in access by using the wizards.

Ted

Post by T

Post by Eugene Blanchard
MS Works has a simple database program that is easy to setup and is pretty
much point and click. I've taught people in 15 min and then they were up
and making there own database.

It does? First I've ever heard of it but then I've always used Office at
some point or another.
Access is also very simple if you first plan out your data.
For what he actually seems to want, Excel would be more than capable but
using a relational database would enable him to expand in the future.
As I said, I'll help any way I can.

Post by Eugene Blanchard

Post by Henry Cabot Henhouse III
Hi...
I maintain 4 switches (shared tenant) in 4 buildings, and have about 1600
did numbers to keep track of. Companies are always coming and going.
Can anyone suggest a simple database (other than fumbling around with
Access) that will let me keep track of things/sort on a per extension (4
digit), per company, per building basis, date history of when installed,
disconnected, notes as to the line equipment, house pair, etc. Windows
based, of course.
Thanks in advance!
Dave