[Koha] files added to users/borrowers

[Biblioteca FIUNER]

Good afternoon. I finish my query about files added to users/borrowers. If
the users photos/images are stored in the database in the users images
table and the users files should be stored in the borrower files table, the
query is how can one get a copy of both folders/ information.



Thanks since now


Lic. Brenda Ramirez

Head of Depth


"Dr. Eduardo A. Barbagelata"  Library

http://biblioteca-fing.uner.edu.ar/  (24/7 disponible)

correo: biblioteca.ingenie...@uner.edu.ar

Atención al público de lunes a viernes de 8 a 18 hs.
___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] koha-US General Meeting reminder: Wednesday, May 11, 2022

[Jennifer Marlatt]

 The next koha-US general meeting is *tomorrow, *Wednesday, May 11th, 2022.

When: 8:30a PT / 11:30a ET  (time converter

)
Where:
https://us02web.zoom.us/j/648572897?pwd=TUpsRE1TYlFPWWxTWFl4TVovSTJ3Zz09
Agenda:
https://docs.google.com/document/d/1R3cbx-XGVZohFzG7xz5H-eJy-Qdkzk3h8LElxQ7bQdQ/edit?usp=sharing

If you have additional topics for the agenda, please send them to
secret...@koha-us.org

Meetings are held via Zoom video conferencing. A microphone and webcam are
recommended but not required. Zoom is available for Windows, Mac, and Linux
on desktops, and Android and iOS on mobile devices. For help getting
started, visit: https://support.zoom.us/hc/en-us/categories/200101697

These meetings are always free and open to any and all.

Jennifer Marlatt
koha-US secretary
secret...@koha-us.org
___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Report help needed

[Alvaro Cornejo]

Hi Elaine,

I guess there is a space missing before FROM in ...main_headingFROM
`auth_header`...

And also a colon after GENRE/FORM)

Else you can try your SQL by parts and start by the basics. Something like

SELECT authid, datecreated,
authtypecode, concat(ExtractValue(`marcxml`,'//datafield[@tag="100"]/*'),
--), main_heading FROM `auth_header`WHERE datecreated SetASpecificDateHere

Regards

Alvaro
||
 Stay safe / Cuídate/  Reste sécurisé
*7* Switch off as you go / Apaga lo que no usas /  Débranchez au fur et à
mesure.
 *q *Recycle always / Recicla siempre / Recyclez toujours
 P Print only if absolutely necessary / Imprime solo si es necesario /
Imprimez seulement si nécessaire


Le mar. 10 mai 2022 à 12:43, Elaine Bradtke  a écrit :

> I imported the following report from Mana, but it doesn't work as is.  I
> tried changing `marcxml` to `metadata` but it still didn't work. The error
> message (You have an error in your SQL syntax; check the manual that
> corresponds to your MariaDB server version for the right syntax to use near
> '' at line 1) isn't specific enough for my limited abilities.  I'd be
> grateful for your help.
>
> Here's the original:
> SELECT authid, datecreated, authtypecode,
> concat(ExtractValue(`marcxml`,'//datafield[@tag="100"]/*'), --
> PERSO_NAMEExtractValue(`marcxml`,'//datafield[@tag="110"]/*'), --
> CORPO_NAMEExtractValue(`marcxml`,'//datafield[@tag="111"]/*'), --
> MEETI_NAMEExtractValue(`marcxml`,'//datafield[@tag="130"]/*'), --
> UNIF_TITLEExtractValue(`marcxml`,'//datafield[@tag="148"]/*'), --
> CHRON_TERMExtractValue(`marcxml`,'//datafield[@tag="150"]/*'), --
> TOPIC_TERMExtractValue(`marcxml`,'//datafield[@tag="151"]/*'), --
> GEOGR_NAMEExtractValue(`marcxml`,'//datafield[@tag="155"]/*')  --
> GENRE/FORM) main_headingFROM `auth_header`WHERE datecreated BETWEEN <<(from
> -mm-dd)>> AND <<(to -mm-dd)>>ORDER BY datecreated, authtypecode,
> main_heading
>
> Elaine Bradtke
> VWML 
> English Folk Dance and Song Society 
> 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
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>
___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Export tool failure Koha 21.11.03.000

[Elaine Bradtke]

I just tested it (21.11.05) with Authorities, giving a specific number and
a range of record numbers (1, and then 50 records) both worked. Tried both
XML and MARC.  We are not using AWS.
Elaine
VWML 



On Mon, May 2, 2022 at 3:23 AM Katrin Fischer 
wrote:

> Hi Evan,
>
> there have been no bug reports about the export not working.
>
> Are you exporting authority or bibliographic records?
>
> Which settings do you use?
>
> Does it also happen when you try to export a single or very few records,
> for example by biblionumber range?
>
> Hope this helps,
>
> Katrin
>
>
> On 28.04.22 13:43, Evan Stewart wrote:
> > Hi all,
> >
> > Has anyone else experienced errors with the Export tool in the Tools
> menu?
> >
> > -Evan Stewart
> >
> > On Wed, Apr 13, 2022 at 3:09 AM Evan Stewart 
> > wrote:
> >
> >> Hello,
> >>
> >> I seem to be having a problem with the Export data tool (Tools > Export
> >> Data).  When I click the Export link, I get a "503 Service Unavailable"
> >> message.  All other tools I try are working fine. I'm running Koha on
> AWS
> >> (see details below).
> >>
> >> My local server versions of Koha (running on Debian) are working fine.
> >> Just the AWS install is having the export tool failure.
> >>
> >> Has anyone experienced this problem with exporting data?
> >>
> >> Hosting Environment: AWS Lightsail, 2GB RAM
> >> OS: Debian 10
> >> Koha: 21.11.04.001
> >> Server: Apache 2.4.38
> >>
> >> Any thoughts on how to troubleshoot to discover the cause?
> >>
> >> Thanks,
> >> Evan Stewart
> >>
> >>
> >>
> > ___
> >
> > Koha mailing list  http://koha-community.org
> > Koha@lists.katipo.co.nz
> > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>
___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Report help needed

[Elaine Bradtke]

I imported the following report from Mana, but it doesn't work as is.  I
tried changing `marcxml` to `metadata` but it still didn't work. The error
message (You have an error in your SQL syntax; check the manual that
corresponds to your MariaDB server version for the right syntax to use near
'' at line 1) isn't specific enough for my limited abilities.  I'd be
grateful for your help.

Here's the original:
SELECT authid, datecreated, authtypecode,
concat(ExtractValue(`marcxml`,'//datafield[@tag="100"]/*'), --
PERSO_NAMEExtractValue(`marcxml`,'//datafield[@tag="110"]/*'), --
CORPO_NAMEExtractValue(`marcxml`,'//datafield[@tag="111"]/*'), --
MEETI_NAMEExtractValue(`marcxml`,'//datafield[@tag="130"]/*'), --
UNIF_TITLEExtractValue(`marcxml`,'//datafield[@tag="148"]/*'), --
CHRON_TERMExtractValue(`marcxml`,'//datafield[@tag="150"]/*'), --
TOPIC_TERMExtractValue(`marcxml`,'//datafield[@tag="151"]/*'), --
GEOGR_NAMEExtractValue(`marcxml`,'//datafield[@tag="155"]/*')  --
GENRE/FORM) main_headingFROM `auth_header`WHERE datecreated BETWEEN <<(from
-mm-dd)>> AND <<(to -mm-dd)>>ORDER BY datecreated, authtypecode,
main_heading

Elaine Bradtke
VWML 
English Folk Dance and Song Society 
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
___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha