If a TariffShark client needs to change the Official Company Name of a company in TariffShark the following can be used a template for the SQL Script to run against their TS database. If you copy and paste this into an email or ticket you will need to attached the new company's TS license XML file and edit the scripting in red to provide new and old company Official Names (and new Short Name).
- The updated license file is attached. You may save it right over the top of the current License.xml file on your TariffShark application server.
- Here's the SQL statement you need to run in your TariffShark database to update the Company Name.
UPDATE dbo.Company
SET [Name] = 'Products (SE) Pipe Line',
[ShortName] = 'Products (SE) Pipe Line'
WHERE [Name] = 'Plantation Pipe Line Company'
If you do step 1 above without step 2 (or step 2 without step 1), the Company will disappear from the TariffShark desktop client UI. Once both steps are done, ask the user to log out of TariffShark and back in.
SET is used to provide the New Company's Official Name and Short Name (Note: Short Name is updatable directly in TS).
WHERE tells the script the Old Company Name to find and change.