Archive of design documentation

Question

ERP

Good afternoon, dear habra community. I want to ask for help from the collective mind.

There was an urgent need to reorganize the archive at the enterprise producing electronics.

What is now:
1. A folder containing 100500 files with names like 425212001-05K(03)(3101)_RE(RS)IN3417.pdf, they are in the same folder to avoid duplicates, the name is unique.
2. Excel file, with several sheets, specifying the correspondence Device name - code, Device name - designation according to GOST, Device name + file type - inventory number.

The main problem: in this garbage, no one except the one who created it can find the necessary document.

What I would like:
1. Maintaining an archive through the program, network access to documents.
2. Ability to search for document(s) by any attribute (name, internal code, inventory number, etc.)
3. Ability to divide documentation into production and operational, and the ability to configure to display only operational for some users.
4. Ability to upload documentation to the selected folder (both for 1 document and all selected by the filter), with the ability to specify the name of the documents according to the template (for example, Device name_document type_inventory number, or another combination of available fields)

Now the question. Prompt the program which it will be possible to arrange the archive in such a way. Google leads to sites with programs from the 90s and offering to buy first, and then think whether it suits the task or not.
Preferably those with whom you really worked, with a description of their pros and cons. I would be very grateful.

Answer 1

PDM or PLM system is needed here. They require money. But before its implementation, it is necessary to think over the structure of the future storage (for example, the ESKD classifier or industry-specific ones).

Answer 2

There are complex solutions for electronic archives. They are expensive.
We make knowledge bases with flexible taxonomies for classifying uploaded documents.
Documents can be of any type: pdf, avi, doc, xls, etc.
All this is classified as you like: by device type, by year, well, you can come up with any meta fields.
For example, there is such a project here casepress.org/?portfolio=baza-znanij I
recommend WordPress, because In my opinion this is the best solution in terms of price / quality ratio. The system itself is free, but the costs of its development are highly dependent on the size of the community of specialists and ready-made solutions, according to all these parameters, WP No. 1 in the world, because. occupies more than 50% of the market.
There is experience. If you are interested in consultations, please contact us.

Answer 3

Belarusian Intermech offers a whole complex for these tasks. They seem to give it a try.
He worked at the enterprise where it was implemented (was implemented), and at the enterprise where the archive is arranged as it is written for you - heaven and earth. What is worth for an electronics engineer is the choice of which transistor thread in the base, and the instant display of all nodes of all devices and complexes where such an element was once used. A completely paperless circulation of documentation, electronic normative control, transparent control and setting of temporary tolerances for each document approval operation. This is me about Search. There's a lot more - check out their website.
But it is very expensive and very painful to implement, older employees usually greatly hinder

Answer 4

del. missed

Answer 5

I developed an archive of design documentation (in fact, I continue to add functionality, although the system is already in use) in the form of an intranet site based on Drupal. All your "Wishlist" is implemented in it, with the exception of mass unloading (although it's not very clear why this is needed). If you are interested in the experience, write, I will try to help.

Answer 6

Look at the solution DEXMA (DEXMA) dexma-plm.com - a modern solution and the functionality of organizing an archive of electronic documentation is present there. For review, it does not require implementation, it is available as a cloud service, if you wish, you can install the software on your corporate server (including for study).