Find Jobs
Hire Freelancers

Write Google App script to sync data between mySql and Sheets -- 2

$30-250 USD

Fechado
Publicado há mais de 9 anos

$30-250 USD

Pago na entrega
I'm looking for a talented coder with excellent english communication skills to write several custom functions in Google App Script. All functions are to be written to have speed in mind (ie. only one call to mysql DB via JDBC per function), and in line with best practices (ie. batch operations). In your reply, please tell me your approach, and how many JDBC calls are needed per function. Custom Functions to be written for Google Sheets: MySQL => Sheets 1. ImportMySQLtable(cell of the first column header in Sheet) into Google Sheet - check if current active sheet is empty, if not give a warning prompt that data will be overwritten, with option to cancel or proceed - retrieve table data from mySQL - confirm name of table, numbers of columns and rows from mysql, prompt to proceed or cancel - specific error messages in pop-up (ie. table does not exist, passwd invalid, etc.) - column headers/attributes in the first row (first attribute in A1 per default), write data in active sheet (first record starts in B1 per default) - show simple real progress bar while writing data is in progress (ie. row /total rows = increments of 10% progress), plus 'Operation complete' Prompt at end. 2. UpdateSheetFromMySQL(cell of first header column in Sheet) - retrieve table from MySQL - check if column headers in active sheet match exactly the attributes of the mysql table. Empty cells in header are ignored. If not give warning prompt, list column attributes (column # and name) from MySQL table in a prompt which don't match, and abort function upon ok. - specific error messages in pop-up (ie. table does not exist, passwd invalid, etc.) - confirm name of MySQL table, total numbers of columns and total rows from mysql, prompt to proceed or cancel - For each cell value that doesn't match, give a prompt to ask if user wants to overwrite this value, yes, yes to all, no, or abort. In the prompt, show cell reference, old and new value. - 'Operation complete' Prompt at end, with no. of total cells updated. 3. CollectMySQLtableinfo(cell where to start writing result) - Get all tables names and attributes and no. rows (plus specific error messages upon exceptions) - check if target sheet area is empty; give warning prompt with message that data will be overwritten, abort or proceed - for each table: give table name, no. of attributes, no. of rows give data type of each attribute (first column in sheet is first attribute, second etc.) give name of each attribute - empty row between each table output - 'Operation complete' Prompt at end, with no. of tables collected. Sheets => MySQL 4. UpdateMySQLFromSheet(cell of first header column in Sheet) - retrieve table from MySQL - specific error messages in pop-up (ie. table does not exist, passwd invalid, etc.) - check if column headers in active sheet match exactly the attributes of the mysql table. Empty cells in header are ignored. If not give warning prompt, list column attributes (column # and name) from MySQL table in a prompt which don't match, and abort function upon ok. - confirm name of MySQL table target, total numbers of columns and total rows from Sheet, prompt to proceed or cancel - For each cell value that doesn't match, give a prompt to ask if user wants to overwrite this value, yes, yes to all, no, or abort. In the prompt, show cell reference, old value, new value, no. of remaining cells to be updated. - update table in MySQL (2nd JDBC call) - 'Operation complete' Prompt at end, with no. of total cells updated. 5. CreateTableMySQL(A1:F10) - A1:A10 will be the column attributes - values in B1:B10 will determine the data type, ie. varchar, integer - table name will be name of the sheet that contains A1:F10 - Create MySQL table with B1:F10 as the data input - 'Operation complete' Prompt at end, with no. of total rows created.
ID do Projeto: 6499453

Sobre o projeto

3 propostas
Projeto remoto
Ativo há 10 anos

Quer ganhar algum dinheiro?

Benefícios de ofertar no Freelancer

Defina seu orçamento e seu prazo
Seja pago pelo seu trabalho
Descreva sua proposta
É grátis para se inscrever e fazer ofertas em trabalhos
3 freelancers estão ofertando em média $190 USD for esse trabalho
Avatar do Usuário
I am Data Entry, MS Word and MS Excel Expert. i am very much professional in this work i am pretty sure that you cant find a best person for this job like me so i am ready to work on your project with low rate and high quality.
$147 USD em 3 dias
5,0 (11 avaliações)
3,2
3,2
Avatar do Usuário
i will help you now with your problem
$222 USD em 2 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
Hello again, I am a Software Developer with over 5 years of experience. I have extensive experience with PHP, MySQL, HTML, CSS, jQuery and CodeIgniter. As I told you before I have extensive experience with Google Spreadsheets and Google API Script. Thank you!
$200 USD em 3 dias
0,0 (0 avaliações)
0,0
0,0

Sobre o cliente

Bandeira do(a) THAILAND
Bangkok, Thailand
5,0
6
Método de pagamento verificado
Membro desde abr. 5, 2014

Verificação do Cliente

Obrigado! Te enviamos um link por e-mail para que você possa reivindicar seu crédito gratuito.
Algo deu errado ao enviar seu e-mail. Por favor, tente novamente.
Usuários Registrados Total de Trabalhos Publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Carregando pré-visualização
Permissão concedida para Geolocalização.
Sua sessão expirou e você foi desconectado. Por favor, faça login novamente.