{ version => '01', contest_name => 'Russian WW PSK Contest', contest_id => 'RU-WW-PSK', filter => { mode => \"IN ('PSK','PSK31','BPSK31','PSK63','BPSK63','PSK125','BPSK125')", band => \"IN('160M','80M','40M','20M','15M','10M')", }, defaults => { contest_url => 'http://www.epc-ru.ru/index.php?option=com_content&task=view&id=562&Itemid=192', log_cols => [qw/ mycall call qso_date time_on mode freq band rst_sent stx rst_rcvd srx pfx cont dxccprefix calc1 /], placeholders => [qw/ cont dxccprefix /], dropbox_options => { cont => [qw/ AF AN AS EU NA OC SA /], dxccprefix => [ sort keys %{{ do 'dxcc.inc' }} ], CATEGORY => [qw/ SOAB MOAB SOSB SOAB-R /], }, update => sub { my $row = shift; my %h; $h{srx} = sprintf '%03d', $row->{srx} unless $row->{srx} =~ /\D/; $h{stx} = sprintf '%03d', $row->{stx} unless $row->{stx} =~ /\D/; $h{calc1} = $row->{srx} if $row->{srx} =~ /\D/; # Russian Area (oblast) Code return \%h; }, Qs => [ { label => 'Own Country 10/15/20', weight => 1, group_by => 'band, mode, call', where => {dxccprefix=>$INPUT{dxccprefix},band=>[qw/10M 15M 20M/]} }, { label => 'Own Country 40/80/160', weight => 2, group_by => 'band, mode, call', where => {dxccprefix=>$INPUT{dxccprefix},band=>[qw/40M 80M 160M/]} }, { label => 'Own Continent 10/15/20', weight => 3, group_by => 'band, mode, call', where => {cont=>$INPUT{cont},dxccprefix=>{'!=' => $INPUT{dxccprefix}},band=>[qw/10M 15M 20M/]} }, { label => 'Own Continent 40/80/160', weight => 6, group_by => 'band, mode, call', where => {cont=>$INPUT{cont},dxccprefix=>{'!=' => $INPUT{dxccprefix}},band=>[qw/40M 80M 160M/]} }, { label => 'Different Continent 10/15/20', weight => 5, group_by => 'cont, band, mode, call', where => { cont=>{'!=' => $INPUT{cont}}, band=>[qw/10M 15M 20M/] } }, { label => 'Different Continent 40/80/160', weight => 10, group_by => 'cont, band, mode, call', where => { cont=>{'!=' => $INPUT{cont}}, band=>[qw/40M 80M 160M/] } }, ], mults => [ { label => 'DXCC', group_by => 'band, dxccprefix' }, { label => 'UA Areas', group_by => 'band, calc1', where => { dxccprefix=>'UA' } }, ], cabrillo => { cabrillo_url => 'http://www.epc-ru.ru/index.php?option=com_content&task=view&id=562&Itemid=192', version => '3.0', headers => [qw/ CATEGORY CLUB NAME ADDRESS OPERATORS EMAIL SOAPBOX /], qso_cols => [qw/cab_freq cab_mode cab_date cab_time mycall rst_sent stx call rst_rcvd srx /], qso_fmt => '%-5s %-2s %-10s %-04s %-10s %-3s %-3s %-13s %-3s %-3s', # --------info sent------- -------info rcvd-------- # QSO: freq mo date time call rst exch call rst exch # QSO: ***** ** yyyy-mm-dd nnnn ********** nnn *** ************* nnn *** # QSO: 3584 PO 2011-02-18 2103 SJ3AZ 599 001 RM9DAZ 599 SV # QSO: 3582 PO 2011-02-18 2105 SJ3AZ 599 002 UT1I 599 002 # 000000000111111111122222222223333333333444444444455555555556666666666777777777788 # 123456789012345678901234567890123456789012345678901234567890123456789012345678901 }, }, years => { 2011 => { sample => '', filter => { qso_date => { -between => [20110218, 20110219] }, }, }, }, }