Re: Merging Files or Other Method getting Transactions into main File.
Good Morning Matt, Your summary is spot on. Thank you very much for your offer. However I feel that that may not further complicate my situation as I have had two sessions of inputting. I think at this stage I prefer to plod on slow and steady. Two things that I think should be written into the main GNU Cash are: Import from XML file. Export to QIF. Regards Mike On Tue, Jan 30, 2018, at 10:02 PM, Matt Graham wrote: > Hi Mike, > > So if I understand correctly from looking through the email chains: > 1. You had everything entered into the mobile app > 2. You exported from the mobile app and hit the bug where splits lose > their values in the export > 3. You imported all the transactions into GNUCash desktop in a new > file (so get the splits, but no values) then painfully went > through and entered all the transaction amounts for the splits > 4. You tried exporting from Gnucash desktop in a variety of formats > and importing back into your main file, and it didn’t work. So you > are now re-entering all of those transactions manually into your > main file That is incredibly painful.> > Is all of this correct? > > To try to save you a lot of painful hours of concentration, and > assuming my above is correct, my questions are: > 1. Is this the kind of data that you are willing/able to send to one > of us so that we can see what the outputs are ourselves? (probably > the qif export from the desktop gnucash). Obviously, don’t post it > to gnucash-user because then the world will have it online. > Usually this is not an option for people, but if it is then it > could really help the troubleshooting. Export/import qif from > gnucash has always been really good for me. > 2. If that is not an option, when you exported from Gnucash desktop > in qif format. What do you see when you open the file in Wordpad > or Notepad (I’m assuming you use windows)? It will be a large > file, with lots of text, but it would give us clues as to what is > going wrong.> > Thanks and regards, > > Matt > > *From: *Mike Stillingfleet[1] *Sent: *Tuesday, 30 January 2018 8:33 PM > *To: *Geert Janssens[2]; gnucash-user@gnucash.org *Subject: *Re: > Merging Files or Other Method getting Transactions into main File.> > Thanks Geert, yes I have previously had a go at that other forum no > response. > > I have this morning created reports from the corrected XML file. > > I am starting to input manually. It may take a week or so to re- > input the data but carrying on with the current effort is completely > pointless. > > I do think that the GNU cash Web site should take down any link to > the App and further issue a massive health warning about the App. > > Having said that. Since upgrading I gave scheduled a daily QIF > download from the App. > > GNU Cash so far appears to be able to handle these tiny QIF files. > But I would urge users not to enter a volume of data on the App. It > is a disastrous waste of time. > > > > > > On Tue, Jan 30, 2018, at 8:22 AM, Geert Janssens wrote: > > Op dinsdag 30 januari 2018 07:59:01 CET schreef john_mike: > > > Confused! > > > > > > Back ground : Trying to get damaged transactions from phone to > > > main file. Transactions entered whilst phone app had some sort of > > > double minus problem. > > > > > > > > > What I have done: > > > > > > The only way to repair the transactions was to export as an XML > > > file. Open that XML in GNUCash. Go through line by line and enter > > > amounts. > > > > > > Now I want these transactions to be imported into my main file. > > > > > > > > > I have attempted to export these corrected transactions to a QIF > > > File. But this option does not seem to exist. So have followed > > > the export to CSV file. > > > > > > Now when attempting to import these CSV files to my main file. It > > > fails. > > > > > I'm sorry you have such trouble trying to interchange data between > > these two applications. > > > > But you really should ask help on the Gnucash for Android forum, > > which is not here. The issue starts there in this particular case, > > and there nothing gnucash on desktop can do about this I'm afraid. > > > > CSV import in gnucash 2.6 and before has a very limited scope: it > > was written solely for importing bank statements and the options to > > tweak it show this. GnuCash data (like exported from gnucash to > > CSV) on
RE: Merging Files or Other Method getting Transactions into main File.
Hi Mike, So if I understand correctly from looking through the email chains: 1. You had everything entered into the mobile app 2. You exported from the mobile app and hit the bug where splits lose their values in the export 3. You imported all the transactions into GNUCash desktop in a new file (so get the splits, but no values) then painfully went through and entered all the transaction amounts for the splits 4. You tried exporting from Gnucash desktop in a variety of formats and importing back into your main file, and it didn’t work. So you are now re-entering all of those transactions manually into your main file That is incredibly painful. Is all of this correct? To try to save you a lot of painful hours of concentration, and assuming my above is correct, my questions are: 1. Is this the kind of data that you are willing/able to send to one of us so that we can see what the outputs are ourselves? (probably the qif export from the desktop gnucash). Obviously, don’t post it to gnucash-user because then the world will have it online. Usually this is not an option for people, but if it is then it could really help the troubleshooting. Export/import qif from gnucash has always been really good for me. 2. If that is not an option, when you exported from Gnucash desktop in qif format. What do you see when you open the file in Wordpad or Notepad (I’m assuming you use windows)? It will be a large file, with lots of text, but it would give us clues as to what is going wrong. Thanks and regards, Matt From: Mike Stillingfleet<mailto:mikestillingfl...@fastmail.co.uk> Sent: Tuesday, 30 January 2018 8:33 PM To: Geert Janssens<mailto:geert.gnuc...@kobaltwit.be>; gnucash-user@gnucash.org<mailto:gnucash-user@gnucash.org> Subject: Re: Merging Files or Other Method getting Transactions into main File. Thanks Geert, yes I have previously had a go at that other forum no response. I have this morning created reports from the corrected XML file. I am starting to input manually. It may take a week or so to re-input the data but carrying on with the current effort is completely pointless. I do think that the GNU cash Web site should take down any link to the App and further issue a massive health warning about the App. Having said that. Since upgrading I gave scheduled a daily QIF download from the App. GNU Cash so far appears to be able to handle these tiny QIF files. But I would urge users not to enter a volume of data on the App. It is a disastrous waste of time. On Tue, Jan 30, 2018, at 8:22 AM, Geert Janssens wrote: > Op dinsdag 30 januari 2018 07:59:01 CET schreef john_mike: > > Confused! > > > > Back ground : Trying to get damaged transactions from phone to main file. > > Transactions entered whilst phone app had some sort of double minus problem. > > > > > > What I have done: > > > > The only way to repair the transactions was to export as an XML file. Open > > that XML in GNUCash. Go through line by line and enter amounts. > > > > Now I want these transactions to be imported into my main file. > > > > > > I have attempted to export these corrected transactions to a QIF File. But > > this option does not seem to exist. So have followed the export to CSV file. > > > > Now when attempting to import these CSV files to my main file. It fails. > > > I'm sorry you have such trouble trying to interchange data between these two > applications. > > But you really should ask help on the Gnucash for Android forum, which is not > here. The issue starts there in this particular case, and there nothing > gnucash on desktop can do about this I'm afraid. > > CSV import in gnucash 2.6 and before has a very limited scope: it was written > solely for importing bank statements and the options to tweak it show this. > GnuCash data (like exported from gnucash to CSV) on the other hand has much > more detail and the importer has no knowledge of how to interpret this. So in > 2.6, a CSV export/import cycle won't work. The upcoming 3.0 will allow this, > but for your specific problem it will come a few months too late probably. > > Good luck solving your issue! > > Geert > > -- Mike Stillingfleet mikestillingfl...@fastmail.co.uk ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.gnucash.org%2Fmailman%2Flistinfo%2Fgnucash-user&data=02%7C01%7C%7C51cdae5a0fd948a6251808d567c4913c%7C84df9e7fe9f640afb435%7C1%7C0%7C636529016297750524&sdata=W0zv1rhjxbBbxXl%2FHG4UO8wfyNkF9J1BCi9UjdZUqH8%3D&reserved=0 If you are using Nabble or Gmane, please see https://nam02.safelinks.pro
Re: Merging Files or Other Method getting Transactions into main File.
Thanks Geert, yes I have previously had a go at that other forum no response. I have this morning created reports from the corrected XML file. I am starting to input manually. It may take a week or so to re-input the data but carrying on with the current effort is completely pointless. I do think that the GNU cash Web site should take down any link to the App and further issue a massive health warning about the App. Having said that. Since upgrading I gave scheduled a daily QIF download from the App. GNU Cash so far appears to be able to handle these tiny QIF files. But I would urge users not to enter a volume of data on the App. It is a disastrous waste of time. On Tue, Jan 30, 2018, at 8:22 AM, Geert Janssens wrote: > Op dinsdag 30 januari 2018 07:59:01 CET schreef john_mike: > > Confused! > > > > Back ground : Trying to get damaged transactions from phone to main file. > > Transactions entered whilst phone app had some sort of double minus problem. > > > > > > What I have done: > > > > The only way to repair the transactions was to export as an XML file. Open > > that XML in GNUCash. Go through line by line and enter amounts. > > > > Now I want these transactions to be imported into my main file. > > > > > > I have attempted to export these corrected transactions to a QIF File. But > > this option does not seem to exist. So have followed the export to CSV file. > > > > Now when attempting to import these CSV files to my main file. It fails. > > > I'm sorry you have such trouble trying to interchange data between these two > applications. > > But you really should ask help on the Gnucash for Android forum, which is not > here. The issue starts there in this particular case, and there nothing > gnucash on desktop can do about this I'm afraid. > > CSV import in gnucash 2.6 and before has a very limited scope: it was written > solely for importing bank statements and the options to tweak it show this. > GnuCash data (like exported from gnucash to CSV) on the other hand has much > more detail and the importer has no knowledge of how to interpret this. So in > 2.6, a CSV export/import cycle won't work. The upcoming 3.0 will allow this, > but for your specific problem it will come a few months too late probably. > > Good luck solving your issue! > > Geert > > -- Mike Stillingfleet mikestillingfl...@fastmail.co.uk ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: Merging Files or Other Method getting Transactions into main File.
Op dinsdag 30 januari 2018 07:59:01 CET schreef john_mike: > Confused! > > Back ground : Trying to get damaged transactions from phone to main file. > Transactions entered whilst phone app had some sort of double minus problem. > > > What I have done: > > The only way to repair the transactions was to export as an XML file. Open > that XML in GNUCash. Go through line by line and enter amounts. > > Now I want these transactions to be imported into my main file. > > > I have attempted to export these corrected transactions to a QIF File. But > this option does not seem to exist. So have followed the export to CSV file. > > Now when attempting to import these CSV files to my main file. It fails. > I'm sorry you have such trouble trying to interchange data between these two applications. But you really should ask help on the Gnucash for Android forum, which is not here. The issue starts there in this particular case, and there nothing gnucash on desktop can do about this I'm afraid. CSV import in gnucash 2.6 and before has a very limited scope: it was written solely for importing bank statements and the options to tweak it show this. GnuCash data (like exported from gnucash to CSV) on the other hand has much more detail and the importer has no knowledge of how to interpret this. So in 2.6, a CSV export/import cycle won't work. The upcoming 3.0 will allow this, but for your specific problem it will come a few months too late probably. Good luck solving your issue! Geert ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: Merging Files or Other Method getting Transactions into main File.
GnuCash for Android is a separate project. The developers of GnuCash (or this mailing list) are not affiliated with it. The GnuCash project has a link to it because users of GnuCash may be interested in it. So you’ve found that this 3rd party app for your phone had a bug. That happens from time to time with any software, including GnuCash itself. The bug, as has been noted on this forum very recently (last few days) MANY times, has been fixed in newer releases. I would think removing mention of the app from the GnuCash website on account of a bug would be a bit too far. Just update the app on your phone and re-export the data. Is that not possible for you? Perhaps I’m misunderstanding, but I didn’t interpret that the bug was a damage to the data file on the phone, but rather an incorrect export. If it really did damage your file, other than restoring from a backup and manually entering in the later transactions, or manually keying in everything from the phone to the desktop version, I’m not sure there’s a simpler solution. But if you can see the full data on the phone, then I suspect updating the app and re-exporting will solve the dilemma. Regards, Adrien > On Jan 30, 2018, at 12:59 AM, john_mike > wrote: > > Confused! > > Back ground : Trying to get damaged transactions from phone to main file. > Transactions entered whilst phone app had some sort of double minus problem. > > > What I have done: > > The only way to repair the transactions was to export as an XML file. Open > that XML in GNUCash. Go through line by line and enter amounts. > > Now I want these transactions to be imported into my main file. > > > I have attempted to export these corrected transactions to a QIF File. But > this option does not seem to exist. So have followed the export to CSV file. > > Now when attempting to import these CSV files to my main file. It fails. > > So is there a way to simply merging the two XML files rather than importing > them. > > > If not I will print the transactions out and start manually entering them in > my main file as this is now totally beyond a joke. > > I say again. > > AS THE GNUCASH ANDROID APP DOES NOT WORK PLEASE PLEASE PLEASE REMOVE IT FROM > THE GNUCASH WEB SITE SO THAT NO ONE ELSE SUFFERS THIS HUGE WASTE OF TIME. > > > > > > > > > -- > Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Merging Files or Other Method getting Transactions into main File.
Confused! Back ground : Trying to get damaged transactions from phone to main file. Transactions entered whilst phone app had some sort of double minus problem. What I have done: The only way to repair the transactions was to export as an XML file. Open that XML in GNUCash. Go through line by line and enter amounts. Now I want these transactions to be imported into my main file. I have attempted to export these corrected transactions to a QIF File. But this option does not seem to exist. So have followed the export to CSV file. Now when attempting to import these CSV files to my main file. It fails. So is there a way to simply merging the two XML files rather than importing them. If not I will print the transactions out and start manually entering them in my main file as this is now totally beyond a joke. I say again. AS THE GNUCASH ANDROID APP DOES NOT WORK PLEASE PLEASE PLEASE REMOVE IT FROM THE GNUCASH WEB SITE SO THAT NO ONE ELSE SUFFERS THIS HUGE WASTE OF TIME. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
