Fw: Way of importing CAT result to International DB
Nichole Knox
Sent: Wednesday, October 20, 2021 12:09 AM
To: ihe-testing-and...@googlegroups.com <ihe-testing-and...@googlegroups.com>
Cc: Nichole Knox <nk...@rsna.org>
Subject: Way of importing CAT result to International DB
Dear Testing & Tools,
I send following information how IHE-Japan sent Connectathon result data to EricP every year I heard from our development team.
Sorry for late reply.
We use “eportResultCAT.sh” provided by Gazelle development team (maybe EricP).
It will make a SQL file which can import Connectatohn result data to the International Result table.
I attach both exportCATResults.sh and a sample SQL file the tool created.
Our development team sent the SQL file to EricP every year.
I guess he might have edited some additional information in the SQL file before he import it to the DB.
As you see our company names are in Japanese.
Sometimes EricP asked me which company name in the International Result data was matched to a Japanese company name in the SQL.
Actually he could make matching it using find function even if he couldn’t read the Japanese characters.
But he lost his way when a company name had been changed during a year like Toshiba Medical to Canon Medical.
Unfortunately, I don’t know the detail his work.
I think Kereval team knows it.
Best regards,
Salt
--------
Yasunari Shiokawa
JAMI certification Senior Healthcare Information Technologist
Canon Medical Systems Corporation
IHE-Japan Director / RAD Tech Committee Chair / Testing & Tools Committee member
IHE International Testing & Tools / RAD-Tech / CAsC Committee member
HL7-Japan Conformity Assessment Committee Chair
Make "Made For life" possible with CMSC & Canon --------
[Note]
This e-mail message may contain personal information or confidential information.
If you are not the addressee of this message, please delete this message and kindly notify the sender as soon as possible.
Do not copy, use, or disclose this message.
Radiological Society of North America
820 Jorie Blvd, Oak Brook, IL 60523
TEL 1-630-571-2670
FAX 1-630-571-7837
RSNA 2021 Annual Meeting
November 28 to December 2
Join us in-person at McCormick Place, Chicago