5 use Data::Dump qw/dump/;
6 use Algorithm::CheckDigits;
9 my $ferweb_csv = 'report_62836_1026_Aktivni_studenti.csv';
10 my $new_dateexpiry = '2013-10-31';
12 die "$ferweb_csv : $!" unless -r $ferweb_csv;
14 my $c = DBI->connect("dbi:CSV:","","", { RaiseError => 1, f_ext => '.csv', f_encoding => 'utf-8', csv_sep_char => ';' }) || die $dbi::errstr;
15 my $k = DBI->connect("dbi:mysql:database=koha_fer","","", { RaiseError => 1, AutoCommit => 0, mysql_enable_utf8 => 1 }) || die $DBI::errstr;
17 my $ferweb_table = $ferweb_csv;
18 $ferweb_table =~ s/\.csv//i;
20 my $s = $c->prepare(qq{
21 select * from $ferweb_table
25 my $user_exists = $k->prepare(qq{
26 select * from borrowers where cardnumber = ?
29 my $insert_user = $k->prepare(qq{
31 (cardnumber, categorycode, userid, firstname, surname, branchcode, email, dateexpiry)
33 (?,'S',?,?,?,'SRE',?,'2021-12-13')
36 my $update_dateexpiry = $k->prepare(qq{
44 while( my $row = $s->fetchrow_hashref ) {
46 # warn "# row = ",dump($row),$/;
48 $user_exists->execute( 'S' . $row->{jmbag} );
50 if ( $user_exists->rows ) {
51 my $user = $user_exists->fetchrow_hashref;
52 # warn "# koha borrower = ",dump($user);
55 $update_dateexpiry->execute( $new_dateexpiry, 'S' . $row->{jmbag} );
56 } elsif ( ! $row->{nick} ) {
57 warn "NEW (without nick) ",dump($row);
58 $stat->{new_no_nick}++;
61 warn "NEW: ",dump($row);
62 $insert_user->execute( 'S' . $row->{jmbag}, $row->{nick}, $row->{ime}, $row->{prezime}, $row->{email} );
77 warn "# stat ", dump( $stat ),$/;