You must provide an ASCII tab-delimited text file or an excel spreadsheet file of your serials holdings as input to WilsonWeb journal holdings. For ASCII format input files, each record in the file should contain an ISSN, journal title, and holdings message text with a delimiter between each.

You must observe the following rules:

1. ISSN number must be input in the following format: NNNN-NNNX. That is, it must be a string that consists of 4 numeric characters followed by a hyphen followed by 4 more characters, the first 3 of which must be numeric. The final character may be any numeric character or an <X>. The program will insert a hyphen following the fourth character in the string if it's not present in the data.

2. The journal title in your input file should be the standard title for that journal. The input from this field is limited to 80 or fewer characters. Data in excess of 80 characters in the title field will be truncated by the program.

3. The holdings message can be either a text message or a hotlink. The message itself may be of unlimited length. (Consideration should be given to make the displayable text as brief as possible. One line of text is ideal.) You may embed a URL within the holdings message to enable linking from the Wilson record to the corresponding web address.
    
   You can incorporate links to web sites as a part of your static holdings messages by embedding URLs in your holdings messages and/or your default messages. Multiple links may be embedded into a single holdings message.
    
   To include URLs in your message, you must specify an HTML hotlink using the following syntax:
    
   <A HREF="URL goes here">this text is highlighted and can be clicked on</A>
    
   For example, to display the holdings message: "This journal can be viewed online at the Online Library." where Online Library is the hotlink prompt, you would input this text in the holdings file as follows:
    
   This journal can be viewed online at the <A HREF="http://www.libraryname.org">Online Library.</A>
    
   The HTML markup is case sensitive. Also, do not nest the references; use one <A HREF="URL">link text</A> at a time.

4. Delimiters are required to separate each field. Each record must contain 2 delimiters. The delimiter must clearly mark the end of one field and the beginning of the next. You can use any character as a delimiter, though a <tab> is recommended.

5. You must use a standard line-feed character between each record. It is possible to create valid records which do not contain an ISSN or which do not contain a journal title (however, the record must contain one or the other). In these cases, you MUST include the delimiter to mark the place of the field for which there is no data (for example, each record must contain 2 delimiters even if there is not data present in each of the expected fields).

6. A message will be written to the log file to identify records that contain no ISSN or no title. You may also have records in your input file that contain no message text.
    
   You may be able to extract an ASCII file in the appropriate format from your OPAC. Alternatively, an ASCII or text (.txt) file can be created by a variety of word processors, text editors, spreadsheet applications. When you save the file, be sure that you are saving a plain text file. For example, with Microsoft Word or Microsoft Excel select "Text Only" (*.txt) or "Text (Tab Delimited) (*.txt)", respectively.
    
   A tab-delimited input file might look like the following:
    
   0001-4079 Bulletin of the Academy of National Medicine This title available in
   the University Medical Library.
   1058-4838 Clinical Infectious Diseases This title is available in the University
   Medical Library.
    
   If you want various segments of your message to display on separate lines within the Wilson record, you can specify line feeds (hard breaks) in the holdings message by entering 
    
   <br class="none"/> at the end of the line.
   
   For example:
   0001-4079 Bulletin of the Academy of National Medicine. <br class="none"/> This title is available in the University Medical Library.<br class="none"/> The past ten years are on microfiche. Speak to a librarian for assistance.
    
   This message will display in the Wilson record as:
    
   0001-4079 Bulletin of the Academy of National Medicine.
   This title is available in the University Medical Library.
   The past ten years are on microfiche. Speak to a librarian for assistance.