Author Topic: Re establishing logfile in correct format  (Read 3710 times)

Offline gabba

  • Financial Supporter
  • Hero Member
  • *****
  • Posts: 2153
  • Country: 00
  • Karma: 213
  • Gender: Male
    • Hutt Weather
  • Station: Vantage Vue, Weather Display, Webcam.
Re establishing logfile in correct format
« on: May 19, 2013, 10:23:17 PM »
Hi

I've had to make a large number of corrections to my Feb log file. It was far easier to do it in excel, than via WD

So now I have a file in excel that I can save in a whole heap of formats. The closest format I can find to the logfile format is  to save the excel file as .csv, then find and replace in a text editor, the commas, with a space.

When I did that the log file isn't quite right - that is the format is still different to the other months log files. I've noticed some of the fields are seperated by two spaces, and others by just one.

So, two questions:
(a) does anyone know the file format for the log file?
(b) has anyone else pulled data from excel before and how did you convert it?

Thanks in advance


Cheers, Andrew

Vantage Vue, Weather Display, Webcam.
www.huttweather.co.nz

Maungaraki, Lower Hutt, New Zealand

Offline gabba

  • Financial Supporter
  • Hero Member
  • *****
  • Posts: 2153
  • Country: 00
  • Karma: 213
  • Gender: Male
    • Hutt Weather
  • Station: Vantage Vue, Weather Display, Webcam.
Re: Re establishing logfile in correct format
« Reply #1 on: May 20, 2013, 10:58:26 PM »
Solved this one thanks to the guys at Weather Watch (Actually Weather Display - thanks once again!)

Basically the file can be edited in excel, and then saved as a space delimited file. The option preserves the formatting so you need to make sure you space out all the columns enough so there is at least one space between each field. If there are multiple spaces between fields it isn't an issue.

Cheers

Offline TokWW

  • Grim
  • Global Moderator
  • Hero Member
  • *****
  • Posts: 1579
  • Country: 00
  • Karma: 196
  • Gender: Male
  • Another Engineer
    • Tokoroa North Weather
Re: Re establishing logfile in correct format
« Reply #2 on: June 07, 2013, 10:23:26 AM »
There is a trick to the first column as well for the editing while in Excel - as because the first single digit days of the month use only one column - one letter space, you get a data shift you don't want for everything else across the page - just for the first 9 days.  It is essential to make that shift so the columns line up.  When saving, it doesn't matter as two spaces still get treated as one space by WD when it is read back into the program.


Share via twitter

xx
Correct my rain recording for the day

Started by Azzura

9 Replies
5313 Views
Last post July 16, 2012, 10:37:32 PM
by Weather Display
clip
To Correct Month & Year Rainfall in WD

Started by JennyLeez

1 Replies
4540 Views
Last post July 27, 2013, 06:07:43 AM
by Weather Display
clip
'How To' Correct Year Rainfall in Cumulus

Started by JennyLeez

0 Replies
4898 Views
Last post August 06, 2013, 12:48:20 PM
by JennyLeez
xx
Clientraw.txt Format

Started by JennyLeez

25 Replies
19035 Views
Last post May 24, 2012, 08:01:46 AM
by Weather Display
xx
Date Format

Started by Wolfie33

3 Replies
3766 Views
Last post February 06, 2018, 08:41:06 AM
by Wolfie33