Category Archives: Office – Transfer Data

Hydrolynx 5096, Office - Transfer Data

HydroLynx 5096 – Transfer Data

  1. Locate appropriate SA1, DAT and SA2 files on laptop and transfer to network drive (e.g., Q:\StationDocs\199 – Fillmore Sanitation\Records\2015)
  2. Open Hydstra Explorer (HYEXPLORE) and select from the menu tree: Programs by Function > Hydstra/TS – Time Series > Hydstra Data Management > HYDMWB – Data Managers Workbench
  3. Press the Open folder icon or select File > Open
  4. In the Open Time Series Site dialog box that opens, enter the site number in general format (e.g., 199) in the Site Specifier field and press the Lookup Site button
  5. Select the specific site (e.g., 199A) that appears in the dialog box and then press OKprogram_hydstra_5096import1
  6. In the Open Time Series Sites dialog box confirm that the proper site is shown, then press OK
  7. Single-click the site icon that has an A at the end (e.g., 199A A) and select File > Copy
  8. Select File > Import Data.
  9. It is likely Hydstra will still “remember” importing ML1 data from previous site visits; therefore, you need to change the data type. Press Back until Logger is highlighted and select HYD from dropdown
  10. Press Next to highlight Variant and select RAININCH from the dropdown
  11. Press Next to highlight Filename and Browse to proper DAT file on network driveprogram_hydstra_5096import2
  12. Press Finish and a new B file is created on the Data Manger’s Workbench
  13. Drag the C file to the B file and release
  14. In the Merge Files dialog box, select the Resolve Overlaps: Split blocks if necessary, preserving C File data radio button, verify the Delete Source box is checked and press OK
  15. Double-click the B file to open the work file
  16. In the dialog box that opens, double-click the row 11.00 Rainfall (inches) – High-Resolution
  17. Open the block of newly imported data by selecting the block and pressing the Text tab
  18. Highlight all data points and  press the Quality edit buttonprogram_hysdstra_ml1_qualedit
  19. In the Quality Edit dialog box that opens select 20 Coarser dataset used to fill gap in dataset (ie. ALERT data) from the New Quality dropdown and press OK
  20. Fill data gaps and continue processing data as described in Hydrological Services ML-1 – Transfer Data
Office - Transfer Data, Stream, WaterLOG H-350XL

WaterLOG H-350XL/H-500XL – Transfer Data

Stream data downloaded from equipment in the field should ideally be transferred immediately from temporary media (e.g., USB key) to a folder on the laptop, and should be stored in the SiteMonthDayYear format (e.g., 800a080615).

    1. Locate appropriate file on laptop and transfer to station folder on network drive (e.g., Q:\STATIONS\TL\800A\2015\Misc)
    2. Open Hydstra and select from the menu tree: Programs by Function > Hydstra/TS – Time Series > Hydstra Data Management > HYDMWB – Data Managers Workbench.
    3. Press the Open folder icon or select File > Open
    4. In the Open Time Series Sites dialog box that opens, enter the site number in general format (e.g., 800) and click the Lookup Site button
    5. Select the specific site (e.g., 800A) that appears in the dialog box and then press OK
    6. Press OK in the Open Time Series dialog box
    7. Single-click the site icon that has an A at the end (e.g., 800A A) and the select File > Copy
    8. In the Select Work File dialog box that opens, Select B as the New DataSource and then press OK; a new file icon is placed on the workbench (e.g., 800A B)
    9. Select File > Import Data and navigate to appropriate file on the network drive, as described in step 1, and then press Open
    10. Press Finish in the Import Data dialog box and close the event log that appears in Hydstra Explorer; a new file icon is placed on the workbench (e.g., 800A C)
    11. Drag the C file to the B file and release
    12. In the dialog box, select the Resolve Overlaps: Split blocks if necessary, preserving the C file radio button and press OK
    13. Double-click the B file to open the Work File dialog box (the end date of the 232.00 variable should be modified to match the date and time of the site visit)program_hydstra_maxgap
    14. Double-click variable 232.00, which will open the High-Resolution data set
    15. Most of the time, Gap<MaxGap (ignored) will be displayed between the previous data set and the data set most recently imported
    16. To eliminate this gap, select the block of data immediately below this status and select Split
    17. In the Split Block dialog box, add five minutes to Split Time (e.g., 10:50:00_07/20/2015 becomes 10:55:00_07/20/2015) and press OK; this will create an additional block of time
    18. Select the new block and the one immediately above it (this should be the one that has the Gap<MaxGap (ignored) status) by shift-clicking both
    19. Select Fill Gaps and from the dialog box that opens, select the Extend Backwards (add a new point to the start of the second block) radio button and 1 Good Unedited Data from the Inserted Quality dropdown; press OK
    20. A new block is created which spans the existing blocks; both the new block and the block below now display Yes in the Modified column
    21. Close the dialog box and press Yes to save your changes and then close the Work File dialog box
    22. Finally, drag the B file to the A file and select the Merge (preserve B File data if duplicates) radio button, making sure the Delete B File option is checked
    23. Press OK and close event log that appears in Hydstra Explorer
Office - Transfer Data, SonTek FlowTracker, Stream

SonTek FlowTracker – Transfer Data

  1. Connect unit to computer using 5-pin cable and serial connection (with or without USB adapter)
  2. Press yellow power button to turn unit on
  3. Open SonTek FlowTracker program
  4. Press Connect to a FlowTracker
  5. On Connect to serial port dialog box, select proper COM port and confirm Baud rate: 9600
  6. Press Connect
  7. Press Recorder; dialog box opens
  8. Select files for download (e.g., 800A0806.15)
  9. Press Browse to navigate to destination folder (e.g., Q:\STATIONS\TL\800a\2015\Misc)
  10. Press Download
  11. Confirm .WAD files transferred to proper location
  12. To erase .WAD files, select all appropriate (e.g., 800A0806.15) and press Format
  13. When completed, press yellow power button to turn unit off and disconnect unit from computer
  14. In Windows Explorer, navigate to folder (e.g., Q:\STATIONS\TL\800a\2015\Misc), select file (e.g., 800A0806.15.WAD) and rename using SiteMonthDayYear format (e.g., 800a080615.WAD)
  15. In FlowTracker, press Open a FlowTracker file, navigate to newly named .WAD file and press Open
  16. Press Printer button, print first page and attach to front sheet from site visit
JBS AquaCalc Pro+, Office - Transfer Data, Stream

JBS AquaCalc Pro+ – Transfer Data

  1. Connect AquaCalc Pro+ to compter via USB cable and press On/Off
  2. Press 3 (Connections) and verify that Connection is set to USB
  3. Open AquaCalc DataLink3
  4. Press Download
  5. In Download Section Measurements dialogue box, select measurement to be downloaded (e.g., 776A080515)
  6. Under Choose a download location, press Choose and navigate to appropriate folder location (e.g., Q:\STATIONS\TL\776a\2015\Misc)
  7. Press Download Sections
  8. Verify transfer of .CSV file to appropriate file location (e.g., 776A080515_T__LIDDELL_T__LIDDELL_080515_0709.csv)
  9. To remove discharge measurement from Aquacalc Pro+, re-select section and press Delete Sections
  10. To rename tranferred file so that it follows the SiteMonthDayYear naming convention (e.g., 776a080515), right-click CSV file and select Rename
  11. Press Analyzer; MS Excel document opens
  12. Select Import and Edit Here tab, press Import AquaCalc Pro Output File, navigate to the newly transferred file and press Open
  13. Select Summary for Printing (5×8) tab, print first page and attach to front sheet from site visit

equipment_transfer_aquacalc

 

Hydrological Services ML1, Office - Transfer Data, Rainfall

Hydrological Services ML-1 – Transfer Data

Rainfall data downloaded from equipment in the field should ideally be transferred immediately from temporary media (e.g., USB key) to a folder on the laptop, and should be stored in the SiteMonthDayYear format (e.g., 066e072015).

Rainfall data downloaded via Bluetooth will not have site visit start/stop bucket tips to demarcate beginning and ending of data blocks, so those will have to be created for each site visit.

Data Downloaded via Cable

    1. Locate appropriate file on laptop and transfer to network drive (e.g., Q:\RAINSTNS\TL\199.15)
    2. Open Hydstra Explorer (HYEXPLORE) and select from the menu tree: Programs by Function > Hydstra/TS – Time Series > Hydstra Data Management > HYDMWB – Data Managers Workbench
    3. Press the Open folder icon or select File > Open
    4. In the Open Time Series Site dialog box that opens, enter the site number in general format (e.g., 199) in the Site Specifier field and press the Lookup Site button
    5. Select the specific site (e.g., 199A) that appears in the dialog box and then press OKprogram_hydstra_ml1_labeled1
    6. In the Open Time Series Sites dialog box confirm that the proper site is shown, then press OK
    7. Single-click the site icon that has an A at the end (e.g., 199A A) and select File > Copy
    8. Select B as the New DataSource in the dialog box and then press OK; a new file icon is placed on the workbench (e.g., 199A B)
    9. Select File > Import Data and navigate to appropriate file on the network drive, as described in step 1, and then press Open
    10. Press Finish and close the event log that appears in HYEXPOLRE; a new file icon is placed on the workbench (e.g., 199A C) in HYDMWBprogram_hydstra_ml1_labeled2
    11. Drag the C file to the B file and release
    12. In the Merge Files dialog box, select the Resolve Overlaps: Split blocks if necessary, preserving C File data radio button, verify the Delete Source box is checked and press OK
    13. Double-click the B file to open the work file
    14. In the dialog box that opens, double-click the row 11.00 Rainfall (inches) – High-Resolution
    15. To fill the data gap between previous visits, highlight most recent block and the one above it, then press Fill Gaps
      program_hydstra_ml1_labeled3
    16. In the Fill Gaps dialog box, select the Extend Backwards radio button and select 2 Good quality edited data from the Inserted Quality dropdown and press OK (the beginning date of the most recent block should be adjusted backwards)
    17. Press the Text tab to view data in the newly modified block
    18. program_hysdstra_ml1_qualeditSelect one or more records with Qual values of 151 and press the Quality edit button
    19. In the Quality Edit dialog box that opens select 2 Good quality edited data from the New Quality dropdown and press OK
    20. The last record in the block should have a Qual of 1, which indicates the bucket tip at the start of your field visit, as described hereprogram_hysdstra_ml1_dataedit
    21. Select this last record and press the Data edit button
    22. In the Edit Data Point dialog box that opens, change the Value to 0.00 and the Quality to 2 Good quality edited data, the press OKprogram_hydstra_ml1_labeled4
    23. Press Yes in the warning dialog box that opens
    24. Record the rainfall total in the yellow field book
    25. Select File > Close or press the X in the top right corner of the High-Resolution dialog box
    26. In the HYDMWB dialog box that opens, press Yes to save the file
    27. Select File > Close or press the X in the top right corner of the Work File dialog box
    28. Drag the B file to the A file and release
    29. In the Merge Files dialog box that opens, select the Merge (preserve B File data if duplicates) radio button, verify the Delete Source box is checked and press OK
    30. Close the event log that appears in HYEXPOLRE
    31. In the Hydstra Data Manager’s Workbench, verify that one of the site icons is highlighted and select File > Close Site

Data Downloaded via Bluetooth

  1. Follow steps 1-14, as described above
  2. Note that there are no bucket tips to indicate the beginning or end of the current or previous site visits, only the tips generated by rainfall between visits
  3. To create a block of data with appropriate starting and ending times, select the current block, then select Blocks > Add New Point
  4. In the Edit Data Point dialog box, enter a Time (ending in :00 seconds) that matches the ending time and date of the previous block, enter a Value of 0.000 and select 2 Good quality edited data from the Quality dropdown, then press OKprogram_hydstra_ml1_datagap_labeled1
  5. Repeat step 4 for the end of the current block, consistent with the end of your remote “site visit”
  6. Your new block of data should now stretch from the end of the previous site visit to the end of the current site visit (which will be used as the starting point for the next block of data for the subsequent site visit)program_hydstra_ml1_datagap_labeled2
  7. Press the Text tab to view data in the newly modified block
  8. program_hysdstra_ml1_qualeditSelect one or more records with Qual values of 151 and press the Quality edit button
  9. In the Quality Edit dialog box that opens select 2 Good quality edited data from the New Quality dropdown and press OK
  10. The last record in the block should have a Qual of 1, which indicates the bucket tip at the start of your field visit, as described here
  11. program_hysdstra_ml1_dataeditSelect this last record and press the Data edit button
  12. In the Edit Data Point dialog box that opens, change the Value to 0.000 and the Quality to 2 Good quality edited data, the press OK
  13. Press Yes in the warning dialog box that opens
  14. Record the rainfall total in the yellow field book
  15. Select File > Close or press the X in the top right corner of the High-Resolution dialog box
  16. In the HYDMWB dialog box that opens, press Yes to save the file
  17. Select File > Close or press the X in the top right corner of the Work File dialog box
  18. Drag the B file to the A file and release
  19. In the Merge Files dialog box that opens, select the Merge (preserve B File data if duplicates) radio button, verify the Delete Source box is checked and press OK
  20. Close the event log that appears in HYEXPOLRE
  21. In the Hydstra Data Manager’s Workbench, verify that one of the site icons is highlighted and select File > Close Site