Inlet error with daily data

[juan diaz bernardos]

Issue Summary

I'm trying to input daily river discharge data for model calibration using QSWAT3 v2.0.3 (SWAT 2012), but I get this error:

Error: La columna 'DATE' no pertenece a la tabla tblTs.

(The column 'DATE' does not belong to table tblTs)

 Software & Project

• QSWAT: v2.0.3
• SWAT Version: SWAT 2012
• QGIS: 3.40 LTR
• Data: Daily discharge records (4,464 days, 2009-2021)
• Watershed: 24 km², Segovia, Spain

The Problem:

When I try to load a Daily Records file (.txt) through:

• QSWAT3 → Edit Inlet Inputs → Daily Records → Select file

I get an error regardless of file format tried:

• DAY YEAR FLODAY SEDDAY ...
• DATE DAY YEAR FLODAY SEDDAY ...
• DATE JDAY MO DAY_MO YEAR FLODAY SEDDAY ...

The error message suggests QSWAT3 is looking for a column 'DATE' in an Access database table (tblTs), not reading a text file.

File Format I'm Using

Following SWAT 2012 Chapter 31 (Manual):

JDAY  YEAR FLODAY SEDDAY...

 274 2009 42336.00 0.0 0.0 0.0 0.0...

 275 2009 35424.00 0.0 0.0 0.0 0.0...

 276 2009 38016.00 0.0 0.0 0.0 0.0...

• Format: Free format (F90)
• FLODAY: m³/day

 

Question

How do I properly input daily measured data in QSWAT3 v2.0.3 for SWAT 2012?

1. Should I import the text file into the Access database first? How?
2. Is there a different method for measured time series in QSWAT3?

Any help appreciated!