X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=blobdiff_plain;f=kmig.d%2Fbin%2Fmig-export;fp=kmig.d%2Fbin%2Fmig-export;h=2920514524d2885794af3fc686a593616db9a58c;hp=314830ccb9e643cdeeab0b5ec806a55bc5a4b9ba;hb=741cd2fc924b5eea69934b888c7403795d62c050;hpb=f910e0d0a916c485dd6681c47f09348e5d6dee25 diff --git a/kmig.d/bin/mig-export b/kmig.d/bin/mig-export index 314830c..2920514 100755 --- a/kmig.d/bin/mig-export +++ b/kmig.d/bin/mig-export @@ -103,6 +103,8 @@ sub backup_authorisedvalues { open(my $fh, '>', $backupfile) or die "Could not open $backupfile!"; my $xml = XML::Writer->new(OUTPUT => $fh, DATA_MODE => 1, DATA_INDENT => 2, ); $xml->xmlDecl('UTF-8'); + $xml->startTag('document'); + $xml->startTag('authorisedvalues'); my $query = "SELECT category,authorised_value,lib,lib_opac,imageurl FROM authorised_values WHERE category != 'ITEMTYPECAT'"; my $sth = $dbh->prepare($query); @@ -117,6 +119,19 @@ sub backup_authorisedvalues { $xml->endTag('value'); } $xml->endTag('authorisedvalues'); + + $xml->startTag('categories'); + $query = "SELECT category_name FROM authorised_value_categories WHERE category_name != 'ITEMTYPECAT'"; + $sth = $dbh->prepare($query); + $sth->execute(); + while (my @row = $sth->fetchrow_array) { + $xml->startTag('value'); + $xml->dataElement('name', $row[0]); + $xml->endTag('value'); + } + $xml->endTag('categories'); + + $xml->endTag('document'); $xml->end(); close $fh; return;