At my work we have a couple of big mechanical machines running, which needs regular maintenance. Now all incidents, repairs etc. are recorded by hand, but we would like to start recording this digitally.

So we want to create a database-system that contains all the parts in our machines, their location in the machines, track history of repairs, component lifetime, schedule regular maintenance etc. And we would like this system to be smart, so for example if you look at a certain component, blocks on the page will automatically contain relevant links and content ( like history of component, pending jobs on component, links to parent component and similar components etc. ). The system should also announce if a pending job is nearing it's deadline.

Would Drupal be a good tool for doing this? I could program a system like this with mySQL and PHP, but Drupal is very appealing. Maybe there even is a module in Drupal created for making this kind of systems?

So should I use Drupal for this? Any tips or ideas would be greatly appreciated!

Cheers,
Daniel

Comments

VM’s picture

yes. you can do what you are asking with Drupal.

There is no one module that will do all of what you are looking for.

you will need to set up content types and views (views.module) to generate your lists of data (history, joblist, jobs per machine, status .. etc.)

dwinsvol’s picture

Thanks VM, then I will start working with Drupal. New to this program, so need to start with the basics. Any other module then Views that might come in handy?

glanster’s picture

I´m about to start a similar project. How was your experience so far?

bhatmahesht’s picture

Drupal is not just a CMS it's also like a framework for web applications
Considering your project you can use the combination of cck for storing and views for presenting it. Integrate the new module views to use the full power of Drupal.

--
Passionate about Drupal

Makedon’s picture

Was searching for similar, worth to try