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,
But the issue is in Article Body the Images is not Visible(Please find the below screenshot).
Please help me to Solve the Issue.
Note: Display Attachment Checkbox is checked
Best Regards,
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?
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
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.
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.
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
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?
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
Hi Robert,
Thanks for your reply,
I have imported the KB version data as well.
But I am not able to see the Version in Knowledge Table.
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.
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.
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
