CSV format datafiles |
Post Reply |
Author | |
Tensmoor
Postmaster General Joined: 07 Apr 2015 Location: Scotland Status: Offline Points: 1830 |
Post Options
Thanks(1)
Posted: 26 Jan 2021 at 21:45 |
Given the number of folks that have got in touch with me regarding problems using the XML datafiles in spreadsheets I thought I'd publish CSV versions of some of them (these are a by-product of my processing the files to put them in a database) and are updated daily at just after 00:30 Illy time each day. The datafiles are available at: https://illystuff.uk/illydata/data/csv/ The complex structure of the alliances datafile has been simplified by splitting it into three parts. alliances.csv is the main data, allianceRoles.csv is the various roles defined in each alliance and allianceRels.csv is the various diplomatic relationships for each alliance. There is also a coastalTowns.csv file which holds the full town data but only for those towns which are within 5 tiles of the coast. Each file has a description line at the start showing what fields are in each. More 'specialist' files may be added in the future. Tens
|
|
Hopper
Wordsmith Joined: 02 Jul 2016 Location: Paris, France Status: Offline Points: 144 |
Post Options
Thanks(0)
|
if anybody needs tools to extract data from xml files, I'd be ready to develop the necessary xslt transforms… (this is within my main skills, ;-) )
|
|
aka ibn(whatever), or computer science developers…
|
|
Tensmoor
Postmaster General Joined: 07 Apr 2015 Location: Scotland Status: Offline Points: 1830 |
Post Options
Thanks(0)
|
There have been problems with the csv version of the towns datafile when trying to load it into Google sheets due to the size of it (all those folks with too many cities ) so I've split this into 3 files each covering approximately 1/3 of the map. These are named towns1.csv (the northern most 1/3) to towns3.csv (the southern most 1/3). If anyone is experiencing problems using any of these files please let me know. Tens
|
|
Tensmoor
Postmaster General Joined: 07 Apr 2015 Location: Scotland Status: Offline Points: 1830 |
Post Options
Thanks(0)
|
An example google spreadsheet with each of the csv files loaded in it: https://docs.google.com/spreadsheets/d/1OFBjTtbKU7QKZej46nYLl6fkbQoVbKgscKx98hZAVqQ/edit?usp=sharing Note: This sheet is read-only. You are however free to take a copy of it yourself and that copy will be completely editable.
|
|
Tensmoor
Postmaster General Joined: 07 Apr 2015 Location: Scotland Status: Offline Points: 1830 |
Post Options
Thanks(0)
|
Updated link & new files I've now added some new csv files based on datasets I've gathered over the years and there are full descriptions of the contents of each file along with links available on Illystuff here. I'll continue addingmore files as and when I can. Tens
|
|
Post Reply | |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |