Salve a tutti, Avrei bisogno di qualche suggerimento. Ho dei sensori installati in alcuni pozzi che ogni giorno inviano una mail con i dati in allegato. Sono 2 file, in uno si trova data, ora, pressione, temperatura, e conducibilità dell' acqua, ed in un altro data ora pressione e temperatura del sensore che si trova all esterno del pozzo. Volevo fare un applicazione che si scarica gli allegati, si prende i dati, li mette su un database e consentire la visualizzazione di grafici via web. Programmo in python sostanzialmente per raspberry e di competenze sulla programmazione web ne ho poche. Se qualcuno avesse suggerimenti e mi indicasse una via, in modo da non farmi andare a ficcare in un vicolo cieco gli sarei veramente grato. Volevo provare mongoDB come database e Django come framework, ma credo che per questo tipo di dati sia meglio un db sql.
Saluti AndreaData file for DataLogger. ============================================================================== COMPANY : COMP. STATUS: Do DATE : 01-04-2020 TIME : 06:02:03 FILENAME : T4796_VEI_T4796_202003310600_till_202004010500.MON CREATED BY : SWS Wallmount modem 35821635 HW 2 SW R2.1S ========================== BEGINNING OF DATA ="" [Logger settings] Instrument type =CTD-Diver=17 Status =Started =0 Serial number =..15-T4796 317. Instrument number = =0 Location =VEI_T4796 Sample period =M60 Sample method =T Number of channels =3 [Channel 1] Identification =PRESSURE Reference level =400.0 cmH2O Range =1750.0 cmH2O Master level =0.0 cmH2O Altitude =0 m [Channel 2] Identification =TEMPERATURE Reference level =-20.00 °C Range =100.00 °C [Channel 3] Identification =2:Spec.cond. Reference level =0.00 mS/cm Range =120.00 mS/cm [Series settings] Serial number =..19-T4796 317. Instrument number = Location =VEI_T4796 Sample period =00 01:00:00 0 Sample method =T Start date / time =00:00:06 31/03/20 End date / time =00:00:05 01/04/20 [Channel 1 from header] Identification =PRESSURE Reference level =400.0 cmH2O Range =1750.0 cmH2O Master level =0.0 cmH2O Altitude =400.0 m [Channel 2 from header] Identification =TEMPERATURE Reference level =-20.00 °C Range =100.00 °C [Channel 3 from header] Identification =2:Spec.cond. Reference level =0.00 mS/cm Range =120.00 mS/cm [Data] 24 2020/03/31 06:00:00.0 1406.2 26.56 2.86 2020/03/31 07:00:00.0 1406.5 26.56 2.68 2020/03/31 08:00:00.0 1406.8 26.57 2.40 2020/03/31 09:00:00.0 1407.1 26.59 2.70 2020/03/31 10:00:00.0 1407.3 26.55 2.38 2020/03/31 11:00:00.0 1407.2 26.56 2.24 2020/03/31 12:00:00.0 1406.7 26.54 2.58 2020/03/31 13:00:00.0 1406.7 26.57 2.96 2020/03/31 14:00:00.0 1406.4 26.57 2.92 2020/03/31 15:00:00.0 1406.2 26.58 2.84 2020/03/31 16:00:00.0 1406.4 26.57 2.57 2020/03/31 17:00:00.0 1406.2 26.56 2.34 2020/03/31 18:00:00.0 1406.5 26.56 2.55 2020/03/31 19:00:00.0 1407.0 26.56 2.53 2020/03/31 20:00:00.0 1407.0 26.58 2.32 2020/03/31 21:00:00.0 1407.2 26.58 2.86 2020/03/31 22:00:00.0 1407.3 26.57 2.66 2020/03/31 23:00:00.0 1407.1 26.57 2.52 2020/04/01 00:00:00.0 1408.1 26.56 2.21 2020/04/01 01:00:00.0 1415.4 26.56 2.91 2020/04/01 02:00:00.0 1420.0 26.59 2.84 2020/04/01 03:00:00.0 1418.4 26.54 2.60 2020/04/01 04:00:00.0 1415.0 26.56 2.57 2020/04/01 05:00:00.0 1412.8 26.59 2.79 END OF DATA FILE OF DATALOGGER FOR WINDOWSData file for DataLogger. ============================================================================== COMPANY : COMP. STATUS: Not appl. DATE : 01-04-2020 TIME : 06:02:03 FILENAME : 00192_Eijkelkamp_Giesbeek_202003310700_till_202004010601.MON CREATED BY : SWS Wallmount modem 35821635 HW 2 SW R2.1S ========================== BEGINNING OF DATA ="" [Logger settings] Instrument type =e+_2_Chn =52 Status =Started =0 Serial number =.B53-00192 0252. Instrument number =EAE#00000000192 =0 Location =Eijkelkamp Giesbeek Sample period =M60 Sample method =T Number of channels =2 [Channel 1] Identification =Pressure Reference level =400.0 cmH2O Range =750.0 cmH2O Master level =0.0 cmH2O Altitude =0.0 m Alarm Low =400.0 cmH2O Hysteresis Low =400.0 cmH2O Hysteresis High =1150.0 cmH2O Alarm High =1150.0 cmH2O [Channel 2] Identification =Temperature Reference level =-20.0 degC Range =100.0 degC Alarm Low =-20.0 degC Hysteresis Low =-20.0 degC Hysteresis High =80.0 degC Alarm High =80.0 degC [Series settings] Serial number =.B53-00192 0252. Instrument number =EAE#00000000192 Location =Eijkelkamp Giesbeek Sample period =00 01:00:00 0 Sample method =T Start date / time =31:00:07 31/03/20 End date / time =30:00:06 01/04/20 [Channel 1 from header] Identification =Pressure Reference level =400.0 cmH2O Range =750.0 cmH2O Master level =0.0 cmH2O Altitude =0.0 m [Channel 2 from header] Identification =Temperature Reference level =-20.0 degC Range =100.0 degC [Data] 24 2020/03/31 07:00:31.0 1036.0 7.4 2020/03/31 08:00:31.0 1036.6 9.1 2020/03/31 09:00:33.0 1037.1 14.1 2020/03/31 10:00:30.0 1037.3 19.5 2020/03/31 11:00:35.0 1037.1 20.3 2020/03/31 12:00:30.0 1036.6 24.1 2020/03/31 13:00:30.0 1036.3 24.4 2020/03/31 14:00:30.0 1035.8 23.6 2020/03/31 15:00:32.0 1035.7 22.9 2020/03/31 16:00:30.0 1035.7 21.1 2020/03/31 17:00:31.0 1035.7 19.0 2020/03/31 18:00:30.0 1035.8 17.4 2020/03/31 19:00:35.0 1036.3 15.0 2020/03/31 20:00:30.0 1036.4 13.4 2020/03/31 21:00:30.0 1036.6 12.2 2020/03/31 22:00:31.0 1036.3 11.2 2020/03/31 23:00:31.0 1036.5 9.9 2020/04/01 00:00:30.0 1036.8 8.2 2020/04/01 01:00:30.0 1035.9 6.5 2020/04/01 02:00:31.0 1035.5 5.6 2020/04/01 03:00:31.0 1035.5 5.4 2020/04/01 04:00:30.0 1035.1 5.3 2020/04/01 05:00:30.0 1035.4 5.3 2020/04/01 06:00:30.0 1035.7 5.2 END OF DATA FILE OF DATALOGGER FOR WINDOWS
_______________________________________________ Python mailing list Python@lists.python.it https://lists.python.it/mailman/listinfo/python
