create account

DOES ANYONE OUT THERE KNOW HOW TO GENERATE A CSV REPORT OF STEEM WALLET DATA? by papa-pepper

View this thread on: hive.blog |  peakd.com |  ecency.com
steem · @papa-pepper ·
$2.80
DOES ANYONE OUT THERE KNOW HOW TO GENERATE A CSV REPORT OF STEEM WALLET DATA?
https://s8.postimg.cc/i34yybqb9/123444.jpg

## <center>This is just another thing outside of my skill set that I was hoping someone in the community could help out with.</center>

------ 

I realize that many people out there in the steemit community are more technologically advanced, so if you are one of them, or if you know one of them, please let me know if you've got an answer to this question. I'll try to make it simple, short, and to the point.


http://i.imgur.com/uVNBbyL.jpg

## <center>CAN ANYONE GENERATE A STEEM REWARDS CSV FILE?</center>
##


Last year, there were resources that no longer exist. As @jesta mentioned [**in this post**](https://steemit.com/taxes/@jesta/steem-rewards-history-csv-exporter-via-steemdata-com) from last year, by using [**a small set of aggregation queries**](https://github.com/aaroncox/steemdata-reward-history) that he shared on GitHub he was able to generate CSV reports. However, the problem now is that it used **SteemData**, which @furion [**shut down last year.**](https://steemit.com/steemdata/@furion/steemdata-is-shutting-down-on-may-1st)

At the moment, I am still "technological roadkill," so I'm hoping that someone out there may be able to assist. I'm not sure if anyone will be able to, but I figured that I would ask. Thanks everyone!

http://i.imgur.com/uVNBbyL.jpg



#### <center>Until next time…</center>
## 
# <center>STEEMIT LIKE YOU MEAN IT!</center>


<center>https://steemitimages.com/640x0/https://homesteaderscoop.com/wp-content/uploads/2018/11/coop-logo-website.png</center>
### <center>Want to sell sustainable, handmade products in the Homesteaders Co-op?</center>
#### <center>[Learn more and apply here](https://homesteaderscoop.com/sell/)</center>
##
# <center>[Visit the Pepper Family Homestead Store here!](https://homesteaderscoop.com/store/pepper-family-homestead/)</center>
##
## <center>[My First Book Available is Here!](https://www.amazon.com/dp/1517698774)</center>
##
πŸ‘  , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , and 406 others
properties (23)
authorpapa-pepper
permlinkdoes-anyone-out-there-know-how-to-generate-a-csv-report-of-steem-wallet-data
categorysteem
json_metadata{"tags":["steem","steemit","help","programming","technology"],"users":["jesta","furion"],"image":["https://s8.postimg.cc/i34yybqb9/123444.jpg","http://i.imgur.com/uVNBbyL.jpg","https://steemitimages.com/640x0/https://homesteaderscoop.com/wp-content/uploads/2018/11/coop-logo-website.png"],"links":["https://steemit.com/taxes/@jesta/steem-rewards-history-csv-exporter-via-steemdata-com","https://github.com/aaroncox/steemdata-reward-history","https://steemit.com/steemdata/@furion/steemdata-is-shutting-down-on-may-1st","https://homesteaderscoop.com/sell/","https://homesteaderscoop.com/store/pepper-family-homestead/","https://www.amazon.com/dp/1517698774"],"app":"steemit/0.1","format":"markdown"}
created2019-02-19 17:04:48
last_update2019-02-19 17:04:48
depth0
children10
last_payout2019-02-26 17:04:48
cashout_time1969-12-31 23:59:59
total_payout_value2.242 HBD
curator_payout_value0.559 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length1,957
author_reputation1,951,223,832,091,597
root_title"DOES ANYONE OUT THERE KNOW HOW TO GENERATE A CSV REPORT OF STEEM WALLET DATA?"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id80,106,886
net_rshares5,699,645,802,978
author_curate_reward""
vote details (470)
@akipponn · (edited)
Last year I made a small Ruby script to scrape data from steemd.com as Steem Data wasn’t available any more as you wrote. But it certainly stresses steemd.com so I just kept it for my personal use.

I think similar thing can be done with SteemSQL [https://steemsql.com](https://steemsql.com) a paid database service that provides data on Steem blockchain in traditional database format.

I wanted to work on this since last year but our family had cold for long and now it may be the time ;)

Posted using [Partiko iOS](https://steemit.com/@partiko-ios)
properties (22)
authorakipponn
permlinkakipponn-re-papa-pepper-does-anyone-out-there-know-how-to-generate-a-csv-report-of-steem-wallet-data-20190219t180947309z
categorysteem
json_metadata{"app":"partiko","client":"ios"}
created2019-02-19 18:09:48
last_update2019-02-19 18:10:33
depth1
children0
last_payout2019-02-26 18:09:48
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length553
author_reputation547,037,159,241,304
root_title"DOES ANYONE OUT THERE KNOW HOW TO GENERATE A CSV REPORT OF STEEM WALLET DATA?"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id80,109,669
net_rshares0
@arcange ·
$0.07
Assuming you have an active [SteemSQL subscription](https://steemsql.com), you can use a free MS-SQL client like [HeidiSQL](https://www.heidisql.com) and issue the following SQL query:

```
SELECT
    *
FROM
    TxTransfers
WHERE
    [from] = 'papa-pepper'
    OR [to] = 'papa-pepper'
ORDER BY
    timestamp
```
<br>
Right click on the result and "Export grid rows" as CSV and you're done!
It should not require more than 10 minutes.
πŸ‘  ,
properties (23)
authorarcange
permlinkre-papa-pepper-does-anyone-out-there-know-how-to-generate-a-csv-report-of-steem-wallet-data-20190219t231440504z
categorysteem
json_metadata{"tags":["steem"],"links":["https://steemsql.com","https://www.heidisql.com"],"app":"steemit/0.1"}
created2019-02-19 23:14:42
last_update2019-02-19 23:14:42
depth1
children2
last_payout2019-02-26 23:14:42
cashout_time1969-12-31 23:59:59
total_payout_value0.056 HBD
curator_payout_value0.018 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length433
author_reputation1,146,633,779,972,293
root_title"DOES ANYONE OUT THERE KNOW HOW TO GENERATE A CSV REPORT OF STEEM WALLET DATA?"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id80,119,896
net_rshares142,582,651,968
author_curate_reward""
vote details (2)
@papa-pepper · 
Thanks!
properties (22)
authorpapa-pepper
permlinkre-arcange-re-papa-pepper-does-anyone-out-there-know-how-to-generate-a-csv-report-of-steem-wallet-data-20190220t022120157z
categorysteem
json_metadata{"tags":["steem"],"app":"steemit/0.1"}
created2019-02-20 02:21:27
last_update2019-02-20 02:21:27
depth2
children0
last_payout2019-02-27 02:21:27
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length7
author_reputation1,951,223,832,091,597
root_title"DOES ANYONE OUT THERE KNOW HOW TO GENERATE A CSV REPORT OF STEEM WALLET DATA?"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id80,125,487
net_rshares0
@sallybeth23 · 
So Cool @arcange
properties (22)
authorsallybeth23
permlinkre-arcange-re-papa-pepper-does-anyone-out-there-know-how-to-generate-a-csv-report-of-steem-wallet-data-20190219t234359037z
categorysteem
json_metadata{"tags":["steem"],"users":["arcange"],"app":"steemit/0.1"}
created2019-02-19 23:44:00
last_update2019-02-19 23:44:00
depth2
children0
last_payout2019-02-26 23:44:00
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length16
author_reputation284,926,055,139,511
root_title"DOES ANYONE OUT THERE KNOW HOW TO GENERATE A CSV REPORT OF STEEM WALLET DATA?"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id80,120,716
net_rshares0
@dwells · 
(left hand on hip with elbow to the side chest puffed out, right arm extended upward with hand pointing towards the sky)
>"This looks like a job for.............somebody else cus I had to Google what is a CSV file."
properties (22)
authordwells
permlinkre-papa-pepper-does-anyone-out-there-know-how-to-generate-a-csv-report-of-steem-wallet-data-20190219t171237557z
categorysteem
json_metadata{"tags":["steem"],"app":"steemit/0.1"}
created2019-02-19 17:12:39
last_update2019-02-19 17:12:39
depth1
children1
last_payout2019-02-26 17:12:39
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length215
author_reputation2,311,227,928,120
root_title"DOES ANYONE OUT THERE KNOW HOW TO GENERATE A CSV REPORT OF STEEM WALLET DATA?"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id80,107,373
net_rshares0
@simms50 ·
$0.03
HAHAHAHA!!! Now I did already know what a CSV file was but I really enjoyed your comment!!!
πŸ‘  ,
properties (23)
authorsimms50
permlinkre-dwells-re-papa-pepper-does-anyone-out-there-know-how-to-generate-a-csv-report-of-steem-wallet-data-20190219t172054182z
categorysteem
json_metadata{"community":"busy","app":"busy/2.5.6","format":"markdown","tags":["steem"],"users":[],"links":[],"image":[]}
created2019-02-19 17:20:54
last_update2019-02-19 17:20:54
depth2
children0
last_payout2019-02-26 17:20:54
cashout_time1969-12-31 23:59:59
total_payout_value0.020 HBD
curator_payout_value0.006 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length91
author_reputation17,988,269,869,339
root_title"DOES ANYONE OUT THERE KNOW HOW TO GENERATE A CSV REPORT OF STEEM WALLET DATA?"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id80,107,781
net_rshares53,066,512,004
author_curate_reward""
vote details (2)
@fbslo ·
$0.05
Use Steemworld.org --> Transfer search
πŸ‘  
properties (23)
authorfbslo
permlinkre-papa-pepper-does-anyone-out-there-know-how-to-generate-a-csv-report-of-steem-wallet-data-20190219t182722646z
categorysteem
json_metadata{"tags":["steem"],"app":"steemit/0.1"}
created2019-02-19 18:27:21
last_update2019-02-19 18:27:21
depth1
children1
last_payout2019-02-26 18:27:21
cashout_time1969-12-31 23:59:59
total_payout_value0.036 HBD
curator_payout_value0.012 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length38
author_reputation163,373,705,640,602
root_title"DOES ANYONE OUT THERE KNOW HOW TO GENERATE A CSV REPORT OF STEEM WALLET DATA?"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id80,110,297
net_rshares94,610,903,960
author_curate_reward""
vote details (1)
@freebornangel · 
Yep
properties (22)
authorfreebornangel
permlinkre-fbslo-re-papa-pepper-does-anyone-out-there-know-how-to-generate-a-csv-report-of-steem-wallet-data-20190219t183119700z
categorysteem
json_metadata{"tags":["steem"],"app":"steemit/0.1"}
created2019-02-19 18:32:03
last_update2019-02-19 18:32:03
depth2
children0
last_payout2019-02-26 18:32:03
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length3
author_reputation171,005,551,503,977
root_title"DOES ANYONE OUT THERE KNOW HOW TO GENERATE A CSV REPORT OF STEEM WALLET DATA?"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id80,110,455
net_rshares0
@flemingfarm · (edited)
$0.04
https://steemit.accusta.tk/

https://steemit.com/utopian-io/@semasping/accusta-for-steem-export-to-csv-block-listener-v1-2-1
πŸ‘  
properties (23)
authorflemingfarm
permlinkre-papa-pepper-does-anyone-out-there-know-how-to-generate-a-csv-report-of-steem-wallet-data-20190219t182240648z
categorysteem
json_metadata{"tags":["steem"],"links":["https://steemit.accusta.tk/","https://steemit.com/utopian-io/@semasping/accusta-for-steem-export-to-csv-block-listener-v1-2-1"],"app":"steemit/0.1"}
created2019-02-19 18:22:42
last_update2019-02-19 18:24:33
depth1
children1
last_payout2019-02-26 18:22:42
cashout_time1969-12-31 23:59:59
total_payout_value0.036 HBD
curator_payout_value0.002 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length124
author_reputation1,386,216,174,737,200
root_title"DOES ANYONE OUT THERE KNOW HOW TO GENERATE A CSV REPORT OF STEEM WALLET DATA?"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id80,110,117
net_rshares94,631,424,192
author_curate_reward""
vote details (1)
@papa-pepper · 
Thanks for that. I'll look into it.
properties (22)
authorpapa-pepper
permlinkre-flemingfarm-re-papa-pepper-does-anyone-out-there-know-how-to-generate-a-csv-report-of-steem-wallet-data-20190219t182629172z
categorysteem
json_metadata{"tags":["steem"],"app":"steemit/0.1"}
created2019-02-19 18:26:30
last_update2019-02-19 18:26:30
depth2
children0
last_payout2019-02-26 18:26:30
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length35
author_reputation1,951,223,832,091,597
root_title"DOES ANYONE OUT THERE KNOW HOW TO GENERATE A CSV REPORT OF STEEM WALLET DATA?"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id80,110,260
net_rshares0
Help/Feedback