PHP/SQL Lookup - App Repair / Issue Resolution

進行中 投稿 5年前 着払い
進行中 着払い

We have an on-prem, small PHP webapp running on IIS (Server 2016) that looks up a telephone number and returns the result to our phone system. Our phone system routes incoming calls based on whether the CallerID number exists in a database, what type of company (client, vendor, unknown). When we migrated the application to Windows Server 2016, some functionality relating to the second database lookup stopped working.

Here is the workflow:

--> Incoming Call

--> Phone system (Switchvox) passes the callerID to the app which then looks up the number in our CRM database. This is done on the Switchvox side using an event trigger - [login to view URL]

--> If CallerID number is in the CRM database, the app sends the name of the caller, the type of caller (client, vendor, or unknown) back to the phone system along with the extension the call should be routed to. The phone system then handles the call from there.

--> If CallerID number is not in the CRM database, the app then queries a second database which contains company name, first/last name, telephone number and contact type - client/vendor. The apps then sends the name of the caller, company, CallerID and what extension the call should be routed to. The phone system then handles the call from there.

-->If the CallerID is not in either database, it then routes the call based on the area code of the incoming call.

As previously mentioned, the second database lookup is not working. If we go to the event trigger URL manually, we get a 500 error.

IIS PHP SQL

プロジェクトID: #17704325

プロジェクトについて

19個の提案 リモートプロジェクト アクティブ 5年前

19人のフリーランサーが、平均$529 で、この仕事に入札しています。

AzzkaNoor

It seems like an interesting project. I would like to discuss all the requirements with you, so I can mark the scope of this project. Please also note that final estimation will be provided once all the requirements wi もっと

$555 USD 10日以内
(62件のレビュー)
8.1
tangramua

Hi, my name is Oleksii. After reviewing your request, I am ready to fix your problem with IIS web application. I have 19 years’ experience in System Administration and Programming. I would like propose partnership もっと

$750 USD 10日以内
(192件のレビュー)
8.4
AleenaIlyas

Hi there, I have read the details I am experienced with IIS, PHP, SQL. I can help you with this job, Please come to chat so we can discuss this job.

$1250 USD 20日以内
(30件のレビュー)
7.3
technorizensoft

Hello , I have gone through your requirement and understand that,you are looking to develop a mobile app (Android & Ios ) In which app I have worked on many apps in various domain like App Repair / Issue Resolutio もっと

$400 USD 10日以内
(9件のレビュー)
6.3
KGeorgy

Hi, Thanks for your job posting. I've read your project description carefully. As a php & mysql expert, I have rich experience in this kind of project. I am sure I can handle this project as you expected. If you ha もっと

$555 USD 10日以内
(41件のレビュー)
6.1
lexul

Hello Ready to take this project from you. Please have all the details ready so that we can start working immediately. Such as remote desktop credentials. If you have any questions please open up a chat with us. もっと

$400 USD 3日以内
(17件のレビュー)
5.1
sadafshahid24

I am really good at problem solving and i believe after through investigation of the problem i can fix it. you can pay me only if you are satisfied with the fix. i have dealt with similar situations while working at a もっと

$250 USD 10日以内
(0件のレビュー)
0.0
cfiorillo

I will solve the 500 error calling the event trigger manually, then I will test the complete path with different scenario: - number in the first database (CRM); - number in the second database (Name system); - numbe もっと

$611 USD 10日以内
(0件のレビュー)
0.0