IUA - Interlibrary Users Association

National Capital Area Libraries Networking Together


Home | Contact | Membership Information | Member Profiles | Downloads | Job Links

 

IUA's Journal Holdings Update Process

XYZ_hold.xls

File supplied by editor

USE WHEN

Editing Your Holdings (This file is specific to your Library. It contains the IUA journal holdings for your Library)

  • Journal title is the same, but your holdings have changed.
  • You no longer have the Journal title and it is to be deleted.

Instructions & Example

title_add.xls

Right click to download file

USE WHEN

Adding Your Holdings for a Title Listed in the Journal Holdings

  • Your library has added a journal and it is listed in the Journal Holdings. NEW to you, but NOT NEW to IUA

Instructions & Example

title_new.xls

Right click to download file

USE WHEN Adding Your Holdings for a Title NOT Listed in the Journal Holdings
  • Your library has subscribed to a journal that is not listed in the Journal Holdings. NEW to you and to IUA
Instructions & Example
title_mod.xls

Right click to download file

USE WHEN Modify Titles Listed in the Journal Holdings
  • Adding or correcting title information for a journal title listed in the Journal Holdings.
Instructions & Example

If you have problems or questions concerning the files, please contact Jennifer Hatfield - email: jennifer.hatfield@lmco.com or call: 703-367-6508

Saving

  • You may save the file as an .xls (Excel) file or as a text (delimited file).

Quality Checks

  • For consistency please use ALL UPPER CASE.
  • The preferred formatting for the holdings information is: VOL. (YEAR)-VOL. (YEAR).
    It is assumed that most titles have missing issues. You do not need to detail minor gaps in coverage.
  • Thoroughly review your information.
  • Run spell check.

Instructions for Editing Your Holdings


XYZ_hold.xls USE WHEN (Your IUA code will appear instead of XYZ)

  • Journal title is the same, but your holdings have changed.
  • You no longer have the Journal title and it is to be deleted.

The Holdings Update file supplied to you lists all current holdings for your library in the IUA database. If you have problems or questions concerning this file, please contact Jennifer Hatfield - email: jennifer.hatfield@lmco.com or call: 703-367-6508

IMPORTANT NOTES:

  • You only need to work with the 2 columns - HOLDINGS and DELETE.
    If your holdings information has changed, please update the information in the HOLDINGS column.

    To identify journals you no longer hold, put the word YES in the delete column. Leaving the DELETE cell empty indicates that the title will remain in the IUA database.
    Other modifications made in this file are omitted during import.
  • DO NOT REMOVE or CUT RECORDS FROM THIS FILE.

Example of information to supply in XYZ_hold.xls

IUA CODE TITLE TITLE NUMBER ISSN HOLDINGS DELETE
           
XYZ ACM COMPUTING SURVEYS 211172 0360-0300 V.10 (1978)-(1994)  
XYZ ADA INFORMATION CLEARINGHOUSE NEWSLETTER 284798   1994-  
XYZ ADA LETTERS
140455
0736-721X 1992-  
XYZ ADVANCED IMAGING 290735 1042-0711 CURRENT YEAR  
XYZ ADVANCED MANAGEMENT JOURNAL
(1974-1984)
49503 0362-1863 WINTER (1984) YES
XYZ AEROSPACE DAILY 38133 0193-4546 CURRENT SIX MONTHS  
XYZ APPLIED OPTICS 92320 0003-6935 1991-1997  

Saving

  • You may save the file as an .xls (Excel) file or as a text (delimited file).

Quality Checks

  • For consistency please use ALL UPPER CASE.
  • The preferred formatting for the holdings information is: VOL. (YEAR)-VOL. (YEAR).
    It is assumed that most titles have missing issues. You do not need to detail minor gaps in coverage.
  • Thoroughly review your information.
  • Run spell check.

Instructions for Adding Your Holdings for a Title Listed in the Journal Holdings


title_add.xls USE WHEN

  • Your library has added a journal and it is LISTED in the Journal Holdings
    (NEW to you, but NOT NEW to IUA)
  1. The information required for using title_add.xls
    • Your Library's IUA Code
    • IUA Journal Title Number
      Look for title in the Journal Holdings, if listed, the title number is included.
      If title is not listed, you need to use the title_new.xls form to add your holdings information for the new title.
    • Your holdings information - preferred formatting: VOL. (YEAR)-VOL. (YEAR)
  2. You may find filling out the Title column to be helpful. It is optional and will not create any problem in the update process.

Example of information to supply in title_add.xls
You need to provide information in the first 3 columns. Journal Title is optional but filling in this column makes it easier to determine what you have listed.

YOUR LIBRARY IUA CODE JOURNAL TITLE NUMBER YOUR HOLDINGS JOURNAL TITLE
       
XYZ 27896 CURRENT YEAR OPTIONAL
XYZ 9882 CURRENT FIVE YEARS OPTIONAL
XYZ 451826 1989- OPTIONAL
XYZ 260247 V.9 (1993)-V.10(1994) OPTIONAL
XYZ 7175 V.5 (1977)- OPTIONAL
XYZ 55527 V.9:NO.11(1983)-V.22:NO.3 (1989) OPTIONAL
XYZ 181719 V.8 (1961)-V.9(1962) M
OPTIONAL

Saving

  • You may save the file as an .xls (Excel) file or as a text (delimited file).

Quality Checks

  • For consistency please use ALL UPPER CASE.
  • The preferred formatting for the holdings information is: VOL. (YEAR)-VOL. (YEAR).
    It is assumed that most titles have missing issues. You do not need to detail minor gaps in coverage.
  • Thoroughly review your information.
  • Run spell check.

Instructions for Adding Your Holdings for a Title NOT Listed in the Journal Holdings


title_new.xls USE WHEN

  • Your library has subscribed to a journal that is NOT LISTED in the Journal Holdings.
  1. Provide as much of the requested journal information as possible.
    Use Library of Congress, Ulrich's, the Journal's web site, OCLC, etc. to help you find information.
  2. Journal titles should be consistent with the name on the journal cover.

Example of information to supply in title_new.xls
Provide as much information as possible.

JOURNAL TITLE

ISSN NUMBER FREQUENCY PUBLISHER PUBLISHED DATES AND VOLUME INFORMATION SUBSEQUENT TITLE (IF ANY) PREVIOUS TITLE (IF ANY) YOUR LIBRARY IUA CODE YOUR HOLDINGS
                 
HEALTHCARE MANAGEMENT REVIEW 0361-6274 QUARTERLY FREDERICK, MD: ASPEN PUBLISHERS INC V. 1 (1976)-     XYZ CURRENT FIVE YEARS
JOURNAL OF THE SURVEYING AND MAPPING DIVISION 0569-8073 INFREQUENTLY NEW YORK: AMERICAN SOCIETY OF CIVIL ENGINEERS V.82 (1956)-V.108 (1982) CONTINUED BY: JOURNAL OF SURVEYING ENGINEERING CONTINUES IN PART: PROCEEDINGS OF THE AMERICAN SOCIETY OF CIVIL ENGINEERS XYZ V.82 (1956)-V.90 (1974)

Saving

  • You may save the file as an .xls (Excel) file or as a text (delimited file).

Quality Checks

  • For consistency please use ALL UPPER CASE.
  • The preferred formatting for the holdings information is: VOL. (YEAR)-VOL. (YEAR).
    It is assumed that most titles have missing issues. You do not need to detail minor gaps in coverage.
  • Thoroughly review your information.
  • Run spell check.

Instructions for Modifying Titles Listed in the Journal Holdings


title_mod.xls USE WHEN

  • Adding or correcting title information for a journal LISTED in the Journal Holdings.

You need to provide the title number from the Journal Holdings and the information that is being added or corrected.

Some reasons a Title would need to be modified:

    • When a journal is continued by a new journal title, the ceased title will need the volume information and subsequent title information updated. In this case the three columns with information you would provide are; journal title number, published dates and volume information, and subsequent title.
    • An ISSN number is missing from a title and you can supply it. In this case the two columns with information you would provide are; journal title number, and ISSN number.
    • Publisher is different than the one listed.
    • Journal title ceased publication.

Example of information to supply in title_mod.xls
Provide the title number from the Journal Holdings and the information that is being added or corrected.

JOURNAL TITLE NUMBER

JOURNAL TITLE

ISSN NUMBER FREQUENCY PUBLISHER PUBLISHED DATES AND VOLUME INFORMATION SUBSEQUENT TITLE (IF ANY) PREVIOUS TITLE (IF ANY)
               
42629 OPTIONAL    QUARTERLY FREDERICK, MD: ASPEN PUBLISHERS INC      
452122 OPTIONAL 0569-8073          
156946 JOURNAL OF THE SOCIETY OF CHEMICAL INDUSTRY       V.1 (1882)-V.69 (1950) CONTINUED BY: JOURNAL OF APPLIED CHEMISTRY  
453257 OPTIONAL       1980-1982    
52480 JOURNAL OF APPLIED CHEMISTRY AND BIOTECHNOLOGY       V.21 (1971)-V.28 (1978)  CONTINUED BY: JOURNAL OF CHEMICAL TECHNOLGOY AND BIOTECHNOLOGY  CONTINUES: JOURNAL OF APPLIED CHEMISTRY

Saving

  • You may save the file as an .xls (Excel) file or as a text (delimited file).

Quality Checks

  • For consistency please use ALL UPPER CASE.
  • The preferred formatting for the holdings information is: VOL. (YEAR)-VOL. (YEAR).
  • Thoroughly review your information.
  • Run spell check.

This page is maintained by Jim Miller and Jennifer Hatfield

November 29, 2006