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 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.

The database is VSQL01.web.cob and the database is towing.

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

  SELECT *
    FROM [Towing].[dbo].[towed_emails]
    where subscriber_email = '[e-mail]' 
    order by timestamp asc

• (optional) Delete existing plates for this email:

  DELETE FROM [Towing].[dbo].[towed_emails]
    where subscriber_email = '[e-mail]'

• Insert batch of new records:

  INSERT INTO [Towing].[dbo].[towed_emails] (
    subscriber_emaiL, subscriber_plate, subscriber_states, subscriber_htmls, source_optin
  )
  VALUES
    ('[e-mail]', 'DE920', 'RI', 1, 1),
    ('[e-mail]', '6597XL', 'ME', 1, 1),
    ('[e-mail]', 'R39242', 'DC', 1, 1)
    ...
    ('[e-mail]', 'N537937', 'LA', 1, 1);

Add a recipient to email administrative notifications

This is done by adding the new recipient to the [e-mail] email group.