Find Jobs
Hire Freelancers

From MySQL to Googlesheet

£20-250 GBP

Completed
Posted over 2 years ago

£20-250 GBP

Paid on delivery
This project is aimed at extracting data from MySQL database and exporting them to google sheet. You need to follow the steps of the project described below in order to complete it successfully. 1. You need to know a website (similar to 000webshost) where you can host a PHP/MySQL for free. The service should include remote access to the MySQL Database. If you cannot do this, please adjust your price accordingly. 2. You need to design a PHP/HTML page that allows users to insert data into MySQL Database Form. One example is given on this link. [login to view URL] The form should contain the following fields: 2.1. Date The date should show like below. The default date is today’s date. 2.2. COA Code – Description Please refer to [login to view URL] So this step requires Autocomplete Search Record From Database Using Bootstrap 4, PHP, MySQLi & Ajax The content of the autocomplete is Types: Variable with maximum 100 characters 4100000 - AAAAA 4100001 - BBBBB 4100002 - CCCCC 4200000 - DDDDD 4200001 - EEEEE 4200002 - FFFFF 4300000 - GGGG 2.3 Debit In Currency Rupiah Rp with 2 decimal number after the comma 2.4 Credit In Currency Rupiah Rp with 2 decimal number after the comma 3. If you refer back to point 1 and you cannot find a free PHP/MySQL solution, I want you to give a short description of what to do on configuring the MySQL database. 4. Please open a free Google account. Open a google sheet with the following headers: A1: Date B1: COA Code – Description C1: Debit D1: Credit 5. Please use the Castodia trial version to extract the MySQL data into the google sheet. [login to view URL] [login to view URL] I need this finished between 2-3 days or quicker if possible. Thank you
Project ID: 31472416

About the project

6 proposals
Remote project
Active 3 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
£0 GBP in 2 days
4.9 (95 reviews)
6.2
6.2
6 freelancers are bidding on average £143 GBP for this job
User Avatar
Hi, I am very familiar with Google sheet api & MySQL query, and I have read your description carefully. I have already done very similar projects using google sheet api, php, mysql. So I can do this job in a day and I can start work right now. Please discuss your project for quality result. Thanks.
£200 GBP in 1 day
5.0 (2 reviews)
3.3
3.3
User Avatar
Hi there! I hope you are doing well! I have reviewed your project requirements and I am very confident to do this job and give you a 100% result, on time and with constant updates and status of the project. I am a professional full stack engineer with 5+ years of experience. My experience and skills Designed, developed and customized backend and frontend systems, comprising of Appraisal Development systems, Content management systems, complaints management systems, hospital management system and foreign nationals’ system, Human resource management systems, ERPs as well as REST and SOAP APIs. My skills include PHP (CodeIgniter, Laravel and YII frameworks), JavaScript (jQuery, Angular, React,Node), Python, and Java (Spring boot) and solid skills in server management i.e ubuntu, apache2, nginx services. If you have any questions about my working processes, sample works and/or experience please don't hesitate to message. Kind Regards
£135 GBP in 1 day
4.6 (2 reviews)
1.2
1.2

About the client

Flag of INDONESIA
Jakarta, Indonesia
5.0
3
Payment method verified
Member since Dec 31, 2012

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.