Export list of all KB to Excel

Maria_jandtMaria_jandt Customer IT Monkey ✭
Hi, 
I tried to export all KB articles to Excel to get a list of them. We need to have the owner column and category column but they only shows binary, we do not get the user id or categoryname.
Anyone have an idea så populate a list with all kb articles, with owner, category etc.

Regards
Maria

Best Answer

Answers

  • Roland_KindRoland_Kind Partner Advanced IT Monkey ✭✭✭
    It depends how you create the export - did you made a SQL query ? if yes - can you post the query
  • Maria_jandtMaria_jandt Customer IT Monkey ✭
    edited June 19
    select ArticleID, Title, VendorArticleID, Owner, Category from KnowledgeArticle

    ArticleID, Title, VendorArticleID are OK
    But, Owner and category onlys shows binary code, i guess they get the data from Another table, which one I don´t know.,


  • Maria_jandtMaria_jandt Customer IT Monkey ✭
    Perfect! :) owner now works. But Category still is in binary.
  • Roland_KindRoland_Kind Partner Advanced IT Monkey ✭✭✭
    edited June 19

    strange ... in my dev. env this works ;)

    on the right side "Hardware" ...

    314 test  roki FE31BC1E-FD34-99C1-351E-218702F2A58C Hardware

    what is your default language .. is it english ? 

    try changing "ENU" to your default language ... e.g. "DEU" for german

  • Maria_jandtMaria_jandt Customer IT Monkey ✭
  • Justin_WorkmanJustin_Workman Cireson Support Ninja IT Monkey ✭✭✭✭
    The 'DisplayString' is the category.  In your select statement do "CatStr.DisplayString AS 'Category'" and omit kb.Category.
  • Maria_jandtMaria_jandt Customer IT Monkey ✭
    Thanks for your help!  :)

     
Sign In or Register to comment.