Closed

Auto Convert Scheduled e-mailed .CSV file into MYSQL Database

I receive a scheduled e-mail every morning with a .CSV attachment (auto exported from an age-old programme from the 80's). The info is timesheets, project data like contact detail, P/O details, payments, invoices, etc.

I want to e-mail it into something that can "read and convert" that data and upload it into a MYSQL database, which I can use to set-up a dashboard in ZOHO Analytics. I am really tired of converting the spreadsheet every morning to a useful format.

I need suggestions to:

1. Set-up an inbox to receive the .csv file

2. Manually of automatically convert it and host in the cloud, MYSQL database.

3. Help me to set-up some initial reports from the MYSQL data in Zoho Analytics.

Jaco

Skills: PHP, MySQL, Database Programming, Data Analytics

See more: upload data csv file mysql, uploading csv file mysql php script, perl read csv file mysql select, php script upload csv file mysql, import outlook csv file mysql, csv file mysql php large size data fastly, php transfer csv file mysql table, sned csv file mysql, send csv file mysql, upload csv file mysql database php code, upload csv file mysql using php, perl csv file mysql database, perl script convert csv file mysql, php script uploading csv file mysql database, data csv file mysql database using aspnet, php script insert csv file mysql database, upload csv file mysql database java, import csv file mysql database using codeigniter, php script import csv file mysql database

About the Employer:
( 8 reviews ) Saratoga Spring, United States

Project ID: #25437270

20 freelancers are bidding on average $214 for this job

Itblast

Hello There . Yes sure i will Do the task for you . ✅ Zoho One Administrator ✅ Zoho Certified Professional ✅ Deluge & API Integration Expert I offer my best professional experience of 4+ years to solve uniq More

$200 USD in 3 days
(73 Reviews)
6.7
baoo

Hi, I am ready to build a software to auto convert your spreadsheet to MYSQL DB. I can assure 100% satisfaction guarantee. Please have a look on my profile to see my past work and review. Looking forward to your fru More

$1500 USD in 10 days
(61 Reviews)
6.5
schoudhary1553

Hello, I can make Auto Convert Scheduled e-mailed .CSV file into MYSQL Database I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already comp More

$180 USD in 3 days
(87 Reviews)
6.7
novepi

Hi there, The requirements look quite clear and straightforward to implement. I presume those emails are coming from a certain email address. I can create a php script which constantly watches your inbox via IMAP. Whe More

$150 USD in 3 days
(45 Reviews)
6.1
RusselExpert

Hello. Thanks for your post. As a senior programmer, i can help you to save excel file into mysql database. Plz contact me. Thanks.

$140 USD in 7 days
(21 Reviews)
5.5
vitalykuzin

PHP&MySQL expert here! I've been working on PHP for 5 years if we include this year. [login to view URL] [login to view URL] [login to view URL] [login to view URL] More

$140 USD in 7 days
(13 Reviews)
5.1
mtdevil369

Hi, Greetings! Started my [login to view URL] my salam. ✅checked your project details : Auto Convert Scheduled e-mailed .CSV file into MYSQL Database ✅Completed Time : 24 hours or your requriment deadline . I would like to wo More

$130 USD in 2 days
(41 Reviews)
5.2
RococoConsultant

Hello !!! (Expert in AWS ) I am specializing in Wordpress, Wordpress themes, Blog, Woo-commerce HTML/CSS, UI/[login to view URL] refer to my portfolio of work on Freelancer I am highly proficient in the following Skill: Wordpres More

$220 USD in 4 days
(18 Reviews)
4.4
superbpartner

Hi,dear! I am quite interested in your project - 'Auto Convert Scheduled e-mailed .CSV file into MYSQL Database'. :) I've already done this kind of project before. I am a skillful software developer who has rich experi More

$155 USD in 1 day
(12 Reviews)
4.9
writingapp

Hi. I am ready to write your project. I have written many automation database projects. Will complete within 2 days

$65 USD in 2 days
(13 Reviews)
4.4
grabovikmaran

how are you? I can help you to modify your for this site: . I have extensive experience to Create custom PrestaShop Theme, Complete PrestaShop development, Installation and configuration, debugging, mainten More

$140 USD in 7 days
(13 Reviews)
4.1
omartini

Hello, there. I have carefully read your job description with great interests. and I have good experiences in web developing for about 10 years. Please visit my past references here. -[login to view URL] -http://sho More

$140 USD in 7 days
(4 Reviews)
3.8
croll12

I would be happy to complete this for you. I have been programming in Python for over 5 years now and will be able to parse the data as requested and output to a database. Please let me know if you would like to dis More

$200 USD in 2 days
(4 Reviews)
2.7
JamesP93

Hi, I've just the skillset to solve this problem. I have extensive experience in preparing data and automating data flows. I've spent a good amount of time specifically handling data from CSV and Excel files using Pyt More

$100 USD in 5 days
(0 Reviews)
0.0
rohithcrash7

Python has been my primary language at work for a while. I was working as a Data Engineer earlier. Feel free to initiate a chat to discuss Few tasks I have worked on with Python - Implemented and Maintained data wareh More

$250 USD in 5 days
(0 Reviews)
0.0
shaniijoiiya789

hello sir i am well educated have done Master in software engineering and run my small software house i have 5 year of experience in this field i can do everything you want in very low price. kindly give me a chance i More

$30 USD in 35 days
(0 Reviews)
0.0
yashkanrish

Your project is pretty simple. We just need to connect to your email through python fetch the csv and upload it to the mysql server. We will host python code using AWS and using AWS lambda we can set it up to run after More

$30 USD in 2 days
(0 Reviews)
0.0
$156 USD in 3 days
(0 Reviews)
0.0
Ishaan1991

I can do it better

$156 USD in 3 days
(0 Reviews)
0.0
AVRUUX

With Zoho, you don't need to make any script for MYSQL DB and even external hosting to save .csv files or DB. I have a solution for that. I am Zoho Authorized partner and just finished Zoho Analytics-CRM integration pr More

$200 USD in 7 days
(0 Reviews)
0.0