DataLoader Report and Log Files

table#NoBorder {

   border:none;

}

 

table#NoBorder td {

   border:none;

   background-color:white;

}

After each loading process, a report is generated.

DataLoader Report

The report contains links to a number of files that can be used for analysis. Open these files using Excel, Word, or a text editor. You can also choose to save them to your hard disk for later use.

Analysis of the Data File

This file contains information about the analysis of the primary keys in the data file as well as information about which object portfolios have been added or updated.

The following is an example of a report file:

Report Translate 076-836X Translated 1076-836X into 1063-5157

Report Translate 1077-3118 Translated 1077-3118 into 0003-6951

Report NotExist 1471-4892 Object not in database

Report Added 0003-6951 New Portfolio added

Report Added 1063-5157 New Portfolio added

This report shows that:

Two eISSN values have been replaced with the corresponding ISSN values. The ISSN values will be loaded.
One ISSN has not been found in the SFX database; it will not be loaded. Inform Ex Libris about this and it will be added to the database in the next update.
Two new object portfolios have been added.

The following is an example of a report file for updated object portfolios:

Report Updated 0936-8051 Updated portfolio with id=3850000000002481

VG_SPRINGER_LINK_JOURNALS getFullTxt Archives of Orthopaedic and Trauma Surgery Deactivated

Report Updated 0340-5761 Updated portfolio with id=3850000000002484

VG_SPRINGER_LINK_JOURNALS getFullTxt Archives of Toxicology Deactivated

Report Updated 1434-1816 Updated portfolio with id=3850000000002486

VG_SPRINGER_LINK_JOURNALS getFullTxt Archives of Women's Mental Health ACTIVE:No-change

Report 0933-7946 Updated portfolio with id="3850000000002491" VG_SPRINGER_LINK_JOURNALS getFullTxt Arthroskopie ACTIVE:No-change

This report shows that:

Two object portfolios have been updated and deactivated
Two object portfolios have not been changed and remain active

The location and name of the report file are specified by DataLoader. For example

exlibris/sfx_ver/sfx4_1/sfxlcl4/dbs/scratch/test.txt.ok.err

If Report Mode is selected, no changes are made in the SFX database. The log file contains information about changes that would have been made.

The following is an example of a report file:

Report	Mode	ReportMode
DataLoader is in Report Mode: this file contains a report of what would be updated with this data file.
Report	Added	1063-651X	Added portfolio with id=<TBD>
Report	Added	0094-9930	Added portfolio with id=<TBD>
Report	Added	0892-7219	Added portfolio with id=<TBD>
Report	Total	3	Added 3 portfolios
Report	Total	0	Updated 0 portfolios

The following is an example of the location and name of a cleaned copy of the data file used by the DataLoader to complete the data loading:

exlibris/sfx_ver/sfx4_1/sfxlcl4/dbs/scratch/test.txt.ok

DataLoader Log

Each time DataLoader is used, the program writes information to the log file dataloader.log.

In the following example, you can see the information saved to the log file:

Wed May 16 13:55:23 2001: user 'local' connected to database 'local_01'

Wed May 16 13:55:23 2001: infile: test.txt

0 checksum and syntax errors in file

0 translated from eISSN into ISSN

Wed May 16 13:55:31 2001: Fields in data file are ISSN PARSER THRESHOLD PARSE_PARAM

Total of 1 objects not in database

Wed May 16 13:55:31 2001: loadObject finished

Wed May 16 13:55:37 2001: user global tries to create portfolio for target ALLEN_PRESS service 'getAbstract'