There are a couple of fields where you cant use normal display values, for example the status property, when you import knowledge articles you cant use “Draft” you will have to use “10F171DF-3AB1-648D-D151-D83A5171DD7B” in the CSV file. That is because the knowledge form use StringIds then there is a “translation table” in the database to translate the string into the correct work and language. So how do you get hold of these values?
\nThey are all in the LocalizedText table in the Service Manager database. For example to get the StringID for draft status you can run the following query<\/p>\n
It will give you a result like this<\/p>\n As you can see there are different values for different languages. When you need to get StringIds for your values you will need to check in this table. During my test I found that you need to do this for status, tag and\u00c2\u00a0category.<\/p>\n There are two\u00c2\u00a0other intresting properties, \u00c2\u00a0AnalystContent and EndUserContent. When you use these two with the CSV import feature is looking for files in the C:\\Program Files\\Microsoft System Center\\Service Manager 2010 folder (default path). The content in these two files will be uploaded to the corresponding text field in the knowledge article form.<\/p>\n \u00c2\u00a0 and the XML file used with the CSV file<\/p>\n Travis Wright in the Service Manager product team has written a good post<\/a> with more info about this.<\/p>\n","protected":false},"excerpt":{"rendered":" This week I have tested to import knowledge into Service Manager. Knowledge can be used for example as guides in the self service portal for end-users, system documentation for engineers or troubleshooting guides for service desk personnel. One of the ways to get knowledge into Service Manager is to use the CSV import feature.\u00c2\u00a0The CSV … Continue reading SELECT [LTStringId]
\n,[LanguageCode]
\n,[LTStringType]
\n,[ManagementPackId]
\n,[ElementName]
\n,[MPElementId]
\n,[SubElementName]
\n,[LTValue]
\n,[TimeAdded]
\n,[LastModified]
\n,[DisplayStringId]
\nFROM [ServiceManager].[dbo].[LocalizedText] WHERE ElementName LIKE '%knowledge%status%draft%'<\/code><\/p>\n![\"\"](\"http:\/\/contoso.se\/blog\/wp-content\/uploads\/2010\/02\/SMImpKnowledge01.jpg\" "\\"SMImpKnowledge01\\"")
<\/a><\/p>\n<\/a><\/p>\n
\nThe following is a example of a CSV file and a XML file I used to import a knowledge article. If you save them to a folder and import them into Service Manager you will get a new knowledge article with some guidelines in each text field, so you easy can identify where to put your text.<\/p>\n10F171DF-3AB1-648D-D151-D83A5171DD7B,
\nF982E5B1-7864-7FC5-D0A4-8E000C91C241,75F786E2-CAA7-E7E9-47A0-BCC714BF1EDF,ArticleOwner,Comments,
\nCreatedBy,VendorArticleID,Title,Abstract,keyword,,
\nExternalURLSource,http:\/\/www.contoso.se,
\ncomment01.txt,comment02.txt<\/code><\/p>\n<\/a><\/p>\n