Importing stat cat information can produces import.item.invalid.stat_cat_data error

[Dale Rigney]

Tested in Evergreen 3.7

When uploading/importing items stat cat information in the MARC Batch Import/Export screen Evergreen could produce an "import.item.invalid.stat_cat_data error" error message when the item stat cat name is owned by more then one system. The stat cat information in your holdings record is validated by checking for a matching stat cat name in the asset.stat_cat table and then checking to ensure the entry is located in the asset.stat_cat_entry table for the matching stat cat id. If you have two systems with the exact same Item stat cat name, Evergreen sometimes looks at the wrong asset.stat_cat id to search for the asset.stat_cat_entry record.

I believe this could be prevented if the Vandelay.pm would also check for the stat cat owner based on the item circulating library.

To duplicate you will need two or more asset.stat_cat records with the exact name but owned by different libraries. Then create entries for just one those stat cat records but not the other. In your holdings information you send the stat cat name and the stat cat entry divided by a | (i.e. <subfield code="d">Special Item Types|McNaughton Item</subfield>). Evergreen tries to match the stat cat name, then grabs the stat cat id and looks for the entry in the asset.stat_cat_entry table by the matching asset.stat_cat.id. If Evergreen grabs the wrong stat cat record based on the name it will search for the entry for the wrong stat cat.