Skip to main content
SharePoint

Return to Question

edited tags
Link
Forward Ed
Forward Ed
  • 55
  • 10
edited tags
Link
Forward Ed
Forward Ed
  • 55
  • 10
Source Link
Forward Ed
Forward Ed
  • 55
  • 10

Uploading files to SharePoint Library and referencing excel file to fill in column values

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.

there are:

  • Specifications
  • 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:

enter image description here

Based on this table I know that SSD 0002.0001.dwg has the title:

Structural Standard Drawings Layering Structure

And that its Status is:

Active

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.