search

TrakHound / TrakHound-Community

Open Source MDC Software Package using MTConnect
http://www.TrakHound.com
GNU General Public License v3.0
49 stars 29 forks source link

Data Storage #33

Open cmdanger opened 7 years ago

cmdanger commented 7 years ago

I have installed TrakHound Dashboard and Server and have about 90 devices collecting data. Where is the data stored by default on Windows 10?

PatrickRitchie commented 7 years ago

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

cmdanger commented 7 years ago

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?

cmdanger commented 7 years ago

Oh, and is it open source?

PatrickRitchie commented 7 years ago

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.

rphauck commented 7 years ago

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.

rphauck commented 7 years ago

BTW - is this the best forum for posting questions/comments on the software? Are there any plans for a formal forum so to speak?

PatrickRitchie commented 7 years ago

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 info@trakhound.com.

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.

MZorzy commented 7 years ago

@mdanger may u take an screenshoot ? 90 machines awesome :-D

PatrickRitchie commented 7 years ago

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.

cmdanger commented 7 years ago

This looks awesome! I'll look at this today and give it a whirl :)

On Mar 1, 2017, at 2:56 AM, Patrick Ritchie notifications@github.com 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.

intolerance commented 7 years ago

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

PatrickRitchie commented 7 years ago

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

Sebast1ann commented 6 years ago

Hi I'm trying to move to v2 but i cant find Data Server anymore (going for local storage). Thanks in advance

PatrickRitchie commented 6 years ago

@Sebast1ann We have combined the DataClient and DataServer apps into a new product called MTC2SQL. Please contact us about a free trial at info@trakhound.com

MZorzy commented 6 years ago

@PatrickRitchie https://github.com/ ... ?

PatrickRitchie commented 6 years ago

@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.

raulrdodriguez commented 6 years ago

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