[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

SP 2013 - Copy and paste from excel to Quick edit view - Managed Meta data columns

Posted on 2014-04-23
4
Medium Priority
?
2,133 Views
Last Modified: 2014-04-24
Hi,

I'm trying to migrate a meta data from an excel spreadsheet to a SP 2013 document library. The columns are managed meta data columns with pre defined terms matching the data in the excel spreadsheet.

However I cannot copy and paste data from excel via Quick Edit in the doucment library without getting the following error "The data returned from the tagging UI was not formatted correctly"

http://i.imgur.com/1bqpMPA.jpg

This happens even when I remove all formatting or paste to notepad first.

Are there any simple solutions to this issue?


Thanks,
0
Comment
Question by:concern_support
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 50
ID: 40017130
Hello,

you cannot copy/paste managed metadata columns like text or numbers. The underlying structure with managed metatdata is a lot more complex than just the text that the user sees in the form.

Managed metadata items are identified by internal, underlying IDs. These will only be created properly if the metadata is selected in the form field.

There are third party solutions that offer tools to bulk edit items and apply managed metadata values.

You can probably write code to apply a range of values from an Excel sheet to a batch of list items in SharePoint.

But the bottom line is: it is not as simple as copying a range of Excel cells and pasting them into a SharePoint view.

This requires code. Either your own or a 3rd party tool's.

cheers, teylyn
0
 

Author Comment

by:concern_support
ID: 40019700
Thanks.

Can you recommend any third party tools?
0
 
LVL 50

Accepted Solution

by:
Ingeborg Hawighorst (Microsoft MVP / EE MVE) earned 2000 total points
ID: 40019719
For bulk classifying my employer uses Metavis Information Manager. This tool can be used to bulk upload and/or apply metadata to list items, including managed metadata columns.

I would not particularly "recommend" it. It has its flaws and annoyances but it gets the job done and the support staff are responsive.
0
 

Author Comment

by:concern_support
ID: 40020304
Thanks I'll have a look at that.

Cheers,
0

Featured Post

Will your db performance match your db growth?

In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
With its various features, Office 365 can not only help you with your day-to-day business tasks, it can also do wonders for your marketing campaign.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

656 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