refdb-users

[Refdb-users] Field math advice

[Daniel O'D. <dan...@ul...>]

Hi all,

A question:

In adding legacy data to my refdb database, I have inconsistencies in
the way end page numbers are represented: they can show up in any of the
following formats:

a) 323-324
b) 323-24
c) 323-4

I think I'd prefer (a), because the others can all be derived from it.
What I'd been thinking of doing was trying to extract the records that
are in the form (b) or (c) and then manually correct them (if somebody
has a better idea, I'd love to hear it).

To find the ones I wanted, I thought I'd use something like this:

refdbc: getref :EP:<:SP:

But this clearly isn't doing what I'm expecting, as here are my first
three results (of hundreds); ideally of these three, only the first
should show up; the second one in the list actually has an EP that is
larger than SP, though it isn't showing up in the output:

ID*:1 (1992)
Key: ABRAHAM1992
Abraham,Lenore
Cædmon's Hymn and the Geþwærnysse (fitness) of things
American Benedictine Review 43:331-44

ID*:5 (1998)
Key: SZARMACH1998
Szarmach,Paul E.
Anthem: Auden's Caedmon's Hymn

in: Utz,Richard J., Shippey,T.A., Workman,Leslie J., University of
Sydney, Centre for Medieval Studies(ed.), Medievalism in the modern
world essays in honour of Leslie J. Workman; part of: Making the Middle
Ages
Series Volume: v. 1pp. 329-340


Any suggestions?

-d

-- 
Daniel Paul O'Donnell
Associate Professor and Chair of English
Director, Digital Medievalist Project
<http://www.digitalmedievalist.org/>
University of Lethbridge
Lethbridge AB T1K 3M4
Canada

Vox +1 403 329-2377
Fax +1 403 382-7191

:@caedmon/ubuntu

Re: [Refdb-users] Field math advice

[Damien J. D. <D.J...@cs...>]

Gidday Daniel

This may be a bit hacky, it's something I wrote when I first started, 
working around my own lack of knowledge. It's the script I used once to 
get arbitrary sql queries out of REFDB using postgresql. I've changed it 
so that the sql command is close to the one that you'd want. Also you 
have to enter your database name and you may have to add username and 
password details if they're not already set up in config files etc. and 
to use the database client you're using.

Peace
Damien

echo -- start script --

rm -f out.111

rm -f out.222

rm -f out.333

psql DBNAME -t -c "select refdb_citekey from t_refdb where 
to_number(refdb_startpage,"9999999999") > 
to_number(refdb_endpage,"9999999999");">out.111

cat out.111 | echo :ID:\>9999 `sed -e 's/ / OR :CK:=/g'` > out.222

refdbc -d djdphd -C getref -t ris `cat out.222` > out.333

cat out.333

echo -- end script --

Daniel O'Donnell wrote:
> Hi all,
> 
> A question:
> 
> In adding legacy data to my refdb database, I have inconsistencies in
> the way end page numbers are represented: they can show up in any of the
> following formats:
> 
> a) 323-324
> b) 323-24
> c) 323-4
> 
> I think I'd prefer (a), because the others can all be derived from it.
> What I'd been thinking of doing was trying to extract the records that
> are in the form (b) or (c) and then manually correct them (if somebody
> has a better idea, I'd love to hear it).
> 
> To find the ones I wanted, I thought I'd use something like this:
> 
> refdbc: getref :EP:<:SP:
> 
> But this clearly isn't doing what I'm expecting, as here are my first
> three results (of hundreds); ideally of these three, only the first
> should show up; the second one in the list actually has an EP that is
> larger than SP, though it isn't showing up in the output:
> 
> ID*:1 (1992)
> Key: ABRAHAM1992
> Abraham,Lenore
> Cædmon's Hymn and the Geþwærnysse (fitness) of things
> American Benedictine Review 43:331-44
> 
> ID*:5 (1998)
> Key: SZARMACH1998
> Szarmach,Paul E.
> Anthem: Auden's Caedmon's Hymn
> 
> in: Utz,Richard J., Shippey,T.A., Workman,Leslie J., University of
> Sydney, Centre for Medieval Studies(ed.), Medievalism in the modern
> world essays in honour of Leslie J. Workman; part of: Making the Middle
> Ages
> Series Volume: v. 1pp. 329-340
> 
> 
> Any suggestions?
> 
> -d
> 

Re: [Refdb-users] Field math advice

[Daniel O'D. <dan...@ul...>]

Thanks Damien,

I'm using mysql, but I'll take this as a starting point and see what I
can do.

-d

On Sun, 2006-25-06 at 19:59 +0100, Damien Jade Duff wrote:
> Gidday Daniel
> 
> This may be a bit hacky, it's something I wrote when I first started, 
> working around my own lack of knowledge. It's the script I used once to 
> get arbitrary sql queries out of REFDB using postgresql. I've changed it 
> so that the sql command is close to the one that you'd want. Also you 
> have to enter your database name and you may have to add username and 
> password details if they're not already set up in config files etc. and 
> to use the database client you're using.
> 
> Peace
> Damien
> 
> echo -- start script --
> 
> rm -f out.111
> 
> rm -f out.222
> 
> rm -f out.333
> 
> psql DBNAME -t -c "select refdb_citekey from t_refdb where 
> to_number(refdb_startpage,"9999999999") > 
> to_number(refdb_endpage,"9999999999");">out.111
> 
> cat out.111 | echo :ID:\>9999 `sed -e 's/ / OR :CK:=/g'` > out.222
> 
> refdbc -d djdphd -C getref -t ris `cat out.222` > out.333
> 
> cat out.333
> 
> echo -- end script --
> 
> Daniel O'Donnell wrote:
> > Hi all,
> > 
> > A question:
> > 
> > In adding legacy data to my refdb database, I have inconsistencies in
> > the way end page numbers are represented: they can show up in any of the
> > following formats:
> > 
> > a) 323-324
> > b) 323-24
> > c) 323-4
> > 
> > I think I'd prefer (a), because the others can all be derived from it.
> > What I'd been thinking of doing was trying to extract the records that
> > are in the form (b) or (c) and then manually correct them (if somebody
> > has a better idea, I'd love to hear it).
> > 
> > To find the ones I wanted, I thought I'd use something like this:
> > 
> > refdbc: getref :EP:<:SP:
> > 
> > But this clearly isn't doing what I'm expecting, as here are my first
> > three results (of hundreds); ideally of these three, only the first
> > should show up; the second one in the list actually has an EP that is
> > larger than SP, though it isn't showing up in the output:
> > 
> > ID*:1 (1992)
> > Key: ABRAHAM1992
> > Abraham,Lenore
> > Cædmon's Hymn and the Geþwærnysse (fitness) of things
> > American Benedictine Review 43:331-44
> > 
> > ID*:5 (1998)
> > Key: SZARMACH1998
> > Szarmach,Paul E.
> > Anthem: Auden's Caedmon's Hymn
> > 
> > in: Utz,Richard J., Shippey,T.A., Workman,Leslie J., University of
> > Sydney, Centre for Medieval Studies(ed.), Medievalism in the modern
> > world essays in honour of Leslie J. Workman; part of: Making the Middle
> > Ages
> > Series Volume: v. 1pp. 329-340
> > 
> > 
> > Any suggestions?
> > 
> > -d
> > 
-- 
Daniel Paul O'Donnell
Associate Professor and Chair of English
Director, Digital Medievalist Project
<http://www.digitalmedievalist.org/>
University of Lethbridge
Lethbridge AB T1K 3M4
Canada

Vox +1 403 329-2377
Fax +1 403 382-7191

:@caedmon/ubuntu