Images are not Visible in Knowledge Article Body

sayan-ghosh
Tera Contributor

Hello Team,

I am trying to Import all the Published Knowledge Articles from Source Instance to Target Instance through XML.

I am able to see all the Articles are imported successfully including the Attachments,

sayanghosh_0-1743883752357.png

 


But the issue is in Article Body the Images is not Visible(Please find the below screenshot).

sayanghosh_1-1743883804510.png


Please help me to Solve the Issue.
Note: Display Attachment Checkbox is checked

Best Regards,

2 ACCEPTED SOLUTIONS

Robert H
Mega Sage

Hello @sayan-ghosh ,

 

It seems that you are using the Article Versioning feature. Have you exported and imported all the different versions of the articles, and also all the version metadata, which can be found in the kb_version table? And I hope the versioning is enabled in both the source and the target instance?

 

RobertH_0-1743885629255.png

RobertH_1-1743885747439.png

 

 

If this is not the case then things like checking out articles for editing won't work, and it might also be the reason for the issue you are describing.

 

Regards,

Robert

View solution in original post

Hello @sayan-ghosh ,

 

Let's try some basic troubleshooting:

 

Step 1: In the source instance view the Source Code of one of the affected articles and find the HTML code for one of the images. The "src" attribute should look something like "/sys_attachment.do?sys_id=...". Remember that sys_id.

RobertH_0-1743922509796.png

RobertH_1-1743922833525.png

 

 

Step 2: In the source instance go to the sys_attachment table and apply the filter "Sys ID = the sys_id you saw in step #1". Take note of the Table name (should be kb_knowledge) and Table sys ID. This should be the sys_id of the KB Article that you were looking at in step #1.

RobertH_2-1743922992026.png

 

Step 3: Now in the target instance, go to the very same KB Article and again look at the "img" attibute in the source code. The attachment sys_id should be the same as the one found in step #1.

 

Step 4: In the target instance, go to the sys_attachment table again and look up the attachment with that Sys ID. Again, the Table sys ID of that record should be the sys_id of the KB Article. And if you click on the File name of that attachment record it should download the expected picture file.

 

Please let me know if any of the things where I said "should" does not look as expected and we'll take it from there.

 

Regards,

Robert

 

 

View solution in original post

9 REPLIES 9

Hey Robert,

It works!!
Thanks!

Best Regards

@sayan-ghosh , awesome! Glad to hear your got it working.

Vishal Jaswal
Giga Sage

Hello @sayan-ghosh 

 

please validate whether imported KB article’s xml have not ended up with a KB number that already exists which means two duplicate KB numbers; if yes then just change the KB number of your imported(via xml) KB articles.


Hope that helps!

Shivalika
Mega Sage

Hello @sayan-ghosh 

 

You also need to import sys_attachment data for the knowledge records. You can add filter that table is kb_knowledge. 

 

Additionally you also need to import data from db_image table, I guess there's no filter here, you can check out. Because these two are the tables which store any images kr attachments if at all it exists. 

 

But even after copying all the attachments and images from above, the attachments and images are not coming in your instance then it means - they have been copy pasted and not done by storing somewhere in the system. 

 

In that case they are Linked with local storage and will be lost if you try to copy it somewhere else. That's the reason it's recommended to store the attachments first in any of the table and then refer it. Else it will be lost by exporting or even just you can "copy your kb article" and see it won't come. 

 

These are the only possible scenarios, there can be nothing out of it. I hope this answered your queries. 

 

Kindly mark my answer as helpful and accept solution if it helped you in anyway. This will help me be recognized for the efforts and also move this questions from unsolved to solved bucket. 

 

Regards,

 

Shivalika 

 

My LinkedIn - https://www.linkedin.com/in/shivalika-gupta-540346194

 

My youtube - https://youtube.com/playlist?list=PLsHuNzTdkE5Cn4PyS7HdV0Vg8JsfdgQlA&si=0WynLcOwNeEISQCY

 

Shivalika
Mega Sage

Hello @sayan-ghosh 

 

Please confirm if you checked my answer. Kindly mark my answer as helpful and accept solution if it helped you in anyway. This will help me be recognized for my efforts and also it can move from unsolved bucket to solved bucket. 

 

Regards, 

Shivalika 

 

My LinkedIn - https://www.linkedin.com/in/shivalika-gupta-540346194

 

My youtube - https://youtube.com/playlist?list=PLsHuNzTdkE5Cn4PyS7HdV0Vg8JsfdgQlA&si=0WynLcOwNeE