Back Filling

You can back fill data into your database from other killboards by running the backfill.py script. Before doing so however, you'll need to define at least one killboard to fetch data from in the killboards table. Specify the URL including the idfeed parameter for EDK boards,

~~~~~~
insert into pykb.killboards(url) values('http://eve-kill.net/?a=idfeed');
~~~~~~

Then to back fill data for your corporation or alliance:

~~~~~~
./backfill.py -C 'War Tribe'
[2012-05-13 08:30:08,607]: INFO - Starting...
[2012-05-13 08:30:08,711]: INFO - Requesting kills after 1 inclusive
[2012-05-13 08:30:08,712]: INFO - http://eve-kill.net/?a=idfeed&allkills=1&corpname=War+Tribe&lastintID=80000
[2012-05-13 08:30:09,633]: INFO - 50 kill mails retrieved.
[2012-05-13 08:30:09,714]: INFO - Finished processing.
[2012-05-13 08:30:09,724]: INFO - Pausing for 1800 seconds
~~~~~~

It'll pull the oldest 50 kills every 30 minutes followed by the next oldest set until nothing else is returned or there's an error. So run it manually and let it go for a while until it catches up eventually as it'll pause between fetches for 30 minutes as recommended by EVE-Kill. You can adjust this for other EDK boards by updating the killboards table.

Once caught up, just schedule a cron job to have it launch perhaps twice a day to catch up. It'll pause as needed until no more data is returned.

If you want, you can override the id it starts with:

~~~~~~
./backfill.py -C 'War Tribe' -S 80000
[2012-05-13 08:30:08,607]: INFO - Starting...
[2012-05-13 08:30:08,711]: INFO - Requesting kills after 80000 inclusive
[2012-05-13 08:30:08,712]: INFO - http://eve-kill.net/?a=idfeed&allkills=1&corpname=War+Tribe&lastintID=80000
[2012-05-13 08:30:09,633]: INFO - 50 kill mails retrieved.
[2012-05-13 08:30:09,714]: INFO - Finished processing.
[2012-05-13 08:30:09,724]: INFO - Pausing for 1800 seconds
~~~~~~

You can backfill the data for a particular character as well:

~~~~~~
./backfill.py -n Khorkrak -S 2
[2012-05-13 19:45:35,562]: INFO - Starting...
[2012-05-13 19:45:35,668]: INFO - Requesting kills after 2 inclusive
[2012-05-13 19:45:35,669]: INFO - http://eve-kill.net/?a=idfeed&allkills=1&lastintID=2&pilotname=Khorkrak
[2012-05-13 19:45:50,026]: INFO - 50 kill mails retrieved.
[2012-05-13 19:45:50,582]: INFO - kill: 0, 2009-07-02 21:42:00, Xerpex, Rifter saved.
[2012-05-13 19:45:51,551]: INFO - kill: 0, 2009-06-06 21:32:00, Khorkrak, Megathron saved.
[2012-05-13 19:45:51,643]: INFO - kill: 0, 2009-06-06 01:33:00, Khorkrak, Imicus saved.
~~~~~~

Just let it go until it ends.