BTCtalksender

import csv
import time
import json
from bitcoinrpc.authproxy import AuthServiceProxy

#Address to connect with local wallet running as rpc server
url = "http://user:pass@localhost:50554/"

#Setup connection and check balance
conn = AuthServiceProxy(url)
data = conn.getbalance()
print data

#Open output file for recording transaction ids
outputtx = open('outputtxRound3.txt', 'w')
outputtx.write('{0}, {1}, {2}, {3}\n'.format("list#", "userid", "useraddress", "tx id"))

#Run through list of all addresses and only add ones not banned
goodlist = []    #the list of good addresses
with open('TALK.csv', 'rb') as alladdresses:
    reader = csv.reader(alladdresses)
    for row in reader:
        #All bad address have a note in column 5, so if its length is short it's good
        if len(row[5]) < 2:
            goodlist.append(row)
        else:
            print "Banned!!!", row

#Run through the goodlist and send coins to each address, make note of tx, and wait
for idx, val in enumerate(goodlist):
    #Make val idx variables explicit
    userid = val[0]
    useraddress = val[1]
    #Check is address is valid
    print "Validating user {0} @ {1}".format(userid, useraddress)
    isvalid = conn.validateaddress(useraddress)[u'isvalid']
    if isvalid == True:
    #Use the following line instead of the preceding one if the script crashes and you need to restart
    #if isvalid == True and idx+1 > 824:
        time.sleep(3)
        #Send coins
        try:
            print "Sending coins to {0} @ {1}".format(userid, useraddress)
            senttx = conn.sendtoaddress(useraddress, 4.20, 'test airdrop 3', 'test airdrop 3')
            print "coins sent!"
            time.sleep(18)
        except:
            print "Failed!"
            senttx = 'FAILED TX - RPC interface error'
            time.sleep(18)
    elif isvalid != True and idx+1 > 824:
        print "Bad address!!!"
        senttx = 'FAILED TX - invalid address'
    else:
        senttx = 'pass'

    #Log user info and tx id
    outputtx.write('{0}, {1}, {2}, {3}\n'.format(idx+1, userid, useraddress, senttx))

#Close output file
outputtx.close()

#Check balance again
data = conn.getbalance()
print data