Solved

Import taxonomy fields from Sharepoint Document library into SQL database

Posted on 2014-11-21
1
125 Views
Last Modified: 2015-04-29
I have a document library on my Sharepoint 2013 site with various properties, where some of them are of the type Managed Metadata, taxonomy.
I need to import those items and all of their properties into sql database.
I tried to use the Odata source to import the data from the sharepoint document  library, but none of the managed metadata columns seems to be imported. How could I achive this?
0
Comment
Question by:gosi75
1 Comment
 
LVL 18

Accepted Solution

by:
SimonAdept earned 500 total points
ID: 40471063
Looks like it might be a struggle :(

You've probably seen these links already if you've Googled the issue...
http://msdn.microsoft.com/en-us/library/office/hh147179%28v=office.14%29.aspx
https://gallery.technet.microsoft.com/office/ExportImport-the-Taxonomy-b41dfddb
http://underthehood.ironworks.com/2011/10/sharepoint-2010-how-to-backuprestore-managed-metadata-from-one-farmenvironment-to-another.html

Sorry, I can't help beyond providing the links above. The last link included a comment that suggested a code-free way of migrating the metadata to another farm.
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now