pgEdit is a combination of server-side scripts and a Java applet designed to modify an AccelNET database graphically. The goal of pgEdit is to allow someone with less console and/or SQL experience to make simple changes to AccelNET.
Although this application is not yet complete, it is quite functional in its current state. If you encounter problems/bugs with this application, please contact NEC with a description of the problem so that it may be addressed.
All of the commonly edited tables have basic insert, update, and delete abilities. The following commands have also been implemented: dbconvert all, buildmb all, convertX, and convertY. The following reports may also be generated and viewed: Module, CAMAC, Alarms, Label, RecId, M&B, Limits, JackRec, RPrecord, and Zrecord.
Note
Because pgEdit is still under development, it may not have been installed and/or configured on your control system. Please contact NEC if you wish to test this software.
TODO: write me!
pgEdit can be accessed using a Java[5] enabled web browser such as Mozilla, FireFox, Safari, Opera, NetScape, or Internet Explorer. The following is a set of directions on how to access the editor.
Open your Java enabled web browser.
Point the browser to the control system's hostname. If you are seated at the control system, the hostname 'localhost' will work.
You will be presented with a web page tailored for AccelNET. Across the top will be the contract name, accelerator type, and the wording "AccelNET Control System Home Page." Several menus will be lined down the left side of the page. These menus include accelerator status views, dosimetry information, documentation, and pgEdit.
Scroll down the page to the bottom so that the Database Tools menu is visible.
Single-click on "Database Editor."
You are now presented with a login form.
Fill in the fields and click the "Login" button.
The hostname should have been filled in for you. Click the dropdown menu to select the contract you wish to edit. In most cases, there will only be one option. The 'postgres' username should be used with no password.
At this point, the Java applet should load.
Single-click the "Connect" button to connect to the database.
The status bar at the bottom will display a message stating it is connected.
Single-click the "(Re)Load" button to load the database into pgEdit.
The user interface should be fairly easy to learn. The database table names are listed as a series of tabs along the left side of the applet. Across the top you will find buttons to perform global functions. The following is a list of the buttons and what they do:
- Connect(Disconnect)
Connects/Disconnects to/from the Postgres database.
- (Re)Load
Retrieves the tables and populates pgEdit with the latest values. This should be clicked after major deletions and updates.
- Refresh Rec
Retrieves and populates the currently displayed screen with the latest values. This is helpful if you made a mistake and noticed it before you submit an update.
- Update Rec
Updates the database with the currently displayed information. This should be clicked after making any changes before continuing to another parameter/table.
- Delete Rec
Removes the currently displayed record from the database permanently.
- Insert Rec
Inserts the currently displayed record to the database permanently.