[Pioneer Software]

Hi – I can confirm that the new SMS system should work in Nigeria.

Many thanks!

[Pioneer Software]

Hi Naz,

It sounds like you simply have some records stuck in the User Session Manager. You can “force remove” them from the VIEW | User Session Manager screen, or alternatively, you can follow these instructions to clear out the database logon table :-

1) Make sure everyone is logged out of ClinicOffice

2) Login as an administrator, go to the TOOLS menu and click Advanced DB Operation

3) Make sure the “As Administrator” check box is ticked, and delete any code present in this window

4) Copy & paste the code below into the “Advanced Database Operation” window

delete from logon

5) Click EXECUTE, then OK and close the window

Please post back to let us know if this resolves the problem.

[Pioneer Software]

This code will give you the Appointment ID in that event :-

using System.Data;

DataRow row = (Params[0] as DataRow);

long app_id = PSLib.cDBFuncs.ToLong(row["id"]);

[Pioneer Software]

Thanks for posting your solution Sean.

For other users reading this, please note that we don’t recommend that end-users use SQL to directly manipulate their database, unless you’re 100% sure that you know what you’re doing, since you could delete or update data irrevocably.

[Pioneer Software]

Hi – thanks for your question. Please follow these instructions to revert back to TextAnywhere…

1. Log on to ClinicOffice as an Administrator (aka ‘Supervisor’)
2. Go to the TOOLS tab (at the top), then click Advanced DB Operation
3. Delete any text present in this window
4. Copy and paste the text below into the “Advanced Database Operation” window :-

delete from setting where section='PioneerSMS'

Lastly click the EXECUTE button and then you must log off ClinicOffice and then log back on again.

This will revert you back to your previous TextAnywhere configuration!  🙂

[Author]

Posts