#!/usr/bin/perl
# Copyright 2001-2023 Leslie Richardson
# This file is part of Open Admin for Schools.
my %lex = ('Main' => 'Main',
'Error' => 'Error',
'Import Students' => 'Import Students',
'Export' => 'Export',
'Upload Student CSV file' => 'Upload Student CSV file',
'Error Reading Record' => 'Error Reading Record',
'The file must be a .csv file!' => 'The file must be a .csv file!',
'Maximum File Upload size exceeded!' => 'Maximum File Upload size exceeded!',
'Cannot open file' => 'Cannot open file',
'Continue' => 'Continue',
'Cannot sysopen student number file.' => 'Cannot sysopen student number file.',
'Complete' => 'Complete',
);
my $self = 'mssUploadStudentCSV.pl';
my $maxbufcount = 500; # 500k max; change as required
my $maxrecorddisplay = 5;
use DBI;
use CGI;
use Text::CSV_XS;
use Fcntl qw(:DEFAULT :flock);
eval require "../../etc/admin.conf";
if ( $@ ) {
print $lex{Error}. " $@
\n";
die $lex{Error}. " $@\n";
}
my $q = new CGI;
print $q->header( -charset, $charset );
my %arr = $q->Vars;
my $dsn = "DBI:$dbtype:dbname=$dbase";
my $dbh = DBI->connect($dsn,$user,$password);
my $csv = Text::CSV_XS->new( {binary => 1} );
# Print Page Header
my $title = qq{Upload Student CSV - MSS MyBlueprint STD};
print qq{$doctype\n$title\n};
print qq{\n};
print qq{$chartype\n\n};
print qq{[ $lex{Main} |\n};
print qq{$lex{Export} ]\n};
print qq{$title
\n};
if ( not $arr{page} ) {
showStartPage();
} elsif ( $arr{page} == 1 ) {
delete $arr{page};
importStudents();
}
#----------------
sub showStartPage {
#----------------
print qq{\n};
exit;
}
#-----------------
sub importStudents {
#-----------------
my $file = $q->param("filename");
my $name; my $ext;
my $filename = $file; # fileName is output filename, file is input.
if ( $file ) {
$filename =~ s!^.*(\\|\/)!!;
$filename = lc($filename);
@name = split /\./, $filename; # split on dots.
$ext = $name[$#name]; # last element is the extension.
unless ( $ext eq 'csv' or $ext eq 'txt' ){
print qq{$lex{'The file must be a .csv file!'}};
print qq{