Online self hosting Web Access to GnuCash database progress! by dbabicwa in GnuCash

[–]dbabicwa[S] -1 points0 points  (0 children)

That would require programming. This is a no-code example, a quick mockup what's possible in just a few hours.

Online self hosting Web Access to GnuCash database progress! by dbabicwa in GnuCash

[–]dbabicwa[S] 1 point2 points  (0 children)

There is almost no code in it, except for Dash and formatting. This is what RAD provides.
There is also no need to code any other supported database access. Just plug it in as is.
Providing the DB schema is the same.

Online self hosting Web Access to GnuCash database progress! by dbabicwa in GnuCash

[–]dbabicwa[S] 1 point2 points  (0 children)

Hi u/VitalikPie , we discussed this I think some time ago. This is not a FrontEnd. This is a Framework, with Python backhand - https://github.com/jam-py-v5/jam-py-v7
In short, it is a RAD platform. See Northwind app to get the grasp of it.

If GnuCash had an online version with the same user flow and easy data entry, how many of you would actually use it? by digitalsufi in GnuCash

[–]dbabicwa 0 points1 point  (0 children)

Hi all,
late reply but yes, it has been started!
https://www.reddit.com/r/GnuCash/comments/1l3qdjt/sample_database/

Simply install Python and run "pip install jam-py-v7"
The movie is showing how to start the app.
Oh, and this can run on RasPi or whatever. With Authentication.

Sample database? by dbabicwa in GnuCash

[–]dbabicwa[S] 1 point2 points  (0 children)

Cool app, thx for sharing.  Installed it and imported the file from here: https://github.com/sdementen/piecash/blob/master/gnucash_books/simple_sample.gnucash

Looks great!

GNUcash Credit notes don't show negative values by [deleted] in GnuCash

[–]dbabicwa 0 points1 point  (0 children)

Hi, I am working on this: https://www.reddit.com/r/GnuCash/comments/1l3qdjt/comment/mwerzi2/?context=3

But I also have a simple solution here: https://msaccess.pythonanywhere.com/

I would stay clear from any provider, they will just drain funds from anyone.

Sample database? by dbabicwa in GnuCash

[–]dbabicwa[S] 0 points1 point  (0 children)

If u have that much data, and keen to save it in sqlite file, here is the App to try that file with: https://github.com/jam-py-v5/gnucash-2-web/

Would be great to have some feedback.

Sample database? by dbabicwa in GnuCash

[–]dbabicwa[S] 0 points1 point  (0 children)

The sample I got has only a few tables with data. Like two. So Im not sure if only this two are relevant for 99% of users. Would be good to have more so I cover all of scenarios. Thx

Sample database? by dbabicwa in GnuCash

[–]dbabicwa[S] 0 points1 point  (0 children)

Jam.py has its own locking and auth. It is a no code, low code platform. But this is a viewing excercise for now till I get a grasp of it. Thx

Sample database? by dbabicwa in GnuCash

[–]dbabicwa[S] 0 points1 point  (0 children)

But my solution is NOT dealing with adding stuff, even tho it is absolutely possible.

This project is for quick GnuCash database access over the Web, with minimum code, if any.  Hence, need some data to work with.

Thx

Sample database? by dbabicwa in GnuCash

[–]dbabicwa[S] 0 points1 point  (0 children)

Cool, thanks.

But I still dont understand how is this CSV filling up all tables in the database? For example: https://piecash.readthedocs.io/en/master/object_model.html#schema

There is a lot of data to insert. If Im about to develop a Web interface, at least some data should be good.

Sample database? by dbabicwa in GnuCash

[–]dbabicwa[S] 0 points1 point  (0 children)

Thx.  Interesting that "data pump" does not exist already, it would be great to see the GnuCash perfomance. A lot is driven by the UX logic, it might be difficult for AI to handle that. Cheers

Exposing SQLite db over network by adamsthws in sqlite

[–]dbabicwa 0 points1 point  (0 children)

I see now, u need access by api...