Delimited Records

 
7. On the Data Import - Step 2, set the delimiters for your data. Your changes display in the preview pane.
  • In the Field Delimiter list, choose how the fields in the file will be separated: comma, semicolon, tab, or space.
  • In the Text Qualifier list, choose the character you want to mark the beginning and end of data in a field, or choose no character. For example, if a field contains lastname, firstname, the data might be enclosed within quotes, as in “lastname, firstname”.
  • Click Next.
 
8. On the Data Import - Step 3, indicate the field mapping configuration to be used during the import session.
A. In the check box column, no fields are selected by default. Select the check box next to each field you want to import.
B. In the Action column, select Keep or Replace for each field and subfield you plan to import.
  • Select Keep if you want the data currently stored in that field to be kept during the import procedure.
  • Select Replace if you want to change the current data in a field to a constant value (such as a library name, regional code, or field label) during the import procedure. A keyword box will display in the Field Data column; type the information you want to appear in this field.
C. In the Map To column, enter the destination MARC field and subfield for each field you plan to import. Type a new field and subfield in the text box, or click the arrow to the right and select a field and subfield in the window.
D. Click Next.
 
If you will be importing the same type of data in the same format multiple times, you can save the field map after you create it. Click on the Save button in the Field Mappings box and enter a name for the map.
 
To use a previously saved field map, click Load in the Field Mappings box. A window will open with a list of the previously saved field maps. Click Load next to the name of the desired map. At this point you can modify the field map again or click Next and skip to Data Import -- step 3.
 
9. On the Data Import - Step 4, specify the import options.
 
Tip: You must have 852 fields
in the records you are
importing or other fields
mapped to 852 in order for
Update barcode values in
852 field with to work. If no
852 field is found in a record,
then no barcode is generated
for that record.
 
A. You can create new barcodes for the records being imported, whether barcodes exist in the original records or not. To do so, select the Update barcode values in 852 field with check box under Barcode. Then:
  • Prefix – To assign a constant prefix to the barcode, type it here. For example, type B for bibliographic records or P for patron records. You must assign different prefixes to bibliographic records and patron records.
  • Suffix Starting Value – To assign an incrementing suffix to the barcodes in the order they import into the system, type the numeric starting value for these records (for example, type 1).
  • Suffix Increment By – If you assign a suffix, type the number of increments you want the records to increase by (for example, 1 increment).
B. If you are importing bibliographic records, the Duplicates options are available. Choose one of the following:
  • To prevent the import of records that may duplicate existing records, click Don’t allow duplicates. (All fields in two records need not match for the records to be considered duplicates; for example, two bibliographic records may be considered duplicates if just the ISBN field matches.)
  • To import records that may duplicate existing records, click Allow duplicates.
  • To be prompted when duplicate records are found during the import process, click Prompt if duplicates are found option. This lets you compare the record you are importing to the existing record, and then decide whether to import the duplicate record.
C. If you are importing bibliographic records, the Holding Records option is available. If you do not want to generate holding records, clear the Generate holding records check box. Otherwise, leave it selected.
D. In the Unicode box, you can choose to convert records to Unicode, convert records to MARC8, or not convert records.
E. In the Default group list, select the group you want the imported data assigned to by default.
F. If you want to assign a rule to this data, click the Expand View button next to Group Assignment Rule.
  • Select the check box to the left of the first box to activate it. To the right of the box, click the arrow button.
  • Enter the rule you want assigned. (Example: Type 852k under Field, select Equals, and then type REF under Text.)
  • Click Add. Add other rules if desired. When finished, click Close.
  • In the list to the right of the arrow, select the group to assign records to when they meet the rule criteria. (Example: Select Reference Collection to complete the example in step 2.)
 
10. When finished, click Finish. While the import processes, a progress bar displays. If a duplicate record is found and you selected Prompt if duplicates are found in step 9B, the Bibliographic Compare window displays.
 
Using the four buttons, you have the following choices:
  • Save Existing – Saves the existing record and does not import the duplicate record. All corresponding holding records are imported. Result: One bibliographic record with all corresponding holding records.
  • Replace Existing – Imports the duplicate record and replaces the existing record. All corresponding holding records are also imported. Result: One bibliographic record with all corresponding holding records.
  • Import – Imports the duplicate record and keeps the existing record. All corresponding holding records are also imported and linked to the duplicate bibliographic record. Result: Two bibliographic records and two sets of holdings - the existing bibliographic record and its original holdings, and the duplicate bibliographic record and its corresponding holdings.
  • Do not Import – Does not import the duplicate record. Result: The bibliographic record and its holding records remain the same.
 
Tip: Select the Don’t show
this window again check box
before clicking a button to
apply the action to the
displayed record and all
records being imported in
this session.
 
11. When the import procedure is complete, the import summary displays. Click OK to return to the Import page, or click Print to print the summary.