SELECTING AN UPLOAD FILE FORMAT

 

You may upload a file to Ulrich’s Serials Analysis System in any one of several upload formats:

 

·         Plain-text, Comma-delimited – ISSN only

·         Plain-text, Tab-delimited – ISSN only, or ISSN and other data elements

·         Plain-text, Pipe-delimited – ISSN only, or ISSN and other data elements

·         Files created in Excel – ISSN only, or ISSN and other data elements

 

ISSN is a mandatory field in all upload file formats.  The format for each ISSN must be four digits, a hyphen, and the remaining four digits (including the check digit) of the ISSN.

 

For example: 1234-5678

 

In addition to the ISSN for an item in your collection, you may include other item-specific fields that will display in your analytical reports.  For example, you may include the title from your local holdings, usage statistics for a particular journal, notes related to aggregator packages in which the titles are found, department or fund codes, or other information.  Only the ISSN from your list is used for matching against Ulrich’s.

 

 

GETTING STARTED

 

§         Formatting a List of (only) ISSN as a Comma-Delimited File

 

If your list contains only ISSN – and no other fields – you may upload your list in plain-text, comma-delimited format.

 

Comma-delimited format files contain a comma – but no spaces – between each ISSN, or each ISSN on a separate line.  The last character in the file should be the check-digit of the last ISSN in the file.

 

For example:  1234-5678,1122-3344,7890-1234,5555-678X,0123-9876

 

Or, one ISSN per line:

 

                   1234-5678

                   1122-3344

                   7890-1234

                   5555-678X

                   0123-9876

                  

§         Formatting an ISSN List as a Tab-Delimited File

 

If your list contains only ISSN – or ISSN and other fields* – you may upload your list in plain-text, tab-delimited format.  The fields that can be uploaded in plain-text, tab-delimited format include (in order):

 

 

*Library-defined Usage Stats, Notes 1, and Notes 2 are free-text fields that may contain a maximum of 100 characters each, but which should not include tabs in the body of the text.   Examples of data that you may want to include in Notes 1 or Notes 2 are: local library notes, comments regarding the serial's format, details on the fund or department code associated with the serial in your catalog, the price you pay for the item, or other serial-specific information. This data may be pulled from your Electronic Resource Management (ERM) module, local databases, or other sources.

 

Tab-delimited format files contain a tab – but no spaces – between each data field, with one record per line. Fields for which you will not upload information for a particular serial should be replaced by a tab character.

 

For example:

 

ISSN only (one record per line):

0002-7561

0002-8282

0003-6846

 

            ISSN and Title (one record per line):

0002-7561<tab>American Banker

0002-8282<tab>American Economic Review

0003-6846<tab>Applied Economics

 

            ISSN, Title, Library-Defined Usage Stats (one record per line):

0002-7561<tab>American Banker<tab>$0.60 per use

0002-8282<tab>American Economic Review<tab>$0.90 per use

0003-6846<tab>Applied Economics<tab>no data available

 

            ISSN and Notes 1 - no Title or Library-Defined Usage Stats (one record per line):

0002-7561<tab><tab><tab>new subscription as of 2004

0002-8282<tab><tab><tab>Business school purchase

0003-6846<tab><tab><tab>special fund item

 

§         Formatting an ISSN List as a Pipe-Delimited (Vertical Bar-Delimited) File

 

If your list contains only ISSN – or ISSN and other fields* – you may upload your list in plain-text, pipe-delimited format.  The fields that can be uploaded in plain-text, tab-delimited format include (in order):

 

 

*Library-defined Usage Stats, Notes 1, and Notes 2 are free-text fields that may contain a maximum of 100 characters each, but which should not include tabs in the body of the text.   Examples of data that you may want to include in Notes 1 or Notes 2 are: local library notes, comments regarding the serial's format, details on the fund or department code associated with the serial in your catalog, the price you pay for the item, or other serial-specific information. This data may be pulled from your Electronic Resource Management (ERM) module, local databases, or other sources.

 

Pipe-delimited format files contain a pipe symbol (|) represented by the vertical bar (ASCII hexadecimal 7C) – but no spaces – between each data field, with one record per line.  Fields for which you will not upload information for a particular serial should be replaced by a pipe (|) symbol.

 

For example:

 

ISSN only (one record per line):

0002-7561

0002-8282

0003-6846

 

            ISSN and Title (one record per line):

0002-7561|American Banker

0002-8282|American Economic Review

0003-6846|Applied Economics

 

            ISSN, Title, Library-Defined Usage Stats (one record per line):

0002-7561|American Banker|$0.60 per use

0002-8282|American Economic Review|$0.90 per use

0003-6846|Applied Economics|no data available

 

            ISSN and Notes 1 - no Title or Library-Defined Usage Stats (one record per line):

0002-7561|||new subscription as of 2004

0002-8282|||Business school purchase

0003-6846|||special fund item

 

 

§         Formatting an ISSN List Created in Microsoft Excel

 

You may upload a file created from a Microsoft Excel spreadsheet and saved in one of two formats:

 

 

 The list of fields* that can be uploaded from columns in an Excel spreadsheet includes (in order):

 

 

*Library-defined Usage Stats, Notes 1, and Notes 2 are free-text fields that may contain a maximum of 100 characters each.   Examples of data that you may want to include in Notes 1 or Notes 2 are: local library notes, comments regarding the serial's format, details on the fund or department code associated with the serial in your catalog, the price you pay for the item, or other serial-specific information.

 

Files uploaded from Excel spreadsheets must contain each data field as a separate column.

 

Fields for which you will not upload information for a particular serial should appear as empty columns in your Excel spreadsheet.  Do not include column headers in your Excel spreadsheet.  Include only 1 worksheet per spreadsheet.

 

Here are some examples of Excel spreadsheets with columns that can be uploaded to Ulrich’s Serials Analysis System:

 

 

To save your file from Excel in comma-delimited format (for files of ISSN only):

 

 

To save your file from Excel in tab-delimited format (for files of ISSN only, or for files of ISSN and other fields):

 

 

 

For instructions on how to load your ISSN list into the System, please refer to the Help document titled “Loading an ISSN List”.

 

 

 

Note: Access to some features of Ulrich’s Serials Analysis System is restricted, based on User Type. Check with your Ulrich’s Serials Analysis System license administrator to determine whether your User Type grants you permission to use this feature.

 

Ulrichsweb.com technical support is available from Serials Solutions. Library Client Services can be contacted via the Support Center or email, clients@serialssolutions.com. For assistance via telephone, North American clients please call +1 (866) SERIALS extension 4, and clients outside of North America please call our UK office at +44 12 2312 5512.