Re: [GNC] GNC 3.3 CSV Importer Freezing on MacOS

2018-11-07 Thread Derek Atkins
On Wed, November 7, 2018 11:18 am, btrib wrote: > By RE-APPLY do you mean to process a new identical payment, or can the > existing payment simply be re-designated? Either way works. You can either Process Payment, or Right Clien -> Apply as Payment. Up to you. > Please remember to CC this li

Re: [GNC] GNC 3.3 CSV Importer Freezing on MacOS

2018-11-07 Thread Derek Atkins
btrib writes: > How are invoices designated as paid in the xml file? Dont modify the XML file by hand. That's worse than replaying log files when you have business transactions! Just re-apply the payments, or mark the payment transactions properly. This of course assumes you fixed the potentia

Re: [GNC] GNC 3.3 CSV Importer Freezing on MacOS

2018-11-07 Thread btrib
By RE-APPLY do you mean to process a new identical payment, or can the existing payment simply be re-designated? -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To up

Re: [GNC] GNC 3.3 CSV Importer Freezing on MacOS

2018-11-06 Thread Derek Atkins
On Tue, November 6, 2018 1:46 pm, btrib wrote: > Thank you that's good to know if it ever occurs again. > Now, I need to find a workaround that will allow me mark the invoice as > paid. RE-apply the payment transaction. > Please remember to CC this list on all your replies. > You can do this by

Re: [GNC] GNC 3.3 CSV Importer Freezing on MacOS

2018-11-06 Thread btrib
How are invoices designated as paid in the xml file? -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https:/

Re: [GNC] GNC 3.3 CSV Importer Freezing on MacOS

2018-11-06 Thread btrib
Thank you that's good to know if it ever occurs again. Now, I need to find a workaround that will allow me mark the invoice as paid. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-us

Re: [GNC] GNC 3.3 CSV Importer Freezing on MacOS

2018-11-06 Thread Derek Atkins
Hi, On Tue, November 6, 2018 12:58 pm, btrib wrote: > I've updated to 3.3 and recovered all but the missing invoices. > In recreating the missing invoices the challenge is that duplicate > receivable entries will be created as well. Does anyone have a method they > would recommend to recreate invo

Re: [GNC] GNC 3.3 CSV Importer Freezing on MacOS

2018-11-06 Thread btrib
I've updated to 3.3 and recovered all but the missing invoices. In recreating the missing invoices the challenge is that duplicate receivable entries will be created as well. Does anyone have a method they would recommend to recreate invoices that will not throw off the receivable account? -- Se

Re: [GNC] GNC 3.3 CSV Importer Freezing on MacOS

2018-11-06 Thread Derek Atkins
Hi, On Tue, November 6, 2018 12:37 pm, btrib wrote: > Autosave simply updates the log file whereas closing the program updates > the > main file, correct? No, autosave automatically saves the full data file every N minutes (where you set N in your preferences) --- if there has been any changes to

Re: [GNC] GNC 3.3 CSV Importer Freezing on MacOS

2018-11-06 Thread Geert Janssens
Op dinsdag 6 november 2018 18:37:30 CET schreef btrib: > Autosave simply updates the log file whereas closing the program updates the > main file, correct? No. Autosave is a full save and as such updates the main file. The log files are updated while you create/modify/delete a transaction. Closi

Re: [GNC] GNC 3.3 CSV Importer Freezing on MacOS

2018-11-06 Thread Maf. King
On Tuesday, 6 November 2018 17:37:30 GMT btrib wrote: > Autosave simply updates the log file whereas closing the program updates the > main file, correct? > Incorrect, AFAIK Assuming you are using the XML back end to save your file (not SQLite), then triggering a save (autosave, or File->Save)

Re: [GNC] GNC 3.3 CSV Importer Freezing on MacOS

2018-11-06 Thread btrib
Autosave simply updates the log file whereas closing the program updates the main file, correct? -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscri

Re: [GNC] GNC 3.3 CSV Importer Freezing on MacOS

2018-11-06 Thread Derek Atkins
btrib writes: > Is there a setting to save and make backups automatically? I've looked but > cannot find. Yes, turn on Autosave. But it will only save if there are changes. > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek --

Re: [GNC] GNC 3.3 CSV Importer Freezing on MacOS

2018-11-05 Thread Stephen M. Butler
On 11/5/18 11:09 AM, btrib wrote: So, I'm just trying to understand, I deactivate compression and this makes the file openable as xml? After GNC has saved the file one more time. -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166

Re: [GNC] GNC 3.3 CSV Importer Freezing on MacOS

2018-11-05 Thread Stephen M. Butler
On 11/5/18 7:42 AM, btrib wrote: True! ...however, text editor is unable to open the main data file. How can the main file be manually accessed? Uncompress the file.  Your OS should have a utility that can do that.  On Linux I would use gunzip. -- Stephen M Butler, PMP, PSM stephen.m.butle.

Re: [GNC] GNC 3.3 CSV Importer Freezing on MacOS

2018-11-05 Thread Colin Law
On Mon, 5 Nov 2018 at 19:11, btrib wrote: > > So, I'm just trying to understand, I deactivate compression and this makes > the file openable as xml? It would be quicker to try it than ask, but yes. Colin ___ gnucash-user mailing list gnucash-user@gnuca

Re: [GNC] GNC 3.3 CSV Importer Freezing on MacOS

2018-11-05 Thread Geert Janssens
Op maandag 5 november 2018 20:15:00 CET schreef btrib: > Update! The problem is restricted to a malfunction with the date format in > the 2.6.16 version. Specifically, the program will allow the user to proceed > with import in the default format /MM/DD despite the CSV transaction > dates being

Re: [GNC] GNC 3.3 CSV Importer Freezing on MacOS

2018-11-05 Thread btrib
Update! The problem is restricted to a malfunction with the date format in the 2.6.16 version. Specifically, the program will allow the user to proceed with import in the default format /MM/DD despite the CSV transaction dates being formatted as MM/DD/. This is what causes the program to cr

Re: [GNC] GNC 3.3 CSV Importer Freezing on MacOS

2018-11-05 Thread btrib
So, I'm just trying to understand, I deactivate compression and this makes the file openable as xml? -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your sub

Re: [GNC] GNC 3.3 CSV Importer Freezing on MacOS

2018-11-05 Thread btrib
Is there a setting to save and make backups automatically? I've looked but cannot find. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription pre

Re: [GNC] GNC 3.3 CSV Importer Freezing on MacOS

2018-11-05 Thread Colin Law
n Mon, 5 Nov 2018 at 15:47, btrib wrote: > > True! ...however, text editor is unable to open the main data file. How can > the main file be manually accessed? In Edit > Preferences > General under Files clear the Compress Files checkbox. Then save it as xml and you will be able to edit it. That

Re: [GNC] GNC 3.3 CSV Importer Freezing on MacOS

2018-11-05 Thread btrib
True! ...however, text editor is unable to open the main data file. How can the main file be manually accessed? -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To upd

Re: [GNC] GNC 3.3 CSV Importer Freezing on MacOS

2018-11-05 Thread Geert Janssens
Op zondag 4 november 2018 22:40:59 CET schreef btrib: > Agreed. OFX/QIF works perfect. My CSV import did not only freeze but crashed > the program and caused me to lose a large amount of data. Hundreds of asset > transactions plus one entire liability account as well as several dozens of > invoices

Re: [GNC] GNC 3.3 CSV Importer Freezing on MacOS

2018-11-04 Thread David T. via gnucash-user
I'm glad you were able to engineer a solution! For what it's worth, you might have had similar success by switching around the edit point-- in other words, once you had recreated your account in the data file, you could have gone in and replaced the new account ID in your data file with the acc

Re: [GNC] GNC 3.3 CSV Importer Freezing on MacOS

2018-11-04 Thread btrib
David, thank you again! I was able to recover the missing account and ALL of my missing transactions! I just wanted to update for the community to have a record. Thanks to the article that David provided which points out that accounts are not part of log files, I was able to manipulate the data l

Re: [GNC] GNC 3.3 CSV Importer Freezing on MacOS

2018-11-04 Thread David Carlson
I based the estimate to be massive on your comments that you said you lost hundreds of transactions and it will take hours to reconstruct your lost data. If you make a backup every 15 minutes, you should only lose 15 minutes work at most. David C Sun, Nov 4, 2018, 7:56 PM btrib 100 transaction

Re: [GNC] GNC 3.3 CSV Importer Freezing on MacOS

2018-11-04 Thread btrib
Thanks David. I appreciate understanding how the program works. This is helpful to know, even though it doesn't cure my problem. At least now I know that if I can figure out how to read the log file it would help me to manually reconstruct the transactions for the missing account. -- Sent from:

Re: [GNC] GNC 3.3 CSV Importer Freezing on MacOS

2018-11-04 Thread David T. via gnucash-user
While I do not use the importers much these days, I will note that in  https://www.gnucash.org/docs/v3/C/gnucash-guide/basics-backup1.html, there is information regarding the items that are and are not covered by log files.  The reason that log files don't cover these, I believe, had to do with t

Re: [GNC] GNC 3.3 CSV Importer Freezing on MacOS

2018-11-04 Thread btrib
100 transactions is not what I'd consider massive. Nonetheless, I cannot understand why saving could not be done automatically or why the log file doesn't seem to contain all changes. I've tried to replay the log and it saved some but doesn't seem to restore all the transactions. I'm still missing

Re: [GNC] GNC 3.3 CSV Importer Freezing on MacOS

2018-11-04 Thread David Carlson
Btrib, I believe the CSV importer in release 3.3 is greatly improved over the old importer. However, being relatively new it probably has a few kinks remaining to be worked out. IT appears that you are trying to do a massive import from old files, possibly without sufficient planning and testing

Re: [GNC] GNC 3.3 CSV Importer Freezing on MacOS

2018-11-04 Thread btrib
Agreed. OFX/QIF works perfect. My CSV import did not only freeze but crashed the program and caused me to lose a large amount of data. Hundreds of asset transactions plus one entire liability account as well as several dozens of invoices -- all gone. CSV import has huge problems, stay away from any

Re: [GNC] GNC 3.3 CSV Importer Freezing on MacOS

2018-10-31 Thread Geert Janssens
I'm glad you have found a workaround. I would be interested in digging deeper at what went wrong with the cvs import though. Can you retry a cvs import and check what appears in the trace file [1] ? Alternatively can you try to reduce your 100 transaction csv file further in search of a partic

Re: [GNC] GNC 3.3 CSV Importer Freezing on MacOS

2018-10-30 Thread Wole Lawani
I was unable to get the CSV import to work. Eventually I converted the CSV to a QIF file and that worked. On Sun, Oct 28, 2018 at 10:34 PM Wole Lawani wrote: > > Thanks John. > I had tested with a small (c. 100 transactions) segment of the larger > file but it still freezes. > > On Sun, Oct 28, 2

Re: [GNC] GNC 3.3 CSV Importer Freezing on MacOS

2018-10-28 Thread Wole Lawani
Thanks John. I had tested with a small (c. 100 transactions) segment of the larger file but it still freezes. On Sun, Oct 28, 2018 at 10:28 PM John Ralls wrote: > > If you made a large CSV it might be > https://bugs.gnucash.org/show_bug.cgi?id=795383. > > Regards, > John Ralls > > > > On Oct 28,

Re: [GNC] GNC 3.3 CSV Importer Freezing on MacOS

2018-10-28 Thread John Ralls
If you made a large CSV it might be https://bugs.gnucash.org/show_bug.cgi?id=795383. Regards, John Ralls > On Oct 28, 2018, at 2:19 PM, klawani wrote: > > Hi. > A few days ago I was able to do my first successful CSV import on my GNC 3.3 > installation (MacOS 10.12.6 - Sierra). > I then spe

[GNC] GNC 3.3 CSV Importer Freezing on MacOS

2018-10-28 Thread klawani
Hi. A few days ago I was able to do my first successful CSV import on my GNC 3.3 installation (MacOS 10.12.6 - Sierra). I then spent a week preparing a much larger import. The CSV file is basically the same structure as was used for the earlier successful run - in fact I'm using the settings I sa