Page 1 of 1
Database Fields
Posted: Thu Sep 28, 2017 12:15 am
by wxthomson
Can someone tell me the field numbers for the meteotemplate csv database?
Re: Database Fields
Posted: Thu Sep 28, 2017 6:09 am
by 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
Re: Database Fields
Posted: Thu Sep 28, 2017 12:42 pm
by 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
Re: Database Fields
Posted: Thu Sep 28, 2017 5:27 pm
by wxthomson
Thanks Luc
Just what i was looking for