
VBA Script and VB ASP Web Code
- or -
Post a project like this541
£18/hr(approx. $24/hr)
- Posted:
- Proposals: 6
- Remote
- #4230567
- Awarded
Digital Web & AI Automation Agency | Expert in WordPress, Shopify & Custom Development



Full Stack Developer|.NET Core |C#| Flutter| iOS & Android | React JS| jQuery| Umbraco| Angular | Stripe| UI/UX
2556831227480450415912824956143111010744575
Description
Experience Level: Entry
Estimated project duration: 1 day or less
I am looking to integrate the opensource Android SMS gateway found here (https://github.com/capcom6/android-sms-gateway) in to a project. Full documentation can be found on their git and API details
I need someone who can write me a VB ASP procedure that will sit on an IIS server and:
1) can register a webhook with the SMS gateway software running on an Android phone somewhere on the local network.
2) receives SMS messages forwarded by the SMS gateway on that android phone, and store them in a table within an MS Access database.
3) Delete the webhook if we ever need to
Key points:
• All of the hardware involved will be on the local network.
• Intention is to register the webhook once, then the server will run permanently in the background.
• This is for an extension of existing project (moving from using 3rd party gateway to one on our own network)
• Some long text messages will be received and need to be handled as such (trimming to the 500 character field length)
• Errors need to be trapped and logged on the server as a log file.
• The lighter and simpler the code, the better.. I'm looking for robust 24/7 operation that processes SMS messages quickly.
• MS Access is currently a 2003 MDB but we're in the process of porting to a 2019 update, so something that works for both JET & ACE would be ideal.
Anticipated workflow:
{first time config} https://xxx/sms-start - this will prompt for a local host ID and the url of the Android SMS gateway, store this in a config on the web server, and will then use this information to register a web hook with the SMS Gateway server. Running this page and submitting it should overwrite the current config and prompt to create a new webhook on the SMS gateway.
{day to day operation} https://xxx/sms-receive - When the Android server receives an SMS, it will forward it on to this address as a POST message. The server will then store the data in the MS Access database
{if we ever stop using this server} https://xxx/sms-decommission - This page will use the information in the config file to delete the web-hook from the SMS gateway.
I need someone who can write me a VB ASP procedure that will sit on an IIS server and:
1) can register a webhook with the SMS gateway software running on an Android phone somewhere on the local network.
2) receives SMS messages forwarded by the SMS gateway on that android phone, and store them in a table within an MS Access database.
3) Delete the webhook if we ever need to
Key points:
• All of the hardware involved will be on the local network.
• Intention is to register the webhook once, then the server will run permanently in the background.
• This is for an extension of existing project (moving from using 3rd party gateway to one on our own network)
• Some long text messages will be received and need to be handled as such (trimming to the 500 character field length)
• Errors need to be trapped and logged on the server as a log file.
• The lighter and simpler the code, the better.. I'm looking for robust 24/7 operation that processes SMS messages quickly.
• MS Access is currently a 2003 MDB but we're in the process of porting to a 2019 update, so something that works for both JET & ACE would be ideal.
Anticipated workflow:
{first time config} https://xxx/sms-start - this will prompt for a local host ID and the url of the Android SMS gateway, store this in a config on the web server, and will then use this information to register a web hook with the SMS Gateway server. Running this page and submitting it should overwrite the current config and prompt to create a new webhook on the SMS gateway.
{day to day operation} https://xxx/sms-receive - When the Android server receives an SMS, it will forward it on to this address as a POST message. The server will then store the data in the MS Access database
{if we ever stop using this server} https://xxx/sms-decommission - This page will use the information in the config file to delete the web-hook from the SMS gateway.
Paul G.
99% (15)Projects Completed
14
Freelancers worked with
14
Projects awarded
27%
Last project
22 Jul 2024
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies