[Koha] How can I extract a list of vendors?

[Elaine Bradtke]

Thanks, I've got it now.
SELECT name, postal, contemail FROM aqbooksellers

On Thu, Nov 13, 2014 at 1:11 AM, Liz Rea <liz at catalyst.net.nz> wrote:

> http://schema.koha-community.org/tables/aqbooksellers.html may help. :)
>
> Liz
> On 13/11/14 14:09, Elaine Bradtke wrote:
> > That's a good start, but I also need the contact info.  I'll see if I can
> > expand on that.
> >
> > On Thu, Nov 13, 2014 at 12:46 AM, Liz Rea <liz at catalyst.net.nz> wrote:
> >
> >> Hi Elaine,
> >>
> >> Try this:
> >> SELECT name FROM aqbooksellers
> >>
> >> Cheers,
> >> Liz
> >> On 13/11/14 13:39, Elaine Bradtke wrote:
> >>> We're running 3.16 and a colleague would like a list of the vendors we
> >> use.
> >>> I don't see any way to do this through the staff interface, or via a
> >> report.
> >>> Is it possible to do it otherwise? If so could you give me enough info
> >> so I
> >>> can pass it on to my IT person?
> >>> Thanks
> >>>
> >> --
> >> --
> >> Liz Rea
> >> Catalyst.Net Limited
> >> Level 6, Catalyst House,
> >> 150 Willis Street, Wellington.
> >> P.O Box 11053, Manners Street,
> >> Wellington 6142
> >>
> >> GPG: B149 A443 6B01 7386 C2C7 F481 B6c2 A49D 3726 38B7
> >>
> >> _______________________________________________
> >> Koha mailing list  http://koha-community.org
> >> Koha at lists.katipo.co.nz
> >> http://lists.katipo.co.nz/mailman/listinfo/koha
> >>
> >
> >
>
> --
> --
> Liz Rea
> Catalyst.Net Limited
> Level 6, Catalyst House,
> 150 Willis Street, Wellington.
> P.O Box 11053, Manners Street,
> Wellington 6142
>
> GPG: B149 A443 6B01 7386 C2C7 F481 B6c2 A49D 3726 38B7
>
>


-- 
Elaine Bradtke
Data Wrangler
VWML
English Folk Dance and Song Society | http://www.efdss.org
Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
Tel    +44 (0) 20 7485 2206 (This number is for the English Folk Dance and
Song Society in London, England. If you wish to phone me personally, send
an e-mail first. I work off site)
--------------------------------------------------------------------------
Registered Company No. 297142
Charity Registered in England and Wales No. 305999
---------------------------------------------------------------------------
"Writing about music is like dancing about architecture"
--Elvis Costello (Musician magazine No. 60 (October 1983), p. 52)