Error when using hcismatconvert

[Avy Luthor]

Leadership wants to track the number of messages that go through almost all threads.

1) What is the easiest way to do this?  

2) Reading filename.smatdb does not work, so I thought I could use hcismatconvert to make the .smatdb files into the old format so that I can parse them.

2a) In that proc, there is a class which sets variable tableName to smat_msgs.  That table, smat_msgs, does not seem to exist because I get the error “Error while getting records number from smat db:  no such table:  smat_msgs”.  Anyone know if this table has been renamed between 5.7 and 6.1?

Topic

[Mark Thompson]

Hello Avy,

Is your .smatdb encrypted?  That might be the issue with not finding the smat_msgs table.

Once you solve the encryption issue you may want to use something like:

Code:

echo ‘select count(*) from smat_msgs;’ | sqlite filename.smatdb

- Mark Thompson
HealthPartners

[Rob Abbott]

Avy, if you are on 6.2, there is a statistics database feature that captures this information.

Rob Abbott
Cloverleaf Emeritus

[Author]

Replies