Automatic price quotes & PostgreSQL backend

[David T.]

A workaround I used for a while was to create a simple shell script that invoked GnuCash with the "--add-price-quotes" option on my data file. I then was able to run this script whenever and however I wanted (for example, as a cron job at a certain time every day). 


David



________________________________
 From: David <dgpickett at aol.com>
To: warlord at MIT.EDU 
Cc: gnucash-user at gnucash.org 
Sent: Monday, October 28, 2013 10:48 AM
Subject: Re: Automatic price quotes & PostgreSQL backend
 

These daemon sort of functions have traditionally been implemented either 1) as a second app that runs as a daemon and has these limited functions, or 2) as an option telling it to be a daemon (like sendmail -bd) with a second copy running, or 3) as a thread or periodic task in the single application.  The latter options keeps all code in one app, but the first two need to tolerate multiple users on the files or data storage.

Does the GNUCash xml storage have a RDBMS/SQL layer over it?  The xml storage might not be as amenable to second users as the SQL versions, but regardless, you have to be doing things that do not open the possibility of either app. overlaying the other's changes.  Prices are probably easier to do than scheduled transactions, as price tables are not in continuous use, and that mostly read only, but account registers are.  Doing it all in one app left running solves some of the conflict and concurrency issues.

Getting the daemon/startup launch varies by O/S.  It could be under cron or the Windows Task Scheduler, or could run continuously like so many pesky processes in windows, e.g., real_something.exe checking for updates to the realplayer.  In X, it could run windowless until a user logs on and runs a second copy, which tells the first what the DISPLAY is that it needs to add windows to.  It might even learn to close all windows when dismissed, but keep running.


Not hearing from Anthony, the original poster, so has anyone done any scheduled prices or transactions any way?




-----Original Message-----
From: Derek Atkins <warlord at MIT.EDU>
To: DGPickett <dgpickett at aol.com>
Cc: gnucash-user <gnucash-user at gnucash.org>
Sent: Mon, Oct 28, 2013 11:27 am
Subject: Re: Automatic price quotes & PostgreSQL backend


DGPickett <dgpickett at aol.com> writes:

> Good Idea!  Did you have an success?
>
> I wish GNUCash would just get the prices every day at a given time, if left
> running, or have something cron-like to keep it in sync.  

Great idea!   Looking forward to your patch to implement it!

> They could do the same for generated transactions, every day just after
> midnight.  Maybe part of GNUCash could be a daemon/service to take care of
> such.  The storage media should not make a difference.  For xml, they can
> put a rdbms-like daemon over the files so they can have multiple updating
> clients.
>
>
>
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

-- 
       Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
       Member, MIT Student Information Processing Board  (SIPB)
       URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
      warlord at MIT.EDU                        PGP key available


_______________________________________________
gnucash-user mailing list
gnucash-user at gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.