#!/usr/bin/python
from dbfpy import dbf
## create empty DBF, set fields
db = dbf.Dbf('tempdata.dbf', new=True)
db.addField(('date','D'),('temp','N',3,1),)
## read date, temp from .dat file
openFile=open('1.dat', 'r')
for line in openFile:
cols = line.split()
if len(cols) == 3 and cols[1] == '00:00:00':
date = cols[0].split('.')
date = date[2] + date[1] + date[0]
try:
temp = float(cols[2])
except ValueError:
break
rec = db.newRecord()
rec['date']=date
rec['temp']=temp
rec.store()
db.close()
openFile.close()