No subject
Tue Dec 27 09:26:03 EST 2011
r phone number.
You can see the tables in the actor schema with the command: evergreen# \=
dt actor.
the period is critical in this command. You should see:
evergreen# \dt actor.
List of relations
Schema | Name | Type | Owner
--------+------------------------+-------+-----------
actor | card | table | postgres
actor | hours_of_operation | table | postgres
actor | org_address | table | postgres
actor | org_lasso | table | postgres
actor | org_lasso_map | table | postgres
actor | org_unit | table | postgres
actor | org_unit_closed | table | postgres
actor | org_unit_proximity | table | postgres
actor | org_unit_setting | table | postgres
actor | org_unit_type | table | postgres
actor | stat_cat | table | postgres
actor | stat_cat_entry | table | postgres
actor | stat_cat_entry_usr_map | table | postgres
actor | usr | table | postgres
actor | usr_address | table | postgres
actor | usr_note | table | postgres
actor | usr_org_unit_opt_in | table | postgres
actor | usr_password_reset | table | evergreen
actor | usr_saved_search | table | evergreen
actor | usr_setting | table | postgres
actor | usr_standing_penalty | table | postgres
actor | workstation | table | postgres
(22 rows)
Now, your phone number is found in the usr table as Wolf explained earlie=
r. to see the fields in the usr table, one issues the \d actor.usr comman=
d.
The table is big enough so that i am not listing it's contents here. 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 lin=
e 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 ph=
one=09number
Hi Darshan,
--Please watch the subject line. 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 dat=
abase. 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). I cannot tell you exactly how to approach using the f=
ield, but I can guarantee it will be there. (Your money back if not delig=
hted).
Wolf
On Wed, Jan 4, 2012 at 7:40 AM, darshan <dkhot at dreamsoftech.com> 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 <wolf.halton at gmail.com>
Subject: Re: [OPEN-ILS-DEV] Want to know the variable name of patron's
phone number
To: Evergreen Development Discussion List
<open-ils-dev at list.georgialibraries.org>
Message-ID:
<CALRLYEm4RFJigMgfcowywNBeJhU_XS9JtQiDZfzwBCThX=3DWboA at mail.gmail.com>
Content-Type: text/plain; charset=3D"utf-8"
I am not a dev on this project, but I could find you this much. That
information is in the table called "usr" there are fields for day_phone,
evening_phone and other_phone. I used pgadmin III to look at the table
details. This is on evergreen version 2.1.
On Tue, Jan 3, 2012 at 6:48 AM, darshan <dkhot at dreamsoftech.com> wrote:
> Hi,****
>
> ** **
>
> In email template we use some variables ( like ${PATRON_NAME} and
> ${PATRON_ADDRESS}) to get patron specific data. We want to use patrons
> phone number in email message but we could not identify the variable
> to get this value. Please help.****
>
> ** **
>
> Thanks****
>
> Darshan Khot****
>
--
This Apt Has Super Cow Powers - http://sourcefreedom.com Advancing Librar=
ies
Together - http://LYRASIS.org
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<http://libmail.georgialibraries.org/pipermail/open-ils-dev/attachments/2=
012
0103/1dba7e0f/attachment-0001.htm>
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
----=_vm_0011_W936110723_23823_1326010891
Content-Type: text/html; charset="utf-8"
Content-Transfer-Encoding: quoted-printable
<html><div> I tried to respond before but my email didn't make it onto th=
e list for some reason. This is my second try.<br><br>Darshan,<br><=
br>You need the right database, by default it is called evergreen. &=
nbsp; In postgres, your previous posts indicate that you can get into psq=
l. pgadmin and other gui tools are cool but fundamentally one=
wants to understand the underlying database. psql strips away the =
gui and forces you to think only about the database, it might speak to th=
e difficulty you are having.<br><br>first, in psql, use the \l tool to se=
e what databases you have in your postgres instance. Usually, your =
Evergreen database will be called evergreen unless you had done something=
proactive to change that name.<br><br>postgres#\c evergreen <br><br>this=
command should attach you to your evergreen database. Now you prob=
ably want to see the tables. While it is tempting to type \d and se=
e tables, evergreen aggregates it's tables into functional schema. =
You must know what these schema are in order to interact with the tables =
they govern. To get a list of those tables, use the command \=
dn which should yield a list like:<br><br> &=
nbsp; List of schemas<br> =
Name |  =
; Owner <br>---------------------+-----------<br> acq&nb=
sp; &nbs=
p; | postgres<br> action &=
nbsp; &n=
bsp; | postgres<br> action_trigger |=
postgres<br> actor &=
nbsp; | postgres<br>&nbs=
p;asset =
| postgres<br> auditor &n=
bsp; &nb=
sp; | postgres<br> authority &nbs=
p; | postgres<br> biblio &n=
bsp; &nb=
sp; | postgres<br> booking =
| evergreen<=
br> config &nbs=
p; | postgres<br> containe=
r =
| postgres<br> evergreen &=
nbsp; | evergreen<br> extend_reporter &=
nbsp; | postgres<br> information_schema | postgres<br> metabib&=
nbsp; &n=
bsp; | postgres<br> migration &nb=
sp; | postgres<br> m=
oney &nb=
sp; | postgres<br> offline =
&=
nbsp; | postgres<br> permission &=
nbsp; | postgres<br> pg_ca=
talog |=
postgres<br> pg_toast &nbs=
p; | postgres<br> pg_toast_temp_=
1 | postgres<br> pg_toast_temp_2 =
| postgres<br> public &nbs=
p; | po=
stgres<br> query &nbs=
p; | evergree=
n<br> reporter =
| postgres<br> search &nbs=
p;  =
; | postgres<br> serial &nb=
sp; &nbs=
p; | postgres<br> staging &=
nbsp; | everg=
reen<br> stats =
| post=
gres<br> vandelay &nb=
sp; | postgres<br>(31 rows)<br><br>From thi=
s list of schema, you probably want the Actor schema to gleen your phone =
number. <br><br>You can see the tables in the actor schema with the=
command: evergreen# \dt actor.<br><br>the period is critical in this com=
mand. You should see:<br><br>evergreen# \dt actor.<br> &=
nbsp; &n=
bsp; List of relations<br> Schema | &nb=
sp; Name  =
; | Type | Owner <br>----=
----+------------------------+-------+-----------<br> actor | =
card &nb=
sp; | table | postgres<br> actor=
| hours_of_operation | table | postgres<br=
> actor | org_address  =
; | table | postgres<br> actor | org_l=
asso &nb=
sp; | table | postgres<br> actor | org_lasso_map &n=
bsp; | table | postgres<br>&nbs=
p;actor | org_unit &=
nbsp; | table | postgres<br> actor&nbs=
p; | org_unit_closed | table | =
postgres<br> actor | org_unit_proximity  =
; | table | postgres<br> actor | org_unit_setting &=
nbsp; | table | postgres<br> actor | org_uni=
t_type | table | po=
stgres<br> actor | stat_cat  =
; | table | postgres<br>&=
nbsp;actor | stat_cat_entry &nbs=
p; | table | postgres<br> actor | stat_cat_entry_usr_map=
| table | postgres<br> actor | usr &nb=
sp; &nbs=
p; | table | postgres<br> actor | usr_address =
; | table | p=
ostgres<br> actor | usr_note &nbs=
p; | table | postgres<br>=
actor | usr_org_unit_opt_in | table | postg=
res<br> actor | usr_password_reset | t=
able | evergreen<br> actor | usr_saved_search  =
; | table | evergreen<br> actor | usr_settin=
g | tab=
le | postgres<br> actor | usr_standing_penalty | t=
able | postgres<br> actor | workstation  =
; | table | postgres<br>(22 row=
s)<br><br>Now, your phone number is found in the usr table as Wolf explai=
ned earlier. 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 listin=
g it's contents here. This post should explain for you and others w=
ho might be new to the evergreen schema architecture how to navigate arou=
nd 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: #0=
000ff 2px solid; MARGIN-RIGHT: 0px"><font face=3D"Tahoma" size=3D"2">----=
-Original Message-----<br><b>From:</b> Wolf Halton [mailto:wolf.halton at gm=
ail.com]<br><b>Sent:</b> Sunday, January 8, 2012 01:40 AM<br><b>To:</b> '=
Evergreen Development Discussion List'<br><b>Subject:</b> Re: [OPEN-ILS-D=
EV] Want to know the variable name of patron's phone=09number<br><br></fo=
nt>Hi Darshan,<br>--Please watch the subject line. Your response ha=
d 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 evergreen database. If you have a linux desktop to l=
ook at gui stuff, you can look at the structure using pgadmin III (as lon=
g as your database is listening on an external port). I cannot tell=
you exactly how to approach using the field, but I can guarantee it will=
be there. (Your money back if not delighted).<br>
<br>Wolf<br><br><br><div class=3D"gmail_quote">On Wed, Jan 4, 2012 at 7:4=
0 AM, darshan <span dir=3D"ltr"><<a href=3D"mailto:dkhot at dreamsoftech.=
com" mce_href=3D"mailto:dkhot at dreamsoftech.com" target=3D"_blank">dkhot at d=
reamsoftech.com</a>></span> wrote:<br><blockquote class=3D"gmail_quote=
" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"=
>
Hi,<br>
<br>
I checked in database but I couldn't find table that you mention. In fact=
<br>
there was no single table in database. Please see attached screenshot and=
<br>
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 <<a href=3D"mailto:wolf.halton at gmail.com" mce_href=3D=
"mailto:wolf.halton at gmail.com" target=3D"_blank">wolf.halton at gmail.com</a=
>><br>
Subject: Re: [OPEN-ILS-DEV] Want to know the variable name of patron's<br=
>
phone number<br>
To: Evergreen Development Discussion List<br>
<<a href=3D"mailto:open-ils-dev at list.georg=
ialibraries.org" mce_href=3D"mailto:open-ils-dev at list.georgialibraries.or=
g" target=3D"_blank">open-ils-dev at list.georgialibraries.org</a>><br>
Message-ID:<br>
<CALRLYEm4RFJigMgfcowywNBeJhU_XS9JtQiDZfzw=
BCThX=3D<a href=3D"mailto:WboA at mail.gmail.com" mce_href=3D"mailto:WboA at ma=
il.gmail.com" target=3D"_blank">WboA at mail.gmail.com</a>><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. Tha=
t<br>
information is in the table called "usr" there are fields for day_phone,<=
br>
evening_phone and other_phone. I used pgadmin III to look at the ta=
ble<br>
details. This is on evergreen version 2.1.<br>
<br>
On Tue, Jan 3, 2012 at 6:48 AM, darshan <<a href=3D"mailto:dkhot at dream=
softech.com" mce_href=3D"mailto:dkhot at dreamsoftech.com" target=3D"_blank"=
>dkhot at dreamsoftech.com</a>> wrote:<br>
<br>
> Hi,****<br>
><br>
> ** **<br>
><br>
> In email template we use some variables ( like ${PATRON_NAME} and<br=
>
> ${PATRON_ADDRESS}) to get patron specific data. We want to use patro=
ns<br>
> phone number in email message but we could not identify the variable=
<br>
> to get this value. Please help.****<br>
><br>
> ** **<br>
><br>
> Thanks****<br>
><br>
> Darshan Khot****<br>
><br>
<span class=3D"HOEnZb"><font color=3D"#888888"><br>
<br>
<br>
--<br>
This Apt Has Super Cow Powers - <a href=3D"http://sourcefreedom.com" mce_=
href=3D"http://sourcefreedom.com" target=3D"_blank">http://sourcefreedom.=
com</a> Advancing Libraries<br>
Together - <a href=3D"http://LYRASIS.org" mce_href=3D"http://LYRASIS.org"=
target=3D"_blank">http://LYRASIS.org</a><br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL:<br>
<<a href=3D"http://libmail.georgialibraries.org/pipermail/open-ils-dev=
/attachments/2012%0A0103/1dba7e0f/attachment-0001.htm" mce_href=3D"http:/=
/libmail.georgialibraries.org/pipermail/open-ils-dev/attachments/2012%0A0=
103/1dba7e0f/attachment-0001.htm" target=3D"_blank">http://libmail.georgi=
alibraries.org/pipermail/open-ils-dev/attachments/2012<br>
0103/1dba7e0f/attachment-0001.htm</a>><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 Ap=
t Has Super Cow Powers - <a href=3D"http://sourcefreedom.com" mce_href=3D=
"http://sourcefreedom.com" target=3D"_blank">http://sourcefreedom.com</a>=
<br>Advancing Libraries Together - <a href=3D"http://LYRASIS.org" mce_hre=
f=3D"http://LYRASIS.org" target=3D"_blank">http://LYRASIS.org</a><br>
<br>
</blockquote></html>
----=_vm_0011_W936110723_23823_1326010891--
More information about the Open-ils-dev
mailing list