1 / 7

SNS Application Development Environment CVS Tom Nepsee March 17, 2003

SNS Application Development Environment CVS Tom Nepsee March 17, 2003. SNS ADE CVS Release Cycle. Power Supply Controls Configuration Data Flow. One IOC. Relational DB. Client App. CONFIG FILE. QUERY. IOC DB. Flat File in ASCII Encoded CSV Format. Extracts data for each PS.

bryant
Download Presentation

SNS Application Development Environment CVS Tom Nepsee March 17, 2003

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. SNS Application Development Environment CVS Tom Nepsee March 17, 2003

  2. SNS ADECVS Release Cycle

  3. Power Supply ControlsConfiguration Data Flow One IOC Relational DB Client App CONFIG FILE QUERY IOC DB Flat File in ASCII Encoded CSV Format Extracts data for each PS

  4. Power Supply ControlsDatabase Tables • IOC/PSC/PSI • List of power supply names with IOCs • PS Model Data • Operating parameters for each PS type • IOC Locations • Location • Controls Cabinets • Location and power requirements • IOC Records • Describes EPICS records used by IOC

  5. Power Supply ControlsDatabase Query Query Selects Configuration Parameters for a specific IOC SELECT [PS to IOC Map].[PS Name], [PS to IOCMap].[PSC Number], [PS to IOC Map].[PSI Number], [PS Models].[Max Current], [PS Models].[Max Voltage], [PS Models].[Polarity] FROM [PS Models] INNER JOIN ([PS to IOC Map] INNER JOIN [PS ID] ON[PS to IOC Map].[PS Name]=[PS ID].[PS Name]) ON [PS Models].[Model]=[PS ID].[Model] WHERE ((([PS to IOC Map]![IOC Name])="ICS_Ctl:IOC_7"));

  6. Power Supply ControlsConfig File Format Max Current Max Voltage PSC Number PSC Channel PS Name Polarity Mode Ring_PS:DCVB7,0,0,20.00,35.00,Bipolar Ring_PS:DCVB9,0,1,20.00,35.00,Bipolar Ring_PS:DCVC1,0,2,20.00,35.00,Bipolar Ring_PS:DCVC10,0,3,20.00,35.00,Bipolar Ring_PS:DCVC13,0,4,20.00,35.00,Bipolar Ring_PS:DCVC3,0,5,20.00,35.00,Bipolar Ring_PS:DCVC5,1,0,20.00,35.00,Bipolar Ring_PS:DCVC7,1,1,20.00,35.00,Bipolar Ring_PS:DCVC9,1,2,20.00,35.00,Bipolar Ring_PS:DCVD1,1,3,20.00,35.00,Bipolar Ring_PS:DCVD10,1,4,20.00,35.00,Bipolar

  7. Summary • An automated method is used for building power supply IOC software with information from a relational database.

More Related