Forum Discussion
Unique Metadata in Sharepoint
Is there a way to require unique metadata in Sharepoint? I'm researching a suitable application to move our engineering documents to. We've been using Filenet since 2003 and it's time to make a ...
We would use Sharepoint as a "Published" drawing system.
A drawing may come from scanning, multiple cad softwares, or outside vendors either designing for us or or providing turnkey systems. We have a PDM solution to manage CAD document for engineers. Sharepoint would be used as simple "Search, View, Print". Departments like Machine Repair, Maintenance, Machine Repair, Purchasing, Marketing, Pricing, Sales... would be consumers of the data. We currently have 300,000 drawings and have 240 users access drawings as they need them. Our published drawing system is the one place to go for the correct copy. It's not the CAD system, not a file cabinet, not e-mail...
We would like to check in a file over another as a version. (but what happens when we want to replace a TIFF with a PDF?)
Minimal editing or changes. Only to keep up with data corrections.
I was looking as a few tools that could generate a published file from our cad data and publish it to sharepoint. The idea get a bit messing when you consider existing data can consider what might go wrong.
Our current system allows all files to be loaded. Then on an after record insert in the database a procedure searches for duplicates. If something is found it renames the new file and sends the author an e-mail telling them to fix their mistake. Not perfects but keeps the system cleaner and prevents junk from building.
I've experimented with Sharepoint searching. It's different from what we are use to. We may have to build a few more filters that would help. Not being able to use a prefix wild card could heart. Content searching is not a bonus for us and most of our data is a tiff file. We want to limit results in most cases. most of the time people just search for a part number. They know the number and get the one file they need. But when you don't exactly know what you want and need to search for a combination of fields it gets interesting. Some of us are good at it and others...well you know...
A drawing may come from scanning, multiple cad softwares, or outside vendors either designing for us or or providing turnkey systems. We have a PDM solution to manage CAD document for engineers. Sharepoint would be used as simple "Search, View, Print". Departments like Machine Repair, Maintenance, Machine Repair, Purchasing, Marketing, Pricing, Sales... would be consumers of the data. We currently have 300,000 drawings and have 240 users access drawings as they need them. Our published drawing system is the one place to go for the correct copy. It's not the CAD system, not a file cabinet, not e-mail...
We would like to check in a file over another as a version. (but what happens when we want to replace a TIFF with a PDF?)
Minimal editing or changes. Only to keep up with data corrections.
I was looking as a few tools that could generate a published file from our cad data and publish it to sharepoint. The idea get a bit messing when you consider existing data can consider what might go wrong.
Our current system allows all files to be loaded. Then on an after record insert in the database a procedure searches for duplicates. If something is found it renames the new file and sends the author an e-mail telling them to fix their mistake. Not perfects but keeps the system cleaner and prevents junk from building.
I've experimented with Sharepoint searching. It's different from what we are use to. We may have to build a few more filters that would help. Not being able to use a prefix wild card could heart. Content searching is not a bonus for us and most of our data is a tiff file. We want to limit results in most cases. most of the time people just search for a part number. They know the number and get the one file they need. But when you don't exactly know what you want and need to search for a combination of fields it gets interesting. Some of us are good at it and others...well you know...
A combination of columns containing a unique value is what I'm looking for, Nice to know at least one column can contain a unique value.