I have been tasked with a project where I am moving a ton of documents from an old DB backed system to SharePoint. Easy, right? No!
The documents all have what the old system calls properties - basically tags or metadata such as Year, Invoice Number, or Customer. Naturally, one would just add columns to the Library. The only problem is, there are about 20 different groups of documents, all with their own properties.
Example:
- 1099's
- Doc1.tif
- Year: 2001
- Company Code: 15432
- Doc2.tif
- Year: 2003
- Company Code: 54323
- Bank Statements
- Statement1.tif
- Bank Name: Bank1
- Account Number: 3452345345
- Statement2.tif
- Bank Name: Bank2 of America
- Account Number: 2342345234
All "sets" of documents have their own "properties" and there are about 20 different sets of documents. So I don't think library columns would work here. I would HATE to have 20 different libraries to manage for this one project. I love metadata (and what SharePoint admin doesn't??), but this one has me stumped.
Does anyone know how this could be accomplished?