Kapalı

Write Google App script to sync data between mySql and Sheets

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.

Beceriler: Excel, Javascript, MySQL

Daha fazlasını görün: writing the result at table, writing sheets, write your name in old english, write names, script writing app, script sheets, names and numbers, how to write your name in old english, how to start writing, how to get english writing skills, get a coder app, custom list in excel, best writing app, best custom writing, app sheets writing, app coder needed, Google Sheet Script, mysql 5.1, written list into excel, update current app, sheets, mysql 4, how to proceed with, how to cancel, google speed

İşveren Hakkında:
( 6 değerlendirme ) Bangkok, Thailand

Proje NO: #6494710

2 freelancers are bidding on average $164 for this job

KeepTummypTummy

Hello, Thanks for giving me chance to bid on your task and taking a minute to read my profile brief.I have read this and i assured you 100% completion and best quality in reasoanble price. My expertise in web de Daha fazlası

in 3 gün içinde155$ USD
(3 Değerlendirme)
2.9
job4work

Hello, Hope all is well. Webminds Infotech is a Web Development Company having 9+ years of experience in developing [url removed, login to view] have total strength of 30+ techies+Designers with us and they are skilled in Web 2.0 PH Daha fazlası

in 3 gün içinde172$ USD
(1 Değerlendirme)
1.3
armanhakim999

My skills include Photoshop, Adobe illustrator and Dreamweaver. Logo design, brochures, websites and web design, mobile GUI, brand identity packages and marketing collateral (business cards, letterheads, package design Daha fazlası

in 3 gün içinde155$ USD
(0 Değerlendirme)
0.0