re: hosting existing cache.dat

[alex jennings]

I don't know if anyone could offer any advice. We have an instance of cache that runs our electronic prescribing system, we have no access to the back end of the system as this is prohibited by the vendors, however we are able to run reports based on the SQL tables that have been set up by the vendor for that purpose. Formulating these reports into a web portal has provided numerous benefits to medical staff and we are even able to link biochemistry to prescribed medicines by combining the lab data and the SQL derived queries. However what we would like to be able to do within the portal is to provide intelligence to the medical staff around the medicines that they have prescribed and to do this I would like to link a portion of the prescribing system that is updated once a month by a third party supplier. However this information is not in one of the pre-built SQL tables. The once monthly update is in the form of a cache.dat file and I was wondering if it would be possible to host the cache.dat in a separate installation and extract the data I need in a more relational type format. To this end I have created a fresh cache install, a namespace and a database, then swapped out the cache.dat file for the one from the third party supplier. I can now by selecting edit see 5 primary globals and within these a structure of sub globals down to the data, however nothing else within cache appears to work. Deepsee just displays UNKNOWN under all options, classes and routines displays a 5001 error and studio keeps popping up error messages.

 

Is there something else I need to do to get this darn thing working? Any help greatfully received

[Matthew Gage]

The simple answer is YES - however, it will probably be a lot of work to extract the information in a way that is meaningful.

There are a number of ways that the data could be represented in this cache.dat

Given it seems that you don't have table/class definitions in the file, the most likely are:

You could have data from class/table structures that are defined in a different cache.dat

You could have data that is from "mumps" style storage (no sql or object representation at all) - the definition of the storage is in the application.

In the absence of having access to the definitions or code (which it sounds like you don't), you need to reverse engineer (and guess !!!) the likely storage based on experience, reports the application provides and spot checking known records. This is not a simple process, but can often be done - given you are asking the question, you would probably need outside assistance in doing this though !

Matt

[Derek Day]

I would suggest working with your vendor and your systems engineer/account manager at InterSystems to work out a solution. Since you have access to a DeepSee development environment (I assume you must have a direct license as well, and an account team at InterSystems).

 

Even if you were able to reverse engineer the data format without breaking any agreements with the vendor, you have no guarantee that it won’t change with the next update, whereas if you partner with them, the solution will be dependable.

 

~Derek

--
You received this message because you are subscribed to the Google Groups "InterSystems: Zen Community" group.
To post to this group, send email to InterSys...@googlegroups.com
To unsubscribe from this group, send email to InterSystems-Z...@googlegroups.com
For more options, visit this group at http://groups.google.com/group/InterSystems-ZEN?hl=en
Zen Community Terms and Conditions: http://groups.google.com/group/InterSystems-ZEN/web/community-terms-and-conditions
---
You received this message because you are subscribed to the Google Groups "InterSystems: Zen Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to intersystems-z...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

[alex jennings]

Unfortunately the relationship we have with the vendor is not great and they will charge us an extortionate sum of money to achieve something simple. As we are in the NHS in the UK and have to make 20billion efficiency savings, I don't have any money to buy a new pen let alone anything else! At the moment I am using a trial version of cache downloaded from intersystems on a standalone PC to try as a proof of concept before I go cap in hand to the powers that be to ask for investment.