Re: [Koha] Possible APP development

2014-04-14 Thread Viktor.Sarge
My two cents: 

If I understand the state of things correctly offline web apps in HTML5 is 
already possible. Push notifications over the web isn't there yet even if OS X 
has it and I hope that it becomes more common. I think that the advantage of 
using push notifications instead of e-mail/SMS isn't big enough to motivate 
using the resources neded to create and maintain tablet and phone apps for 
Android, iOS and possible Windows devices. I do however understand if someone 
wants to code those apps because it's fun :) 

Worth investigating might also be gateway apps that receives push-notifications 
for you without the need for installing a native app. I cannot vouch for 
https://pushover.net/ but a quick search turned it up and the idea seems to be 
sound. 

Kind regards/Viktor 

  

-Ursprungligt meddelande-
Från: Koha [mailto:koha-boun...@lists.katipo.co.nz] För Robin Sheat
Skickat: den 10 april 2014 02:12
Till: koha@lists.katipo.co.nz
Ämne: Re: [Koha] Possible APP development

Miller, Tim schreef op wo 09-04-2014 om 16:15 [-0700]:
 One aspect that a native app can offer which a web-based app cannot is 
 offline work.

One other thing that native apps can do that would be of use to library users 
is push notifications. I.e. your phone tells you when things are nearly 
overdue, reserves are waiting for you, the thing you suggested has shown up, 
and so on.

--
Robin Sheat
Catalyst IT Ltd.
✆ +64 4 803 2204
GPG: 5FA7 4B49 1E4D CAA4 4C38  8505 77F5 B724 F871 3BDF

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


[Koha] Where are subject headings ( field 650$a) stored in in Koha database

2014-04-14 Thread amutsikiwa
Hi

 

I imported  close to 87000 items. I think I miss-align the subject column
during data migration from liberty 3 to Koha, so the subjects are out of
place. I would like to correct the error. I am interested in establishing
which table in Koha holds subject headings and which field in particular.

 

I will appreciate any pointers.

 

Kind Regards,

 

Admire Mutsikiwa 

ICT Projects Manager

Libraries 

University of Zimbabwe

Tel:+263-4-303276

It is easy to dodge our responsibilities, but we cannot dodge the
consequences of dodging our responsibilities.  Josiah Charles Stamp,
1880-1941, former director of the Bank of England 

 

 

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


Re: [Koha] Where are subject headings ( field 650$a) stored in in Koha database

2014-04-14 Thread Michał Dudzik
Hi,
look in biblioitems- marcxml.
Greets
Michał Dudzik



--
View this message in context: 
http://koha.1045719.n5.nabble.com/Where-are-subject-headings-field-650-a-stored-in-in-Koha-database-tp5794003p5794016.html
Sent from the Koha-general mailing list archive at Nabble.com.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha


Re: [Koha] Possible APP development

2014-04-14 Thread Sue McMillan
Thanks for everyone's input. The different views are interesting.

I see one of the major advantages of having an app that uses push notifications 
is that here in NZ internet access for people outside of the major centres is 
patchy at best.  Connecting to a webpage over a cell phone network or even a 
landline is near impossible in rural areas as the connection is weak and/or 
drops out continuously.  High speed broadband is limited to major cities.  
Towns outside of these areas have broadband but at very low speeds.  Some 
(un)lucky places still have dial up.  

Most rural cell phone connections get enough signal send and receive texts but 
not phone calls, and definitely not enough to load a webpage.  

Personally I would much rather have an app that sends me notifications alerting 
me to the need to renew books or that a held item is ready for collection than 
remember to login to a webpage.   

Regards
Susan McMillan
Cataloguing and Systems Administrator| South Taranaki District Council
105-111 Albion St, Hawera 4610 | Private Bag 902, Hawera 4640, NZ
Phone: +64 6 278 0555 | Cell: | www.southtaranaki.com 
 


This e-mail and any attachments may contain confidential and 
privileged 
information. If you are not the intended recipient, please notify the 
sender immediately by return e-mail, delete this e-mail and destroy 
any 
copies. Any dissemination or use of this information by a person other 
than the intended recipient is unauthorised and may be illegal. Please 
note that this communication does not designate an information system 
for the purposes of the Electronic Transactions Act 2002.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha


Re: [Koha] Importing Patron Loan History (old_issues)

2014-04-14 Thread Robin Sheat
jbarker schreef op vr 11-04-2014 om 06:26 [-0700]:
 I tried to export our loans history data from our old ILS to koha
 3.14,
 using:
 load data local infile '/PATHTO/importloanstest.csv' into table
 koha.old_issues fields terminated by ',' enclosed by '' lines
 terminated
 by'\n';
 
 and got the following error:
 ERROR 1452 (23000): Cannot add or update a child row: a foreign key
 constraint fails (`koha`.`old_issues`, CONSTRAINT `old_issues_ibfk_1`
 FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers`
 (`borrowernumber`) ON
 DELETE SET NULL ON UPDATE SET NULL)

This is saying that you're attempting to reference a borrower that
doesn't actually exist.


 So i'm just wondering how other people got their loans history into
 koha
 from their old ILS?

I tend to write scripts to do it, for example:

https://gitorious.org/koha-migration-toolbox/koha-migration-toolbox/source/395f9d788acf79df53d2c878837ce7cb72b08467:migration/Liberty/circ.pl

One thing it does do is discard any records that have a non-existent
borrower or item number, as the software that it comes from keeps them
around even when they're quite meaningless.

-- 
Robin Sheat
Catalyst IT Ltd.
✆ +64 4 803 2204
GPG: 5FA7 4B49 1E4D CAA4 4C38  8505 77F5 B724 F871 3BDF

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