Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /*********************************************************************************************************
- NAME:
- PURPOSE: Extracción y consolidado de los archivos subidos en un fichero
- REVISIONS:
- Ver Date Author Description
- --------- ---------------- ------------------ ---------------------------------------------------
- 1.0 15/08/2020 Marvin Navarro 1. Script que inserta registros en MySQL
- coment: Se debe habilitar la api drive , www.botdevp.com
- **********************************************************************************************************/
- var conn = Jdbc.getConnection('jdbc:mysql://hostnamedatabase:port/name_database','user','pass');
- var stmt = conn.createStatement();
- var ss = SpreadsheetApp.getActive();
- var sheet = ss.getSheetByName('NameHojadeCalculo');
- var data = sheet.getDataRange().getValues();
- var rangeData = sheet.getDataRange();
- var lastRow = rangeData.getLastRow();
- do{
- var i = i + 1;
- var result = result + i;
- if (data=='') //Si hay registros nulos, la funcion finaliza
- {
- return
- }
- else {
- var sql = "INSERT INTO name_table(campo1,campo2,campo3,campo4,campo5,campo6,campo7,campoN) VALUES ('" + data[i][0] + "','" + data[i][1] + "','" + data[i][2] + "','" + data[i][3] + "','" + data[i][4] + "','" + data[i][5] + "','" + data[i][6] + "','" + data[i][7] + "')";
- var count = stmt.executeUpdate(sql,1)
- sheet.deleteRow(1); //se ejecuta el delete de cada registro ingresado
- }
- } while (i < 400); //permite procesar solo 400 insert como maximo
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement