[Tutorial] Data Sets

[Shadow72 187]

    So what do data sets do? Data sets allow you to import spreadsheets into Ylands. They are perfect for keeping the mess down when working with large amounts of data and are actually quite easy to use. To use them you will need a program to create and edit a spreadsheet(I use google sheets). Lets get started!

    The very top row of your spreadsheet is where you set the names of all the columns. The first column must be named Id(at least I think, i'm still not too sure). You need to increment the id column for each row you add starting at 0. The rest of the columns you can name whatever you want. I named one Text. Be aware that you cannot have any empty cells in a row with data in it. If you do you will have errors when importing it into Ylands. You also cannot have any formatting. 

 

    Once you have created your spreadsheet it is time to download it. For google sheets you go to file > download > comma-separated values(.csv). For excel you want to go to Save As, and for the Save as select "CSV (Comma Delimited)"(Thank you @Valour4Eva).

Now it is time to import it into Ylands. Place down a Data Set game logic in your world and click on the folder in the properties window.

It will bring up a folder on your computer and you want to copy your .csv file into it. After copying your file you want to go back to Ylands and close the properties window for the dataset and reopen it. Under the file drop down you will now be able to select the file you just made. Click the import button and now you are ready to start using the data set!

Here is an example of getting data from a dataset.

And here is an example of looping through a data set.

 

If you run into any issues or have any questions feel free to ask me for help. Ill try and respond as soon as possible.

Edited November 3, 2020 by Shadow72
Added how to save spreadsheet in excel

[ocnoglittle 760]

Thank you for making this tutorial!

[jchob 354]

uh, i got "cannot load file" error. 
Maybe i had different delimiters on csv file and ylands options
I will try it again. 

Thanks a lot for this ?

[Shadow72 187]

2 minutes ago, jchob said:

uh, i got "cannot load file" error. 
Maybe i had different delimiters on csv file and ylands options
 I will try it again. 

Thanks a lot for this ?

If you want you can send me a pic of your spreadsheet and I can see if I can spot the issue.

[spiritchaser28 920]

Fantastic tutorial! I had no idea you could even do this! I can imagine this being a time saver in editor.

[Valour4Eva 75]

Nice tutorial shadow! As far as how to do that with excel, you just save the dataset you want to incorporate into ylands as a CSV shown below:

Edited November 3, 2020 by Valour4Eva

[Valour4Eva 75]

On 10/28/2020 at 3:16 PM, Shadow72 said:

The first column must be named Id(at least I think, i'm still not too sure).

Just wanted to mention I tested this real quick by naming it "Row" and it works, so It doesn't need to be named ID.

[kodedo 3]

Hi, great tutorial thank you for sharing.

Edited April 14 by kodedo