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

We Value Your Feedback!
Could you please spare a few minutes to share your thoughts on Cloud Connected vs On-Premise Services. Your feedback can help us shape the future of services.
Learn more about the survey or Click here to Launch the survey
Schneider Electric Services Innovation Team!

ExportHistoryToTSV tool

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
  • ExportHistoryToTSV tool
Options
  • 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
308
AndrewScott
Admiral AndrewScott
98
BevanWeiss
Spock BevanWeiss
91
AdamWoodlandToo
Lt. Commander AdamWoodlandToo
37
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
StanleyK
Ensign StanleyK
Ensign

Posted: โ€Ž2022-01-24 07:14 AM . Last Modified: โ€Ž2023-05-02 11:59 PM

0 Likes
12
2545
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • 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: โ€Ž2022-01-24 07:14 AM . Last Modified: โ€Ž2023-05-02 11:59 PM

ExportHistoryToTSV tool

Hi,

is it possible please to obtain somewhere the source code of SCX tool "ExportHistoryToTSV v1.0.30"?

 

It's very helpful tool, but it isn't suitable for a big amount of historic records (eg. 21mil records per point).

 

Thanks.

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

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

  • All forum topics
  • Previous Topic
  • Next Topic

Accepted Solutions
sbeadle
Kirk sbeadle Kirk
Kirk

Posted: โ€Ž2023-02-14 08:46 AM

0 Likes
0
1521
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • 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: โ€Ž2023-02-14 08:46 AM

I have written a new version in .Net, available on the KB in the Tools and Samples page, see "Export and Import History Tool".

 

Source code available on our GitHub too!

See Answer In Context

Reply
Contact Support

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

Replies 12
BevanWeiss
Spock BevanWeiss
Spock

Posted: โ€Ž2022-01-24 01:20 PM

0 Likes
9
2539
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • 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: โ€Ž2022-01-24 01:20 PM

I haven't heard of this specific tool, and I don't remember anything similar being on the Resource Centre.

Are you sure that it came from Serck / Schneider?

Do you have a link to the source that you obtained it from?

 

 

There are a number of ways to get data out of ClearSCADA / Geo SCADA Expert.

It might be worth having a look through the code samples available here:

https://github.com/GeoSCADA/Utilities-and-Examples

 

In particular

https://github.com/GeoSCADA/Utilities-and-Examples/blob/ce75d441f7fe2af64f0910eefe8038bb1af39c7b/Ins... 

 

If you are looking to retrieve data of 21million events over a large number of points then you need to accept that this is a lot of data, and that if you expand it into a Tab Separated Values format (inefficient data storage) then it will both take up a lot of disk space, and it will also be slow, just because it's a lot of disk transactions.  The faster your disks (for both source and destination), the better..  if you're using magnetic drives, it will be slow.

 

There are other ways which don't involve code, like the Crystal Reports driver, or SQL Export.  But given the data volumes you're talking about I think these other layers will only cost you performance.


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
Contact Support

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

sbeadle
Kirk sbeadle Kirk
Kirk

Posted: โ€Ž2022-01-25 01:51 AM

In response to BevanWeiss
0 Likes
8
2529
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • 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: โ€Ž2022-01-25 01:51 AM

Hi All,

 

that tool is mine!

 

It's available compiled on the KB in the Tools and Samples page, see "Export and Import History Tool".

It's quite useful to both extract and restore historic data, as you can select the points and time period, then export to a Tab-Separated file per point. Import, like export, includes the additional fields like quality and reason.

Unfortunately I wrote it a long time ago, and it's in VB6. Very simple though, and if you translate to .Net then please consider open-sourcing - contact me if you wish me to add it to our GitHub.

 

I attach the source to this post.

 

Steve B

 

Attachments
ExportSCXHistoryToTSVcode.zip
  • Tags:
  • english
  • scada
  • SCADA app
  • SCADA software
  • SCADA tutorial
  • Telemetry and SCADA
Reply
Contact Support

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

BevanWeiss
Spock BevanWeiss
Spock

Posted: โ€Ž2022-01-25 10:06 PM

In response to sbeadle
0 Likes
1
2517
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • 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: โ€Ž2022-01-25 10:06 PM

It looks like it is using OLE-DB, so I expect performance gains could be had if it migrated to using the .NET API instead ๐Ÿ˜Š

 

But I reckon this is a task best left to the reader ๐Ÿ˜‰


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
Contact Support

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

StanleyK
Ensign StanleyK
Ensign

Posted: โ€Ž2022-01-27 03:13 AM

In response to BevanWeiss
0 Likes
0
2502
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • 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: โ€Ž2022-01-27 03:13 AM

Hi,

thanks for your answer.

 

In the end, I solve it with ViewX scripting, I have exported historic files diveded after 10k records per CSV file. And it looks fast.

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

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

StanleyK
Ensign StanleyK
Ensign

Posted: โ€Ž2022-01-31 02:31 AM

In response to sbeadle
0 Likes
0
2472
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • 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: โ€Ž2022-01-31 02:31 AM

 
Reply
Contact Support

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

ggallardo
Crewman ggallardo
Crewman

Posted: โ€Ž2022-07-08 02:25 PM

In response to sbeadle
0 Likes
2
2352
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • 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: โ€Ž2022-07-08 02:25 PM

Hi,

 

We want to use the ExportHistoryToTSV to retrieve data from a Hot-Standby configuration GEOSCADA 2019 server, but we keep getting runtime-error '76': Path not found.

 

The folder specified in Target Folder already exists and we have run the tool in a local server without problem. Can you help us with more information about the error or with your experience with similar outcomes?

 

The data is from only a week

 

Thanks

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

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

BevanWeiss
Spock BevanWeiss
Spock

Posted: โ€Ž2022-07-10 02:41 PM

In response to ggallardo
0 Likes
1
2311
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • 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: โ€Ž2022-07-10 02:41 PM

You should raise a new topic for your issue.  If you mention @sbeadle he might be able to assist you with this.


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
Contact Support

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

sbeadle
Kirk sbeadle Kirk
Kirk

Posted: โ€Ž2022-07-11 01:04 AM

In response to BevanWeiss
0 Likes
0
2294
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • 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: โ€Ž2022-07-11 01:04 AM

The tool is built using VB6, so may not support UNC file paths. Are you using a drive letter? e.g. c:\ or x:\ ? 

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

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

Clearscada_EIT
Ensign Clearscada_EIT
Ensign

Posted: โ€Ž2022-09-12 09:50 AM . Last Modified: โ€Ž2022-11-11 01:00 PM

In response to sbeadle
0 Likes
1
1843
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • 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: โ€Ž2022-09-12 09:50 AM . Last Modified: โ€Ž2022-11-11 01:00 PM

 

THanks 

Reply
Contact Support

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

AndrewScott
Admiral AndrewScott
Admiral

Posted: โ€Ž2022-09-12 10:00 AM

In response to Clearscada_EIT
0 Likes
0
1840
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • 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: โ€Ž2022-09-12 10:00 AM

@Clearscada_EIT, @sbeadle already attached the VB6 source code for ExportHistoryToTSV to the third post in this topic (above).

 

https://community.se.com/krefy84679/attachments/krefy84679/ecostruxure-geo-scada-expert-forum/2683/1... 


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

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

sbeadle
Kirk sbeadle Kirk
Kirk

Posted: โ€Ž2023-02-14 08:46 AM

0 Likes
0
1522
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • 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: โ€Ž2023-02-14 08:46 AM

I have written a new version in .Net, available on the KB in the Tools and Samples page, see "Export and Import History Tool".

 

Source code available on our GitHub too!

Reply
Contact Support

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

StanleyK
Ensign StanleyK
Ensign

Posted: โ€Ž2023-03-20 06:36 AM

0 Likes
0
1372
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • 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: โ€Ž2023-03-20 06:36 AM

Thank you very much.

Reply
Contact Support

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