MySQL - PHP Document Control (Free!)

G

Greg B

#1
Hi All,

I thought I would share this FREE Document Register with you. My company was about to pour thousands of dollars into a system that did the same thing as this register. It is Intranet based and will accept all types of documents in all types of formats (Word, Excel, Visio, PDF etc). I had to get my IT guy to download it and set it up on the server but we now have ALL of our company documents on it. HR, IT, QA, ENV, OH&S etc over 1200 documents.
When you 'download' a document on your PC, you can do whatever you want with it but it cannot effect the master copy. We use the 'form' tool to design all our forms to make them 'electronic'. Peole can fill in documents at their PC. Anyway I'll let you all visit the site and play with this Money saving, God send. We no longer have printed copies of documents it saves me heaps of time.

http://dms.markuswestphal.de/about.html

All the Best

Greg B
 
Elsmar Forum Sponsor

Marc

Hunkered Down for the Duration
Staff member
Admin
#2
MySQL

I have not done the demo, but MySQL is what these forums run on as well as many major corporation's database apps. MySQL is extremely good - and FREE... You don't need Oracle, PeopleSoft or other expensive sofware. And... micky$oft will not be able to raise the price (for Access) in a year or so...
 
E

energy

#3
What are we saying?

I don't know. What are you intellectuals saying? Is it going to border on the Mystic on how we log in and go on with the game? Like, what are the improvements that needed to be accomplished? Is this something for his Majestry's service? An imaginary vision of how it should look like as opposed to those that think it didn't need fixing? Enlighten me and the other ignorant Bozos as to why the current system has to be replaced. Are we behind the times? Behind the cutting edge? Just another Sunday night and wondering why we need this monumental change. I'm assuming that that the change requires a major adjustment from all of us to learn to navigate the new "system". Cripes, it's Monday already!:vfunny: :smokin:
 
M

M Greenaway

#4
What advantages does this have over simply saving documents to a read only folder location on your company PC server ?
 
B

Bob_M

#5
Originally posted by M Greenaway
What advantages does this have over simply saving documents to a read only folder location on your company PC server ?
I second that questions.

Of course we have less than 10 regular computer users here...
and 1600 file
WOW I did not realize we had that many documents...
Note to self. Future project - Reduce documentation.
 
C

Cathy

#6
I agree with Bob and M,

I opened it up, started the demo and I immediately thought it was too complicated. I am going to have a better look at it later but I know for sure no-one in my organisation would look at it. Maybe in a larger company this type of thing might work.

What I did for my Document control was designed an intranet and saved all linked documents to read only folders. Like M says, it simple. I have made the intranet very user friendly and as interesting as possible. I use it to display photographs of nights out, make important social announcements and of course, for all QMS documentation, forms, logs, databases - the works.

It took a day to set up. That was 4 months ago and now staff from other departments are happy to log in, check out the dates for the next night out and look up the latest news on the quality front. I know its a bit of bribe...but it works.

I would be happy to share the concept and set up with anyone who is interested.

Cathy
 
B

Bob_M

#7
Although I did not check out the demo, we have tried to keep our intranet simple and easy.

We have a central "Controlled Documents" directory.

I created subdirectories as needed.

All directories are read-only and can only be modified or deleted by the Quality Manager (me), the computer administrator account (me), and the President/Owner (who never will unless I leave).

All files are read-only in their orignal form (Word, Excel, etc).
Currently the documents are not internally protected, but no one currently here has any reason to modify a document without updating the process. Even though I like the idea of making PDF copys for general access, for our small company its really a waste of time and resources.

People have been instructed to forward updated documents to me for uploading and controlling. (Still need to update procedure/workinstruction though).
 
G

Greg B

#8
Let me explain

What advantages does this have over simply saving documents to a read only folder location on your company PC server ?
If you save a document as read only then people can change the master document by taking the read only off. This is not likely to happen but it could. With the Document Register noone but the administrator can change a master document. The system can also track changes, reasons for change, revision numbers and dates of change. It has a search function for words or documents. It supports various documents including word, excel and visio etc. It sits on the intranet. It can notify groups of a change in a document that they have an interest in (by email). Old document versions are saved automatically for easy comparison and retrieval. You can set temporary documents to expire after a given date (good for plant trials etc).

I don't say that everyone needs it but if you were looking for an instant electronic document control system you could not go past this FREE one.

All of your ideas sound great. I was just putting out some help if anyone needed it. :D

Greg B
 

Mike S.

Happy to be Alive
Trusted Information Resource
#9
Re: Let me explain

Originally posted by Greg B
If you save a document as read only then people can change the master document by taking the read only off. This is not likely to happen but it could. With the Document Register noone but the administrator can change a master document.

It has a search function for words or documents. It supports various documents including word, excel and visio etc. Greg B
If I save a Word or Excel file as "read-only" with a password, the same thing applies -- no one but the password holder can change it -- unless your employees are into hacking or password busting or something. It has never happened to me in over a decade.

Windows has a search function that I rely on often.

It does sound like the software has some bells and whistles that some may want, though. Thanks for adding the details. Maybe someday... :bigwave:
 

CarolX

Super Moderator
Super Moderator
#10
Re: Re: Let me explain

Originally posted by Mike S.
If I save a Word or Excel file as "read-only" with a password, the same thing applies -- no one but the password holder can change it -- unless your employees are into hacking or password busting or something. It has never happened to me in over a decade.

Mike,

You want to try an experiment. Send me your Excel or Word file and let me see if I can bust it open. Energy can attest that it only takes a matter of minutes to do (I did it to him). Post it here and I'll bust it for you.

CarolX
 
Thread starter Similar threads Forum Replies Date
Z Using PHP, ajax and MySql for QMS Quality Assurance and Compliance Software Tools and Solutions 8
Marc What Database to Use - MySQL vs. a 'Real' Database Quality Assurance and Compliance Software Tools and Solutions 8
A Designing a Documents Control System from scratch (in a php intranet) Document Control Systems, Procedures, Forms and Templates 5
M What is a PHP screw? M2 x 10 PHP screw SS Manufacturing and Related Processes 11
C Web based SPC Analysis using PHP Statistical Analysis Tools, Techniques and SPC 2
J Santy worm affects PHP bulletin boards After Work and Weekend Discussion Topics 1
B Document Approval Matrix Benchmarking Document Control Systems, Procedures, Forms and Templates 3
J Document Approval Signature Order Document Control Systems, Procedures, Forms and Templates 10
L How to add exemption or statement to control of document procedure? ISO 13485:2016 - Medical Device Quality Management Systems 5
M What is the proper way to document measurements Measurement Uncertainty (MU) 1
P Equipment 21 CFR 820.70(g) - User Requirements Document for Off the shelf equipment 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 7
B Do IFU designs have to be document controlled under ISO 13485? Document Control Systems, Procedures, Forms and Templates 2
C Certificate of Conformance Form - COC for each customer a controlled document? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 2
A Document "Correspondence IATF 16949 vs ISO13485" available? IATF 16949 - Automotive Quality Systems Standard 0
R Document Retention - Discard hard-copies after scanning? ISO 13485:2016 - Medical Device Quality Management Systems 2
P Mylar plot suppliers in accordance with D6-51991 document AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 4
A Document Change Notice vs complete System re-write Manufacturing and Related Processes 4
Q Document approval through SharePoint (without signature) Records and Data - Quality, Legal and Other Evidence 4
S What is considered a "core algorithm"? (From an FDA guidance document) Medical Information Technology, Medical Software and Health Informatics 4
U Document Approval - Software company ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 3
O Please, help with document on ISO/ TS 17758 and (IDF 87: 1979). Thank you. Manufacturing and Related Processes 1
K Proper document of SMPS used in infant warmer for IEC 60601-1 testing IEC 60601 - Medical Electrical Equipment Safety Standards Series 1
I Nitpicking on document released dates ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 2
I Document Control on Log Files ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 6
Q Refusal to Document Complaints Customer Complaints 39
Q Tracking Procedure Revisions (Document Control) Document Control Systems, Procedures, Forms and Templates 9
C Document Control Stamps - Does anyone still stamp their documents? Document Control Systems, Procedures, Forms and Templates 24
I Master Document Access - ISO 9001:2015 clause 7.5.3 Document Control Systems, Procedures, Forms and Templates 5
I Can a document (form) approval record be separate? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 6
I Control of Documentation Distribution - Document Control ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 2
T Advice needed - Environmental MS - unwritten but customer requests policy document ISO 14001:2015 Specific Discussions 5
T Control of downloaded document copies by employees Document Control Systems, Procedures, Forms and Templates 3
T Document control ISO 13485:2016 ISO 13485:2016 - Medical Device Quality Management Systems 5
I Is highlighting on a printed document considered a change? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 4
C QMS Document Management Software Recommendations Quality Assurance and Compliance Software Tools and Solutions 14
E Part 11 Compliance, Excel living documents (i.e. document master list, equipment list, approved supplier list) Pharmaceuticals (21 CFR Part 210, 21 CFR Part 211 and related Regulations) 3
Sidney Vianna Informational New IAQG Document - AS9100 Clarifications of Intent AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 3
S How to determine & document Organizational Knowledge of a company Document Control Systems, Procedures, Forms and Templates 4
D Are medical device companies required to document every change made to their website? Document Control Systems, Procedures, Forms and Templates 2
M Informational IMDRF draft document – Principles and Practices for Medical Device Cybersecurity Medical Device and FDA Regulations and Standards News 0
M Nonconformity for missing form number on the job description document Nonconformance and Corrective Action 1
R Training Matrix for Document revisions ISO 13485:2016 - Medical Device Quality Management Systems 4
S Controlled Document Location Document Control Systems, Procedures, Forms and Templates 3
M Setting deadlines (ex. 45 days) for Document Registration & Review Cycle Document Control Systems, Procedures, Forms and Templates 3
M Informational IMDRF draft document – Requirements for Regulatory Authority Recognition of Conformity Assessment Bodies Conducting Medical Device Regulatory Reviews Medical Device and FDA Regulations and Standards News 0
B AS9110 Audit Check Sheet wanted Excel or Word Document AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 2
D Document review on already approved registrations requested by China's NMPA? China Medical Device Regulations 3
O Vendor vs Engineering Document Control ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 1
Z 21 CFR and Annex 11 mapping document Pharmaceuticals (21 CFR Part 210, 21 CFR Part 211 and related Regulations) 1
A ISO9001:2015 Document control and training aids ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 7

Similar threads

Top Bottom