Hi
As I am a student and I want to export data from Manager Desktop Software to SQL format just to learn more how everything works inside it? How many tables are there? How everything is wired and working really good? By the way, Which technologies they are using for its cloud version?
You cannot. Even when new API will become available I doubt that we will have full access to everything. Keep in mind that manager is not open source.
About the technology it is based on Mono and Sqlite. The database is chriptographed so you cannot read data directly.
2 Likes
Removed due to possible violation of rules.
2 Likes
Can you explain how in depth…
Removed due to possible violation of rules.
Note: I did not reverse engineer it and I posted this information, because searching with the API is too slow.
1 Like
whether something is open source or not should not have to do anything with the ability to access your data without any obstacles. 
Manager has excellent data export facilities thorough the provided user interface. It has indefinite free access via the desktop version. It has the ability to be hosted on your own private server to provide ongoing private multi-user access. It has the ability to be extended by the user through custom fields and custom themes. Localisations can be exported and imported. Some work has even been put into an API to add further flexibility.
Manger does not try to block a users access to the users data. It is actually extremely flexible in that regard, far more so than other commercial products.
On the other hand, reverse engineering a commercial product is usually considered a violation of the terms of use. It is typically used to steal intellectual property, in an effort to steal market share and reduce the viability of ongoing Manager development. The ease with which this can be done can be decreased by building in program protection / encryption. Doing so diverts programmer time and decreased program performance for all users. There is no legitimate reason to learn & play around with the internal workings of a commercial software product.
If you want to help and enhance Manager there are lots of ways to constructively contribute. I do not however support intellectual property theft particularly from such a generously priced product.
1 Like
Do you think that something like https://sqlitebrowser.org/ can work? And through odbc?
1 Like
Make a “custom report” and copy and paste it.
The sql database is just a dump of objects. You’ll need to write a program that links up to the Manager.dll file to turn those objects into something useful.
Manager is ok for small files, it doesn’t really use the sqlite for anything except storing data. You can’t use sqlite indexes to speed it up. Once you fill it up with lots of transactions(I have a 5mb file) it slows down. I’ve tried putting the file into a RAM disk but it’s still slow.
1 Like