SQL challenges in WorldVistA using Medsphere's FM Projection Tool: Seeing headers but not underlying data

[Tony Perry]

Hi,

I'm wondering whether anyone on Hardhats has set up the FileMan Projection tool that Medsphere developed -- it is a powerful tool that, in essence, makes FileMan tables accessible using SQL coding.  There are three components to this:

1) Setting up the SQL-formatted tables on the WorldVistA server (via a KIDS file)

2) Setting up a local mySQL server

3) Creating tables on the local MySQL server that point to ("project") the tables on the WorldVistA server (this is helped by a tool that Medsphere developed called "FM Visualiser").

I set up the FM Visualiser Tool and am having a bit of difficulty getting it to work.  I have projected the table ICD_DIAGNOSIS from FileMan (this is a table created via the Medsphere KIDS file)--while I can see the headers, the underlying data itself doesn't seem to have gone across and I'm not quite sure how to access it.  I can see the underlying data on the WorldVistA server via the FM Visualiser, but not on the local MySQL server.  Therefore, when I write an SQL query, it returns zero rows.

Ultimately, this seems to be an issue related to the CREATE TABLE command in SQL (which FM Visualiser uses to 'project' the table on the WorldVistA server); the headers get copied over, but not the underlying data.  The MySQL server is redirected to the WorldVistA server using the ENGINE= command in SQL

Does anyone have any thoughts on what might be happening, and what I can do to pull the data itself?  I have attached screenshots for reference.

(More information about FM Projection can be found here:  https://medsphere.org/community/project/fm-projection)

I also posted this query on the Medsphere web site last Thursday but as yet have no reply (please see: https://medsphere.org/message/4903#4903)

Thanks in advance for any help you could provide!

Tony

  

[David Whitten]

I know this is an obvious question, but do you see the data in the ICD9 global using 

the DO ^%G command?

--
http://groups.google.com/group/Hardhats
To unsubscribe, send email to Hardhats+u...@googlegroups.com

[Sam Habiel]

It looks like Jeff Apple already responded to your question on medsphere.org.

FYI: I got it to work on WorldVistA when it wasn't a plugin but required a re-compile of mySQL. Let us know when you get it working.

Sam