TrakHound-Community
TrakHound-Community copied to clipboard
TrakHound
Data Storage
I have installed TrakHound Dashboard and Server and have about 90 devices collecting data. Where is the data stored by default on Windows 10?
Thanks for the question! TrakHound Community only stores data for 24 hours and that data is buffered in a SQLite database file located at "c:\TrakHound\Backup\Local-Server-Backup.db". This application is meant to be a simple way to view current MTConnect Device data without the need to configure each device or setup a database server. We are however getting ready to release a full featured data collection package that will store MTConnect data in a database for permanent storage (TrakHound v2).
Please let us know if you have any other questions.
Thanks,
Patrick
Hey Patrick, our company is very interested in this "full featured" data collection solution. Any idea when it will be released as well as technologies involved? Will it be able to be stored to SQL Server?
We are looking to have the first version released by the end of this month. The first release will only be for data storage and won't have much as far as data retrieval. The idea of this next version is to store all of the MTConnect data in its original form so that it can be processed later and the original data will always stay valid. Over the next few months we will be releasing more for data retrieval/processing as well as integrating these new features into TrakHound Dashboard.
Yes it will be able to work with MySQL, SQL Server, and SQLite databases.
Yes it will be open source just like our other TrakHound apps.
I am also starting to utilize TrakHound and am currently monitoring 3 out of our 6 machines. (3 Fanuc monitored, 3 HAAS soon to be...) Really liking where this is headed especially with data storage and retrieval coming. Let me know if I can help.
BTW - is this the best forum for posting questions/comments on the software? Are there any plans for a formal forum so to speak?
Glad to hear you're finding TrakHound useful! Any help is appreciated and feel free to create Issues for any bugs you find or feature requests. You can also contact us at [email protected].
We originally had an actual forum but it was rarely used and got a lot of spam so this is fine for posting comments and questions until we get a better way.
TrakHound Version 2 is now available. This new version uses the DataClient, DataServer, and AnalyticsServer projects to collect MTConnect data, store it in a database, and then process and retrieve it.
The projects are on our GitHub page and more information is on our website www.TrakHound.com. Setup information is in the ReadMe files and I'm working on some how-to videos also.
The quickest way to get started is to create an account at TrakHound.com/join and Add a subscription for DataHosting. The subscription gives you a 30 day trial and if you don't pay it will simply cancel automatically.
Version 2 is completely separate from TrakHound Community and Mobile as of right now and over the next few months we will integrate those back in.
We currently only have MySQL and SQL Server modules for the DataServer app but we will be adding a SQLite module to use in a "Live View" dashboard which will be similar to what TrakHound Community is right now which doesn't require any setup or database management.
We only have a few modules so far for the AnalyticsServer but will be adding ones for OEE, run times, cycles, etc. over the next month or two.
The idea for this new system is to store essentially All of the data that is available at the time so that as we further develop TrakHound we can always go back and re analyze old data and it should be just as valid as the new. Also, since it is stored in the database using the standard MTConnect terminology it makes it easy for other applications to utilize it such as Crystal Reports, Excel, etc.
This looks awesome! I'll look at this today and give it a whirl :)
On Mar 1, 2017, at 2:56 AM, Patrick Ritchie [email protected] wrote:
TrakHound Version 2 is now available. This new version uses the DataClient, DataServer, and AnalyticsServer projects to collect MTConnect data, store it in a database, and then process and retrieve it.
The projects are on our GitHub page and more information is on our website www.TrakHound.com. Setup information is in the ReadMe files and I'm working on some how-to videos also.
The quickest way to get started is to create an account at TrakHound.com/join and Add a subscription for DataHosting. The subscription gives you a 30 day trial and if you don't pay it will simply cancel automatically.
Version 2 is completely separate from TrakHound Community and Mobile as of right now and over the next few months we will integrate those back in.
We currently only have MySQL and SQL Server modules for the DataServer app but we will be adding a SQLite module to use in a "Live View" dashboard which will be similar to what TrakHound Community is right now which doesn't require any setup or database management.
We only have a few modules so far for the AnalyticsServer but will be adding ones for OEE, run times, cycles, etc. over the next month or two.
The idea for this new system is to store essentially All of the data that is available at the time so that as we further develop TrakHound we can always go back and re analyze old data and it should be just as valid as the new. Also, since it is stored in the database using the standard MTConnect terminology it makes it easy for other applications to utilize it such as Crystal Reports, Excel, etc.
— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub, or mute the thread.
Patrick, I've been using TrakHound Community for quite some time now. I've migrated over to TrakHound API v2 about a month ago. What I'm missing now is the dashboard aspect that existed in TrakHound community.
Do you have any updates in regards to updating the Trakhound Community so that we can have a dashboard again whilst using API v2?
Thank you,
-Allen G
Allen,
Great to hear you have found TrakHound useful! Yes we are currently testing the beta version of the new v2 Dashboard and the link can be found below. This will soon be on GitHub and our web site.
http://apps.trakhound.com/release?id=64FBAD4F-C10D-BC95-5BA7-181EA7A27A73
Please let us know about any issues or feedback.
-Patrick
Hi I'm trying to move to v2 but i cant find Data Server anymore (going for local storage). Thanks in advance
@Sebast1ann We have combined the DataClient and DataServer apps into a new product called MTC2SQL. Please contact us about a free trial at [email protected]
@MZorzy Thanks for letting me know about the other repo. Looks like it is a forked version of the older DataServer repo and not the actual MTC2SQL app that we offer.
Hi,
@PatrickRitchie How can I change the settings of the Performance and Quality metrics in the Dashboard? I am only getting part count. I have a Fanuc controller CNC connected.
I will appreciate any comments.
Thanks, Raul
