Manual
Alarm
Burst Data
Dashboard
Data Source
Displacement Graph
GIS
Historical Graphs
Real Time Display
Virtual Variables
Analysis
Contacts
Contact Groups
Completeness
Documents
Download Data
Localization
Notes
Month Overview
Manual Inclinometer
Reports
Site Setup
Validation
Owner
Prism
Update Overview
Videos
Guides
Creating a new project
Install IIS: Windows Server
Installing Scheduled Tasks
Restarting the Vista Data Vision System
FAQ
Server Side
File Converter gets empty
Update header - new sensors added to the data file
Import modified or historical data
Future data imported into VDV
The VI Not Executable
Email subject contains information from the mail server
Webcam not importing pictures
How to configure Text Message Service
Run tasks minimized
System Requirements
No graphs showing in historical data
How to backup VDV?
Front end
- All Categories
- FAQ
- Server Side
- Future data imported into VDV
Future data imported into VDV
Updated
by Andres Andresson
In rare occasions data sources can produce erroneous data with future timestamp that is imported into the VDV database.
db.robot.c is designed to know what timestamps already have been imported into the database and will not import new data unless the timestamp is newer then the latest timestamp in the database. When data with future timestamps have been imported into the database this becomes a problem because no new data will be imported until that date has passed.
There is a three step solution to this problem:
- Fix the data source and make sure that the raw .dat files does not have any future dates in it.
- Go to db.robot.c > Data Handling > Delete Data From Station
Select From and To dates from the Date Picker and make sure that the future data is within that range and delete the data - Go to db.robot.c > Data Handling > Change Last Timestamp
Change the Latest Timestamp to date and time prior to the latest that that is correctly in the database.
db.robot.c will import all data in the raw .dat file that is newer the configured Latest Timestamp.NOTE: The Data Handling feature is only available in VDV 2016 and later