Thanks for your reply.

I did the following this morning:

1.       When I exported MARC holdings from Symphony, I checked the internal Symphony Catalog Key to populate tag 001.

2.       Then I updated the marc.properties file to parse off the u that Symphony appends to the front of its internal catalog key.

3.       Then I imported.

4.       About my holdings in the sample file now populate holdings.  Those of the form u123456 parse and populate.  About my holdings didn’t parse and populate.  Those that didn't are of the form ocm15628163.

LEADER

01672cam a2200337 i 4500

001

u524267

003

SIRSI

005

20130807083054.0

008

130328s2013 nyu 000 1 eng

010

|a 2013008797

040

|a DLC |c DLC |d IG# |d OCLCO |d NSB |d UPZ |d WIM |d IUK |d NSB |d YDXCP |d VP@

020

|a 1476710767

020

|a 9781476710761

020

|a 9781476710778 (pbk.)

035

|a (OCoLC)833630459

043

|a n-us-ks

092

|a F |b BURKE

049

|a TWAA

100

1

|a Burke, James Lee, |d 1936-

245

1

0

|a Light of the world : |b a Dave Robicheaux novel / |c James Lee Burke.

260

|a New York, N.Y. : |b Simon & Schuster, |c c2013.

300

|a 548 p. ; |c 25 cm

440

2

|a A Dave Robicheaux mystery ; |v bk. 20

500

|a First Simon & Schuster hardcover edition.

520

|a Police detective Dave Robicheaux faces off with the most diabolical villain he has ever faced in the twentieth installment of the Dave Robicheaux series. A summer getaway in Montana for Dave Robicheaux's family and friends is violently shattered by the arrival of serial killer and prison escapee Asa Surrette. He avoids the death penalty for murders he committed while capital punishment was banned in his home state of Kansas. But when Robicheaux's daughter Alafair writes a series of articles implicating Surrette in other murders which could get him death, he decides to escape prison and make her pay. Can Robicheaux save his daughter?

650

0

|a Robicheaux, Dave (Fictitious character) |v Fiction.

650

0

|a Good and evil |v Fiction.

651

0

|a Kansas |v Fiction.

655

7

|a Mystery fiction. |2 gsafd

655

7

|a Suspense fiction. |2 gsafd

994

|a C0 |b TWA

 

marc.properties:

#id = 001, first

# Extract the numeric portion of the id number using a pattern map:

id = 001, (pattern_map.id)

pattern_map.id.pattern_0 = u[^0-9]*[0]*([0-9]+)=>$1

 

I suspect that I am doing something unconventional, but am making some progress!

 

Regards,

Gregory

 

-----Original Message-----
From: Steven Hild [mailto:sjhild@wm.edu]
Sent: Sunday, August 25, 2013 2:54 PM
To: Gregory M. Testa
Cc: Demian Katz; vufind-general@lists.sourceforge.net; vufind-tech@lists.sourceforge.net
Subject: Re: [VuFind-General] VuFind Symphony Web Services Question

 

> (Sorry if I'm misunderstanding what you're saying -- not familiar with

> the Symphony title/record ID distinction).

 

We use Symphony and I'm not sure what you mean either, Greg.

 

Your screenshot looked like a hitlist; it would probably be helpful to narrow your case down to a single record that produces the database error. At the moment, I'm particularly interested in its Solr id field (the bit after "/Record/" in the URL).