Main -> Documentation -> OCLC SiteSearch Record Builder -> Performing Online Updates to Local Databases with Record Builder

Performing Online Updates to Local Databases with Record Builder


Beginning with Open SiteSearch 4.1.0, Open SiteSearch Database Builder includes the Record Builder application. Record Builder allows cataloguers to perform online database updates to local databases one record at a time. If the local database is available to patrons through the WebZ interface, a cataloguer can update the database while your patrons still have access to the database. Only the record being added, modified, or deleted is locked (unavailable to patrons or other staff using Record Builder) until the cataloguer submits the new or modified record to the database.

Online database updates in Record Builder include:

If your system uses the Access component to provide staff authentication and authorization for Record Builder, a cataloguer must possess the proper privileges to add, edit, or delete records for a particular database. All cataloguers may not have the same privileges for every database.

Except for adding a new record to a local database, online record updates begin with locating a record and then opening (locking) the record. See these procedures for information about locating records:


Document Conventions

  • The term "you" refers to a cataloguer or other authorized staff member using Record Builder to perform online database updates.
  • Each procedure assumes that you have opened Record Builder in a Web browser:

    New record screen

    See Record Builder Display Layout for information about the features of the Record Builder interface. The graphics in this topic show only the work area of the display.


Adding a Record to a Local Database

Follow this procedure to use Record Builder to create a new record in a local database.

1. Find the database's name, such as US National Parks in the example shown here, and the workform (data entry form) you want to use to create the record. (The names underneath the database name are all of the its available workforms.) Click the desired workform name.

Selecting a workform

2. The workform you select appears, ready for you to enter data:

  • Type or select a value for the fields you want to complete (no fields are required). See Data Entry Fields and Buttons and for more information about the fields and buttons on the workform.
  • If the resource you are cataloging is available on the Internet or your intranet, click Open URL on the Options menu to see the resource in a second browser window.

Blank workform

3. When you finish entering data, you can either:

  • Submit the record to the target database (go to step 4). Do this when the record is complete and is ready to go into production.
                OR
  • Store the record in the Save (temporary) database. Do this if the record is incomplete or needs approval before you can put it into production. See Adding a Record to the Save Database for more information.

4. To submit the record to its target database:

  • Click the arrow beside the Available actions: drop-down list at the top of the screen.
  • Select Submit record from the list.

    Submit record option

5. You see a confirmation message and the data contained in the record:

Confirm submit

Submitting a record adds it to the database. Once you submit a record, you must subsequently delete it to remove it from the database or edit it to modify any of its data. If you are working with a production database that is available to patrons through the WebZ interface while you modify the database, the record becomes available to patrons after you submit it.

6. Do you want to submit the record to the database now?

  • Yes. Click YES. Go to step 7.
  • No. Click NO. You can return to this record at any time during this Record Builder session by clicking its hot link in the Edit Session information part of the display.

7. When Record Builder successfully commits the record to the database, you see the Update completed message, like this:

Submit confirmation
6. Choose your next action from the Options menu.
 

Updating an Existing Record in a Local Database

Follow this procedure to use Record Builder to modify an existing record in a local database.

1. Search or browse for the record you want to modify.

2. When you find the right record, click the Edit Record icon (Edit Record icon) beside its name on the Search Results screen.

Selecting Edit Record from search results screen

3. The record opens with the master XML template used to originally create the record. Type or select the information that you want to change. See Data Entry Fields and Buttons for more information about the fields and buttons on the workform, respectively.

Editing a record

4. When you finish entering data, you can either:

  • Submit the record to the target database (go to step 5). Do this when the record is complete and is ready to go into production.
                OR
  • Store the record in the Save (temporary) database. Do this if the record is incomplete or needs approval before you can put it into production. See Adding a Record to the Save Database for more information.

5. To submit the record to the target database:

  • Click the arrow beside the Available Actions: drop-down list at the top of the screen.
  • Select Submit record from the list.

    Submit record option

6. You see the following prompt and the data contained in the record:

Confirm submit

Submitting a modified record adds the changes you made to the record the database. If you are working with a production database that is available to patrons through the WebZ interface while you modify the database, the revised record becomes available to patrons after you submit it.

7. Do you want to submit the record to the database now?

  • Yes. Click YES.
  • No. Click NO. You can return to this record at any time during this Record Builder session by clicking its hot link in the Edit Session information part of the display.
8. When Record Builder successfully commits the record to the database, you see the Update completed message, like this:

Update completed

9. Choose your next action from the Options menu.

Copying a Record in a Local Database

Follow this procedure to use Record Builder to copy a record in a local database and then edit the new record. In this procedure, you:

  • Search or browse the database to locate the record of interest.
  • Copy the record.
  • Edit the new record.
  • Submit the new record to the database.

1. Search or browse for the record you want to copy.

2. When you find the right record, click the Copy Record icon (Copy Record icon) to the left of its name on the Search Results screen.

Selecting Copy Record from search results screen

3. Record Builder copies the record and then opens the Edit Record screen with the master XML template used to originally create the record. Type or select the information that you want to change. See Data Entry Fields and Buttons for more information about the fields and buttons on the Edit Record screen.

Editing a record

4. This new record is like a new record. It isn't saved anywhere yet. When you finish entering data, you can either:

  • Submit the new record to the target database (go to step 5). Do this when the record is complete and is ready to go into production.
                OR
  • Store the record in the Save (temporary) database. Do this if the record is incomplete or needs approval before you can put it into production. See Adding a Record to the Save Database for more information.

5. When you finish editing this new record, you are ready to submit it to the database. (Note that this record is like a new record; you haven't saved it until you successfully submit it to the database.) To submit a record:

  • Click the arrow beside the Available Actions: drop-down list at the top of the screen.
  • Select Submit record from the list.

    Submit record option

6. You see a confirmation message and the data contained in the record:

Confirm submit

Submitting a record adds it to the database. Once you submit a record, you must subsequently delete it to remove it from the database or edit it to modify any of its data. If you are working with a production database that is available to patrons through the WebZ interface while you modify the database, the record becomes available to patrons after you submit it.

7. When Record Builder successfully commits the record to the database, you see the Update completed message, like this:

Update completed

8. Choose your next action from the Options menu.


Deleting a Record from a Local Database

Follow this procedure to use Record Builder to delete a record in a local database.

1. Search or browse for the record you want to delete.

2. When you find the right record, click the Delete Record icon (Delete Record icon) to the left of its name on the Search Results screen.

3. You see the record you selected and a message asking you to confirm the deletion:

Confirm submit

Deleting a record permanently removes it from the database. If you are working with a production database that is available to patrons through the WebZ interface while you modify the database, the record is no longer available to patrons as soon as you delete it.

4. Do you want to delete the record now?

  • Yes. Click YES. After Record Builder deletes the record, you see this message:

    Confirmation message

  • No. Click NO. Record Builder opens the record so you can edit it if you wish. See step 3 in Updating a Record in a Local Database if you want to edit the record. If you don't want to edit the record, select Cancel changes from the Available actions drop-down list.
5. Choose your next action from the Options menu.

 


See Also

A Walkthrough of the Record Builder Interface
Record Builder Process Model and System Overview
Working with the Save Database
New Record Screen
Edit Record Screen
Copy Record Screen
Delete Record Screen



[Main][Documentation][Support][Technical Reference][Community][Glossary][Search]

Last Modified: