How can i Get all downloaded for month or uploaded?

There have been some overly complicated instructions for using the earnings calculator floating around in this topic. Some may stem from earlier version, others just from misconceptions about it only working for docker installs. The earnings calculator does not care how your node is installed, it only needs access to (a copy of) the bandwidth.db, storage_usage.db and piece_spaced_used.db files. Since it is a python script, you need python installed on your system, which is available for any common OS.

Some misconceptions:

  • You need docker (As mentioned by @Vadim) : Not true, the calculator works just fine on windows nodes, just point to a folder with a recent copy of your bandwidth.db, storage_usage.db and piece_spaced_used.db files.
  • You need windows subsystem for linux (As mentioned by @Enzo) : I see no reason to use this roundabout way. Python is available for windows and when it’s installed these commands work just fine from Command Prompt or PowerShell.
  • You need to install SQLite3 (As mentioned by @Alexey) : Older versions used the SQLite3 binary, but since version 5.2.0 this script uses the Python SQLite3 package that has been included with Python since Python v2.5.

This is all you actually need to do:

  • Install python for your OS
  • Stop your node
  • Copy bandwidth.db, storage_usage.db and piece_spaced_used.db to the same folder as where you placed the python script
  • Start your node again
  • Run the command: python earnings.py

I try to make things as easy to use as possible, if any of this doesn’t work for you, please report back on the earnings calculator topic here.

1 Like

As StorJ api gives all needed information,may be it is time to make it on web base not geting information from database? as api also give information about data alocated every day.
Next step put it information to Dashboaed

As far as I’m aware the api does not provide historic information. That’s one of the important features for the earnings calculator as it provides you with a way to compare actual payouts to that months stats. Since payouts happen during the next month, the official web dashboard and API don’t help there.
I agree that this information should ideally be provided on the official storagenode web dashboard though.

2 Likes

does db contain all node history?

For most data, yes.
Though storage history was not collected by the node prior to September 2019, so for months before that you’ll get a warning in the calculator that clarifies why that data is missing.

I can’t guarantee Storj won’t add a cleanup of old data at some point though, but for now it’s there in the db files.