How to Update the SharePoint 2013 Term Store by Importing it from an Excel 2013 Spreadsheet
Changing your Region Settings
The first thing you need to do is make sure your region setting are formatted correctly. This is because the file format used by the SharePoint Term Store is a csv. This converts table using the “List separator” in your PC’s region settings. If you don’t set these first you have difficulty opening and converting the spreadsheet to and from a csv file format.The csv extension literally stands for Comma Separated Values.
Change the “List separator” from a semi-colon to a comma
- Open “Control Panel”
- Click “Region” or “Region and Language”, depending on your Windows operation system
- Click “Additional settings…”
- Change:
a. Decimal symbol . (full stop)
b. List separator , (comma)
Both need to change. It seems to conflict if you just change the “List separator” and not both. If they are both comma’s, the csv conversion returns semi-colon’s. - Click “OK”
- Click “OK”
For another article on the same, see here: http://akbaraji.wordpress.com/2012/05/29/the-comma-and-semicolon-issue-in-excel-due-to-regional-settings-when-open-csv-file/
Import the csv sample template from SharePoint 2013 Term Store
- Open SharePoint 2013
- Click the cog (Site Actions), top right corner
- Select “Site Settings”
- Click “Term store management”, under “Site Administration”
- Select the Managed Metadata Service application, on the left tree view
- Click “View a sample import file”, on the right (properties pane)
- Click “Save”
Working on the Terms
- Open this file (ImportTermSet.csv) with Excel 2013.
If all the region setting are correct, it will open correctly, in the correctly formatted columns.
To see the raw csv, you can open it in Notepad.
For more on the Managed metadata input file format, here: http://technet.microsoft.com/en-us/library/ee424396.aspx
Compare Excel spreadsheet with Term Store
What will the spreadsheet going to look like in the Term Store?
Save to csv
If you have competed creating the terms in Excel and have the spreadsheet in xlsx format and you want to re-save it to into csv format.- Open Excel 2013
- Click "File" tab, on the Ribbon
- Select "Save As", on the left
- Click "Browse"
- Select the file type: CSV (Comma delimited) (*.csv)
- Give the file a relative name
e.g. ImportTermSetNew
Import csv to SharePoint 2013 Term Store
Remember permission. The authentication account which you use to access the Term Store Management Tool, must be listed as a "Term Store Administrator", or you will not be able to accomplish this task.
- Open SharePoint 2013
- Click the cog (Site Actions), top right corner
- Select “Site Settings”
- Click “Term store management”, under “Site Administration”
- Select the Managed Metadata Service application, on the left tree view
- On the left, in the tree view, select the “Term Group” you would like to upload to.
- Select “Import Term”
e.g.: Test Term Group - Click “Browse”
- Choose the relevant csv file
e.g.: ImportTermSetNew.csv - Click “OK”
0 komentar:
Posting Komentar