How can I extract a list of vendors?
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 -- 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)
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
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@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@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- 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)
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@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@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
Thanks, I've got it now. SELECT name, postal, contemail FROM aqbooksellers On Thu, Nov 13, 2014 at 1:11 AM, Liz Rea <liz@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@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@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)
participants (2)
-
Elaine Bradtke -
Liz Rea