Page 1 of 1

eFilm not querying MySQL database on localhost.

Posted: Tue Mar 08, 2005 4:49 am
by Antw1
I installed eFilm and PacsOne Premium on the same machine.
When querying the local PacsOne server, eFilm queries its own database instead on MySQL.
Any idea how to work this out ?
Thanks.

Posted: Tue Mar 08, 2005 1:17 pm
by pacsone
This seems like a eFilm configuration issue.

I'd think in order to configure eFilm to query an AE (e.g., PacsOne), you'd need to configure an entry in its AE table by setting up the AE Title, hostname, IP address and TCP port number.

If you find eFilm was querying itself, most likely the AE you've setup for eFilm to query has the wrong TCP port number, or even the wrong hostname/IP address, or both.

You can also verify if eFilm was indeed querying PacsOne by examining the PacsOne Server log to see if there's any incoming C-FIND connections to PacsOne when eFilm performed its querying.

Posted: Tue Mar 08, 2005 4:04 pm
by Antw1
I believe I configured PacsOne in eFilm properly since it can verify the DICOM connection and push/receive images from it.
I think it has more to do with the way eFilm connects to a database. For example, eFilm can query a remote database without being configured in the remote server as an AE.
Could it be the TCP port the database uses ? As opposed to the TCP port for the DICOM server...

Posted: Tue Mar 08, 2005 6:46 pm
by pacsone
This is news to me.

Are you saying that eFilm can query a MySQL database directly using SQL statements? i.e., a SQL query as opposed to the Dicom Query using C-FIND protocol. If so, this should be a question for eFilm support since it's not related to PacsOne Server.

Posted: Tue Mar 08, 2005 7:39 pm
by Antw1
The implementation model as depicted in the DICOM conformance statement shows that eFilm (eFilm.exe) queries the remote database directly (C-FIND) when the DICOM Server only receives queries and images pushed to it from remote AE.
So I don't know if it means, eFilm uses a different TCP port for its database or uses the same as the DICOM server... which I doubt.
I guess I'll try to sniff the network with a network analyser.

Posted: Tue Mar 08, 2005 8:13 pm
by pacsone
If eFilm is running Dicom queries using C-FIND, it's supposed to connect to the configured TCP port number of the remote AE, on the configured host/IP address where the remote AE is located.

For example, if you've configured a Dicom AE "dummy" which is running on IP address 192.168.2.1 Port 5678, then when you ask eFilm to query this AE "dummy", it should connect to Port 5678 on IP address 192.168.2.1 and send the C-FIND request. If eFilm was connecting to a different port or a different IP address, then eFilm has a bug to fix.

Posted: Tue Mar 08, 2005 8:17 pm
by Antw1
Sorry for being out of subject here. Discussion forums about these topics are hard to come by, and I know some of the members use PacsOne in conjuction with eFilm...

Posted: Wed Mar 09, 2005 6:10 pm
by pacsone
You can try using wild-card characters on one(1) search criteria, instead of using wild-card chars on all search criterias.

For example, if you want to search by Patient Name, enter '*' for Patient Name but leave out the '**' for Patient ID as well as the '*' for referring physician and '*' for accession numbers.

EFILM QUERY

Posted: Wed Mar 09, 2005 6:36 pm
by JEFFWOLF
Actually, that is the way that search was done. It appears Efilm inserts the * when you leave a search item blank. I put an * into the patientid field.

Jeff

Posted: Wed Mar 09, 2005 6:40 pm
by pacsone
In that case, can you search only by patient id? i.e., uncheck the other search criteria like 'lastname', 'accession number', etc.

efilm

Posted: Wed Mar 09, 2005 6:45 pm
by JEFFWOLF
Sorry- that isn't an option, at least on the version I have.

jeff

I spoke to soon

Posted: Wed Mar 09, 2005 6:57 pm
by JEFFWOLF
Sorry, I spoke too soon.

I removed the wildcard option and it looks like it works fine.

Thanks.

Posted: Wed Mar 09, 2005 10:26 pm
by Antw1
Jeff, I'm impressed. I never heard of eFilm 1.4... It was a freeware up until version 1.5.3 as far as I know.
Would you mind sharing it with me ? Could you send it as email attachment ?
Here is my email address: AntnUsa_at_aol_dot_com.
Thanks a lot.