[Koha-devel] Problem retrieving data from DB on Koha 16.11

2017-07-31 Thread Rodrigo Santellan
Hi, I have troubles with retrieving the data from the items. On my db I have this on the table *biblioitems* field *marcxml* 5563 0 CEN c CEN Beltrame Regina 40938 Silva, Virginia Silva, Virginia CV 1609 IMPR CZ 302.23 GAN ej.3 C0186

[Koha-devel] On-site checkouts

2017-09-11 Thread Rodrigo Santellan
Hi, I have some items on the library that are only for using on the library. The difference with those items is that you can place a hold on them to use them during the day and also you can place a hold on them and checkout for using on the weekends and during the night (you check it out at last h

Re: [Koha-devel] On-site checkouts

2017-09-11 Thread Rodrigo Santellan
e to 0 in the circulation rules, so that the circulation desk has to > confirm the check out. > > On Mon, Sep 11, 2017 at 7:54 AM, Rodrigo Santellan > wrote: > >> Hi, >> >> I have some items on the library that are only for using on the library. >> The differen

[Koha-devel] Migrate/Upgrade from 2.2.3 to latest.

2016-09-12 Thread Rodrigo Santellan
Hi, I'm trying to do a migration or upgrade from koha 2.2.3 to koha 3. I know is a daunting task that I have embarked but I'm trying to bring back a library to the latest updates of the community. So far this are the steps I have done: 1 - I dump an empty schema of the DB and create a new one wit

Re: [Koha-devel] Migrate/Upgrade from 2.2.3 to latest.

2016-09-12 Thread Rodrigo Santellan
cards_upgrade.pl scripts. I think those > where supposed to be run by the updatedatabase.pl script, but I seem to > recall having trouble with that myself. > > On Mon, Sep 12, 2016 at 7:07 AM, Rodrigo Santellan > wrote: > >> Hi, >> >> I'm trying to do a mig

Re: [Koha-devel] Migrate/Upgrade from 2.2.3 to latest.

2016-09-13 Thread Rodrigo Santellan
> > That table is gone, but I don't know when it gets dropped. I looked > through > > updatedatabase.pl and didn't see it get dropped. So I don't know. If > you > > are aiming for a recent release then it should be ok to omit the table > and > >

Re: [Koha-devel] Migrate/Upgrade from 2.2.3 to latest.

2016-09-13 Thread Rodrigo Santellan
e 1281. Has anybody has the correct definition of the table permissions? Regards. On Tue, Sep 13, 2016 at 11:35 AM, Rodrigo Santellan wrote: > Hi, > > I have changed: 3.00.00.053 to remove the constraint to labels_templates > and now it goes smooth on that part. I'll add more log

Re: [Koha-devel] Migrate/Upgrade from 2.2.3 to latest.

2016-09-14 Thread Rodrigo Santellan
are fixes by 3.01.00.009, certainly because MySQL > strictness has changed since 3.00.00.068 > > Try to change the 2 code columns to default null. > If it works, please open a new bug report (and attach a patch if you > know how to do it :)) > > Cheers, > Jonathan > >

Re: [Koha-devel] Migrate/Upgrade from 2.2.3 to latest.

2016-09-14 Thread Rodrigo Santellan
g imports'), (13, 'export_catalog', 'Export bibliographic and holdings data'), (13, 'import_patrons', 'Import patron data'), (13, 'delete_anonymize_patrons', 'Delete old borrowers and anonymize circulation history (deletes borrower read

Re: [Koha-devel] Migrate/Upgrade from 2.2.3 to latest.

2016-09-14 Thread Rodrigo Santellan
); > > > > On Wed, Sep 14, 2016 at 1:10 PM, Rodrigo Santellan > wrote: > >> I have almost complete the updatadatabase.pl without db errors. >> >> Now I'm missing some data on userflags, what should be the 13 module_bit >> >> Upgrade to 3.00.

[Koha-devel] Custom authentication

2016-09-15 Thread Rodrigo Santellan
Hi, I need to authenticate using a custom LDAP and a custom Web Service authentication how will be the best to implement this without forking the code. I ask this because I'm trying to migrate an old Koha 2.2.3 that has gone astray from the community and I don't want to start doing that again. W

[Koha-devel] Where the field studentnumber of borrower is?

2016-09-16 Thread Rodrigo Santellan
Hi, I'm migrating from Koha 2 to 3 and the field studentnumber of the table borrowers has gone? It should be now on a patron custom type? Regards and thanks for the help! ___ Koha-devel mailing list Koha-devel@lists.koha-community.org http://lists.koha-

Re: [Koha-devel] Where the field studentnumber of borrower is?

2016-09-16 Thread Rodrigo Santellan
Thank you Zeno, I will create some sql to do it from the db directly. Thanks a lot! On Fri, Sep 16, 2016 at 4:01 PM, Zeno Tajoli wrote: > Hi, > > >I'm migrating from Koha 2 to 3 and the field studentnumber of the table > borrowers has gone? > reading the code of update22to30.pl the answer is y

Re: [Koha-devel] To React or not to React

2016-09-19 Thread Rodrigo Santellan
Arthur, I believe that foundation is an alternative to bootstrap. React JS is on the league of backbone, angular and ember. I have use React JS on a project and the best thing about it is the possibility of rewrite really small parts of the page. Create small widget to increase the functionality

[Koha-devel] Authentication field on borrower.

2016-09-20 Thread Rodrigo Santellan
Hi, I'm trying to figure out where the field authentication of the borrowers table is used? Regards. ___ Koha-devel mailing list Koha-devel@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : http://www

Re: [Koha-devel] Authentication field on borrower.

2016-09-21 Thread Rodrigo Santellan
Then I have a legacy application customization that the upgrade22to30.pl didn't find out. Is there any possible way to add different authentication per user? Say use LDAP on one user, DBI on another? Thanks for the help! Regards On Wed, Sep 21, 2016 at 8:54 AM, Owen Leonard wrote: > > I'm try

[Koha-devel] Customize debian scripts.

2016-09-21 Thread Rodrigo Santellan
Hi, I'm looking at the Debian scripts and I'm finding out that all the paths are hard coded. This is not really useful when installing the development version. Is worthy to change them to relatives paths? Or have it to take the enviroment variable to build the paths? Or is a waste of time? Regar

Re: [Koha-devel] Customize debian scripts.

2016-09-21 Thread Rodrigo Santellan
I'm looking to kohadevbox for how to use that for my scripts. On Wed, Sep 21, 2016 at 11:23 AM, Tomas Cohen Arazi wrote: > Rodrigo, take a look at koha-gitify, or even to kohadevbox. > > El mié., 21 sept. 2016 a las 10:19, Rodrigo Santellan (< > rsantel...@gmail.com

[Koha-devel] Zebra indexing

2016-09-22 Thread Rodrigo Santellan
Hi, Is there any way to show how many biblios index has zebra? Running on the intranet searching for an item on item search I get some results. Trying to use the OPAC or the Search bar I don't have any matches, zebra is running and I have run perl ./misc/migration_tools/rebuild_zebra.pl -b -a -r

Re: [Koha-devel] Zebra indexing

2016-09-22 Thread Rodrigo Santellan
omas Cohen Arazi wrote: > Hi > > El jue., 22 sept. 2016 a las 12:01, Rodrigo Santellan (< > rsantel...@gmail.com>) escribió: > >> Hi, >> >> Is there any way to show how many biblios index has zebra? Running on the >> intranet searching for an item on it

[Koha-devel] Elasticsearch not searching.

2016-09-28 Thread Rodrigo Santellan
Hi, I have installed Elasticsearch after giving up on Zebra. I have follow the the wiki: https://wiki.koha-community.org/wiki/Elasticsearch#Install_elasticsearch and installed latest Elasticsearch through the official repository. My installed version is: curl -XGET 'localhost:9200' { "name" : "

Re: [Koha-devel] Elasticsearch not searching.

2016-09-28 Thread Rodrigo Santellan
gt; You could try installing 1.7 and seeing how you go > > Chris > > > * Rodrigo Santellan (rsantel...@gmail.com) wrote: > > Hi, > > > > I have installed Elasticsearch after giving up on Zebra. I have follow > the the > > wiki: https://wiki.koha-comm

Re: [Koha-devel] Elasticsearch not searching.

2016-09-29 Thread Rodrigo Santellan
t; Received SearchResponse. > Search was a bloomin' failure. > Number of hits: 0, setno 6 > Result Set Status: none > records returned: 0 > Diagnostic message(s) from database: > [114] Unsupported Use attribute -- v2 addinfo '1' > Elapsed: 0.000289 > > D

[Koha-devel] Migrating from koha 2.2 to koha 16.05

2016-10-06 Thread Rodrigo Santellan
Hi, I have a question about the locations and from where it get the data of the marcs. For what I understand after running the move_marc_to_biblioitems.pl two new columns are created, marc and marcxml. And it moves all the data from marc_subfield_table to those fields. That has happen alright,

[Koha-devel] Trying to generate the package.

2016-10-11 Thread Rodrigo Santellan
Hi, I'm trying to generate the package to learn how to so can I apply it later. I follow: https://wiki.koha-community.org/wiki/Building_Debian_Packages_-_The_Easy_Way on the kohadevbox (jessie) but when I try to generate the package this message appear: W: /home/vagrant/.pbuilderrc does not exist

Re: [Koha-devel] Development environment ,

2016-10-25 Thread Rodrigo Santellan
Karam, If kohadevbox don't start on windows I have the scripts to use koha on Vagrant (before I knew how to make work kohadevbox). Is not the standard way to run koha for the developers... But you will not need to install Linux on your machine. Regards On Tue, Oct 25, 2016 at 9:28 AM, Owen Leon

Re: [Koha-devel] Development environment ,

2016-10-28 Thread Rodrigo Santellan
Karam, Put the content where you did the git clone and follow this steps: 1. vagrant up (retrieve ubuntu 16.04) 2. vagrant ssh 3. sh /vagrant/provisioning/fullProvisioning.sh 4. sh /vagrant/provisioning/makeKoha.sh 5. sudo sh /vagrant/provisioning/apacheEnviroment.sh I separated

[Koha-devel] Creating new template.

2016-10-31 Thread Rodrigo Santellan
Hi, I want to create a new template for a custom action in the patron details. What I need is to call a web service to update some data of the patron but only is the staff wants (Ideally it will be called on a cron job at midnight). I have two languages English and Spanish, do I need to change bo

Re: [Koha-devel] Creating new template.

2016-10-31 Thread Rodrigo Santellan
I could, is that the preferred way? Should I check on https://wiki.koha-community.org/wiki/JQuery_Library for coding standards of Koha? Regards On Mon, Oct 31, 2016 at 2:47 PM, Tomas Cohen Arazi wrote: > Can't you inject that using Jquery? > > El lun., 31 oct. 2016 a las

Re: [Koha-devel] Creating new template.

2016-10-31 Thread Rodrigo Santellan
Is really specific. On Mon, Oct 31, 2016 at 2:52 PM, Tomas Cohen Arazi wrote: > ARe you trying to introduce a new feature or enhancement to Koha? For > everyone to use? Or is it just too specific? > > El lun., 31 oct. 2016 a las 14:49, Rodrigo Santellan (< > rsantel...@gm

Re: [Koha-devel] Creating new template.

2016-10-31 Thread Rodrigo Santellan
tes. Otherwise you would need to > maintain your own branch. So Jquery is a good way of injectng stuff to the > DOM, but it will depend on what you are trying to do. > > regards > > El lun., 31 oct. 2016 a las 14:59, Rodrigo Santellan (< > rsantel...@gmail.com>) escribió: >

[Koha-devel] Create autocomplete for addbiblio.pl

2016-10-31 Thread Rodrigo Santellan
Hi, I'm trying to create an autocomplete for a few fields when adding a biblio. My problem so far is that the ids generated are things like this: *tag_110_subfield_a_361770_300725* (I'm trying to create an author autocomplete). One quick fix for me will be to add to the fields a class containing t

Re: [Koha-devel] Creating new template.

2016-10-31 Thread Rodrigo Santellan
I will try that on my scripts! Thanks a lot!! On Mon, Oct 31, 2016 at 5:06 PM, Tajoli Zeno wrote: > Hi Rodrigo, > > Il 31/10/2016 19:20, Rodrigo Santellan ha scritto: > >> For what I see the code that I put on |IntranetUserJS will be used on >> every intranet page.

Re: [Koha-devel] Create autocomplete for addbiblio.pl

2016-11-01 Thread Rodrigo Santellan
_builder scripts. > > Cheers, > Jonathan > > On Mon, 31 Oct 2016 at 20:19 Rodrigo Santellan > wrote: > >> Hi, >> >> I'm trying to create an autocomplete for a few fields when adding a >> biblio. My problem so far is that the ids generated are things li

Re: [Koha-devel] koha on redhat

2016-11-04 Thread Rodrigo Santellan
Divya, There is a page on the wiki that says how to on RHEL: https://wiki.koha-community.org/wiki/Koha_on_Redhat_Enterprise_6 My recommendation is that install it on a machine with internet first for all the dependency resolutions and then try it on the actual server. You can download the source

Re: [Koha-devel] [Koha] Redundant infrastructure for Koha

2016-11-07 Thread Rodrigo Santellan
Chris, What about the uploaded files? You will need to replicate them to the other server. What about the cross connection of the DB, you will use mysql proxy in the middle? I'm really curious about those answers. Regards. On Mon, Nov 7, 2016 at 5:05 PM, Chris Cormack wrote: > On 8 November

Re: [Koha-devel] KohaDevBox and Xenial

2016-11-14 Thread Rodrigo Santellan
Thomas, Have you try "bento/ubuntu-16.04" for me was the only Xenial that had worked. Regards! On Sun, Nov 13, 2016 at 11:26 AM, Tomas Cohen Arazi wrote: > Hi everyone, recently I changed the Xenial box that KohaDevBox has > configured. But it seems I didn't find (yet) the right box. I managed

[Koha-devel] OAI-PMH filter data

2016-11-22 Thread Rodrigo Santellan
, and the google group is almost dead. Does anybody can give me a clue for where to start looking to accomplish that? I believe could be a nice resource to add to the wiki! Regards and thanks for any help! Rodrigo Santellan ___ Koha-devel mailing list Koha

Re: [Koha-devel] INSTALLING KOHA ON UBUNTU 16

2017-03-16 Thread Rodrigo Santellan
Can you attach the error log? Regards. On Thu, Mar 16, 2017 at 11:12 AM, bwengu wrote: > Hello, > I was installing koha on my Ubuntu 16 but when I managed to get to web > installer, more especially stage 3 I got Software error > > > > -- > View this message in context: http://koha.1045719.n5.na

[Koha-devel] Upgrading from koha 16.05 to 16.11

2017-03-20 Thread Rodrigo Santellan
Hi, I'm upgrading from koha 16.05 to 16.11 (I'm trying to keep up to date) and I see on the updatedatabase.pl this: *DBD::mysql::db do failed: Can't DROP 'isbn'; check that column/key exists [for Statement "ALTER TABLE biblioitems DROP INDEX isbn"] at /home/vagrant/kohaclone/installer/data/mysql

Re: [Koha-devel] AUTO_INCREMENT fix - prevent data lost

2017-07-12 Thread Rodrigo Santellan
I only have one question about it, it only affects MySQL 5.7 and MariaDB 10.02? Koha should not say that it works with certain version of the MySQL or MariaDB? I been struggling a lot with issues on the DB because I'm on new version. Regards, Rodrigo On Wed, Jul 12, 2017 at 3:11 PM, Jonathan Dr