Đang Thực Hiện

Write some Software & upload output data to MYSQL database

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.

Kỹ năng: MySQL, PHP, Kiến trúc phần mềm

Xem thêm: show multiple locations mysql database data google map, display mysql database data android, mysql database data matching, mysql database data xml feed, simple iphone app mysql database data, mysql database data collection, upload data mdb mysql database, update mysql database data email, transfer mysql database data wordpress, link mysql database form output, upload data mysql database, perl script write form data mysql database, copy mysql database data, fill mysql database data form, upload excel data mysql database

Về Bên Thuê:
( 71 nhận xét ) lebanon, United States

Mã Dự Án: #13462875

Đã trao cho:

rinsadsl

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

$421 USD trong 5 ngày
(842 Đánh Giá)
8.4

40 freelancer đang chào giá trung bình $475 cho công việc này

rajeshsonisl

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 Thêm

$416 USD trong 4 ngày
(777 Đánh Giá)
8.2
TenStar718

Hello. I have full experience with mysql database. I have developed many apps with backend. Backend is developed with mysql database. If you hire me, I will do my best to work on your project to make the excellent re Thêm

$736 USD trong 10 ngày
(177 Đánh Giá)
8.1
mituld

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

$463 USD trong 15 ngày
(354 Đánh Giá)
8.1
webbookstudio

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 Thêm

$480 USD trong 9 ngày
(70 Đánh Giá)
7.4
Shopify

Hello, Greetings from Shopify We have recently completed the similar project and would like to show you a live demo which is similar to your project . I would like to discuss your project in more details so during Thêm

$515 USD trong 10 ngày
(20 Đánh Giá)
6.9
mike199

Hi, my name is Mike, I’m based in Oxford, UK. Your project description sounds interesting to me and I do have skills & experience that are required to complete it to a high standard. I can show you some examples of my Thêm

$555 USD trong 10 ngày
(48 Đánh Giá)
6.9
prashushinde9

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 Thêm

$721 USD trong 15 ngày
(50 Đánh Giá)
6.9
gangabass

I'm expert in web automation with hundreds of completed projects and excellent reviews here that's why I'm sure you'll be impressed with my work. I can fully automate both your tasks in less than three days and all I Thêm

$355 USD trong 3 ngày
(287 Đánh Giá)
6.8
webdesign786

HI My Motion: "No Satisfaction, No Payment" We have expertise in Web Design & Development. Please check our client reviews to determine the quality of our work. Let’s discuss in detail and start now? I am c Thêm

$526 USD trong 5 ngày
(76 Đánh Giá)
6.6
asifchaudhry2015

Hi there, I am really interested to automate this manual work and save your time .I can finish within 3 days but I want to first see your [url removed, login to view]

$555 USD trong 10 ngày
(61 Đánh Giá)
6.3
caroldata

Hi, As you are looking to Write some Softwaree so I am glad to inform you that we are an Indian Based ISO Certified 9001 : 2008 registered Pvt. Ltd. Software Company working with 8+ years of Experienced Developer fa Thêm

$555 USD trong 10 ngày
(32 Đánh Giá)
5.9
websolutions008

Hi, This is angel from [url removed, login to view] We could build a website as mentioned in the project description Mockup could be provided on your approval, before awarding the project. We are a company located in India. Give Thêm

$555 USD trong 10 ngày
(72 Đánh Giá)
6.2
v2x5111

we offer graphics designing and website development services in feasible price which is for quality output. Our promises for website : 1. Eye catching design in PHOTOSHOP. 2. web design developed by latest technolog Thêm

$333 USD trong 10 ngày
(104 Đánh Giá)
6.2
seemasit

Hi , Greetings!!! Hope you are doing good… Thanks for the job posting on freelancer. I read the job description and as per your requirements you need an expert developer. I am professional developer and designer Thêm

$444 USD trong 10 ngày
(41 Đánh Giá)
5.8
bestit4u

Hello. I am interested in your job. My name is Shan Bin and I am a team manager. Our team is an excellent team with over 3 years of exeperiences in android, ios, web development. Also our team members have full ski Thêm

$555 USD trong 10 ngày
(13 Đánh Giá)
5.3
AlexNevsky

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 Thêm

$250 USD trong 3 ngày
(37 Đánh Giá)
5.2
RubyOnRail

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 Thêm

$555 USD trong 10 ngày
(7 Đánh Giá)
5.6
brendanmullan90

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 Thêm

$444 USD trong 3 ngày
(32 Đánh Giá)
5.0
Iamtuheedakram

Hey i can do your job in 2 days max. i am expert in automation and scrapping with over 3 years of work experience. and i have worked on almost all the dbs and files. i have used mysql, mssql, cassendra, oracle, mariadb Thêm

$611 USD trong 3 ngày
(16 Đánh Giá)
4.9
Beautistar

Dear, sir Please check my profile - 100% job completed and more than 60 positive feedbacks [url removed, login to view] Being an experienced designer/developer, i am quite confident to be the best Thêm

$555 USD trong 10 ngày
(14 Đánh Giá)
5.0