CSV format datafiles

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   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

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
Tensmoor Members Profile Send Private Message Find Members Posts Add to Buddy List Postmaster General Joined: 07 Apr 2015 Location: Scotland Status: Offline Points: 1400	Post Options Post Reply Quote Tensmoor Report Post Thanks(1) Quote Reply Topic: CSV format datafiles 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 Members Profile Send Private Message Find Members Posts Add to Buddy List Wordsmith Joined: 02 Jul 2016 Location: Paris, France Status: Offline Points: 110	Post Options Post Reply Quote Hopper Report Post Thanks(0) Quote Reply Posted: 27 Jan 2021 at 19:33
	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 Members Profile Send Private Message Find Members Posts Add to Buddy List Postmaster General Joined: 07 Apr 2015 Location: Scotland Status: Offline Points: 1400	Post Options Post Reply Quote Tensmoor Report Post Thanks(0) Quote Reply Posted: 08 Mar 2021 at 09:30
	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 Members Profile Send Private Message Find Members Posts Add to Buddy List Postmaster General Joined: 07 Apr 2015 Location: Scotland Status: Offline Points: 1400	Post Options Post Reply Quote Tensmoor Report Post Thanks(0) Quote Reply Posted: 15 Mar 2021 at 02:18
	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.