Re: [Koha] Koha Offline Scanner for iPhone - KohaOS

[vinod mishra]

Thanks and congratulations for initiative, can you develop for Android
phone also.

On Sat, 30 Sept, 2023, 07:54 Thomas Lehmann,  wrote:

> Hi Koha team
>
> I am a volunteer supporting Koha in a small library in New Zealand.
> I already sent this mail to this list, but I was asked first to join the
> list and resend this mail… what I do herewith, so please ignore my original
> mail.
>
> While experiencing power outages, where the server and the desktop PCs
> lose the power, I had the idea to use the iPhone as an offline scanner.
> The iPhone still has power, it has it‘s own scanner (camera), it has it’s
> own torch, if needed, and its easy to use. Finally, itsalso easy to share
> the result and upload it into Koha.
>
> The result is my KohaOS app in the Apple app store:
> https://apps.apple.com/app/id6467831983
>
> I would appreciate, if you find some time to try it out, and to promote it
> on your official webpage. Any questions, just ask…
>
> Regards,
> Thomas
>
> ___
>
> 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] Koha Offline Scanner for iPhone - KohaOS

[Thomas Lehmann]

Hi Koha team

I am a volunteer supporting Koha in a small library in New Zealand. 
I already sent this mail to this list, but I was asked first to join the list 
and resend this mail… what I do herewith, so please ignore my original mail.

While experiencing power outages, where the server and the desktop PCs lose the 
power, I had the idea to use the iPhone as an offline scanner. 
The iPhone still has power, it has it‘s own scanner (camera), it has it’s own 
torch, if needed, and its easy to use. Finally, itsalso easy to share the 
result and upload it into Koha.

The result is my KohaOS app in the Apple app store: 
https://apps.apple.com/app/id6467831983

I would appreciate, if you find some time to try it out, and to promote it on 
your official webpage. Any questions, just ask…

Regards,
Thomas

___

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

Re: [Koha] Koha offline circulation

[Katrin Fischer]

Hi,

just a typo on my part. pending_offline_operations is correct.

Katrin

On 17.05.23 05:08, Сычев Игорь Алексеевич wrote:

Hello!
Thank you for the answer!
I don't have a pending_offline_transactions table, but there is a 
pending_offline_operations. Did you want to talk about her?

Good Luck!

Igor A. Sychev
Tomsk Polytechnic University
https://lib.tpu.ru

-Original Message-
From: Koha  On Behalf Of Katrin Fischer
Sent: Sunday, May 14, 2023 4:38 PM
To: koha@lists.katipo.co.nz
Subject: Re: [Koha] Koha offline circulation

Hi,

I am not aware of a limit, but 13.000 could be a little much.

The transactions are stored in the pending_offline_transactions database table. 
Usually they are cleaned up by processing them. Maybe you want to backup the 
table and try with a few transactions first to see how that goes. Or try it out 
on a demo or test installation.

Hope this helps,

Katrin

___

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 offline circulation

[Сычев Игорь Алексеевич]

Hello!
Thank you for the answer!
I don't have a pending_offline_transactions table, but there is a 
pending_offline_operations. Did you want to talk about her?

Good Luck!

Igor A. Sychev
Tomsk Polytechnic University
https://lib.tpu.ru

-Original Message-
From: Koha  On Behalf Of Katrin Fischer
Sent: Sunday, May 14, 2023 4:38 PM
To: koha@lists.katipo.co.nz
Subject: Re: [Koha] Koha offline circulation

Hi,

I am not aware of a limit, but 13.000 could be a little much.

The transactions are stored in the pending_offline_transactions database table. 
Usually they are cleaned up by processing them. Maybe you want to backup the 
table and try with a few transactions first to see how that goes. Or try it out 
on a demo or test installation.

Hope this helps,

Katrin

___

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

Re: [Koha] Koha offline circulation

[Katrin Fischer]

Hi,

I am not aware of a limit, but 13.000 could be a little much.

The transactions are stored in the pending_offline_transactions database
table. Usually they are cleaned up by processing them. Maybe you want to
backup the table and try with a few transactions first to see how that
goes. Or try it out on a demo or test installation.

Hope this helps,

Katrin

On 10.05.23 08:08, Сычев Игорь Алексеевич wrote:

Thanks for the answer.
I wanted to import about 13 thousand rows.
Is there a limit on the number of transactions?
Do these download attempts now need to be cleaned up somehow?

Maybe there are other options for transferring offline circulations?

-Original Message-
From: Koha  On Behalf Of Katrin Fischer
Sent: Monday, May 8, 2023 1:33 PM
To: koha@lists.katipo.co.nz
Subject: Re: [Koha] Koha offline circulation

Hi Igor,

the correct path is:

Circulation > Pending offline circulation actions
(/cgi-bin/koha/offline_circ/list.pl)

AllowOfflineCirculation can stay Disabled.

When using the KOCT Firefox plugin you can choose to upload and process the 
transactions or to just upload and process in Koha. You should always pick the 
latter if you had offline circulations at multiple stations.

I am not sure why you get the error. How many transactions are you trying to 
process?

Hope this helps,

Katrin


On 05.05.23 08:45, Сычев Игорь Алексеевич wrote:

Hello!

I have a koc file. When downloading, I get the following message:
"Your file was uploaded. Once all files are uploaded, please process them in 
pending offline circulation actions.
Upload another KOC file
View pending offline circulation actions"

Do I understand correctly that the file is uploaded?
If I follow the link /cgi-bin/koha/offline_circ/list.pl then "Gateway Timeout"
If I follow the link /cgi-bin/koha/circ/offline.pl then "Offline
circulation disabled Your browser is not compatible with the built-in offline 
circulation tool."

I use Microsoft Edge and Google Chrome.
Koha 22.11.05
AllowOfflineCirculation - Enable

What am I doing wrong?

Good Luck!

Igor A. Sychev
Tomsk Polytechnic University
https://lib.tpu.ru

___

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 mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Koha offline circulation

[Сычев Игорь Алексеевич]

Thanks for the answer.
I wanted to import about 13 thousand rows.
Is there a limit on the number of transactions?
Do these download attempts now need to be cleaned up somehow?

Maybe there are other options for transferring offline circulations?

-Original Message-
From: Koha  On Behalf Of Katrin Fischer
Sent: Monday, May 8, 2023 1:33 PM
To: koha@lists.katipo.co.nz
Subject: Re: [Koha] Koha offline circulation

Hi Igor,

the correct path is:

Circulation > Pending offline circulation actions
(/cgi-bin/koha/offline_circ/list.pl)

AllowOfflineCirculation can stay Disabled.

When using the KOCT Firefox plugin you can choose to upload and process the 
transactions or to just upload and process in Koha. You should always pick the 
latter if you had offline circulations at multiple stations.

I am not sure why you get the error. How many transactions are you trying to 
process?

Hope this helps,

Katrin


On 05.05.23 08:45, Сычев Игорь Алексеевич wrote:
> Hello!
>
> I have a koc file. When downloading, I get the following message:
> "Your file was uploaded. Once all files are uploaded, please process them in 
> pending offline circulation actions.
> Upload another KOC file
> View pending offline circulation actions"
>
> Do I understand correctly that the file is uploaded?
> If I follow the link /cgi-bin/koha/offline_circ/list.pl then "Gateway Timeout"
> If I follow the link /cgi-bin/koha/circ/offline.pl then "Offline 
> circulation disabled Your browser is not compatible with the built-in offline 
> circulation tool."
>
> I use Microsoft Edge and Google Chrome.
> Koha 22.11.05
> AllowOfflineCirculation - Enable
>
> What am I doing wrong?
>
> Good Luck!
>
> Igor A. Sychev
> Tomsk Polytechnic University
> https://lib.tpu.ru
>
> ___
>
> 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

Re: [Koha] Koha offline circulation

[Katrin Fischer]

Hi Igor,

the correct path is:

Circulation > Pending offline circulation actions
(/cgi-bin/koha/offline_circ/list.pl)

AllowOfflineCirculation can stay Disabled.

When using the KOCT Firefox plugin you can choose to upload and process
the transactions or to just upload and process in Koha. You should
always pick the latter if you had offline circulations at multiple stations.

I am not sure why you get the error. How many transactions are you
trying to process?

Hope this helps,

Katrin


On 05.05.23 08:45, Сычев Игорь Алексеевич wrote:

Hello!

I have a koc file. When downloading, I get the following message:
"Your file was uploaded. Once all files are uploaded, please process them in 
pending offline circulation actions.
Upload another KOC file
View pending offline circulation actions"

Do I understand correctly that the file is uploaded?
If I follow the link /cgi-bin/koha/offline_circ/list.pl then "Gateway Timeout"
If I follow the link /cgi-bin/koha/circ/offline.pl then "Offline circulation 
disabled
Your browser is not compatible with the built-in offline circulation tool."

I use Microsoft Edge and Google Chrome.
Koha 22.11.05
AllowOfflineCirculation - Enable

What am I doing wrong?

Good Luck!

Igor A. Sychev
Tomsk Polytechnic University
https://lib.tpu.ru

___

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] Koha offline circulation

[Сычев Игорь Алексеевич]

Hello!

I have a koc file. When downloading, I get the following message:
"Your file was uploaded. Once all files are uploaded, please process them in 
pending offline circulation actions.
Upload another KOC file
View pending offline circulation actions"

Do I understand correctly that the file is uploaded?
If I follow the link /cgi-bin/koha/offline_circ/list.pl then "Gateway Timeout"
If I follow the link /cgi-bin/koha/circ/offline.pl then "Offline circulation 
disabled
Your browser is not compatible with the built-in offline circulation tool."

I use Microsoft Edge and Google Chrome.
Koha 22.11.05
AllowOfflineCirculation - Enable

What am I doing wrong?

Good Luck!

Igor A. Sychev
Tomsk Polytechnic University
https://lib.tpu.ru

___

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

Re: [Koha] Koha OFFLINE

[Christopher Davis]

Luis,

If your staff need to catalog items without access to the Internet, then
you might consider having them use something like MarcEdit <
http://marcedit.reeset.net/> to create the MARC records, then save the MARC
records until later when they can connect to the Internet again. At that
point in time, they could import the MARC records into Koha.

FWIW,


Christopher Davis
Systems & E-Services Librarian
Uintah County Library
cgda...@uintah.utah.gov
(435) 789-0091 <14357890091> ext.261
uintahlibrary.org
basinlibraries.org
facebook.com/uintahcountylibrary
instagram.com/uintahcountylibrary


On Fri, Jun 23, 2017 at 1:24 PM, Marc Véron  wrote:

> Hi Luis
>
> Have a look at the following chapter in the manual:
>
> Offline Circulation Utilities
> https://koha-community.org/manual/16.11/html/ch05s13.html
>
> Kind regards
>
> Marc
>
>
> Am 23.06.2017 um 21:17 schrieb Luis Moises Rojas:
>
>> Hello everybody,
>>
>> Is there is a way where we could have koha OFFLINE?
>>
>> Let my explain:
>>
>> We have severals LIBRARIES, sometimes they do not have access to internet,
>> so they need to catalog books and when they have access again to internet,
>> them UPDATE the CENTRAL DATABASE.
>>
>> Thanks at lot
>>
>>
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Koha OFFLINE

[Marc Véron]

Hi Luis

Have a look at the following chapter in the manual:

Offline Circulation Utilities
https://koha-community.org/manual/16.11/html/ch05s13.html

Kind regards

Marc


Am 23.06.2017 um 21:17 schrieb Luis Moises Rojas:

Hello everybody,

Is there is a way where we could have koha OFFLINE?

Let my explain:

We have severals LIBRARIES, sometimes they do not have access to internet,
so they need to catalog books and when they have access again to internet,
them UPDATE the CENTRAL DATABASE.

Thanks at lot



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

[Koha] Koha OFFLINE

[Luis Moises Rojas]

Hello everybody,

Is there is a way where we could have koha OFFLINE?

Let my explain:

We have severals LIBRARIES, sometimes they do not have access to internet,
so they need to catalog books and when they have access again to internet,
them UPDATE the CENTRAL DATABASE.

Thanks at lot

-- 
*Luis Moisés Rojas P.*
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Koha Offline Circulation 1.3 Released!

[Kyle Hall]

Hello All,

I've updated the original desktop Koha Offline Circulation app for the
first time in 5 years!

Coeur d'Alene Public Library has sponsored the addition of a new feature.
The "Database" menu has now been renamed "Settings" and has a new option to
pre-set a default directory to save your .koc files in. When you set this
directory, by default the program will now save your files in that
directory with timestamp as the file name!

You can download the installer here:
https://github.com/bywatersolutions/koha-offline-circulation/releases

If you are upgrading from a previous version, you will want to uninstall
the old version first, as I had to create a new installer from scratch.
You'll also need to reselect your borrowers.db file if you had previously
selected one.

Kyle

http://www.kylehall.info
ByWater Solutions ( http://bywatersolutions.com )
Meadville Public Library ( http://www.meadvillelibrary.org )
Crawford County Federated Library System ( http://www.ccfls.org )
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Koha offline circulation tool (firefox plugin) documentation

[Francois Charbonnier]

Hi folks, how are you doing?

As requested earlier this week on the IRC, here is the Koha Offline 
Circulation Tool documentation that the (Koha) world is waiting for! ;^)


1. Humm, but what is it for?
Sometimes, you are at the circulation desk and your internet connection 
goes down. Good news, it may not be as terrible as it seems. If your 
twitter followers can wait your next tweets, it may not be an option for 
your patrons. There is already an offline circulation tool that works 
with Koha but if you want to use an easy to install offline circulation 
tool (no technical skills are required), you can try this one. It's 
quite easy to use even if some explanation might be necessary to fully 
understand everything.


2. Download and installation :

First thing : this tool is a firefox plugin you need to download and 
install on your firefox brownser. To do so, just go to the 
https://addons.mozilla.org/en/firefox/addon/koct/ page and click on the 
install now button. You may have to confirm the installation, just 
click on install now and then restart firefox to complete the 
installation. The download and the installation will take you a few 
seconds, it's very quick.


Once you installed the plugin and restarted firefox, you have the koha 
logo in the add-on bar at the bottow of firefox. A click on the logo 
will open the tool in its own window.


3. Set up :

The first thing you want to do then is to set up the plugin. The set up 
constists on 4 parameters to enter into the plugin.

* Go to the Param tab and fill up the following information :
- Server = the URL of the librarian interface.
- Branch Code = the branch you would log in if the internet connection 
was working.

- Username = your librarian account login
- Password = your librarian account password

* To save the settings, you will have to close the plugin window and 
re-open it by clicking again on the koha logo in the add-on bar.


Tips :
You can create a librarian account dedicated to the offline circulation. 
So that, no matter which librarian is at the check-in/check-out desk, 
they won't have to use their collegue account or set up the plugin again.


4. Ergonomy :

The plugin consists of four tabs which are quite self explanatory! ;^)
* Check Out to check-out items
* Check In to check-in items
* Log to keep track of every transaction the librarian did
* Param to set up the plugin

How it works :

* To check out items, go to the Check out tab and :
- scan the patron barcode
- then the item barcode
- and click save

* To check in items, go to the Check In tab and :
- scan the item barcode
- and click save

Each time, you check out or check in an item, a new transaction is 
recorded in the local plugin database and you will see, at the bottom of 
the plugin how many transactions has been made during the offline 
circulation. For example, 10 Row(s) Added means you did 10 transactions.


* Then, if you want an overview of every transactions, go to the log 
tab. This tab will show you the recordings in the plugin database and 
each row will give you the following information :

- the transaction timestamp
- the transaction type : issue or return
- the borrower cardnumber for the issues only
- the item barcode
- the transaction status

The status will be Local. as long as you are offline and don't process 
the transactions into Koha.


5. My internet connection is back, what do I do now?

Well, first thing Breathe!, everything is going to be fine... ;^)

Then, what you want is to process every transaction in Koha database. To 
do so, go to the log tab where two options are available for you.


You can Commit to koha or Apply directly the transactions into Koha. 
It depends on how you manage the check in / check out during the offline 
period.


5.1. If you checked in/out on more than one computer at the same time, 
what you want is to process every transaction consistently.


Let's say for instance that one patron checked a book out on one 
computer and then checked the same book in on another computer. To be 
consistent, you need to record the check out first and then the check 
in. Not the opposite! To do so, you need to group every transactions in 
one place, sort them all and then, process everything.


So, you need to Commit to koha the transactions from every plugins you 
worked with. This way, every issues and returns will goes to Koha in the 
Offline circulation page and be sorted out. The transaction status in 
the log will the following value :
* Authentification failed. if the plugin can not connect to your koha. 
If you encounter this problem, check the set up and be sure that every 4 
field is correctly filled. If the problem persists, you may still be 
offline... ;^)
* Added. which means the transaction has been added to the offline 
circulation page list.


Then, to process the transactions from koha. Go to the the offline 
circulation page from the circulation home page. You will see every 
transactions listed and you 

[Koha] Koha offline circulation tool (firefox plugin) documentation

[Francois Charbonnier]

Hi folks, how are you doing?

As requested earlier this week on the IRC, here is the Koha Offline 
Circulation Tool documentation that the (Koha) world is waiting for! ;^)


1. Humm, but what is it for?
Sometimes, you are at the circulation desk and your internet connection 
goes down. Good news, it may not be as terrible as it seems. If your 
twitter followers can wait your next tweets, it may not be an option for 
your patrons. There is already an offline circulation tool that works 
with Koha but if you want to use an easy to install offline circulation 
tool (no technical skills are required), you can try this one. It's 
quite easy to use even if some explanation might be necessary to fully 
understand everything.


2. Download and installation :

First thing : this tool is a firefox plugin you need to download and 
install on your firefox brownser. To do so, just go to the 
https://addons.mozilla.org/en/firefox/addon/koct/ page and click on the 
install now button. You may have to confirm the installation, just 
click on install now and then restart firefox to complete the 
installation. The download and the installation will take you a few 
seconds, it's very quick.


Once you installed the plugin and restarted firefox, you have the koha 
logo in the add-on bar at the bottow of firefox. A click on the logo 
will open the tool in its own window.


3. Set up :

The first thing you want to do then is to set up the plugin. The set up 
constists on 4 parameters to enter into the plugin.

* Go to the Param tab and fill up the following information :
- Server = the URL of the librarian interface.
- Branch Code = the branch you would log in if the internet connection 
was working.

- Username = your librarian account login
- Password = your librarian account password

* To save the settings, you will have to close the plugin window and 
re-open it by clicking again on the koha logo in the add-on bar.


Tips :
You can create a librarian account dedicated to the offline circulation. 
So that, no matter which librarian is at the check-in/check-out desk, 
they won't have to use their collegue account or set up the plugin again.


4. Ergonomy :

The plugin consists of four tabs which are quite self explanatory! ;^)
* Check Out to check-out items
* Check In to check-in items
* Log to keep track of every transaction the librarian did
* Param to set up the plugin

How it works :

* To check out items, go to the Check out tab and :
- scan the patron barcode
- then the item barcode
- and click save

* To check in items, go to the Check In tab and :
- scan the item barcode
- and click save

Each time, you check out or check in an item, a new transaction is 
recorded in the local plugin database and you will see, at the bottom of 
the plugin how many transactions has been made during the offline 
circulation. For example, 10 Row(s) Added means you did 10 transactions.


* Then, if you want an overview of every transactions, go to the log 
tab. This tab will show you the recordings in the plugin database and 
each row will give you the following information :

- the transaction timestamp
- the transaction type : issue or return
- the borrower cardnumber for the issues only
- the item barcode
- the transaction status

The status will be Local. as long as you are offline and don't process 
the transactions into Koha.


5. My internet connection is back, what do I do now?

Well, first thing Breathe!, everything is going to be fine... ;^)

Then, what you want is to process every transaction in Koha database. To 
do so, go to the log tab where two options are available for you.


You can Commit to koha or Apply directly the transactions into Koha. 
It depends on how you manage the check in / check out during the offline 
period.


5.1. If you checked in/out on more than one computer at the same time, 
what you want is to process every transaction consistently.


Let's say for instance that one patron checked a book out on one 
computer and then checked the same book in on another computer. To be 
consistent, you need to record the check out first and then the check 
in. Not the opposite! To do so, you need to group every transactions in 
one place, sort them all and then, process everything.


So, you need to Commit to koha the transactions from every plugins you 
worked with. This way, every issues and returns will goes to Koha in the 
Offline circulation page and be sorted out. The transaction status in 
the log will the following value :
* Authentification failed. if the plugin can not connect to your koha. 
If you encounter this problem, check the set up and be sure that every 4 
field is correctly filled. If the problem persists, you may still be 
offline... ;^)
* Added. which means the transaction has been added to the offline 
circulation page list.


Then, to process the transactions from koha. Go to the the offline 
circulation page from the circulation home page. You will see every 
transactions listed and you 

[Koha] Koha offline circulation tool (firefox plugin) documentation

[Arslan Farooq]

Hi Francois

A big thank you to you for this! God bless you.

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