Re: [GNC] mysql backend, second user (lock, for example)

2018-11-04 Thread craigarno
Geert Janssens-4 wrote > Op zondag 4 november 2018 14:49:22 CET schreef craigarno: >> Geert Janssens-4 wrote >> > Whether it can work depends on > whether the db layer we rely on has a notification mechanism for db > changes we > can hook into. The current db layer is provided by libdbi, which i

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] Accidentally Created .LNK file and now my entire GnuCash file is overwritten and I can't get back to work

2018-11-04 Thread David T. via gnucash-user
Gordon, It is so much simpler to just delete the files. They only serve as markers to gnucash to let gnucash itself know if the program is already running.  Renaming the files serves no purpose except to propagate files that aren't meant to last on disk after exiting the program. To suggest other

Re: [GNC] some data recovered but much is still missing

2018-11-04 Thread btrib
Solution found: http://gnucash.1415818.n4.nabble.com/GNC-GNC-3-3-CSV-Importer-Freezing-on-MacOS-tp4704858.html -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To updat

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] Accidentally Created .LNK file and now my entire GnuCash file is overwritten and I can't get back to work

2018-11-04 Thread GWB
Yes, but she doesn't want to delete them. GnuCash would not know the difference between deleting them or renaming them if the extensions were no longer .LNK or .LCK. Correct? I would find the timestamps of the .LNK and .LCK files, rename them, and try to find the .gnucash file with the closest ti

Re: [GNC] gnucash 3.x corrupts data file

2018-11-04 Thread David T. via gnucash-user
Jörg, Frank points you to the spurious date that is likely the source of your trouble. I believe that at some point, the developers put in a data check into the upgrade process, to prevent errors from propagating forward, which would explain the problem arising now. Perhaps you could manually a

Re: [GNC] Accidentally Created .LNK file and now my entire G

2018-11-04 Thread David T. via gnucash-user
The Guide does explain this-- in the Basics chapter https://www.gnucash.org/docs/v3/C/gnucash-guide/basics-backup1.html David On Mon, Nov 5, 2018 at 7:42, David T. via gnucash-user wrote: As others explained, the lck and lnk files are created by gnucash to prevent users accidentally ope

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] Accidentally Created .LNK file and now my entire GnuCash file is overwritten and I can't get back to work

2018-11-04 Thread David T. via gnucash-user
As others explained, the lck and lnk files are created by gnucash to prevent users accidentally opening the data file on multiple machines. They are zero bytes in size and there is no point in trying to open them up. There is no there there.  On Mon, Nov 5, 2018 at 7:08, GWB wrote: Hell

Re: [GNC] gnucash 3.x corrupts data file

2018-11-04 Thread Frank H. Ellenberger
Hi Jörg, Am 05.11.18 um 01:31 schrieb Jörg Schaible: > When I start gnucash from the console, it will print an entry of the data > file, when the dialog appears: > > >e1822daceb8b84988373e0df77f579cf > > CURRENCY > EUR > > > 2013-01-26 19:28:12 +0100 > >

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] Accidentally Created .LNK file and now my entire GnuCash file is overwritten and I can't get back to work

2018-11-04 Thread GWB
Hello, Anita, GnuCash User list, The attachment smime.p7s might be a file format (.p7s) that is unique to microsoft outlook, so I'm not having any luck opening it. I use Macs, but not for gnucash, so perhaps you might try: 1. Using the spotlight feature in Mac to search for all files ending in .

[GNC] gnucash 3.x corrupts data file

2018-11-04 Thread Jörg Schaible
Hi, I am a long time user of gnucash (~ fora decade) and have used until last month version 2.7.4. My distribution (Gentoo) set then version 3.2 as stable so I switched to it. I can open my data file written by 2.7.4 with success, but as soon as I make a change a and write it back, gnucash is

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

[GNC] Hide Num Column in Basic Ledger

2018-11-04 Thread Rares Vernica
Hello, Is it possible to hide the Num column in Basic Ledger. I can drag the Num column header and make it not show, but it is till there when I step from column to column with TAB. Is there a way to configure GnuCash so that it totally hides (or hides from TAB as well). Ideally, it would also be

Re: [GNC] Fedora => Debian 3.2 => 2.1.15 Data Conversion Issues

2018-11-04 Thread Adrien Monteleone
A slight correction to my earlier post... You don’t need to build to obtain 3.3. As you can see from the .deb files listed, Sid contains 3.3 already. Regards, Adrien > On Nov 4, 2018, at 3:33 PM, Adrien Monteleone > wrote: > > I’m not sure I’m following completely. > > Are you saying you sw

Re: [GNC] Accidentally Created .LNK file and now my entire GnuCash file is overwritten and I can't get back to work

2018-11-04 Thread David Cousens
My bad there Geert. Maybe the wiki needs a bit of modification to make it clearer to that it is the meta data and not the actual data files as I did read it as the default location for the user's gnucash accounting data files and perhaps a note distinguishing these from the accounting data files

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] Fedora => Debian 3.2 => 2.1.15 Data Conversion Issues

2018-11-04 Thread Adrien Monteleone
I’m not sure I’m following completely. Are you saying you switched from Fedora using GnuCash 3.x to Debian running GnuCash 2.6.15? (hopefully not 2.1.15 as that is ancient) And that you want to open those newer data files on 2.6.15? If that is the case, no, you cannot as you’ve discovered. I do

[GNC] some data recovered but much is still missing

2018-11-04 Thread btrib
I was able to recover some data from a log file but an important account with many detailed splits was not recreated. I'm hoping that GnuCash has transactions for that account stored. At the time I replayed the log file the account was non-existent. My hope was that the replay would recreate that

[GNC] gnucash: Not able to get Online Quotes to work

2018-11-04 Thread Joe Peters
When trying to edit a security, in the 'Edit Security' window, under 'Quote Source Information', everything is grayed out and there is a warning: '> Warning: Finance::Quote not installed properly. <. GnuCash Help|About Version: 3.2 Build ID: 3.2+ (2018-06-24) Finance::Quote: - * I am runn

[GNC] Fedora => Debian 3.2 => 2.1.15 Data Conversion Issues

2018-11-04 Thread Wolfram Wagner
Dear list, After a server break down and huge problems to save my data over the necessary re-install, I moved away from fedora to debian. I am lucky here, but there is a big issue. One of my two gnucash databases cannot be opened in version 2.1.15 because of "use account GUID as key in bayesian fi

Re: [GNC] Accidentally Created .LNK file and now my entire GnuCash file is overwritten and I can't get back to work

2018-11-04 Thread Maf. King
Hi Anita, glad you are back with it! forwarding to the list for reference. Maf. On Sunday, 4 November 2018 16:38:23 GMT you wrote: > Maf, I did what you suggested and deleted the .LNK files that were zero > bytes and now I am back to work! Thank you so very much! > > Have there been any bug

Re: [GNC] Accidentally Created .LNK file and now my entire GnuCash file is overwritten and I can't get back to work

2018-11-04 Thread Maf. King
OK, the 3 screenshots have made it through. I don't understand - you said you had 2 gnucashes superimposed, but I can only see a single instance in the 3rd screenshot, which has the data file "LSA Nicosia (s) BE 175.gnucash" open. That looks to me like it is what you want, from the earlier dir

[GNC] This is the log file showing what I was working on when Gnucash crashed

2018-11-04 Thread Anita Graves via gnucash-user
LSA Nicosia (s) BE 175.gnucash.20181102145014.log Description: Binary data smime.p7s Description: S/MIME cryptographic signature ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https:/

Re: [GNC] Accidentally Created .LNK file and now my entire GnuCash file is overwritten and I can't get back to work

2018-11-04 Thread Anita Graves via gnucash-user
Maf, I think this is hopeless. The .LNK file is in the same listing with the other files and it did not get left behind. Instead, it is always opening, no matter what other file I try to pull thru the File>Open window. Anita > On 4 Nov 2018, at 18:07, Maf. King wrote: > > > Right. first t

Re: [GNC] Accidentally Created .LNK file and now my entire GnuCash file is overwritten and I can't get back to work

2018-11-04 Thread Anita Graves via gnucash-user
Maf, unfortunately the only file that I can open is the .LNK extension. The previous open file is in the list of files on my desktop that is right above the .LNK file (see the .pdf screenshots) and when I try to open that, it always and repeatedly opens the .LNK file. I have tried many times.

Re: [GNC] Accidentally Created .LNK file and now my entire GnuCash file is overwritten and I can't get back to work

2018-11-04 Thread Maf. King
Right. first things first. if GC crashes, it would be expected that a .LCK and .LNK would be left behind in the same folder as the datafile that you were working on at the time. The LNK file is supposed to be there while GC is running normally! It only got left behind because of the cras

Re: [GNC] Accidentally Created .LNK file and now my entire GnuCash file is overwritten and I can't get back to work

2018-11-04 Thread Anita Graves via gnucash-user
Dear Derek, that is exactly what I have done. I have opened the dropdown menu then what you have said: File>Open, and then I have browsed my computer looking for a file that pre-dates the .LNK one to see if it will open normally but I have found so far that all the files I have put into that a

Re: [GNC] Accidentally Created .LNK file and now my entire GnuCash file is overwritten and I can't get back to work

2018-11-04 Thread Anita Graves via gnucash-user
Maf, I am sorry. Yes, I aways mean gnucash, not gnu. I have the GnuCash icon in the dock and when I click on it, it is supposed to open my program so I can go to work. One day I was working in that program, and specifically in the checking account, and the program GnuCash crashed for a reaso

Re: [GNC] Accidentally Created .LNK file and now my entire GnuCash file is overwritten and I can't get back to work

2018-11-04 Thread Derek Atkins
Anita, On a MAC, you cannot double-click on a file. The "Open File" message doesn't get sent to GnuCash. The way to open a specific file on GnuCash is to open GnuCash and then File -> Open from the menu. It's the ONLY way you can open a specific data file on a Mac. -derek On Sun, November 4,

Re: [GNC] Accidentally Created .LNK file and now my entire GnuCash file is overwritten and I can't get back to work

2018-11-04 Thread Maf. King
do you mean that you click on the "GNUCASH" icon to start GC running (is it in the dock thingie, on your desktop, in a menu somewhere? Is it the same thing as you used to click before you had the system crash?)This is what I mean about being explicit. "Gnu" and "Gnucash" mean different th

Re: [GNC] Accidentally Created .LNK file and now my entire GnuCash file is overwritten and I can't get back to work

2018-11-04 Thread Derek Atkins
You can send a JPG through the list, but it needs to be sent as an actual *attachment* and not sent as in inline image. I.e., an HTML "page" with an embedded image will be blocked, but a standard MIME attachment will make it through fine. -derek On Sun, November 4, 2018 10:23 am, Maf. King wrot

Re: [GNC] Accidentally Created .LNK file and now my entire GnuCash file is overwritten and I can't get back to work

2018-11-04 Thread Anita Graves via gnucash-user
Maf, when I click on the gnu icon to open the program, this screen with these two images, one on top of the other comes up. That is what opens before my eyes. I am going to convert my .jpg photos to .pdf files and send them to you. Anita > On 4 Nov 2018, at 17:23, Maf. King wrote: > > Ok Ani

Re: [GNC] Accidentally Created .LNK file and now my entire GnuCash file is overwritten and I can't get back to work

2018-11-04 Thread Maf. King
Ok Anita, I'm sure jpg files are perfectly possible to be sent via the list. 99% sure that I've seen them. maybe convert to png as another option? if you can't get images through, you're going to have to be a lot more specific about what you do and what you can see. Where *exactly* do you se

Re: [GNC] Accidentally Created .LNK file and now my entire GnuCash file is overwritten and I can't get back to work

2018-11-04 Thread Anita Graves via gnucash-user
screenshots on a Mac are .jpg photo files. I think your system does not allow these thru. I am essentially locked out of my working mac file. For example, this .LNK file will not let me open my account ‘checking’. I cannot make any entries in my checking account, either debit or credit. In

Re: [GNC] Accidentally Created .LNK file and now my entire GnuCash file is overwritten and I can't get back to work

2018-11-04 Thread Colin Law
On Sun, 4 Nov 2018 at 15:03, Anita Graves via gnucash-user wrote: > > Oh, Geert, I do so wish you were right. However, I think you missed the > sentence where I said that after the crash I unknowingly and unthinkingly and > quickly in order to restore my screen, I clicked on ‘Open Anyway’ and t

Re: [GNC] Accidentally Created .LNK file and now my entire GnuCash file is overwritten and I can't get back to work

2018-11-04 Thread Anita Graves via gnucash-user
Oh, Geert, I do so wish you were right. However, I think you missed the sentence where I said that after the crash I unknowingly and unthinkingly and quickly in order to restore my screen, I clicked on ‘Open Anyway’ and that’s when my file was locked and this other ’thing’ called a .LNK sits ri

Re: [GNC] Accidentally Created .LNK file and now my entire GnuCash file is overwritten and I can't get back to work

2018-11-04 Thread Geert Janssens
Op zondag 4 november 2018 14:59:39 CET schreef Anita Graves via gnucash-user: > Dear Gnucash folks. I just > read on the Internet that the file extension .LNK is a Windows file > shortcut. What does that mean I don’t use Windows and thought I had > downloaded Gnucash for Mac. Thank you all.

Re: [GNC] Accidentally Created .LNK file and now my entire GnuCash file is overwritten and I can't get back to work

2018-11-04 Thread Geert Janssens
Op zondag 4 november 2018 14:32:56 CET schreef Frederick Bambrough: > In message <6825469.s9l7n08...@legolas.kobaltwit.lan> > > Geert Janssens wrote: > > So no not in the gnucash subdirectory of USER_DATA_HOME (which > > incidentally we refer to as GNC_DATA_HOME). these files should be where

Re: [GNC] mysql backend, second user (lock, for example)

2018-11-04 Thread Geert Janssens
Op zondag 4 november 2018 14:49:22 CET schreef craigarno: > Geert Janssens-4 wrote > > > Op zondag 4 november 2018 04:36:30 CET schreef craigarno: > > The only part I have no idea about at this stage is how to tell all views > > to refresh when one user makes a change. > > If you are headed towar

Re: [GNC] Accidentally Created .LNK file and now my entire GnuCash file is overwritten and I can't get back to work

2018-11-04 Thread Anita Graves via gnucash-user
Dear Gnucash folks. I just read on the Internet that the file extension .LNK is a Windows file shortcut. What does that mean I don’t use Windows and thought I had downloaded Gnucash for Mac. Thank you all. Anita Sent from my iPhone > On 4 Nov 2018, at 10:54, Maf. King wrote: > > Hi

Re: [GNC] mysql backend, second user (lock, for example)

2018-11-04 Thread craigarno
Geert Janssens-4 wrote > Op zondag 4 november 2018 04:36:30 CET schreef craigarno: > The only part I have no idea about at this stage is how to tell all views > to refresh when one user makes a change. If you are headed toward C++, the "Observer" Design Pattern may be able to get the "refresh view

Re: [GNC] Accidentally Created .LNK file and now my entire GnuCash file is overwritten and I can't get back to work

2018-11-04 Thread Frederick Bambrough
In message <6825469.s9l7n08...@legolas.kobaltwit.lan> Geert Janssens wrote: > So no not in the gnucash subdirectory of USER_DATA_HOME (which > incidentally we refer to as GNC_DATA_HOME). these files should be where > you saved them. > So for macOS, enter 'Accounts.gnucash' (without quotes)

[GNC] Opening Balance

2018-11-04 Thread info
___ 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

Re: [GNC] Accidentally Created .LNK file and now my entire GnuCash file is overwritten and I can't get back to work

2018-11-04 Thread Geert Janssens
Op zondag 4 november 2018 10:41:48 CET schreef David Cousens: > Anita, > > You may find the information on this wiki page useful in locating where your > data is stored. I am also not a MacOS user but some of the information at > https://wiki.gnucash.org/wiki/Configuration_Locations may help > The

Re: [GNC] Accidentally Created .LNK file and now my entire GnuCash file is overwritten and I can't get back to work

2018-11-04 Thread Maf. King
Hi Anita. I don't use a Mac, but I do know that you can't click-on-a-datafile to open it, you have to explicitly use the GC menu to File->Open an alternative (ie backup) file on Macs. If you are clicking on backups in the file manager, this might explain some of the behaviour you are seeing.

[GNC] Accidentally Created .LNK file and now my entire GnuCash file is overwritten and I can't get back to work

2018-11-04 Thread Anita Graves via gnucash-user
Dear all you GnuCash geniuses, I had a GnuCash crash and suddenly I tried to reopen the file and it gave me the option to quit, or open anyway, and I quickly and without thinking or knowing any better, clicked ‘open anyway’ and that was the end of my life as we know it. Besides the fact that n

Re: [GNC] Accidentally Created .LNK file and now my entire GnuCash file is overwritten and I can't get back to work

2018-11-04 Thread David Cousens
Anita, You may find the information on this wiki page useful in locating where your data is stored. I am also not a MacOS user but some of the information at https://wiki.gnucash.org/wiki/Configuration_Locations may help The section on USER_DATA_HOME will give you some locations where your GnuCash

Re: [GNC] mysql backend, second user (lock, for example)

2018-11-04 Thread Geert Janssens
Op zondag 4 november 2018 04:36:30 CET schreef craigarno: > My application is similar, except two of my users will be outside of my > local network, working from the Internet. I'm a tiny one man SOHO > operation who is off-site a lot of the time and may also be accessing my > GnuCash database remo

Re: [GNC] Accidentally Created .LNK file and now my entire GnuCash file is overwritten and I can't get back to work

2018-11-04 Thread Anita Graves via gnucash-user
Dear Maf, Thank you for your quick reply. I do not use file manager or any software connected to Windows or PC. I am not clicking on the data files. I am trying to open them thru the GnuCash drop down menu ‘Open’ and using that option to research my files to see if I can find anything that migh