| 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 <2022> 2023 2024 2025 | Index | 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 <2022> 2023 2024 2025 |
| <== Date ==> | <== Thread ==> |
|---|
| Subject: | Re: Generating EPICS records from a spreadsheet |
| From: | Ian Gillingham via Tech-talk <tech-talk at aps.anl.gov> |
| To: | "Cobb, Tom (DLSLtd,RAL,LSCI)" <tom.cobb at diamond.ac.uk>, "tech-talk at aps.anl.gov" <tech-talk at aps.anl.gov> |
| Date: | Fri, 6 May 2022 14:53:59 +0100 |
Hi Tom,
That is absolutely brilliant! Just what I was looking for.
It looks really straightforward, once I've extracted the spreadsheet info.
I'll let you know how it goes
Cheers,
Ian
Hi Ian,
One option would be to do the Excel reading in Python then use https://github.com/dls-controls/epicsdbbuilder to do the db writing. It uses dbStatic calls to load a DBD file, then check that the records being produced are valid and have valid values.
Thanks,Tom
From: Tech-talk <tech-talk-bounces at aps.anl.gov> on behalf of Ian Gillingham via Tech-talk <tech-talk at aps.anl.gov>
Sent: 06 May 2022 12:42
To: tech-talk at aps.anl.gov <tech-talk at aps.anl.gov>
Subject: Generating EPICS records from a spreadsheetI'm interested to know whether anyone has developed a mechanism for
creating a .db file of EPICS records from information (record names,
fields and associated values) stored in an Excel spreadsheet?
Just trying to avoid re-inventing the proverbial wheel.
Thanks,
Ian Gillingham
--
This e-mail and any attachments may contain confidential, copyright and or privileged material, and are for the use of the intended addressee only. If you are not the intended addressee or an authorised recipient of the addressee please notify us of receipt by returning the e-mail and do not use, copy, retain, distribute or disclose the information in or attached to the e-mail.
Any opinions expressed within this e-mail are those of the individual and not necessarily of Diamond Light Source Ltd.
Diamond Light Source Ltd. cannot guarantee that this e-mail or any attachments are free from viruses and we cannot accept liability for any damage which you may sustain as a result of software viruses which may be transmitted in or with the message.
Diamond Light Source Limited (company no. 4375679). Registered in England and Wales with its registered office at Diamond House, Harwell Science and Innovation Campus, Didcot, Oxfordshire, OX11 0DE, United Kingdom