Knowledge Base

Import glossary

Article ID: 311
Last updated: 10 Oct, 2023

If you already have a list of terms and definitions that you would like to use in your knowledgebase, you can upload these terms in bulk.

The process is

  • Create a file of glossary items to import
  • Upload a test sample to the system
  • Import.

Create a file of glossary items to import

First, you need to create your file of articles. This is a comma-separated (CSV) text file that consists of a phrase, followed by a definition.

  • Both fields must be included, and they must be in the order of glossary item name (phrase) first, and then the text that explains it
  • Place the data for each glossary item onto a single line, and separate each field by a comma. Include a space after the comma. If you choose to use something else other than a comma, update the field terminated by field under CSV options to match.
Field Type/size M/O Comments
phrase varchar(100) M The maximum size of a phrase is 100 characters
definition text M
id int(10) O Record ID. If this record ID already exists in the database KBPublisher will skip the record. It will not overwrite an existing ID.
date_updated timestamp O Defaults to time imported to knowledgebase.
highlight_once tinyint(1) O Defaults to 0.
active tinyint(1) O Defaults to 1.

Create a test file

Don't try to upload the whole file without testing it first. If something goes wrong you may then have to delete all those half-imported glossary items and try again. Create a test file and run that first.

  • Copy, say, the first three lines of your text import to a separate file
  • Either:
    • Save the file to a local drive (e.g. somewhere on your c: drive)
    • Upload the file to the server

Import the test file

You are now ready to import the test file to KBPublisher.

  • Click on the Import menu
  • Click on the Import Glossary tab
  • If the import file is on your c: drive (or another local drive),
    • Choose Load Data Local File in the SQL Load Command field
    • Browse for the CSV file on your drive and load it
  • If the import file is on the server,
    • Choose Load data file
    • Type the address where the file is located into the Path to file field on CSV file line
  • Change CSV options if required.
  • Click Load

On completion of the load, you will see a message at the top of the Import Articles screen telling you how many files were imported successfully and how many were skipped.

  • If the upload was successful, click on the Articles tab to check out the articles.

Fix any problems

All going well, you should now have three new glossary items in your knowledgebase. Check them carefully and ensure that everything worked as you expected. If you had problems, delete these, fix the test file and run it again. Keep fine-tuning until it works, and then update the real file to match the fixes you made in the test file.

You are now ready to import the rest of the glossary.

Import articles

Import the rest of the glossary using the same process as for the test file, only this time using the real data file.

Note:

  • If the glossary item already exists, a new item will still be uploaded.  We recommend you do not duplicate.
  • If any unique keys will be duplicated during import, records from cvs file will be ignored.

----------------------------------------------------------------------
This functionality works in version 4.0 and above

Article ID: 311
Last updated: 10 Oct, 2023
Revision: 4
Access: Public
Views: 7546
Comments: 0
Also read

Also listed in