source: gsdl/trunk/perllib/plugins/MetadataCSVPlugin.pm@ 20605

Last change on this file since 20605 was 20000, checked in by davidb, 15 years ago

CSV filename needs to be make regular-expression 'safe' before it is used to match in metadata tables

  • Property svn:keywords set to Author Date Id Revision
File size: 5.6 KB
RevLine 
[12606]1###########################################################################
2#
[15872]3# MetadataCSVPlugin.pm -- A plugin for metadata in comma-separated value format
[12606]4#
5# A component of the Greenstone digital library software
6# from the New Zealand Digital Library Project at the
7# University of Waikato, New Zealand.
8#
9# Copyright 2006 New Zealand Digital Library Project
10#
11# This program is free software; you can redistribute it and/or modify
12# it under the terms of the GNU General Public License as published by
13# the Free Software Foundation; either version 2 of the License, or
14# (at your option) any later version.
15#
16# This program is distributed in the hope that it will be useful,
17# but WITHOUT ANY WARRANTY; without even the implied warranty of
18# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
19# GNU General Public License for more details.
20#
21# You should have received a copy of the GNU General Public License
22# along with this program; if not, write to the Free Software
23# Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA.
24#
25###########################################################################
26
[15872]27package MetadataCSVPlugin;
[12606]28
29
[15872]30use BasePlugin;
[12606]31use strict;
32
[17717]33use multiread;
[12606]34
[17717]35
[12606]36sub BEGIN {
[15872]37 @MetadataCSVPlugin::ISA = ('BasePlugin');
[12606]38}
39
40
[16386]41my $arguments = [
42 { 'name' => "process_exp",
43 'desc' => "{BasePlugin.process_exp}",
[12606]44 'type' => "regexp",
45 'reqd' => "no",
[16386]46 'deft' => &get_default_process_exp() }
[12606]47
[16386]48];
[12606]49
[16386]50
[15872]51my $options = { 'name' => "MetadataCSVPlugin",
52 'desc' => "{MetadataCSVPlugin.desc}",
[12606]53 'abstract' => "no",
54 'inherits' => "yes",
55 'args' => $arguments };
56
57
58sub new
59{
60 my ($class) = shift (@_);
61 my ($pluginlist,$inputargs,$hashArgOptLists) = @_;
62 push(@$pluginlist, $class);
63
[15872]64 push(@{$hashArgOptLists->{"ArgList"}},@{$arguments});
65 push(@{$hashArgOptLists->{"OptList"}},$options);
[12606]66
[15872]67 my $self = new BasePlugin($pluginlist, $inputargs, $hashArgOptLists);
[12606]68
69 return bless $self, $class;
70}
71
72
73sub get_default_process_exp
74{
75 return q^(?i)\.csv$^;
76}
77
78sub metadata_read
79{
80 my $self = shift (@_);
[19493]81 my ($pluginfo, $base_dir, $file, $block_hash,
82 $extrametakeys, $extrametadata, $extrametafile,
83 $processor, $maxdocs, $gli) = @_;
[12606]84
85 # Read metadata from CSV files
86 my $filename = &util::filename_cat($base_dir, $file);
87 if ($filename !~ /\.csv$/ || !-f $filename) {
88 return undef;
89 }
[15872]90 print STDERR "\n<Processing n='$file' p='MetadataCSVPlugin'>\n" if ($gli);
91 print STDERR "MetadataCSVPlugin: processing $file\n" if ($self->{'verbosity'}) > 1;
[12606]92
[16386]93 # add the file to the block list so that it won't be processed in read, as we will do all we can with it here
94 $block_hash->{'file_blocks'}->{$filename} = 1;
95
[12606]96 # Read the CSV file to get the metadata
97 my $csv_file_content;
98 open(CSV_FILE, "$filename");
99 my $csv_file_reader = new multiread();
[15872]100 $csv_file_reader->set_handle('MetadataCSVPlugin::CSV_FILE');
[12606]101 $csv_file_reader->read_file(\$csv_file_content);
102 close(CSV_FILE);
103
104 # Split the file into lines and read the first line (contains the metadata names)
[13173]105 $csv_file_content =~ s/\r/\n/g; # Handle non-Unix line endings
106 $csv_file_content =~ s/\n+/\n/g;
107 my @csv_file_lines = split(/\n/, $csv_file_content);
[12606]108 my $csv_file_field_line = shift(@csv_file_lines);
109 my @csv_file_fields = split(/\,/, $csv_file_field_line);
[13174]110 my $found_filename_field = 0;
[12606]111 for (my $i = 0; $i < scalar(@csv_file_fields); $i++) {
112 # Remove any spaces from the field names
113 $csv_file_fields[$i] =~ s/ //g;
[13174]114 if ($csv_file_fields[$i] eq "Filename") {
115 $found_filename_field = 1;
116 }
[12606]117 }
118
[13174]119 if (!$found_filename_field) {
[15872]120 print STDERR "MetadataCSVPlugin Error: No Filename field in CSV file: $filename\n";
[13174]121 return -1; # error
122 }
[12606]123 # Read each line of the file and assign the metadata appropriately
124 foreach my $csv_line (@csv_file_lines) {
125 # Ignore lines containing only whitespace
126 next if ($csv_line =~ /^\s*$/);
[13174]127 my $orig_csv_line = $csv_line;
[12606]128 # Build a hash of metadata name to metadata value for this line
129 my %csv_line_metadata;
130 my $i = 0;
131 $csv_line .= ","; # To make the regular expressions simpler
132 while ($csv_line ne "") {
133 # Metadata values containing commas are quoted
134 if ($csv_line =~ s/^\"(.*?)\"\,//) {
135 # Only bother with non-empty values
136 if ($1 ne "" && defined($csv_file_fields[$i])) {
[13174]137 if (!defined $csv_line_metadata{$csv_file_fields[$i]}) {
138 $csv_line_metadata{$csv_file_fields[$i]} = [];
139 }
140 push (@{$csv_line_metadata{$csv_file_fields[$i]}}, $1);
[12606]141 }
142 }
143 # Normal comma-separated case
144 elsif ($csv_line =~ s/^(.*?)\,//) {
145 # Only bother with non-empty values
146 if ($1 ne "" && defined($csv_file_fields[$i])) {
[13174]147 if (!defined $csv_line_metadata{$csv_file_fields[$i]}) {
148 $csv_line_metadata{$csv_file_fields[$i]} = [];
149 }
150 push (@{$csv_line_metadata{$csv_file_fields[$i]}}, $1);
[12606]151 }
152 }
153 # The line must be formatted incorrectly
154 else {
[15872]155 print STDERR "MetadataCSVPlugin Error: Badly formatted CSV line: $csv_line.\n";
[12606]156 last;
157 }
158
159 $i++;
160 }
161
162 # We can't associate any metadata without knowing the file to associate it with
[13174]163 my $csv_line_filename_array = $csv_line_metadata{"Filename"};
164 if (!defined $csv_line_filename_array) {
[15872]165 print STDERR "MetadataCSVPlugin Error: No Filename metadata in CSV line: $orig_csv_line\n";
[12606]166 next;
167 }
[13174]168 my $csv_line_filename = shift(@$csv_line_filename_array);
[12606]169 delete $csv_line_metadata{"Filename"};
170
[20000]171
[12606]172 # Associate the metadata now
[20000]173 $csv_line_filename = &util::filename_to_regex($csv_line_filename);
174
[12606]175 $extrametadata->{$csv_line_filename} = \%csv_line_metadata;
176 push(@$extrametakeys, $csv_line_filename);
177 }
178}
179
180
1811;
Note: See TracBrowser for help on using the repository browser.