Skip to end of metadata
Go to start of metadata

You are viewing an old version of this content. View the current version.

Compare with Current View Version History

« Previous Version 10 Next »

Using Excel to create a .csv file

If you use Microsoft Excel to create a .csv file, the file should contain 5 columns with the titles in the cells A1, B1, C1, D1, E1 as primary question, question variations, voice text, chat text, guid respectively.

As shown in the below image, each type will have a guid to uniquely identify the primary questions.

Using Notepad to create a .csv file

If you use Notepad to create the .csv file, the first line should have the titles.

primary question, question variations, voice text, chat text, guid

Comma-separated values should be given in the same order as described above.

For example:

primary question,question variations,voice text,chat text,guid
What is cancer,"What do you know about cancer,What do you mean by the term cancer,What is the definition of cancer,What is cancer","<p>Cancer is unwanted growth of cells</p>
",,fmlJse
What are the symptoms of cancer,"How do i know if i have cancer?,How do i know if someone has cancer?,What are the symptoms of cancer ,What are the symptoms of cancer","<p>The symptoms depends on the type of cancer</p>
",,hitlsX
What is covid?,"What is corona?,What is the definition of corona?,What is the definition of covid?,What is covid?","<p>Covid is a respiratory infection.</p>
","<p>Covid is a respiratory infection</p>
",NnZthT
What is the treatment of cancer,"How do you treat cancer?,How to get rid of cancer?,What is the treatment of cancer","<p>Chemotherapy is one of the ways you can treat cancer</p>
",,ofZXYP
What is the treatment for Covid,"how to get rid of covid ?,how to overcome covid ?,What is the treatment for Covid","<p>No specific treatment yet.</p>
",,zlHejb
What is diabetes,"What do you know about diabetes?,What do you know about the term diabetes?,What is diabetes","<p>Diabetes is increased levels of glucose in your body</p>
",,jfvdED
What are the symptoms of covid?,"What are the symptoms of covid ,What are the symptoms of covid?","<p>symptoms of covid</p>
",,jSEgMx

GUID

The GUID is an autogenerated 6 character ID that is used to uniquely identify a primary question.

  • If the given GUID doesn't exist in the project, Orbita Answers will create a new primary question and the corresponding content and will assign the specified GUID to it.

  • If the GUID exists, the associated primary question and its contents will be updated with the new content from the .csv file.

If you manually create the .csv file, you also can leave the GUID column empty. Upon bulk add, Orbita Answers will create a new primary question and the corresponding content. A GUID will be automatically assigned to it.

Exporting an Existing KB as CSV

Select an existing knowledge base that you’d like to export. From the Advanced tab, click “Export” button from the section titled “Export a .csv”

  • When we import a KB using a new custom schema, rather than its original type, we will only import the data for the properties that are common. Other new properties will be ignored in the target location during import.

  • When we create a KB using a custom schema, the user-defined properties will be exported in customData.propertyNameformat. For example, If we have the properties firstName, and location in the custom schema, the exported CSV header will be

primary question

question variations

voice text

chat text

guid

customData.location

customData.firstName

It is recommended to have unique GUIDs for creating new primary questions and the corresponding content.

Related Articles

  • No labels