Import glossary

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

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.

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.
Highlight once tinyint(1) O Defaults to 0.

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.

Import the test file

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

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.

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.



This functionality works in version 4.0 and above

Article ID: 311
Last updated: 17 Mar, 2011
Revision: 3
User Manual v7.0 -> Articles -> Glossary -> Import glossary