importing splits

[Jeff Abrahamson]

Thanks.  I see my question wasn't clear.  My problem is that I want to
import the splits and it seems I can only import transactions.

I.e. (super simplified):

    deposit cheque           bank                      dx 100.00
    cheque 1        Alice    membership     rx 50.00
    cheque 2        Bob      membership     rx 50.00

Jeff


On Tue, Feb 20, 2018 at 09:01:54PM +0000, Matt Graham wrote:
> The easiest way would be saving  the spreadsheet to .csv format and importing
> that to Gnucash.
> 
> Id recommend:
> - first removing any other text and stuff you have so that the spreadsheet is
> just the headings you want and the data you want in columns
> - doing the import on a new test gnucash file first if you have a lot of data
> already in your gnucash book. Just in case.
> 
> Good luck!
> 
> Thanks and regards,
> Matt
> 
> 
> -------- Original message --------
> From: Jeff Abrahamson <jeff at p27.eu>
> Date: 21/2/18 05:00 (GMT+10:00)
> To: gnucash-user at gnucash.org
> Subject: importing splits
> 
> I'm processing check deposits.  I have a spreadsheet with lovely columns
> like name, check number, amount, and the account to debit.  It seems a
> shame to retype it all.
> 
> I see some old discussion on the list that, essentially, says this is
> not well supported if supported at all.
> 
>     https://nam04.safelinks.protection.outlook.com/?url=
> https%3A%2F%2Flists.gnucash.org%2Fpipermail%2Fgnucash-user%2F2014-October%2F056617.html
> &data=
> 02%7C01%7C%7C78035f813c42409f0bb008d5788bde6b%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636547464489079590
> &sdata=uG5aM8vQ0%2FJ6JvudouGDUL%2F%2BJaLVQvq%2FOQcX93gD%2BaA%3D&reserved=0
> 
> Is there anything since that might help?  I'm not sure converting
> spreadsheets to QIF to then import into gnucash is better than retyping.
> 
> --
> 
> Jeff Abrahamson
> +33 6 24 40 01 57
> +44 7920 594 255
> 
> https://nam04.safelinks.protection.outlook.com/?url=
> http%3A%2F%2Fp27.eu%2Fjeff%2F&data=
> 02%7C01%7C%7C78035f813c42409f0bb008d5788bde6b%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636547464489079590
> &sdata=Y%2FRcHTU8yWdltXDL4zBTAMPN8grAsKCwY7mf%2FQfmhyw%3D&reserved=0
> 
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://nam04.safelinks.protection.outlook.com/?url=
> https%3A%2F%2Flists.gnucash.org%2Fmailman%2Flistinfo%2Fgnucash-user&data=
> 02%7C01%7C%7C78035f813c42409f0bb008d5788bde6b%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636547464489079590
> &sdata=LnIFOxRytZiVO6O4On68c7%2B%2FT6DbEEEOclsFRTwyxyo%3D&reserved=0
> If you are using Nabble or Gmane, please see https://
> nam04.safelinks.protection.outlook.com/?url=
> https%3A%2F%2Fwiki.gnucash.org%2Fwiki%2FMailing_Lists&data=
> 02%7C01%7C%7C78035f813c42409f0bb008d5788bde6b%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636547464489079590
> &sdata=gnCglOKNDVqlWOaz1Wc4ilJcgVFWM9OkBtXcCFXJdWE%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.