Moving Historic Data from a Modbus or DNP3 Point to a NEW DNP3 Point

[dahoodman]

During a transition from one SCADA system to another, we created Modbus and/or DNP3 outstations with associated points (depending on the station) in GeoSCADA to temporarily poll for data while controls and such were upgraded and now we are creating a new set of Points under a new Outstation and we need to move the old historical data into the new points. What is the best/easiest way to accomplish this? Is it best to export to SQL and then import back to GeoSCADA or is there a more direct way to do this within GeoSCADA?

[geoffpatton]

in the Geo SCADA Tools and Samples there is the section

Export and Import History Tools

it has links to code examples on GitHub.

https://community.se.com/t5/Geo-SCADA-Knowledge-Base/Tools-amp-Samples/ba-p/279123

[dahoodman]

Tried the TransferHistory tool and it gave me an error that it couldn't communicate to the server. I had a GeoSCADA ViewX window open so I figured maybe since I was using port 5481 already that was the issue, but when I closed it, there was no difference. It was still giving me an error. Does this have to be run on the server itself and can the server be running when exporting and importing? I am essentially exporting from one tag into the other tag on the same server.

Just tried the ExportToTSV and although that connected, I selected one tag to export and chose a path that exists on my computer and the server and the app errored out saying path not found (C:\Temp). Not sure what I need to do there.

[geoffpatton]

I have not used either of those code examples I just saw them the other day when I was looking for another tool.

I have not worked on a .Net program in a long time but have always run them on the server itself. I believe they should work fine from a remote computer that has the connections configurations, which if you have ViewX installed are installed.

Did you try running it As Administrator that seems to be necessary now days even when you are logged in as an administrator. Folder permission can be a pain now try a folder in your user folder like in Documents.

[dahoodman]

Yep, ran as admin on my computer and still nothing. I did move it to the server and it at least connected and read the tags I could select, but once I selected one tag for a 6 month history export and hit export the program locked up and closed. Thank you for pointing me to the tools, maybe I can see if I can get them to work but it sure would be nice if they had something already built-in. Maybe they do and I'm just missing it.

[dahoodman]

I figured out the issue with the ExportToTSV application. I don't know how to resolve it, but the issue is that the combination of the tag name and the path to export to is too long for a file name apparently. I tried to export a shorter named tag and that worked. But I can't just go renaming my tags to fit the tool so I'm looking through the source code on GITHUB to see what SQL is being used and see if I can just replicate it on my own using point ID rather than a tag name. Pretty sure everything is stored that way anyway.