Import of Word Documents to ServiceNow Knowledge base

[welterp]

I am trying to import Word Documents to ServiceNow Knowledge Articles with out losing any images. I have tried using the Word Cleaner and SED installs without any success. Is there any fix that works?

[Goran WitchDoc]

We are in the start of going over to ServiceNow and this script will help us alot and save many hours of importing KB-articles into the system 😃

[Alex125]

The script from Michel Conter worked fine in Calgary. But no longer when we switched to Eureka Patch 8. Pictures are attached but the image links in the article missing the attachments sys_id 😞

So pictures are not showing..

Any idea?

[jnicolosi]

I had to make some changes to get this to work in eureka.   Looks like there is a lot that is no longer needed:

This is the version of the script that worked for me:

var gdt = new GlideDate();   

       gdt.addDays(2);   

       //current.valid_to = gdt;   

       var desc = email.subject;   

       desc = desc.replace("Knowledge:","");   

       current.short_description = desc.trim();   

       current.workflow_state = "draft";   

       current.topic = "General";   

       //current.category = "";   

       current.roles = "knowledge";   





       //Find and replace the image tags with the proper source.   

       //Get the number of attachments so the loop can be exited   

       //so it will stop no mater what.   

       var currentCount = 0;   

       var newBody = email.body_html;   

       var emailuid = email.uid;

       var searchBody = email.body_html.replace(/\n/g, " ");   





       var regex = /<img(.*?)>/ig;   

       var match;   

       var match2;   

       while(match = regex.exec(searchBody)){   

           //Add a style float tag next to the align tag.   

           var alignText = match[0].replace(/align=['"]?left['"]?/gi, 'align="left" style="FLOAT: left"');   

           alignText = alignText.replace(/align=['"]?right['"]?/gi, 'align="right" style="FLOAT: right"');   

           searchBody = searchBody.replace(match[0], alignText);   

           var regex2 = /src=("(.)*?"|'(.)*?'|(.)*?\s+$)?/ig;   

/*           while(match2 = regex2.exec(alignText)){   

           findAndReplaceImage(match2[1].replace(/\s+$/,"").replace(/"+/g,"").replace(/'+/g,""));   

           } */



           currentCount += 1;   

           if(currentCount >= 100)   

           break;   

       }   

       searchBody = searchBody.replace(/<o:p>(.*?)<\/o:p>/ig, "");   

       currentCount = 0;   

       var regex2 = /<!--\[if(.*?)<!\[endif\]-->/ig;   

       while(match = regex2.exec(searchBody)){   

           searchBody = searchBody.replace(match[0], "");   

           currentCount += 1;   

           if(currentCount >= 100)   

           break;   

       }   

       currentCount = 0;   

       var regex2 = /<!\[if !vml\]>(.*?)<!\[endif\]>/ig;   

       while(match = regex2.exec(searchBody)){   

           searchBody = searchBody.replace(match[0], match[1]);   

           currentCount += 1;   

           if(currentCount >= 100)   

           break;   

       }   





       //gs.log("Create Morning Post: " + searchBody);   





       current.text = searchBody;   





       current.insert();   





       event.state="stop_processing";   



/*           

       function getEmailSYSID(emailuid) {   

           var em = new GlideRecord('sys_email');   

           em.addQuery('uid', emailuid);   

           em.query();   

           while(em.next()) {   

               //we execute the return only within a certain time difference between the creation of the attachment and now (in seconds)   

               var dif = gs.dateDiff(em.sys_created_on, gs.nowNoTZ(), true);   

               if(dif < 300 && dif > -300){   

                   return em.sys_id;   

               }   

           }   

           return "";   

       } 





       function findAndReplaceImage(imageText){   

           var img = imageText;   

           var imgName = img.substring(4, img.search(/@/i));   

           var imgCode = "sys_attachment.do?sys_id=";   

           //Get the sys_id of the attachment   

           var gr = new GlideRecord("sys_attachment");   

           gr.addQuery("file_name", imgName);   

           gr.addQuery("table_sys_id", getEmailSYSID(email.uid));   

           gr.query();   

           if (gr.next()) {   

           imgCode += gr.sys_id;   

           }   

           searchBody = searchBody.replace(img, imgCode);   

       }   */

HTH

Joe

[Alex125]

Thanks Joe! That works indeed in Eureka!

[treed]

This answer worked for me and is tested in Fuji with 1 modification. There is a new required reference field called "Knowledge Base" for any kb_knowledge record. This needed to be added to the first segment of code with a reference to the sys_id of a "Knowledge" reference.

This sys_id was found under Knowledge Base -> Administration -> Properties

var gdt = new GlideDate(); 

       gdt.addDays(2); 

       //current.valid_to = gdt; 

       var desc = email.subject; 

       desc = desc.replace("Knowledge:",""); 

       current.short_description = desc.trim(); 

       current.workflow_state = "draft"; 

       current.topic = "General"; 

       //current.category = ""; 

       current.roles = "knowledge"; 

       current.kb_knowledge_base = 'insert_your_sys_id_here'