1-800-264-9029|602-266-8500
  • Course Schedule
    • Microsoft Training
      • Windows 10
      • Teams / Microsoft 365 / MS365
      • Windows Server 2019
      • Windows Server 2016
      • SQL Server
      • Power BI
      • Power Platform
      • Azure
      • Data Engineering / Machine Learning
      • Artificial Intelligence (AI)
      • Exchange Server
      • PowerShell
      • System Center
      • SharePoint
      • IIS
    • Cloud Computing
      • Azure
      • Amazon Cloud (AWS)
    • Developer Training
      • DevOps
      • Docker Kubernetes
      • Web Development
      • .NET Development and Visual Studio
      • Java Programming
      • Python
    • Cisco Training
      • Cisco CCNA Routing & Switching
      • Cisco Training – HD TelePresence
    • CompTIA Certification
      • CompTIA A+
      • CompTIA Network+
      • CompTIA Security+
    • Business Training
      • Project Management
      • ITIL
      • NIST
      • Business Analysis
      • Agile
    • IT Security Training
      • Microsoft Security
      • CISSP / CEH / PKI / Security
      • NIST
    • Wireless / Wireshark Training
      • Wireless Networking
      • Wireshark
    • Red Hat
      • Red Hat – Linux
      • Red Hat – DevOps
    • Other Training
      • VMware
      • NetApp
      • F5 Networks
      • Salesforce
      • Citrix
  • Exams
    • Student Pricing
  • Subscriptions
  • RemoteLive™
  • Replay™
  • Video Courses
  • Resources
    • Tech Blogs
    • Tech Videos
    • Microsoft Learn Catalog
  • About
    • Instructors
    • Interface Gold™ Benefits
    • TechPaks
    • Our Video Training Timeline
    • Training Room Rental
    • Group Training & Private Classes
    • Contact

Setting Default Metadata Values in SharePoint 2010

Home > Blogs > SharePoint > Setting Default Metadata Values in SharePoint 2010

Setting Default Metadata Values in SharePoint 2010

Like This Blog 6 Spike Xavier
Added by Spike Xavier July 25, 2012

In this blog I will be migrating several documents from a file share into SharePoint 2010. On the file share they are unstructured data. When we migrate them into SharePoint they will be seen as the content type courseOutline and they will have an Instructor and technical department site column attached to them as metadata. In order to save time we will be using the feature of Column default values for metadata columns in SharePoint 2010. In order to understand this process it is important that you have a grasp of the concepts in the following two blog entries:

Creating Site Columns and Custom Lists in SharePoint 2010

Creating a Custom Content Type in SharePoint 2010

I have set up a new site collection and created a custom content type courseOutline with the site columns Instructor and technicalDepartment both are choice columns.
I have added a folder structure to mimic the file share and I have adjusted the default view to include the site columns, including Title.

Match Folder Structure

Match-Folder-Structure.png

I match the folder structure of my file share. If I wanted a different structure, I would do that here but in this case, I am migrating data into SharePoint and changing it from unstructured data to proper content types with searchable metadata.

Click Library Library Settings

Click-Library-Library-Settings.png

I click the Library Tab and then the Library Settings icon in the ribbon.

Click Column Default Value Settings

Click-Column-default-value-settings.png

I click on Column default value settings under General Settings on the List Settings page.

Select the folder

Select-the-folder.png

I select the Cisco folder since this is the first one I want to set the default values for.

Set default values for Instructor

Set-default-values-for-instructor.png

I select Instructor by clicking on the Column link.

Edit Default Value

Edit-Default-Value.png

I choose the radio button Use this default value: and add in Mark Jacobs (the Cisco Instructor) Then click OK.

Set default value for technicalDepartment

Set-default-value-for-technicalDepartment.png

I click the link for technicalDepartment (notice the green icon now on the Cisco folder since a default value has been set for this location.)

Fill in Modal Window form

Fill-in-modal-window-form.png

I select the radio button to Use this default value: and then set the Default value to Cisco. It is important to set the value to the exact match for one of the values in the choice column. Then I click OK.

Repeat process for development

Repeat-process-for-development.png

I repeat the process I used for setting the values in the Cisco folder but this time I click the Development folder in the Location to configure column and set the default values appropriate to development outlines.

Repeat process for SharePoint

Repeat-process-for-SharePoint.png

I repeat the process I used for setting the values in the Cisco and Development folders, but this time I click the SharePoint folder in the Location to configure column and set the default values appropriate to sharepoint outlines.

Repeat process for Systems

Repeat-process-for-systems.png

I repeat the process I used for setting the values in the Cisco, Development, and SharePoint folders, but this time I click the Systems folder in the Location to configure column and set the default values appropriate to systems outlines.

Return to courseOutlines Library

Return-to-courseOutlines-Library.png

Using the breadcrumb, I return to the courseOutlines document Library which is now properly set up.

Go to Cisco folder

Go-to-cisco-folder.png

I click on the Cisco folder to get into it.

Click Add document

Click-Add-document.png

I click the Add document link.

Click Upload Multiple Files

Click-Upload-Multiple-Files.png

I click the Upload Multiple Files link (notice that I could have just done this from the courseOutlines document library because you can choose a folder in this modal window).

Browse for files instead

Browse-for-files-instead.png

You can drag files into the Drag Files and Folders Here Silverlight control or you can click Browse for Files instead. You can only upload up to 100 files at a time in this way.

Select files to upload

Select-files-to-upload.png

I select the top document and then holding the shift key down select the bottom document which selects them all then click the Open button.

Click OK

Click-OK1.png

I verify the items in the window then click OK.

Verify status

Verify-status.png

I verify that the status shows done, then I click the Done button.

Validate results

Validate-results.png

I check to make sure that the instructor column has the value Mark Jacobs and that the technical department is now Cisco. I will then repeat the process for the other folders.

Repeat steps for Development folder

repeat-steps-for-development-folder.png

I repeat the steps for adding documents to the Cisco folder but this time I upload the documents from the Development folder on the file share to the Development folder in the courseOutlines document library.

Repeat steps for SharePoint folder

repeat-steps-for-sharepoint-folder.png

I repeat the steps for adding documents to the Cisco folder but this time I upload the documents from the SharePoint folder on the file share to the SharePoint folder in the courseOutlines document library.

Repeat steps for System folder

repeat-steps-for-system-folder.png

I repeat the steps for adding documents to the Cisco folder but this time I upload the documents from the Systems folder on the file share to the Systems folder in the courseOutlines document library. I have now successfully uploaded many documents from the unstructured world of the file share into the content type structured world of SharePoint 2010 using default column value settings!

Enjoy!
Spike Xavier
SharePoint Instructor – Interface Technical Training
Phoenix, AZ

Subscribe to this author's posts feed via RSS

You May Also Like

  • Using Navigation Controls in a Collaboration Site in SharePoint
    Using Navigation Controls in a Collaboration Site in…
  • How to Configure Navigation in SharePoint Publishing Sites
    How to Configure Navigation in SharePoint Publishing Sites
  • Using Navigation Controls in a Publishing Site in SharePoint
    Using Navigation Controls in a Publishing Site in SharePoint
  • How to Create a Site Content Type based on ObjectOfItem in SharePoint Designer 2013
    How to Create a Site Content Type based on…
Category SharePoint

Tags

Custom Content Types, metadata, SharePoint, SharePoint 2010, sp360

Videos You May Like

Using Navigation Controls in a Collaboration Site in SharePoint

Using Navigation Controls in a Collaboration Site in SharePoint

0 343 1

In this SharePoint training video, I want to talk about the Navigation Controls in SharePoint. They tend to fall into two kind of different categories; one with the navigation controls in a typical Collaboration Site such as a Team Site or a Project Site. These are Sites that are based on the Team Site Template … Continue reading Using Navigation Controls in a Collaboration Site in SharePoint

How to Use SharePoint Navigation Controls in a Publishing Site

How to Use SharePoint Navigation Controls in a Publishing Site

0 232 2

For more SharePoint training videos in this series, see: Part 1 – Using Navigation Controls in a Collaboration Site in SharePoint Part 2 – » Using Navigation Controls in a Publishing Site in SharePoint « Part 3 – Configuring SharePoint Navigation in a Publishing Site – Activating the Publishing Feature Part 4 – How to Configure Navigation in SharePoint … Continue reading How to Use SharePoint Navigation Controls in a Publishing Site

How to Configure Navigation in SharePoint Publishing Sites

How to Configure Navigation in SharePoint Publishing Sites

0 1240 3

For more SharePoint training videos in this series, see: Part 1 – Using Navigation Controls in a Collaboration Site in SharePoint Part 2 – Using Navigation Controls in a Publishing Site in SharePoint Part 3 – Configuring SharePoint Navigation in a Publishing Site – Activating the Publishing Feature Part 4 – » How to Configure Navigation in … Continue reading How to Configure Navigation in SharePoint Publishing Sites

Write a Comment

See what people are saying...

  1. Pingback: How to use Metadata Navigation in SharePoint 2010 | Interface Technical Training

Share your thoughts... Cancel reply

Please fill out the comment form below to post a reply.

ITIL 4 Promotion

Blogs by Technology

  • Amazon AWS (2)
  • Azure Cloud Computing (2)
  • Business Analysis (8)
  • Cisco (125)
  • CompTIA (71)
  • Developer Visual Studio / ASP.NET (62)
  • Exchange Server (47)
  • ITIL / COBIT (33)
  • Lync Server (3)
  • Office 365 (5)
  • PMP Project Management (63)
  • PowerShell (81)
  • Security (47)
  • SharePoint (93)
  • SQL Server (78)
  • System Center (13)
  • Web Development (60)
  • Windows 10 (65)
  • Windows 7 (124)
  • Windows 8 (85)
  • Windows Server (74)
  • Windows Server 2012 (90)
  • Windows Server 2016 (14)
  • Wireless (9)
  • Wireshark (5)

Blogs by Instructor

  • Dan Wahlin (44)
  • Don Jones (15)
  • Dr. Avril Salter (6)
  • Greg Richard (1)
  • Interface (49)
  • Jason Helmick (38)
  • Jeff Jones (18)
  • Jeremy Cioara (8)
  • Mark Jacob (125)
  • Mark Thomas (28)
  • Mike Danseglio (93)
  • Mike Pfeiffer (35)
  • Peter Avila (32)
  • Rick Trader (127)
  • Spike Xavier (86)
  • Steve Fullmer (163)
  • Suzanne Van Hove (1)

Blogs You May Like

  • Creating Lists and Libraries in SharePoint
  • How to Configure Navigation in SharePoint Publishing Sites
  • Using Navigation Controls in a Publishing Site in SharePoint
  • Using Navigation Controls in a Collaboration Site in SharePoint
  • Part 3 How to Import a CSV Text File into SharePoint 2013 – Creating the list in SharePoint
  • Part 5 – Importing a CSV file into SharePoint 2013: Create Home Page Dashboards

Video Courses

  • ITIL 4 Foundation Certification Video Training Course
  • Project Management Professional (PMP®) Certification Video Training PMBOK® 6th Edition
  • PMI-PBA Business Analysis for IT Analysts and Project Managers (PMI-PBA)® Certification
  • SharePoint Designer 2013 for American Express
  • CompTIA Network+ (Coming Soon!)
  • CompTIA Security+ (Coming Soon!)
  • CompTIA A+ Certification Core 1 1001 (Coming Soon)
  • CompTIA A+ Certification Core 2 1002 (Coming Soon)

Live Training Courses

  • NET+007: CompTIA Network+ Certification Training + N10- 007 Exam
  • PowerShell - 10961: Automating Administration with Windows PowerShell
  • ITIL4® Foundation Certification Course with Exam
  • AZ-100: Azure Infrastructure and Deployment Training
  • PMI-PBA: Business Analysis for IT Analysts and Project Managers (PMI-PBA Certification)
  • Cisco CCNA - ICND1v3 Interconnecting Cisco Networking Devices CCNA Part 1
  • COBIT205: COBIT® 5 Foundation and Implementation IT Governance Training
  • DEV415: Microservices with ASP.NET Core and Docker
  • IT Security - SEC+501: CompTIA Security+ with Certification Exam SY0-501
  • SQL Server - SQL101: Introduction to Transact SQL
Facebook
Twitter
Linked In
Comment
EMAIL

About Us

  • Interface Gold™ Benefits
  • TechPaks
  • Training Room Rental
  • Group Training & Private Classes

Contact Us

3115 N 3rd Ave
G130
Phoenix, AZ 85013

602-266-8500

Stay in touch on our social channels!
Twitter
Facebook
LinkedIn
State of Arizona Contract # ADSPO18-210228

Copyright © 2021 Interface Technical Training. All Rights Reserved.

Interface Live Training Terms and Conditions Terms of Use Microsoft Subscription Terms and Conditions Privacy Policy WIOA Policy

We are OPEN! All live classes 100% available with RemoteLive!Learn More
+ +