Hi Alex, Sorry, lost the thread of this a bit now. Did you run the posted report? Did it work? Why did you show me that SQL? Bart...
5354
alex carsley
alexcrsly
Mar 21, 2013 2:37 pm
Ok, I posted a question to ask if there was a way of getting a list of all our patients that have Repeat Dispensing i.e. anyone with Current meds that are...
5355
alex carsley
alexcrsly
Mar 21, 2013 2:39 pm
Ok, I posted a question to ask if there was a way of getting a list of all our patients that have Repeat Dispensing i.e. anyone with Current meds that are...
5356
Bart Smissaert
bartsmissaert
Mar 21, 2013 2:43 pm
Hi Alex, Yes, the posted report should do that Bart...
5357
alex carsley
alexcrsly
Mar 21, 2013 3:19 pm
It did but you weren't happy that it took 48mins.........
5358
Bart Smissaert
bartsmissaert
Mar 21, 2013 3:27 pm
Hi Alex, Was this the report with the SQL node? Bart...
5359
Bart Smissaert
bartsmissaert
Mar 21, 2013 5:19 pm
If it was the one with the SQL node then try the attached report, which minimizes the strain on Firebird and let SQLite do some of the work. Bart...
5360
Anne Crowe
paulscrowe...
Mar 22, 2013 4:25 pm
Bart, Thank you for all your help in the past, please keep my contact details and let me know when you have something that runs with Emis! Kind regards, Anne...
5361
Bart Smissaert
bartsmissaert
Mar 28, 2013 11:30 am
Attached a report that will list your discontinuations with reasons Allergy and Intolerance, to do with the data conversion to Emis web. As I understand it...
5362
alex carsley
alexcrsly
Apr 11, 2013 9:18 am
Hi All, I'm trying to run a report on all our Nursing Home patients past and present and I think the best way for me to identify these patients is by using the...
5363
Bart Smissaert
bartsmissaert
Apr 11, 2013 9:44 am
Hi Alex, What you need here is an IN condition and that would be like this: where postcode in ('WV6 9DH', 'WV6 8LG', 'WV3 8JX') Unfortunately the search box in...
5364
Bart Smissaert
bartsmissaert
Apr 11, 2013 9:56 am
One thing to add to this: If the XTR field is numeric then the comma separated list will work, so it will make the proper IN condition. This could work with ...
5365
alex carsley
alexcrsly
Apr 11, 2013 10:27 am
Hi Bart, That worked really well!! I did consider the Residential Institute codes as well but I do tend to find the odd patient here and there without the code...
5366
Bart Smissaert
bartsmissaert
Apr 11, 2013 10:36 am
Yes, I didn't think the method with RESIDENTIAL_INSTITUTE would work. I will upload a new version in a bit and that will allow you to put that IN condition in...
5367
bartsmissaert
Apr 11, 2013 11:32 am
A number of changes in this one: 1. Now using the latest SQLite version 3.7.16 2. A new version of vbRichClient (thanks to Olaf Schmidt), now version 5.0.0.4...
5368
alex carsley
alexcrsly
Apr 12, 2013 3:17 pm
Thanks Bart....
5369
George Knox
george_h_knox
Apr 28, 2013 2:42 am
Single Mom Makes $89,844/Yr in Her Spare Time on The Computer Without Selling Anything http://www.readersquotient.com/hwork56.html 4/28/2013 3:42:20 AM...
5370
Hayden Dennis (LODDON...
thealeuk
May 1, 2013 10:08 am
Brain dead as usual. Can I please have instructions on how to link Repaid to Excel 2010. Ta Den ...
5371
Bart Smissaert
bartsmissaert
May 1, 2013 10:49 am
Hi Dennis, From mobile: You need to go to the add-in menu, which I think is under the left-most toolbar button. Then browse to ...
5372
Bart Smissaert
bartsmissaert
May 1, 2013 1:51 pm
Hi Dennis, Just had a look and the required menu is under File, Options, Add-ins. Bart...
5373
Hayden Dennis (LODDON...
thealeuk
May 21, 2013 3:49 pm
I have a strange one here, but perhaps not as we have just gone to Office 10. I have been given a deceased patients report that have been deducted where there...
5374
Bart Smissaert
bartsmissaert
May 21, 2013 4:18 pm
Hi Dennis, Could you mail me the workbook and I will have a look. Regards, Bart...
5375
Hayden Dennis (LODDON...
thealeuk
May 23, 2013 11:15 am
I'm just holding off on this. I think there is a problem with OENs to PIDs but the spreadsheet I have been sent by EMIS has a mixture of OENs and PIDs which...
5376
Bart Smissaert
bartsmissaert
May 23, 2013 12:15 pm
Hi Dennis, OK, will look at this later. When you have chance mail me a SQLite DB of all your PID and OEN's like this: In Rep-Aid, SQL node: select patient_id, ...
5377
Lowes John (NHS SURRE...
drjohnlowes
May 30, 2013 3:01 pm
Hi Bart Are you going to be doing anything with Emisweb? Something like Repaid F12 to get from a spreadsheet into the patients notes would be helpful. Many...
5378
Bart Smissaert
bartsmissaert
May 30, 2013 4:56 pm
Hi John, The plan is to get the full functionality back, definitely the F12 function. The main thing that probably won't be possible is the plain SQL on the...
Hi John, I have put together a little add-in that will do the F12, so load the patient in Emis from the Emis number in the active cell (the selected cell) in...
5381
Val
valjhnsn
Jun 11, 2013 9:25 am
We are migrating to Systm1 with a go-live date of June 20th. I couldn't say farewell without posting part of a message sent to Bart privately. 'I wanted to...
5382
Bart Smissaert
bartsmissaert
Jun 11, 2013 9:34 am
Hi Val, Thanks for that, really appreciated. Good luck with System One! Regards, Bart...
