Re: [GNC] Problem With Price Editor
Les, Actually, you did receive an answer to your question, from John Ralls, only a few hours after your post: On Jun 21, 2018, at 2:51 AM, Les wrote: Yesterday, I created a new stock account, like all of the other stock accounts that I have. The strange thing is while the stock is listed in my Security Editor, it is NOT listed in Price Editor. How is this possible? How can I fix this problem? Get or create a price for the new security. Regards, John Ralls CMR On 06/22/2018 05:31 AM, Les wrote: Previously I posted a problem where I had created a new stock entry but it never got populated in Price Editor although it is in Security Editor and in my list of stocks. Since I have not received any suggestions, I attempted to "fix" this myself but removing the account from my list of stocks and from Security Editor. I was able to remove it from my list of stocks, but when I attempted to remove it from Security Editor, I was prevented from doing so. So, I am appealing to the list for assistance with this issue. Any suggestions greatly appreciated. Les ___ 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. -- Linux distribution Debian 9 "Stretch" "Owning a handgun doesn't make you armed any more than owning a guitar makes you a musician." ~ Jeff Cooper -- ___ 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: [GNC] Backup and restore GnuCash Settings
As a long time Linux user and having used GnuCash for several years I can tell you that your GnuCash settings are in a hidden file in your home directory: ~/.gnucash You didn't say how you made your backup so, as David asked, did you back up your hidden files. If, for example, you used `tar` by running the command `tar cvf /home/tmp/backup.tar /home/nikos` then your hidden files should have been copied. However, if you instead ran `tar cvf backup.tar *` from within your home directory, your hidden files would not have been copied. HTH CMR On 05/16/2018 10:50 AM, David Carlson wrote: I am not an expert on Linux, so do not quote me here. I think that GnuCash puts the settings in a hidden folder under your user directory. Does your backup program also back up the hidden folders? David C On Wed, May 16, 2018 at 10:00 AM, Nikos Charonitakiswrote: Hi All I have recently made a back of my home directory on a fedora 27 pc and then i restored it to a new installation on fedora 28. I was expecting to open Gnucash and continue working on my latest Gnucash file and also have all my settings in place but this was not the case. Running Gnucash on the new installation is like you start application for the first time. Firefox for example does not have this behavior, all my setting plugins, bookmarks,passwords are in their place after restoring my home dir. Any ideas how to fix this? Note: This is not specific to GnuCash 3, i have seen the same thing and on previous gnucash versions. Nikos ___ 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. ___ 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. -- Linux distribution Debian 8 "Jessie" "The more you observe politics, the more you've got to admit that each party is worse than the other." -- Will Rogers -- ___ 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: [GNC] find AND REPLACE?
I'm still a novice at GnuCash but from previous discussions I do not believe that there is a global find and replace utility. But two ideas come to mind. If your file format is XML, isn't that a text file? If it is, you could use a text editor ('vi' if you're on Linux) to do a global search & replace. Or, if you are using SQLite, you could use the dump utility to create a text SQL file and, likewise, use a text editor. Then rebuild your GnuCash file from the edited SQL dump file. HTH! CMR On 04/09/2018 11:11 PM, Paul Costan wrote: I am looking for the command(s) or work-around to accomplish what I used to use in Quicken as Find and Replace. Specifically, after downloading multiple months of transactions from my credit union into a simple checkbook ledger, I could use the Quicken "find" to select all transactions with description "Safeway" and then select from them to "replace" the category to "Groceries". I'm good in Gnucash up through the Find part, can't figure out how to easily set the Account without a lot of keystrokes. Didn't see anything in the manual/help/faq. Suggestions? Thanks. ___ 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. -- Linux distribution Debian 8 "Jessie" "We contend that for a nation to tax itself into prosperity is like a man standing in a bucket and trying to lift himself up by the handle." --Winston Churchill -- ___ 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: GnuCash 3.0 Released
John, Thanks for all your hard work. GnuCash is an invaluable piece of software. Cheers! CMR On 04/02/2018 03:17 PM, John Ralls wrote: GnuCash 3.0 released The GnuCash development team proudly announces GnuCash 3.0, the first release in our new 3.x stable series. New Features for Users: The headline item for this release is that GnuCash now uses the Gtk+-3.0 Toolkit and the WebKit2Gtk API. This change was forced on us by some major Linux distributions dropping support for the WebKit1 API. Unfortunately the Webkit project doesn't support Microsoft Windows so that platform will continue to use the WebKit1 API, though with Gtk3. We've selected Gtk+-3.14.0 as the minimum version because it fully supports CSS theming. New editors to remove outdated or incorrect match data from the import maps, a new user interfacs for managing files associated with transactions, an improved facility for removing old prices from the price database, and a way to remove deleted files from the history list in the file menu. New Reports: A Reconciliation Report based on the Transaction Report,a Income GST Report, and a Cashflow Barchart report. A new CSV importer largely rewritten in C++, adding new features including the ability to re-import CSV files exported from GnuCash, along with a separate CSV price importer. A new preference panel for the Alphavantage API key so that Finance::Quote users need not edit /etc/gnucash/environment. We've removed all references to the various Yahoo! quote sources and made Alphavantage the default. Data file directories are now located appropriately to the operating system's conventions by default: Windows: CSIDL_APPDATA/Gnucash MacOS: $HOME/Application Support/Gnucash Linux: $XDG_CONFIG_HOME/gnucash (or the default $HOME/.config/gnucash) It's still possible to overried with the environment variable GNC_DOC_PATH, which replaces GNC_DOT_DIR in earlier versions of GnuCash. Accounts in the Bayes import map are now linked by GUID instead of names so that the matcher won't have to be retrained if you rename an account. The Bayesian import maps are also stored in a flatter structure to allow faster access, especially in SQL. These changes mean that if you have Bayesian mapping data, once converted your database will be loadable only by GnuCash 2.6.20 and later. MySQL and SQLite3 date storage has changed a bit. Once converted, MySQL and SQLite3 database will be loadable only by GnuCash 2.6.19 and later. Numerics are rewritten to allow for more significant digits. The old 6-digit-maximum fraction is now 9-digits, and prices may have up to 18 digit precision. Chart Reports appearance is improved, including more modern chart colours as suggested by http://clrs.cc/. Transaction Report improvements, including regular expression filtering and many more options and features including a "Subtotal Summary Grid" The subtotal summary-grid will tabulate subtotals - prime-sortkey vertically, sec-sortkey horizontally. For example, with prime-sortkey = accounts, sec-sortkey = date, sec-subtotal = monthly will produce a monthly time series table. The About dialog box layout is improved and now includes the detected Finance::Quote version. GnuCash will always build the locale-specific tax modules. This was optional when building with autotools and never enabled when building with cmake. Note that the only supported tax locales are en_US and de_DE. On Macs the Reconcile Window's menu moved to the menubar. GnuCash no longer supports Guile-1.8 and now does support Guile-2.2 New Features for Developers: Several parts of the engine and the SQL backend are rewritten in C++, an effort that will continue in the next development cycle. KVP is now private to libgncmod-engine and accessible outside via qof_instance_set and qof_instance_get. KVP and GUID are reimplemnted in C++ using boost::variant and boost::UUID respectively. C++ unit tests require GoogleTest. While it's possible to use prebuilt libgtest and libgmock on some distros, building static libraries for GnuCash is preferred. It may be necessary to provide the paths to the googletest and googlemock source with CMake parameters GTEST_ROOT and GMOCK_ROOT respectively. The date implementation is migrated to boost::date-time, replacing a Glib GDateTime implementation. This makes the earliest date recordable 1 January 1400CE instead of 1 January 1CE. We doubt any users will be affected. We've reorganized the code into a core library directory, libgnucash, and application-specific directory, gnucash. The python bindings are now in a top-level directory, bindings; code pinched from other projects is in borrowed, the account templates, check templates, and pixmaps are consolidated in data, and common holds the cmake modules and test framework code. The bin directory's contents have moved to the top
Re: Segmentation Fault
John, Thanks very much. That's good news -- not that I have a corrupted data file, but that I have a way forward! CMR On 02/23/2018 12:04 PM, John Ralls wrote: On Feb 23, 2018, at 9:40 AM, C M Reinehr <c...@reinehr.net> wrote: John, FYI, by clean I meant that I was running only Debian compiled programs downloaded from the repository, but in all honesty had forgotten that I had tried to install some of Doug Doughty's custom reports. In any case, I reinstalled Gnucash, created a new .gnucash directory into which I copied my existing gnucash data file (gnucash.personal in sql format) & tried again. Now I get only: Found Finance::Quote version 1.35 Segmentation fault I also rebuilt the data file with the .dump command. Here's the contents of the gnucash.trace file: * 11:33:18 CRIT [sqlite3_error_fn()] DBI error: -6: An invalid or out-of-range index was passed to libdbi Looks like you've got some bad data in your file. There have been several segfault fixes to the SQL backend since 2.6.4, but until you get around to upgrading those aren't available to you. You'll have to use the sqlite3 command-line tool to fix the row that's crashing. To find out what row that is, run `gnucash --log gnc.backend.dbi=debug`. That will write the SQL queries to your gnucash.trace file. The last one before the crash will reveal what row in what table is the problem and you can work up a query to fix it. https://wiki.gnucash.org/wiki/SQL describes the schema. Regards, John Ralls -- "Be polite, be professional, but have a plan to kill everybody you meet." -- General James Mattis ___ 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: Segmentation Fault
John, FYI, by clean I meant that I was running only Debian compiled programs downloaded from the repository, but in all honesty had forgotten that I had tried to install some of Doug Doughty's custom reports. In any case, I reinstalled Gnucash, created a new .gnucash directory into which I copied my existing gnucash data file (gnucash.personal in sql format) & tried again. Now I get only: Found Finance::Quote version 1.35 Segmentation fault I also rebuilt the data file with the .dump command. Here's the contents of the gnucash.trace file: * 11:33:18 CRIT [sqlite3_error_fn()] DBI error: -6: An invalid or out-of-range index was passed to libdbi Thanks! CMR On 02/23/2018 11:00 AM, John Ralls wrote: On Feb 23, 2018, at 8:10 AM, C M Reinehr <c...@reinehr.net> wrote: This morning I am unable to start Gnucash. Whenever I try I receive the following message: ;;; note: auto-compilation is enabled, set GUILE_AUTO_COMPILE=0 ;;; or pass the --no-auto-compile argument to disable. ;;; compiling /home/cmr/.gnucash/gnctimeperiod-utilities.scm ;;; WARNING: compilation of /home/cmr/.gnucash/gnctimeperiod-utilities.scm failed: ;;; ERROR: no code for module (gnucash gettext) Found Finance::Quote version 1.35 Segmentation fault and the program terminates. I have been running Gnucash v 2.6.4 for some time now on my Debian system -- "Jessie, v 8.10. All programs & libraries are up to date. I know that I could update Gnucash to a more current version but I prefer to run a "clean" Debian stable (in this case, old stable) system. Until recently this version of Gnucash has been more than satisfactory. Anyone have any ideas? You’re deceiving yourself about running a “clean” system: gnctimeperiod-utilities.scm is part of Doug Doughty’s transaction report extensions, not part of GnuCash proper. The error suggests that the compilation can’t find /share/gnucash/scm/gnucash/gettext.scm or /lib/gnucash/scm/ccache/2.0/gnucash/gettext.go. The most likely cause is that the environment variables GUILE_LOAD_PATH and GUILE_LOAD_COMPILED_PATH have gotten changed somehow. Regards, John Ralls -- "I've never let my school interfere with my education." -- Mark Twain ___ 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.
Segmentation Fault
This morning I am unable to start Gnucash. Whenever I try I receive the following message: ;;; note: auto-compilation is enabled, set GUILE_AUTO_COMPILE=0 ;;; or pass the --no-auto-compile argument to disable. ;;; compiling /home/cmr/.gnucash/gnctimeperiod-utilities.scm ;;; WARNING: compilation of /home/cmr/.gnucash/gnctimeperiod-utilities.scm failed: ;;; ERROR: no code for module (gnucash gettext) Found Finance::Quote version 1.35 Segmentation fault and the program terminates. I have been running Gnucash v 2.6.4 for some time now on my Debian system -- "Jessie, v 8.10. All programs & libraries are up to date. I know that I could update Gnucash to a more current version but I prefer to run a "clean" Debian stable (in this case, old stable) system. Until recently this version of Gnucash has been more than satisfactory. Anyone have any ideas? Thanks! CMR -- "Political power grows out of the barrel of a gun." -- Mao Zedong ___ 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: mailing list
Likewise, there is a link to instructions as to how to manage your subscription in the signature of every list email: 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. On 02/07/2018 03:51 PM, Kurt Padilla wrote: Graham, Please check your inbox for instructions on how to unsubscribe. These should have been automatically emailed to you when you signed up for the mailing list. Kurt On Wed, Feb 7, 2018, 16:45 Graham Jackswrote: A few days ago I asked you a question about GnuCash, as I was wondering whether to start using it. Since then I seem to have been put on your mailing list, and have been seeing a lot of email messages about issues related to GnuCash which mean nothing to me. After studying GnuCash, I don’t think it would be the program/app/system that I need, so could I ask you to take me off the mailing list? I will delete the messages that have already arrived. Best wishes, Graham Jacks ___ 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. -- "The spirit of resistance to government is so valuable on certain occasions that I wish it to be always kept alive. It will often be exercised when wrong, but better so than not to be exercised at all." -- Thomas Jefferson ___ 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: Keeping track of sales and expenses for a specific craft show
Ravenkwill, I would suggest setting up your chart of accounts to record the revenues & expenses and then use the notes field of each entry to identify the specific craft show. Later, you can then use the notes field as a filter when running profit & loss reports, or specific views. CMR On 02/05/2018 06:59 PM, ravenkwill wrote: My wife is an artist, and is beginning to do craft shows. I want to be able to track the profitability for each show by collecting expenses and sales. I've read through the manuals about jobs, but that doesn't seem to be quite right. Do I need to create a separate sub-account for each fair? That seems cumbersome. Examples of entries: show fees, hotel fees, food while traveling, and of course the sales during the event. I'd love ideas and suggestions about how to handle this. Thanks! -- 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://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. -- "A free people ought not only to be armed and disciplined, but they should have sufficient arms and ammunition to maintain a status of independence from any who might attempt to abuse them, which would include their own government." -- George Washington ___ 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: Reconciliation Report
The accounting software that I use to manage my business includes the following "Bank Reconciliation Report": 1) The bank balance as of the reconciliation date; 2) A list of currently unreconciled deposits & charges; 3) A subtotal of the above (2); 4) Followed by an "Adjusted Statement Balance" calculated by adding the above subtotal to the bank balance. This balance should be your register balance as of the reconciliation date or there is an error. This is essentially the procedure that is followed when reconciling your bank or credit card statement to your GNUCash register, just in the form of a printed report instead of an adding machine tape. I'm no expert at GNUCash but I haven't yet found any way to replicate this report in GNUCash but I think it would be a useful addition. HTH. CMR On 11/30/2017 03:06 PM, Mike or Penny Novack wrote: On 11/29/2017 11:07 PM, Adrien Monteleone wrote: Rick, Try the Transaction or Transaction by Payee report (the latter posted here on the list). You can show the Reconciled Date using the display tab in options, and/or sort by the reconciled date in the sorting tab. Unfortunately, I don’t think you can filter by reconciled/non-reconciled as the report currently stands. Perhaps a more serious issue? Depending on what is meant by "reconciliation report". Rick, can you describe what your report is supposed to show? Let me explain. In the "old days" each month, when we got our bank statement, we "reconciled" the checking account. The bank statement showed the balance as of the close of the period and also all the deposits that the bank has during the period and all checks cleared during the period. Your books would have a bank account showing all deposits you made during the period and all checks written during the period and what you think the ending balance should be. Those two would normally NOT agree because: 1) A deposit made on the last day of the period might not be credited. 2) Some number of checks written during the period (or even from previous periods) not cleared yet. "1" rare but "2" the normal situation. So you took your balance and added to it all the checks that had not cleared (those NOT reconciled in the gnucash sense of "reconciled") and took the bank balance and added to it any deposit you made not shown on the bank statement and checked that those those two sums were equal. THAT what you mean? << I don't do any on-line banking (not over a dial-up connection OR a public access (unsecured) wifi) and the organizations for which I keep books have a low enough volume of checks written each month that doing the old fashioned reconciliation no big chore to do that "report" by hand since not likely to be more than 2-3 uncleared checks >> If THAT is the report you require, unless you have a large number of checks still outstanding each period, automating the process perhaps a waste of time. So try to better describe what you have been asked to produce. Michael D Novack ___ 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. -- “Jurors should acquit, even against the judge’s instruction… if exercising their judgment with discretion and honesty, they have a clear conviction the charge of the court is wrong.” -- Alexander Hamilton ___ 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: Adding Fixed Assests
While your debit entry is to the fixed asset account your opposite, credit, entry should be to your cash account (reducing cash) or equity account(representing ownership). On 11/07/2017 03:45 PM, Kevin Barber wrote: Hello Can anyone tell me how to record fixed assets in GnuCash. When I put the entry in GnuCash automatically balances the entry with a deduction of the same amount so the fixed assets always shows as “zero”. What am I doing wrong? Kevin Sent from Mail for Windows 10 ___ 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. -- “Three millions of people, armed in the holy cause of liberty, and in such a country as that which we possess, are invincible by any force which our enemy can send against us. Beside, sir, we shall not fight our battles alone. There is a just God who presides over the destinies of Nations, and who will raise up friends to fight our battles for us. The battle, sir, is not to the strong alone; it is to the vigilant, the active, the brave.” -- Patrick Henry ___ 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: Version Migration
I do something similar, working between my office PC & my home PC but I use SpiderOakONE to backup & synchronize the two PC's. However, my GnuCash file is an SQLite database and I found that SOO did not play well with the GnuCash file, since GnuCash writes each transaction, one at a time to the file. SOO then was seeing each new transaction as a "new" file & trying to back it up resulting in a terrific number of historical files in the SOO archive. One way around this problem is to program the SOO program only to backup files at certain times of the day, when you are not using GnuCash. What I did was to write a simple script that copies the .gnucash directory into a working directory which is not monitored by SOO & then when I closed the program copy the resulting .gnucash directory back to where SOO would see it. Hope this helps! CMR On 08/31/2017 03:28 PM, Rui Dias Costa wrote: Hi, We use gnucash in two distinct computers running on windows. Both have the work files are in complete sync, including a copy of the gnucash database files. Since the computers function at different moments in time, never at the same time, they both run gnucash all right. No issues. For instance, we can turn it off in one machine, go to the other and continue were we left things. To sync them we use Resilio Sync. We had some troubles while back using dropbox to do this job. Always worked fine. Regards, Rui On 31 Aug 2017, at 20:46, Robert Hellerwrote: At Thu, 31 Aug 2017 14:29:10 -0400 james wrote: On 08/31/17 13:35, Matthew Pounsett wrote: On 31 August 2017 at 13:33, Geert Janssens wrote: While these solutions will work most of the time they all have the same risk: if the snapshot is made while gnucash is updating the db, you end up with an inconsistent db file. I don't know how well sqlite3 handles this so the risk may be high or low. I've done a few spot-checks for consistency and never run into a problem. I don't know this for certain, but it looks as if GnuCash is wrapping each update in a transaction. If it is doing that, it would ensure that the data written to disk is never inconsistent. ___ 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. Since my company is small, I'm sticking with the legacy gnu system, for now. That's the permanently offline system I'm in the process of migrating too. Is anyone basically using a USB stick for all records? If so, can you just plug that USB stick into any of several different (but same version of gnucash), make changes and store all records on a usb 2 or 3 device? Then copy usb-stick for backups? Should be possible. A USB stick is just another file system. There is no *set-in-stone* reason gnucash's data *has* to be the local system disk. A given version of Gnucash should behave the same on any number of different systems. Generally, the *preferences* (including saved reports) would be local to each system (since they live in $HOME). You might need to use the File->Open menu item to open the data file. Like others, I am curious to track the database progress, as well as running gnucash on a cluster. Anyone running many instances of GNUcash on containers, alpine or just a bunch of VMs? I'd be most interested in those experiences too. Projects of such multiplicative offerings of gnucash I could follow? I have a desktop Linux machine (CentOS 6, x86_64) and a laptop Linux machine (also 6, x86_64). Generally I run GnuCash (2.4.15-4.el6) on my desktop Linux machine. I do have a procedure (shell script) to rsync the GnuCash data & prefs onto my laptop on occasion, I run GnuCash (also 2.4.15-4.el6) there and then rsync the GnuCash data & prefs back to my desktop Linux machine. I don't know if this counts towards what you are asking. James ___ 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. -- Robert Heller -- 978-544-6933 Deepwoods Software-- Custom Software Services http://www.deepsoft.com/ -- Linux Administration Services hel...@deepsoft.com -- Webhosting Services ___ 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