Thanks for everybody's help - the importconverter rules worked great - that takes a load off. Thank god for conquest!
keep up the good work Marcel and everybody in the forums - thanks for answering questions. hopefully we can get rid of that spammer? 
All of these studies (90,000 give or take) are coming in from antoher site we are taking over. The techs had to hand type in all of the info... normally the patient ID's should be six digits (123456_SJS), but with typos we have some that are seven and some that are eight digits long. Is there anything that we can do in this situation?
Thanks
I have a number of studies that I need to import from a different system that all contain a '_SJS' at the end of the patient ID for every exam.
Can the import converter strip off data at the end of the patient ID as in the following example?
importconver0 = ifmatch "%i" "*_SJS" delete
I may have used the wrong command, but the '_SJS' is at the end of the patient ID, I just want the importconverter to strip off the '_SJS' that is at the end of every patient ID and be left with the value that is infront of that.
Thanks!
Marcel,
I just tried with alpha 3 and here is the error I get with Conquest:
Study Level Query:
& here is the radstore error:
2010/04/16 16:21:06.671: <I> [CS,SCP-10724] RADARCH3: Received association request from AE-Title CONQUEST
2010/04/16 16:21:06.906: <W> [AS,STOR-942925] SQL Query contains unknown attribute in select :StudyStateText
2010/04/16 16:21:06.921: <I> [AS,STOR-942925] SELECT DISTINCT TOP 120000 [00080005], [00080020], [00100010], [00100020], [StudyState] FROM tblDICOMStudy WHERE [00100020] = N'9301482'
2010/04/16 16:21:06.921: <I> [CS,SCP-10724] Query: AE peer: CONQUEST, maximum results reached: 0, #results: 9
Marcel,
Looks like this has already been looked into on this thread:
http://forum.image-systems.biz…cf865fc9bf08bb18152#p7264
Radstore is actually renamed to Centricity Enterprise Archive after GE purchased applicare a long time ago.
I am going to try alpha 3 now.
--thanks for all of your help on this
Marcel,
On the query/move tab, the only button close to 'move' is 'Copy to destination' and it gives me the same error -- I am using v1.4.15
So, what you saying is if it doesn't work in the GUI is that it probably won't work from the command line with dgate?
Move requests? I don't follow what you mean? Are you talking about using dgate from the command line?
Marcel,
This is the error that we get on conquest for each query:
& here are the logs from RADARCH for each query:
Query Level: PATIENT:
2010/04/15 10:07:40.000: <I> [CS,SCP-46975] RADARCH: Received association request from AE-Title RADARCH42010/04/15 10:07:40.000: <I> [CS,SCP-46975] Connecting to archive RADARCH2010/04/15 10:07:40.000: <W> [CS,SCP-46975] Requested SOP not supported: 1.2.840.10008.5.1.4.312010/04/15 10:07:40.093: <I> [AS,STOR-141054] Query returned 2 results2010/04/15 10:07:40.093: <I> [CS,CSPR] Submitted 0 jobs2010/04/15 10:07:40.093: <I> [AS,STOR-141054] Unregister done for DICOM.3.02010/04/15 10:07:40.093: <I> [CS,CSPR] Sending trigger to PRouter to route images from client RADROUTE2010/04/15 10:07:40.234: <I> [AS,STOR-141060] Register called for DICOM.3.0, in archive RADARCH2010/04/15 10:07:40.250: <I> [AS,STOR-141060] SELECT DISTINCT TOP 50 [00080005], [00100010], [00100020] FROM tblDICOMStudy WHERE [00100020] = N'5500855'2010/04/15 10:07:40.250: <I> [CS,SCP-46975] PFM: C-FIND SCP Start response2010/04/15 10:07:40.250: <I> [AS,STOR-141060] Query2 returned 2 results2010/04/15 10:07:40.250: <I> [AS,STOR-141060] Unregister done for DICOM.3.02010/04/15 10:07:40.250: <I> [CS,SCP-46975] Query: AE peer: RADARCH4, maximum results reached: 0, #results: 22010/04/15 10:07:40.562: <I> [CS,SCP-46975] C_FIND request from RADARCH4 was handled in 703 ms2010/04/15 10:07:40.562: <I> [CS,SCP-46975] stopping thread: SCP-46975: SCP id = 0x9b4 handle = 000008F82010/04/15 10:07:40.562: <I> [CS,SCP-46975] association was active for 0.703 secondsQuery Level STUDY:
2010/04/15 10:10:29.421: <I> [CS,SCP-47019] RADARCH: Received association request from AE-Title RADARCH42010/04/15 10:10:29.421: <I> [CS,SCP-47019] Connecting to archive RADARCH2010/04/15 10:10:29.421: <W> [CS,SCP-47019] Requested SOP not supported: 1.2.840.10008.5.1.4.312010/04/15 10:10:29.656: <I> [AS,STOR-141143] Register called for DICOM.3.0, in archive RADARCH2010/04/15 10:10:29.656: <W> [AS,STOR-141143] SQL Query contains unknown attribute in select :StudyStateText2010/04/15 10:10:29.656: <I> [AS,STOR-141143] SELECT DISTINCT TOP 50 [00080005], [00080020], [00100010], [00100020], [0020000D], [StudyState] FROM tblDICOMStudy WHERE [00100020] = N'5500855'2010/04/15 10:10:29.656: <I> [CS,SCP-47019] PFM: C-FIND SCP Start response2010/04/15 10:10:29.671: <I> [AS,STOR-141143] Query2 returned 17 results2010/04/15 10:10:29.671: <I> [AS,STOR-141143] Unregister done for DICOM.3.02010/04/15 10:10:29.671: <I> [CS,SCP-47019] Query: AE peer: RADARCH4, maximum results reached: 0, #results: 172010/04/15 10:10:29.984: <I> [CS,SCP-47019] C_FIND request from RADARCH4 was handled in 766 ms2010/04/15 10:10:29.984: <I> [CS,SCP-47019] stopping thread: SCP-47019: SCP id = 0x9b4 handle = 000009D42010/04/15 10:10:29.984: <I> [CS,SCP-47019] association was active for 0.766 seconds2010/04/15 10:10:29.984: <I> [CS,SCP-47019] number of bytes stored: 02010/04/15 10:10:29.984: <I> [CS,SCP-47019] average throughput: 0 bpsQuery Level Study - StudyRoot
2010/04/15 10:12:45.375: <I> [CS,SCP-47079] RADARCH: Received association request from AE-Title RADARCH42010/04/15 10:12:45.375: <I> [CS,SCP-47079] Connecting to archive RADARCH2010/04/15 10:12:45.375: <W> [CS,SCP-47079] Requested SOP not supported: 1.2.840.10008.5.1.4.312010/04/15 10:12:45.734: <I> [AS,STOR-141214] Register called for DICOM.3.0, in archive RADARCH2010/04/15 10:12:45.750: <W> [AS,STOR-141214] SQL Query contains unknown attribute in select :StudyStateText2010/04/15 10:12:45.750: <I> [AS,STOR-141214] SELECT DISTINCT TOP 50 [00080005], [00080020], [00100010], [00100020], [0020000D], [StudyState] FROM tblDICOMStudy WHERE [00100020] = N'5500855'2010/04/15 10:12:45.750: <I> [CS,SCP-47079] PFM: C-FIND SCP Start response2010/04/15 10:12:45.750: <I> [AS,STOR-141214] Query2 returned 17 results2010/04/15 10:12:45.750: <I> [AS,STOR-141214] Unregister done for DICOM.3.02010/04/15 10:12:45.750: <I> [CS,SCP-47079] Query: AE peer: RADARCH4, maximum results reached: 0, #results: 172010/04/15 10:12:46.078: <I> [CS,SCP-47079] C_FIND request from RADARCH4 was handled in 907 ms2010/04/15 10:12:46.078: <I> [CS,SCP-47079] stopping thread: SCP-47079: SCP id = 0x1c4 handle = 00000DDC2010/04/15 10:12:46.078: <I> [CS,SCP-47079] association was active for 0.907 seconds2010/04/15 10:12:46.078: <I> [CS,SCP-47079] number of bytes stored: 02010/04/15 10:12:46.078: <I> [CS,SCP-47079] average throughput: 0 bpsQuery Level Patient - PateintStudyOnly
2010/04/15 10:14:12.765: <I> [CS,SCP-47109] RADARCH: Received association request from AE-Title RADARCH42010/04/15 10:14:12.765: <I> [CS,SCP-47109] Connecting to archive RADARCH2010/04/15 10:14:12.765: <W> [CS,SCP-47109] Requested SOP not supported: 1.2.840.10008.5.1.4.312010/04/15 10:14:13.015: <I> [AS,STOR-141256] Register called for DICOM.3.0, in archive RADARCH2010/04/15 10:14:13.031: <I> [AS,STOR-141256] SELECT DISTINCT TOP 50 [00080005], [00100010], [00100020] FROM tblDICOMStudy WHERE [00100020] = N'5500855'2010/04/15 10:14:13.031: <I> [CS,SCP-47109] PFM: C-FIND SCP Start response2010/04/15 10:14:13.031: <I> [AS,STOR-141256] Query2 returned 2 results2010/04/15 10:14:13.031: <I> [AS,STOR-141256] Unregister done for DICOM.3.02010/04/15 10:14:13.031: <I> [CS,SCP-47109] Query: AE peer: RADARCH4, maximum results reached: 0, #results: 22010/04/15 10:14:13.343: <I> [CS,SCP-47109] C_FIND request from RADARCH4 was handled in 718 ms2010/04/15 10:14:13.343: <I> [CS,SCP-47109] stopping thread: SCP-47109: SCP id = 0xe9c handle = 00000D7C2010/04/15 10:14:13.343: <I> [CS,SCP-47109] association was active for 0.718 seconds2010/04/15 10:14:13.343: <I> [CS,SCP-47109] number of bytes stored: 02010/04/15 10:14:13.343: <I> [CS,SCP-47109] average throughput: 0 bpsQuery Level STUDY - PatientStudyOnly
2010/04/15 10:15:44.421: <I> [CS,SCP-47129] RADARCH: Received association request from AE-Title RADARCH4
2010/04/15 10:15:44.656: <W> [AS,STOR-141304] SQL Query contains unknown attribute in select :StudyStateText
2010/04/15 10:15:44.656: <I> [AS,STOR-141304] SELECT DISTINCT TOP 50 [00080005], [00080020], [00100010], [00100020], [0020000D], [StudyState] FROM tblDICOMStudy WHERE [00100020] = N'5500855'
2010/04/15 10:15:44.671: <I> [CS,SCP-47129] Query: AE peer: RADARCH4, maximum results reached: 0, #results: 17
Marcel -
We tried it and here is the error we get on radstore or the device with the AE of 'RADARCH'. The AE 'RADARCH4' is conquest.
2010/04/15 08:37:11.750: <W> [AS,STOR-139247] SQL Query contains unknown attribute in select :StudyStateText
2010/04/15 08:37:11.750: <I> [AS,STOR-139247] SELECT DISTINCT TOP 50 [00080005], [00080020], [00100010], [00100020], [0020000D], [StudyState] FROM tblDICOMStudy WHERE [00100020] = N'5500855'
2010/04/15 08:37:11.750: <I> [CS,SCP-46449] Query: AE peer: RADARCH4, maximum results reached: 0, #results: 17
It appears to be complaining about a SOP not being supported. Would there be any way around that?
Thanks for your help!
maybe radarch won't accept a patient root query from conquest? Is there a way to send it a study root query maybe?
can I use wildcards inside the quotes, like "JANE*" with ifmatch?
example: importconverter10 = ifmatch "%V0008,0080","JANE*"; set 0008,0050 to "OUTSIDE - JPMC"
Beautiful -- it works, just as it should.
--so the maximum number of importconverters that will work are 20 only?
Can I also make this statement conditional? Would I use a "ifcontains" instead of "ifequal" & can I use wildcards for the "ifcontains" to match on like in the example below?
like: importconverter0 = ifcontains "%V0008,0080","Nor*"; set 0008,0050 to "OUTSIDE - NWMC"
hey all -
I'm trying to change the accession number (0008,0050) to "OUTSIDE - hospital name" based on the institution name (0008,0080), and it seems to work with one importconverter but not with multiple importconverters. I do have 19 of these rules in my dicom.ini file, but I will just post a few here as examples so see if I have them formatted right. When I send a study to conquest I can see it going through every import rule, but every study that goes through conqeust, no matter where its from (in the institution name) always ends up with whatever the last importerconverter in the list says to set in the 'accession_number field'. Here is what I have in my dicom.ini file:
importconverter0 = set 0008,0050 to "OUTSIDE - NWMC"
ifequal "%V0008,0080","North Radiology"
importconverter1 = set 0008,0050 to "OUTSIDE - ST Mary's"
ifequal "%V0008,0080","St. Mary's Hospital"
importconverter2 = set 0008,0050 to "OUTSIDE - Urologic Spec"
ifequal "%V0008,0080","UROLOGIC SPECIALISTS OF NOWHERE SPECIAL"
Thanks for your help on this.
Okay if I were to use 1.4.12c now and have mutiple sens in one rule, would this be a working example?
ForwardAssociationLevel = STUDY
ForwardAssociationCloseDelay = 5
ForwardAssociationRefreshDelay = 3600
ExportConverters = 1
ExportModality0 = MG
ExportFilter0 = StationName LIKE 'SJBR%'
ExportConverter0 = forward to 'MAMMORD%'
and this would be the case if I have 3 read stations named MAMMORD1, MAMMORD2, & MAMMORD3? correct?
or how would I route to multiple AEs with one export converter?
I did see something in the PDF about RF*, but a wild card after a modility make much sense, can you shed some light on how you do it? Maybe give me an example of your code in your .ini file? Thanks!
Would it be possible to add or modify Conqeust in the future to allow it to send to multiple places within one rule?