Solution for CSV multiple line import and daily rainfall totals

  • 1
  • Idea
  • Updated 2 years ago
I have posted a solution that allows you to download the AcuRite data 
as a CSV file, once a day, or at any interval you want, that corrects 
the problem  with the date/time stamp inversion found in CSV files with 
more than one data record. The solution is an Access database file to 
hold the data and an Excel file that contains macros to import the CSV data, and report back original data and daily summaries for any date interval. The daily summary includes maximum, average, and minimum values, total daily rainfall, and vector averaged wind direction. You 
can download the files at 
http://imascientific.com/weather/weatherCSV2DB.zip. Enjoy!
Photo of Allan Fabrick

Allan Fabrick

  • 2 Posts
  • 0 Reply Likes

Posted 2 years ago

  • 1
Photo of AcuRite Alyssa

AcuRite Alyssa

  • 174 Posts
  • 9 Reply Likes

Dear Allan Fabrick,

Thank you for posting that information. Our temporary solution for now is as follows:


To make sure your data is sorted correctly, set your AcuRite Connect software to automatically download data every 12 minutes and select “append to a single file.”  Using these settings and keeping your AcuRite display plugged into your computer, with the computer on, will ensure the data file is sorted correctly. Our technology team is working on a permanent fix for this sorting issue.


When will the issue be resolved?
At this time, the best way to ensure your data is sorted correctly is to set your AcuRite Connect software to automatically download data every 12 minutes and select “append to a single file.” We don’t yet have a release date for the fix, but will make an announcement when we have more information.
 
What if you can’t leave the display plugged into the computer?
While people who have experienced the issue have found the easiest way to resolve the issue it to use 12 minute downloads, if you must download a large amount of data, you can reverse sort the affected column in Excel to properly order the data.

You can find more information on flipping columns of data in Excel here:
https://blogs.technet.microsoft.com/hub/2010/05/06/excelling-in-excel-how-to-flip-a-column-of-data/ 



Photo of AcuRite Jenny

AcuRite Jenny, Official Rep

  • 3449 Posts
  • 165 Reply Likes
Hello,

The AcuRite Connect software has been updated with a fix for the sorting issue you've experienced.  For more information please see, https://support.acurite.com/acurite/topics/acurite-connect-new-software-release-v1-2-1?utm_source=no...