search

ananthakumaran / paisa

Paisa – Personal Finance Manager. https://paisa.fyi demo: https://demo.paisa.fyi
https://paisa.fyi
GNU Affero General Public License v3.0
2.4k stars 124 forks source link

System not updating #32

Open FionnD opened 11 months ago

FionnD commented 11 months ago

The whole app doesn't seem to be updating from my main ledger. I've done a number of things such as deleting backups, checking the file is correct, restarting the computer etc.

ananthakumaran commented 11 months ago

Could you provide more information? What OS (including architecture), CLI, or Desktop and whether you were able to get the demo working? Paisa comes with different level of logging, you can set PAISA_DEBUG=true env variable to get debug level logs.

sauvala commented 11 months ago

Hi, I also had the same issue. I tried with the both, CLI and application, and both of them had the same issue. I was able to get the demo working but when I changed the Journal Path to my existing ledger journal file the dashboard did switch to use the new data source. I also tried to change the Db Path to point to a new DB to start fresh but that didn't help either. In the Ledger -> Editor menu it showed my ledger file and all the transactions, so at least the path to the file was correct and Paisa was able to read it.

I also set the PAISA_DEBUG=true env variable but I couldn't spot anything special from there. Could you point me to some specific log message I should be looking at?

ananthakumaran commented 11 months ago

dashboard did switch to use the new data source

you mean, it didn't? Did you try to use the sync journal action (top right hand corner). Normally paisa will sync ledger -> db when you save the file via editor. But if you update the config file or you edit the file outside Paisa, you have to manually sync.

I need to improve this, and probably show some indication that ledger is out of sync with db

sauvala commented 11 months ago

you mean, it didn't? Did you try to use the sync journal action (top right hand corner). Normally paisa will sync ledger -> db when you save the file via editor. But if you update the config file or you edit the file outside Paisa, you have to manually sync.

Ah yes, I meant that it didn't work. And yes, I tried manually syncing but that didn't fix the problem neither.

However, I noticed that when I added the 'currency symbol' (€ in my case) like

Liabilities:Credit Card    -62.74€

then the sync worked and the dashboard showed my information from my smaller test journal file. I have kept my journal file without the currency symbols since those seems to be optional for ledger-cli and it has been working fine without them. I didn't yet test this with my main journal file but I assume this fixes the issue.

I need to improve this, and probably show some indication that ledger is out of sync with db

Yes, that would be nice. And maybe you could add an option that Paisa would automatically sync itself with the file when it notices that the file has been changed. I use Emacs to edit my journal file so having an automatic sync option would be handy.

Thank you for making this tool. I got into PTA and ledger this year and I was looking for some nice tools to visualise the data but those tools didn't look as polished as Paisa.

airtonix commented 10 months ago

I need to improve this, and probably show some indication that ledger is out of sync with db

I'd be doing something like hashing the resolved ledger data (before importing it into sqlite3) and storing that somewhere and comparing it on startup.

ananthakumaran commented 10 months ago

I'd be doing something like hashing the resolved ledger data (before importing it into sqlite3) and storing that somewhere and comparing it on startup.

I am planning to do something similar, one complication would be the include directive, which could include other files, so just hashing the main ledger file contents won't be enough.