Re: Channel Archiver - Data Conversion / Export from File to RDBArchiver PostgreSQL database

["Kasemir, Kay" <kasemirk@ornl.gov>]

Hi:

When we went through that transition at SNS, the archive display tool (CSS Data Browser) was configured to look in both the channel archiver's XMLRPC server and the RDB-based data source.

(If you update from the channel archiver to the archive appliance you could do the same. I believe the archive appliance can also serve existing channel archiver data, so then you're back to just one access point for reading data)

In principle it wouldn't be too hard to create a conversion tool.

The CSS sources include both an archive reader for the channel archiver (and other data sources) and an archive writer for the RDB.

The test code contains an older "CopyDemo" that reads all channels from a reader and writes all their samples for some time range to the writer:

https://github.com/ControlSystemStudio/cs-studio/blob/master/applications/archive/archive-plugins/org.csstudio.archive.writer.test/test/org/csstudio/archive/writer/rdb/CopyDemo.java

So that's a starting point. If you only need the conversion once, you can try to adjust the URLs etc. in there, then run it from within the development environment.

-Kay

---

From: tech-talk-bounces@aps.anl.gov <tech-talk-bounces@aps.anl.gov> on behalf of Zumbruch, Peter Dr. <P.Zumbruch@gsi.de>
Sent: Monday, November 28, 2016 11:47 AM
To: tech-talk@aps.anl.gov (tech-talk@aps.anl.gov)
Subject: Channel Archiver - Data Conversion / Export from File to RDBArchiver PostgreSQL database

 

Hi,

I would like to export data from the file base channel archiver into the PostgreSQL database of the CSS RDBArchiver.

Has anybody already done so and has experience or tools for converting data from file to RDB?

 

Any help appreciated.

Best regards,

Peter

 

--
Dr. Peter Zumbruch
Experiment Electronics / Controls group

Phone / Telefon: +49-6159-71-1435

Fax: +49-6159-71-2986
E-Mail: P.Zumbruch@gsi.de

GSI Helmholtzzentrum für Schwerionenforschung GmbH
Planckstraße 1, 64291 Darmstadt, Germany, www.gsi.de

Commercial Register / Handelsregister: Amtsgericht Darmstadt, HRB 1528
Managing Directors / Geschäftsführung:
Ursula Weyrich, Professor Dr. Karlheinz Langanke, Jörg Blaurock
Chairman of the Supervisory Board / Vorsitzender des GSI-Aufsichtsrats:
State Secretary / Staatssekretär Dr. Georg Schütte