Comrades Good afternoon I understand that the content is not very clear but if what I want is that each Station with its weewx software is programmed to insert the data in the same table of the Mysql database, that is, the query I am not very clear about data union I do not know if you can help me but what I want is in each station to program the same table of the database of the other stations and to be able to identify them,
It is a single database, all the stations are programmed to insert the data in the same database. Only that each station has a table, what I want is for all of them to insert the data in a table with a different identifier so that when they are consulted, it is easier I don't know if there is a way to Modify the weewx code to insert the identifier of each station and thus give the same table to all of them. Where do I do it? El martes, 21 de septiembre de 2021 a las 12:06:54 UTC-5, [email protected] escribió: > I don't understand the requirement completely either, but I have some > thoughts. Rather than modifying weewx, perhaps you could use a union query > across all the mysql tables to aggregate your data. You would probably want > some station ID in the table to keep the records straight. I would also > consider using a tool like Grafana to visualize the aggregated data outside > of Weewx. > > On Tue, Sep 21, 2021 at 9:24 AM Tom Keffer <[email protected]> wrote: > >> Hello, Jose. >> >> It is not very clear what you are trying to do. Will the data be >> collected by WeeWX? Or, something else? >> >> WeeWX is not designed to handle many different stations. First, there is >> no way to identify each station (although that would not be hard to add). >> The bigger problem is that weewxd blocks, waiting for data from a station. >> It does not have a "select" statement that allows it to wait for data from >> any one of 20 different stations. It can wait for only one station. >> >> Finally, the reporting engine does not have a way of saying that you want >> to display data from only a particular station. >> >> Hope that helps. >> >> -tk >> >> On Tue, Sep 21, 2021 at 8:41 AM jose riaño <[email protected]> wrote: >> >>> Good morning friends and colleagues I want to ask you What happens is >>> that I have more than 20 stations online in a department of Colombia I >>> would like to know how I could use the same Mysql table to store the data >>> of all the stations by modifying the central code I want to find a >>> identifier for each station and that all the data is inserted in the same >>> table of all the stations, how I have it now, it is a My sql table per >>> station, it makes me more complex for the queries and the web software that >>> I have. >>> >>> In summary, what I want is to insert the data of those 20 stations in >>> the same mysql table. Thank you very much >>> >>> -- >>> You received this message because you are subscribed to the Google >>> Groups "weewx-user" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to [email protected]. >>> To view this discussion on the web visit >>> https://groups.google.com/d/msgid/weewx-user/27051542-3e2c-44a9-9274-577fa88870b5n%40googlegroups.com >>> >>> <https://groups.google.com/d/msgid/weewx-user/27051542-3e2c-44a9-9274-577fa88870b5n%40googlegroups.com?utm_medium=email&utm_source=footer> >>> . >>> >> -- >> You received this message because you are subscribed to the Google Groups >> "weewx-user" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected]. >> > To view this discussion on the web visit >> https://groups.google.com/d/msgid/weewx-user/CAPq0zEDuZiCTyEkLiz-yHEDrh_aC2fO1pDU0wr5YBJ6XGZwwRg%40mail.gmail.com >> >> <https://groups.google.com/d/msgid/weewx-user/CAPq0zEDuZiCTyEkLiz-yHEDrh_aC2fO1pDU0wr5YBJ6XGZwwRg%40mail.gmail.com?utm_medium=email&utm_source=footer> >> . >> > > > -- > Peter Quinn > (415)794-2264 <(415)%20794-2264> > -- You received this message because you are subscribed to the Google Groups "weewx-user" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/fe5b8d79-95e8-4c1b-a0f2-34e8973d7a89n%40googlegroups.com.
