Running noark5-validator/src/importExtraction.php on Debian and MySQL

[Ole Aamot]

I sucessfully installed the Noark5 database with noark5-validator in a
MySQL database on Debian unstable.

On Debian, install the package mysql-client, php-mysql and php-doctrine-dbal

root at linux:/# apt-get install mysql-client
root at linux:/# apt-get install php-mysql
root at linux:/# apt-get install php-doctrine-dbal

Checkout noark5-validator from github.com:

oka at linux:~/src$ git clone https://github.com/KDRS-SA/noark5-validator.git
oka at linux:~/src$ cd noark5-validator/src/

In noark5-validator/src/importExtraction.php, enter a new MySQL database:

    $conn = array(
        'driver' => 'pdo_mysql',
        'user' => 'noark5',
        'host' => 'localhost',
        'password' => '<your_password>',
        'charset' => 'utf8',
        'driverOptions' => array(1002=>'SET NAMES utf8'),
        'dbname' => 'noark5'
    );

Enter the noark5-validator/src directory and run the script

oka at linux:~/src/noark5-validator/src$ php importExtraction.php
-d$HOME/src/noark5-validator/src/resources/test-uttrekk/uttrekk1/n5uttrekk/
-t=noark5 -v=31 -s=y
-i$HOME/src/noark5-validator/src/resources/test-uttrekk/uttrekk1/info.xml
PHP Warning:  Declaration of
ArkivstrukturDBImporter::preProcessFile($classType) should be compatible
with ArkivstrukturParser::preProcessFile() in
/home/oka/src/noark5-validator/src/handler/ArkivstrukturDBImporter.php on
line 4
PHP Warning:  Declaration of
ArkivstrukturDBImporter::preProcessRecord($classType) should be compatible
with ArkivstrukturParser::preProcessRecord() in
/home/oka/src/noark5-validator/src/handler/ArkivstrukturDBImporter.php on
line 4
PHP Warning:  Declaration of
ArkivstrukturDBImporter::postProcessFile($classType) should be compatible
with ArkivstrukturParser::postProcessFile() in
/home/oka/src/noark5-validator/src/handler/ArkivstrukturDBImporter.php on
line 4
PHP Warning:  Declaration of
ArkivstrukturDBImporter::postProcessRecord($classType) should be compatible
with ArkivstrukturParser::postProcessRecord() in
/home/oka/src/noark5-validator/src/handler/ArkivstrukturDBImporter.php on
line 4
DocumentDescription::__toString id[],
systemId[2872a56c-7e3a-416c-8cad-3ffb9e8f49ce]
DocumentDescription::__toString id[],
systemId[2872a56c-7e3a-416c-8cad-3ffb9e8f49ce]
DocumentDescription::__toString id[],
systemId[942486fd-c763-47c2-a75c-48a62a727e81]
DocumentDescription::__toString id[],
systemId[6a71028c-5023-4768-95bf-733a706ae06e]

This creates 52 Noark5 tables and populates the MySQL database with noark5
tables and the data in
noark5-validator/src/resources/test-uttrekk/uttrekk1/info.xml

mysql> show tables;
+-------------------------------+
| Tables_in_noark5              |
+-------------------------------+
| author                        |
| basic_file_storage_location   |
| basic_record                  |
| basic_record_author           |
| basic_record_comment          |
| basic_record_keyword          |
| basic_record_storage_location |
| case_file                     |
| case_file_precedence          |
| case_party                    |
| class                         |
| class_keyword                 |
| classification_system         |
| classified                    |
| comment                       |
| conversion                    |
| correspondence_part           |
| cross_reference               |
| deletion                      |
| disposal                      |
| disposal_undertaken           |
| document_description          |
| document_description_author   |
| document_description_comment  |
| document_object               |
| electronic_signature          |
| file                          |
| file_comment                  |
| file_keyword                  |
| fonds                         |
| fonds_creator                 |
| fonds_fonds_creator           |
| fonds_storage_location        |
| keyword                       |
| meeting_file                  |
| meeting_participant           |
| meeting_record                |
| precedence                    |
| record                        |
| record_case_party             |
| record_correspondence_part    |
| record_document_description   |
| record_sign_off               |
| registr_entry_precedence      |
| registry_entry                |
| screening                     |
| series                        |
| series_classfication_system   |
| series_storage_location       |
| sign_off                      |
| storage_location              |
| workflow                      |
+-------------------------------+
52 rows in set (0.01 sec)

Best,
Ole Aamot
-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://lists.nuug.no/pipermail/nikita-noark/attachments/20170520/2f541ed4/attachment.htm