Export data for further analysis

[Ronald Legere]

Some of us in SignalCartel have been trying to learn more about how wormholes are connected (Project W). There is some speculation that there may be a pattern and they are not as random as one might think. To this end we have been collecting data (by hand) but I wonder if there is not a way to extract data from TripWire, since it has been collecting this data for some time. So the feature request: Some kind of API to extract all the data that was collected for a certain mask that I otherwise have access to. Question: How long is data kept in the database? Is it removed as soon as the wormhole 'expires'?

[Valtyr Farshield]

I'm not the developer of Tripwire, but maybe I can help by saying that you can access the list of all known wormholes to your mask by accessing this link (you have to be logged in): https://tripwire.eve-apps.com/refresh.php?mode=init

You will receive a JSON response which can be parsed by a script and useful data can be extracted from that. I use this myself for building an application which parses that data to find shortest paths. Here's an example of how it can be done if you look at the Tripwire module: https://github.com/farshield/pathfinder

The wormhole signatures are removed from the list when the user deletes them or when they expire and they can not be accessed anymore by the user. However, they are moved to a table called _history_signatures, but the purpose of this table is for providing the undo/redo functionality and not for statistical analysis. You are better off building your own database by reading the JSON list, for example once a day.

[Ronald Legere]

Someone mentioned that to me before and I forgot the url, thanks for the reminder, i think that will work just fine! Thanks also for the pathfinder example.

[Ashy]

I'm glad you've found a solution. Perhaps we can look into something more streamlined at some point though