Main -> Documentation -> Database Builder – Pears  -> Extracting and Displaying BER Records in SSDOT for Pears

Extracting and Displaying BER Records in SSDOT for Pears

You may want to share records among Pears databases by simply dumping them out of one and loading them into another without converting them or you may want to review BER records to decide which indexes to create for a database. In either case, you must first export the records in BER format. SSDOT for pears provides two options for extracting BER formatted records from a Pears database. One allows you to view the records on screen and the second allows you to export them to a file. The procedures for performing both of these activities are outlined in the tables below.

Contents

Extracting BER Records
Displaying BER Records


Extracting BER Records

SSDOT for Pears provides menu options for extracting and displaying BER records from a Pears database. The procedure below provides the steps that you can perform to extract BER records from your Pears database.

1. Start SSDOT for Pears and press Enter to go the Main Menu.

2. Type 2 and press Enter to go to the BER Records Menu.

Result:

The following screen appears:


#### SSDOT Pears Administration ####

BER Records Menu

1. Display BER records
2. Extract BER records
3. Exit SSDOT

Working Database: No database selected

Type "l" To LIST available databases
Type "s" To SET a working database
Type "u" To UNSET the working database

Press [ENTER] key to return to Main Menu
>

 

3. Type 2 and press Enter to begin extracting BER records from your Pears database.

Result:

The following prompt appears:

Name of database:

 

4. Type the name of the database from which you want to extract BER records and press Enter.

Result:

The following prompt appears:

Number of records to EXTRACT or press [ENTER] key or all:

 

5. Are there a certain number of records that you want to extract:

  • Yes: Type the total number of records that you want to extract and press Enter.
  • No: Press Enter to extract all the records in the database.
Result:

The following prompt appears:

Number of records to SKIP or press [ENTER] key for none:

 

6. Are there a certain number of records that you want to skip during export:

  • Yes: Type the total number of records that you want to skip and press Enter.
  • No: Press Enter to extract all the records in the database.
Result:

The following prompt appears:

File name to which to EXTRACT records:

7. Type the complete path to the file to which you want to export the records and press Enter.

Example:  
File name to which to EXTRACT records: <WebZ_root>/dbbuilder/dbs/marcus/marcus2.ber

Result:

Confirmation information like the following should appear:

BER Records successfully extracted to <WebZ_root>/dbbuilder/dbs/Marcus/marcus2.ber.

Press [ENTER] key to continue:

8. Press Enter to go back to the BER Records Menu.

 

Displaying BER Records

You have two ways to display BER records that have been extracted from a Pears database: You can view them on screen or export them to a file and view them using a UNIX or Windows-based tool. The procedure below provides the steps for either displaying records on screen or sending them to a text file.

1. Start SSDOT for Pears and press Enter to go the Main Menu.

2. Type 2 and press Enter to go to the BER Records Menu.

Result:

The following screen appears:


#### SSDOT Pears Administration ####

BER Records Menu

1. Display BER records
2. Extract BER records
3. Exit SSDOT

Working Database: No database selected

Type "l" To LIST available databases
Type "s" To SET a working database
Type "u" To UNSET the working database

Press [ENTER] key to return to Main Menu
>

 

3. Type 1 and press Enter to display BER records.

Result:

The following prompt appears:

Name of BER file to DISPLAY or press [ENTER] key to return to menu:

 

4. Type the full path to the file containing the BER records that you which to display.

Example:  
Name of BER file to DISPLAY or press [ENTER] key to return to menu:<WebZ_root>/dbbuilder/dbs/marcus/marcus2.ber

Result:

The following prompt appears:

Name of Output file or [ENTER] key for screen:

 

5. Do you want to view the records on screen?

  • Yes: Press Enter.
Result:

A display similar to the following should appear on screen:

Working, please wait |Record Number:1
DataDir: fldid(0) asn1class(1) form(1) length(0) count(20)
child: DataDir: fldid(0) asn1class(2) form(0) length(0) count(8)
data: 6e 67 6d 20 20 4b 61 20 ngm Ka
sibling: DataDir: fldid(1) asn1class(2) form(0) length(0) count(12)
data: 6f 63 6d 33 39 34 35 31 39 31 37 20 ocm39451917
sibling: DataDir: fldid(3) asn1class(2) form(0) length(0) count(5)
data: 4f 43 6f 4c 43 OCoLC
sibling: DataDir: fldid(5) asn1class(2) form(0) length(0) count(9)
data: 31 39 39 38 30 37 30 38 20 19980708
sibling: DataDir: fldid(8) asn1class(2) form(0) length(0) count(40)
data: 39 38 30 37 30 38 74 31 39 39 38 31 39 39 37 63 980708t19981997c
61 75 31 30 30 20 6a 20 20 20 20 20 20 20 20 20 au100 j
20 76 6c 65 6e 67 20 64 vleng d
sibling: DataDir: fldid(28) asn1class(2) form(1) length(0) count(3)
child: DataDir: fldid(0) asn1class(2) form(0) length(0) count(2)

Press [ENTER] key to continue or type "q" to quit:

  • No: Type a full path to the text file that will hold the BER to text records and press Enter.
Example:

<WebZ_root>/dbbuilder/dbs/marcus/marcus2.txt


Result:

A display similar to the following should appear on screen:

Working, please wait |BER file: <WebZ_root>/dbbuilder/dbs/marcus/marcus2.ber successfully converted to readable format.
Output File: <WebZ_root>/dbbuilder/dbs/marcus/marcus2.txt.

Press [ENTER] key to continue:

 

6. Press Enter to return to the BER Records Menu.

 


See Also

Pears System Overview
SSDOT for Pears
The SiteSearch Database Operations Tool (SSDOT)

 


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

Last Modified: