Re: [Koha] Embed Local video files like YouTube

[Puneet Saini]

Dear Vinod,

I would like to inform you that, only Latest version of koha 20.05.02 support 
on Embed local video.. we have done for one client..

For more information you may contact us

Regards,

Puneet Kumar 
+91-9350515096

Sent from my iPhone

> On 30-Jul-2020, at 4:44 AM, dc...@prosentient.com.au wrote:
> 
> Hi Vinod,
> 
> 
> 
> Koha, at least as of 19.11, has the capacity to handle non-YouTube media. I 
> won’t give you remote support here, but perhaps someone else can or perhaps 
> you can engage a support provider. 
> 
> 
> 
> David Cook
> 
> Systems Librarian
> 
> Prosentient Systems
> 
> 72/330 Wattle St
> 
> Ultimo, NSW 2007
> 
> Australia
> 
> 
> 
> Office: 02 9212 0899
> 
> Online: 02 8005 0595
> 
> 
> 
> From: vinod mishra  
> Sent: Thursday, 30 July 2020 4:38 AM
> To: dc...@prosentient.com.au
> Cc: Koha 
> Subject: Re: [Koha] Embed Local video files like YouTube
> 
> 
> 
> Hello David
> 
> 
> 
> We have videos on Intranet and in MP4 format, but it seems current provision 
> is for YouTube only and it fetches/embed the video nicely in Koha but not 
> mine on Intranet.
> 
> 
> 
> Please suggest. 
> 
> 
> 
> With Regards,
> 
> Vinod Kumar Mishra,
> Assistant Librarian,
> Biju Patnaik Central Library (BPCL),
> NIT Rourkela,
> Sundergadh-769008,
> Odisha,
> India.
> Mob:91+9439420860
> 
> ORCID ID: http://orcid.org/-0003-4666-7874
> 
> 
> 
> "Spiritual relationship is far more precious than physical. Physical 
> relationship divorced from spiritual is body without soul" -- Mahatma Gandhi
> 
> 
> 
> 
> 
> On Wed, Jul 29, 2020 at 6:19 AM   > wrote:
> 
> Hi Vinod,
> 
> I haven't played with the HTML5 Media in Koha, but I've been curious about 
> it, so I decided to take a look after reading your email.
> 
> Looking at the code, it appears that you can embed other videos and not just 
> Youtube videos. You'll need to use the system preferences HTML5MediaEnabled 
> and HTML5MediaExtensions, and make sure your 856$u has a valid URL to the 
> video. You may need to transcode your video if it's in a format that doesn't 
> work with HTML Video.  
> 
> It also depends on what you mean by "Local server". Is this the same server 
> that is running Koha? Is it a separate file server? So long your server 
> provides the video over HTTP(S) in a way that is accessible to your users, I 
> think that you should be fine. 
> 
> David Cook
> Systems Librarian
> Prosentient Systems
> 72/330 Wattle St
> Ultimo, NSW 2007
> Australia
> 
> Office: 02 9212 0899
> Online: 02 8005 0595
> 
> -Original Message-
> Date: Tue, 28 Jul 2020 16:54:51 +0530
> From: vinod mishra mailto:mishrav...@gmail.com> >
> To: Koha mailto:Koha@lists.katipo.co.nz> >
> Subject: [Koha] Embed Local video files like YouTube
> Message-ID:
>  >
> Content-Type: text/plain; charset="UTF-8"
> 
> Hello
> As we have an option to activate YouTube online video embed feature within 
> Koha, similarly i wish to embed lecture videos kept in Local server. Please 
> let me know how we can make it possible like YouTube videos?
> 
> Thanking You
> 
> With Regards,
> 
> Vinod Kumar Mishra,
> Assistant Librarian,
> Biju Patnaik Central Library (BPCL),
> NIT Rourkela,
> Sundergadh-769008,
> Odisha,
> India.
> Mob:91+9439420860
> ORCID ID: http://orcid.org/-0003-4666-7874
> 
> *"Spiritual relationship is far more precious than physical. Physical 
> relationship divorced from spiritual is body without soul" -- Mahatma
> Gandhi*
> 
> ___
> 
> 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] Embed Local video files like YouTube

[dcook]

Hi Vinod,

 

Koha, at least as of 19.11, has the capacity to handle non-YouTube media. I 
won’t give you remote support here, but perhaps someone else can or perhaps you 
can engage a support provider. 

 

David Cook

Systems Librarian

Prosentient Systems

72/330 Wattle St

Ultimo, NSW 2007

Australia

 

Office: 02 9212 0899

Online: 02 8005 0595

 

From: vinod mishra  
Sent: Thursday, 30 July 2020 4:38 AM
To: dc...@prosentient.com.au
Cc: Koha 
Subject: Re: [Koha] Embed Local video files like YouTube

 

Hello David

 

We have videos on Intranet and in MP4 format, but it seems current provision is 
for YouTube only and it fetches/embed the video nicely in Koha but not mine on 
Intranet.

 

Please suggest. 



With Regards,

Vinod Kumar Mishra,
Assistant Librarian,
Biju Patnaik Central Library (BPCL),
NIT Rourkela,
Sundergadh-769008,
Odisha,
India.
Mob:91+9439420860

ORCID ID: http://orcid.org/-0003-4666-7874

 

"Spiritual relationship is far more precious than physical. Physical 
relationship divorced from spiritual is body without soul" -- Mahatma Gandhi

 

 

On Wed, Jul 29, 2020 at 6:19 AM mailto:dc...@prosentient.com.au> > wrote:

Hi Vinod,

I haven't played with the HTML5 Media in Koha, but I've been curious about it, 
so I decided to take a look after reading your email.

Looking at the code, it appears that you can embed other videos and not just 
Youtube videos. You'll need to use the system preferences HTML5MediaEnabled and 
HTML5MediaExtensions, and make sure your 856$u has a valid URL to the video. 
You may need to transcode your video if it's in a format that doesn't work with 
HTML Video.  

It also depends on what you mean by "Local server". Is this the same server 
that is running Koha? Is it a separate file server? So long your server 
provides the video over HTTP(S) in a way that is accessible to your users, I 
think that you should be fine. 

David Cook
Systems Librarian
Prosentient Systems
72/330 Wattle St
Ultimo, NSW 2007
Australia

Office: 02 9212 0899
Online: 02 8005 0595

-Original Message-
Date: Tue, 28 Jul 2020 16:54:51 +0530
From: vinod mishra mailto:mishrav...@gmail.com> >
To: Koha mailto:Koha@lists.katipo.co.nz> >
Subject: [Koha] Embed Local video files like YouTube
Message-ID:
mailto:cagluwiqd7dvcvgtgmvbwld5u2jdfgtxmqe7neep-v6msarn...@mail.gmail.com> >
Content-Type: text/plain; charset="UTF-8"

Hello
As we have an option to activate YouTube online video embed feature within 
Koha, similarly i wish to embed lecture videos kept in Local server. Please let 
me know how we can make it possible like YouTube videos?

Thanking You

With Regards,

Vinod Kumar Mishra,
Assistant Librarian,
Biju Patnaik Central Library (BPCL),
NIT Rourkela,
Sundergadh-769008,
Odisha,
India.
Mob:91+9439420860
ORCID ID: http://orcid.org/-0003-4666-7874

*"Spiritual relationship is far more precious than physical. Physical 
relationship divorced from spiritual is body without soul" -- Mahatma
Gandhi*



signature.asc
Description: PGP signature
___

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

[Koha] Erro Brazilian Portuguese or Koha language

[Victor Barroso Oliveira]

Good evening,
In ubuntu 20.04 and koha 20.05.02, when used in the Brazilian Portuguese or
Koha language, there is an error in the tools module.
Look at the images.

https://docs.google.com/document/d/1kIW6ne0cuu1B_YEQV4v8zD5Frv-VX7-zOSjciAlitEY/edit?usp=sharing
___

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

Re: [Koha] Linking fields 770 and 772

[cruciani]

Thanks you a lot Elaine. I´ve looked through my framework and checked  
that both subfieds were set to display in OPAC and Staff interface. I  
hadn´t seen the bug reported by Katrin, maybe there´s something wrong  
with 772 field too. I hope this will be fixed.

Regards,

Paola V. Cruciani

Elaine Bradtke  escribió:


Check your framework to make sure it is set to display in OPAC and Staff
interface?
Though maybe Katrin has more insight - as there is a bug for the 770 field
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20200

Elaine Bradtke
VWML
Our income is severely diminished in these exceptionally uncertain times.
Please help us to survive beyond this national crisis. Donate now
.
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


On Wed, Jul 29, 2020 at 6:16 AM  wrote:



Hi. I am working with serials, trying to link a parent record to a
supplement record using 770 and 772 fields and it seems not to be
working. In spite of using 772 0# in the supplement record and 770 0#
in the parent one (using $w for linking records) no linking note
appears to be displaying and no relation seems to be establishing. I´m
using Koha version 19.11.
I ´d greatly appreciate your feedback on this.

Regards,
Paola V. Cruciani


___

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] BULK EDIT BARCODES

[Ian Bays]

Hi.

I think you do not need the % characters in the REPLACE patterns.  You 
could use something like:


UPDATE items SET barcode = REPLACE(barcode, '--', '-') WHERE barcode LIKE 
'%--%';


assuming you want to change all barcodes with "--".

Hope this helps.

On 29/07/2020 20:45, muiru james wrote:

Hi Team,

I need to edit barcodes to replace a double hyphen (--) with a single
hyphen (-). The barcodes are many and will take long using the item editor
which allows me to edit one after the other.

Is there a SQL command I could use to edit from the terminal? I tried
running the query below. It is matching the records but changing none. Is
there something I am missing?

MariaDB[koha_library]>
UPDATE items SET barcode = REPLACE(barcode, '%--%', '%-%') WHERE itemnumber
IN (377,378,391,.);

I am using koha version 19.11 on Ubuntu 16.04 and mysql Ver 15.1 Distrib
10.0.38-MariaDB

Please assist

Warm Regards
James
___

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] BULK EDIT BARCODES

[muiru james]

Hi Team,

I need to edit barcodes to replace a double hyphen (--) with a single
hyphen (-). The barcodes are many and will take long using the item editor
which allows me to edit one after the other.

Is there a SQL command I could use to edit from the terminal? I tried
running the query below. It is matching the records but changing none. Is
there something I am missing?

MariaDB[koha_library]>
UPDATE items SET barcode = REPLACE(barcode, '%--%', '%-%') WHERE itemnumber
IN (377,378,391,.);

I am using koha version 19.11 on Ubuntu 16.04 and mysql Ver 15.1 Distrib
10.0.38-MariaDB

Please assist

Warm Regards
James
___

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

Re: [Koha] Embed Local video files like YouTube

[vinod mishra]

Hello David

We have videos on Intranet and in MP4 format, but it seems current
provision is for YouTube only and it fetches/embed the video nicely in Koha
but not mine on Intranet.

Please suggest.

With Regards,

Vinod Kumar Mishra,
Assistant Librarian,
Biju Patnaik Central Library (BPCL),
NIT Rourkela,
Sundergadh-769008,
Odisha,
India.
Mob:91+9439420860
ORCID ID: http://orcid.org/-0003-4666-7874

*"Spiritual relationship is far more precious than physical. Physical
relationship divorced from spiritual is body without soul" -- Mahatma
Gandhi*


On Wed, Jul 29, 2020 at 6:19 AM  wrote:

> Hi Vinod,
>
> I haven't played with the HTML5 Media in Koha, but I've been curious about
> it, so I decided to take a look after reading your email.
>
> Looking at the code, it appears that you can embed other videos and not
> just Youtube videos. You'll need to use the system preferences
> HTML5MediaEnabled and HTML5MediaExtensions, and make sure your 856$u has a
> valid URL to the video. You may need to transcode your video if it's in a
> format that doesn't work with HTML Video.
>
> It also depends on what you mean by "Local server". Is this the same
> server that is running Koha? Is it a separate file server? So long your
> server provides the video over HTTP(S) in a way that is accessible to your
> users, I think that you should be fine.
>
> David Cook
> Systems Librarian
> Prosentient Systems
> 72/330 Wattle St
> Ultimo, NSW 2007
> Australia
>
> Office: 02 9212 0899
> Online: 02 8005 0595
>
> -Original Message-
> Date: Tue, 28 Jul 2020 16:54:51 +0530
> From: vinod mishra 
> To: Koha 
> Subject: [Koha] Embed Local video files like YouTube
> Message-ID:
> <
> cagluwiqd7dvcvgtgmvbwld5u2jdfgtxmqe7neep-v6msarn...@mail.gmail.com>
> Content-Type: text/plain; charset="UTF-8"
>
> Hello
> As we have an option to activate YouTube online video embed feature within
> Koha, similarly i wish to embed lecture videos kept in Local server. Please
> let me know how we can make it possible like YouTube videos?
>
> Thanking You
>
> With Regards,
>
> Vinod Kumar Mishra,
> Assistant Librarian,
> Biju Patnaik Central Library (BPCL),
> NIT Rourkela,
> Sundergadh-769008,
> Odisha,
> India.
> Mob:91+9439420860
> ORCID ID: http://orcid.org/-0003-4666-7874
>
> *"Spiritual relationship is far more precious than physical. Physical
> relationship divorced from spiritual is body without soul" -- Mahatma
> Gandhi*
>
>
___

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

Re: [Koha] Linking fields 770 and 772

[Elaine Bradtke]

Check your framework to make sure it is set to display in OPAC and Staff
interface?
Though maybe Katrin has more insight - as there is a bug for the 770 field
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20200

Elaine Bradtke
VWML
Our income is severely diminished in these exceptionally uncertain times.
Please help us to survive beyond this national crisis. Donate now
.
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


On Wed, Jul 29, 2020 at 6:16 AM  wrote:

>
> Hi. I am working with serials, trying to link a parent record to a
> supplement record using 770 and 772 fields and it seems not to be
> working. In spite of using 772 0# in the supplement record and 770 0#
> in the parent one (using $w for linking records) no linking note
> appears to be displaying and no relation seems to be establishing. I´m
> using Koha version 19.11.
> I ´d greatly appreciate your feedback on this.
>
> Regards,
> Paola V. Cruciani
>
>
> ___
>
> 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] Koha 20.05, Ubuntu 18.04 and MariaDB

[Cindy Murdock Ames]

I've been running 19.11.05 for several months now with MariaDB 10.4.13 with
no issues AFAIK.  I upgraded a test server to 20.05 and got some errors
from updatedatabase.pl like this:

DBD::mysql::db do failed: Row size too large. The maximum row size for the
used table type, not counting BLOBs, is 8126. This includes storage
overhead, check the manual. You have to change some columns to TEXT or
BLOBs
[for Statement "ALTER TABLE branches DROP COLUMN branchprinter"] at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl
line 21074.

After some investigating I found that our database (imported from 3.22 in
April) had a row_format of "Compact" on all tables and newer versions of
the database have a row_format of "Dynamic".  I expect this is cruft from
our database that has been imported into new versions of Koha several
times, since we've been using Koha for 10+ years.  Anyway, on my test
server I changed ours to Dynamic and it was able to update without any
errors after that, but I haven't yet upgraded our production server to it.
Probably no one else will run into this, but I thought I'd just put it out
into the ether in case anyone else runs into this issue.

Cindy

---
Cindy Murdock Ames
IT Services Director
Meadville Public Library | CCFLS
https://meadvillelibrary.org | https://ccfls.org




On Mon, Jul 27, 2020 at 11:24 AM Philippe Blouin <
philippe.blo...@inlibro.com> wrote:

> I only dared to write that affirmatively because I was just in the
> process of updating another machine (from 9.9 to 9.13), and it was
> installing MariaDB 10.4.13.
>
> It was right in front of me, on my screen.
>
> But after your answers I dug a bit and yeah, the source.list.d specifies
> 10.4 for mariadb.
>
> So my initial answer is mostly wrong.  The only correct part is that we
> do have multiple production systems running 10.4 without glitch, but
> that is not proof of anything.
>
> My apologies for the misleading answer.
>
> Philippe Blouin,
> Directeur de la technologie
>
> Tél.  : (833) 465-4276, poste 230
> philippe.blo...@inlibro.com 
>
> inLibro | pour esprit libre | www.inLibro.com 
> On 2020-07-27 10:56 a.m., Michael Kuhn wrote:
> > Hi Philippe
> >
> > Am 27.07.20 um 16:32 schrieb Philippe Blouin:
> > > 10.4 is the default mariadb version you get with an up-to-date Debian
> > > 9 or Ubuntu 18.
> > >
> > > It works.
> >
> > I just updated another Installation of Debian GNU/Linux 9.12 to 9.13.
> > But it only updated to MariaDB 10.1.45, not 10.4.x
> >
> > So my question is still open, if Koha 18.11 on Debian 9 will work with
> > Koha 10.3
> >
> > Best wishes: Michael
> ___
>
> 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] Linking fields 770 and 772

[cruciani]

Hi. I am working with serials, trying to link a parent record to a  
supplement record using 770 and 772 fields and it seems not to be  
working. In spite of using 772 0# in the supplement record and 770 0#  
in the parent one (using $w for linking records) no linking note  
appears to be displaying and no relation seems to be establishing. I´m  
using Koha version 19.11.

I ´d greatly appreciate your feedback on this.

Regards,
Paola V. Cruciani


___

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