Help
  • Explore Community
  • Get Started
  • Ask the Community
  • How-To & Best Practices
  • Contact Support
Notifications
Login / Register
Community
Community
Notifications
close
  • Forums
  • Knowledge Center
  • Events & Webinars
  • Ideas
  • Blogs
Help
Help
  • Explore Community
  • Get Started
  • Ask the Community
  • How-To & Best Practices
  • Contact Support
Login / Register
Sustainability
Sustainability

Join our "Ask Me About" community webinar on May 20th at 9 AM CET and 5 PM CET to explore cybersecurity and monitoring for Data Center and edge IT. Learn about market trends, cutting-edge technologies, and best practices from industry experts.
Register and secure your Critical IT infrastructure

Importing Historic Data

EcoStruxure Geo SCADA Expert Forum

Schneider Electric support forum about installation, configuration, integration and troubleshooting of EcoStruxure Geo SCADA Expert (ClearSCADA, ViewX, WebX).

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Home
  • Schneider Electric Community
  • Remote Operations
  • EcoStruxure Geo SCADA Expert Forum
  • Importing Historic Data
Options
  • Subscribe to RSS Feed
  • Mark Topic as New
  • Mark Topic as Read
  • Float this Topic for Current User
  • Bookmark
  • Subscribe
  • Mute
  • Printer Friendly Page
Invite a Co-worker
Send a co-worker an invite to the portal.Just enter their email address and we'll connect them to register. After joining, they will belong to the same company.
You have entered an invalid email address. Please re-enter the email address.
This co-worker has already been invited to the Exchange portal. Please invite another co-worker.
Please enter email address
Send Invite Cancel
Invitation Sent
Your invitation was sent.Thanks for sharing Exchange with your co-worker.
Send New Invite Close
Top Experts
User Count
sbeadle
Kirk sbeadle Kirk
307
AndrewScott
Admiral AndrewScott
96
BevanWeiss
Spock BevanWeiss
90
AdamWoodlandToo
Lt. Commander AdamWoodlandToo
36
View All
Related Products
product field
Schneider Electric
EcoStruxure™ Geo SCADA Expert

Invite a Colleague

Found this content useful? Share it with a Colleague!

Invite a Colleague Invite
Solved Go to Solution
Back to EcoStruxure Geo SCADA Expert Forum
Solved
DavidSkilbeck
Lt. Commander DavidSkilbeck
Lt. Commander

Posted: ‎2021-02-23 12:31 AM . Last Modified: ‎2023-05-03 12:05 AM

0 Likes
11
3546
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Subscribe to RSS Feed
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content

Link copied. Please paste this link to share this article on your social media post.

Posted: ‎2021-02-23 12:31 AM . Last Modified: ‎2023-05-03 12:05 AM

Importing Historic Data

Hi, I have been running through the article below.

 

https://tprojects.schneider-electric.com/GeoSCADAHelp/Geo%20SCADA%202020/Content/ServerAdministratio...

 

For the last example 2.

Initially used the data provided as below

2016,07,03,16,23,23,0

2016,07,03,16,24,23,12

and got a message below

ErrorMessageCSVImport.png

I changed the data to below to get it to work

(earliest I could go back).

2021,02,22,16,11,38,000,4.0218887
2021,02,22,16,11,53,000,3.1718216
.......
It did work, however the date in the history was today's date and not that of the file.
ErrorMessageCSV2Import.png

 

Is there a way of adjusting the time window (and if so how far back can we go).
Is there a setting for the correct date / time  to be loaded in to the history, as to that of the file ( I notice there is AM listed).

Thanks,

Labels
  • Labels:
  • SCADA
  • Tags:
  • english
  • scada
  • SCADA app
  • SCADA software
  • SCADA tutorial
  • Telemetry and SCADA
Reply

Link copied. Please paste this link to share this article on your social media post.

  • All forum topics
  • Previous Topic
  • Next Topic

Accepted Solutions
AndrewScott
Admiral AndrewScott
Admiral

Posted: ‎2021-02-23 01:58 AM

0 Likes
10
3541
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Subscribe to RSS Feed
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content

Link copied. Please paste this link to share this article on your social media post.

Posted: ‎2021-02-23 01:58 AM

The writable life for historic data is configured using the Server Configuration tool:

https://tprojects.schneider-electric.com/GeoSCADAHelp/Geo%20SCADA%202020/Default.htm#ServerAdministr... l

 

The timestamps in the CSV file are in UTC, but ViewX is displaying the times in local time of the client PC, which appears to be UTC+10:00, so you are probably located in Australia.


Andrew Scott, R&D Principal Technologist, AVEVA

See Answer In Context

  • Tags:
  • english
  • scada
  • SCADA app
  • SCADA software
  • SCADA tutorial
  • Telemetry and SCADA
Reply

Link copied. Please paste this link to share this article on your social media post.

Replies 11
AndrewScott
Admiral AndrewScott
Admiral

Posted: ‎2021-02-23 01:58 AM

0 Likes
10
3542
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Subscribe to RSS Feed
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content

Link copied. Please paste this link to share this article on your social media post.

Posted: ‎2021-02-23 01:58 AM

The writable life for historic data is configured using the Server Configuration tool:

https://tprojects.schneider-electric.com/GeoSCADAHelp/Geo%20SCADA%202020/Default.htm#ServerAdministr... l

 

The timestamps in the CSV file are in UTC, but ViewX is displaying the times in local time of the client PC, which appears to be UTC+10:00, so you are probably located in Australia.


Andrew Scott, R&D Principal Technologist, AVEVA
  • Tags:
  • english
  • scada
  • SCADA app
  • SCADA software
  • SCADA tutorial
  • Telemetry and SCADA
Reply

Link copied. Please paste this link to share this article on your social media post.

DavidSkilbeck
Lt. Commander DavidSkilbeck
Lt. Commander

Posted: ‎2021-02-23 01:14 PM

In response to AndrewScott
0 Likes
9
3528
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Subscribe to RSS Feed
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content

Link copied. Please paste this link to share this article on your social media post.

Posted: ‎2021-02-23 01:14 PM

Hi, do you refer to this section as below

 

ErrorMessageCSV3Import.png

 

as it seems to be set to 520 weeks.

I figures it would be something about UTC / Local.

Thanks,

  • Tags:
  • english
  • scada
  • SCADA app
  • SCADA software
  • SCADA tutorial
  • Telemetry and SCADA
Reply

Link copied. Please paste this link to share this article on your social media post.

BevanWeiss
Spock BevanWeiss
Spock

Posted: ‎2021-02-23 02:37 PM

In response to DavidSkilbeck
0 Likes
8
3520
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Subscribe to RSS Feed
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content

Link copied. Please paste this link to share this article on your social media post.

Posted: ‎2021-02-23 02:37 PM

Those sections that you have indicated only apply to 'Synchronisation Data'.. not to the data that the Main server is actively able to write to.

 

The section that applies for the historical writes is at the top.  If you look at the help for 'Archive after' you will see that this is what triggered the inability to update/add new historical data.

 

The help comments are:

Define the Archive Time for Historic Data

Alarm Summary, Configuration Changes Auditing, Event Journal or Historic Data is stored online for a specified duration (see Specify the Duration to Retain Historic Data Online), then the data is deleted. You can define a period of time after, which data that is stored online can be archived. When historic data is marked as eligible for archiving, it can be archived for example to CD, DVD and so on, (it has to be archived before the duration of the online data expires).

During the period that data is stored online, the data can be altered (by having new values reported for the time period) unless it is marked as eligible for archiving. When historic data is marked as eligible for archiving, it can no longer be altered on the disk—the new records for that period / time cannot be written to; it can only be read.

 

2021-02-24 09_18_57-Clipboard.png

 

The concept here is that once you say that a historical period is 'archivable' then it should no longer be modified.  Since it may no longer be on the computer itself, and may actually be on a CD / DVD or write-once media stored for archiving.

 

For some reason I always 'think' that having an archive after time configured will help performance.  But I'm pretty sure it doesn't.  It obviously cuts down on when re-indexing might be required, but if you're trying to insert historical data into your system, then you probably need that historical data in there, and the cost of indexing is just a burden you need to wear.  As such, I'd say for 'most' systems, probably not having the Archive after tick box ticked is a reasonable approach (I think the default is ticked and 2 weeks).  If you will archive off to DVD etc, then you will need to have this configured.  But Geo SCADA Expert archiving is a little confusing anyway... so I suspect most people aren't using it.


Lead Control Systems Engineer for Alliance Automation (VIC).
All opinions are my own and do not represent the opinions or policies of my employer, or of my cat..
  • Tags:
  • english
  • scada
  • SCADA app
  • SCADA software
  • SCADA tutorial
  • Telemetry and SCADA
Reply

Link copied. Please paste this link to share this article on your social media post.

geoffpatton
Captain geoffpatton
Captain

Posted: ‎2021-02-24 06:22 AM

In response to BevanWeiss
0 Likes
7
3509
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Subscribe to RSS Feed
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content

Link copied. Please paste this link to share this article on your social media post.

Posted: ‎2021-02-24 06:22 AM

I have always kept years of history, but never actually archived any of it.

If I am remembering correctly the Archive after setting helps when you have redundancy and are restarting one of the machines.

This could have changed over the years too. I have been using ClearSCADA since version 2005.

  • Tags:
  • english
  • scada
  • SCADA app
  • SCADA software
  • SCADA tutorial
  • Telemetry and SCADA
Reply

Link copied. Please paste this link to share this article on your social media post.

BevanWeiss
Spock BevanWeiss
Spock

Posted: ‎2021-02-24 02:53 PM

In response to geoffpatton
0 Likes
6
3485
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Subscribe to RSS Feed
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content

Link copied. Please paste this link to share this article on your social media post.

Posted: ‎2021-02-24 02:53 PM

I think this behaviour might have changed in recent versions.

I did a sync yesterday, and having the 4 week 'archive after' setting did NOT help in any way... the full 4 months of historic data was synchronised... which was quite painful over the two tin cans, and low value twine used for the inter-server connection.

 

I would have hoped that it would have done a hash over the current data blocks, and only requested sync where the data block hash didn't match... but it seems that's not the case either (or the behaviour is buggy..)


Lead Control Systems Engineer for Alliance Automation (VIC).
All opinions are my own and do not represent the opinions or policies of my employer, or of my cat..
  • Tags:
  • english
  • scada
  • SCADA app
  • SCADA software
  • SCADA tutorial
  • Telemetry and SCADA
Reply

Link copied. Please paste this link to share this article on your social media post.

AdamWoodland
AdamWoodland Schneider Alumni (Retired)
Schneider Alumni (Retired)

Posted: ‎2021-02-24 03:05 PM

In response to BevanWeiss
1 Like
4
3483
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Subscribe to RSS Feed
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content

Link copied. Please paste this link to share this article on your social media post.

Posted: ‎2021-02-24 03:05 PM

I think the methodology of how far back it syncs was changed around 2017 R1, based on the earlier change...

 

> would have done a hash

 

It used to do a CRC comparison up to 2013R1 or R2, they changed it as the CRC was too intensive to a much faster size and last modified date. If those match it doesn't re-sync the file.

 

Does cause problems if you copy/restore files to a server and that copy changes the last modified date, as the resync will just resync everything anyway.

  • Tags:
  • english
  • scada
  • SCADA app
  • SCADA software
  • SCADA tutorial
  • Telemetry and SCADA
Reply

Link copied. Please paste this link to share this article on your social media post.

geoffpatton
Captain geoffpatton
Captain

Posted: ‎2021-02-24 03:27 PM

In response to BevanWeiss
0 Likes
0
3481
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Subscribe to RSS Feed
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content

Link copied. Please paste this link to share this article on your social media post.

Posted: ‎2021-02-24 03:27 PM

Good to know, I like your networking description. I think all of the servers I work on have lots of resources and a good gigabit connection between them, and I rarely am the one that restarts one.

  • Tags:
  • english
  • scada
  • SCADA app
  • SCADA software
  • SCADA tutorial
  • Telemetry and SCADA
Reply

Link copied. Please paste this link to share this article on your social media post.

BevanWeiss
Spock BevanWeiss
Spock

Posted: ‎2021-02-24 06:39 PM

In response to AdamWoodland
0 Likes
3
3471
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Subscribe to RSS Feed
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content

Link copied. Please paste this link to share this article on your social media post.

Posted: ‎2021-02-24 06:39 PM

Hmm... thanks for the refresher on that new system @AdamWoodland .  Unfortunately doesn't match my experience from yesterday.

 

The primary server had only been off since the 20th Feb, so it should have only been missing 4 days worth of data (or the last 1 week granules needing sync).  But it definitely resynchronised the whole history.

 

I do have a scheduled historic optimise, but that's only every Sunday... I guess I'll need to keep an eye on it, and report if it happens again.


Lead Control Systems Engineer for Alliance Automation (VIC).
All opinions are my own and do not represent the opinions or policies of my employer, or of my cat..
  • Tags:
  • english
  • scada
  • SCADA app
  • SCADA software
  • SCADA tutorial
  • Telemetry and SCADA
Reply

Link copied. Please paste this link to share this article on your social media post.

DavidSkilbeck
Lt. Commander DavidSkilbeck
Lt. Commander

Posted: ‎2021-02-25 09:02 PM . Last Modified: ‎2021-02-25 10:14 PM

In response to BevanWeiss
0 Likes
2
3436
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Subscribe to RSS Feed
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content

Link copied. Please paste this link to share this article on your social media post.

Posted: ‎2021-02-25 09:02 PM . Last Modified: ‎2021-02-25 10:14 PM

Hi, these are the settings for my Geo SCADA.

 

ErrorMessageCSV4Import.png

This a sample of the data I want to import
4.0218887,2020,07,22,16,11,38,010,192,8
3.1718216,2020,07,22,16,11,53,010,192,8

This is what I am getting in Geo SCADA

ErrorMessageCSV5Import.png

If I use the below it wont import historic values

dt = new DateTime(2020, 2, 26, 11, 55, 52);

If I change the 2020 to 2021 it works.

  • Tags:
  • english
  • scada
  • SCADA app
  • SCADA software
  • SCADA tutorial
  • Telemetry and SCADA
Reply

Link copied. Please paste this link to share this article on your social media post.

DavidSkilbeck
Lt. Commander DavidSkilbeck
Lt. Commander

Posted: ‎2021-02-28 06:19 PM

In response to DavidSkilbeck
0 Likes
1
3403
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Subscribe to RSS Feed
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content

Link copied. Please paste this link to share this article on your social media post.

Posted: ‎2021-02-28 06:19 PM

It has been working. I just needed to select last year for it to display.

Even with offset property for the point set to "Hour - 2 Years", yo have to change search to last year.

Thanks,

 

Reply

Link copied. Please paste this link to share this article on your social media post.

BevanWeiss
Spock BevanWeiss
Spock

Posted: ‎2021-02-28 09:00 PM

In response to DavidSkilbeck
0 Likes
0
3394
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Subscribe to RSS Feed
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content

Link copied. Please paste this link to share this article on your social media post.

Posted: ‎2021-02-28 09:00 PM

It's possible that there are bugs around the offset property (and just Historic List behaviour in certain scenarios).

It would be worth reviewing the help documentation, and if you see behaviour that differs from the help documentation then raising a case with Tech Support.  That way they know about it, and can get it fixed for the future.

 

But always good to double check what the actual query is being used for the lists.


Lead Control Systems Engineer for Alliance Automation (VIC).
All opinions are my own and do not represent the opinions or policies of my employer, or of my cat..
  • Tags:
  • english
  • scada
  • SCADA app
  • SCADA software
  • SCADA tutorial
  • Telemetry and SCADA
Reply

Link copied. Please paste this link to share this article on your social media post.

Preview Exit Preview

never-displayed

You must be signed in to add attachments

never-displayed

 
To The Top!

Forums

  • APC UPS Data Center Backup Solutions
  • EcoStruxure IT
  • EcoStruxure Geo SCADA Expert
  • Metering & Power Quality
  • Schneider Electric Wiser

Knowledge Center

Events & webinars

Ideas

Blogs

Get Started

  • Ask the Community
  • Community Guidelines
  • Community User Guide
  • How-To & Best Practice
  • Experts Leaderboard
  • Contact Support
Brand-Logo
Subscribing is a smart move!
You can subscribe to this board after you log in or create your free account.
Forum-Icon

Create your free account or log in to subscribe to the board - and gain access to more than 10,000+ support articles along with insights from experts and peers.

Register today for FREE

Register Now

Already have an account? Login

Terms & Conditions Privacy Notice Change your Cookie Settings © 2025 Schneider Electric

This is a heading

With achievable small steps, users progress and continually feel satisfaction in task accomplishment.

Usetiful Onboarding Checklist remembers the progress of every user, allowing them to take bite-sized journeys and continue where they left.

of