GnuCash XML sched-xaction split amount formatting
ngewif at gmail.com
Fri May 1 14:30:06 EDT 2015
On Fri, May 1, 2015 at 7:28 PM, Wm <wm+gnc at tarrcity.demon.co.uk> wrote:
> Thu, 30 Apr 2015 17:57:05 <269E0B83-186C-4755-876B-21ED3FE04992 at gmail.com>
> Ngewi Fet <ngewif at gmail.com>
> Oh, I didn't realize you were attempting to process the SXes in the
>>>> Android app!! That changes things; I just assumed you wanted to make
>>>> sure you could read the GnuCash XML data and then re-write it back out
>> Yes indeed, we are parsing the scheduled transactions and generating any
>> missed ones. Then we also maintain the schedule in the app as long as the
>> file is loaded in the database.
> This is screwing my idea of which prog is responsible for what in a
> substantial way. I thought GoA was just using the SX to note (say) a bank
> account would be less $100 because of a regular payment rather than
> processing it and passing it back to the host.
Both apps support SX. You can decide which one should handle them for you!
> How do you deal with SX that have been generated twice? The desktop will
> just see the incoming transaction that GoA has generated as a new unique
> meaning the transaction is recorded twice which isn't desirable.
If you imported your GnuCash XML to the Android app and are regularly
exporting QIF to the desktop, then yes, you could potentially have
The solution is simply to delete the scheduled transactions from the
Android device. I suppose you only do this once after importing the file.
If however, you are passing the same XML file back and forth between
desktop and Android, then you will not run into duplicates.
> More on topic though:
>>> Ngewi, you write that you intend to generate the transactions when an SX
>>> is due. Knowing that gnucash will also create these transactions,
>>> independently from GoA when they are due, won't this cause duplicate
>>> entries when importing back from GoA to gnucash on the desktop ?
>> The scheduled transactions XML tracks things like the last run time,
>> number of executions pending etc etc. We update all of that information as
>> I assume GnuCash looks at this before deciding if and how many
>> transactions to generate from the scheduled template. That way there will
>> be no duplicates.
>> But please correct me if I'm wrong.
> Hmmmn. I don't see how GoA can generate the same UID as the desktop host
> for the purposes of saying ditto so I'm thinking duplicate nightmare if
> they are both generating transactions.
We do not need to generate the same ID when exporting to XML. If you are
exporting QIF, then delete the SX on your Android device. For XML files,
GnuCash will look at the last execution time to know if missing
transactions should be generated.
> Ngewi, how do you see the worklflow happening with a desktop master and a
> GoA slave and SX being generated by both?
Yes, it could. As I mentioned above, if you import your desktop XML file
into GncA and then regularly export QIF from it, then yes, you might have
duplicates. To fix this, just delete any SX on the Android device (you need
to do that only once).
More information about the gnucash-devel