Page History: QA Report

Compare Page Revisions

46 45 44 43 42 41 40 39 38 37 36 35 34 33 32 31 30 29 28 27 26 25 24 23 22 21 20 19 18 17 16 15 14 13 12 11 10 9 8 7 6 5 4 3 2 1 0 Current 46 45 44 43 42 41 40 39 38 37 36 35 34 33 32 31 30 29 28 27 26 25 24 23 22 21 20 19 18 17 16 15 14 13 12 11 10 9 8 7 6 5 4 3 2 1 0

« Older Revision - Back to Page History - Newer Revision »

Page Revision: 2009/08/03 16:22

Install¶

NOTE: QA-Report was written to compare input data (i.e. data created for NDNP during reel evaluation) to the output after data conversion (i.e. the batch, mets issue and mets reel files). These instructions are written for use with data from an MS Access 2007 database and a Windows XP operating system.

1. Extract QA-Report and save it on the same drive and folder as the batch you are testing (output data). For example, if your batch is in a folder called NDNP you would save it the same folder. (e.g. C:\NDNP\batch_wa_20081223_sample and C:\NDNP\QA-Report)
   

How to Run¶

1. To run QA-Report you must first save your input data as xml to the QA-Report folder
   1. Our input data is delivered in MS Access in three tables (titleTbl, reelTbl, issueTbl)
   2. From Access save each table as xml into the QA-Report folder (e.g. Export > More > XML File > C:\QA_Report\reelTbl.xml)
      1. Click OK
      2. Export XML window will open, save 'Data (XML)' only (uncheck 'Schema of the data (XSD)' - this isn't needed)
      3. Click OK
      4. Save Export Steps if you like, click Close
      5. You can close the database
2. QA-Report should now have three xml files (titleTbl.xml, reelTbl.xml, issueTbl.xml)
   1. NOTE: You will get errors if your data isn't structured in three tables or in the same way that this script was written for. I've provided sample data so you can see where the differences might be. If you know xsl, you're welcome to change the code to meet your needs. Also, if your field names are not the same as the sample data provided, simply change the variable names in the .xsl files in QA-Report
3. Now run the QA-Report using the BATCH.xml file
   1. Open your computer's MS-DOS command
   2. Start > Run > type 'cmd' > click 'OK'
   3. Navigate to QA-Report (cd C:\NDNP\QA-Report)
   4. At the prompt run the "run_report" batch file with the BATCH.xml file of the batch you are testing (e.g. C:\QA-Report>run_report '..\batch_wa_20081223_sample\BATCH.xml')
   5. You should see this:
      

      testing titleTbl.xml...
      testing reelTbl.xml...
      testing issueTbl.xml...

   6. When the comparison is done a browser window will open with the titleTbl_report.html window.
      

Understanding the Results¶

Test: titleTbl¶

This table is a re-creation of the table titled titleTbl in the database.

1. Titles in red are missing from the BATCH.xml file
2. The links at the bottom of the page will take you to the next test results
   

Test: reelTbl¶

This table is a re-creation of the table titled reelTbl in the database.

1.