Concern Support
asked on
SP 2013 - Copy and paste from excel to Quick edit view - Managed Meta data columns
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,
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,
ASKER
Thanks.
Can you recommend any third party tools?
Can you recommend any third party tools?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks I'll have a look at that.
Cheers,
Cheers,
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