- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-26-2021 09:22 AM
for knowledge articles, in the XML one does not find "sys ID" mentioned but rather the field "article ID"
can anyone elaborate around this construct as it differs from other record types where usually Sys ID is found on the xml as well as when exporting records.
i'm trying to test some article imports from one servicenow instance to a different customer instance in which the issue of LIKE article numbers or LIKE sys ID would be things to contend with.
in my tests thus far, i took an article xml for an existing article, then altered the ARTICLE ID to see what it does when importing, but it simply updated the existing article instead of making a duplicate as i would have expected. So this indicates that article ID is not the unique identifier but rather the sysID still is but sysID does not show in the xml or in exporting the article to excel.
thanks for your help
Solved! Go to Solution.
- Labels:
-
Knowledge Management
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-26-2021 10:23 PM
Ok, after installing Knowledge Management Advanced plugin, this article_id field appeared as both dictionary entry in the table and in XML for knowledge record. However sys_id is also in the list. Made a quick test:
- exported published KB article to XML, article ID and sys_id are there and they are the same
<article_id>c85cd2519f77230088aebde8132e70c2</article_id>
<sys_id>c85cd2519f77230088aebde8132e70c2</sys_id>
- unpublished article, modified it, published again (as v2) and exported to XML
<article_id>c85cd2519f77230088aebde8132e70c2</article_id>
<sys_id>6bce8f422f2a201003bd5e072799b65b</sys_id>
It seems article_id always refers to the original version of the article record while sys_id - to the current (latest) one.
Hope it helps
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-26-2021 10:01 AM
Without intimate knowledge of this exact use case ill try to diagnose this.
A sys_id is like the social security number of a record- a Unique id in that instance.
When you move data from one instance to another- the sys_id in the destination could already be taken in the destination.
That is why the Knwoledge id is taken so u can have a semblance of connectivity a human can recognize- as a human doesnt memorize the sys_id - a new sys_id will be created on insert in the destination table.
The only way to preserve exact sys_id is to do a clone.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-26-2021 10:05 AM
the article id = sys_id as far as i can tell unless one manipulates the xml before import.
guess i'm a little confused by your comment around readability as the article id string is no more readable than the sysid (as they are the same string)
thanks for that tip bout cloning, this is between two different company instances in which we're trying to migrate articles but dont want to overwrite existing articles.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-26-2021 10:14 AM
I may have been comfusing that Article ID for KB number.
Whats the situation in the other instance- are there old versions of the same articles or are they totally different. If they are totally different then you dont have to worry and you can always run a filter- created on last hour to see what you loaded in.
If there are old versions and some articles need to be updated from your import consider an import set that coalesces on a common field... Or even load these in a brand new Knowledgebase and have a SME curate them and keep what you need - retire a duplicate etc
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-26-2021 10:55 AM
we're trying to migrate articles from a different company's servicenow into our servicenow. So there is the possibility that the importing articles could have the same article numbers or even same sysID though i think the latter would be unlikely.
I think i'm going to have to just do a data comparison (like an excel vlookup match or something) between the articles to be imported versus what we have to resolve the like article numbers or like article ID (sys ID) and handle those differently.