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 type, id, data, from, to respectively.

As shown in the previous image, each type will have an ID, used in Facts to uniquely identify the types of data.

Open

Using Notepad to create a .csv file

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

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

For example:

The previous comma-separated values translate into the following:

Type: fact

id: 5d2e0076d842596d00b5350c

data: "{""voice"":{""rePrompt"":"""",""sayText"":""<p>You may experience diarrhea as a result of several conditions or circumstances. Potential causes of diarrhea include:</p>\n\n<ul>\n\t<li>food intolerance, such as lactose intolerance</li>\n\t<li>food allergy</li>\n\t<li>an adverse reaction to a medication</li>\n\t<li>a viral infection</li>\n\t<li>a bacterial infection</li>\n\t<li>an intestinal disease</li>\n\t<li>a parasitic infection</li>\n\t<li>Gallbladder or stomach surgery</li>\n</ul>\n""},""screen"":{""largeImage"":"""",""smallImage"":"""",""body"":"""",""longTitle"":"""",""shortTitle"":""""},""chat"":{""rePrompt"":"""",""chatText"":""""}}"

from: 5d2df183d842596d00b53504

to: 5d2dfc1dd842596d00b5350a

Open

Related Articles