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:mikestillingfleet at fastmail.co.uk>
Sent: Tuesday, 30 January 2018 8:33 PM
To: Geert Janssens<mailto:geert.gnucash at kobaltwit.be>; gnucash-user at gnucash.org<mailto:gnucash-user at 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
  mikestillingfleet at fastmail.co.uk
_______________________________________________
gnucash-user mailing list
gnucash-user at 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%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636529016297750524&sdata=W0zv1rhjxbBbxXl%2FHG4UO8wfyNkF9J1BCi9UjdZUqH8%3D&reserved=0
If you are using Nabble or Gmane, please see https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwiki.gnucash.org%2Fwiki%2FMailing_Lists&data=02%7C01%7C%7C51cdae5a0fd948a6251808d567c4913c%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636529016297750524&sdata=rXuZ%2FU%2FL%2F9mVo%2B3ssU5RdPRmjm5x%2BMjpBijWFeh5gAU%3D&reserved=0 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.