[GNC] Multi split transactions using csv import

[Geert Janssens]

If it's not a one time chore you could look into writing a spreadsheet macro to do it for your each 
time.

Regards,

Geert

Op zondag 1 november 2020 06:42:19 CET schreef will at theprescotts.com:
> Is this a one time chore. I don't know about doing it on the Gnucash side,
> but it seems relatively easy to do in in a spreadsheet.
> 
> Insert a column for numbering the rows.
> 
> Duplicate all the rows as a block, i.e. with the second copy of all the rows
> following the first block e.g.
> 1 a ...
> 2 b ...
> 3 c ...
> 4 d ...
> 1 a ...
> 2 b ...
> 3 c ...
> 4 d ...
> 
> In the first block clear the column for one of the splits
> In the second block clear the column for the other split
> 
> In one block copy the splits into the same column they are in in the other
> block
> 
> Finally sort all rows to put the splits back on consecutive rows
> 1 a ...
> 1 a ...
> 2 b ...
> 2 b ...
> 3 c ...
> 3 c ...
> 4 d ...
> 4 d ...
> 
> Will
> 
> 
> 
> On 2020 Oct 31, at 10-31 19:21:14, Craig Phillips <craigphil at gmail.com>
> wrote:
> 
> Hi,
> 
> I've been scratching my head on how to do this for a significant time so
> hoping someone can help...
> 
> I have transactions that I have downloaded from a site, and that I would
> like to import into gnucash using a csv.
> 
> Each transaction is a row and in columns I have a total credit, balanced by
> the sum of two debits.
> 
> Normally when I'm trying to work out what my import file needs to look like
> I enter an example transaction manually and then download the transaction
> list from that sub account to give me an idea of what I would need to do.
> Having done that, and what I can gather from the documentation, it looks
> like split transaction entries are meant to be entered as rows one after
> the other. This would be painful for me as I have the necessary data in
> columns and I can't work out an easy way of transposing the data to
> individual rows.
> 
> So my question - can the csv import work for me if I'm looking to upload
> one row for a split transaction? (i.e. one credit balanced by two debits).
> If so, what does it look like?
> 
> Thanks in advance for your help.
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at 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 at 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.