eFilm not querying MySQL database on localhost.

[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.

[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.

[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...

[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.

[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.

[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.

[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...

[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.

[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

[pacsone]

In that case, can you search only by patient id? i.e., uncheck the other search criteria like 'lastname', 'accession number', etc.

[JEFFWOLF]

Sorry- that isn't an option, at least on the version I have.

jeff

[JEFFWOLF]

Sorry, I spoke too soon.

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

Thanks.

[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.