Re: gnucash and mysql: Incorrect datetime value for column 'post_date'
Hi Maf, just to inform you. Your assumption was totally correct. After fixing the date in the xml file I succeeded in importing the data into my mysql database. Many thanks to you and all others who friendly shared their thoughts concerning my issue. I'm still wondering a little how I could encounter a Windows bug in my pure Linux installation. Joerg On Mon, 16 Oct 2017 22:43:28 +0200 Joerg Diederich wrote: > Hi Maf, > > thank you very much for this hint. I guess it points into the right > direction. I've just checked my xml file and indeed, there is an entry with > such a strange date. I will try to fix it as suggested and look, if I can > save the data into my mysql database. > > Joerg > > > On Mon, 16 Oct 2017 20:46:14 +0100 > "Maf. King" wrote: > > > On Monday, 16 October 2017 17:27:13 BST Fred Bone wrote: > > > > > > > > A date in 1898 (as reported) looks more like a data error. > > > > I know the OP mentioned Linux - but isn't that date something to with a > > (fixed/ > > resolved) windows bug creating transactions from "before time existed" > > Just > > rings a distant bell with me... > > > > Maybe a grep of the xml file for something like the problem timestamp and > > fixing > > the data manually? A postdate won't be visible in the registers anywhere > > AFAIK. > > > > Back up the data file first then back it up again... > > > > 0.02 > > Maf. > > > > > > > > ___ > > 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 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 CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[MAINT] Update: issue found (was Re: More network maintenance for Saturday)
Hi All, One more update, with some good news and bad news. tl;dr: I (temporarily) solved the network issues causing major packet delays and some packet loss, however this required turning off my IPv6 tunnel. The good news is that I finally found the trigger for the network issues, so I now have a clean network. I discovered this last night while trying to debug it further, and tested overnight with positive results. The bad news is that the issue is (was?) my IPv6 tunnel, which means to fix the issue I had to turn off v6. This has the side-effect that if you're using v6 you will see a delay when trying to access the GnuCash infrastructure, at least until I can determine how to resolve this issue. At least this gives me somewhere to focus and search; I can limit the testing, and focus my testing efforts there. It does appear that only upstream IPv6 traffic is causing the problem, so incoming data isn't causing it. This means I can keep myself in good shape just by keeping the routing table empty. It also *looks* like I can trigger the issue just by running mtr -6 www.google.com (although it's possible that there is other v6 traffic going on). I plan to continue testing, but in the short term I expect to keep my v6 network turned off. I will require some network downtime to perform further tests, so I'll ask on IRC before I pull the plug to run my tests. My apologies if this affects you in an negative way. -derek -- Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory Member, MIT Student Information Processing Board (SIPB) URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH warl...@mit.eduPGP key available ___ 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: Vendor Bill - Invoice Entries
Probably the most common, and least expensive one, that I run into most often is Quick Books. I've never used it but I have used Quicken -- and left it for GnuCash! Here at my office we use an ERP product called Southware Innovations. We've been using it for quite a long time now so I'm not up on their current pricing but at a guess I think the cost of a single user license for the basic accounting modules as well as order entry/sales & inventory management will likely run between $2,500 & $5,000. Here is a website that I just discovered that appears to list any & all kinds of software available. Narrowing it down to inexpensive accounting packages you get: https://www.softwareadvice.com/accounting/?deployment_id=&market_products_sort_order=&market_products_sortby=great_fit&more=true&price_ranges=1&stars=&segment_id=&platforms=&int_site_code=&subsize1_id= If that URL is corrupted just start at www.sofwareadvice.com. Cheers! On 10/16/2017 05:44 PM, fellowtrave...@comcast.net wrote: > Thanks CM, I’ll take a look. Given that this is a very small non-profit, I am hoping to avoid a commercial package and so far GC has (mostly) met the needs but now we’re looking at trying to have more data available that is not strictly just dollars and cents so to speak. In any case, are you (or anyone else here) aware of some common commercial packages? > > > > >> On Oct 16, 2017, at 6:31 PM, C M Reinehr wrote: >> >> I second the comments by Michael. While I use GnuCash to keep up with my personal accounting, for my business I use commercial accounting software which provides all of the modules described and quite a few more. You can license as few or as many modules as desired -- at a cost, of course. So, if you're doing only basic accounting you can license only the general ledger module, which would be analogous to GnuCash. But if your needs are greater than there are the accounts receivable module, the accounts payable, module, payroll, inventory control, sales order entry, point of sale, etc. >> >> The only other open source software of which I am aware that would provide you these types of modules is a product called SQL-Ledger which you may wish to investigate: >> >> http://www.sql-ledger.org/cgi-bin/nav.pl?page=feature/index.html&title=Features >> >> At the very least looking at what SQL Ledger has to offer will show you the kinds of packages available. >> >> Otherwise, you're looking at purchasing commercial enterprise resource software. >> >> Hope this helps! >> >> CMR >> >> On 10/16/2017 05:04 PM, fellowtrave...@comcast.net wrote: >>> Michael: >>> Thanks for the reply. I have to say, I was thinking this would be a natural function of business accounting software but I see your point about the bulk. This is a function I am currently looking into for a non-profit. Basically, we receive invoices for services which I’ve been inputing as bills into the AP register. The invoices of course could contain any number of services, many of which are common. What we’d like to be able to do is to create reports that might say, these are the top 5 services that were preformed in 2016 and how many of each there were. I’d prefer to only have to enter this data once, so I was hoping that GC would have the functionality but I am finding out that this might be outside the scope of any accounting type of software. >>> Would you be able to suggest an approach, a tool, that might compliment GC? Or is this just going to have to be something totally different? >>> Thanks. On Oct 16, 2017, at 9:17 AM, Mike or Penny Novack wrote: On 10/15/2017 10:08 PM, DaveC49 wrote: > Hi, > > The facilities you are requesting are likely to require an inventory > management system. At present Gnucash is an accounting package and currently > does not incorporate any features for inventory management. As far as i know > there are no plans to incorporate such features in the near future. To do so > would reuire a developer(s) interested in developing these features. > Similarly while it can handle the accounting specific side of payroll > management it does not handle the calculation of payrolls, deductions, taxes > etc. You may need to took at ERP software if you require these facilities. > > David Cousens I am going to point something out. Gnucash is an accounting package. A business might need a number of OTHER packages that would interact with the accounting package, but normally are separate parts. Why separate? Because which of these other parts a business might want/need depend on the business. A unified business application (including ALL the different possible pieces) would be unnecessarily bulky, with a given business never using many of those pieces. inventory -- only if the business HAS inventory that it sells payroll -- only if the business has employees (employees in the legal sense o
Re: command line QIF import
To: Liz, the moderator, and the list: Actually Gnucash seems to strike a strong resemblance to Quicken. The data entry in the journal mode with no payee in the check or source account entry (from cash, checking, or credit cards), and where the amounts of the entry change in during the data entry process, and where errors, often based on changing amounts (2 debits, etc.,) are hidden from the user. It makes sense that users of the Intuit family of products want to leave, due to some of their business practices; and some desire to use an operating system that is not founded on enhancing the profits of the publishers at the user's expense. I watch Gnucash for fixes to these problems, but all I see are justifications of why they exist. A 'preference' switch to allow users who are familiar and comfortable with the 'Intuit Way' to continue, vs. those with accounting knowledge who want a transaction to look like a transaction, could have it that way, is a possibility. The end result would be a transaction posted to the appropriate accounts. I use a DOS program run under Dosemu in Ubuntu, written by 2 programmers who sold their program to Intuit. Intuit buried their program, "In House Accountant", and use some of its code in Quickbooks. I declined their offer to 'switch'. John Sowden American Sentry Systems, Inc. On 10/16/2017 07:06 PM, Liz wrote: On Mon, 16 Oct 2017 06:52:17 -0700 (MST) Nelson wrote: You're getting very defensive here David and your posts are not contributing to this discussion at all. Gnucash is Gnucash. It isn't a Quicken-to-Gnucash project. Yes, we do get many queries about this, but the process once completed is soon forgotten, and while there is much knowledge about this in the mailing lists, Quicken-to-Gnucash is not the main focus of this project. Nelson, you are free to try and do what you like, except start personal attacks on other contributors. Liz, the moderator. (Profanity is also something I heavily discourage) ___ 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 CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: command line QIF import
John R. Sowden, Could you please elaborate on your assertions that 1. "errors, often based on changing amounts (2 debits, etc.,) are hidden from the user." 2. "A 'preference' switch to allow users who are familiar and comfortable with the 'Intuit Way' to continue, vs. those with accounting knowledge who want a transaction to look like a transaction, could have it that way, is a possibility." 3. is "In House Accountant" available on the internet? David C On Tue, Oct 17, 2017 at 10:36 AM, John R. Sowden wrote: > To: Liz, the moderator, and the list: > > Actually Gnucash seems to strike a strong resemblance to Quicken. The > data entry in the journal mode with no payee in the check or source account > entry (from cash, checking, or credit cards), and where the amounts of the > entry change in during the data entry process, and where errors, often > based on changing amounts (2 debits, etc.,) are hidden from the user. > > It makes sense that users of the Intuit family of products want to leave, > due to some of their business practices; and some desire to use an > operating system that is not founded on enhancing the profits of the > publishers at the user's expense. > > I watch Gnucash for fixes to these problems, but all I see are > justifications of why they exist. A 'preference' switch to allow users who > are familiar and comfortable with the 'Intuit Way' to continue, vs. those > with accounting knowledge who want a transaction to look like a > transaction, could have it that way, is a possibility. The end result > would be a transaction posted to the appropriate accounts. > > I use a DOS program run under Dosemu in Ubuntu, written by 2 programmers > who sold their program to Intuit. Intuit buried their program, "In House > Accountant", and use some of its code in Quickbooks. I declined their > offer to 'switch'. > > John Sowden > American Sentry Systems, Inc. > > > > On 10/16/2017 07:06 PM, Liz wrote: > >> On Mon, 16 Oct 2017 06:52:17 -0700 (MST) >> Nelson wrote: >> >> You're getting very defensive here David and your posts are not >>> contributing to this discussion at all. >>> >>> >>> Gnucash is Gnucash. >> It isn't a Quicken-to-Gnucash project. >> >> Yes, we do get many queries about this, but the process once completed >> is soon forgotten, and while there is much knowledge about this in the >> mailing lists, Quicken-to-Gnucash is not the main focus of this project. >> >> >> Nelson, you are free to try and do what you like, except start personal >> attacks on other contributors. >> >> Liz, the moderator. >> (Profanity is also something I heavily discourage) >> ___ >> 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 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 CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: gnucash and mysql: Incorrect datetime value for column 'post_date'
On Tuesday, 17 October 2017 14:24:58 BST Joerg Diederich wrote: > Hi Maf, > > just to inform you. Your assumption was totally correct. After fixing the > date in the xml file I succeeded in importing the data into my mysql > database. Many thanks to you and all others who friendly shared their > thoughts concerning my issue. I'm still wondering a little how I could > encounter a Windows bug in my pure Linux installation. > I could be wrong about it being a windows-only bug! But glad that it got you going on the correct path to a fix. Maf. ___ 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 2.7.0 released
GnuCash 2.7.0 released The Gnucash Development Team is pleased to release Gnucash 2.7.0, the first release of an unstable series leading to Gnucash 2.8.0. This release is UNSTABLE and SHOULD NOT BE USED in production. See the KNOWN PROBLEMS list at the bottom of the announcement. Note: Version information in the splash screen and About dialog will now reflect the date of the last commit used to build GnuCash rather than the date it was compiled. This is to assist quality assurance and debugging efforts by Linux distribution maintainers. 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 with the newer API 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. (Geert Janssens, Robert Fewell, and John Ralls) • There's a new CSV importer largely rewritten in C++, adding new features including the ability to re-import CSV files exported from GnuCash. (Geert Janssens) • Data file directories are now located appropriately to the operating system's conventions by default. It's still possible to overried with the environment variable GNC_DOC_PATH, which replaces GNC_DOT_DIR in earlier versions of GnuCash. (Geert Janssens) • 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. This will make your file unreadable by previous versions of gnucash. There's a new editor 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. (All from Robert Fewell!) • Numerics are rewritten to allow for more significant digits. The old 6-digit-maximum fraction will be a 9-digit maximum by 2.8. there is still some cleanup required before the limit can actually change. (John Ralls) • New Income GST Report and some improvements to the Transaction report. (Christopher Lam) • Chart Reports appearance is improved (Carsten Rinke) For Developers • The code is reorganized into a core library directory, libgnucash, and applications-specific directory, gnucash. Code lifted from other projects is in borrowed. (Geert Janssens) • 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. Object properties stored using KVP are generally accessible using g_object_get and g_object_set; there is also a more direct access available via qof_instance_get and qof_instance_set. (John Ralls and Aaron Laws) • KVP and GUID are reimplemnted in C++ using boost::variant and boost::UUID respectively (Aaron Laws). • 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. (John Ralls) • Distribution tarballs can now be built with CMake as well as Autotools. (Rob Gowin) • The CuteCash front end has been removed. The code we need from GOffice has been brought into the GnuCash code base so GOffice is no longer a dependency. • A new Russian translation of the Guide has been started by Dmitriy Mandel. Downloads in the usual formats are available at https://code.gnucash.org/docs/ru/; the HTML is at https://code.gnucash.org/docs/ru/gnucash-guide/. • There will be no unstable documentation release at this time. There have been very few relatively minor changes to the master documentation branch; those documents may be viewed in the nightly builds at https://www.gnucash.org/docs.phtml. KNOWN PROBLEMS: • On Microsoft Windows starting the AQBanking Setup Wizard crashes GnuCash. • test-import-bayes built with autotools intermittently fails at line 381, where the returned value is 1 instead of the expected 6. Getting GnuCash for Windows and MacOS X GnuCash is provided for both Microsoft Windows XP® and later and MacOS X 10.9 (Mavericks)® and later in pre-built, all-in-one packages. An installer is provided for Microsoft Windows® while the MacOS X® package is a disk image containing a drag-and-drop application bundle. The SHA256 Hashes for the downloadable files are: • 429f9aef704fe9378aa400d3e29c22e383e184d54ed4bc364406e38356ac01ef gnucash-2.6.18.tar.bz2 • afa303bfbc183a700f77013b214f0b25843ee5a8da83994daae1926af990e525 gnucash-2.6.18.tar.gz • 2c83e8f79042e997f624efdb1abd154f50aafa5c
Re: GnuCash 2.7.0 released
Thanks for the report, but in future please use gnucash-user or file a bug report. I’ve gotten reports of similar problems with Apple’s new linkage system not quite working as advertised and was curious whether it would affect GnuCash. I guess I have the answer. Regards, John Ralls > On Oct 17, 2017, at 7:15 PM, Malcolm Fitzgerald > wrote: > > How exciting. I grabbed the dmg from source forge and copied the application > to my desktop. It displayed the splash screen but crashed immediately after > that. I've pasted the crashlog below. > > thanks for your work, > > Malcolm > > > > > Process: Gnucash-bin [8034] > Path: > /Users/USER/Desktop/*/Gnucash.app/Contents/MacOS/Gnucash-bin > Identifier:org.gnucash.Gnucash > Version: 2.7.0 (2.7.0) > Code Type: X86-64 (Native) > Parent Process:??? [1] > Responsible: Gnucash-bin [8034] > User ID: 501 > > Date/Time: 2017-10-18 15:11:49.034 +1300 > OS Version:Mac OS X 10.11.6 (15G1611) > Report Version:11 > Anonymous UUID:44E5DDB9-58FC-738B-9E48-286EEE538303 > > Sleep/Wake UUID: 8324B829-3B55-4BBB-82E5-2C22543167C1 > > Time Awake Since Boot: 20 seconds > Time Since Wake: 19 seconds > > System Integrity Protection: enabled > > Crashed Thread:0 Dispatch queue: com.apple.main-thread > > Exception Type:EXC_BREAKPOINT (SIGTRAP) > Exception Codes: 0x0002, 0x > Exception Note:EXC_CORPSE_NOTIFY > > Dyld Error Message: > Symbol not found: _clock_gettime > Referenced from: > /Users/USER/Desktop/*/Gnucash.app/Contents/Resources/lib/libguile-2.0.22.dylib > Expected in: /usr/lib/libSystem.B.dylib > > Thread 0 Crashed:: Dispatch queue: com.apple.main-thread > 0 dyld 0x7fff642df075 dyld_fatal_error + 1 > 1 dyld 0x7fff642e2094 > dyld::fastBindLazySymbol(ImageLoader**, unsigned long) + 139 > 2 libdyld.dylib 0x7fff98ccc262 dyld_stub_binder + > 282 > 3 ??? 0x00010d1ad0f0 0 + 4514828528 > 4 libguile-2.0.22.dylib 0x00010d0ebb25 scm_i_init_guile + > 277 > 5 libguile-2.0.22.dylib 0x00010d14da7a > scm_i_init_thread_for_guile + 122 > 6 libguile-2.0.22.dylib 0x00010d1509c9 > with_guile_and_parent + 25 > 7 libgc.1.dylib 0x00010d2a21ab > GC_call_with_stack_base + 27 > 8 libguile-2.0.22.dylib 0x00010d14dacb scm_with_guile + 43 > 9 libguile-2.0.22.dylib 0x00010d0eb9a5 scm_boot_guile + 69 > 10 Gnucash-bin 0x00010cfa91e7 main + 3751 > 11 libdyld.dylib 0x7fff98cce5ad start + 1 > > Thread 1: > 0 libsystem_kernel.dylib0x7fff921f35e2 __workq_kernreturn + > 10 > 1 libsystem_pthread.dylib 0x7fff86ea2578 _pthread_wqthread + > 1283 > 2 libsystem_pthread.dylib 0x7fff86ea0341 start_wqthread + 13 > > Thread 2:: Dispatch queue: com.apple.libdispatch-manager > 0 libsystem_kernel.dylib0x7fff921f3efa kevent_qos + 10 > 1 libdispatch.dylib 0x7fff8b56f165 _dispatch_mgr_invoke > + 216 > 2 libdispatch.dylib 0x7fff8b56edcd _dispatch_mgr_thread > + 52 > > Thread 3: > 0 libsystem_kernel.dylib0x7fff921f35e2 __workq_kernreturn + > 10 > 1 libsystem_pthread.dylib 0x7fff86ea2578 _pthread_wqthread + > 1283 > 2 libsystem_pthread.dylib 0x7fff86ea0341 start_wqthread + 13 > > Thread 4: > 0 libsystem_kernel.dylib0x7fff921f35e2 __workq_kernreturn + > 10 > 1 libsystem_pthread.dylib 0x7fff86ea2578 _pthread_wqthread + > 1283 > 2 libsystem_pthread.dylib 0x7fff86ea0341 start_wqthread + 13 > > Thread 5: > 0 libsystem_kernel.dylib0x7fff921f35e2 __workq_kernreturn + > 10 > 1 libsystem_pthread.dylib 0x7fff86ea2578 _pthread_wqthread + > 1283 > 2 libsystem_pthread.dylib 0x7fff86ea0341 start_wqthread + 13 > > Thread 6: > 0 libsystem_kernel.dylib0x7fff921f35e2 __workq_kernreturn + > 10 > 1 libsystem_pthread.dylib 0x7fff86ea2578 _pthread_wqthread + > 1283 > 2 libsystem_pthread.dylib 0x7fff86ea0341 start_wqthread + 13 > > Thread 7: > 0 libsystem_kernel.dylib0x7fff921f35e2 __workq_kernreturn + > 10 > 1 libsystem_pthread.dylib 0x7fff86ea2578 _pthread_wqthread + > 1283 > 2 libsystem_pthread.dylib 0x7fff86ea0341 start_wqthread + 13 > > Thread 8: > 0 libsystem_kernel.dylib0x7fff921f35e2 __workq_kernreturn + > 10 > 1 libsystem_pthread.dylib 0x7fff86ea2578 _pthread_wqthread + > 1283 > 2 libsystem_pthr
Re: command line QIF import
> On Oct 17, 2017, at 8:36 AM, John R. Sowden > wrote: > > It makes sense that users of the Intuit family of products want to leave, due > to some of their business practices; and some desire to use an operating > system that is not founded on enhancing the profits of the publishers at the > user's expense. > > I watch Gnucash for fixes to these problems, but all I see are justifications > of why they exist. A 'preference' switch to allow users who are familiar and > comfortable with the 'Intuit Way' to continue, vs. those with accounting > knowledge who want a transaction to look like a transaction, could have it > that way, is a possibility. The end result would be a transaction posted to > the appropriate accounts. You’ll have a long wait, it’s not something that the GnuCash development team is interested in. The underlying conceptual designs of the two programs are too different. Quicken users who want a similar FOSS program should consider KMyMoney rather than GnuCash. Quickbooks users and Quicken users who are ready to graduate to real accounting are in GnuCash’s target audience. Regards, John Ralls ___ 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.
