Manual:Verbot Editor Creating a CSV File

From VerbotWiki

What is a CSV file?

CSV also known as Comma Separated Value files are a standard export format for many applications, most notably is Microsoft Excel. Use the CSV format you can create data driven KnowledgeBase by entering your data by way of a spreadsheet program such as Excel or Open Office Spreadsheet. Using KnowledgeBase Template Rules you can access CSV data by Compiling or Expanding the KnowledgeBase Template.

Note: If you don't have Microsoft Excel you may want to download Open Office which includes a spreadsheet application.

Adding Data.

This section assumes you have Microsoft Excel. If you haven't done so already, open a blank Excel spreadsheet.

Image:Ve_tut_createcsv1.png

The first row is considered a heading. For this example you are going to make a Verbot phone book. So in row 1 column A enter "Name". Then in row 1 column B enter "Number". Your spreadsheet should look like the following:

Image:Ve_tut_createcsv2.png

Now that the spreadsheet has headings you can begin entering names and numbers for your friends and family. Your spreadsheet should end up looking something like this:

Image:Ve_tut_createcsv3.png

Now that you have your headings and data entered, it's time to save the file as a CSV file. Click "File"-->"Save As"

Image:Ve_tut_createcsv4.png

The following dialog box should appear. Click on the "Save as type" drop down and locate the file type: "CSV (Comma delimited)" format. Type in phone_book for the name of the file, and click the "Save" button.

Image:Ve_tut_createcsv5.png

Once your you've saved the file it's time to move on to the next section Creating a KnowledgeBase Template.