Export/extract Knowledge Base articles?

chanel65 · ‎08-13-2014

Hi,

Does anyone know a way of exporting or extracting the Knowledge Base without using XML and thereby losing the attachments?

Our customer preferably wants the extracted articles in an editable format.

The articles in the KB are a mix of plain text and plain text with PDF, Doc and PPT attachments.

Thankful for any help as we have not found any solution either here in the community, on Share or by asking in HI.

Kind Regards,

Christer

williamsun · ‎08-13-2014

There is no easy way to do this.

I have tried and failed. Someone else might have a script that does this nicely with an FTP, but for the volume I did it with I preferred to download and store all the attachments manually.

robpickering · ‎08-13-2014

It won't help you now, but we standardized on having all attachments (mostly images) put into a KB Article to be named with the number of the KB article they were attached to. This now allows us to pull them all out of the attachments table and be able to associate them back to the articles they were attached to.

chanel65 · ‎08-14-2014

Thank you both for your answers! (Even if I had hoped for a more positive answer. )

@Rob

How do you pull them from the attachments table?

Kind Regards,

Christer

robpickering · ‎08-14-2014

sys_attachment_doc.list

Personalize to include "Sys attachment", this is the name of the document.

Export -> XML

Parse accordingly with an XML parser.

Alternatively you can export to a CSV, but it will still require some work to convert the Base-64 encoded data to binary.