I am brand new in SharePoint. I've been tasked with developing a SharePoint site that makes it easier to find documents and improve their organization than is currently the case on our network drives. I am now trying to set up a specification library.
- Standard Specifications Exceptions
- Exceptions that do not conform to the standard specification
The non-standard exceptions are also divided into four regions where the same exception file name can have different contents.
Originally, I planned to upload everything to a library and use different views to display the information. After reading another question here, it sounds like a separate library is the better approach for each question.
In the end I will probably have about 3K +/- documents to upload. They will be a mix of PDF, XML, DOC and DWG. Each file has a unique name. Some of the file formats are:
Currently, each of the types defined by the first 3-4 characters is in its own directory. In addition, each directory has an Excel file that contains an index. These are all similar, but column names, number, and position can vary slightly from index to index.
An example index would look like this:
From this table, I know that SSD 0002.0001.dwg has the title:
Standard structural drawings overlaying the structure
And that his status is:
While I can pull 100 files at once and manually go to the library and enter the column information for each file, this is quite time consuming.
Is there a way to upload the files and retrieve the appropriate column information from the index file?
Is there a better way to do this? So far, I've created a hyperlink formula in each index that points to the file on the network drive.
No idea what is labeled as "this", so support for this question would be very welcome.