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.
(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 = '[email protected]' order by timestamp asc
(optional) Delete existing plates for this email:
DELETE FROM [Towing].[dbo].[towed_emails] where subscriber_email = '[email protected]'
Insert batch of new records:
INSERT INTO [Towing].[dbo].[towed_emails] ( subscriber_emaiL, subscriber_plate, subscriber_states, subscriber_htmls, source_optin ) VALUES ('[email protected]', 'DE920', 'RI', 1, 1), ('[email protected]', '6597XL', 'ME', 1, 1), ('[email protected]', 'R39242', 'DC', 1, 1) ... ('[email protected]', 'N537937', 'LA', 1, 1);
Add a recipient to email administrative notifications
This is done by adding the new recipient to the [email protected]
email group.
Last updated
Was this helpful?