Merging Files or Other Method getting Transactions into main File.

Mike Stillingfleet mikestillingfleet at fastmail.co.uk
Wed Jan 31 01:14:35 EST 2018


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 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.>  



--
  Mike Stillingfleet
  mikestillingfleet at fastmail.co.uk



Links:

  1. mailto:mikestillingfleet at fastmail.co.uk
  2. mailto:geert.gnucash at kobaltwit.be


More information about the gnucash-user mailing list