SynapseDirect

Sorry ... try http://compkarori.com/emr/beta/synapse-server.exe

---

Graham Chiu
Beta Downloads and Documentation Wiki
Developer Forum

Finally got the 171 server build in place.

I got the same error as before. Below is the metadata from the server screen.

 

]
surname: "ALLEN"
fnames: "LAKARRA L"
userid: "1133767"
pmsid: "1133767"
street1: "13962 LEATHERGLASS"
state: "TX"
zip: "75110"
ssn: "000008123"
homeph: "9032292440"
workph: ""
dob: 11-Aug-2006
gender: "F"
primaryinsurance: "TMHP TEXAS HEALTH STEPS"
secondaryinsurance: "undefined"
physician-lastname: "SMITH"
physician-firstname: "JOHN"
referring-physician-lastname: "WHITE"
referring-physician-surname: "ERIC"
raw message

Ok.  I still need to see the database table metadata, or definition.

You can use a program like IBOconsole to login to the Firebird database and examine the users table and grab the sql metadata.

This is to see if your table is correct or needs updating.

 

---

Graham Chiu
Beta Downloads and Documentation Wiki
Developer Forum

I was not able to add a patient even thru the normal add patient interface which suggests that the database you sent me is corrupted.

You could try one of the Firebird database repair utities, or, just download a new blank database since you only have the one patient in it.

 

---

Graham Chiu
Beta Downloads and Documentation Wiki
Developer Forum

For beta versions check http://www.compkarori.com/emr/beta/

DrO 

I'm told that I should be importing both the PMS id and the SSN when doing HL7 imports.  This note to remind me!

---

Graham Chiu
Beta Downloads and Documentation Wiki
Developer Forum

Have you been able to complete a bidirectional interface with medisoft?

Didn't start it.  It's a low priority as there doesn't seem to be any demand.

 

---

Graham Chiu
Beta Downloads and Documentation Wiki
Developer Forum

Graham:

I would like to import all Diagnoses for each of my patients. Can you rig up a routine for importing these diagnoses(ICD-9 codes) as you did for PATIENT IMPORT?

It could be CHART NUMBER followed by up to 10 ICD-9 codes or CHART NUMBER, DX, DATE of diagnosis <--- more attuned with  Synapse.

In the same vein, perhaps you could help us import Meds: CHART NUMBER and Medications ( 10-15 meds) 

For some of us this would be very helpful. Some of the Tech Members might be able to use these routines to help others migrate to Synapse.

Thanks,

DrO 

Perhaps you could show me some sample data ?

---

Graham Chiu
Beta Downloads and Documentation Wiki
Developer Forum

?

---

I'm working at half mast today, I think my ESR is higher than Grahams :( Dx: URTI vs. Flu.

Patient’s date of birth (format: mmddyyyy).

Excel doesn't have this as a default .. but you can do custom formats.

---

I'm working at half mast today, I think my ESR is higher than Grahams :( Dx: URTI vs. Flu.

Wow. Got it done.

There was much trouble making the appropriate .csv file as Excel doesn't create what is needed.

I suggest the following additions:

allowing double-quoteless blanks.

ie. allow ,,  not force ,"",

The vast majority of new users will be generating .csv files from MS Excel.

Other realizations:

(1) you must have 16 entries per patient - or the importing fails.

(2) only blanks need double quotes to allow importing.

(3) generating a .csv file with the current restrictions would be fairly difficult.

(4) importer performed very well once I got the right .csv format.

 

 

---

I'm working at half mast today, I think my ESR is higher than Grahams :( Dx: URTI vs. Flu.

I am pretty sure that Synapse actually *DELETES* any .csv file that it tries to import !  Very Dangerous !

---

I'm working at half mast today, I think my ESR is higher than Grahams :( Dx: URTI vs. Flu.

Yes, Synapse deletes the csv file ASAP so there's no chance of it being imported again.  Very Safe!

 

---

Graham Chiu
Beta Downloads and Documentation Wiki
Developer Forum