Exporting Keywords
You can export Keywords contained in Contacts from the Content Management system into a Comma Separated Value (CSV) file.
Before you begin
- To export Keywords from Contacts in an Address Book in a Publication, you need Contact Management rights and Read permissions for the selected Address Book.
- To export Keywords from the (All Contacts) node, or in any Address Book in System Administration, you need System Administrator rights.
- To export Keywords from Contacts in a Distribution List, you need Distribution List Management rights and Read permissions for the Outbound E-mail Folder.
About this task
The data in the exported Keywords file is formatted as follows:
- a comma is used as field delimiter
- double quote is used as text qualifier
- carriage return line-feed (CrLf) is used as a row separator
- the file is encoded in UTF-8.
You can export Keywords contained in Contacts from any Address Book or Distribution List in the system. The export can contain all Keywords in all Contacts in an Address Book or Distribution List , or you can filter the Contact list first before exporting.
An SDL Tridion Sites System Administrator can perform an export of all Keywords used in Contacts in the system from the (All Contacts) node in System Administration.
Procedure
- Open the Content Manager Explorer.
- Navigate to the node.
- To export Keywords used in Contacts to a .CSV file, do one of the following:
- To export Keywords in all Contacts of a specific Distribution List or Address Book, select the Distribution List or Address Book and either select Export Keywords from the context menu or click the Export Keywords icon in the toolbar.
- To export Keywords in a filtered selection of members of a specific Distribution List or Address Book, perform a Contacts search and click the Export Keywords icon. For more information, see Searching Contacts.
- In the File Download dialog, click Save.
- In the standard Windows Save File dialog that appears, select a location on your file system, enter a name for the file and click Save.
Results
Columns and rows of data are created in the export file. The following columns are created:
KEYWORDCATEGORYPUBLICATION- Contact Identification fields
Each Keyword for a selected Contact is stored in a separate row.