MkItBetr

v.1.01 (6/9/2000)

Tom Tyler, University of Denver Library

Requirements:

· URLVerify.html file from Innopac library using the URLVerify product

· Microsoft Windows 9x

· Microsoft Access, Microsoft Excel, or equivalent software

· URLVExpt software which can be downloaded from: http://www.du.edu/~ttyler/freeware/urlvexpt.zip

Brief Description:

Using source data provided by one of the URLVExpt's delimited files, Innovative’s URLVerify.html data is sorted by Error Type and URL in MS Access (preferably), and exported to a delimited file. This file is used as input data for MkItBetr which creates a newly formated error report in HTML with separate pages for each error type -- each arranged first by domain and then by URL.

MkItBetr is designed to enable Innopac libraries with large to very large URLVerify.html files the means to have an error report file that is better organized and more effective in use than is possible with the generic Innopac product.

Documentation:

Documentation for MarcXGen, in MS Word format, is included among the files in the Zipped package available at the Download heading.

This file is also available on the web at http://www.du.edu/~ttyler/mkitbetr.htm.

Download

The MkItBetr executable, documentation in MS Word format, and the template file for library name and IP number are available in Zipped format at http://www.du.edu/~ttyler/freeware/mkitbetr.zip

Unzipping MkItBetr.Zip

1. Be sure you web browser is set up to save-to-disk a file with the extension ".zip".

2. Use your web browser to go to the following URL: http://www.du.edu/~ttyler/freeware/mkitbetr.zip

3. Save the MkItBetr.zip file to the folder/directory on your workstation where you will be processing the URLVExpt output file from your library system.

4. Unzip MkItBetr.zip using appropriate software (e.g. the PKZIP utility).

5. After unzipping the MkItBetr.zip you should have the following files:

mkitbetr.exe The program itself

mkitbetr.txt The text file the program needs to hold on to your library's name and IP number. You must edit this file with your library's name and the IP number for your Innopac catalog.

mkitbetr.doc. Documentation in MS Word format which corresponds to the file you are reading now.

Configuring MkItBetr

The only configuration needed is to edit the mkitbetr.txt file. Replace all the asterisks with the name of your library. When saving the file be sure that you save it in text format.

Example:

Before editing: Library Name Goes Here

###.###.###.###

After editing: University of Denver Library

130.253.32.83

Using MkItBetr:

1. Run the URLVExpt program to convert the Innopac URLVerify.html file data into delimited text. You will need the URLVOUT.TXT file in the directory that contains mkitbetr.exe.

2. Import the URLVOUT.TXT file into MS Access; accept URLVOUT as the table name

3. In MS Access, create a "Make Table Query" using the table URLVOUT. When asked for a table name do not use MKITBETR; Use instead MIBOUT or some other name

4. In Query Design, select the SQL View and enter/paste the following:

SELECT URLVOUT.[RECORD#], URLVOUT.ERROR, URLVOUT.URL, URLVOUT.[REDIRECT URL] INTO MIBOUT

FROM URLVOUT

ORDER BY URLVOUT.ERROR, URLVOUT.URL;

Or

Enter in design view only the four fields (columns) that will be used: RECORD#, ERROR, URL, and REDIRECT URL; Select ascending sort for both Error and URL.

NOTE: The sorting is very important because the MkITBetr program creates pages by error type and arranges reported errors by domain.

5. Run the query; this should create a new table called MIBOUT if you decided to use that name.

6. In Tables, Export the MIBOUT file as a delimited text file. This will be the file used as source data for MkItBetr.

7. Run MkItBetr. It may be run from the DOS command line (i.e. MS-DOS Prompt) or from Windows Explorer.

· From the DOS prompt enter the command MKITBETR ; press the ENTER key , or

· Select mkitbetr.exe from the folder/directory display if you use Windows Explorer

8. The program will remind you that the Library Name/IP Number file (mkitbetr.txt) needs to have been edited for local use. It will ask for a date in the format mmmmmmmm dd, yyyy and it will ask for the filename of the delimited file (e.g. MIBOUT.TXT).

9. The program should run to its conclusion. The file MA00.HTM (M A zero zero) is the parent page for the rewritten URLVerify.html errors.

APPENDIX A: MkItBetr COPYRIGHT NOTICE

The freeware MkItBetr and its documentation is (C) Copyright by Thomas G. Tyler,( 2000).

Permission to use, copy, and distribute this software and its documentation, in whole or in part, for any purpose (except as detailed hereunder) is hereby granted without fee, provided that the above copyright notice and this permission notice appear in all copies of the software and related documentation. Notices of copyright and/or attribution which appear in any file included in this distribution must remain intact.

You may not disassemble, decompose, reverse engineer, or alter this file or any of the other files in the package.

This software is provided as FREEWARE, and cannot be sold. This restriction does not apply to connect time charges, or flat rate connection/download fees for electronic bulletin board services. This software can not be bundled with any commercial package without express written permission from Thomas G. Tyler. Source code for this software is

proprietary information of Thomas G. Tyler, the AUTHOR. No source-code license is available.

THE SOFTWARE IS PROVIDED "AS-IS" AND WITHOUT WARRANTY OF ANY KIND, EXPRESS, IMPLIED OR OTHERWISE, INCLUDING WITHOUT LIMITATION, ANY WARRANTY OF MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE.

IN NO EVENT SHALL THE AUTHOR BE LIABLE FOR ANY SPECIAL, INCIDENTAL, INDIRECT OR CONSEQUENTIAL DAMAGES OF ANY KIND, OR ANY DAMAGES WHATSOEVER RESULTING FROM LOSS OF USE, DATA OR PROFITS, WHETHER OR NOT ADVISED OF THE POSSIBILITY OF DAMAGE, AND ON ANY THEORY OF LIABILITY, ARISING OUT OF OR IN CONNECTION WITH THE USE OR PERFORMANCE OF THIS SOFTWARE, OTHER THAN TO THE EXTENT OF ANY UNAVOIDABLE STATUTORY LIABILITY.

Report errors and problems to:

Thomas G. Tyler

Associate Director for Budget & Technical Planning

University of Denver Library

303-871-3334 (w)

303-871-3446 (fax)

Email: ttyler@du.edu

Web: http://www.du.edu/~ttyler/freeware/mkitbetr.htm