Kapalı

Write an App script for Google Sheet to connect with MySQL

I'm looking for a talented coder with excellent english communication skills to write five 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 result table, writing sheets, write names, script writing app, script sheets, write name old english, get english writing skills, get coder app, custom list excel, connect writing, best writing app, best custom writing, app sheets writing, app coder needed, an approach, writing sheet, google sheet script, written list excel, write app, update current app, mysql 4, line sheet, google speed, google sheet, google app sheets

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

Proje NO: #6499536

3 freelancer bu iş için ortalamada 122$ teklif veriyor

wbslivera

Hello, i am oracle certified professional java programmer have worked with both jdbc and Google APIs ready help thanks

in 5 gün içinde167$ USD
(55 Değerlendirme)
5.3
adilalisiddiqui

I can do your work with no error within given time period and effectively and 100% accuracy you will receive. I am a very hardworking person whose always ensures everything is being managed efficiently and effective Daha fazlası

in 7 gün içinde100$ USD
(1 Değerlendirme)
0.0
ioncristian

I am a Software Developer with over 5 years of experience. I have extensive experience with PHP, MySQL, HTML, CSS, jQuery and CodeIgniter. Moreover, I have extensive experience with Google Api Script, Google Spreads Daha fazlası

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