Write some Software & upload output data to MYSQL database
$250-750 USD
Plačilo ob prevzemu
Hello,
Currently, we have two programs and both of them require manual work. (We have the source code of these two programs as well). The main goal is to automate the process that we do manually now. We would like our database to be updated daily automatically without manual work.
The first program we have automatically downloads (21) raw excel data files from this website, converts it to .sql files using the field names & field types that we need. We then manually take these (21) generated output .sql files and truncate the (21) corresponding tables in our database. We then re-upload these new (21) files manually. The excel files on this website are updated daily and we would like to update our database daily too using the newest data automatically. Truncating and re-uploading (21) tables takes time to do manually especially when it’s a daily process.
The 2nd program we have takes a single .txt file that’s on this website called “2017 YTD SR1A file“ that’s updated every Thursday of the week. We manually insert this raw .txt file into our program and it converts it into an .sql file with the field names/types that we need. We then truncate the “2017_SALES” table and replace it with the new output .sql file. After replcaing the table with the latest data, we run a MYSQL script to update the (21) county data tables with the latest “2017_SALES” data.
Goal: One program that runs automatically daily that downloads the data, creates the output .sql’s using our field names/types and updates the database tables and then run the script.
Requirements:
You must speak fluent English.
You must have past experience.
You must have skype/teamviewer so we can share screens and show you some more details.
You must complete this project within 3-5 days.
*We're seeking a LONG TERM database expert. A "Go to" guy for any db related tasks.
ID projekta: #13462875
Več o projektu
Dodeljeno:
Hello there I can automate both of those Semi Automated processes. I clearly got your point and I am ready to be your "Go to" guy for the database tasks. Looking forward to work with you. Thanks Rinsad
40 freelancerjev ponuja v povprečju za $475 na tem delu
Hello! I meet all your requirements and am available to get started right away. I shall need access to both programs. Are both programs setup on the same server / IP? With 98% to 99% completion rate, 900+ succ Več
Hi I work towards providing reliable, relevant and robust IT solutions at most competitive prices to my customers. I ensure 100% customer satisfaction so lets start Thanks
Hello, my name is Michael. I represent Ukrainian based IT-company Webbook Inc that provides services in the IT-sphere for international business. We were carefully reviewing the requirements of the job description, so Več
Hello, I want to discuss this project with you further, let me know the best suitable time for you to schedule the meeting, Feel free to message me at any time, i used to be online 14 hrs in a day on this website so p Več
Hello, It's a pleasure to let you know that I've Completed and Delivered similar project before. All I need to work on customization part if we can proceed towards more discussion. I have gone through your project Več
Hi there my name is Brendan and i am an expert in Web Development with over 9 years experience. First off, i am not a spam bidder that you see a lot of on Freelancer, people that auto bid without reading the projec Več
Hello, I have 5+ years experience with PHP, MYSQL and i can help with your tasks if 2 programms which you have is php scripts - "We have the source code of these two programs as well". No Magento core edit. No rest Več
I have 5+ years of experience in Web-Development and Product Management. Depending on the size of project, I have team of about 10 developers to work with - whom I personally guide and manage. My work history reflects Več
I am having more than 8 years of experience in IT industry.I have worked on .net(c#.net,vb.net,asp,asp.net,mvc) with sql server 2005/2008/2012/2014/2016 and oracle(pl/sql). I can provide you better solution by utili Več
Hello, I am ready to work with you . I know how to implement this auto update feature . Please contact me to discuss further. Thanks
Sounds like an interesting project. Skype/TeamViewer are fine but i would be look for 6/7 days for completion.
I CAN START WORK RIGHT NOW.I CAN START WORK RIGHT NOW.I CAN START WORK RIGHT NOW.I CAN START WORK RIGHT NOW.I CAN START WORK RIGHT NOW. -- I CAN START WORK RIGHT NOW.I CAN START WORK RIGHT NOW.I CAN START WORK RIGHT Več