Ingress Tracker is a Windows Application designed to assist agents in their fight for control of portals around the world.
The application allows you to enter your statistics from the “All Time” tab, to allow you to keep track of where you are now, and what your statistics used to be.
- Enter statistics as often as you want
- See the current badges and level that the application thinks you are
- Multi-agent per installation capability
- Define new statistics and badges dynamically when Niantic update Ingress
- Pre-loaded with stats, badges and levels from Early Feb 2015
- Ability to award non-statistic-based badges (such as Innovator) to players
- Import data from CSV file
- Predictions based on historical data for new badge awards
Install the application, and launch it. Open the Users screen, and configure the application for whoever will use it, adding in Agent name and faction. There is a default user installed automatically, but feel free to rename this or remove it when you’ve defined more users.
When you’ve finished editing the users, restart the application. If you have more than one user defined, you’ll be prompted to choose which user you wish to log in as.
You may need to update the categories, statistics, and badges defined in the application when Niantic issue updates. You can do this from the other static data screens.
Click the “Enter Stats” button to enter a new set of statistics. Click Badge Progress to get a quick run-down of your progress on all badges, and click Extra Badges to award the one-time badges such as Innovator which contribute to levelling.
- Predictions based on historical data for new level awards
- Easy export
- Read stats from photo screenshot
- Seer badge tracking
Disclaimers / Licencing / etc
This project is not officially affiliated with Ingress, or Niantic Labs at Google.
Data is currently stored in %APPDATA%\IngressTracker\data.s3db. This is a SQLite database file, with the data stored in a relational database format.
Feel free to read from this file directly if you wish to use the data for something else. However, please don’t write to this file unless you really know what you’re doing, and especially don’t touch the schema or the user_version pragma. The database is automatically created on launch if not found at that location, and automatically upgraded based on the user_version pragma in the file.
Migration from legacy spreadsheet
Ok, so this is a bit harder.
- Copy the “Badge History” sheet into a new Excel Workbook
- Unhide all columns, and delete the calculation columns. You want to keep the data you’ve entered, and the description column. On my latest copy, this is columns A, and C through T. Also delete the first row, and the very last column (“INSERT TO LEFT!”)
- Press Alt + D, P to open up the (hidden in Excel 2007+) Pivot Table wizard.
- Set the data source to be “Multiple consolidation ranges”, and produce a PivotTable – click Next.
- Tell it you’ll create the page fields, and click Next.
- Add a range which covers your data, including the column and row headers. You want zero page fields, and click Next.
- Put your new PivotTable in a new worksheet. It should appear as a whole load of 1s.
- In the bottom corner of your new PivotTable, there’s a Grand Total column. Double click the very bottom, right hand cell which is in the Grand Total column, and Grand Total row. This will add a new worksheet with your data “unpivoted”.
- Rename the column headers to “Statistic”, “Timestamp”, and “Value”, and export this as a CSV file.
- Open the Data Import screen, and load the file
- Map the statistics in the file to the statistics in the application. The application will try to do this for you, but will need double-checking.
- When it’s done, it should close the import screen automatically. You can refresh the overview screen to check everything has been calculated correctly!