Versions Compared

Version Old Version 9 New Version Current
Changes made by

Alger Alama

Alger Alama

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Without Twilio credentials, restaurant sites will not be able to utilize the features: Text to Pay or Dispatch Dashboard.

Twilio Account

...

A new phone number might need to be implemented for an ECM Instance. This is how you purchase a phone number from Twilio. (Approval needed by Product Owner/CTO/CEO first.)

  • Click Explore Products on left panel of the dashboard.


  • Click Phone Numbers under Super Network

...

  • Click Manage
  • Click Buy Number
  • Input search criteria. (Utilize Advanced Search for access to beta numbers and specific requirements.)
  • All purchasable numbers will be listed. 
  • Click on  Buy


  • Click Active Numbers under Manage to display all purchased phone numbers.
  • Phone numbers will display the city they are connected to.
  • Active Configuration will display what the Webhooks that are currently utilizing the phone number (if applicable).

Apply Twilio Data to ECM Instance (SQL)

Info

NOTE: This section is for employees trained in SQL. If you are unaware of how to utilize these queries, please speak to your shift - lead on who to escalate toescalation procedures.

Now that you have an Account SID, Auth Token, and phone number. You , you can run this SQL query to apply the changes to the ECM.CLOUD database. These queries will change the values in the DBO.SYSTEMSETTINGS section of the database. 

  • Log into ECM Instance server (ECM Instance Edge1 in Bomgar)Callaway Edge1, East Lake Edge1, Dornoch Edge1, etc. in Bomgar).
  • Open SQL Management Studio.
  • Click ecm.cloud under Databases.
  • Right click dbo.SystemSettings and choose Select Top 1000 Rows. 

Image Added

  • Press CTRL+N for a new SQL Query page.
  • Enter the query below and change the set value sections to their indicated changes. (i.e., Auth Token, Account SID, etc.), then click Execute.
Begin transaction
update [ecm.cloud].[dbo].[SystemSettings]
set value ='Auth Token'
where SystemSettingId ='F3CA754B-9B7B-493A-B622-00CDAE43445F'
update [ecm.cloud].[dbo].[SystemSettings]
set value ='Account SID'
where SystemSettingId ='C73ABD0C-F803-4341-992D-2EE72FF2393F'
update [ecm.cloud].[dbo].[SystemSettings]
set value ='Phone Number'
where SystemSettingId ='E249932E-F457-4F8B-A94E-5826BC46F065'
Select * from SystemSettings
where name like '%twilio%'
Rollback
Select * from SystemSettings
where name like '%twilio%'
  • This initial query will show the differences in the changes, comparing them before and after, because of the Rollback clause.
  • After review, change Rollback to Commit.
Info

Verify ALL CHANGES are correct before running the commit query below.


Begin transaction
update [ecm.cloud].[dbo].[SystemSettings]
set value ='Auth Token'
where SystemSettingId ='F3CA754B-9B7B-493A-B622-00CDAE43445F'
update [ecm.cloud].[dbo].[SystemSettings]
set value ='Account SID'
where SystemSettingId ='C73ABD0C-F803-4341-992D-2EE72FF2393F'
update [ecm.cloud].[dbo].[SystemSettings]
set value ='Phone Number'
where SystemSettingId ='E249932E-F457-4F8B-A94E-5826BC46F065'
Select * from SystemSettings
where name like '%twilio%'
Commit
Select * from SystemSettings
where name like '%twilio%'
  • Click Execute to solidify changes to database.
  • Navigate to C:\inetpub\ECM\ECM\.
  • Edit ecm.web config.
  • Change the Phone Number section and input the new number purchased.
  • Save and Close.
  • Completed.