Re: Generating EPICS records from a spreadsheet

["Cobb, Tom \(DLSLtd,RAL,LSCI\) via Tech-talk" <tech-talk at aps.anl.gov>]

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 spreadsheet

 

I'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