Question
Thread display: Collapse - |
All Answers
Start or search
Create a new discussion
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
Transitioning old file/server CRM solution to new Web-based Application
Basically, we currently have a fairly simple Microsoft Access (2007) database system, into which customer information and updates are added and from which regular reports are generated based on that data.
It is a fairly simple database with only two main tables: a customer info table and a transaction table with a one-to-many relationship between the two. There are other tables but they are mostly lookup tables used by the input forms in order to standardize input values.
The problem is that currently this database is only accessible from one main office location. We have four other branch offices in different locations across the state, and the process in the past has been for those branch offices to fax daily customer updates to the main office where the data is collected and then added to the database.
However, we want to decentralize and modernize this process by moving the data entry and reporting out of the central office and into the individual branch offices instead, allowing each branch to track and manage their own customer data, but we want those offices to share a central database repository between them.
What I'm trying to figure out is how to migrate the currently out-dated system -- which is limited to a single physical location -- to a new, web-based system that can be shared and accessed from these geographically separated offices. I have looked at certain Full-stack CMS solutions like Joomla or Drupal to create this system, but I'm beginning to think going that way might be overkill for what I'm trying to do.
Basically, I need a browser front-end that can be used for data entry from the branch locations, a central data repository (I'm thinking MySQL) where all data is stored, network code to communicate between the two across the internet (probably PHP?), and a reporting functionality that would allow us to run aggregate reports on the data inputted.
We are a fairly small company, and I am the only tech-resource, so I am trying to scope out this project and decide what technologies would be best to use to accomplish it.
Any advice, links I can look at or comments on things I should keep in mind would be greatly appreciated! Thanks in advance --eric