Some minor improvements and as requested added the option to move a node in the treeview up or down amongst it's sibling nodes. This goes with a right-click on...
Two new things in this version: 1. After a (semi-) request for this added another DB writing utility that can merge 2 different patients. This for the not that...
With the routine to merge 2 patients I had overlooked that not all users have Torex appointments, so they then don't have the table AP_DATE, causing an error...
Some further fixes to do with the utility to merge 2 different patients. The problems were to do with the fact that I have tables in the database (Torex appts...
Just to say that the option to merge 2 patients has now been fully tested on our live database (merged several real patients) and it all works fine and as...
Made a new Options menu as the old one had several drawbacks, mainly the fact that if you clicked an item the menu was gone and you had to go all the way back...
This is now the regular version. Added one extra section to the new menu and that deals with the SQLite report database and that is in the Files and folders...
Some more fixes and improvements to the new menu. Also lots of editing options directly from the menu (as compared to dumping to Excel, editing and putting...
API login (where you don't have to type in your login credentials when Synergy is running) wasn't picked up, so it offered the login dialog when you didn't...
Fixed a bug to do with moving data manually from Firebird to SQLite via the SQL node. Added the option to encrypt a SQLite database file with a password. This...
Added a better message when you tried to save a report file with an invalid name, eg HPV 9/10. It will now clearly tell you what the problem is. Some further...
On some systems the new options menu fixed controls (treeview and buttons at the bottom) could come out slightly wrongly positioned and there is now a button...
One minor fix to do with the new options menu. In the new menu the buttons have now in the right-click menu, Show procdure the option to go directly to that...
Some more items added to the new menu, so a new file Options.db3. Also the option now to start with the node in the options menu that was accessed last. This...
Hi Bart, One of our staff marked a couple of pathology actions as done before she had done them and hadn't made a note of which patients. We know roughly what...
Hi Bart, This is done and recorded in GPP Links - ie GP adds an action to a result in GPP links, admin staff then process the actions folder in GPP Links. It...
Hi Paul, Could you simulate the situation (say with Mickey Mouse) you are trying to detect and tell me how can recognize it in Synergy? I think that this can...
See if running a plain SQL like this gives you any insight. Not tested as I am off to work now, but will run later at work. You need to alter the dates and the...
Thanks for the inspiration Bart. You're right. I didn't need the audit trail. I searched for free text "%done%" and receptionist's initials in all of the...
Hi Bart, Is it possible to search by updated date in RepAid then? The SQL you posted didn't find any rows when I changed the staff number or deleted that row. ...
Hi Paul, Just add a SQL node and in the SQL box put something along these lines: select e.patient_id, e.entry_id, e.read_code, e.term_text, e.added_date, ...
If I am searching for drugs that were issued between 1 3 08 - 31 3 09, which option from the drop down box do I choose, e.g issue, current med etc, and do I...