[clinicoffice_user]

Brilliant – have taken your advice and updated all records. Thanks,

[clinicoffice_user]

HI Josh,

Although I can see the tick box for inactive records in the grid, i’ve realised I don’t actually know how to set a record to inactive.  Could you provide details of how to please, thanks, Anne

[clinicoffice_user]

Thanks. we are running Bitdefender, but still have constant drop outs so it must be another problem?

 

Today we are unable to connect to the database from one of the network computers, I am opening a new discussion for it.

[clinicoffice_user]

No error message.  When trying to choose one practitioner – it shows zero result.  When I chose no practitioner then it shows all results.  But would like to see results per practitioner.  Which until recently I was able to do.

[clinicoffice_user]

Thanks Joshua, that worked and was easy to do. CO must have lost the pathway somehow.

All good now, thanks again.

[clinicoffice_user]

Hi – thanks – it was a PC issue to do with the hard drive – solved by running a disk scan.

[clinicoffice_user]

Hi I have emailed Physiapp re integration with Clinic Office. They sent met his reply.

Hello Stephen,

Thank you for your email. I’d be happy to assist you.

Physitrack is always welcome to new integrations. This is a great way to combine both systems and make Physitrack an essential tool in your clinic. Please contact a Clinic Office administrator and advise them of your interest in integration with Physitrack, and please provide their details in your next response. Our development team will take it from there.

We look forward to hearing from you!

Kind regards,

Raul PerojoDevelopment Executive
Physitrack Limited
rp@physitrack.com

[clinicoffice_user]

In a last attempt to figure this out, after many days to get this fixed myself, I started up the Front Desk computer 5 minutes ago and started CO5. The last diary view setting was month view so I started with clicking on a random weeknumber in the small calendar on the right side, and it simply worked.

I have the view exactly as I want it and it behaves just like the Server Computer now. I wish I knew why but I am mostly happy it just does it now.

Thank you.

[clinicoffice_user]

Thank you for your reply Joshua,

I know that the diary views differs, this is because it happens automatically 🙁 and it seems like I have no control over this.

In my original post I tried to explain as good as possible what happens with the diary view when I do certain actions (see under Question 2). I thought when I upgraded the software it will be exactly the same on my new computer as on the computer it was first installed on. But as I mentioned in Question 1, this is not the case.

The software on the new computer (Front desk) also behaves differently than the Server Computer, as described in Question 2.

What can I do to get some assistance in this matter because it really frustrates the ease of work on a daily basis.

 

 

 

[clinicoffice_user]

Never mind, the Task List report gives me everything I need to write the sql

select

task.id as task_id,
task.name as description,
task.due,
(case task.priority
when 1 then 'High'
when 2 then 'Normal'
when 3 then 'Low'
else 'UNKNOWN' end) as priority,
task.iscompleted as completed,
task.notes,
task.clinic_id,
clinic.name as _clinic,
link.ref_per_id as patient_per_id,
@NAME:per as _patient_link,
taskstaff.staff_id,
staff.knownas as _staff_assigned

from task

left join clinic on (clinic.id=task.clinic_id)
left join link on (link.task_id=task.id and link.ref_per_id is not null)
left join per on (link.ref_per_id=per.id)
left join taskstaff on (taskstaff.task_id=task.id)
left join staff on (taskstaff.staff_id=staff.id)

[clinicoffice_user]

thank you. That works brilliantly.

[clinicoffice_user]

Hi Josh

Would you be able to advise which tables require updating? ‘Tasks’ is obvious but I don’t see which table is used to associate it with a row in Per.

thanks

Sean

[clinicoffice_user]

Thank you for having all this info available on the forum!! This helped me 7 years after it was posted 😀

[clinicoffice_user]

Looking for other information I stumbled upon a post made July 5, 2016 at 10:57 am #31604 by
William (Keymaster) : “Here is a Multi Appointment Confirmation Slip report. It is similar to the default “Appointment Confirmation Slip”.. This is exactly what I was looking for! It just didn’t show up with the search criteria I entered when I first started searching. This file works perfectly.

Thank you!

[clinicoffice_user]

Thank you very much! I still have to take some time to set it up completely but it is doing what I want it to do. The only way it works right now is if I am in the “reports & templates” screen and select the template I created and click on “Run report”. I select from which date I want the document to show the appointments (only future dates for eg.) and search for the patient, select patient and click “ok”. It creates the desired document containing all the info I need. Perfect.

Two questions remain for now:

I saved the template I created twice. Once in category “patients” and once in category “appointments”.

1. Is there a way to get this (future) appointment overview to print from a patient’s appointment screen? For eg. I have patient X planned at 1pm on sept 13th. I open that specific appointment from Diary and go to “print”. All I see there is “appointment confirmation slip”. Is it possible to make my template visible there and have it do exactly as I described above?
2. Is there a way to get this (future) appointment overview to print from a patient’s file? So I go to “patients” screen. Right click on the patient and choose “open patient”, choose “appointments” tab and click “print”. I get different options there like “print this screen” (not what I am looking for) and “financial”, “letters” and “patients”. In the “patients” folder there is only the option “address (envelope DL)”. Is it possible to make my template visible there and have it do exactly as I described above?

[clinicoffice_user]

Hi William,

That is great. Just what I wanted. 🙄

Steve

[clinicoffice_user]

Follow-up to my earlier messages about database update problems.

I looked on the forum for other ElevateDB problems and followed the advice to run the DB Check and Repair tool.

This fixed it!!

[clinicoffice_user]

Follow-up to my message of 2:52 July 16.

I have now rebooted my machine and CO will start.  I’m back to the original problem that the database won’t update.  I get the error message

“Elevate.ElevateDB.Data.EDBException: ElevateDB Error #1004 The column in the table emailarchive cannot be NULL…..”

Any advice?

[clinicoffice_user]

the task list is a great option in CO. Nevertheless, I am losing sight of the upcoming items. Therefore it would be awesome when they would show up in de diary. On the moment of completion, or a couple of days ahead of completion.

[clinicoffice_user]

NicE!!!! Can’t wait!

[clinicoffice_user]

Thanks for your help Josh, even if it wasn’t the answer I was hoping for.

[clinicoffice_user]

Hi Josh,

Thanks for the quick reply. I’m happy to dump Outlook 2007 and to use Google Calendar instead, unfortunately I haven’t been able to do so.
When I right click on my diary I get this:

The only option available is Outlook which if I select that opens this screen:

The drop down menu at the top is greyed out and inaccessible. When I bought clinic office, and the calendar sync module, Google calendar wasn’t really a thing and Outlook was the only option. Was it called Outlook sync in 2009? Did the module get updated automatically along with the Clinic Office IV automatic upgrades?
Obviously as I reinstalled Clinic Office yesterday I have the latest version. Is my Clinic Office license stuck in 2009?

Maybe I’m missing something very simple. I did download Chrome with the Calendar add on in case Microsoft Edge was the problem. But still no joy.

Jon

[clinicoffice_user]

Thanks, problem solved , kindly advice on how to prevent reoccurrence in the future.

Regards

[clinicoffice_user]

Hello Williams,
The patients financial record is missing, all records of previous appointments is also missing. How can I restore them.

[clinicoffice_user]

Thanks, I can now open the patients record. Please is this operation suppose to wipe the patients data? As I can’t seem to see his previous stored records. (Financial, appointments e.t.c)

[clinicoffice_user]

Yes, I have always been using normal compression

[clinicoffice_user]

File has been successfully uploaded, find attached image
[attachment=0:owi910j5]15BA7E70-1E4D-4F90-B1B4-FCE6949E5342.jpeg[/attachment:owi910j5]

[clinicoffice_user]

Hello William,

Find attached the error encountered during data upload[attachment=0:3o31ur9o]82BC50AF-349E-47AD-9ACA-BBF9937951C3.jpeg[/attachment:3o31ur9o]

[clinicoffice_user]

Thanks Williams, to back up my data, I logoff then perform backup operation, the system will not allow me perform a backup when I am logged on.
I followed the instructions recommended but I still encountered the eeeor message #1004 on attempt to optimize my data.

[clinicoffice_user]

[attachment=0:1hf9soqf]FEACEA43-CEB9-4DFD-A609-B29A7B42F3F4.jpeg[/attachment:1hf9soqf]
I tried optimizing my database as recommended in one of the links, but I received the attached message at about 82% into the optimization

[clinicoffice_user]

The link specified is on how to use the consent manager

[clinicoffice_user]

Thank you so so much William, I have had sleepless night over this issue, i wish you had come to my rescue a bit earlier. “ it’s better late than never” Thanks my issues are now resolved, I pray it never happens again. =D>
Also, kindly notify me whenever your New SMS service becomes available/compatible with my region NIGERIA. Thanks

[clinicoffice_user]

This is called .ics

[clinicoffice_user]

Hi great idea to have this reviewed! I would like to add that it would be really convenient to be able to sync the diary’s to my phone for instance. I could then directly book appointments from there. Without having to login to my CO (2 way sync).

[clinicoffice_user]

With the new law in place, I feel there is no room anymore for my online-forms/online-questionaires. Do you see any possibilities in a module as mentioned above? Or do you maybe have some other options to explore?

[clinicoffice_user]

Hello support team, I tried to import appointment into my database using csv file but I got validation failed message with error “one or more records contain invalid data in the field ‘start’
Also on attempt to import staff, validation also failed with message “ Required field ‘lastname’ Is missing from import file. Even when I can see lastname in the spreadsheet when opened.

Thanks

[clinicoffice_user]

Hello, I posted an error message encountered 2 days ago. So far I haven’t got any response, I have explored all options related to my challenge as indicated on the forum. This issue has prevented me from utilizing the software effectively. Kindly assist.

Thank you.

[clinicoffice_user]

Many thanks. Your suggestion has fixed the problem.

[clinicoffice_user]

Refund acknowledged with thanks, kindly notify me whenever this service becomes available in in my country NIGERIA.

[clinicoffice_user]

Hello, am still having the same problem. I have done check and repair but the problem still remains

[clinicoffice_user]

Thank you for your reply,
I have naturally made sure the details are correct and have tried a number of different email addresses but to no avail.

[clinicoffice_user]

Thank you for the reply.
There is no option to email error.
When I try to send reminders either for individual appointments or through a pre-organised contact rule, this message comes in

[clinicoffice_user]

Hello Again,
Still no luck with this.
Can you give any advice please?

[clinicoffice_user]

Hi, Josh

Thank you for your input!

Since I posted my question, we moved our clinic to another location where security is very tight. So until now we are unable to connect to Clinic Office. My excuse for late input.

I understood that the field is numeric and not changeable. We will use this number as unique patient ID then.
Have a nice day!

Kind regards,

Kazumi

[clinicoffice_user]

To maintain data security and be GDPR compliant, it is likely we are going to have to delete personal data from records. Is it possible to do this without deleting the complete clinical record?
Thanks
Clive

[clinicoffice_user]

That’s fantastic news – thank you! 😀

[clinicoffice_user]

That’s Brilliant, Thank you!

[clinicoffice_user]

Hi

The issue is that the server is running v 1085, the PC I have installed clinic office on will only upgrade to v 1079. So to me that looks like the server is running a new version? How do I get my new PC on the same version as my server?

[clinicoffice_user]

Hello.
Is there any way of having patients names included in this detailed summary at all?

[clinicoffice_user]

This appears to happen every time the computer is reactivated from screen saver, so fairly often yes.
The antivirus is AVG.

[Author]

Posts