[Koha] Hello and Questions about Koha Acquisitions

2012-04-05 Thread Joe
module work? Would we be able to import Price, Fund, Vendor, Order Number, and Invoice Number to our 945 line? Is there a simple report we could run that would give us that information along with the Title and ISBN of the item? Sincerely, -Joe- -- Joseph Alway Access Services Coordinator Chan Shun

Re: [Koha] Installation problem

2012-04-06 Thread Joe
This is straight from my how-to setup koha. ;-) *[cmd] means you should be entering the following command in the command line / terminal.* (You need to know the password for root or you need to be using the username and password that was given to you by your system administrator.) ** * * *7 -

Re: [Koha] Installation problem

2012-04-06 Thread Joe
t Literary Masterpieces. Freely Available At Your Fingertips. Project Gutenberg. The Free Digital Library." http://www.gutenberg.org === On Fri, Apr 6, 2012 at 9:40 AM, Joe wrote: > This is straight from my

Re: [Koha] Installation problem

2012-04-09 Thread Joe
o the next update, but that was at least two months ago. -Joe- On Fri, Apr 6, 2012 at 1:03 PM, Owen Leonard wrote: > > Here is the link to my Koha Setup document, if anyone is interested. > > > http://dl.dropbox.com/u/21733088/Koha%20on%20Ubuntu%20Installation%20Manual.doc > > Ma

Re: [Koha] koha on ubuntu: Date::Calc::Add_Delta_Days(): not a valid date...

2012-04-09 Thread Joe
problem. -Joe- On Mon, Apr 9, 2012 at 1:12 AM, Khurram wrote: > Hi > > I have successfully installed koha on ubuntu. > > But when i try to login from front end, it gives following error : > > > -

Re: [Koha] add new record in Koha

2012-04-10 Thread Joe
ke Sure to Choose what collection the item is going into and Click the Add Button. Clicking the Add Button in the Create Order Screen will create an item for that record and you will be able to receive the order, because there is an item attached to the record you created. -Joe- On Tue, Apr 10, 2012

Re: [Koha] Import Checkout to koha

2012-04-10 Thread Joe
Were you wanting a link to the Database Scheme? http://schema.koha-community.org/ It's not a straight forward answer, but the information is there. -Joe- On Tue, Apr 10, 2012 at 6:55 AM, kamild wrote: > Hi, > I want import information about checkout to koha. Where is the informat

Re: [Koha] add new record in Koha

2012-04-11 Thread Joe
Here is a quick tutorial I made on using the Acquisitions module in Koha. http://dl.dropbox.com/u/21733088/Acquisitions%20Demo.htm -Joe- On Wed, Apr 11, 2012 at 12:09 AM, shahas rahman wrote: > Hi,,thank u for reply,, > > Everything is OK till step#2. > I have doubt about crea

Re: [Koha] Koha assistance

2012-04-12 Thread Joe
Do you have the latest version of Koha? I believe the latest version is 3.6. -Joe- On Thu, Apr 12, 2012 at 12:25 AM, shahas rahman wrote: > hi,,, > > I watched one Demo of Koha,, > In that Demo item Records are creating while placing > order(automatically),,, > > > But

Re: [Koha] add new record in Koha

2012-04-12 Thread Joe
a Description for the item type and click "Save Changes". Now you should be able to choose an Item Type in the Koha Item Type selection box. -Joe- On Thu, Apr 12, 2012 at 3:14 AM, shahas rahman wrote: > Hi,,Joe,, > Sorry for disturbing u,, > > In my koha,,am getting error while

Re: [Koha] Local call number

2012-04-19 Thread Joe
C, on the Intranet, in the editor, and will make it show up as collapsed in the editor. See this page for more details: http://manual.koha-community.org/3.6/en/catadmin.html#marcbibframeworks Sincerely, -Joe- On Wed, Apr 18, 2012 at 4:36 PM, Paula Corman wrote: > I am embarking on cataloging

Re: [Koha] (no subject)

2012-06-07 Thread Joe
up except in the brief history view, but the information is there. None of this may be ideal, but it works. :-) It sure beats paying $1,000 a year for an outdated and mostly useless periodicals program. :-) We can actually search by subject now. :-) Sincerely, -Joe- -- Joseph Alway Access Service

[Koha] Fwd: Debian and Koha 3.0 Installation

2012-06-21 Thread Joe
/Koha_3.8_on_Debian_Squeeze Sincerely, -Joe- On Thu, Jun 21, 2012 at 10:43 AM, felix chisoni wrote: > Anyone with an installation guide there. I have tried for the past weeks to > install koha from small images but I have failed. Now I have 5 Cds of > Debian Lenny plus Koha 3.0 Cd. I am su

Re: [Koha] Wiki down?

2020-02-03 Thread Joe Sikowitz
It was working earlier this morning, but it looks like it is down now. Joe On Mon, Feb 3, 2020 at 10:19 AM George wrote: > Is it just me, or is the community wiki down? > > George > > -- > George Williams > Next Search Catalog Coordinator > Send NEXT support e-mai

Re: [Koha] Adding pre-defined Manual Invoice Types

2018-12-06 Thread Joe Sikowitz
value description will be used as the amount. Enter monetary amounts in the description without currency symbols. I hope that helps. Best, Joe On Thu, Dec 6, 2018 at 4:54 AM Mutsikiwa Admire wrote: > I would like to add pre-defined Manual Invoices Types. For instance, > Miscellaneous -$2,

Re: [Koha] Need a little help with an SQL query

2019-02-20 Thread Joe Sikowitz
Something like this may work: SELECT b.cardnumber, b.surname, b.firstname, i.issuedate FROM borrowers b INNER JOIN issues i ON (b.borrowernumber = i.borrowernumber) WHERE i.issuedate BETWEEN <> AND <> GROUP BY b.cardnumber Joe On Wed, Feb 20, 2019 at 11:24 AM Chris Brown wrot

Re: [Koha] Need a little help with an SQL query

2019-02-20 Thread Joe Sikowitz
ernumber) INNER JOIN old_issues o ON (b.borrowernumber = o.borrowernumber) WHERE i.issuedate or o.issuedate BETWEEN <> AND <> GROUP BY b.cardnumber Joe On Wed, Feb 20, 2019 at 11:35 AM Joe Sikowitz wrote: > Something like this may work: > > SELECT b.cardnumber, b.surname, b.firstnam

Re: [Koha] Need a little help with an SQL query

2019-02-20 Thread Joe Sikowitz
ON (b.borrowernumber = o.borrowernumber) WHERE i.issuedate BETWEEN <> AND <> OR o.issuedate BETWEEN <> AND <> GROUP BY b.cardnumber On Wed, Feb 20, 2019 at 12:11 PM Joe Sikowitz wrote: > You could also add in old issues which you probably would want so that you > get

Re: [Koha] Need a little help with an SQL query

2019-02-21 Thread Joe Sikowitz
o.issuedate AS 'Old Issue' FROM borrowers b LEFT JOIN issues i ON (b.borrowernumber = i.borrowernumber) LEFT JOIN old_issues o ON (b.borrowernumber = o.borrowernumber) WHERE i.issuedate >= DATE_SUB(CURDATE(), INTERVAL 6 MONTH) OR o.issuedate >= DATE_SUB(CURDATE(), INTERVAL 6 MONTH) GRO

Re: [Koha] Need a little help with an SQL query

2019-02-21 Thread Joe Sikowitz
That doesn't work. It seems to be implicitly saying find rows where i.issuedate IS NOT NULL OR o.issuedate BETWEEN <> AND <>. Joe On Thu, Feb 21, 2019 at 1:05 PM Chris Brown wrote: > Hi Barton and Joe, > > All interesting discussion, and many thanks for the he