No subject

Tue Dec 27 09:26:03 EST 2011

You can see the tables in the actor schema with the command: evergreen# \dt actor.

the period is critical in this command.&nbsp; You should see:

evergreen# \dt actor.
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; List of relations
&nbsp;Schema |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | Type&nbsp; |&nbsp;&nbsp; Owner&nbsp;&nbsp; 
--------+------------------------+-------+-----------
&nbsp;actor&nbsp; | card&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | table | postgres
&nbsp;actor&nbsp; | hours_of_operation&nbsp;&nbsp;&nbsp;&nbsp; | table | postgres
&nbsp;actor&nbsp; | org_address&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | table | postgres
&nbsp;actor&nbsp; | org_lasso&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | table | postgres
&nbsp;actor&nbsp; | org_lasso_map&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | table | postgres
&nbsp;actor&nbsp; | org_unit&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | table | postgres
&nbsp;actor&nbsp; | org_unit_closed&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | table | postgres
&nbsp;actor&nbsp; | org_unit_proximity&nbsp;&nbsp;&nbsp;&nbsp; | table | postgres
&nbsp;actor&nbsp; | org_unit_setting&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | table | postgres
&nbsp;actor&nbsp; | org_unit_type&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | table | postgres
&nbsp;actor&nbsp; | stat_cat&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | table | postgres
&nbsp;actor&nbsp; | stat_cat_entry&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | table | postgres
&nbsp;actor&nbsp; | stat_cat_entry_usr_map | table | postgres
&nbsp;actor&nbsp; | usr&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | table | postgres
&nbsp;actor&nbsp; | usr_address&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | table | postgres
&nbsp;actor&nbsp; | usr_note&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | table | postgres
&nbsp;actor&nbsp; | usr_org_unit_opt_in&nbsp;&nbsp;&nbsp; | table | postgres
&nbsp;actor&nbsp; | usr_password_reset&nbsp;&nbsp;&nbsp;&nbsp; | table | evergreen
&nbsp;actor&nbsp; | usr_saved_search&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | table | evergreen
&nbsp;actor&nbsp; | usr_setting&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | table | postgres
&nbsp;actor&nbsp; | usr_standing_penalty&nbsp;&nbsp; | table | postgres
&nbsp;actor&nbsp; | workstation&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | table | postgres
(22 rows)

Now, your phone number is found in the usr table as Wolf explained earlier.&nbsp; to see the fields in the usr table, one issues the \d actor.usr command.

The table is big enough so that i am not listing it's contents here.&nbsp; This post should explain for you and others who might be new to the evergreen schema architecture how to navigate around it using the psql command line tool.

pgadmin and others (I use Navicat) only make this easier.

I hope this helps.
Steve Wills

-----Original Message-----
From: Wolf Halton [mailto:wolf.halton at gmail.com]
Sent: Sunday, January 8, 2012 01:40 AM
To: 'Evergreen Development Discussion List'
Subject: Re: [OPEN-ILS-DEV] Want to know the variable name of patron's phone	number

Hi Darshan,
--Please watch the subject line.&nbsp; Your response had a subject line of "...Digest etc etc" and that breaks the threading of the conversation. --

That is the list of databases, and the table is part of the evergreen database.&nbsp; If you have a linux desktop to look at gui stuff, you can look at the structure using pgadmin III (as long as your database is listening on an external port).&nbsp; I cannot tell you exactly how to approach using the field, but I can guarantee it will be there.&nbsp; (Your money back if not delighted).

Wolf

On Wed, Jan 4, 2012 at 7:40 AM, darshan &lt;dkhot at dreamsoftech.com" target="_blank" &gt;dkhot at dreamsoftech.com&gt; wrote:

Hi,

I checked in database but I couldn't find table that you mention. In fact

there was no single table in database. Please see attached screenshot and

guide me if I am referring wrong database.

Thanks

Darshan

Message: 2

Date: Tue, 3 Jan 2012 08:00:34 -0500

From: Wolf Halton &lt;wolf.halton at gmail.com" target="_blank" &gt;wolf.halton at gmail.com&gt;

Subject: Re: [OPEN-ILS-DEV] Want to know the variable name of patron's

 &nbsp; &nbsp; &nbsp; &nbsp;phone &nbsp; number

To: Evergreen Development Discussion List

 &nbsp; &nbsp; &nbsp; &nbsp;&lt;open-ils-dev at list.georgialibraries.org" target="_blank" &gt;open-ils-dev at list.georgialibraries.org&gt;

Message-ID:

 &nbsp; &nbsp; &nbsp; &nbsp;&lt;CALRLYEm4RFJigMgfcowywNBeJhU_XS9JtQiDZfzwBCThX=WboA at mail.gmail.com" target="_blank" &gt;WboA at mail.gmail.com&gt;

Content-Type: text/plain; charset="utf-8"

I am not a dev on this project, but I could find you this much. &nbsp;That

information is in the table called "usr" there are fields for day_phone,

evening_phone and other_phone. &nbsp;I used pgadmin III to look at the table

details. &nbsp;This is on evergreen version 2.1.

On Tue, Jan 3, 2012 at 6:48 AM, darshan &lt;dkhot at dreamsoftech.com" target="_blank" &gt;dkhot at dreamsoftech.com&gt; wrote:

&gt; Hi,****

&gt;

&gt; ** **

&gt;

&gt; In email template we use some variables ( like ${PATRON_NAME} and

&gt; ${PATRON_ADDRESS}) to get patron specific data. We want to use patrons

&gt; phone number in email message but we could not identify the variable

&gt; to get this value. Please help.****

&gt;

&gt; ** **

&gt;

&gt; Thanks****

&gt;

&gt; Darshan Khot****

&gt;

--

This Apt Has Super Cow Powers - http://sourcefreedom.com Advancing Libraries

Together - http://LYRASIS.org

-------------- next part --------------

An HTML attachment was scrubbed...

URL:

&lt;http://libmail.georgialibraries.org/pipermail/open-ils-dev/attachments/2012

0103/1dba7e0f/attachment-0001.htm&gt;

End of Open-ils-dev Digest, Vol 70, Issue 1

*******************************************

-- 
This Apt Has Super Cow Powers - http://sourcefreedom.com
Advancing Libraries Together - http://LYRASIS.org

--=_2f09a6c5ee232f8e30e47c1f93359104
Content-Transfer-Encoding: quoted-printable
Content-Type: text/html; charset="UTF-8"

<br><br>Thank You<br><br>--------------------------------------------------=
---------------------------------------------------------------------------=
--------------------------------<br>From: "Steve Wills" &lt;swills at beyond-p=
rint.com&gt;<br>Sent: Sun, 08 Jan 2012 13:51:49 <br>To: "Evergreen Developm=
ent Discussion List" &lt;open-ils-dev at list.georgialibraries.org&gt;<br>Subj=
ect: [OPEN-ILS-DEV] ***SPAM*** Using PSQL with Evergreen's Database.  Want =
to know the variable name of patron's phone	number<br> <div> I tried to res=
pond before but my email didn't make it onto the list for some reason.&nbsp=
; This is my second try.<br><br>Darshan,<br><br>You need the right database=
, by default it is called evergreen.&nbsp;&nbsp; In postgres, your previous=
 posts indicate that you can get into psql.&nbsp;&nbsp; pgadmin and other g=
ui tools are cool but fundamentally one wants to understand the underlying =
database.&nbsp; psql strips away the gui and forces you to think only about=
 the database, it might speak to the difficulty you are having.<br><br>firs=
t, in psql, use the \l tool to see what databases you have in your postgres=
 instance.&nbsp; Usually, your Evergreen database will be called evergreen =
unless you had done something proactive to change that name.<br><br>postgre=
s#\c evergreen <br><br>this command should attach you to your evergreen dat=
abase.&nbsp; Now you probably want to see the tables.&nbsp; While it is tem=
pting to type \d and see tables, evergreen aggregates it's tables into func=
tional schema.&nbsp; You must know what these schema are in order to intera=
ct with the tables they govern.&nbsp; To get a list of those tables, use th=
e command&nbsp; \dn which should yield a list like:<br><br>&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp; List of schemas<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp; Name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; |=
&nbsp;&nbsp; Owner&nbsp;&nbsp; <br>---------------------+-----------<br>&nb=
sp;acq&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; | postgres<br>&nbsp;action&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp; &nbsp; | postgres<br>&nbsp;action_trigger&nbsp;&nbsp;&nbsp; &nbsp; =
| postgres<br>&nbsp;actor&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; | postgres<br>&nbsp;a=
sset&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; | postgres<br>&nbsp;auditor&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
 | postgres<br>&nbsp;authority&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp; | postgres<br>&nbsp;biblio&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp; | postgres<br>&nbsp;booking&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | evergreen<br>&nbsp;config&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp; | postgres<br>&nbsp;container&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | postgres<br>&nbsp;ever=
green&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | e=
vergreen<br>&nbsp;extend_reporter&nbsp;&nbsp;&nbsp; | postgres<br>&nbsp;inf=
ormation_schema | postgres<br>&nbsp;metabib&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | postgres<br>&n=
bsp;migration&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp; | postgres<br>&nbsp;money&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | pos=
tgres<br>&nbsp;offline&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | postgres<br>&nbsp=
;permission&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p; | postgres<br>&nbsp;pg_catalog&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp; | postgres<br>&nbsp;pg_toast&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | postgres<b=
r>&nbsp;pg_toast_temp_1&nbsp;&nbsp;&nbsp; | postgres<br>&nbsp;pg_toast_temp=
_2&nbsp;&nbsp;&nbsp; | postgres<br>&nbsp;public&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp; | postgres<br>&nbsp;query&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
; | evergreen<br>&nbsp;reporter&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | postgres<br>&nbsp;search&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp; | postgres<br>&nbsp;serial&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp; | postgres<br>&nbsp;staging&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | evergre=
en<br>&nbsp;stats&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | postgres<b=
r>&nbsp;vandelay&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp; | postgres<br>(31 rows)<br><br>From this list of =
schema, you probably want the Actor schema to gleen your phone number.&nbsp=
; <br><br>You can see the tables in the actor schema with the command: ever=
green# \dt actor.<br><br>the period is critical in this command.&nbsp; You =
should see:<br><br>evergreen# \dt actor.<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Lis=
t of relations<br>&nbsp;Schema |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp; Name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | Ty=
pe&nbsp; |&nbsp;&nbsp; Owner&nbsp;&nbsp; <br>--------+---------------------=
---+-------+-----------<br>&nbsp;actor&nbsp; | card&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp; | table | postgres<br>&nbsp;actor&nbsp; | hours_of_operation&nbsp=
;&nbsp;&nbsp;&nbsp; | table | postgres<br>&nbsp;actor&nbsp; | org_address&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | table | =
postgres<br>&nbsp;actor&nbsp; | org_lasso&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | table | postgres<br>&nbsp;ac=
tor&nbsp; | org_lasso_map&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp; | table | postgres<br>&nbsp;actor&nbsp; | org_unit&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | table | =
postgres<br>&nbsp;actor&nbsp; | org_unit_closed&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp; | table | postgres<br>&nbsp;actor&nbsp; | org_unit_proximity=
&nbsp;&nbsp;&nbsp;&nbsp; | table | postgres<br>&nbsp;actor&nbsp; | org_unit=
_setting&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | table | postgres<br>&nbsp;ac=
tor&nbsp; | org_unit_type&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp; | table | postgres<br>&nbsp;actor&nbsp; | stat_cat&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | table | =
postgres<br>&nbsp;actor&nbsp; | stat_cat_entry&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp; | table | postgres<br>&nbsp;actor&nbsp; | stat_cat_entr=
y_usr_map | table | postgres<br>&nbsp;actor&nbsp; | usr&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp; | table | postgres<br>&nbsp;actor&nbsp; | usr_address&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | table | =
postgres<br>&nbsp;actor&nbsp; | usr_note&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | table | postgres<br>&nb=
sp;actor&nbsp; | usr_org_unit_opt_in&nbsp;&nbsp;&nbsp; | table | postgres<b=
r>&nbsp;actor&nbsp; | usr_password_reset&nbsp;&nbsp;&nbsp;&nbsp; | table | =
evergreen<br>&nbsp;actor&nbsp; | usr_saved_search&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp; | table | evergreen<br>&nbsp;actor&nbsp; | usr_setting&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | table | postgres=
<br>&nbsp;actor&nbsp; | usr_standing_penalty&nbsp;&nbsp; | table | postgres=
<br>&nbsp;actor&nbsp; | workstation&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp; | table | postgres<br>(22 rows)<br><br>Now, your=
 phone number is found in the usr table as Wolf explained earlier.&nbsp; to=
 see the fields in the usr table, one issues the \d actor.usr command.<br><=
br>The table is big enough so that i am not listing it's contents here.&nbs=
p; This post should explain for you and others who might be new to the ever=
green schema architecture how to navigate around it using the psql command =
line tool.<br><br>pgadmin and others (I use Navicat) only make this easier.=
<br><br>I hope this helps.<br>Steve Wills<br><br><br><br></div>
<blockquote style=3D"PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000=
0ff 2px solid; MARGIN-RIGHT: 0px"><font face=3D"Tahoma" size=3D"2">-----Ori=
ginal Message-----<br><b>From:</b> Wolf Halton [mailto:wolf.halton at gmail.co=
m]<br><b>Sent:</b> Sunday, January 8, 2012 01:40 AM<br><b>To:</b> 'Evergree=
n Development Discussion List'<br><b>Subject:</b> Re: [OPEN-ILS-DEV] Want t=
o know the variable name of patron's phone	number<br><br></font>Hi Darshan,=
<br>--Please watch the subject line.&nbsp; Your response had a subject line=
 of "...Digest etc etc" and that breaks the threading of the conversation. =
--<br><br>That is the list of databases, and the table is part of the everg=
reen database.&nbsp; If you have a linux desktop to look at gui stuff, you =
can look at the structure using pgadmin III (as long as your database is li=
stening on an external port).&nbsp; I cannot tell you exactly how to approa=
ch using the field, but I can guarantee it will be there.&nbsp; (Your money=
 back if not delighted).<br>
<br>Wolf<br><br><br><div cl-ass=3D"gmail_quote">On Wed, Jan 4, 2012 at 7:40=
 AM, darshan <span dir=3D"ltr">&lt;dkhot at dreamsoftech.com" target=3D"_blank=
" &gt;dkhot at dreamsoftech.com&gt;</span> wrote:<br><blockquote cl-ass=3D"gma=
il_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-lef=
t:1ex">
Hi,<br>
<br>
I checked in database but I couldn't find table that you mention. In fact<b=
r>
there was no single table in database. Please see attached screenshot and<b=
r>
guide me if I am referring wrong database.<br>
<br>
Thanks<br>
Darshan<br>
<br>
Message: 2<br>
Date: Tue, 3 Jan 2012 08:00:34 -0500<br>
From: Wolf Halton &lt;wolf.halton at gmail.com" target=3D"_blank" &gt;wolf.hal=
ton at gmail.com&gt;<br>
Subject: Re: [OPEN-ILS-DEV] Want to know the variable name of patron's<br>
 &nbsp; &nbsp; &nbsp; &nbsp;phone &nbsp; number<br>
To: Evergreen Development Discussion List<br>
 &nbsp; &nbsp; &nbsp; &nbsp;&lt;open-ils-dev at list.georgialibraries.org" tar=
get=3D"_blank" &gt;open-ils-dev at list.georgialibraries.org&gt;<br>
Message-ID:<br>
 &nbsp; &nbsp; &nbsp; &nbsp;&lt;CALRLYEm4RFJigMgfcowywNBeJhU_XS9JtQiDZfzwBC=
ThX=3DWboA at mail.gmail.com" target=3D"_blank" &gt;WboA at mail.gmail.com&gt;<br=
>
Content-Type: text/plain; charset=3D"utf-8"<br>
<br>
I am not a dev on this project, but I could find you this much. &nbsp;That<=
br>
information is in the table called "usr" there are fields for day_phone,<br=
>
evening_phone and other_phone. &nbsp;I used pgadmin III to look at the tabl=
e<br>
details. &nbsp;This is on evergreen version 2.1.<br>
<br>
On Tue, Jan 3, 2012 at 6:48 AM, darshan &lt;dkhot at dreamsoftech.com" target=
=3D"_blank" &gt;dkhot at dreamsoftech.com&gt; wrote:<br>
<br>
&gt; Hi,****<br>
&gt;<br>
&gt; ** **<br>
&gt;<br>
&gt; In email template we use some variables ( like ${PATRON_NAME} and<br>
&gt; ${PATRON_ADDRESS}) to get patron specific data. We want to use patrons=
<br>
&gt; phone number in email message but we could not identify the variable<b=
r>
&gt; to get this value. Please help.****<br>
&gt;<br>
&gt; ** **<br>
&gt;<br>
&gt; Thanks****<br>
&gt;<br>
&gt; Darshan Khot****<br>
&gt;<br>
<span cl-ass=3D"HOEnZb"><font color=3D"#888888"><br>
<br>
<br>
--<br>
This Apt Has Super Cow Powers - <a href=3D'http://sourcefreedom.com'>http:/=
/sourcefreedom.com</a> Advancing Libraries<br>
Together - <a href=3D'http://LYRASIS.org'>http://LYRASIS.org</a><br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL:<br>
&lt;<a href=3D"http://www.rediffmail.com/cgi-bin/red.cgi?red=3Dhttp%3A%2F%2=
Flibmail%2Egeorgialibraries%2Eorg%2Fpipermail%2Fopen%2Dils%2Ddev%2Fattachme=
nts%2F2012%250A0103%2F1dba7e0f%2Fattachment%2D0001%2Ehtm&amp;isImage=3D0&am=
p;BlockImage=3D0&amp;rediffng=3D0" mce_href=3D"http://libmail.georgialibrar=
ies.org/pipermail/open-ils-dev/attachments/2012%0A0103/1dba7e0f/attachment-=
0001.htm" target=3D"_blank">http://libmail.georgialibraries.org/pipermail/o=
pen-ils-dev/attachments/2012<br>

0103/1dba7e0f/attachment-0001.htm</a>&gt;<br>
<br>
End of Open-ils-dev Digest, Vol 70, Issue 1<br>
*******************************************<br>
</font></span></blockquote></div><br><br clear=3D"all"><br>-- <br>This Apt =
Has Super Cow Powers - <a href=3D'http://sourcefreedom.com'>http://sourcefr=
eedom.com</a><br>Advancing Libraries Together - <a href=3D'http://LYRASIS.o=
rg'>http://LYRASIS.org</a><br>
<br>
</blockquote>=20
<br><A HREF=3D"http://sigads.rediff.com/RealMedia/ads/click_nx.ads/www.redi=
ffmail.com/signatureline.htm at Middle?" target=3D"_blank"><IMG SRC=3D"http://=
sigads.rediff.com/RealMedia/ads/adstream_nx.ads/www.rediffmail.com/signatur=
eline.htm at Middle"></A><br><table width=3D"578" border=3D"0" cellspacing=3D"=
0" cellpadding=3D"0"><tr><td><span style=3D"font-family:Arial, Helvetica, s=
ans-serif; font-size:12px; color:#393939;">Follow&nbsp;<span style=3D"color=
:#0000CC;"><b><u><a href=3D"http://track.rediff.com/click?url=3D___http://d=
ealhojaye.rediff.com?sc_cid=3Drediffmailsignature___&cmp=3Dsignature&lnk=3D=
rediffmailsignature&newservice=3Ddeals" target=3D"_blank">Rediff Deal ho ja=
ye!</a></u></b></span>&nbsp;to get exciting offers in your city everyday.</=
span></td></tr></table>
--=_2f09a6c5ee232f8e30e47c1f93359104--