Skip to page content

亚洲太平洋地区 (Chinese Simplified) 更改

Export and Import Authority Records

Set export options

About export options

  • Export methods. You can export bibliographic records or authority records to a file on the Connexion server, and then download the file to your workstation. Or you can export records directly to your local system via a TCP/IP connection.
  • Records. You can export bibliographic records retrieved from WorldCat or the bibliographic save file. You can export authority records retrieved from the Authority File or authority save file.
  • Single or batch export. With either export method, you can export one record at a time or export a group of flagged records.
  • Formats. You can export bibliographic records in MARC, in Dublin Core HTML, or in Dublin Core RDF using either export method. For export to a local system, verify which formats your local system can accept. You can export authority records in MARC format only.
  • Validation for bibliographic records. You can choose to have Connexion validate all exported bibliographic records (the default setting), or you can turn off automatic validation for exported records.

Go to Export Options screen

  Action
1

On the General tab, click Admin.

2

At the Preferences screen, click Export Options.


Save changes, cancel, or restore original defaults

  • When finished viewing and/or changing options on this screen, use the buttons at the top and bottom of the screen to take an action.
  • The following table describes how the buttons work.
Button Purpose/Result
Go Back

Return to the previous screen.

Save for Session

Save changes on this screen for the current session only.

When you log off, the system restores your previous default settings.

Save My Default

Save changes on this screen for the current session and future sessions.

The new settings remain in effect until you change them.

Reset

Restore original Connexion settings for options on this screen.

Reverse any changes you made during the current session or in previous sessions.

Cancel

Reverse any changes you made since you accessed this screen during the current session.

Your previously saved settings remain in effect.


Format for exporting flagged bibliographic records

Why use this setting? Select a format to export groups of flagged bibliographic records in your preferred format automatically, without selecting a format at the time of export.

Action Result

On the Export Options screen, under Flagged Bibliographic Record Export Format,

  • Select MARC or Dublin Core HTML or Dublin Core RDF.

    Or

  • Keep the original default setting, None.

Format specified.

When you export flagged bibliographic records, the system uses the selected format automatically.

None (original default setting).

When you export flagged records, the system displays a screen that prompts you to select an export format.


Validate exported bibliographic and authority records

  • Choose the level of validation for a single exported bibliographic record, bibliographic institution record, and/or authority record.
  • Validation levels apply only when you export a single master bibliographic record, bibliographic institution record, or authority record. Connexion does no validation when you export multiple records Note: You cannot export multiple institution records (because you cannot save IRs). Single-record export is the only supported method for exporting IRs.
  • Validation increases time required for export. When you choose to validate exported records, exporting takes longer to complete.
Action Result

On the Export Options screen, under Validate Exported Bibliographic and Authority Records, select the validation level for each record type.

Keep the default setting, None, or select Basic or Full.

Note: Level for exported institution records This area also lets you choose a validation level for exported bibliographic institution records
Default setting None.

  • None (default setting). No validation for exported records.
  • Basic Checks the validity of elements, length, repeatability, type of data or codes, and other aspects of MARC record structure.
  • Full Verifies record structure (as for basic validation) and also checks relationships between elements.

Note: When you choose Basic or Full validation for exported bibliographic records, Connexion changes each record's Validate status and Export status as appropriate.

Records that fail validation cannot be exported until you correct the errors identified.


Save records marked for export (bibliographic records only)

  • Why use this setting? When you want to export a group of bibliographic records at once, use the Mark for Export action to mark each record as ready for export.
  • However, to do batch export, you must save the records. Only saved records can be retrieved by searching for the Export - Ready status, flagged, and exported as a group.
Action Result

On the Export Options screen, under Mark for Export and Save Record,

  • Select On or Off.

    Or

  • Keep the original default setting, Off.
  • On. If you select On, Connexion saves each bibliographic record that you mark for export.
  • Off. (default setting) If you select Off, Connexion does not automatically save bibliographic records marked for export.

Specify fields to delete from exported bibliographic or authority records

Note: The setting for bibliographic records applies to both bibliographic master records and to bibliographic institution records. On export, Connexion deletes the same fields from an IR or a master record.

Action Result

Fields to Delete on Export (Optional) Specify the fields you want to remove from each bibliographic and/or authority record before exporting the record for local use.

On the Export Options screen, under Fields to Delete on Export, separate text boxes let you specify fields to remove from each record type. In either text box, type the 3-digit MARC tag numbers for the fields to delete.


Note: The setting for bibliographic records applies to both bibliographic master records and to bibliographic institution records. On export, Connexion deletes the same fields from an IR or a master record.

  • To delete a single field, type the tag number in the text box.
  • To delete a range of fields, type the first and last tag to be removed, separated by a hyphen.
  • Separate single tags and tag ranges with commas.

Example: In the Bibliographic Records text box, type
920, 938, 945-999
to remove fields 920 and 938, and fields 945 through 999, from all exported bibliographic records.


Export to a file (default setting)

  • Use export to a file if you have not set up a direct TCP/IP connection from OCLC Connexion to your library's local system.
  • Export files:
    • Are created and stored on the Connexion server.
    • Allow appending until downloaded. You can continue exporting to the same file until you download the file.
    • Contain records in one format. Separate export files are created for authority records. If you export bibliographic records in more than one format, such as MARC and Dublin Core HTML, the system creates a separate file for each export format used.
    • Contain records of a specific format that are exported either by any user from one institution (OCLC symbol) or by one user (authorization number). The default file type is Institution. To create export files for your individual authorization, set the Export File Type option (on the Export Options screen) to Individual.
    • Remain available for download for 30 days from the file creation date. After 30 days, the system automatically deletes export files.
  • Exported authority records. If you export authority records, the Download Export Files screen includes a separate list for authority record export files.
  Action Result or Note
1

On the Export Options screen, under Export Destination, select Export to a File.

  • When you export records, the system adds the records to a file on the Connexion server.
  • Until you download the file, records you export are added to the export file.
  • To use the exported records, download the export file to your workstation.
2

Optional. Specify a file name for downloaded export files.

  • On the Export Options screen, under Export File Name, type the file name and extension in the File Name text box.
  • Or keep the default file name, export.dat.
  • Name specified. When you download an export file from the Download Export Files screen, the system automatically supplies the specified file name and extension.
  • Default name. If you do not specify a file name, the system supplies the default name, export.dat.
  • Change name or extension during downloading. If necessary, you can change the supplied file name before saving the file.
3

Optional. Specify the type of export file to use.

On the Export Options screen, under Export File Type, select Institution (default setting) or Individual.

Note: This setting determines how records accumulate in each file. Regardless of this setting, Connexion checks for record format and creates a separate export file fore each format.

If you select:

  • Institution export file (default setting). Connexion creates export files that contain records exported by anyone logged on with an authorization number linked to your library's OCLC symbol.
  • Individual export file. Connexion creates export files that contain records exported by a user logged on with a specific authorization number.

Export to local system via TCP/IP

  • Your local system must be able to accept records directly via TCP/IP.
  • If your site uses a firewall to isolate internal systems from the Internet, you must provide a port that allows OCLC Connexion to access your local system through the firewall.
  • Your site's firewall system must recognize and accept export data sent by the server from any numeric IP address within the following address range: 132.174.2.0/24 (all numeric addresses from 132.174.2.1 through 132.174.2.253). If you have questions about firewall requirements for TCP/IP export, contact OCLC Customer Support.

    E-mail a support question: To e-mail questions to Customer Support, at the top right corner of the Connexion browser screen, click Contact. Select Problem/Question as the message type and select OCLC Support as the recipient.

  Action Result or Note
1

On the Export Options screen, under Export Destination, select Export to a TCP/IP Connection.

When you export records, the system sends each record directly to your local system via a TCP/IP connection you specify.

2

Under TCP/IP Connection Options, complete both items:

  • Host Name. Type either the TCP/IP name (example: lib.domain.edu) or the numeric TCP/IP address of the host computer that runs your local system.
  • Port Number. Type the number of the port at your site that provides direct access to your local library system.

Firewall setup. If your local system is behind your site's firewall, complete the following steps:

  1. Specify a host name/address and port number that provide access to your local system through the firewall.
  2. Configure the firewall software to recognize and accept data from any numeric IP address within the following address range: 132.174.2.0/24 (all numeric addresses from 132.174.2.1 through 132.174.2.253).
  3. The port range is the same for any IP address: 30000-30499.
3

Under TCP/IP Host Settings, select one or both of the options if required for your local system.

Default setting: both check boxes cleared, options not selected.

Permanent Connection

Select the check box

Notify Host before Disconnect

Select the check box

4

Under TCP/IP Timeouts and Retries, accept the default values unless your local system requires that you change the.

Timeout

Specify how long (in seconds) the system should wait for a response from your local system before abandoning the attempt to connect.

Retries

Specify the number of times the system should retry to connect to your local system after a failed attempt.

Delay

Specify how long (in seconds) the system should wait after connecting to the local system before transmitting data to the local system.

5

Under TCP/IP Local System User Information,

  • Supply the information your local system requires for authentication (Logon ID, Password, and/or User ID).
  • Select the appropriate check box(es) to have the system send the information you supplied when requesting access to your local system.
 

TCP/IP export options: definitions

TCP/IP setting Definition Notes
Host Name
  • IP address or IP name for the local system host.
  • IP address. Internet Protocol address. Also referred to as the Internet address. A unique address for a machine in a TCP/IP network. It is a 32-bit address comprising four 8-bit segments, each separated by a period (.). Each 8-bit segment is a number from 0 to 255.
  • IP name. Internet Protocol name. A unique name for a machine in a TCP/IP network that you can use in place of the machine's IP address. It comprises at least two segments, each separated by a period (.).
 
Port Number
  • Port number on the host to which you want to export records.
  • TCP/IP port. A TCP/IP software channel through which other machines on a TCP/IP network communicate with a TCP/IP host for specified services.

Firewalls

If your site uses a firewall to isolate internal systems from the Internet, the port number for export to your local system must provide a path through the firewall, directly to your local system.

Permanent Connection

If your local system disconnects you after each export, select this check box to stay connected.

 
Notify Host before Disconnect
  • If your local system requires that you notify it before you disconnect, select this check box.
  • When this box is selected, the system sends a notification message to your local system before disconnecting.

 
Timeout
  • Specify the number of seconds to wait for local system response. There is no upper limit.
  • When the specified time expires, the system considers the export to have failed and closes the TCP/IP export destination.

 
Retries
  • Specify the number of times to retry connecting to the local system if the first try fails.
  • There is no upper limit.

 
Delay
  • Specify the number of seconds to wait after connecting to the local system before transmitting data to the local system.
  • There is no upper limit.

 
Send Logon ID
  • Select this check box to send the logon ID and password before each export to the local system.
  • Enable this setting only if your local system vendor specifies it.

 
Logon ID

If your local system requires a logon ID before each export, type the local system logon ID in this text box.

 
Password

If your local system requires a password for authorization, type the password in this text box.

 
Send User ID

Select this check box to send the user ID before each record exported to your local system.

 
User ID

If required for your local system to process the export, type ID of the user authorized to export records.

 

back to top

Export authority records

Records you can export

  • Single authority record in MARC format. This function is available when you display or edit the record in the appropriate view.
  • Multiple records in MARC. This function is available when you flag records you want to export.
  • More than 100 records per export action. You can export more than 100 records at once. However, to prevent timeout problems that can occur with larger batches, Connexion browser pauses after exporting 100 records and asks you to confirm that you want to continue processing the flagged records.
  • Records retrieved from
    • Authority File
    • Authorities save file
  • Saved records. You can export saved records only if the records exist in the Authority File (that is, the records have LCCNs and ARNs). You cannot export a new record not yet added to the Authority File.

Export methods

Export method What you need to know to use it
Export to a file on the Connexion server

How it works

When you take an export action (on one record or a group of records), the system creates a file on the server that contains the record(s).

How to use it

This is the default export method. Unless you select the other export method (TCP/IP export), the system always exports records to a file on the server.

Append records to file

You can export records to a file and then append more exported records to the same file. The file remains open and accepts additional records until you download the file.

Download export files

When finished exporting, download the export file to your workstation.

Export to a TCP/IP connection

How it works

When you export records, the system sends each record directly to your local system via TCP/IP.

How to use it

To export directly to a local system, you must:

  • Specify that you want the system to use TCP/IP export.
  • Supply the name of the host computer on which your local system is located, and the TCP/IP port to use when adding records to the local database.

Select an export method

  Action
1

Go to the Export Options screen

On the General tab, under Admin, click Preferences.

At the Preferences screen, click Export Options.

2

Specify export method

On the Export Options screen, under Export Destination,

Select Export to a File

Or

Select Export to a TCP/IP Connection

3

Complete TCP/IP export settings

If you select Export to a TCP/IP Connection, you must supply additional information.

Complete optional setup for export to a file:

For export to a file, no other settings are required. However, you can choose whether to create files that contain records exported by any user at your institution or by individual users. You can also specify a file name to be used when you download export files.

4

Save as default or change for current session

  • To use your modified export options for the current session only, at the top or bottom of the Export Options screen, click Save For Session.

    Or

  • To use the modified options as the default for future sessions, click Save My Default.

Validate exported authority records

  • You can choose the level of validation applied for exported authority records. On the Export Options screen, under Validate Exported Bibliographic and Authority Records, select None (default setting) or Basic or Full.
  • The setting applies when you export a single authority record.
  • Validation increases time required for export. With validation on, exporting takes longer to complete.
Action Result

On the Export Options screen, under Validate Exported Bibliographic or Authority Records, select None or Basic or Full.

Note: You can also set the validation level on the Authority Options screen under Validation Levels. If you change the setting on either screen, it changes automatically on the other screen.

  • None (default setting) Connexion does not validate exported authority records.
  • Basic Checks the validity of elements, length, repeatability, type of data or codes, and other aspects of MARC record structure.
  • Full Verifies record structure (as for basic validation) and also checks relationships between elements.

Note: Records that fail validation cannot be exported until you correct the errors identified.


Specify fields to delete from exported authority records

  • You can have the system remove specific fields from each authority record before exporting the record for local use.
  • You use tag numbers to specify single fields and/or field ranges.

Export single authority record

  Action
1

Retrieve the record you want to export. You can export a record retrieved from the Authority File or the authorities save file.

2

On the Action list, click Export Record in MARC.

Or press <Alt><K> and then <E> (or <Alt><J> and then <E>).

Results

  • Validation. If you choose Basic or Full validation, Connexion validates each record before exporting. Records that fail validation cannot be exported until you correct the errors identified.
  • For export to a file, the system exports the record to a file on the Connexion server. The system creates a new file or, if an export file exists, adds the record to the open file.
  • For TCP/IP export, the system exports the record directly to your local system.

Note: The system adds the date/time stamp of the export to the 005 field.


Export multiple authority records

More than 100 records per export action

  • You can export more than 100 records at once.
  • However, to prevent timeout problems that can occur with larger batches, Connexion browser pauses after exporting 100 records and asks you to confirm that you want to continue processing the flagged records.
  Action
1 Retrieve a set of authority records that includes records you want to export.
2

Flag the records you want to export.

  • Results list. At a results screen (Authority File or authorities save file), click the open box in front of the brief entry for each record or open the Action/Sort list (top right corner of screen) and click Flag All on Page or Flag All Records Retrieved.
  • Full record. On the Action list, click Flag Record.
3

(Optional) Repeat steps 1 and 2 to retrieve and flag more records for export.

4

At the top of the results screen, open the Action/Sort list and click Export Flagged Records.

The system displays an Export screen listing all records flagged for export.

Note: Flagged records not in current results list.

If all the records you flagged are not in the current result set, use a Show Flagged option to retrieve a list of all flagged records in the Connexion Authority File or the authorities save file.

  • On the Authorities tab, under Show Options, click Flagged AF Records or Flagged SF Records.
  • On the flagged records screen, open the Action/Sort list and click Export Flagged Records.
5

At the top of the Export screen, click the MARC button.

Results

  • For export to a file, the system exports the records to a file on the Connexion server. The system creates a new file or, if an export file exists, adds the records to the open file.
  • For TCP/IP export, the system exports the records directly to your local system.

Download export files

  • Export files:
    • Are created and stored on the Connexion server.
    • Allow appending until downloaded. You can continue exporting to the same file until you download the file.
    • Contain records in one format. Separate export files are created for authority records and bibliographic records.
    • Contain records of a specific format that are exported by users from one institution (OCLC symbol) or by one user (authorization number). The default file type is Institution. To create export files for your individual authorization, set the Export File Type option (on the Export Options screen) to Individual.
    • Remain available for download for 30 days from the file creation date. After 30 days, the system automatically deletes export files.
    • Exported authority records. The Download Export Files screen includes a separate list for authority record export files.
  Action
1

Go to the Download Export Files screen.

On the General tab, on the Admin Options list, click Download Export Files.

2
  1. In the list of files, find the file(s) you want to download.
  2. Click to select the check box for the file.

    Download multiple files: You can download 2 or more files at once. Before sending the files to the browser, the system creates one file that contains records from all selected export files.

3

When finished selecting files, click Download.

4

The next step depends on which browser you use.

  • Internet Explorer. In the File Download dialog box, select Save or press <Enter>.
  • Netscape Navigator. In the Unknown File Type dialog box, click Save File.
5
  1. In the Save As dialog box, use the Save In box to select the location (drive and folder) where you want to save the exported record.
  2. In the File Name box, use the supplied name.

    Or

    Change the supplied file name and add the appropriate extension:

    • Supply a name that identifies the file as containing records exported from Connexion. You may want to include a date or day of the week and/or the type of records contained in the export file.
    • Add an extension to the filename.

      Note: An extension, such as .dat or .exp or .mrc, identifies the file format and/or content. A specific extension may be required if you plan to import record(s) from the file to a local system or other software.

    • Note: To change the default file name for export files, use the Export File Name setting on the Export Options screen.
6
  • Click Save or press <Enter>.
  • Click Close or press <Enter> to close the Download Complete message box.

Tip: Override browser-supplied file type and name for export file

Note: To change the default file name for export files, use the Export File Name setting on the Export Options screen.

  Action
1

When the Save As dialog box appears, the browser supplies a default location (drive and folder), file type, and file name. The File Name box is selected.

To override the default file type and file name:

  • In the File Name box, type the name for the export file, including the extension, enclosed in quotation marks. Use the extension your software requires to identify the file as a MARC export file (for example, .dat, .exp, or .mrc).
  • Example

    "exp1017.dat"

To save the export file to a different location, specify the drive and folder within the quotation marks:

  • Type the drive letter followed by a colon and a backslash.
  • Type the folder name(s), separated by backslashes.
  • Example

    "c:\data\export0310\exp1017.dat"

2

Click Save or press <Enter>.


Manage export files

This section summarizes information and functions provided on the Download Export Files screen.

Column in file list Purpose or content

Select

Provides check boxes for selecting listed files.

Authorization

Column is blank for institution files that contain records exported by any user at your institution.

For individual files, the column shows the authorization number under which the file was created. May show your authorization number or that of any user from your institution.

Created

Date and time when the file was created.

Format

Data format of records in the export file. Possible values are MARC, DC HTML, and DC RDF.

Bytes

Size of file in kilobytes.

Downloaded

Date and time when the file was first downloaded

Shows Not Downloaded for a file not yet downloaded.

Hidden

Appears when you click Show Hidden Files to view a list containing files previously hidden.

If the file is currently hidden, lists the date and time the file was hidden.

If the file has been restored to the list, the column is blank.


Action Procedure

Download an export file

Select the check box for the file and click Download.

Hide downloaded file

Select the check box for a previously downloaded file and click Hide.

Show hidden file

Click Show Hidden Files.

Restore hidden file to list

Click Show Hidden Files.

Select the check box for a hidden file and click Restore.

Clear selections

Click Reset.


Format details: exported authority records

For a detailed description of exported MARC authority records, see OCLC-MARC Records.

back to top

Download export files

    Download export files

    • Export files:
      • Are created and stored on the Connexion server.
      • Allow appending until downloaded. You can continue exporting to the same file until you download the file.
      • Contain records in one format. Separate export files are created for authority records. If you export bibliographic records in more than one format, such as MARC and Dublin Core HTML, the system creates a separate file for each export format used.
      • Contain records of a specific format that are exported by users from one institution (OCLC symbol) or by one user (authorization number). The default file type is Institution. To create export files for your individual authorization, set the Export File Type option (on the Export Options screen) to Individual.
      • Remain available for download for 30 days from the file creation date. After 30 days, the system automatically deletes export files.
    • Exported authority records. If you export authority records, the Download Export Files screen includes a separate list for authority record export files.
      Action
    1

    Go to the Download Export Files screen.

    On the General tab, on the Admin Options list, click Download Export Files.

    2
    1. In the list of files, find the file(s) you want to download.
    2. Click to select the check box for the file.

      Download multiple files: You can download 2 or more files at once. However, files downloaded together must contain records in the same format. Before sending the files to the browser, the system creates one file that contains records from all selected export files.

    3

    When finished selecting files, click Download.

    4

    The next step depends on which browser you use.

    • Internet Explorer. In the File Download dialog box, select Save or press <Enter>.
    • Netscape Navigator. In the Unknown File Type dialog box, click Save File.
    5
    1. In the Save As dialog box, use the Save In box to select the location (drive and folder) where you want to save the exported record.
    2. In the File Name box, use the supplied name.

      Or

      Change the supplied file name and add the appropriate extension:

      • Supply a name that identifies the file as containing records exported from Connexion. You may want to include a date or day of the week and/or the type of records contained in the export file.
      • Add an extension to the filename.

        Note: An extension, such as .dat or .exp or .mrc, identifies the file format and/or content. A specific extension may be required if you plan to import record(s) from the file to a local system or other software.

      • Note: To change the default file name for export files, use the Export File Name setting on the Export Options screen.
    6
    • Click Save or press <Enter>.
    • Click Close or press <Enter> to close the Download Complete message box.

    Tip: Override browser-supplied file type and name for export file

    Note: To change the default file name for export files, use the Export File Name setting on the Export Options screen.

      Action
    1

    When the Save As dialog box appears, the browser supplies a default location (drive and folder), file type, and file name. The File Name box is selected.

    To override the default file type and file name:

    • In the File Name box, type the name for the export file, including the extension, enclosed in quotation marks. Use the extension your software requires to identify the file as a MARC export file (for example, .dat, .exp, or .mrc).
    • Example

      "exp1017.dat"

    To save the export file to a different location, specify the drive and folder within the quotation marks:

    • Type the drive letter followed by a colon and a backslash.
    • Type the folder name(s), separated by backslashes.
    • Example

      "c:\data\export0310\exp1017.dat"

    2

    Click Save or press <Enter>.


    Manage export files

    This section summarizes information and functions provided on the Download Export Files screen.

    Column in file list Purpose or content

    Select

    Provides check boxes for selecting listed files.

    Authorization

    Column is blank for institution files that contain records exported by any user at your institution.

    For individual files, the column shows the authorization number under which the file was created. May show your authorization number or that of any user from your institution.

    Created

    Date and time when the file was created.

    Format

    Data format of records in the export file. Possible values are MARC, DC HTML, and DC RDF.

    Bytes

    Size of file in kilobytes.

    Downloaded

    Date and time when the file was first downloaded

    Shows Not Downloaded for a file not yet downloaded.

    Hidden

    Appears when you click Show Hidden Files to view a list containing files previously hidden.

    If the file is currently hidden, lists the date and time the file was hidden.

    If the file has been restored to the list, the column is blank.


    Action Procedure

    Download an export file

    Select the check box for the file and click Download.

    Hide downloaded file

    Select the check box for a previously downloaded file and click Hide.

    Show hidden file

    Click Show Hidden Files.

    Restore hidden file to list

    Click Show Hidden Files.

    Select the check box for a hidden file and click Restore.

    Clear selections

    Click Reset.


    back to top

    Export flagged authority records

    About the flagged record export screen

    • The system displays this screen when you flag authority records and take the Export Flagged Records action (available on results screens (Authority File or authority save file), on the Flagged AF Records screen, or the Flagged AF Save File screen).
    • Note: You can export saved records only if the records exist in the Authority File (they have LCCNs and ARNs). You cannot export a new record not yet added to the Authority File.
    • The system exports the authority records using your current export method. For export to a file, the system stores the records in an appendable file on the Connexion server. For TCP/IP export, the system sends the records directly to your local system.

    Use this screen

      Action
    1

    At the top of the Export screen, click MARC.

    Results

    • For export to a file, the system exports the records to a file on the Connexion server. The system creates a new file or, if an export file exists, adds the records to the open file.
    • For TCP/IP export, the system exports the records directly to your local system.
    2

    If you export to a file, when ready to download exported authority records:

    Go to the Download Export Files screen.

    On the General tab, on the Admin Options list, click Download Export Files.

    3
    1. In the list of files, find the file(s) you want to download.
    2. Click to select the check box for the file.

      Download multiple files: You can download 2 or more files at once. Before sending the files to the browser, the system creates one file that contains records from all selected export files.

    4

    The next step depends on which browser you use.

    • Internet Explorer. In the File Download dialog box, select Save or press <Enter>.
    • Netscape Navigator. In the Unknown File Type dialog box, click Save File.
    5
    1. In the Save As dialog box, use the Save In box to select the location (drive and folder) where you want to save the exported record.
    2. In the File Name box, use the supplied name.

      Or

      Change the supplied file name and add the appropriate extension:

      • Supply a name that identifies the file as containing records exported from Connexion. You may want to include a date or day of the week and/or the type of records contained in the export file.
      • Add an extension to the filename.

        Note: An extension, such as .dat or .exp or .mrc, identifies the file format and/or content. A specific extension may be required if you plan to import record(s) from the file to a local system or other software.

      • Note: To change the default file name for export files, use the Export File Name setting on the Export Options screen.

    Export format for authority records

    Format Description
    MARC Complies with MARC21 standard. Formatted as for records exported from OCLC WorldCat.

    Caution: Exporting flagged records

    When you export flagged records, the system exports a snapshot of each record as it appeared when flagged. Changes made to the record after you flag it are not reflected in the exported record.

    To avoid exporting records that do not reflect all your editing, use the following workflows when editing records for export.

    • Edit the record locally. When finished modifying the record, update holdings. While the edited version is still displayed, flag the record. At the end of your work session, retrieve the list of flagged records and export.
    • If you want to make further changes to any one of the flagged, updated, edited records, open the flagged record in local edit mode, modify the record, unflag the record, and then reflag the edited record.

    Note: Flagging works the same way if the record is in master edit mode. A snapshot is taken when the record is flagged and the snapshot does not change if you continue to edit the record after flagging.

    back to top

    Import bibliographic or authority records

    Why import records?

    • Contribute bibliographic or authority records created in your library's local system.
    • Process bibliographic records from OCLC offline services: PromptCat, Bibliographic Record Notification, GovDoc, and WorldCat Collection Sets.
    • Process unresolved Batchload records.

    Records you can import

    • Bibliographic or authority records:
      • MARC format only (OCLC-MARC or MARC21).
      • Exported from a local system. Export the records to a file via your system's MARC export function.
    • Bibliographic records received from OCLC offline services: PromptCat, Bibliographic Record Notification, GovDoc, WorldCat Collection Sets, and Batchload.
    • OCLC bibliographic records (records that contain an OCLC control number in the 001 field) from offline products or from your local system.
    • Note: Use imported OCLC bibliographic records.
      • You can take most actions on imported OCLC bibliographic records, including: Derive New Record, Export, Update Holdings, and Validate.
      • Cannot delete holdings. Imported OCLC records do not contain the indication that the item is Held or Not Held by your library. You cannot take the Delete Holdings action on imported record. To view holdings for the item, take the Display Holdings action.
      • Caution: Lock and Replace. If you use an imported OCLC bibliographic record to lock the corresponding master record, Connexion locks and displays the current version of the master record, overwriting any changes you made to the imported record. The system warns you that your changes will be lost and asks whether you want to continue.
    • OCLC authority records (records that contain an OCLC Authority Record Number (ARN)) exported from your local system or supplied via the OCLC MARS service.
      • Record actions: Derive only. To use an imported OCLC authority record, you must first take the Derive New Record action. You cannot take other actions on the imported record. After completing the derived record, you can take any action, including: Export Record, Submit Record for Review, and Add Record.
      • Cannot validate. Imported OCLC authority records do not pass validation in Connexion browser. Internal dates in imported authority records do not match the system date. You cannot correct this problem by modifying the record. To use the content of the imported record within Connexion, derive a new record from it; the derived record does not contain the mismatched internal date.
      • Caution: Lock and Replace. If you use an imported OCLC authority record to lock the corresponding master record, Connexion locks and displays the current version of the master record, overwriting any changes you made to the imported record. The system warns you that your changes will be lost and asks whether you want to continue.
    • Non-OCLC bibliographic records.
      • Imported as new records (workforms)
      • On these records, you can take any actions that are available for bibliographic workforms generated within Connexion.
    • Non-OCLC authority records
      • Imported as new records (workforms)
      • On these records, you can take any actions that are available for authority workforms generated within Connexion

    About import files

    Property Requirements and notes

    Format

    OCLC-MARC or MARC21 only.

    Caution:

    • Non-MARC files. If you try to import from a non-MARC file (for example, a file with the extension .doc, .xls, .mdb, .msg, .gif, .jpeg, or .tif), Connexion displays an error message.
    • File with corrupt or fragmented MARC records If you try to import from a corrupted file of MARC records, or a file that contains some MARC data, the system cannot process the file. If the browser is inactive for more than 5 minutes, click the Stop button. Then check the file for problems before retrying import.

    Record types

    Bibliographic records

    Authority records

    Size

    No prescribed maximum for file size (KB or MB).

    Connexion imports records in groups of 100, pausing after each group to ask you to confirm that you want to continue.

    Maximum number of records you can import depends on the number of records currently in your bibliographic or authority save file. Save files can contain up to 9,999 records.

    Location

    Disk: Hard disk or network drive connected to local workstation.

    URL: Public Web server. Connexion must be able to retrieve the file via an HTTP request.

    Note: No FTP support. Due to security measures, the import function cannot retrieve files via FTP; only the HTTP protocol is supported.


    Prepare to import records

      Action
    1

    Select and/or set up the location (local drive or URL) for files of records to import.

    2

    Create or retrieve file of records to import.

    • Export bibliographic or authority records from OCLC software or from your local system

      Or

    • Retrieve a file of bibliographic records received from your OCLC cataloging service (PromptCat, Bibliographic Record Notification, GovDoc, WorldCat Collection Sets, or Batchload)
    3

    Move the file of records to the local drive or upload to the Web server.

    4

    (Optional) Decide whether to apply constant data or insert My Status notes in the imported records:

    • Bibliographic records
      • Apply default constant data. Verify that your current default constant data record is appropriate. Edit the default CD record or designate another CD record as your default CD. Change the Fields to Apply setting if desired.
      • Include My Status note. When importing records from an OCLC service, select the My Status option and specify the appropriate record type. For other records, leave the record type box empty. For any group of imported records, assign a distinctive My Status note to help you manage the records in the bibliographic save file.
    • Authority records
      • Apply default constant data. Verify that your current default authority constant data record is appropriate. Edit the default CD record or designate another CD record as your default authority CD. Change the Fields to Apply setting if desired.

    Import bibliographic or authority records

      Action
    1

    Log on to Connexion browser.

    2

    On the Cataloging tab or the Authorities tab, under Create Options, click Import Records.

    3

    Specify the records to import.

    Under Type of Records to Import:

    • Select Import Bibliographic Records to import bibliographic records only.

      Or

    • Select Import Authority Records to import authority records only.

      Or

    • Select both check boxes if the file contains both bibliographic and authority records and you want to import both record types at once.
    4

    Specify the file location.

    Under File Location:

    • In the Disk text box, type the full path (drive letter, folder, and file name) for an import file on a local hard disk or network drive. Or click the Browse button to navigate to the location.

      Or

    • In the URL text box, type the URL for an import file located on a Web server. Note: You must specify the URL using the HTTP protocol, beginning with http://

    Note:

    • Below each text box, the screen shows the location from which you last imported records.
    • Specify either a disk location or a URL. If you click Import with text in both boxes, an error message appears.
    5

    (Optional) Apply default constant data

    Under Import Bibliographic Records or Import Authority Records:

    • Select the Apply Default Constant Data check box to apply your default constant data record to imported bibliographic records and/or authority records.

      Or

    • Clear the check box to import records without applying constant data.
    6

    (Optional) Assign My Status to bibliographic records

    Under My Status for Bibliographic Records:

    • Type. For records from OCLC offline services, select the service that supplied the records you plan to import. For other records, leave the Type box empty.
    • Identifier box. For any bibliographic record, type a distinctive note to help you retrieve and manage imported records in the bibliographic save file.
    7

    Click Import.

    Results

    • Connexion imports the specified records, beginning with the first record in the file.
    • The system adds the records to the bibliographic save file and/or the authority save file with the source status Imported.
    • Non-OCLC records are imported as OCLC workforms.
    • Based on the options you select, the system applies default constant data and/or inserts My Status notes (bibliographic records only).
    • After importing all specified records, Connexion displays a results screen that gives totals for bibliographic and/or authority records and reports actions taken on the records.

    More than 100 records in file

    If the import file contains more than 100 records:

    1. Connexion imports the first 100 records.
    2. The system displays a status screen and asks you to confirm that you want to continue importing records. Click OK or press <Enter> to continue importing with the next record in the file.
    3. After importing each group of 100 records, the system again pauses and asks you to click OK or press <Enter> to continue.

    Imported records: details

    • All imported records are assigned the source status Imported.
    • MARC21 records are converted to OCLC-MARC.
    • Non-OCLC records are converted to workforms
    Record type OCLC record Non-OCLC record

    Bibliographic

    • Workflow status: In process
    • Save file expiration date: 14 days.
    • OCLC control number retained in 001.
    • If Lang in fixed field is 3 blanks, change to N/A.
    • If record contains 533 $7, convert the data to a 539 field.
    • Delete field 994 if present.
    • Workflow status: New
    • Save file expiration date: 28 days.
    • NEW in 001.
    • Entered date replaced with current date.
    • RecStat value set to n.
    • Default 040 field inserted.
    • If Lang in fixed field is 3 blanks, change to N/A.
    • If record contains 533 $7, convert the data to a 539 field.

    Authority

    • Workflow status: In process
    • Save file expiration date: 90 days.
    • ARN retained in 001.
    • Workflow status: New
    • Save file expiration date: 90 days.
    • NEW in 001.
    • Entered data replaced with current data.
    • RecStat value set to n.
    • EncLvl value set to n.
    • Default 040 field inserted.
    • Fields deleted: 002, 003, 004, 005, 009, 010, and 035.

    Find imported bibliographic records

    Action

    Show by Status screen On the Cataloging tab, under Show Options, click By Status.

    1. At the status list screen, under Show Save File, Source Status, select the check box for the Imported status.
    2. Then click Show Records or press <Enter>.

    Or

    Search Save File screen On the Cataloging tab, under Search Options, click Save File.

    • Search for Imported status. On the Search Save File screen, at the bottom of the search form, open the Source Status list and click Imported.
    • Search for My Status text. In the Search for box, type the text you supplied on the Import Records screen. You can search for any whole word in the note. Search for the Type only (if specified), for any word in the free-text Identifier, or for the complete My Status note (Type plus user-defined note).

      Example If you selected PromptCat from the Type list and also supplied the date 20031031 in the Identifier box, you can retrieve the records by searching for PromptCat only, for 20031031 only or for the complete note PromptCat 20031031.

    • Then click Search or press <Enter>.

    Find imported authority records

    Action

    Show by Status screen On the Authorities tab, under Show Options, click By Status.

    1. At the status list screen, under Show Save File, select the check box for the Imported status.
    2. Then click Show Records or press <Enter>.

    Or

    Search Authorities Save File screen On the Authorities tab, under Search Options, click Save File.

    • On the Search Save File screen, at the bottom of the search form, open the with Status list and click Imported.
    • Then click Search or press <Enter>.

    Download OCLC records

    Use this procedure to download records from the Product Services Web.

      Action
    1

    Point your Web browser to Product Services Web at http://psw.oclc.org/ and press <Enter>.

    2

    Click Records and Reports.

    3

    Click the service that supplies the records you want.

    4

    Enter an authorization number and password and click OK.

    5

    Right click the Download link next to the record file. Click Save Target As.

    6

    To download the file, click Save.


    For more information, see the Product Services Web Quick Reference at:
    http://www.oclc.org/support/documentation/batchprocessing/using/productservices/

    Unresolved Batchload Records

    Unresolved records are bibliographic records for which no match was found in WorldCat by the OCLC Batchload service. These records fail to match for a variety of reasons, including legitimate differences in cataloging practice, data errors, or other problems. OCLC posts files of unresolved batchload records on the Product Services Web.

    Unresolved records have the following characteristics:

    • They have the word NEW instead of an OCLC Control Number.
    • The file of records remains on the Product Services Web for 90 days before being deleted automatically.
    • If the unresolved records are generated by group batchload projects, they have identifiers in the 951 field.

    Process unresolved batchload records

      Action
    1

    Perform this procedure after you have downloaded your unresolved batchload records from OCLC Product Services Web, imported them into your Connexion interface (browser or client), and retrieved them. See earlier sections of this topic for these procedures.

    2

    Search WorldCat for the item to see if a record exists.

    3

    If a record exists (individual institution project): Follow local practice to determine if you should use the record you found instead of the one from your project. If you use the record you found, edit it as needed.

    If a record exists (group project): Copy the library identifier from the 951 field in the unresolved record and paste it into the WorldCat record you found.

    If no record exists: Edit the unresolved record, as needed.

    4

    Take final action on the record (produce, update, save, export).

    5

    Delete the unresolved record from the save file, if needed.


    back to top