# Hold pickup location batch updater

**URL:** https://forum.innovativeusers.org/t/hold-pickup-location-batch-updater/391
**Category:** Sierra Repository
**Created:** [September 19, 2022, 5:54pm UTC](https://forum.innovativeusers.org/t/hold-pickup-location-batch-updater/391 "2022-09-19T17:54:42Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![helpdesk](https://forum.innovativeusers.org/letter_avatar_proxy/v4/letter/h/7c8e57/32.png) [@helpdesk](https://forum.innovativeusers.org/u/helpdesk)
#### Post date: [September 19, 2022, 5:54pm UTC](https://forum.innovativeusers.org/t/hold-pickup-location-batch-updater/391/1 "2022-09-19T17:54:42Z")

</div>

[This script](https://github.com/jmgold/Hold-Pickup-Location-Updater) will batch update the pickup location for all holds with a status of “on hold” with a specified location code to a new pickup location code

Two excel log files will be generated in the same directory as this script. One that will include all holds prior to the update and a second with any holds the script was unable to update

Within the dist folder you will find a deployable for windows executable version of the script created using pyinstaller

Prerequistes

In order to function you must complete the api\_info.ini file in the same directory and add your cacert.pem file to the certifi folder

api\_info.ini

Requires valid credentials for both the Sierra holds API and sql access The file should be formatted like so

[api]

base\_url = https://[local domain]/iii/sierra-api/v5

client\_key = [enter Sierra API key]

client\_secret = [enter Sierra API secret]

sql\_host = [enter host for Sierra SQL server]

sql\_user = [enter sql username]

sql\_pass = [enter sql password]

cacert.pem file

To find where this file is located on your computer you may run the following python script

import certifi  
certifi.where()

Once you’ve located the file, copy it to a certifi folder within the same directory

[jgoldstein@minlib.net](mailto:jgoldstein@minlib.net)