HL7 Spy with SMATDB

[Grace Huynh]

Has anyone used HL7spy’s SQL Loader to directly connect to Cloverleaf’s SMATDB? If so, would you mind me picking your brain on how your organization is leveraging this?

 

Thanks!

Topic

[Tipu Razaq]

HL7Spy has an FTP feature. Using that FTP feature we navigate to the directory where your SMATDBs are stored on the Cloverleaf server and select the ones you’d ‘like to download. HL7Spy will start downloading them and if they’re encrypted, it will ask for the password, too.

 

Make sure you’re using a version of HL7Spy that supports SMATDBs. I know version 20.xx does. HL7Spy is great and a total time saver!

[Dock Hutson]

I am also interested in using HL7 Spy, but how do you know the password for the SMATDB encryption if you are letting the system create it?  I know if revolves around the Site Name, but it can’t be that simple.

[Robert Kersemakers]

It is that simple: site name.

Zuyderland Medisch Centrum; Heerlen/Sittard; The Netherlands

[Tipu Razaq]

It’s usually the site name, but it can be set to anything.

 

[Dock Hutson]

Thanks for the quick answer!  I’m testing out HL7 Spy and I’m wondering if there is a way to not have to enter the site password for every single file?  We archive our SMATDB files daily so I would like to open a week or a month of data, but it gets old entering the password for every single file.  It would be nice if it tried the first password entered for the rest of the files and prompted you when it doesn’t work.

I love the tool so far.  This will save us so much time in data searches!

[Tipu Razaq]

Yup, that’s annoying. I would email the vendor and ask for a enhancement request.

 

Who knows, they may already have a solution for it, but I haven’t searched the documentation to find out.

 

• This reply was modified 4 days, 3 hours ago by Tipu Razaq.

[Author]

Replies