Database Fields

[wxthomson]

Can someone tell me the field numbers for the meteotemplate csv database?

[iatros]

Hello wxthomson

Fields are numbered by you:
log in as admin, then in Control Panel go to Database, Dataimport, txt/csv, Then you see a page like this one;

https://screenshots.firefox.com/LvfmKT7 ... dubler.com

You can set field numbers according to the columns of your csv import file, i.e.

Date/Time in one field: Field 0 (corresponding to column A in your csv)
Then e.g. Temp Field 1 (corr. to column B in your csv)
a.s.o
or

Date : Field 0
Time: Field 1
e.g. Temp: Field 2 a.s.o

HTH, Martin

[Luc]

Hi wxthomson,

The explanation of Martin is true for a general csv file with meteotemplate data. The fields depends on the source which made the csv file.

When you are referring to the meteotemplate backup csv files, then the fields are as follows:

Code: Select all

Column        DB field    Description
     0        DateTime    Date and Time
     1        T           Temperature
     2        Tmax        (max temp)
     3        Tmin        (min temp)
     4        H           Humidity
     5        D           (dewpoint)
     6        W           Wind speed
     7        G           Wind gust
     8        B           Wind Direction
     9        RR          Rain rate
    10        R           Cumulative daily precipitation
    11        P          Pressure
    12        S          Solar radiation
    13        A          (apparent temp)

See also my description how to import a Meteotemplate backup file in the Meteotemplate database.
How to import a backup of an alldata year file
http://meteotemplate.com/forum/viewtopi ... =183#p1101

Hope this helps

[wxthomson]

Thanks Luc

Just what i was looking for