[OPEN-ILS-DEV] Problems with call numbers in Evergreen 2.1

[Vyacheslav Tykhonov]

Dear Den,

>Maybe you could extract some rows from asset.call_number /
>asset.call_number_prefix / asset.call_number_suffix that are not showing
>up in the OPAC view for us?

The tables are below:

evergreen.v3=# select * from asset.call_number limit 10;
   id    | creator |          create_date          | editor |           edit_date           | record  | owning_lib |     label      | deleted | label_class | label_sortkey  | prefix | suffix
---------+---------+-------------------------------+--------+-------------------------------+---------+------------+----------------+---------+-------------+----------------+--------+--------
  838006 |       1 | 2011-08-14 19:04:29.666943-04 |      1 | 2011-08-14 19:04:29.666943-04 | 1006170 |          4 |                | f       |           1 |                |     -1 |     -1
 1199565 |       1 | 2011-08-16 07:58:25.058531-04 |      1 | 2011-08-16 07:58:25.058531-04 | 1334806 |          4 | ZDO 7          | f       |           1 | ZDO 7          |     -1 |     -1
  838007 |       1 | 2011-08-14 19:04:29.666943-04 |      1 | 2011-08-14 19:04:29.666943-04 |  905767 |          4 | 1996/12192     | f       |           1 | 1996 12192     |     -1 |     -1
 1200265 |       1 | 2011-08-16 07:58:25.058531-04 |      1 | 2011-08-16 07:58:25.058531-04 | 1355517 |          4 | ZK 1328        | f       |           1 | ZK 1328        |     -1 |     -1
 1200545 |       1 | 2011-08-16 07:58:25.058531-04 |      1 | 2011-08-16 07:58:25.058531-04 | 1400551 |          4 | ZK 6159        | f       |           1 | ZK 6159        |     -1 |     -1
  838008 |       1 | 2011-08-14 19:04:29.666943-04 |      1 | 2011-08-14 19:04:29.666943-04 | 1010765 |          4 | 1997/9642      | f       |           1 | 1997 9642      |     -1 |     -1
  838009 |       1 | 2011-08-14 19:04:29.666943-04 |      1 | 2011-08-14 19:04:29.666943-04 | 1056857 |          4 | 2001/1199      | f       |           1 | 2001 1199      |     -1 |     -1
  838010 |       1 | 2011-08-14 19:04:29.666943-04 |      1 | 2011-08-14 19:04:29.666943-04 |  992907 |          4 | Bro 1236/3 fol | f       |           1 | BRO 1236 3 FOL |     -1 |     -1
 1208153 |       1 | 2011-08-16 08:13:31.647324-04 |      1 | 2011-08-16 08:13:31.647324-04 | 1342639 |          4 | PM 6845        | f       |           1 | PM 6845        |     -1 |     -1
 1209499 |       1 | 2011-08-16 08:13:31.647324-04 |      1 | 2011-08-16 08:13:31.647324-04 | 1343493 |          4 | PM 6408        | f       |           1 | PM 6408        |     -1 |     -1
(10 rows)

evergreen.v3=# select * from asset.call_number_suffix limit 10;
 id | owning_lib | label | label_sortkey
----+------------+-------+---------------
 -1 |          1 |       |
  1 |          4 | fol   | fol
  3 |          4 | k     | k
  2 |          2 | .x    | x

evergreen.v3=# select * from asset.call_number_prefix limit 10;
 id | owning_lib | label | label_sortkey
----+------------+-------+---------------
 -1 |          1 |       |
  1 |          4 | Bro   | bro
  2 |          4 | ZK    | zk
  3 |          4 | ZO    | zo
  4 |          4 | ZF    | zf

As I said before, It's possible to see all this call numbers from Holdings Maintenance, but suddenly they're disappared from OPAC view.

---
Best Regards,
Vyacheslav Tykhonov
Software Developer
Internationaal Instituut voor Sociale
http://www.iisg.nl

On Thu, Apr 12, 2012 at 10:28:00PM +0200, Vyacheslav Tykhonov wrote:
> Hi there,
>
> At the moment we're working on upgrade our current stable version 2.0.3 to 2.1, but have a couple of problems with call numbers as described below:
>
> OPAC vew:
> After doing all migration steps as described in update manual all call numbers aren't visible in OPAC view, but still can be opened in the Holdings Maintenance menu.
> We understand that now every call number split to 3 parts (prefix, callnumber, suffix) in new version, so we must adjust some new settings for libraries.

It's possible to have prefixes and suffixes for call numbers, but it's
not necessary; in asset.call_number the prefix and suffix column values
should default to "-1", which should be an entry in
asset.call_number_prefix / asset.call_number_suffix with a "label" value
of an empty string - not NULL, but an empty string.

Maybe you could extract some rows from asset.call_number /
asset.call_number_prefix / asset.call_number_suffix that are not showing
up in the OPAC view for us?

> Is it possible to get more information about all changes for holdings in Evergreen 2.1 and manual how to make automatic migration to new way of storing call numbers?

The upgrade scripts are supposed to automatically handle that migration
for you.  They worked for us in making the jump from 2.0.x to 2.1.x
(although we had to massage them a bit to make them work for us due to
some local customizations).

> Editing callnumbers:
> When adding a new call number, we get the following error message:
> Error in g.vivicate_update_volumes, acn_id = undefined temp_acn = {"ilsevent":-1,"textcode":"Server or method error"}
> We don't have any additional information about temporary callnumbers in the logs, but probably it's the same issue as new settings for libraries.

It's probably worth adding some alert() messages to your
volume_copy_creator.js file in the vivicate_update_volumes() method to
display the value of variables like acn.id, acnp.id, and acns.id
throughout the method, and then trace the call in the server logs to the
FM_ACN_FIND_OR_CREATE method (open-ils.cat.call_number.find_or_create
per Open-ILS/xul/staff_client/chrome/content/main/constants.js) to see
if you can dig up any more information.


End of Open-ils-dev Digest, Vol 73, Issue 15
********************************************