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.
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.
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!