Is it possible to copy over a table format KB article and import them into the Cireson KB database?

Stuart_OwenStuart_Owen Customer IT Monkey ✭


We are working on migrating our existing Knowledge base articles and converting them into Cireson's Knowledge base portal.  We have them setup in a table format and would like to know if it is possible to Import tables into the knowledge base database?

We've made a few tables in Cireson portal from scratch and manually copied and pasted the information from our existing knowledge articles, but I would like to see if there is a way to copy the entire table and insert it into the knowledge base user information or Analyst tab.

We would like to see if there is a way or workaround to import these tables without manually creating new tables within Cireson portal and performing a manual copy and paste which is heavily time consuming.


Best Answers

  • Stuart_OwenStuart_Owen Customer IT Monkey ✭
    Accepted Answer
    We are in the process of coping over and Pasting the content as we don't want to import into SCSM then transfer through an API script to Cireson Portal as there are too many variables that it could error out or import incorrectly and create more work for our team. Thanks for the Help Justin 

Answers

  • Justin_WorkmanJustin_Workman Cireson Support Ninja IT Monkey ✭✭✭✭
    edited March 2
    @Stuart_Owen
    There's a script here that might help you get started.  It's migrating articles from the OOB SCSM  KnowledgeBase, but it's got all the bits for inserting new articles with the API.  If you would like to provide a sample of an existing article, maybe I can help rewrite the script to fit what you need.
    https://community.cireson.com/discussion/2458/copying-kb-articles-from-the-scsm-database
    Thanks @john_doyle ;)
  • Stuart_OwenStuart_Owen Customer IT Monkey ✭
    We currently have been extracting the articles and reformatting them from SCSM and currently have them all stored in a OneNote Notebook with in a 2X6 table format. We don't want to double the work by reinserting them back into SCSM and then converting them over into the Cireson portal.

    Is there a way to just copy the table like the one below and insert it into the Cireson portal without creating new tables for each article and copying and pasting all of the content?



  • Justin_WorkmanJustin_Workman Cireson Support Ninja IT Monkey ✭✭✭✭
    @Stuart_Owen
    If it was just text, maybe we could run through a CSV and build KB articles using the API.  But getting the text and images would be a pretty big challenge.  In the long run, it may be easier to copy/paste.
  • Stuart_OwenStuart_Owen Customer IT Monkey ✭
    Accepted Answer
    We are in the process of coping over and Pasting the content as we don't want to import into SCSM then transfer through an API script to Cireson Portal as there are too many variables that it could error out or import incorrectly and create more work for our team. Thanks for the Help Justin 
  • Adam_DzyackyAdam_Dzyacky Customer Contributor Monkey ✭✭✭✭✭
    edited March 29
    @Stuart_Owen
    ...But getting the text and images would be a pretty big challenge...

    Actually! That's pretty doable actually through a little known OneNote and Office 365 trick. In short, if you open the OneNote notebook on Onedrive in your browser, the OneNote web app performs an inline Base64 image conversion for you.

    As such, you can copy from the OneNote web app and paste directly into the Cireson KA preserving all images as they are embedded strings.


Sign In or Register to comment.