The database data, encoded?

[hthomas]

Hi, i have managed to import a database and query it. See image below.
Is the data encoded? The Content column is the one I’m referring to.

[ries]

Just a wild guess, could it have something to do with Unicode?
May I ask, how did you manage to import the database?

[Davide]

You cannot open manager files with other softwares…

[hthomas]

I used SQLLite Studio to import the data

[lubos]

Content contains serialized object using Protocol Buffers which is Google’s data interchange format.

Even though Manager is using SQLite as a persistence layer, it doesn’t store data in a relational fashion. Mostly for performance reasons.

[repeted]

Is there a way to interact with that data?

I am trying to find a way to create graphs and charts (Dashboards) for Managers/Owners/Investrors since traditional reporting is not always the best way to present data…

or is there already an option built in somewhere in manager…

[Patch]

Using the API is likely to best achieve what you want
see
Managers API forum information

Customize Reports

Manager is proprietary not shared source software. There is no public release, support for creating a fork or sharing a base code modification. However Manager is highly customizable including Account structure Create custom reports Custom fields Use Batch Create and Batch Update functions Custom themes Localisation (in a state of change but current summary is here) Application programing interface A summary of a useful adaption can be posted on the forum. Sharing of localisation to all use…

The Manager API

Hello, I have recently started using the manager API. I want to create a bunch of useful scripts for requesting info, in Python. @Lubos, this is great! I’m really glad, so many years on, to be so gladly still using manager. It’s grown my business greatly! Hopefully, this API will make life even easier. Could you comment on the status of the API? Do we have anything more than GET at the moment? I was hoping this would become a useful place to have some ‘centralised’ discussion on the API, as I…

Is API changed?

Yeah I know. This is why I’m holding back from releasing any documentation for API whatsoever. It’s not yet stable and endpoints can change. They didn’t for long time though. This particular change is related to changes in Application Data folder. The businesses are no longer named after randomly generated UUID but actually what they are named in Manager. The business string in URL is base64 encoded business name. If you are using server edition, have a look into your Application Data folder t…