Import af poster til M7a
Lige som ved M5 er alle importer kørt med p_file_06 der checker data (i et vist omfang).
Køretiden var ca. 12 timer.
For de meget interesserede kan alle data- og logfiler ses her
Bibliografiske poster
Fra Mads kom der følgende kommentar da han afleverede data:
... er der et enkelt problem med sorteringstegn. Desuden var der en række poster med felt 989.
Der var ikke nogen yderligere kommentarer i logfilerne fra Aleph.
Eksemplarposterne
Bjørns log havde følgende bemærkninger til posterne:
2009-12-11 07:54:31,527 [main] INFO migrateToAleph - Hz item# 4847736 (Loc: Geol, 3944155081) adding sequence 22213/20 2009-12-11 07:55:09,782 [main] WARN migrateToAleph - Hz item# 1005022 (Loc: Hist, 3622229446) unable to translate itype: pui to material type for m 2009-12-11 07:55:09,783 [main] WARN migrateToAleph - Hz item# 1005022 (Loc: Hist, 3622229446) unable to translate itype: pui to item status for m 2009-12-11 07:55:09,825 [main] WARN migrateToAleph - Hz item# 1005785 (Loc: Hist, 3622379715) unable to translate itype: pui to material type for m 2009-12-11 07:55:09,825 [main] WARN migrateToAleph - Hz item# 1005785 (Loc: Hist, 3622379715) unable to translate itype: pui to item status for m 2009-12-11 09:16:16,887 [main] WARN migrateToAleph - Hz item# 4275078 (Loc: KlaArk, 3880321391) deleting relinked item sequence from 3254948 2009-12-11 09:17:52,696 [main] WARN migrateToAleph - item:400023325363 untranslatable:SB-lyd.m-p 2009-12-11 09:17:52,696 [main] WARN migrateToAleph - item:400023325568 untranslatable:SB-lyd.m-p 2009-12-11 09:17:52,696 [main] WARN migrateToAleph - item:400021414296 untranslatable:SB-alm.kvikslt 2009-12-11 09:17:52,696 [main] WARN migrateToAleph - item:400014659968 untranslatable:SBDB.fon 2009-12-11 09:17:52,696 [main] WARN migrateToAleph - item:3900174577 untranslatable:Idraet.int 2009-12-11 09:17:52,696 [main] WARN migrateToAleph - item:400012698761 untranslatable:SB-retr.kvikkat 2009-12-11 09:17:52,696 [main] WARN migrateToAleph - item:400012998587 untranslatable:SB-retr.kvikkat 2009-12-11 09:17:52,696 [main] WARN migrateToAleph - item:400013092212 untranslatable:SB-retr.kvikkat 2009-12-11 09:17:52,697 [main] WARN migrateToAleph - item:400013092182 untranslatable:SB-retr.kvikkat 2009-12-11 09:17:52,697 [main] WARN migrateToAleph - item:400016061695 untranslatable:SB-retr.kvikkat 2009-12-11 09:17:52,697 [main] WARN migrateToAleph - item:400016193583 untranslatable:SB-retr.kvikkat 2009-12-11 09:17:52,697 [main] WARN migrateToAleph - item:405000462324 untranslatable:SB.fjernla 2009-12-11 09:17:52,697 [main] WARN migrateToAleph - item:3562419291 untranslatable:Aestet.u-ref 2009-12-11 09:17:52,697 [main] WARN migrateToAleph - item:3562419283 untranslatable:Aestet.u-ref 2009-12-11 09:17:52,697 [main] WARN migrateToAleph - item:3562419348 untranslatable:Aestet.u-ref 2009-12-11 09:17:52,697 [main] WARN migrateToAleph - item:3562419305 untranslatable:Aestet.u-ref 2009-12-11 09:17:52,697 [main] WARN migrateToAleph - item:3562419321 untranslatable:Aestet.u-ref 2009-12-11 09:17:52,697 [main] WARN migrateToAleph - item:3562419437 untranslatable:Aestet.u-ref 2009-12-11 09:17:52,697 [main] WARN migrateToAleph - item:3562419313 untranslatable:Aestet.u-ref 2009-12-11 09:17:52,697 [main] WARN migrateToAleph - item:3880434909 untranslatable:Aestet.u-KuHhb 2009-12-11 09:17:52,697 [main] WARN migrateToAleph - item:3880434917 untranslatable:Aestet.u-KuHhb 2009-12-11 09:17:52,697 [main] WARN migrateToAleph - item:3880434933 untranslatable:Aestet.u-KuHhb 2009-12-11 09:17:52,697 [main] WARN migrateToAleph - item:3880434925 untranslatable:Aestet.u-KuHhb 2009-12-11 09:17:52,697 [main] WARN migrateToAleph - item:400011599506 untranslatable:SB-alm.u-m 2009-12-11 09:17:52,697 [main] WARN migrateToAleph - item:400013226022 untranslatable:SB-alm.u-m 2009-12-11 09:17:52,697 [main] WARN migrateToAleph - item:400013226014 untranslatable:SB-alm.u-m 2009-12-11 09:17:52,697 [main] WARN migrateToAleph - item:400012575538 untranslatable:SB-alm.u-m 2009-12-11 09:17:52,697 [main] WARN migrateToAleph - item:400021772176 untranslatable:SB-alm.u-m 2009-12-11 09:17:52,697 [main] WARN migrateToAleph - item:400021775787 untranslatable:SB-alm.u-m 2009-12-11 09:17:52,697 [main] WARN migrateToAleph - item:400023050089 untranslatable:SB-retr.kvikslt 2009-12-11 09:17:52,697 [main] WARN migrateToAleph - item:405000005387 untranslatable:SB-retr.kvikslt 2009-12-11 09:17:52,697 [main] WARN migrateToAleph - item:400015961064 untranslatable:SB-retr.kvikslt 2009-12-11 09:17:52,701 [main] WARN migrateToAleph - item:4181103103 untranslatable:KlaArk.rtr 2009-12-11 09:17:52,701 [main] WARN migrateToAleph - item:400022809405 untranslatable:SB-dvd.m-p 2009-12-11 09:17:52,701 [main] WARN migrateToAleph - item:400012312472 untranslatable:SB.nodrtr 2009-12-11 09:17:52,701 [main] WARN migrateToAleph - item:X4513534 untranslatable:SB-alm.p-alf 2009-12-11 09:17:52,701 [main] WARN migrateToAleph - item:400020893212 untranslatable:SB-afly.fon 2009-12-11 09:17:52,701 [main] WARN migrateToAleph - item:400019084289 untranslatable:SBDB.m-rt 2009-12-11 09:17:52,701 [main] WARN migrateToAleph - item:3622497246 untranslatable:KlaArk.m 2009-12-11 09:17:52,701 [main] WARN migrateToAleph - item:3622497262 untranslatable:KlaArk.m 2009-12-11 09:17:52,701 [main] WARN migrateToAleph - item:400021812135 untranslatable:SVB.u-m 2009-12-11 09:17:52,701 [main] WARN migrateToAleph - item:400021812453 untranslatable:SVB.u-m 2009-12-11 09:17:52,701 [main] WARN migrateToAleph - item:X4740824 untranslatable:Aestet.u-nod 2009-12-11 09:17:52,701 [main] WARN migrateToAleph - item:X4740873 untranslatable:Aestet.u-nod 2009-12-11 09:17:52,701 [main] WARN migrateToAleph - item:00049320 untranslatable:DJM.m 2009-12-11 09:17:52,701 [main] WARN migrateToAleph - item:3880334947 untranslatable:Aestet.u-MSa-m 2009-12-11 09:17:52,701 [main] WARN migrateToAleph - item:3880334998 untranslatable:Aestet.u-MSa-m 2009-12-11 09:17:52,701 [main] WARN migrateToAleph - item:3880334963 untranslatable:Aestet.u-MSa-m 2009-12-11 09:17:52,701 [main] WARN migrateToAleph - item:3880334955 untranslatable:Aestet.u-MSa-m 2009-12-11 09:17:52,702 [main] WARN migrateToAleph - item:3880334971 untranslatable:Aestet.u-MSa-m 2009-12-11 09:17:52,702 [main] ERROR migrateToAleph - 53 deleted items encountered 2009-12-11 09:17:52,702 [main] INFO migrateToAleph - records scanned: 3434419 records skipped: 62 deleted records found: 53
Importen til Aleph gav anledning til en del fejl af følgende typer:
0110 : Z30-MATERIAL is not valid 0208 : conflict between Z30-SUB-LIBRARY and Z30-ITEM-STATUS %Errors found for record in line 000063362 0110 : Z30-MATERIAL is not valid 0208 : conflict between Z30-SUB-LIBRARY and Z30-ITEM-STATUS %Errors found for record in line 000063520 0201 : Z30-SUB-LIBRARY is not valid 0206 : Z30-COLLECTION is not valid 0208 : conflict between Z30-SUB-LIBRARY and Z30-ITEM-STATUS %Errors found for record in line 000913200 0201 : Z30-SUB-LIBRARY is not valid 0206 : Z30-COLLECTION is not valid 0208 : conflict between Z30-SUB-LIBRARY and Z30-ITEM-STATUS %Errors found for record in line 000306147 0207 : conflict between Z30-SUB-LIBRARY and Z30-ITEM-PROCESS-STATUS %Errors found for record in line 000306847 0201 : Z30-SUB-LIBRARY is not valid 0206 : Z30-COLLECTION is not valid 0208 : conflict between Z30-SUB-LIBRARY and Z30-ITEM-STATUS %Errors found for record in line 000309398 0207 : conflict between Z30-SUB-LIBRARY and Z30-ITEM-PROCESS-STATUS %Errors found for record in line 000309976 0207 : conflict between Z30-SUB-LIBRARY and Z30-ITEM-PROCESS-STATUS %Errors found for record in line 000309980 0207 : conflict between Z30-SUB-LIBRARY and Z30-ITEM-PROCESS-STATUS %Errors found for record in line 000315150 Der er i alt 408 poster med fejl
Lån
Bjørn gav følgende kommentar med:
2009-12-11 14:11:55,111 [main] WARN migrateToAleph - skipping loan Hz item# 1078851 (Loc: SB-alm, 400001932851) of skipped item 2009-12-11 14:11:55,241 [main] WARN migrateToAleph - skipping loan Hz item# 1081026 (Loc: SB-alm, 400001872670) of skipped item 2009-12-11 14:11:55,287 [main] WARN migrateToAleph - Hz item# 4733739 (Loc: SB-per, 400022179762) unable to translate itype: p to material type for m 2009-12-11 14:11:55,287 [main] WARN migrateToAleph - Hz item# 4733739 (Loc: SB-per, 400022179762) unable to translate itype: p to item status for m 2009-12-11 14:14:31,642 [main] WARN migrateToAleph - item:Hz item# 2999390 (Loc: SB-alm, 400012810235) is not lost and has a borrower but no due or last checkout date 2009-12-11 14:15:44,286 [main] INFO migrateToAleph - scanned: 158283 skipped items/loans:8856 non loan entries: 0
Der var ingen kommentarer fra Aleph ved importen, udover
Start check/correct of records... Program is not exists: correct_z36
Reservationer
Bjørns kommentar:
2009-12-11 12:39:28,750 [main] INFO migrateToAleph - skipping request Hz item# 3338722 (Loc: T, 3865862570) based on request kind/status 2009-12-11 12:39:28,750 [main] WARN migrateToAleph - skipping request Hz item# 3338722 (Loc: T, 3865862570) due to request state or skipped item 2009-12-11 12:39:46,025 [main] WARN migrateToAleph - Skipping request for horizon pickup location: A 2009-12-11 12:49:20,801 [main] INFO dk.statsbiblioteket.alephimportexport.oracle.AlephLoadFile - Closing tmp/z37.seqaa with 15729 records 2009-12-11 12:49:20,801 [main] INFO migrateToAleph - scanned: 18534 skipped items/requests:2805 deleted items/requests: 0 errors:0
Importen til Aleph gav et antal kommentarer af typen
0202 : Z37-PICKUP-LOCATION is not valid %Errors found for record in line 000000041 Der er 29 poster med fejl.
Pengesager
Kommentarer fra Bjørn
2009-12-11 13:24:43,403 [main] INFO migrateToAleph - Converting burb entries for 106793 borrowers 2009-12-11 13:25:07,985 [main] ERROR migrateToAleph - burb entry ref#:1893049 references nonexistent item, skipped 2009-12-11 13:25:23,191 [main] ERROR migrateToAleph - burb entry ref#:1288194 references nonexistent item, skipped 2009-12-11 13:25:23,218 [main] ERROR migrateToAleph - burb entry ref#:1288196 references nonexistent item, skipped 2009-12-11 13:25:23,228 [main] ERROR migrateToAleph - burb entry ref#:1288198 references nonexistent item, skipped 2009-12-11 13:25:23,238 [main] ERROR migrateToAleph - burb entry ref#:1303641 references nonexistent item, skipped 2009-12-11 13:35:38,486 [main] WARN migrateToAleph - Hz item# 4355702 (Loc: SB-per, 400022291211) unable to translate itype: p to material type for m 2009-12-11 13:42:18,319 [main] INFO dk.statsbiblioteket.alephimportexport.oracle.AlephLoadFile - Closing tmp/z31.seqaa with 25685 records
Der var ingen klager fra Aleph importen.
Copy-poster med tilhørende items
Eriks konvertering af subscriptions:
2009-12-11 08:10:50,299 [main] WARN migrateToAleph - copy# 574/33259 bib# 197103 SB-per(1)/p-alf/r-p:4 is active with serLocation=SB 2009-12-11 08:12:12,801 [main] WARN migrateToAleph - copy# 1112/33735 bib# 197451 SB-per(1)/p-alf/r-p:6 defaulting starting year 2009-12-11 08:12:52,173 [main] WARN migrateToAleph - copy# 239724/243340 bib# 197663 SB-LK(1)/p/p:4 defaulting starting year 2009-12-11 08:13:08,902 [main] WARN migrateToAleph - copy# 184345/140009 bib# 197751 SB-LK(1)/tjx/r-p:4 defaulting starting year 2009-12-11 08:14:13,369 [main] ERROR dk.statsbiblioteket.horizon.Serial - Hz Serial# 139645 pattern length mismatch in '33,2003' (1) in main: HzDate 12753 2009-12-11 08:14:13,651 [main] ERROR dk.statsbiblioteket.horizon.Serial - Hz Serial# 139645 pattern length mismatch in '33,2003' (1) in main: HzDate 12753 2009-12-11 11:16:36,607 [main] INFO dk.statsbiblioteket.alephimportexport.oracle.AlephLoadFile - Closing tmp/z12.seqaa with 0 records 2009-12-11 11:16:36,607 [main] INFO dk.statsbiblioteket.alephimportexport.oracle.AlephLoadFile - Closing tmp/z16.seqaa with 168946 records 2009-12-11 11:16:36,607 [main] INFO dk.statsbiblioteket.alephimportexport.oracle.AlephLoadFile - Closing tmp/z30-copyitem.seqaa with 165430 records 2009-12-11 11:16:36,607 [main] INFO dk.statsbiblioteket.alephimportexport.oracle.AlephLoadFile - Closing tmp/z30-copyissue.seqaa with 216373 records 2009-12-11 11:16:36,607 [main] INFO migrateToAleph - Number of current vendors identified: 409 2009-12-11 11:16:36,638 [main] INFO dk.statsbiblioteket.alephimportexport.oracle.AlephLoadFile - Opening tmp/z70.seqaa 2009-12-11 11:16:36,652 [main] INFO dk.statsbiblioteket.alephimportexport.oracle.AlephLoadFile - Opening tmp/z72.seqaa 2009-12-11 11:16:44,449 [main] INFO dk.statsbiblioteket.alephimportexport.oracle.AlephLoadFile - Closing tmp/z70.seqaa with 409 records 2009-12-11 11:16:44,449 [main] INFO dk.statsbiblioteket.alephimportexport.oracle.AlephLoadFile - Closing tmp/z72.seqaa with 403 records
Aleph importen af subscriptions gav disse typer fejl
0215 : Z16-COPY-FROM-DATE is not valid %Errors found for record in line 000000001 0215 : Z16-COPY-FROM-DATE is not valid %Errors found for record in line 000000082 0215 : Z16-COPY-FROM-DATE is not valid %Errors found for record in line 000000083 0202 : Z16-COPY-TO-DATE should be latest then Z16-COPY-FROM-DATE %Errors found for record in line 000013075 0215 : Z16-COPY-FROM-DATE is not valid 0202 : Z16-COPY-TO-DATE should be latest then Z16-COPY-FROM-DATE %Errors found for record in line 000028795 0207 : Z16-CLAIM-2 (-3, -4) can not be empty when Z16-CLAIM is "Y" %Errors found for record in line 000168885 0207 : Z16-CLAIM-2 (-3, -4) can not be empty when Z16-CLAIM is "Y" %Errors found for record in line 000168941 0207 : Z16-CLAIM-2 (-3, -4) can not be empty when Z16-CLAIM is "Y" %Errors found for record in line 000168946
De tilhørende copyissue og copyitem poster gav følgende typer af fejl:
0207 : conflict between Z30-SUB-LIBRARY and Z30-ITEM-PROCESS-STATUS %Errors found for record in line 000000507 0207 : conflict between Z30-SUB-LIBRARY and Z30-ITEM-PROCESS-STATUS %Errors found for record in line 000000817 0207 : conflict between Z30-SUB-LIBRARY and Z30-ITEM-PROCESS-STATUS %Errors found for record in line 000000820 0207 : conflict between Z30-SUB-LIBRARY and Z30-ITEM-PROCESS-STATUS %Errors found for record in line 000001052 0207 : conflict between Z30-SUB-LIBRARY and Z30-ITEM-PROCESS-STATUS %Errors found for record in line 000002647 0207 : conflict between Z30-SUB-LIBRARY and Z30-ITEM-PROCESS-STATUS 0208 : conflict between Z30-SUB-LIBRARY and Z30-ITEM-STATUS %Errors found for record in line 000102453 0208 : conflict between Z30-SUB-LIBRARY and Z30-ITEM-STATUS %Errors found for record in line 000102454 0206 : Z30-COLLECTION is not valid %Errors found for record in line 000046324 0206 : Z30-COLLECTION is not valid %Errors found for record in line 000046325 Der er i alt 1979 copyissue og 39 copyitem poster med fejl
Vendor poster
Importen af vendor (SOL50 z70 og z72) poster gav ingen klager.