Author Topic: exporting records with UTC time  (Read 495 times)

0 Members and 1 Guest are viewing this topic.

Offline sheldon

  • Senior Member
  • **
  • Posts: 59
    • Roma EUR Meteo
exporting records with UTC time
« on: December 16, 2017, 06:55:21 AM »
Hello forum!
I need to export record data from weatherlink (by browse->export records) with time in UTC format. Records are now with UTC+2 time. Can I do this ?
Thank you,
Andrea
My weather Station in Rome:
http://www.romaeurmeteo.it/

Offline johnd

  • Forecaster
  • *****
  • Posts: 2614
    • www.weatherstations.co.uk
Re: exporting records with UTC time
« Reply #1 on: December 16, 2017, 07:00:31 AM »
Hello forum!
I need to export record data from weatherlink (by browse->export records) with time in UTC format. Records are now with UTC+2 time. Can I do this ?

Sorry, no, not so far as I am aware. In the future you could set your console to UTC time or, alternatively, you'll need to adjust the time post-export eg in Excel with some sort of script.
Prodata Weather Systems
Prodata's dedicated Davis EnviroMonitor website
UK Davis Premier Dealer - All Davis stations, accessories and spares
Littleport, Ely, Cambs UK

Offline darkpenguin

  • Senior Member
  • **
  • Posts: 55
    • HoosierWeather
Re: exporting records with UTC time
« Reply #2 on: December 27, 2017, 09:32:41 AM »
Is this something you are still wanting to do?
Jeeps don't get stuck, they just stop to pose for pictures.

Offline darkpenguin

  • Senior Member
  • **
  • Posts: 55
    • HoosierWeather
Re: exporting records with UTC time
« Reply #3 on: December 30, 2017, 05:53:34 PM »
I started playing around with this yesterday, and now have a solution for this that works very well.

If you are still interested in doing this it will be rolled into wx2sql 0.1.3, which I should have ready in mid-late January.  I have a couple of other things to finish with that version before rolling it.  Here is a screenshot of the interface.

 [ You are not allowed to view attachments ]
Jeeps don't get stuck, they just stop to pose for pictures.

Offline darkpenguin

  • Senior Member
  • **
  • Posts: 55
    • HoosierWeather
Re: exporting records with UTC time
« Reply #4 on: January 18, 2018, 11:49:43 PM »
The new version of wx2sql is complete and available for download.  The new version includes a feature that allows you to read in a wlk file and export the observational data in to a csv file.  There are several configuration options that will allow you to customize the output file to your liking.  One of which is the ability to adjust the observation times to different timezones.

You can download the wx2sql application and documentation from www.hoosierweather.com/software
Jeeps don't get stuck, they just stop to pose for pictures.

Offline Marcel-EDDF

  • Member
  • *
  • Posts: 4
    • www.bosch-technik.de
Re: exporting records with UTC time
« Reply #5 on: February 03, 2018, 03:06:28 PM »
@darkpenguin

is there a chance for me to configure your great program to show C (for Europe)?

Best regards

Marcel

Offline darkpenguin

  • Senior Member
  • **
  • Posts: 55
    • HoosierWeather
Re: exporting records with UTC time
« Reply #6 on: February 03, 2018, 05:29:25 PM »
The next dev cycle is just starting.  I will look at adding measuring unit configuration for ya.
Jeeps don't get stuck, they just stop to pose for pictures.

 

anything