[Koha] Source of Acquisition

Alvaro Cornejo cornejo.alvaro at gmail.com
Sat Dec 7 04:14:28 NZDT 2019

Hi Charles

I don't know if you can do the replacement/truncate the 952 from koha but
you can doit directly in mysq with a query like:



Of course you need to work the sample query to suit your needs.

Hope this helps,



Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier
celular y Nextel
en el Perú, México y en mas de 180 paises. Use aplicaciones 2 vias via SMS
y GPRS online
              Visitenos en www.perusms.com

Le jeu. 5 déc. 2019 à 20:24, Charles Kelley <cmkelleymls at gmail.com> a
écrit :

> Hello Alvaro et al!
>     In our latest exchange, on 5 Dec 2019 08:28, you wrote:
> You might concatenate the acquisition number and the Access Db id on 952$i
>> with a character separator like a pipe, asterisk, semicolon, etc. ie
>> 2019-01325|54342.
>     Yes, that's an excellent suggestion.
>     My supervisor and I are arranging a meeting with the other principals
> to look at a number of issues and settle them before the catalog goes live.
> Once you get rid of the old Access DB system you can run a query to the
>> Koha DB biblio table and, using the separator, remove all reference to the
>> old AccessDB.
>     How does one do that in Koha, through the Tool -> Batch Item
> Modification? I know how to run a query, but it's the changing of a group
> of records by removing a portion of one field or subfield that I don't
> understand.
>     This is all new to me, and I'd be grateful for whatever help your can
> offer.
> --
>     -- Charles.
>     Charles Kelley, MLS
>     PSC 704 Box 1029
>     APO AP 96338
>     Charles Kelley
>     1-5-2 Tsukimino #210
>     Yamato-shi, Kanagawa-ken, 〒242-0002
>     JAPAN
>     1-301-741-7122 [US cell]
>     011-81-80-4714-5490 [JPN cell]
>     mnogojazyk at aol.com [h]
>     cmkelleymls at gmail.com [p]
>     linkedin.com/in/cmkelleymls <http://www.linkedin.com/in/cmkelleymls>
>     Meeting Your Information Needs. Virtually.

More information about the Koha mailing list