openHistorian: How to import archive(d2 file)?

[WJ_KIM]

Hi.

I stored the data from PMU by openHistorian.
I deleted the device and create the device again in openHistorian manager.
Then I cannot see the trend of the previous data on a web application.
I think the reason is I created a new database when I create the device again.

The archive(d2 file) is still in the Archive folder.
How to import the previous archive to openHistorian?
I’d like to see the trend and download csv file.

Thanks.

WJ.

[StephenCWills]

Hi WJ,

Please refer to the following topic for more information on why this is happening.

Phasor data history in OpenHistorian

Hi guys, I just wanted to confirm something. I add a device for a while and collect history on that device. I delete that device, then add the same device with a few different parameters. Will the prior history be lost forever, or is there is a way of combining the history of the removed device and the newly added device ( being the same physical device )?

Thanks,
Stephen

[WJ_KIM]

Hi Stephen,

Thank you for your reply.

I have one more question.
Is there any way to see the previous data(D2 file)?
For example, how to convert the archive file to csv?

I’d like to just check the raw data from archive.

Thanks.

Woojin Kim.

[ritchiecarroll]

Try running the DataExtractionUtility.exe that can be found in the openHistorian installation folder, typically C:\Program Files\openHistorian.

If you want to extract points for which you have no loner have metadata (e.g., all possible points) - this will require use of the openHistorian API to scan the target .D file and extract all possible data. At a low level, you can open the FileBlockHeader scanning each block, then find the associated file block and read the contents and then export to a file. The closest thing we have to this is the ArchiveIntegrityChecker which operates at this level.

Thanks,
Ritchie