- Open up a terminal window
- Run
git clone https://github.com/dark-echo/gurgle.git
- Copy this google sheet: https://goo.gl/E3Z7mz (or create a google sheet as described below)
- In sheet, go to Tools > Script Editor
- Copy Code.gs and paste it into Script Editor. (if code not already in there)
- Run > setup
- Publish > Deploy as web app
- enter Project Version name and click 'Save New Version'
- set security level and enable service (most likely execute as 'me' and access 'anyone, even anonymously)
- Copy gurgle.ini to gurgle.local.ini
- Copy the 'Current web app URL' and put this in the "url" in gurgle.local.ini.
- Insert column names on your destination sheet matching the parameter names of the data you are passing in (exactly matching case)
- Make up a key (string), and run
md5 -s 'yourapikey'
orecho -n 'yourapikey' | md5sum
- Put the original key into gurgle.local.ini as apikey
- Put the hex string from md5/md5sum into 'api_key' in Script Editor > Project Properties > Script Properties (you'll need to add new item)
- In gurgle.local.ini, edit location name, x, y, z and distance (radius). (you can get this info from EDDB)
- Install python zmq library (for python 2, not 3).
Depending on your system, any of these might be correct:
yum install python-zmq
apt-get install python-zmq
easy_install zmq
pip install -r requirements.txt
- Run
python eddn.py
orpython2 eddn.py
and see what happens.
So far we've just run this on Linux and MacOSX, but there's no reason it shouldn't work on Windows. Get the latest python2.x and try to do the same things... Or install cygwin with md5 and python2 and you can probably follow the Linux/Mac instructions.
- A tab called "Influence", or an alternate name configured in the Script Editor.
- The included
Code.gs
provides for placing provided values into columns based on the column header. Simply add the required columns to the tab defined in step 1. - The following columns are supported:
Timestamp
- defined by EDDN message, defining when the event was created by the client in UTC.EventDate
- date extracted from TimestampEventTime
- time extracted from TimestampStarSystem
- name of the system for which the data is providedLocationX
/LocationY
/LocationZ
- system coordinatesDistance
- distance calculated for the system based on coordinates provided and configured location in gurgle.iniSystemSecurity
/SystemAllegiance
/SystemGovernment
/SystemEconomy
Population
- population, if available in the feed, else blankSystemFaction
- faction which controls the system- For each faction in the system there will be the following, where $ is replaced by 1 to 10.
Faction$Name
Faction$Influence
Faction$State
/Faction$PendingState
/Faction$RecoveringState
Faction$Allegiance
/Faction$Government