Re: Merging Files or Other Method getting Transactions into main File.

[Mike Stillingfleet]

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 the other

RE: Merging Files or Other Method getting Transactions into main File.

[Matt Graham]

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=02%7C01%7C%7C51cdae5a0fd948a6251808d567c4913c%7C84df9e7fe9f640afb435%7C1%7C0%7C636529016297750524=W0zv1rhjxbBbxXl%2FHG4UO8wfyNkF9J1BCi9UjdZUqH8%3D=0
If you are using Nabble or Gmane, please see 
https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwiki.gnucash.org

Re: Merging Files or Other Method getting Transactions into main File.

[Mike Stillingfleet]

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.

[Geert Janssens]

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.

[Adrien Monteleone]

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.