Exporting our transactions from blockchain and searching for ring members into csv files

In this example, it is shown how to export our transactions from the blockchain into a csv file. This can be very useful for making summaries or reports of our incoming and outgoing (when spend key is given) transactions.

Also it shows how we can search in which transactions used our outputs as its ring members.

Compilation on Ubuntu 22.04

Compile latest Monero

Download and compile recent Monero into your home folder as shown in the following link:

https://github.com/moneroexamples/monero-compilation#example-compilation-of-master-branch-ie-development-version-of-monero-on-ubuntu-2004

Compile the transactions-export

Once the Monero is compiles, the transactions-export can be downloaded and compiled as follows:

# go to home folder if still in ~/monero
cd ~

# download the source code
git clone https://github.com/moneroexamples/transactions-export.git

# enter the downloaded sourced code folder
cd transactions-export

# make a build folder and enter it
mkdir build && cd build

# create the makefile
cmake ..

# altearnatively can use: cmake -DMONERO_DIR=/path/to/monero_folder ..
# if monero is not in ~/monero

# compile
make

Program options

[mwo@arch cmake-build-debug]$ ./xmr2csv -h
xmr2csv, export all your transactions into csv file:
  -h [ --help ] [=arg(=1)] (=0)         produce help message
  -a [ --address ] arg                  monero address string
  -v [ --viewkey ] arg                  private view key string
  -s [ --spendkey ] arg                 private spend key string
  -t [ --start-height ] arg             start from given height
  -n [ --no-of-blocks ] arg (=0)        number of blocks to search starting 
                                        from start-height
  -d [ --start-date ] arg               start roughly from given date: 
                                        yyyy-mm-dd
  -c [ --out-csv-file ] arg (=xmr_report.csv)
                                        name of outputs csv file
  -r [ --out-csv-file2 ] arg (=xmr_report_ring_members.csv)
                                        name of outputs csv file for file 
                                        containing  out outputs as ring members
  -r [ --out-csv-file3 ] arg (=xmr_report_ring_members_freq.csv)
                                        name of outputs csv file for file 
                                        containing frequencies of outputs as 
                                        ring members
  -r [ --out-csv-file4 ] arg (=xmr_report_key_images_outputs.csv)
                                        name of outputs csv file for file 
                                        containing all key images scanned with 
                                        the referenced output public keys
  -b [ --bc-path ] arg                  path to lmdb blockchain
  --testnet [=arg(=1)] (=0)             is the address from testnet network
  -m [ --ring-members ] [=arg(=1)] (=0) search where our outputs are as ring 
                                        members
  --all-outputs [=arg(=1)] (=0)         save all outputs, whether they are ours
                                        or not
  --all-key-images [=arg(=1)] (=0)      save all key_images, whether they are 
                                        ours or not, with referenced output 
                                        public keys

Getting our outputs using address and viewkey

For testing of the viewer, one can use official address and viewkey of the Monero, i.e.,

Address: 44AFFq5kSiGBoZ4NMDwYtN18obc8AemS33DBLWs3H7otXft3XjrpDtQGv7SqSsaBYBb98uNbr2VBBEt7f2wfn3RVGQBEP3A
Viewkey: f359631075708155cc3d92a32b75a7d02a5dcf27756707b47a2b31b21c389501

./xmr2csv -a 44AFFq5kSiGBoZ4NMDwYtN18obc8AemS33DBLWs3H7otXft3XjrpDtQGv7SqSsaBYBb98uNbr2VBBEt7f2wfn3RVGQBEP3A -v f359631075708155cc3d92a32b75a7d02a5dcf27756707b47a2b31b21c389501 -c ./current.csv

Monero forum donation,

Address: 45ttEikQEZWN1m7VxaVN9rjQkpSdmpGZ82GwUps66neQ1PqbQMno4wMY8F5jiDt2GoHzCtMwa7PDPJUJYb1GYrMP4CwAwNp
Viewkey: c9347bc1e101eab46d3a6532c5b6066e925f499b47d285d5720e6a6f4cc4350c

./xmr2csv -a 45ttEikQEZWN1m7VxaVN9rjQkpSdmpGZ82GwUps66neQ1PqbQMno4wMY8F5jiDt2GoHzCtMwa7PDPJUJYb1GYrMP4CwAwNp -v c9347bc1e101eab46d3a6532c5b6066e925f499b47d285d5720e6a6f4cc4350c -c ./forum.csv

Old Monero donation address:

Address: 46BeWrHpwXmHDpDEUmZBWZfoQpdc6HaERCNmx1pEYL2rAcuwufPN9rXHHtyUA4QVy66qeFQkn6sfK8aHYjA3jk3o1Bv16em
Viewkey: e422831985c9205238ef84daf6805526c14d96fd7b059fe68c7ab98e495e5703

./xmr2csv -a 46BeWrHpwXmHDpDEUmZBWZfoQpdc6HaERCNmx1pEYL2rAcuwufPN9rXHHtyUA4QVy66qeFQkn6sfK8aHYjA3jk3o1Bv16em -v e422831985c9205238ef84daf6805526c14d96fd7b059fe68c7ab98e495e5703 -c ./old.csv

Searching txs which use our outputs as ring members and their frequency

Just add -m flag. This will produce xmr_report_ring_members.csv and xmr_report_ring_members_frew.csv files (default names) which contain the list of txs which use our outputs, and frequency of outputs use, respectively. To speed up the search we can use -t flag to specify starting block.

Example 1 (Monero project donation address)

./xmr2csv -t 00580000 -m -a 45ttEikQEZWN1m7VxaVN9rjQkpSdmpGZ82GwUps66neQ1PqbQMno4wMY8F5jiDt2GoHzCtMwa7PDPJUJYb1GYrMP4CwAwNp -v c9347bc1e101eab46d3a6532c5b6066e925f499b47d285d5720e6a6f4cc4350c

Example frequency list output:

Most frequent outputs used as ring members are:
 - <6c04b7393d223b4c3b35493219c6a4d9bb37b6739c9a22193394d5e81964b5a3>: 12 times with ring sizes of 3_3_4_23_3_3_3_3_5_11_5_21
 - <da3cbc0bb751e938d058c556f3c1a3ce215231c04d834f99e6a603c67d17648a>: 11 times with ring sizes of 3_3_3_5_4_3_4_3_5_5_5
 - <d442396157c8bbf8175964c4de41f9a5f1b0afda9feca952e9837d82e8a0b8fd>: 11 times with ring sizes of 3_3_3_5_3_3_5_3_41_5_5
 - <51897c55c3b25daae30bf04cc8cebacddf559fb0cb6f4194f1e292931b57c29a>: 10 times with ring sizes of 4_3_3_3_3_5_10_3_3_5
 - <3ae472a405ffb000fa14cb380a5408cdebe25610ab16ced17cc9cf601dcf3860>: 10 times with ring sizes of 26_11_4_9_13_11_4_3_5_11
 - <04782e24ca5c944f0d4bb764fd3b95c6b6f59144ee2a3c7530a2269e4a19a650>: 10 times with ring sizes of 1_27_21_26_11_3_5_3_3_3
 - <435d2667c93dd7f5960d02cb920ee8db8fda693dd699e1c659703bf1fc359a86>: 10 times with ring sizes of 3_3_5_5_3_5_5_21_5_5
 - <0c6eec50b66c9a453ba6ad7b5228d3d224d187cd53ef215076d55d2347018969>: 10 times with ring sizes of 3_5_5_3_5_3_3_5_5_5
 - <253641711e995282ecd9182a862d474a782b2d642369dd4759e4c81dd8c117e7>: 10 times with ring sizes of 26_5_5_5_3_3_3_3_3_5

Example 2 (Monerujo project donation address)

./xmr2csv -t 01381000 -m -a 4AdkPJoxn7JCvAby9szgnt93MSEwdnxdhaASxbTBm6x5dCwmsDep2UYN4FhStDn5i11nsJbpU7oj59ahg8gXb1Mg3viqCuk -v b1aff2a12191723da0afbe75516f94dd8b068215f6e847d8da57aca5f1f98e0c