Re: [GNC] Debit/Credit in csv imports
Read over the importer help again. I don't use it personally, but I do recall from reading about it, that there is a way to specify additional splits on subsequent rows, however, you have to have your CSV formatted correctly, and I think you have to tell GnuCash you are using that format so it will expect additional splits in those rows. Regards, Adrien On 2/22/21 4:59 PM, Widar Nord wrote: Hello I'm trying to export a list of transactions from my ERP to GnuCash. The GnuCash importer seems to support splits between multiple accounts, however I cant find a way to import the credit and debit column. I may chose "Deposit" or "Withdrawal" but that will only support an imports for one account type each time, and not support split transactions. I refuse to believe this is an oversight from the software designers, so I have to ask: How do I map debit and credit columns in the importer, so it works with debit and credit columns in my chart of accounts? ___ 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.
[GNC] Debit/Credit in csv imports
Hello I'm trying to export a list of transactions from my ERP to GnuCash. The GnuCash importer seems to support splits between multiple accounts, however I cant find a way to import the credit and debit column. I may chose "Deposit" or "Withdrawal" but that will only support an imports for one account type each time, and not support split transactions. I refuse to believe this is an oversight from the software designers, so I have to ask: How do I map debit and credit columns in the importer, so it works with debit and credit columns in my chart of accounts? Kind Regards WIDAR NORD wi...@friatider.se _Vi ger Sverige en rak höger!_ DIREKT: +46812450987 FAX: +46850909765 WEBB: www.friatider.se [1] Links: -- [1] http://www.friatider.se ___ 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: CSV Imports
Op dinsdag 24 oktober 2017 07:33:24 CEST schreef Nick Judd: > Hello everyone, > > I have been using Gnucash for personal accounting for the last couple of > years. I have questions about CSV imports relevant to this thread: > > https://lists.gnucash.org/pipermail/gnucash-user/2017-March/069914.html > > 1. Using Gnucash 2.6.18, my experience is that it is not straightforward > to import transactions from CSV using a CSV /I have generated using > GNUCash/, into exactly the same account structure. > > Am I missing something here? > Yes. The thread you refer to talks about the CSV import improvements I have implemented in the development series. Anything in development will only appear in the next major release. In this case that will be 2.8 in a couple of months. If you're impatient, you can already test this functionality by downloading and installing gnucash 2.7.0, our first test release that will eventually lead up to gnucash 2.8.0. Do backup your data before you do so! There are still a few known crashers in that version (particularly on Windows). On the other hand your feedback would be greatly appreciated. > 2. Looking over previous threads, I understand that Gnucash's CSV import > cannot really handle multi-split transactions. I need multi-split > transactions and I can code well in Python but am useless in Gnucash's > native C/C++. The solutions that immediately come to mind are trying to > shoehorn the data in using Gnucash's Python API (bad) or to use Python > to reshape the CSV into a more Gnucash-friendly object (easier -> > better). However, the threads I have seen focus more on the general > notion that CSV import really isn't going to be ready for prime time > until 2.8 than on the kinds of things CSV import can currently do well. > I am interested in the latter. > Indeed, the major improvements to the CSV importer will only appear as of 2.7/2.8. The current CSV importer is pretty limited and was designed with only one fairly simple use case in mind: import bank statements. These typically have very little data: a date, a (bank) transaction number, a description and an amount. This reflects in the column options you have available in the CSV importer. Bank statements don't have multi-split transactions, and one split is always implied (to be in the bank account for which you're importing the bank statement). Later a few additions were made to the CSV importer but multi-split was not one of those... With that in mind you have only a few options IMO: - wait for 2.8 (the easiest, but perhaps not viable for your situation) - write a python script that does the import for you. There's no way the 2.6 version of the CSV importer will correctly import multi-split transactions. It will always interpret each line as a separate transaction. So manipulating the csv file to that effect won't work. - and perhaps one of the other import formats does support multi-split, but I have no experience with those. There is a utility on the net somewhere to convert xls files to qif. Perhaps that can be an alternative route. Regards, Geert ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: CSV Imports
Nick, The CSV import assistant in release 2.6 series is not able to import files created by GnuCash. This is a known problem which will be corrected when the 2.8 release comes out. That release will change the data file structure in a way that will not be readable by older releases of GnuCash. David C On Oct 24, 2017 12:48 AM, "Nick Judd" wrote: > Hello everyone, > > I have been using Gnucash for personal accounting for the last couple of > years. I have questions about CSV imports relevant to this thread: > > https://lists.gnucash.org/pipermail/gnucash-user/2017-March/069914.html > > 1. Using Gnucash 2.6.18, my experience is that it is not straightforward > to import transactions from CSV using a CSV /I have generated using > GNUCash/, into exactly the same account structure. > > Am I missing something here? > > 2. Looking over previous threads, I understand that Gnucash's CSV import > cannot really handle multi-split transactions. I need multi-split > transactions and I can code well in Python but am useless in Gnucash's > native C/C++. The solutions that immediately come to mind are trying to > shoehorn the data in using Gnucash's Python API (bad) or to use Python to > reshape the CSV into a more Gnucash-friendly object (easier -> better). > However, the threads I have seen focus more on the general notion that CSV > import really isn't going to be ready for prime time until 2.8 than on the > kinds of things CSV import can currently do well. I am interested in the > latter. > > > Apologies for retreading ground that I am sure comes up a lot. Thanks for > your help. > > > Best > > > Nick Judd > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > 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 https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
CSV Imports
Hello everyone, I have been using Gnucash for personal accounting for the last couple of years. I have questions about CSV imports relevant to this thread: https://lists.gnucash.org/pipermail/gnucash-user/2017-March/069914.html 1. Using Gnucash 2.6.18, my experience is that it is not straightforward to import transactions from CSV using a CSV /I have generated using GNUCash/, into exactly the same account structure. Am I missing something here? 2. Looking over previous threads, I understand that Gnucash's CSV import cannot really handle multi-split transactions. I need multi-split transactions and I can code well in Python but am useless in Gnucash's native C/C++. The solutions that immediately come to mind are trying to shoehorn the data in using Gnucash's Python API (bad) or to use Python to reshape the CSV into a more Gnucash-friendly object (easier -> better). However, the threads I have seen focus more on the general notion that CSV import really isn't going to be ready for prime time until 2.8 than on the kinds of things CSV import can currently do well. I am interested in the latter. Apologies for retreading ground that I am sure comes up a lot. Thanks for your help. Best Nick Judd ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.