JosephNewhall - Profile

Opt-In and Opt-Out Questions

Support November 20th, 2024 @ 4:41 pm

Thank you for your response,

Excellent I fully understand, thank you for fixing that.
Thank you for this clarification I will do so.
In our situation, we use this for direct, bulk general notification, and bulk marketing SMS campaigns to our customers that have opted in. Regardless of whether the SMS message was a direct message initiated by a salesperson, was a bulk general SMS notification, or was a bulk SMS marketing campaign, we want our ENTIRE sales department to be notified of ANY incoming SMS so it can be handled by whoever is available and doesn't get missed if someone is sick or not in the office. If you don't decide to add this functionality I fully understand and have prepared to work around this while continuing to use your plugin. I began implementing a group alert logic hook yesterday just in case, and I am almost done with it. I have also been requested to make the CRM relay the incoming SMS to our Sales email box so I already had to create the endpoint and logic hook for that function anyway.

I will install the new build and let you know how things go.

Thank you for all your help, I appreciate how responsive and helpful you have been.

Have a great day!

View Comment

Opt-In and Opt-Out Questions

Support November 19th, 2024 @ 5:14 pm

After adding some debug logging to the plugin PHP code, doing further debug testing, and inspecting the PHP and CRM logs yesterday, I found a few things that were causing issues.

In your "BVSMS\receiveSMS.php" you are searching each of the 3 module databases, Accounts, Contacts, and Leads for the incoming phone number so that you can use that to create the call log record properly. However Twilio returns the full number with the country code, +1 in our case, but we don't use the country code in our phone numbers, only our in-country area codes so it will never find the correct module and the Call log record will not load properly when you attempt to click on it hence the white screen.

To test I added the following code to the findNumberInCRM() function in the "BVSMS/functions.php" file to have it strip the country codes from the numbers before searching the modules.

if (str_start_with($number,&#039;+1&#039;)){
  $number = str_replace(&#039;+1&#039;,&#039;&#039;,$number);
}

The result was that it allowed the relations to be found and properly assigned to the call log and the call logs were able properly load when you clicked on them. As this is just an incomplete and temporary workaround, if you decide to address this issue you should consider checking to see if the number has the country code, if it has a country code and fails to locate the number in the module databases, strip out the country code, and query again using the phone number without a country code. You may also want to consider creating a custom module where you can log any incoming SMS number that you can't resolve back to a specific module. If you do this the plugin won't create a broken record in the Calls module that can't be viewed when it can't reconcile a number to a module. You may even want to consider moving ALL logging and viewing of SMS messages into a custom module to unify the user experience.

I noticed the following error in the CRM log after receiving an incoming SMS, [ERROR] Unable to load custom logic file: "custom/brainvire/Logichooks/bv_update_schedule_sms_logic.php", this logic hook is declared in the "custom/Extension/modules/Calls/Ext/LogicHooks/bv_logic.php". After checking the "custom/brainvire/Logichooks/" location for the "bv_update_schedule_sms_logic.php" I found that it didn't exist BUT the file "bv_schedule_sms_logic.php" does exist. After looking at the function and seeing that it will both add and update it seems that it may be possible that you simply renamed the file but hadn't updated the logic hook declaration before release. I tested changing the logic hook declaration to correspond with the current file name and the error went away, and it seems to work but you will have to tell me if the scenario I am assuming is really the case or if I am truly missing the "bv_update_schedule_sms_logic.php" file.

With the temporary workaround changes I have done, I am now able to receive the incoming webhook requests from Twilio and I can now properly see the incoming calls logged in the Calls module. I will download and install the latest version to test the opt-out features you have implemented. I have created a CRM endpoint that will act as a middleman to temporarily handle the formatting of the incoming SMS numbers and then forward the request to your endpoint, this way I can continue to update your plugin easily and still retain the incoming SMS functionality until they are addressed in your end.

Also, please let me know if you are considering creating a way to configure global/group/role-based notifications for incoming SMS. Until then I will try to implement that functionality with my middleman CRM endpoint.

I will let you know how the new update works out,

Thank you again for all your time and help I really appreciate it.

View Comment

Opt-In and Opt-Out Questions

Support November 18th, 2024 @ 3:50 pm

I have created my own web API endpoint for Twilio, I configured Twilio's Incoming Message webhook to use that URL., then I tested it by replying to the SMS I sent my phone via the CRM, and Twilio sent their response to my test endpoint and I successfully logged it so I know that Twilio is working. I suspect there may be a problem with your plugin endpoint or something else so I will check to see if there are any errors in the CRM or PHP log files this morning, test a few other things, and let you know.

To answer your other questions: 1. I am using a paid number on Twilio and they have approved the campaign and opt-in /opt-out methods that we submitted to them. 2. When I attempt to open the webhook URL in my browser it just returns a blank page. This probably doesn't help much but I inspected it with the Dev View of my Chrome browser to see if there were any errors in the console, but there weren't any. Also looking at the response HTML all it had had was an empty HTML Header tag and an empty Body tag with the following attributes "data-new-gr-c-s-check-loaded="14.1207.0" and data-gr-ext-installed=""

Thanks again for your help, I will let you know what else I find.

View Comment

Opt-In and Opt-Out Questions

Support November 16th, 2024 @ 4:57 pm

Ok more information, I logged in as the admin user and I can see the notifications. However, there are a few issues:

When I click on them, just like when I click on them in the Calls area it takes me to a blank screen.
Because I am the only one who would ever log in as admin AND I do not use that account as my primary account, no one else can see any incoming messages for any questions that may be asked in response to the outgoing SMS message.

There needs to be a way to do at LEAST 1 of the following if not all 3 of the following: - Enable the incoming SMS alerts for ALL users. - Enable the incoming SMS alerts for a specific Role that can be assigned to specific Users. - Enable the incoming SMS alerts for Specific Users directly.

The webhook for Twilio is still not working so I am creating a simple logging test webhook to use as a testing endpoint for Twilio so I can see if Twilio is even sending me the request or if there is something else needed in the Twilio setup that has changed since you created your integration.

I will inform you of anything I discover regarding my Twilio webhook troubleshooting. However, I am reaching a point where I may have to choose to create and use my own endpoint to handle the opt-out functionality, incoming SMS notifications, and call logging until these things are addressed in a future update. Unfortunately, there is a good chance that by that time I may be instructed by our management team to abandon this SMS integration and create our own internal SMS integration for SuiteCRM so that we can move forward with our marketing and sales plans. I hope it doesn't come to that as I have invested a great deal of time both on and off the clock on this integration with our CRM so anything you can do to help me get this working I GREATLY appreciate it.

Thank you for all your help.

View Comment

Opt-In and Opt-Out Questions

Support November 15th, 2024 @ 10:25 pm

One more thing, even though they showed up in the Calls area there was no CRM system notification, does your software provide a system notification when an incoming text comes in?

View Comment

Opt-In and Opt-Out Questions

Support November 15th, 2024 @ 10:24 pm

Quick update, I went and researched the Twilio API and created a basic HTTP request in Postman to test. It is a POST action to my "https://suitecrmURL/index.php?entryPoint=receiveSMS" endpoint (http protocol also works the same), I added the following fields to my form-data, From, To, and Body. These messages are now showing in the CRM Calls area however when you click on them they just pull up a blank screen with no data at all. I don't know if you are trying to match incoming SMS numbers to phone numbers assigned to accounts, contacts, or leads or if there is any extra form data that is expected that I am not sending in my test HTTP Request. Please advise, thank you.

View Comment

Opt-In and Opt-Out Questions

Support November 15th, 2024 @ 9:49 pm

Thank you for the information on the opt-out numbers, I look forward to seeing your front-end changes for the SMS opt-out features. Regarding my Twilio integration, yes, I have entered my CRM's webhook URL for the incoming messages section of my Twilio account. I have also attempted to switch between HTTP and HTTPS protocol for the URL with neither working. Is there any way I can send a test to this endpoint using Postman? If you could give me the information on what the "receiveSMS" entry point is expecting for an HTTP request I could attempt to test it in a more controlled environment. Until then I will go look at the Twilio API and see if I can see what they send and maybe try to build a test request in Postman using that information.

Thank you for all your help.

View Comment

Opt-In and Opt-Out Questions

Support November 12th, 2024 @ 9:41 pm

Ok, I have uninstalled my current version, I then downloaded the one from the store again, installed it, rebuilt angular files, and then did a quick rebuild and repair. I have added my webhook endpoint path to my Twilio messaging configuration. I am able to send SMS to my phone so at least base functions are still working after the update. However, I have a few questions, 1. Where does your plugin set the opt-out for a specific phone number?

Where can I manually mark/unmark a phone number as opt-out? I have looked around since I installed the update but I don't see where to mark/unmark a phone number as being opted out. The only thing I see is where I can mark/unmark an account, contact, or lead email address as opt-out but nothing specific to phone numbers.
If someone replies to an SMS where is that supposed to show up in the CRM? I tested to see what happens if someone replies to the SMS message they received, so I sent myself an SMS and then replied "Testing 1234". I expected to get a notification in SuiteCRM but I didn't see anything indicating the CRM received any response from Twilio. I even checked the Calls area, since you log the outgoing SMS there, thinking I might see the incoming SMS, but there is nothing there.

View Comment

Opt-In and Opt-Out Questions

Support November 6th, 2024 @ 9:47 pm

I apologize for the delay, I did not see this response till today. I will download the new version and test it out. And give you feedback.

Thank you.

View Comment

Email Template is not updating on save.

Support October 9th, 2024 @ 3:40 pm

I ended up uninstalling and removing the current package, downloading the package AGAIN, I installed the newly downloaded package, I ran a "Quick Repair & Rebuild", I ran a "yarn cache clean", and then ran the "yarn run build-dev", tested again and it is now working.

Thank you for your help.

View Comment

Email Template is not updating on save.

Support October 8th, 2024 @ 8:49 pm

I downloaded the latest package from the store, I uninstalled the current package, installed the new package, ran the yarn build, and ran the "Quick Rebuild and Repair" in SuiteCRM however now when I create a new template it doesn't show up at all in my bulk template lists. I am going to attempt to uninstall and reinstall again but this is a pretty straight forward process so I don't think that is going to change the result.

View Comment

New install not showing text icon

Support October 4th, 2024 @ 10:56 pm

You can close this issue as paul8 is my boss and I have resolved this particular issue and am working on new ones.

Thank you.

View Comment

New Install - Schedule SMS module unable to save.

Support October 4th, 2024 @ 10:21 pm

Never mind, I checked the file locations again and found that the record-view.store.ts file was in the wrong location, I copied it to the correct location, ran the yarn command, tested again, and it successfully saved and I received my scheduled SMS message.

I can move on to my testing of the Bulk send and then decide if I can recommend this app to my boss. I very much appreciate your fast responses and solution.

Thank you.

View Comment

New Install - Schedule SMS module unable to save.

Support October 4th, 2024 @ 10:03 pm

I copied the files into the appropriate locations and ran the yarn command however it is still doing the same thing.

View Comment

New Install - Schedule SMS module unable to save.

Support October 3rd, 2024 @ 2:44 pm

Let me know if you need anything else from me. SuiteCRM Debug logs, PHP logs, etc.