Jump to content

Unable to import wind data


Recommended Posts

Greetings,

i'm trying to import data with this format :


"20131223 12:40 6,852 177,6"


through a .txt file (i've also tried a csv).

The problem is WACA 3.1 created some sort of ghost column when importing.


He proposes :


"Timestamp" with none column number
"Unrecognized" column 1 sample :NULL
"Speed" column 02
"Direction" column 03


If I try to import i get :


"Could not refresh the report view because ...
file reading operation failed while performing file read operation in class cFileReadOperationCollection in method ReadFiles. because ...
failed to read a file because ...
the system reported that:
'Division by zero.'"


I'm lost here, my data seems well organized, could you please help me ?


Best regards.
Link to comment
Greetings Thierry,


This indeed a problematic type in current WaCA 3.1 build.
I was able to reproduce the problem you are experiencing. It seems the date time format is not recognized by WaCA.


I am going to include this date time format to the supported date time formats list for the next build, but in the meantime if you want you change the format in following ways to use your data in current available WaCA version:


1.) Either write the time stamp in one bundle like this: 201312231240
2.) Or just remove the colon between hour and minute like this: 20131223 1240


Both of the date time formats above are supported. You can achieve the latter one easily by a simple replace or remove operation in almost any text editor.

Also I recommend using ISO-8601- format (YYYY-MM-DD HH:mm:ss) whenever possible. It is unambiguous and mostly supported by any software.
Link to comment
  • 1 year later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...