139 |
} else { |
} else { |
140 |
print STDERR "WARNING: field '$field' doesn't have 'name' attribute!"; |
print STDERR "WARNING: field '$field' doesn't have 'name' attribute!"; |
141 |
} |
} |
142 |
|
|
143 |
if ($field_name) { |
if ($field_name) { |
144 |
|
$field_name = x($field_name); |
145 |
if (! $last_field_name) { |
if (! $last_field_name) { |
146 |
$last_field_name = x($field_name); |
$last_field_name = $field_name; |
147 |
return $last_field_name; |
return $last_field_name; |
148 |
} elsif ($field_name ne $last_field_name) { |
} elsif ($field_name ne $last_field_name) { |
149 |
$last_field_name = x($field_name); |
$last_field_name = $field_name; |
150 |
return $last_field_name; |
return $last_field_name; |
151 |
} |
} |
152 |
} |
} |
170 |
($s,$se,$d,$i) = (0,1,0,0); |
($s,$se,$d,$i) = (0,1,0,0); |
171 |
} elsif (lc($type) =~ /^lookup/) { |
} elsif (lc($type) =~ /^lookup/) { |
172 |
($s,$se,$d,$i,$il) = (0,1,0,0,1); |
($s,$se,$d,$i,$il) = (0,1,0,0,1); |
173 |
|
} elsif ($type) { |
174 |
|
print STDERR "WARNING: unknown type: $type\n"; |
175 |
} |
} |
176 |
return ($s,$se,$d,$i,$il); |
return ($s,$se,$d,$i,$il); |
177 |
} |
} |
641 |
my $lookup_file = $cfg -> val($database, 'lookup_newfile'); # optional |
my $lookup_file = $cfg -> val($database, 'lookup_newfile'); # optional |
642 |
if ($lookup_file) { |
if ($lookup_file) { |
643 |
#tie %lhash, 'GDBM_File', $lookup_file, &GDBM_NEWDB, 0644; |
#tie %lhash, 'GDBM_File', $lookup_file, &GDBM_NEWDB, 0644; |
644 |
|
if (! -e $lookup_file) { |
645 |
|
open(LOOKUP, "> $lookup_file") || die "can't create $lookup_file': $!"; |
646 |
|
close(LOOKUP); |
647 |
|
} |
648 |
tie %lhash, 'TDB_File', $lookup_file, TDB_CLEAR_IF_FIRST, O_RDWR, 0644; |
tie %lhash, 'TDB_File', $lookup_file, TDB_CLEAR_IF_FIRST, O_RDWR, 0644; |
649 |
print STDERR "creating lookup file '$lookup_file'\n"; |
print STDERR "creating lookup file '$lookup_file'\n"; |
650 |
# delete memory cache for lookup file |
# delete memory cache for lookup file |
815 |
for(my $iC = $oWorksheet->{MinCol} ; defined $oWorksheet->{MaxCol} && $iC <= $oWorksheet->{MaxCol} ; $iC++) { |
for(my $iC = $oWorksheet->{MinCol} ; defined $oWorksheet->{MaxCol} && $iC <= $oWorksheet->{MaxCol} ; $iC++) { |
816 |
my $cell = $oWorksheet->{Cells}[$iR][$iC]; |
my $cell = $oWorksheet->{Cells}[$iR][$iC]; |
817 |
if ($cell) { |
if ($cell) { |
818 |
$row->{int2col($iC)} = $cell->Value; |
# this conversion is a cludge. |
819 |
|
# Files from Excell could have |
820 |
|
# characters which don't fit into |
821 |
|
# destination encoding. |
822 |
|
$row->{int2col($iC)} = $utf2cp->convert($cell->Value) || $cell->Value; |
823 |
} |
} |
824 |
} |
} |
825 |
|
|