Project

General

Profile

Feature #7504

Raingauge levels: import raw CSV from Auro Orchard automatic rain gauge

Added by Philippe May over 5 years ago. Updated over 5 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Target version:
-
Start date:
28/01/2019
Due date:
% Done:

100%

Close

Description

Davis Instruments rain collector model 7857 gives CSV (example attached).

Gisaf could import it directly, bypassing the need for creating Excel file like Charlies'.

20190101_00_00.csv View (71.6 KB) Philippe May, 28/01/2019 17:28

Screenshot (33).png View (215 KB) Pavneet Kaur, 04/02/2019 11:08

4873

Associated revisions

Revision 6c7a6f41 (diff)
Added by Philippe May over 5 years ago

Fixes #7504: import raingauge levels also from a CSV file

History

#1 Updated by Philippe May over 5 years ago

  • Status changed from New to Resolved
  • % Done changed from 0 to 100

#2 Updated by Philippe May over 5 years ago

  • Assignee set to Pavneet Kaur

I think it's OK importing CSV files from Auro Orchard's rain gauge.

So, Pavneet, we'd need to:

- add Auro Orchard in the rain gauge layer (would be, eg, id=15), and delete it from the weather station layer
- in the basket, put the CSV files given by Christian in a folder named with the id (eg. "15"), and import them.

I can explain face to face, if you need a drink ;)

#3 Updated by Pavneet Kaur over 5 years ago

  • Status changed from Resolved to In Progress

1. Auro orchard deleted from weather station
2. uploaded csv's in the basket (under folder with id 15), can import after you give a heads up (you were going to delete the previous data to import again)

#4 Updated by Pavneet Kaur over 5 years ago

4873

error while importing the csv, relating to date and time format, attaching the screen shot of the error

#5 Updated by Philippe May over 5 years ago

We've seen that there's a bit of confusion with the data given by Christian.

So, we assume that these files:
- start with 7 lines of headers to be skipped
- the date is formatted like "dd/mm/yyyy" (with slashes, not hyphens)

#6 Updated by Philippe May over 5 years ago

  • Status changed from In Progress to Resolved

#7 Updated by Philippe May over 5 years ago

  • Status changed from Resolved to Closed

Also available in: Atom PDF