Skip to main content
Ex Libris Knowledge Center

How to run Selective extract

  • Article Type: Q&A
  • Product: Voyager
  • Product Version: All
  • Relevant for Installation Type: Dedicated-Direct; Direct; Local

Question

How to extract all or select list or range of Voyager records for Primo

Answer

1. Connect to server via SSH or telnet.
2. cd /m1/voyager/xxxdb/ini
3. Compare configuration settings in PrimoExp-Publishing.ini and PrimoExp-Selective.ini. Should be using same enrichment tags, availability statuses, etc. Update PrimoExp-Selective.ini if necessary.
4. cd /m1/voyager/xxxdb/sbin
5. Run Selective extract (Pprimoexp.sel) with either a bib range or a list of bib_ids. (See examples in Additional Information.)
6. Primo pipe will need to be run to pick up and process extracted records from /m1/voyager/xxxdb/primo/Selective/bundled when extract complete. Primo TotalCare customers should open Case in advance of running extract to request pipe setup from Primo TotalCare team.

Additional Information

Example 1: Extract all records in file /m1/incoming/PrimoBibs.txt

  1. Command to run: /m1/voyager/xxxdb/sbin/Pprimoexp.sel -f /m1/voyager/xxxdb/ini/PrimoExp-Selective.ini -F /m1/incoming/PrimoBibs.txt
  2. Result: any bib_id listed in PrimoBibs.txt will be extracted to /m1/voyager/xxxdb/primo/Selective/bundled.

Example 2: Extract a range of bib records (or all records)
  1. Command to run: /m1/voyager/xxxdb/sbin/Pprimoexp.sel -f /m1/voyager/xxxdb/ini/PrimoExp-Selective.ini -B1 -E200000
  2. Result: any unsuppressed bib (with no other exclusion conditions) between bib_id=1 and bib_id=200000 will be extracted to /m1/voyager/xxxdb/primo/Selective/bundled.
    1. To extract all records in database, use -E parameter with highest bib_id
    2. To identify highest bib_id in database, query bib_master: select max(bib_id) from bib_master
    3. Use the resulting value as -E parameter.
NOTE: Extracts should not be run for more than 250,000 records at one time. However, Selective extract by range of bib_id can be run for more records if done as multi-threaded extract for large numbers of records. See Possible to extract all records in one Voyager process?

Category: Interoperability


  • Article last edited: 12/16/2014