Ylands:Game logic - Data set

Description

Data set allows to store spreadsheet data in a form of a game logic. Data can be imported from an external CSV file.

Properties

Dataset properties after file import

File

• Star icon - creates a template .csv file with item property format examples
• Folder icon - select a file for import

Once an external file is selected, it's name can be found written next to icons. To load the contents of the file, use the IMPORT button on the bottom of the properties window.

Delimiter

Select the column delimiter symbol from the drop down menu. You can choose from comma, semicolon or space, but make sure the data format reflects your choice. To set a delimiter of the .csv file, please consult your spreadsheet application of choice documentation.

Number of rows

Read only - displays the row count of the imported data

Columns

Read only - lists the name, data type and index of the imported data columns

CSV format

Regardless of the intended use of the data, some rules apply in creating the .csv file. First row of the table is reserved for the column names and the first column of the table for the row names.

To visualize the effect on the imported data, we can use the example DATA_SET.csv created by the star icon in the properties and compare it to how it is structured in a text editor or spreadsheet application. Note that related instructions now list these names in their Row and Column drop-down menus.

Related instructions

• Get Row Count
• Get Column Count
• Get/Set Value

---