Thierry Posted July 11, 2016 Share Posted July 11, 2016 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 03If 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
MattiLindroth Posted July 12, 2016 Share Posted July 12, 2016 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: 2013122312402.) Or just remove the colon between hour and minute like this: 20131223 1240Both 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
Thierry Posted July 13, 2016 Share Posted July 13, 2016 Hello,it did work, thank you.I'll try to use the ISO format for the next time.Best regards. Link to comment
Mario Matković Posted April 11, 2018 Share Posted April 11, 2018 Greetings,I am experiencing the same problem and have tried the procedure above. But then I get a warning --> Error : Unable import file to WAsP Climate Analyst. No protocol could be generated for a file.If you could give me an advice, i would be grateful.Best regards. Link to comment
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now