Re: GnuCash XML sched-xaction split amount formatting
Thu, 30 Apr 2015 17:57:05 <269e0b83-186c-4755-876b-21ed3fe04...@gmail.com> Ngewi Fet 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 again. *ponders* 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. 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. 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 well. 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. Ngewi, how do you see the worklflow happening with a desktop master and a GoA slave and SX being generated by both? -- Wm... ___ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel
Re: GnuCash Android v1.6.0 pre-beta
Thu, 30 Apr 2015 00:40:59 Ngewi Fet Thanks for the comprehensive feedback :D I made some responses inline below: On Thu, Apr 30, 2015 at 12:04 AM, Wm wrote: Sat, 25 Apr 2015 02:23:06 < cae0qbawquk_uyxrthjjqfs_dbaj-mfw737botpl9ss7dyhs...@mail.gmail.com> Ngewi Fet My env is: Android-x86-4.4-r2 guest VirtualBox 4.3.26 Win 8.1 host I can't make sense of the android directory structure in spite of the fact that I put it on an ext2 file system that I can mount and have a look at under standard Linux The external storage should be somewhere under sdcard/0 or /mnt/sdcard depending on your device. It may be different for the emulator you use as well. Not your issue, the vm can't use the guest additions meaning it can't talk to attached drives, shared folders and so on. I'm guessing in file system terms my gnc file is somewhere in a ramfs or similar, irritating but not insurmountable given some curiosity, what I wanted to do was xfer files between my native disk and the android vm. I'll probably figure it out in a day or so, meanwhile via GDrive is ok-ish for testing. Onwards: I installed the google play version and then the .apk over that but it reverted to the google play version. So I got rid of the google play one and installed the apk bare, we (the vm and I) were both happier with that. What do you mean reverted? The install of the new apk did not complete, or what exactly happens? I'm also very interested in upgrade experiences especially ones with existing data in the database. I didn't have any data on the android at all when I started. By reverted I mean after I installed the apk over the play version and *then* rebooted or shut down and restarted, etc I was back where I was with the google play version not your new apk Suggestion: before I figured things out it wasn't clear to me whether I was using the pre-beta or the google play version. I missed the equivalent of Help / About or similar which I looked for on the menu off to the left that has Accounts Open ... Transactions Scheduled ... Settings Maybe it is somewhere else on an Android and I just don't know where to look It is found in the Settings -> About. But we will consider adding it to the navigation drawer menu in the next version. You are correct. three-bar-on-the-top-left / settings / [and then it waits a minute or more] / About / Build Version. Is it possible something else on that menu is calling home and the menu doesn't get displayed until the remote master has been contacted? I'm guessing but does the google-master check app validity or something? Clue: my connection to the internet was broken for a while this afternoon and I presumed an app like gnca was self contained. Am I wrong? That could explain why I couldn't see the About then but can now. Similarly I don't know which file I am working with on android, in desktop I can see whether I'm using ABC.gnca or ABC.xml or XYZ.gnucash. Once again it is possible this is very obvious to people more familiar with androids and I'm just not seeing it. No, this information is actually not present and is planned for the next release. But I will see what I can do to improve display of what file is in use for this release (at least for files gotten from the SD card). I think small things like that may encourage acceptance and use particularly amongst testers who are likely to have more than one file to play with. Perversely, if you get it right the workflow will be more obvious later on. At the moment I am creating a dummy a/c in Equity so I can check which file I am using. Which reminds me, how do I get to the top of the accounts tree after I have moved away from it? If I open a file I see my top level accounts. Problem is once I choose a top level account I can't get back to the top of the account tree. I can navigate up and down but never regain the top. I'm guessing on a real android you sacrifice your first born child and drip their blood in a hand waving way to get it back. I'm too old for that. - Scheduled export to SD Card, DropBox or Google Drive Didn't try the scheduled. I went for Drive for storage and it worked out OK once I got the android to sync, see above about not understanding android directory structure, what dirs am I syncing? Where is gnca actually storing files? GncA creates a directory in your Google Drive with the name of the app and puts all its files into that folder. Not here it doesn't. Is it possible you are presuming everyone is using Chrome? Similarly, DropBox also puts the files into Apps -> GnuCash Android You are not syncing a directory, but rather individual files. I think we should do something to make the export destination known to the user. Thanks for highlighting this. I'm not getting this at all, TBH. My dropbox account puts stuff where I tell it to. Is the fact that the files are coming from an android suddenly g
Re: GnuCash XML sched-xaction split amount formatting
On Fri, May 1, 2015 at 7:28 PM, Wm wrote: > Thu, 30 Apr 2015 17:57:05 <269e0b83-186c-4755-876b-21ed3fe04...@gmail.com> > Ngewi Fet > > 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 again. *ponders* >> 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 duplicates. 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 >> well. >> 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). Ngewi ___ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel
Re: GnuCash Android v1.6.0 pre-beta
> > >> What do you mean reverted? The install of the new apk did not complete, >> or what exactly happens? I'm also very interested in upgrade >> experiences especially ones with existing data in the database. >> > > I didn't have any data on the android at all when I started. > > By reverted I mean after I installed the apk over the play version and > *then* rebooted or shut down and restarted, etc I was back where I was with > the google play version not your new apk Ok, that is weird and looks more like VM issues. > It is found in the Settings -> About. But we will consider adding it to >> the navigation drawer menu in the next version. >> > > You are correct. > > three-bar-on-the-top-left / settings / [and then it waits a minute or > more] / About / Build Version. Is it possible something else on that menu > is calling home and the menu doesn't get displayed until the remote master > has been contacted? I'm guessing but does the google-master check app > validity or something? Clue: my connection to the internet was broken for > a while this afternoon and I presumed an app like gnca was self contained. > Am I wrong? That could explain why I couldn't see the About then but can > now. Yes, you are correct. I think opening the Settings checks on the state of the DropBox and Google Drive sync (if they are enabled) in order to display it in the app. It happens when all of Settings is opened and not just the Backup section because on Gingerbread devices, there are no sections in the settings. Which reminds me, how do I get to the top of the accounts tree after I have > moved away from it? > Use the back button on your Android device, or open the navigation drawer and go to Favorites. > > If I open a file I see my top level accounts. Problem is once I choose a > top level account I can't get back to the top of the account tree. I can > navigate up and down but never regain the top. I'm guessing on a real > android you sacrifice your first born child and drip their blood in a hand > waving way to get it back. I'm too old for that. > > - Scheduled export to SD Card, DropBox or Google Drive >> Didn't try the scheduled. I went for Drive for storage and it >> worked out OK once I got the android to sync, see above about not >> understanding android directory structure, what dirs am I syncing? >> Where is gnca actually storing files? >> >> GncA creates a directory in your Google Drive with the name of the app >> and puts all its files into that folder. >> > > Not here it doesn't. Is it possible you are presuming everyone is using > Chrome? I do not understand the connection to Chrome. Does your emulator have Google Play services running on it? If not, the Google Drive sync will not work. Otherwise, the app will create its own folder on Google Drive (after you authorize it). > > > Similarly, DropBox also puts >> the files into Apps -> GnuCash Android >> You are not syncing a directory, but rather individual files. >> I think we should do something to make the export destination known to >> the user. Thanks for highlighting this. >> > > I'm not getting this at all, TBH. My dropbox account puts stuff where I > tell it to. Is the fact that the files are coming from an android suddenly > going to make it different? Yes, but the app is putting stuff in your DropBox, not you. DropBox automatically creates a folder for apps which connect to it. GncA has a folder in "Apps -> GnuCash Android" > > > - Improved creation of backups and restoring of backups >>> >> again, I couldn't work out where the files were >> GnuCash Android files are here: /sdcard/0/org.gnucash.android/ >> But for restoring backups, you do not need to know the path because a >> dialog is shown to you listing the files. >> > > *IF* you have an SD Card that is nice. Where are they otherwise? I guess it will be somewhere on internal storage which Android will expose as external storage. > GnuCash Android also registers itself >> >>>to open .gnucash files. >>> >> Are you sure about that? Once again it is possible I don't speak >> android well enough but do you perhaps mean .gnca rather than >> .gnucash ? I'm also not sure what happens with compressed files, it >> is possible my vm doesn't have auto unzip and real android devices >> do. >> > > Yes, GnuCash should be in the list of possible apps to open those files >> with, when you try to open such a file from, say, Google Drive by >> clicking on it. The app registers for both .gnca and .gnucash. >> The app handles both compressed and uncompressed XML files just fine. >> You don't need to do anything extra. >> > > .gnucash files are greyed out here, if I rename them I can open them and > choose the application. Where is "here"? Some other app? DropBox? I know some people file selection issues with Google Drive. We are still trying to find a reliable solution for this. > Is the decimal set to "," ? I'm used to "." for decimal. As someone who > h
Hi, I Have a Proposition
Hi Developers, My name is Roger, and I have a proposition. It's my belief that with a few changes to improve work flow, GnuCash could have widespread appeal for managing personal finances. I'm not talking about the next systemd here, just some well-thought-out things like shading newly imported transactions and recently modified accounts, and adding or refining a few wizards. The one notable exception is a rules-based system for classifying items, but I think I can help significantly with that. Everything I'd be addressing could easily be made an option. My primary contribution would be to help determine the changes needed to make GnuCash the superior program for personal finances, and to help implement them. Then, I would write and maintain a publication-worthy free guide on using GunCash for this purpose (and publicize the heck out of it). I would of course link to existing documentation throughout, and include just enough accounting background for this use. If the guide were released simultaneously with at least some of the features I have in mind, it could be an opportunity to get significant attention and attract a new set of users. It's easy to imagine a typically overdone Slashdot title like "GnuCash Takes on Personal Finances--The Quicken Killer?" Kindly note that I am not interested in a Quicken Clone--we can do better than that! Why focus on a niche when GnuCash can do so much more? First, there's benefit to familiarity. If someone knows how to use GnuCash for home finances, why learn something new for their aspiring new business? Second, every single change to facilitate my work flow should be of general benefit. Third, GnuCash is an impressively mature solution, but perhaps it's time to start challenging it to do more. Forth, increased use for any purpose could encourage financial institutions to provide greater support. Hopefully that's enough. I could go on about the details, why I'm qualified for this, my motivation, etc., but my interest at this point is to find out if you folks, the architects of GnuCash, are at all interested. My ambitions are not modest--this is just a start--but for all I know you all are pleased with GnuCash as it is, and I couldn't blame you. I'd love to hear your thoughts, Roger Mustacich Santa Clara, CA ___ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel
Re: GnuCash Android v1.6.0 pre-beta
On 5/1/2015 2:36 PM, Ngewi Fet wrote: > > > On Fri, May 1, 2015 at 8:58 PM, David Carlson > mailto:david.carlson@gmail.com>> wrote: > > OK Vicodin, thousands of KB, not thousands of MB. I am still > having trouble sorting this thread in Gmail, tho. > > > My current observation is that if I un-install the pre-beta and > install release 1.5.5 from Google Play, that version is able to > open my 4,500 KB compressed XML data file and I can find some > complex multi-line split transactions. there may be some issues > with security accounts, but I will defer that until I better > understand what is happening. There were no scheduled > transactions here, although the Since Last Run certainly finds > them on the desktop. This import seems to take quite a while, > perhaps a few minutes. > > > 1.5.5 completely ignores scheduled transactions. > > > > > However, if I un-install release 1.5.5 and use APK installer to > install the April 29 pre-beta 1.6.0, that version appears to > install correctly. I choose to cancel the account creation then > try to open that same 4,500 KB data file. GnuCash for Android > fails to parse a template credit card account (I think > ) it flys by pretty fast. then there are no accounts to display. > That happens much faster than the 1.5.5 import. > > > Yes, I also think that will be the issue. The main change between > 1.5.5 and 1.6.0 is the parsing of template transactions and scheduled > transactions. I would like to have an example of a template > transaction from your XML file if it is ok for you. > Also do you have any accounts or transactions which are not simple > currency transactions? I mean things like stocks, securities etc. > What happens when you install 1.5.5, import your file and then upgrade > in-place to 1.6.0? Do you run into any problems there? Starting from release 1.5.5 looking at that XML file and directly installing the April 29 pre-beta, Gnucash for Android fails to start. There is a brief black screen then the apps page re-appears. The first time there was a list of files to open, but I was not expecting that and I cancelled. Now it won't go back to that window. That is not the same as when I manually un-install 1.5.5 before installing the pre-beta. Going back to one of your other questions, yes, there are many brokerage accounts with many stock and mutual fund accounts with purchases, sales and current balances in those securities. I was hoping to just ignore them for now. My default currency is US Dollars but I may have one or two expense accounts in CAD from years ago, although I do not use them now. As for the other question, I do not know how to identify a template. I remember that I accidentally created one once in release 2.4.something, and I never succeeded in removing it, but that was long ago. It continues to pop up when updating security prices. If you can help me to find it, I should be able to extract it and, if necessary, sanitize it for your perusal. David C > > > If I now try to restore the last backup, I get an error multiple > roots exist in book. The oldest backup restores the first two > manually entered transactions from last week. > > > Thanks for the feedback! > > ___ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel
Re: Hi, I Have a Proposition
> On May 1, 2015, at 1:35 PM, Roger Mustacich wrote: > > Hi Developers, > > My name is Roger, and I have a proposition. > > It's my belief that with a few changes to improve work flow, GnuCash could > have widespread appeal for managing personal finances. I'm not talking about > the next systemd here, just some well-thought-out things like shading newly > imported transactions and recently modified accounts, and adding or refining > a few wizards. The one notable exception is a rules-based system for > classifying items, but I think I can help significantly with that. Everything > I'd be addressing could easily be made an option. > > My primary contribution would be to help determine the changes needed to make > GnuCash the superior program for personal finances, and to help implement > them. Then, I would write and maintain a publication-worthy free guide on > using GunCash for this purpose (and publicize the heck out of it). I would of > course link to existing documentation throughout, and include just enough > accounting background for this use. If the guide were released simultaneously > with at least some of the features I have in mind, it could be an opportunity > to get significant attention and attract a new set of users. It's easy to > imagine a typically overdone Slashdot title like "GnuCash Takes on Personal > Finances--The Quicken Killer?" Kindly note that I am not interested in a > Quicken Clone--we can do better than that! > > Why focus on a niche when GnuCash can do so much more? First, there's benefit > to familiarity. If someone knows how to use GnuCash for home finances, why > learn something new for their aspiring new business? Second, every single > change to facilitate my work flow should be of general benefit. Third, > GnuCash is an impressively mature solution, but perhaps it's time to start > challenging it to do more. Forth, increased use for any purpose could > encourage financial institutions to provide greater support. Hopefully that's > enough. > > I could go on about the details, why I'm qualified for this, my motivation, > etc., but my interest at this point is to find out if you folks, the > architects of GnuCash, are at all interested. My ambitions are not > modest--this is just a start--but for all I know you all are pleased with > GnuCash as it is, and I couldn't blame you. > > I'd love to hear your thoughts, Roger, Well, highlighting recent changes is certainly a small enough change that it's hard to imagine anyone objecting as long as it's an option. Adding wizards is also not too difficult, but you'd have to make the case that they'd be useful and implement them in a way that's consistent with the rest of our code. Rules-based classification is another matter that would require some elaboration: What are you proposing to classify according to what sort of criteria and at what point in the workflow? Immodest ambitions are another matter entirely, particularly if they amount to changing the program's mission. We want GnuCash to serve people who want to keep their accounts, whether personal or for a small business, in a business-like way. That's very different from the target user-bases of Quicken, MS Money, iBank, KMyMoney, etc. We want GnuCash to be useful everywhere, not just in the US. That forces a fair amount of flexibility that other programs don't have. Finally, you must recognize that GnuCash is a volunteer project published under the GNU General Public License: You won't be compensated for your work and it will be published for all to see and copy as they like. Note also that we're severely resource-constrained, so you won't be "helping" implement changes, you'll be implementing them yourself and submitting them for code review. Maybe we'll be interested and maybe not. You haven't provided enough information to decide. Regards, John Ralls ___ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel
