Re: [GNC] Importing csv files

2023-01-21 Thread Mark Bole
I *did* provide a "well-detailed example", as shown in my post copied below (one line with header info, one line of data).  But apparently no one looked at it to the point of finding my somewhat obvious error (not complaining, I realize this is a volunteer resource). So, the other thing I did

Re: [GNC] Importing csv files

2023-01-19 Thread David Carlson
Mark, The Help manual chapter 6 gives a good starting point to configuring a successful CSV transaction import. However, it does not describe importing accounts. GnuCash is supposed to be able to import anything that it can export, so if you try to find an existing account tree example in a

Re: [GNC] Importing csv files

2023-01-19 Thread flywire
There is no panacea for replacing QuickBooks with GnuCash but I'm starting to warm to the workarounds: * https://lists.gnucash.org/pipermail/gnucash-user/2022-February/099811.html - use tags instead of classes, the transaction report is the only one that supports filtering so other reports would

Re: [GNC] Importing csv files

2023-01-19 Thread Mark Bole
By coincidence, I too am trying to import my QuickBooks well-tuned COA into GnuCash via CSV files.  I already knew to try the things recommended in this thread but still have indeterminate results. I realize by now that with the time already invested (especially after I finish writing this), I

Re: [GNC] Importing csv files

2023-01-19 Thread R Losey
Also, do you really need to import data from Quickbooks? I used Quicken, not Quickbooks, but (by and large), I just started up GnuCash afresh and went back to Quicken only when I needed to look things up. Now that I'm years into GnuCash, I have had no need to go back to Quicken. On Wed, Jan

Re: [GNC] Importing CSV files

2023-01-19 Thread rick1 via gnucash-user
-level account to another - take 2 (David T.) -- Message: 1 Date: Thu, 19 Jan 2023 22:27:20 +1100 From: flywire To: rudy beuc Cc: Gnucash Users Subject: [GNC] Importing csv files Message-ID: Content-Type: text/p

Re: [GNC] Importing csv files

2023-01-19 Thread Michael or Penny Novack
On 1/19/2023 6:27 AM, flywire wrote: Make sure you understand what Gnucash offers as it could be a massive downgrade from Quickbooks. I use Quickbooks and GnuCash, each for different books because neither has all the features I need. Specifically, GnuCash does not support classes ... I

Re: [GNC] Importing csv files

2023-01-19 Thread Steve Brown
I've had very good results with this https://github.com/erikmack/qb-escape.git I had to back out the account code stuff in the most recent commit as it didn't work for my use case. The article referenced in the README was similarly helpful. Steve On Wed, 2023-01-18 at 19:29 -0600, rudy beuc

[GNC] Importing csv files

2023-01-19 Thread flywire
Make sure you understand what Gnucash offers as it could be a massive downgrade from Quickbooks. I use Quickbooks and GnuCash, each for different books because neither has all the features I need. Specifically, GnuCash does not support classes or automated GST (tax) for cash accounting (so I've

Re: [GNC] Importing csv files

2023-01-18 Thread Geoff
Hi Rudy The easiest way to learn is to set up a dummy GnuCash book with a few accounts and transactions (doubtless you have done this already as part of your evaluation), do an EXPORT from GnuCash, and study the structure of the CSV files produced by GnuCash. Hope this helps. Regards

Re: [GNC] Importing csv files

2023-01-18 Thread Adrien Monteleone
Welcome to GnuCash! I'm not sure there is any single discussion on this outside of what you'll find in the documentation. There are plenty of list threads on the topic in general, but most of them deal with a specific aspect, issue, error, etc. 'Best Practice' is to export small chunks and

[GNC] Importing csv files

2023-01-18 Thread rudy beuc
Hello, I'm trying to migrate from Quickbooks to GnuCash. I'd like to keep as much information as I can for record keeping. To that end I've first been trying to import my accounts structure in via a csv file and failing badly. Pre Christmas holidays I was getting an error message I could