my profile | my password | search | faq & rules | forum home

» Film-Tech Forum ARCHIVE   » Operations   » Ground Level   » Maintenance databases RFC

Author Topic: Maintenance databases RFC Dominic Espinosa Phenomenal Film Handler Posts: 1172 From: California, U.S.A. Registered: Jan 2004 posted 02-12-2010 08:53 PM                     A little background: At my current employer, maintenance (facilities, projection, etc.) has been accomplished for the last few years by means of a manager filling out a form (excel spreadsheet -- no formulas, just a questionnaire) and faxing it to the head maintenance guy. After I came on board I build a simple database in mysql with a cgi frontend which enabled us to file requests via e-mail, provide transparency between maintenance and administrative personnel and, most importantly, keep track of things. The initial incarnation has been a good tool but I feel like it's time to expand it. I had the pleasure of picking the brain of a couple Regal techs a while back who mentioned Christie's service devision is doing something similar. I'm in the design phase of something new though, which I'll likely make open source or at least freely distributable. So, I'd like to ask: what do you all think of these types of systems and what suggestions would you have?  |  IP: Logged Mark Gulbrandsen Resident Trollmaster Posts: 16657 From: Music City Registered: Jun 99 posted 02-12-2010 09:13 PM                     If you are operating on a company wide server system with MYSQL thats probably the best way to handle it but in my case I don't have any small chains that begin to have that luxury so I've also always used Excel. Mark  |  IP: Logged Jim Ziegler Jedi Master Film Handler Posts: 753 From: West Hollywood, CA Registered: Jul 99 posted 02-12-2010 09:41 PM                     Most webhosting services offer one or more MySQL databases as part of the webhosting packages. I would guess that smaller chains are probably hosting their sites using a service rather than maintaing their own server, so they should have the capability to use something like this. The question is if they have people with the ability to implement it. Sounds like a great idea Dominic.  |  IP: Logged Scott D. Neff Theatre Dork Posts: 919 From: San Francisco, CA Registered: Oct 1999 posted 02-14-2010 11:15 AM                        We had something similar for work orders at Century. We used Lotus Notes though to do a lot of that stuff... don't know the specifics.  |  IP: Logged Dominic Espinosa Phenomenal Film Handler Posts: 1172 From: California, U.S.A. Registered: Jan 2004 posted 02-16-2010 05:40 PM                     Jim Z. in Hollywood now? You get around a lot! The system was originally designed to run on MySQL but I'm setting it up to run on SQLite and MySQL for compatibility purposes. Though I think most places will do precisely what we're doing, run it on their web hosting service. So, what features would you as operators and technicians want to see in something like this?  |  IP: Logged

All times are Central (GMT -6:00)

Printer-friendly view of this topic

Hop To: Select a Forum: Category: Operations -------------------- Digital Cinema Forum Film Handlers' Forum Large Format Forum Ground Level Feature Info, Trailer Attachments & REAL Credit Offsets Category: Community -------------------- Film-Yak Film Handlers' Movie Reviews The Afterlife Bob Maar's Joke-A-Thon Category: Classified -------------------- Equipment and Supplies Wanted/For Sale Help Wanted/Seeking Employment Category: System -------------------- Software Beta Testing Forum

The Film-Tech Forums are designed for various members related to the cinema industry to express their opinions, viewpoints and testimonials on various products, services and events based upon speculation, personal knowledge and factual information through use, therefore all views represented here allow no liability upon the publishers of this web site and the owners of said views assume no liability for any ill will resulting from these postings. The posts made here are for educational as well as entertainment purposes and as such anyone viewing this portion of the website must accept these views as statements of the author of that opinion and agrees to release the authors from any and all liability.