Hi folks,

How you control ur ISO documents in your firms? I mean using what kind software. These documents includes manual, procedures, instructions, inspection records, training materials and records, engineering design, production plan, production travellers and all others.

I guess MS Access can carry out this task but somebody can advice other better softwares else?

thanks.

Most of my clients just have a directory on a company server to store their documents. It is protected so that only authorized personnel can modify, add, or delete controlled documents there.

Assume have 100 part number with different engineering specification and process requirements. It be expected that everything appear on production traveller so that operators and inspectors can follow easy. Then a datebase is required.

Also, for security requirements, it also needs a datebase to make sure employee (data entry) can only enter the data, view the document but can not modify it.

I am gussing there is a simple software can carry out this kind easy task. (I really do NOT like MS Access).

Happy Thanksgiving day!!!

When I was a quality manager I developed a database similar to what you are describing. I did it in... (you guessed it) MS Access. :bonk:

Sorry I can't help. I personally like Access...

en, it seems I should like Bill Gates, even I hate bills.

Donald,

If you are looking for a way to protect documents but still allow all users to access them I suggest making them available your company intranet (if you have one). It is much easier than MS Access and you can apply read-only properties to the documents.

mshell

mshell,

that's a good idea! a web-based database! then I getta using Java...... and go little bit more.... add SPC function. and DOE, R&R......? Hi, let's go sharing some marketing from Minitab........lol

a good quality guy should also be a good programmer, I'm thinking...

WoooooW! my boss wont spend money for software!

Thanks folks

I'd agree with howste and mshell. Use network rights to control access to folders, OR save documents with passwords (or both if yer real 'noid). BUT I maintain others should use what we have: an MS database to log who makes what document revisions, prompt for doc reviews and record purging, create reports on late reviews/revisions, create master record, document, stats and calibrated tool lists; log authors and reviewers, storage locations and methods; define media types; reconcile records; prevent premature data loss, open electronic records/documents, etc. etc. The same software can also manage information for calibrated tools and statistical techniques, has a complete Help file and is still less than $400 per license.

Hi folks,

How you control ur ISO documents in your firms? I mean using what kind software. These documents includes manual, procedures, instructions, inspection records, training materials and records, engineering design, production plan, production travellers and all others.

I guess MS Access can carry out this task but somebody can advice other better softwares else?

thanks.

Donald,
Go to this thread I put up a while ago. It has a link to a 'Document Register' that is 'FREE' and will manage ALL of your documents in any format (word, Excel etc). My company uses it across all of our sites (600 kilometers apart) over the intranet.

I hope it helps.

Greg B
http://elsmar.com/Forums/showthread.php?t=6418

Greg,

Sorry for two days no came here.

Thanks a billion! Give me a little bit time to try this software, I will let you know what happened.

donald

My company uses QSI to control items such as manuals, procedures, work instructions, and forms. This also allows to set up an Electronic Training Record (ETR) database to keep track who needs to be trained on what, who has been trained on what, job descriptions, etc.

The good thing about purchasing a software package to control your documents is that your master list is automatically generated, revision numbers and status are easy to locate in a glance, and training is easy to set-up (especially now that we can train ourselves online...so long as we have an email account).

Many software packages also have modules for Corrective Actions and Internal Audits with links to all of these modules so generating the electronic papertrail is as simple as clicking your mouse. QSI offers these features, but my organization chose not to purchase them.

Donald, you need to pick the option that works best for your organization. Using Access or Word, wouldn't have worked for my place (although it did for the last company I worked at).

Our organization is a PCB maker with less than 100 employees. The terrible situation when I join was totally no computer system to control the process. Even for the specification on working order was written by hands. It seems I went back to 1950s'. The fastest way to improve should be useing Access or Excel to control it. But I perfer to build a web-based datebase control system for them.

When I worked for my last company, I just used MS frontpage to buide a web for document control and got success. But after we lunch another expensive software, lots of people disappeared form the system.

I used touched Minitab and statSoft, they work well but not everybody can be familiar with them easily. Actually these kind software have too much functions exceed we need plus too high price. so I am looking for a way to build a simply and samll web system. I noticed that no everybody familiar with computer, especially for the bosses, (I think they are too old). A esay apprach is necessary to make sure the software will be actually used during the operation.

I think a quality system software just need the following basic founction is enough:

1. Document control. Include Revision and distribution control, records control, engineering drawing control and purchasing/working order release.

2. Basic statistical ability. Not so much company do DOE, ANOVA. A basic SPC function should be enough.

3. Some quality tools function like QFD, Fishbon, 8D and so on to allow people conduct improve activities under guide. That mean use the computer as team leader.

Do you guys think these function is enough?

MyMDS (http://dms.markuswestphal.de/about.html) is not bad, it is based on MySQL (http://www.mysql.org) datebase and use PHP (http://www.php.net) language. Next week I will study it to see if its suitable for my company or not.

Every company has webserver, MySQL, PHP, JAVA are all free. But where can you find a guy familiar with both quality and program?

I am dreaming to write a quality software myself. easy, simple, cheap or free but strong! Did anybody here try it before?

FWIW - We have just purchased ETQ software which (I'm told) is some type of document control software. I haven't been "introduced" to it yet but our IT dept. seems very high on it.

MyMDS (http://dms.markuswestphal.de/about.html) is not bad, it is based on MySQL (http://www.mysql.org) datebase and use PHP (http://www.php.net) language. Next week I will study it to see if its suitable for my company or not.

Every company has webserver, MySQL, PHP, JAVA are all free. But where can you find a guy familiar with both quality and program?

I am dreaming to write a quality software myself. easy, simple, cheap or free but strong! Did anybody here try it before?

DD,

I think if you go to the forums home page you will find this site is maintained or uses both PHP and MySQL. My IT guy tells me that eventually we will not have Access databases but rather MySQL. As I have stated we use MyDMS and it is excellent for managing our documentation. The guy who makes this free program (My DMS) also has a discussion board where people tell him what they want put into the programming. We have asked him for a Documentation list that shows all document chnages and he is now working on it. Again, It is free. :bigwave:

Greg B

Greg,

I setup MyDMS in my computer already, It seem the function is not strong enough for me, sorry for that. It cannot realize the function what I want to. For example, the production order realization.

Greg,

I setup MyDMS in my computer already, It seem the function is not strong enough for me, sorry for that. It cannot realize the function what I want to. For example, the production order realization.

Donald,

What do you mean 'It cannot realize the function"? You can set up a document tier any way you wish. I am sending you a copy of two documents I made to use MyMDS. One is for administrators and one is for Users. I hope these help.

Greg B

:vfunny: Donald,

What do you mean 'It cannot realize the function"? You can set up a document tier any way you wish. I am sending you a copy of two documents I made to use MyMDS. One is for administrators and one is for Users. I hope these help.

Greg B

Great looking documents, Greg. User friendly. I like the imbedded pics of Internet Explorer. I guess I shouldn't let that Smokey the Bear hat fool me. Good job! :agree:

Greg,

Firsty I could not see your documents, they told me I had to pay first.

The example function I desired:

We have almost 500 part number for production, for every PN, the traveller contains production quantity, manufacturing specifications, inprocess control requirements and some other information. the traveller is different for every PN. Currently we fill the traveller by hand and combine with lots of instructions to guide the operators. What I want is use the software to build a database. Just input the part no, quantity, shipping date. then automatically generate the traveller...........furthermore, if can monitor the production status, inspection results and on-time delivery on webserver, will be great. go too far I think...........PHP can also realize SPC function.... :eek:

Yes, MyDMS is a great sofware, I like it. Thanks for the great providing. :thanx:

look forward to seeing your documents.

A former company used a product called Quality Workbench to manage document control as well as complaints. It also does audits, PMs and calibrations, but we didn't use those features. Combined with a Xerox product called DocuShare, (used for engineering drawings and external documents, we had a very effective document control system that could be shared via the Intranet.

My present company uses a mish-mash of different approaches and I plan to convert us to a software tool in the coming year. Too many possibilities for error in paper systems.

Greg,

That's a great done. One more question here, how you control the records by MyDMS. We can put the blank forms on the document system, then keept he hand written forms by hard copy, keep the electric copy in system. But that will be easy to mess. what about this way: blank form --- database table --- filled forms --- data collected by other functions autoatically.Rosie

Samething like Rosie, I will try develop more function base on myDMS in coming year. I will let you all know what happened.

Thanks all.