[AbigailScott771]

Website: ebox.cl

INSERTAR EN TBL_VisitAgenda (visit_agenda_id, company_rut, company_name, project_name, project_address, project_contact, project_email, project_phone, telephone_in charge, destination_id, laborator_id , scheduling_date, scheduling_start_time, scheduling_end_time, observaciones, operación_fecha, quote_id, acceptation_form_id) VALORES

INSERT INTO `TBL_AgendaVisita` (`id_agendamiento_visita`, `rut_empresa`, `razon_social`, `nombre_proyecto`, `direccion_proyecto`, `contacto_proyecto`, `email_proyecto`, `telefono_proyecto`, `telefono_encargado`, `id_destino`, `id_laboratorista`, `fecha_agendamiento`, `hora_ini_agendamiento`, `hora_fin_agendamiento`, `observaciones`, `fecha_operacion`, `id_cotizacion`, `id_form_aceptacion`) VALUES
(1, '76418334-7', 'SOCIEDAD DE INVERSIONES ESPERANZA L', 'OB001 LLANOS BLANCOS', 'RIO LOA 571', 'FRANCISCO LUNA', 'contacto@rfix.cl', 32165487, 98765432, 0, 8, '2020-07-31', '13:00:00', '15:30:00', 'INGRESO DE LH-111527-2020', '2020-07-31', 1, 1),
(4, '77066581-K', 'EMPRESA CONSTRUCTORA TRES EFE ', '6887 MIRADOR DE PENABLANCA III', 'LAS ACACIAS 730, PENABLANCA, VILLA ALEMANA', 'HECTOR CASTILLO', 'laboratorio@celab.cl', 966797805, 966797805, 0, 7, '2020-07-27', '13:00:00', '13:30:00', 'Sin observaciones', '2020-08-03', 1403, 1403),
(5, '76410566-4', 'CONSTRUCTORA CKRONOS SPA', '6841 CONSTRUCCION MURO DE CONTENCION LAS HERAS, VINA DEL MAR', 'CALLE LAS HERAS CON PJE GUSTAVO FRIKE, VINA DEL MAR', 'GERARDO FALK', 'laboratorio@celab.cl', 998858325, 998858325, 0, 7, '2020-07-25', '10:50:00', '13:00:00', 'Sin observaciones', '2020-08-03', 1359, 1359),
(6, '77066581-K', 'EMPRESA CONSTRUCTORA TRES EFE ', '6887 MIRADOR DE PENABLANCA III', 'LAS ACACIAS 730, PENABLANCA, VILLA ALEMANA', 'HECTOR CASTILLO', 'laboratorio@celab.cl', 966797805, 966797805, 0, 7, '2020-07-27', '13:50:00', '15:00:00', '0', '2020-08-03', 1403, 1403),
(7, '84541200-6', 'EMPRESA CONSTRUCTORA LAS LILAS', '6077 MEJ. PROTECCION COSTERA SECTOR EDWARDS- BARON Y CONST. PASEO CARRERA', 'MUELLE BARON S/N VALPARAISO', 'MATIAS ERENCHUN', 'laboratorio@celab.cl', 974964447, 974964447, 12, 0, '2020-07-29', '15:00:00', '15:52:00', '0', '2020-08-03', 658, 658),
(8, '6956902-1', 'AUGUSTO GUTIERREZ GUAJARDO    ', '5999 AMPLIACION SERVICIO DE AGUA POTABLE RURAL EL MOLINO LOS YUYOS', 'EL MOLINO S/N, QUILPUÉ', 'PATRICIO MUNOZ', 'laboratorio@celab.cl', 0, 0, 0, 7, '2020-07-29', '14:15:00', '15:30:00', '0', '2020-08-03', 586, 586),
(9, '76221254-4', 'EBAN INGENIERIA Y CONSTRUCCION', '6634 OBRAS CIVILES S/E AGUA SANTA', 'AV. LAS PALMAS S/N LOTE N° 2A, VIÑA DEL MAR', 'FRANCISCO ESPINOZA', 'laboratorio@celab.cl', 954014986, 954014986, 0, 8, '2020-07-28', '15:30:00', '17:10:00', '0', '2020-08-03', 1173, 1173),

DOWNLOAD FILE:

Hidden Content

You must register or login to view this content.

[Addka72424]

The link in this thread is dead. Please reply to the PM you were sent to get your thread moved back to the Databases section.

[Addka72424]

Hello,

The link on this thread has been updated as of this post.

[TipsyDipsy]

Could you let us know how many lines we can expect from this file?

[AbigailScott771]

Could you let us know how many lines we can expect from this file?

Yes dear, @TipsyDipsy, I just checked it's about 25k lines of the same table I mentioned above, and more information available in other tables as it is an .sql file, I hope that helps, good day!

[TipsyDipsy]

Could you let us know how many lines we can expect from this file?

Yes dear, @TipsyDipsy, I just checked it's about 25k lines of the same table I mentioned above, and more information available in other tables as it is an .sql file, I hope that helps, good day!

Thanks for letting us know, very helpful!