Experienced VBA coder needed in urgent job
- or -
Post a project like this3524
£100(approx. $124)
- Posted:
- Proposals: 3
- Remote
- #540452
- Awarded
Description
Experience Level: Intermediate
General information for the business: COnnect to a database and extract data from it
Kind of development: Customization of existing program
Description of requirements/functionality: Hi,
We have a script made up in Microsoft Access and need it to be modified but the functionality of the script will remain exactly the same. We are a very tight deadline so if it’s not possible ASAP, please do not apply for job.
The issue is this, the current Microsoft Access program (checks postcodes for all orders and generates labels) connects to our website(previously Interspire shopping cart but now BigCommerce) database and extracts data from it and our program then checks the integrity of the addresses customers have added as there delivery address. Due to us having to move websites, we do not have the ability now to remote access to our database anymore therefore we cannot use the same method as previous. I have spoken to a web developer who can do part of the task but he advised the he is not able to do the VBA part of the code as he is not experienced enough. His exact wording was:
" If you can get a developer to modify your current script in the way of making HTTP requests to the server (the app which I can build) and send/parse data in XML, CSV, JSON or another format then we can get the solution.
To work with BigCommerce API it is required to host an application on a separate server. So, here is what I can do:
- setup and configure server
- create a PHP application that:
a) parses requests from MS Access Script
b) sends responses in required format to the Script
c) Requests and Saves data from/to BigCommerce store"
Our script needs altering so it can 'talk' to the file the programmer makes, which will result in the same functionality that the program does now. The information from the website can only be extracted via API which is no good to us presently, but if our programmer manipulates this data into something the program can use, this is what we need you to do. The functionality of the program is already there, but need to feed the data to Microsoft access via a possible solution the programmer will make. Anyone who want further clarification, please message me your mobile and I can show you exactly what I mean.
Regards
Nick
OS requirements: Windows
Extra notes: Hi,
We have a script made up in Microsoft Access and need it to be modified but the functionality of the script will remain exactly the same. We are a very tight deadline so if it’s not possible ASAP, please do not apply for job.
The issue is this, the current Microsoft Access program (checks postcodes for all orders and generates labels) connects to our website(previously Interspire shopping cart but now BigCommerce) database and extracts data from it and our program then checks the integrity of the addresses customers have added as there delivery address. Due to us having to move websites, we do not have the ability now to remote access to our database anymore therefore we cannot use the same method as previous. I have spoken to a web developer who can do part of the task but he advised the he is not able to do the VBA part of the code as he is not experienced enough. His exact wording was:
" If you can get a developer to modify your current script in the way of making HTTP requests to the server (the app which I can build) and send/parse data in XML, CSV, JSON or another format then we can get the solution.
To work with BigCommerce API it is required to host an application on a separate server. So, here is what I can do:
- setup and configure server
- create a PHP application that:
a) parses requests from MS Access Script
b) sends responses in required format to the Script
c) Requests and Saves data from/to BigCommerce store"
Our script needs altering so it can 'talk' to the file the programmer makes, which will result in the same functionality that the program does now. The information from the website can only be extracted via API which is no good to us presently, but if our programmer manipulates this data into something the program can use, this is what we need you to do. The functionality of the program is already there, but need to feed the data to Microsoft access via a possible solution the programmer will make. Anyone who want further clarification, please message me your mobile and I can show you exactly what I mean.
Regards
Nick
Kind of development: Customization of existing program
Description of requirements/functionality: Hi,
We have a script made up in Microsoft Access and need it to be modified but the functionality of the script will remain exactly the same. We are a very tight deadline so if it’s not possible ASAP, please do not apply for job.
The issue is this, the current Microsoft Access program (checks postcodes for all orders and generates labels) connects to our website(previously Interspire shopping cart but now BigCommerce) database and extracts data from it and our program then checks the integrity of the addresses customers have added as there delivery address. Due to us having to move websites, we do not have the ability now to remote access to our database anymore therefore we cannot use the same method as previous. I have spoken to a web developer who can do part of the task but he advised the he is not able to do the VBA part of the code as he is not experienced enough. His exact wording was:
" If you can get a developer to modify your current script in the way of making HTTP requests to the server (the app which I can build) and send/parse data in XML, CSV, JSON or another format then we can get the solution.
To work with BigCommerce API it is required to host an application on a separate server. So, here is what I can do:
- setup and configure server
- create a PHP application that:
a) parses requests from MS Access Script
b) sends responses in required format to the Script
c) Requests and Saves data from/to BigCommerce store"
Our script needs altering so it can 'talk' to the file the programmer makes, which will result in the same functionality that the program does now. The information from the website can only be extracted via API which is no good to us presently, but if our programmer manipulates this data into something the program can use, this is what we need you to do. The functionality of the program is already there, but need to feed the data to Microsoft access via a possible solution the programmer will make. Anyone who want further clarification, please message me your mobile and I can show you exactly what I mean.
Regards
Nick
OS requirements: Windows
Extra notes: Hi,
We have a script made up in Microsoft Access and need it to be modified but the functionality of the script will remain exactly the same. We are a very tight deadline so if it’s not possible ASAP, please do not apply for job.
The issue is this, the current Microsoft Access program (checks postcodes for all orders and generates labels) connects to our website(previously Interspire shopping cart but now BigCommerce) database and extracts data from it and our program then checks the integrity of the addresses customers have added as there delivery address. Due to us having to move websites, we do not have the ability now to remote access to our database anymore therefore we cannot use the same method as previous. I have spoken to a web developer who can do part of the task but he advised the he is not able to do the VBA part of the code as he is not experienced enough. His exact wording was:
" If you can get a developer to modify your current script in the way of making HTTP requests to the server (the app which I can build) and send/parse data in XML, CSV, JSON or another format then we can get the solution.
To work with BigCommerce API it is required to host an application on a separate server. So, here is what I can do:
- setup and configure server
- create a PHP application that:
a) parses requests from MS Access Script
b) sends responses in required format to the Script
c) Requests and Saves data from/to BigCommerce store"
Our script needs altering so it can 'talk' to the file the programmer makes, which will result in the same functionality that the program does now. The information from the website can only be extracted via API which is no good to us presently, but if our programmer manipulates this data into something the program can use, this is what we need you to do. The functionality of the program is already there, but need to feed the data to Microsoft access via a possible solution the programmer will make. Anyone who want further clarification, please message me your mobile and I can show you exactly what I mean.
Regards
Nick
Nick S.
99% (74)Projects Completed
82
Freelancers worked with
53
Projects awarded
27%
Last project
5 Feb 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