[Koha] Migrate transaction data

2013-04-26 Thread gk
Dear Sir/Madam, I tried to export current circulation data from my legacy software to koha 3.8 but not successful. I tried LOAD DATA LOCAL INFILE '/transactions.txt' INTO TABLE issues; and got the following error: ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint

[Koha] Koha error

2013-04-26 Thread pandu rangaswamy
Dear All, I tried to import the data(Books) from the existing koha 3.0 version to Koha version 3.10 in ubuntu 12.4. When i searched it shows only Books Biblios data only, its not showing the item details. Then i did undo the imported data, after that if i search again it shows 116 books. if i trie

Re: [Koha] local use recorded / borrower

2013-04-26 Thread e-Libris Helpdesk
If you check out anything to a "local user" Koha does not add any records to the issues table. Instead Koha adds a record to the statistics table with a "localuse" code in the "type" column. A "local use" patron has a patron category code which uses the "statistical" type. On Thu, Apr 25, 2013 at

Re: [Koha] local use recorded / borrower

2013-04-26 Thread Samuel Desseaux
Le 26/04/2013 14:38, e-Libris Helpdesk a écrit : If you check out anything to a "local user" Koha does not add any records to the issues table. Instead Koha adds a record to the statistics table with a "localuse" code in the "type" column. A "local use" patron has a patron category code which

Re: [Koha] How to handle multiple copies/items or authors while converting excel data to MARC

2013-04-26 Thread Olugbenga Adara
Hi Nanaji, To start with the authors, you should have each author in its own cell in excel. Then export out in excel in tab delimited, rather than comma. Then map the additional author fields to 700$a in MarcEdit. Only the first (main author) should be mapped to 100$a. As per the accession num

Re: [Koha] Byte Order Mark issue importing patrons

2013-04-26 Thread Galen Charlton
Hi, On Thu, Apr 25, 2013 at 4:34 PM, Robin Sheat wrote: > I think it'd be enough for Koha to ignore (or even understand) the BOM. > No reason for it to be syspref controlled if you can make it do the > right thing. It _might_ even be enough to tell it to open the file as > UTF-8. I agree -- Koha