[OPEN-ILS-GENERAL] Clean up holdings

[Geoff Sinclair]

Jason Etheridge wrote:
>> This last part will be a problem if you introduce new shelving locations
>> within the second batch.  If all the shelving locations in the second batch
>> were already present in the first batch, I think you can safely comment out
>> the first SQL statement in the file. Otherwise, if there are locations in
>> the second batch file that aren't in the first, copies will not be created
>> for those locations.
>>
>> Anyone know a better way to deal with this?
>>     
>
> Geoff,
>
> Try modifying that first INSERT statement in generate_copies.sql like so:
>
> INSERT INTO asset.copy_location (name, owning_lib)
>         SELECT  DISTINCT l.location, ou.id
>           FROM  staging_items l JOIN actor.org_unit ou
>                 ON (l.owning_lib = ou.shortname)
>           WHERE l.location NOT IN ( SELECT name FROM
> asset.copy_location WHERE owning_lib = ou.id );
>
>   

Thanks Jason, this works!

Geoff