Re: [Hardhats-members] Fileman Export to Foreign format tool. (Was Hospital Cost analysis)

[Kevin Toppenberg]

Great.

 

What I want to do is to create a function where my group could drop all progress notes to a huge XML file in the event that they want to move to another system, and I am not around.

 

This would need to be a function written from M, inside the system. I would not want them to have to use a web browser to get the data.

 

How hard would this be?

 

P.S. Could you post where I can get the code from, and where the API is documented?

 

Thanks

Kevin

Jim Self <[EMAIL PROTECTED]> wrote:

These capabilities are available to you in M2Web. You can pick pretty much any VistA data
file and get the data out instantly in various formats and document types, including HTML,
XML, and _javascript_. If no format is specified, the default format includes all fields you
are allowed to access from the zero-node of the data record. The default limit of records
per page varies with the document type. The default document type is HTML, of course.

examples:
http://vista.vmth.ucdavis.edu/query?dbfile=OPTION&index=Name&find=XUS
http://vista.vmth.ucdavis.edu/query.xml?dbfile=OPTION&index=Name&find=XUS
http://vista.vmth.ucdavis.edu/query.js?dbfile=OPTION&index=Name&find=XUS
http://vista.vmth.ucdavis.edu/query.js?dbfile=OPTION&index=Name&find=XUS&layout=js2
http://vista.vmth.ucdavis.edu/query.xls?dbfile=OPTION&index=Name&find=XUS

similarly:
http://vista.vmth.ucdavis.edu/query?dbfile=REMOTE+PROCEDURE&index=Name&find=XUS

To see this data rendered in the different document types, insert document type extensions
before the "?" as in the previous examples.

This one includes a custom format with subfields:
http://vista.vmth.ucdavis.edu/query?dbfile=8994&format=TEST2&index=Name&find=XUS
This is interesting for several reasons, one of which is that it contains tables within
tables. Unfortunately, the r endering of sub-tables in this example does not change with
the document type.

This example is almost the same but the format of the subfields was left open. It renders
syntactically correct XML (I have only tested it with Mozilla so far) but the HTML doesn't
look as good. Oh well.

Kevin Toppenberg wrote:
>An extension of this that I would like to implement
>someday in the near future would be to allow XML or
>HTML output. I haven't played with the tool to know
>if it can do this already.
>
>Kevin
>
>
>--- Gregory Woodhouse <[EMAIL PROTECTED]>wrote:
>
>> This is a very powerful (and much underused) tool.
>>
>> ====
>> Gregory Woodhouse
>> [EMAIL PROTECTED]
>> On Apr 15, 2005, at 8:31 AM, James Gray wrote:
>>
>> > You might be able to do it even faster using the
>> Fileman Export to
>> > Fore ign format tool.
>> >
>> > Jim Gray
>> >
>> > ----- Original Message ----- From: "Kevin
>> Toppenberg"
>> > <[EMAIL PROTECTED]>
>> > To:
>> > Sent: Friday, April 15, 2005 5:21 AM
>> > Subject: Re: [Hardhats-members] Hospital Cost
>> analysis
>> >
>> >
>> >>
>> >> --- Eriam Schaffter <[EMAIL PROTECTED]>
>> wrote:
>> >>> The input to this software is flat text files
>> >>> containing datas extracted
>> >>> from the HIS. That's why I think getting data
>> out of
>> >>> the db with sql
>> >>> seems to be the solution. However if you think
>> >>> thoses data text file can
>> >>> be generated in another way why not. Since i've
&g t;> not
>> >>> been working yet
>> >>> with openvista i don't know exactly what is
>> possible
>> >>> and what is not.
>> >>
>> >> You would just write a short M routine that would
>> >> access the data you want, open a text file, and
>> write
>> >> it out.
>> >>
>> >> Kevin

---------------------------------------
Jim Self
Systems Architect, Lead Developer
VMTH Computer Services, UC Davis
(http://www.vmth.ucdavis.edu/us/jaself)


-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
_______________________________________________
Hardhats-members mailing list
Hardhats-members@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/hardhats-members

---

Do you Yahoo!?
Make Yahoo! your home page