Bonjour,
J'ai en ma possession un fichier texte contenant des données de capteurs de températures.
Je dois les insérer dans une base de données MySQL, mais je n'ai pas trouvé de solutions sur Internet...
Voici un extrait du fichier :
{"name":"foo","columns":["time","sequence_number","val","temperature"],"points":[[1427959015783,210001,21,11],[1427959009506,200001,21,11]]}{"name":"foo.bar","columns":["time","sequence_number","value"],"points":[[1427965465000,1,5],[1427965462000,1,3]]}{"name":"foo.temp.temp1","columns":["time","sequence_number","value"],"points":[[1427980734000,1,200],[1427980599000,1,200],[1427980464000,1,200],[1427980328000,1,200],[1427980193000,1,200],[1427980057000,1,200],[1427979922000,1,199],[1427979787000,1,199],[1427979651000,1,199],[1427979516000,1,199],[1427979381000,1,199],[1427979245000,1,199],[1427979110000,1,199],[1427978975000,1,199],[1427978839000,1,199],[1427978704000,1,199],[1427978569000,1,199],[1427978433000,1,199],[1427978298000,1,199],[1427978162000,1,199],[1427978027000,1,199],[1427977892000,1,199],[1427977756000,1,199],[1427977621000,1,199],[1427977486000,1,199],[1427977350000,1,199],[1427977215000,1,199],[1427977080000,1,199],[1427976944000,1,199],[1427976809000,1,199],[1427976674000,1,199],[1427976538000,1,199],[1427976403000,1,199],[1427976267000,1,198],[1427976132000,1,198],[1427975997000,1,199],[1427975861000,1,198],[1427975726000,1,198],[1427975591000,1,198],[1427975455000,1,198],[1427975320000,1,198],[1427975185000,1,198],[1427975049000,1,198],[1427974914000,1,198],[1427974779000,1,198],[1427974643000,1,198],[1427974508000,1,198],[1427974373000,1,198],[1427974237000,1,198],[1427974102000,1,198],[1427973967000,1,198],[1427973831000,1,198],[1427973696000,1,198],[1427973560000,1,198],[1427973425000,1,198],[1427973290000,1,198],[1427973154000,1,198],[1427973019000,1,197],[1427972884000,1,197],[1427972748000,1,197],[1427972613000,1,197],[1427972478000,1,197],[1427972342000,1,197],[1427972207000,1,197],[1427972072000,1,197],[1427971936000,1,197],[1427971801000,1,197],[1427971666000,1,197],[1427971530000,1,197],[1427971395000,1,196],[1427971260000,1,197],[1427971124000,1,196],[1427970989000,1,196],[1427970854000,1,196],[1427970718000,1,196],[1427970583000,1,196],[1427970448000,1,196],[1427970312000,1,196],[1427970177000,1,196],[1427970042000,1,196],[1427969906000,1,196],[1427969636000,1,196],[1427969500000,1,196],[1427969230000,1,196],[1427969094000,1,196],[1427968959000,1,196],[1427968824000,1,196],[1427968688000,1,196],[1427968553000,1,196],[1427968418000,1,196],[1427968282000,1,196],[1427968147000,1,196],[1427968012000,1,196],[1427967876000,1,196],[1427967741000,1,196],[1427967606000,1,196],[1427967470000,1,196],[1427967335000,1,196],[1427967200000,1,196],[1427967065000,1,195],[1427966929000,1,195],[1427966794000,1,195],[1427966659000,1,195],[1427966523000,1,195],[1427966388000,1,195],[1427966253000,1,194],[1427966117000,1,194],[1427965982000,1,194],[1427965847000,1,194],[1427965711000,1,194],[1427965576000,1,194],[1427965441000,1,194],[1427965305000,1,194],[1427965035000,1,194],[1427964899000,1,193],[1427964764000,1,193],[1427964629000,1,192],[1427964494000,1,191],[1427964358000,1,191],[1427964223000,1,190],[1427964088000,1,190],[1427963952000,1,189],[1427963817000,1,188],[1427963682000,1,186],[1427963546000,1,182],[1427963411000,1,179],[1427963276000,1,179],[1427963140000,1,181],[1427963005000,1,180],[1427962870000,1,181],[1427962734000,1,184],[1427962599000,1,187],[1427962464000,1,198],[1427962328000,1,198],[1427962193000,1,198],[1427962058000,1,198],[1427961922000,1,198],[1427961787000,1,198],[1427961651000,1,198],[1427961516000,1,198],[1427961381000,1,198],[1427961245000,1,198],[1427961110000,1,198],[1427960975000,1,198],[1427960839000,1,198],[1427960704000,1,198],[1427960569000,1,198],[1427960433000,1,198],[1427960298000,1,198],[1427960162000,1,198],[1427960027000,1,198],[1427959892000,1,198],[1427959756000,1,198],[1427959621000,1,198],[1427959486000,1,198],[1427959350000,1,198],[1427959215000,1,198],[1427959080000,1,198],[1427958944000,1,198],[1427958809000,1,198],[1427958673000,1,198],[1427958538000,1,199],[1427958403000,1,198],
Je le met en fichier joint également.
Si une personne ayant déjà réalisé ce type d'opération pouvait m'indiquer la marche à suivre, je lui en serai reconnaissant..
Merci par avance !
Cdt,
DamienC