I am brand spanking new to SharePoint. I have been tasked with developing a SharePoint site that will facilitate finding documents, and better organize them than they currently are on our network drives. I am now trying to set up a specifications library.
- Standard Specifications Exceptions
- Non Standard Specification Exceptions
The non standard specification exceptions are also broken into 4 regions where the same exemption file name can have different contents.
Originally I was planning on uploading everything into one Library and using different views to see the information. But after reading another question on here, it sounds like a separate library for each is the better approach.
In the end I will have probably about 3K +/- documents to upload. They will be a mix of PDF, XML, DOC, and DWG. Every file will have a unique name. Some of the file formats will be:
NSP BIRD.XML NSP 001A820.XML NSP 100F08M.xml OPSS 0202.pdf OPSS 0304.pdf SSP 101F23.xml SSP 102S05.xml MTOD 0101.0700.dwg MTOD 0202.0400.dwg OPSD 0100.0100.dwg OPSD 0100.0110.dwg SSD 0002.0001.dwg SSD 0005.0002.dwg
Currently each of the type defined by the first 3-4 characters is in its own directory. Also each directory has an excel file which holds an index. Which are all similar, but column names, count and position may vary slightly from one index to the next.
An example index would look like:
Based on this table I know that SSD 0002.0001.dwg has the title:
Structural Standard Drawings Layering Structure
And that its Status is:
While I can drag an drop 100 files at a time and manually go into the library an and fill in the column information for each file it is rather time consuming.
Is there a way for the files to be uploaded and have the appropriate column information pulled from the index file?
As a followup question is there a better way of doing this? Previously I just made a hyperlink formula in each index that linked to the file on the network drive.
No clue what to tag this as either so some assistance with that would be appreciated.