Skip to content

Add in Bulk/Chatbot

You can select this tool via Tools > Add in Bulk/Chatbot

This feature lets you create a prompt that is copied to your clipboard. You can then paste this prompt into a chatbot. The chatbot's response can be copied and pasted back into the input fields here, allowing for the automatic addition or updating of terms and relations.

alt text

Create a Chatbot prompt

This will generate the prompt.

  • Output Format: Choose the format in which the chatbot will generate its response.
    • table: he chatbot will provide its output as one or two tables (one for terms and one for relations). This allows you to review and modify the data in a spreadsheet program like Excel before importing it back into TermBoard. Simply paste the table(s) into Excel, make your desired changes, and then copy and paste the adjusted table(s) into the appropriate input fields within the "Bulk add terms and relations" section. Ensure you paste the terms table into the terms input and the relations table into the relations input.
    • JSON: The chatbot will generate its response as a JSON string containing terms and/or relations. This JSON string can be directly pasted into the designated JSON input box.
  • Provide information: Based on the prompt you've chosen, you'll see additional input fields:
    • Provide the subject: This field is mandatory for this prompt. Specify the core topic for which you want the prompt to generate information. For example, entering "Car" will instruct the chatbot to create a semantic data model related to cars.
    • Provide the context: This field is optional. If the chatbot's initial response is too general, you can provide more specific context here. For instance, you could enter "Retail sales" to focus the data model on car sales rather than car parts in general.
    • Paste your text: This field will only be visible if you've selected a prompt that requires text analysis. Here, you can paste the specific text that you want the chatbot to process and extract information from.
  • GENERATE PROMPT: Press this button to generate the prompt. It is automatically added to the clipboard.

Paste prompt in a chatbot

  • This gives some handy links to different chatbots. Pick your favorite chatbot and paste the value from you clipboard (CTRL-V) into it and wait for the response

Bulk add terms and relations:

alt text

  • Paste the chatbot's response here. When using the "table" Output Format, select only the term table and paste it into the "Terms" box, and the relation table into the "Relations" box.
  • You can customise the order of the relation columns for bulk adding via Settings > Application > Set order of relations in bulk add . Ensure you configure this order before clicking the "GENERATE PROMPT" button in the preceding step.
  • If you chose "JSON" as the Output Format, a single input box will be displayed where you can paste the entire JSON response from the chatbot, simplifying the process.

TIP

This section can also be used for quickly adding or updating terms and relations manually. When "table" Output Format is selected, simply paste or type a few terms and their details into the "Terms" box, and similarly for relations in the "Relations" box.

Table Format requirements:

  • Terms: Must include a "Name" column. Optionally, you can also include "Description" and/or "Additional information" columns.
  • Relations: Must include "Source", "Target", and "Name" columns. "Source" and "Target" should contain the exact names of the terms involved in the relation.
  • In both cases, do not include the column names otherwise they will also be added as terms or relations
  • Ensure each term and relation occupies a new line, or use "\n" to indicate a line break.
  • Columns can be separated by a Tab character, pipe ( | ), semicolon ( ; ), colon ( : ), or comma ( , ). It will auto detect the used separator.

JSON format requirements:

  • The format should be: {"terms":[{"name", "description", "explanation"}], "relations":[{"source", "target", "name", "explanation"}]}
  • All objects are optional