Differences

This shows you the differences between two versions of the page.

--- cli:franke:fip_3274_monitoraggio_impianto_fotovoltaico [2025/08/07 09:54]
r.fioretti
+++ cli:franke:fip_3274_monitoraggio_impianto_fotovoltaico [2025/08/08 15:47] (current)
r.fioretti [Tabelle]
@@ Line 1: / Line 1: @@
 ====== Progetto Impianto Fotovoltaico ======
-K493qu2TKU%V
+===== Tabelle =====
+{{ :cli:franke:sqltabelle.txt |}}
+<code sql>
+--GRUPPI
+INSERT INTO public.sensorsgrp VALUES (1, 'roof_building_n_3');
+INSERT INTO public.sensorsgrp VALUES (2, 'parking_area');
+--SENSORI
+INSERT INTO public.sensorsdev VALUES (276085, 'Inverter 15', 2);
+INSERT INTO public.sensorsdev VALUES (276083, 'Inverter 14', 2);
+INSERT INTO public.sensorsdev VALUES (276082, 'Inverter 13', 2);
+INSERT INTO public.sensorsdev VALUES (276081, 'Inverter 12', 2);
+INSERT INTO public.sensorsdev VALUES (276080, 'Inverter 11', 2);
+INSERT INTO public.sensorsdev VALUES (276079, 'Inverter 10', 2);
+INSERT INTO public.sensorsdev VALUES (276078, 'Inverter 9', 2);
+INSERT INTO public.sensorsdev VALUES (276077, 'Inverter 8', 2);
+INSERT INTO public.sensorsdev VALUES (276076, 'Inverter 7', 2);
+INSERT INTO public.sensorsdev VALUES (276075, 'Inverter 6', 2);
+INSERT INTO public.sensorsdev VALUES (276074, 'Inverter 5', 2);
+INSERT INTO public.sensorsdev VALUES (276073, 'Inverter 4', 2);
+INSERT INTO public.sensorsdev VALUES (276072, 'Inverter 3', 1);
+INSERT INTO public.sensorsdev VALUES (276071, 'Inverter 2', 1);
+INSERT INTO public.sensorsdev VALUES (276070, 'Inverter 1', 1);
+</code>
+===== SFTP =====
+**SFTP url:** ftp.panpwrws.com:22/Measurements
+**Utente**: franke
+**Password:** K493qu2TKU%V
+**MOUNT command:**
+<code sql>
+sshfs franke@ftp.panpwrws.com:/Measurements /code/sshfs -p 22
+</code>
-sshfs ftp.panpwrws.com:/Measurements /code/sshfs -p 22