The CSV Conversions page converts Dreamflows CSV reports to a format digestible by third-party applications like Microsoft's Excel®.
Most of the resulting fields have the same name, function and format as described on the
CSV reports page.
However, the following application-specific notes apply:
Microsoft Excel
If you want to load a Dreamflows report into Microsoft Excel®, then:
- On the CSV Conversions page, select the report of your choice, then Microsoft Excel.
- Selecting All Fields outputs all fields listed on the
CSV reports page, plus a new field DateTime (described below).
Selecting Common Fields omits Confidence, Deviation, FlowSlope, WaterTemp, TempUnit and ColorCode.
- Save the result to a disk file with a ".csv" extension.
- The conversion process replaces certain field values (e.g. davg) with values digestible by Excel, and strips out certain entries entirely (e.g. river flows that are reported as High).
- Open the file in Excel. Since the file has a ".csv" extension, it should load without further ado.
- The new DateTime field is in U.S. date/time format, using a 24-hour clock, so 6/5/2006 22:15 is June 5, 2006 at 10:15 PM.
Microsoft Access
If you want to load a Dreamflows report into Microsoft Access, then:
- On the CSV Conversions page, select the report of your choice, then Microsoft Access.
- Selecting All Fields outputs all fields listed on the CSV reports page, plus a new field DateTime (described below).
Selecting Common Fields omits Confidence, Deviation, FlowSlope, WaterTemp, TempUnit and ColorCode.
- Save the result to a disk file with a ".txt" extension.
- The conversion process replaces certain field values (e.g. davg) with values digestible by Access, and strips out certain entries entirely (e.g. river flows that are reported as High).
- Launch Access and open or create your database, as appropriate.
Then Get External Data, Import, and choose your disk file.
- Since the file has a ".txt" extension, you will be asked to select conversion parameters.
Select file type as Text.
Confirm Delimited.
Confirm that Delimiter is Comma.
Check the First Row Contains Field Names box.
Set Text Qualifier to double quote (i.e. ").
- The new DateTime field is in U.S. date/time format, using a 24-hour clock, so 6/5/2006 22:15 is June 5, 2006 at 10:15 PM.