[GNC] GNC 3.3 CSV Importer Freezing on MacOS

classic Classic list List threaded Threaded
36 messages Options
12
Reply | Threaded
Open this post in threaded view
|

[GNC] GNC 3.3 CSV Importer Freezing on MacOS

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 saved at the time.

But now the CSV import doesn't work. When I click "next" on the "transaction
information" window everything stops...it freezes. I've done this several
times and left it to run for hours at one point so I'm quite sure it's not
just being slow.

Any ideas would be appreciated. Because I'm having to forcefully terminate
the application, each time I restart it it fails to obtain the file lock and
I select the "open anyway" option - could this be relevant?

Thanks in advance.



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
_______________________________________________
gnucash-user mailing list
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|

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

John Ralls-2
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 <[hidden email]> 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 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 saved at the time.
>
> But now the CSV import doesn't work. When I click "next" on the "transaction
> information" window everything stops...it freezes. I've done this several
> times and left it to run for hours at one point so I'm quite sure it's not
> just being slow.
>
> Any ideas would be appreciated. Because I'm having to forcefully terminate
> the application, each time I restart it it fails to obtain the file lock and
> I select the "open anyway" option - could this be relevant?
>
> Thanks in advance.
>
>
>
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> _______________________________________________
> gnucash-user mailing list
> [hidden email]
> 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
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|

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

klawani
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 <[hidden email]> 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, 2018, at 2:19 PM, klawani <[hidden email]> 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 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 saved at the time.
> >
> > But now the CSV import doesn't work. When I click "next" on the "transaction
> > information" window everything stops...it freezes. I've done this several
> > times and left it to run for hours at one point so I'm quite sure it's not
> > just being slow.
> >
> > Any ideas would be appreciated. Because I'm having to forcefully terminate
> > the application, each time I restart it it fails to obtain the file lock and
> > I select the "open anyway" option - could this be relevant?
> >
> > Thanks in advance.
> >
> >
> >
> > --
> > Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> > _______________________________________________
> > gnucash-user mailing list
> > [hidden email]
> > 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
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|

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

klawani
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 <[hidden email]> 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, 2018 at 10:28 PM John Ralls <[hidden email]> 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, 2018, at 2:19 PM, klawani <[hidden email]> 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 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 saved at the time.
> > >
> > > But now the CSV import doesn't work. When I click "next" on the "transaction
> > > information" window everything stops...it freezes. I've done this several
> > > times and left it to run for hours at one point so I'm quite sure it's not
> > > just being slow.
> > >
> > > Any ideas would be appreciated. Because I'm having to forcefully terminate
> > > the application, each time I restart it it fails to obtain the file lock and
> > > I select the "open anyway" option - could this be relevant?
> > >
> > > Thanks in advance.
> > >
> > >
> > >
> > > --
> > > Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> > > _______________________________________________
> > > gnucash-user mailing list
> > > [hidden email]
> > > 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
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|

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

Geert Janssens-4
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 particular transaction that doesn't work ?
You can do so by repeatedly cutting your file in half and continue with the
half (or halves) that doesn't (don't) work.


Geert

[1] http://wiki.gnucash.org/wiki/Tracefile
Op dinsdag 30 oktober 2018 18:42:15 CET schreef 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 <[hidden email]> 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, 2018 at 10:28 PM John Ralls <[hidden email]> 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, 2018, at 2:19 PM, klawani <[hidden email]> 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 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 saved at the time.
> > > >
> > > > But now the CSV import doesn't work. When I click "next" on the
> > > > "transaction information" window everything stops...it freezes. I've
> > > > done this several times and left it to run for hours at one point so
> > > > I'm quite sure it's not just being slow.
> > > >
> > > > Any ideas would be appreciated. Because I'm having to forcefully
> > > > terminate
> > > > the application, each time I restart it it fails to obtain the file
> > > > lock and I select the "open anyway" option - could this be relevant?
> > > >
> > > > Thanks in advance.
> > > >
> > > >
> > > >
> > > > --
> > > > Sent from:
> > > > http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> > > > _______________________________________________
> > > > gnucash-user mailing list
> > > > [hidden email]
> > > > 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
> [hidden email]
> 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
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|

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

btrib
In reply to this post by klawani
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 CSV
importing at all costs. I wish there was a way to disable or remove it from
the menu. It's by far the worst thing that's ever happened to my GnuCash
data.



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
_______________________________________________
gnucash-user mailing list
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|

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

David Carlson-4
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  to ascertain the best
procedure for the task.

One thing for sure is to save the data files often and back up often.

David C

On Sun, Nov 4, 2018, 3:43 PM btrib <[hidden email] wrote:

> 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 CSV
> importing at all costs. I wish there was a way to disable or remove it from
> the menu. It's by far the worst thing that's ever happened to my GnuCash
> data.
>
>
>
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> _______________________________________________
> gnucash-user mailing list
> [hidden email]
> 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
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|

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

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 one entire account, many transactions with detailed splits and
dozens of invoices.



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
_______________________________________________
gnucash-user mailing list
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|

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

GnuCash - User mailing list

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 the fact that the developer for those parts didn't incorporate them into the logging process. As I understand it, accounts are also part of this omission. 
 
I know that doesn't help you out.  Sorry. 
David
 
  On Mon, Nov 5, 2018 at 7:26, btrib<[hidden email]> wrote:   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 one entire account, many transactions with detailed splits and
dozens of invoices.



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
_______________________________________________
gnucash-user mailing list
[hidden email]
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
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|

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

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: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
_______________________________________________
gnucash-user mailing list
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|

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

David Carlson-4
In reply to this post by btrib
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 <[hidden email] wrote:

> 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 one entire account, many transactions with detailed splits and
> dozens of invoices.
>
>
>
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> _______________________________________________
> gnucash-user mailing list
> [hidden email]
> 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
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|

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

btrib
In reply to this post by 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 log which I had.

The fact is that log files are only useful if you have all accounts in place
completely unchanged -- that is, if an account is created, moved or lost
then users will find that the replaying log files in order to restore data
will not work.

This is due to the fact that GnuCash uses an identification number in
conjunction with the account name to log each transaction in the log file.

My workaround was to:
1. manually recreate the Account in GnuCash with the same name
2. enter a transaction into the recreated account
3. open the active log file
4. copy the new account ID number (acc_guid) which is located just before
the account name
5. open the log file containing the data you want to restore
6. use "find and replace" to overwrite the old account ID with the correct
ID number

After this I was able to replay the log and restore the entire account and
all missing transactions. Hope this can help someone else!



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
_______________________________________________
gnucash-user mailing list
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|

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

GnuCash - User mailing list

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 account ID from the log file. In that case you would only have to change the single ID for the account, rather than every transaction in the log. 
While it is true that you ARE tinkering around in your main data file, that was already messed up (and you have backups as well, anyway), so the risk is mitigated. 
David
 
 
  On Mon, Nov 5, 2018 at 11:29, btrib<[hidden email]> wrote:   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 log which I had.

The fact is that log files are only useful if you have all accounts in place
completely unchanged -- that is, if an account is created, moved or lost
then users will find that the replaying log files in order to restore data
will not work.

This is due to the fact that GnuCash uses an identification number in
conjunction with the account name to log each transaction in the log file.

My workaround was to:
1. manually recreate the Account in GnuCash with the same name
2. enter a transaction into the recreated account
3. open the active log file
4. copy the new account ID number (acc_guid) which is located just before
the account name
5. open the log file containing the data you want to restore
6. use "find and replace" to overwrite the old account ID with the correct
ID number

After this I was able to replay the log and restore the entire account and
all missing transactions. Hope this can help someone else!



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
_______________________________________________
gnucash-user mailing list
[hidden email]
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
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|

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

Geert Janssens-4
In reply to this post by btrib
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 -- all gone. CSV import has huge problems, stay away from any CSV
> importing at all costs. I wish there was a way to disable or remove it from
> the menu. It's by far the worst thing that's ever happened to my GnuCash
> data.

I'm sorry you had such a poor experience with the CSV importer and I'm glad
you were able to recover most of your data (as I read in the remainder of the
thread).

However none of this helps me in any way to improve the CSV importer. I
completely agree it shouldn't crash or make you lose data. But I'll need more
details to figure out why it crashed.

If you can consistently reproduce it, may I ask you to create a bug report in
our Bugzilla instance [1] and supply the details needed for me to reproduce it
as well ? Ideally, attach a simple test file and a small csv file that
triggers the crash. Or a large csv file if that's what's needed to make it
crash.

For the record, I can successfully run the csv importer with a csv file
containing about 2000 transactions. It's a bit slow, but not out of the
ordinary (15 to 20 seconds of delays). So clearly the size of the csv file
itself is not the only factor and my test setup is not having what is needed
to induce the crash.

Regards,

Geert

[1] Refer to http://wiki.gnucash.org/wiki/Bugzilla on how to use our bug
tracker


_______________________________________________
gnucash-user mailing list
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|

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

btrib
In reply to this post by GnuCash - User mailing list
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
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|

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

Colin Law
n Mon, 5 Nov 2018 at 15:47, btrib <[hidden email]> 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
setting only affects what happens when a file is saved.  Once you have
it all working then you tick the box and next time it is saved it will
be compressed again.

Colin
_______________________________________________
gnucash-user mailing list
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|

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

btrib
In reply to this post by David Carlson-4
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
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|

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

btrib
In reply to this post by Colin Law
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
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|

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

btrib
In reply to this post by Geert Janssens-4
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 YYYY/MM/DD despite the CSV transaction
dates being formatted as MM/DD/YYYY. This is what causes the program to
crash. In the new stable version 3.3 the importer provides user feedback to
correct the date and does not allow the import to proceed until fixed.



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
_______________________________________________
gnucash-user mailing list
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|

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

Geert Janssens-4
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 YYYY/MM/DD despite the CSV transaction
> dates being formatted as MM/DD/YYYY. This is what causes the program to
> crash. In the new stable version 3.3 the importer provides user feedback to
> correct the date and does not allow the import to proceed until fixed.

I'm glad you found the issue and got it working.

Note the original reporter *was* using gnucash 3.3. So I assumed you did as
well when you jumped in...

Regards,

Geert


_______________________________________________
gnucash-user mailing list
[hidden email]
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.
12