Convert historical data from V5 to V6

[kcks66]

Hi Mikhail,

Currently I am in the works to migrate Rapid SCADA from v5.8.4 to v6.2.0. I had done manual configure all channels in v6, right now is the time to migrate historical data from v5 to v6.

I downloaded from your utilities tools-v6 HistConv5to6_dotnet8 and extracted. I double click the HistConv5to6 application file somehow looks like a command prompt window pop up then automatic close down.

Pls advice for the steps. Thank you.

[Mikhail]

Hi,

You should run cmd first. Then execute the *.exe in the command prompt.

[kcks66]

Hi Mikhail,

I got the converter to run. However, I got many errors. The converter stop when encountered error. I need to remove those error .dat files and re-run the converter.

https://ibb.co/wQHkqGF

Is there a way to make the converter automatically re-run by skipping errors .dat files?

By the way, why there is some error from v5 .dat file?
Pls advice and thank you.

[Mikhail]

Hi,
It is important to find the cause of the error. May be those files contains correct and useful data. Could you open the problem files in the Administrator app to view data and try to realize why they can cause the error?

[kcks66]

Hi Mikhail,

I can see the error .dat file contain two data per one minute, if compared to other success .dat file contain one data per minute:

https://ibb.co/10rWGDy

Any .dat file with more than 1440 will be treated as error.

[Mikhail]

Hi,

Try the updated converter. Send a screenshot of its work, please.

[kcks66]

Hi Mikhail,

I can see the new converter can continue to run after encountered those data more than 1440 per day.

https://ibb.co/34tkBJV

[kcks66]

Hi Mikhail,

Previous Rapid SCADA v5 I use .dat as my main achieve. Right now after I migrated to v6 I want to use ModArcPostgreSql as my main achieve.

Those .dat files from v5 I used the converter to convert to v6 .dat files format, can be trend by modArcBasic only, right?

Pls advice for what should I do after I set ModArcPostgreSql as my main achieve and still can trend back those converted historical data previously from v5?

Thank you.

• This reply was modified 1 year, 5 months ago by kcks66.

[Mikhail]

Hi,

> Those .dat files from v5 I used the converter to convert to v6 .dat files format, can be trend by modArcBasic only, right?
Yes.

> what should I do after I set ModArcPostgreSql as my main achieve and still can trend back those converted historical data previously from v5?
Using Chart Pro, you can create a chart profile to open data from *.dat archive. Reports also support choosing an archive.
However, may be in your case it is better to use PostgreSQL as a secondary archive.

[kcks66]

Hi Mikhail,

I would like to explore all of these advice.

1) How shall I configure the chart profile to open data from *.dat archive?

https://ibb.co/Gpz254z

2) Am I need to enable/true the below?

<!– User can select archive –>
<SelectArchive>false</SelectArchive>

3) I need to active both set of Achieve like below?

https://ibb.co/RPkhFbf

Thank you.

[Mikhail]

Hi,

1) Create a copy of ChartPro.xml, for example, PlgChartPro_Profile2.xml
Add a new line into ChartPro_Config.xml

<Profile fileName="PlgChartPro_Profile2.xml">Profile 2</Profile>

[Mikhail]

2) In Elastic Report, use SelectArchive and/or DefaultArchive

3) Yes. Activate archives that are in use.

[kcks66]

Hi Mikhail,

Thanks. I tried all of them and they worked accordingly.

After I discussed and showed to the system users, we finally decided to use PostgreSql as only one achieve as main achieve.

My next step is to migrate all the *.dat files (in v6 format already) into Postgresql database. Pls advice any faster or easier way to do such migration?

Thank you.

[Mikhail]

Hi,

> decided to use PostgreSql as only one achieve as main achieve
It’s up to you. However, why don’t you use *.dat format as a secondary to make the system more reliable?

[Mikhail]

> migrate all the *.dat files (in v6 format already) into Postgresql database
Currently, there is no ready to use converter. 2 approaches come to my mind:
1. We can develop a converter by a contract.
2. Deploy an additional instance of Rapid SCADA and use Rapid Gate module to transfer data from the additional instance to the main instance of Rapid SCADA.

[Author]

Posts