EPICS Controls Argonne National Laboratory

Experimental Physics and
Industrial Control System

1994  1995  1996  1997  1998  1999  2000  2001  2002  2003  2004  2005  2006  2007  2008  2009  2010  2011  2012  2013  2014  2015  <20162017  2018  2019  2020  2021  2022  2023  2024  Index 1994  1995  1996  1997  1998  1999  2000  2001  2002  2003  2004  2005  2006  2007  2008  2009  2010  2011  2012  2013  2014  2015  <20162017  2018  2019  2020  2021  2022  2023  2024 
<== Date ==> <== Thread ==>

Subject: Re: Channel Archiver - Data Conversion / Export from File to RDBArchiver PostgreSQL database
From: "Kasemir, Kay" <[email protected]>
To: "Zumbruch, Peter Dr." <[email protected]>, "[email protected] ([email protected])" <[email protected]>
Date: Mon, 28 Nov 2016 17:02:06 +0000

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: [email protected] <[email protected]> on behalf of Zumbruch, Peter Dr. <[email protected]>
Sent: Monday, November 28, 2016 11:47 AM
To: [email protected] ([email protected])
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: [email protected]

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

 


References:
Channel Archiver - Data Conversion / Export from File to RDBArchiver PostgreSQL database Zumbruch, Peter Dr.

Navigate by Date:
Prev: Re: EPICS/RTEMS Compilation errors Benjamin Franksen
Next: Re: EPICS/RTEMS Compilation errors Michael Davidsaver
Index: 1994  1995  1996  1997  1998  1999  2000  2001  2002  2003  2004  2005  2006  2007  2008  2009  2010  2011  2012  2013  2014  2015  <20162017  2018  2019  2020  2021  2022  2023  2024 
Navigate by Thread:
Prev: Channel Archiver - Data Conversion / Export from File to RDBArchiver PostgreSQL database Zumbruch, Peter Dr.
Next: Suppress modbus output Wallace, Alex
Index: 1994  1995  1996  1997  1998  1999  2000  2001  2002  2003  2004  2005  2006  2007  2008  2009  2010  2011  2012  2013  2014  2015  <20162017  2018  2019  2020  2021  2022  2023  2024 
ANJ, 28 Nov 2016 Valid HTML 4.01! · Home · News · About · Base · Modules · Extensions · Distributions · Download ·
· Search · EPICS V4 · IRMIS · Talk · Bugs · Documents · Links · Licensing ·