> For the complete documentation index, see [llms.txt](https://docs.boston.gov/digital/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.boston.gov/digital/guides/legacy-website-cityofboston.gov/legacy-website-maintenance/no-tow-maintenance.md).

# No-Tow Maintenance

This application is largely maintenance-free.  There are no annual processes.

There following is a list of tasks we are requested from time-to-time

### Bulk-add Plates to No-Tow system

From time to time, a fleet operator asks us to add a block of plates to the system as a batch rather than them entering them one at a time via the interface.

In some cases:

a.[^1]  the list will be the full list they want monitored, in which case all 3 steps below should be followed, or

b. the list is just a block of new plates to register, in which case only the last step below  needs to be completed.

{% hint style="info" %}
The database is `VSQL01.web.cob` and the database is `towing`.
{% endhint %}

* (optional) Gather a list of existing plates registered to this email, and export to a csv or json or something.

  ```sql
  SELECT *
    FROM [Towing].[dbo].[towed_emails]
    where subscriber_email = 'someone@example.com' 
    order by timestamp asc
  ```
* (optional) Delete existing plates for this email:

  ```sql
  DELETE FROM [Towing].[dbo].[towed_emails]
    where subscriber_email = 'someone@example.com'
  ```
* Insert batch of new records:

  ```sql
  INSERT INTO [Towing].[dbo].[towed_emails] (
    subscriber_emaiL, subscriber_plate, subscriber_states, subscriber_htmls, source_optin
  )
  VALUES
    ('someone@example.com', 'DE920', 'RI', 1, 1),
    ('someone@example.com', '6597XL', 'ME', 1, 1),
    ('someone@example.com', 'R39242', 'DC', 1, 1)
    ...
    ('someone@example.com', 'N537937', 'LA', 1, 1);
  ```

### Add a recipient to email administrative notifications

This is done by adding the new recipient to the **`No-Tow@cityofboston.gov`** email group.

[^1]: