Re: [GNC] save as sqlite3 error

2021-10-23 Thread Public Address
Thanks, interesting that deleting the “NULL” text and leaving it empty allowed it to go through. “but direct database manipulation may void your GnuCash warranty.” I was thinking about direct upload to the postgres table (creating my own guid and checking for duplication) but that doesn’t

Re: [GNC] Error importing QIF file

2021-10-23 Thread parag puranik via gnucash-user
David thanks for the hint to compare the file with standard QIF format. The app has no provision for entering any share transaction. It is only a robust double-entry book-keeping app -(plain and simple) - running on Sqlite3 at the backend, ensuring excellent data integrity. Hence I do not quit

Re: [GNC] Error importing QIF file

2021-10-23 Thread davidcousens49
The best chance of locating the source of an import error in a file exported from Android is to compare its file format with what is known of the QIF format and look for some deviations from this. Unfortunately QIF is a proprietary format although Intuit did make some information publicly

Re: [GNC] Error importing QIF file

2021-10-23 Thread parag puranik via gnucash-user
Kalpesh, Gnucash (android version) is a companion app to its desktop version with limited functionality as to data entry on-the-go. Its an excellent and stable app. Its first time I faced this kind of error. GNUCASH Developers team should be in a position to explain it since the error message

Re: [GNC] Error importing QIF file

2021-10-23 Thread David Carlson
Parag, Back in the day when I last tried the Android app, I found that it too often choked on an import or export or created an un-importable file or transaction error in the file. As others have suggested here, we are not magicians. You need to dig through the file yourself to find the problem

Re: [GNC] Error importing QIF file

2021-10-23 Thread parag puranik via gnucash-user
David, in that case how do I identify which transactions are at fault ? Secondly, how to fix them ?  Thirdly, how to create new repaired QIF file from it ? Instead, it would be better if someone from Gnucash team/users explain why the Error message arises in the first place. Sent from Yahoo

Re: [GNC] Error importing QIF file

2021-10-23 Thread Kalpesh Patel
Parag - You will have to find the offending faulty transaction and correct it manually after understanding why it is failing. Learning the format of QIF file is not that difficult (plenty of sources to be had by Google'ing for it, including a Wikipedia) and the file can be viewed in any good old

Re: [GNC] Error importing QIF file

2021-10-23 Thread David Carlson
I thought someone suggested that there might be only one or a few transactions at fault that might be fixable in a text editor. On Sat, Oct 23, 2021, 9:56 PM parag puranik via gnucash-user < gnucash-user@gnucash.org> wrote: > I want to know why the error message arises and further how to import

Re: [GNC] Error importing QIF file

2021-10-23 Thread parag puranik via gnucash-user
I want to know why the error message arises and further how to import such a file in desktop.The data in the file can very well be read in Excel file. But I want to get that data into Desktop Gnucash directly (not by manually entering each transaction again in Desktop version). Sent from Yahoo

Re: [GNC] Error importing QIF file

2021-10-23 Thread parag puranik via gnucash-user
Hi GregThe issue in certainly not about compatibility between android and desktop versions, but about a particular  error in one particular file. I have successfully imported other QIF files.My question is regarding the significance of that particular error message and how to get around or work

Re: [GNC] Error importing QIF file

2021-10-23 Thread Liz Dodd
On Sat, 23 Oct 2021 14:36:51 + (UTC) parag puranik via gnucash-user wrote: > I exported a data file from Gnucash Android App version 2.4.0 in QIF > format. While importing this QIF file into Gnucash desktop version > 2.6.19 or even in version 3.10, I get error saying "Share price: >

Re: [GNC] Processing a customer payment

2021-10-23 Thread R. Victor Klassen
Assuming you have created the invoices using the “Business Features”, you go to Business->Customer->Process Payment, select the customer, and select both invoices. If they paid by a means that has a transaction number (check, credit card transaction…) put that in the number field. Select your

Re: [GNC] elementary questions

2021-10-23 Thread David H
Hi T. R. Jackson, answering what I can for you inline :-) On Sun, 24 Oct 2021 at 04:25, m.x. keating wrote: > GnuCash User List ahoy: > > LibreOffice’s user list has a procedure for handling .pdfs, screenshots, > , by storing them in special places, outside the list, but I haven’t > had

Re: [GNC] link bank statement to all reconciled transactions?

2021-10-23 Thread David Carlson
I happen to enter a transaction to some of my bank or credit card accounts each month to report the balance shown on the statement. I could assign a URL or filename to this transaction if desired. On Sat, Oct 23, 2021 at 5:54 PM wrote: > Mattia > > A reconciliation deals with all the splits to

Re: [GNC] link bank statement to all reconciled transactions?

2021-10-23 Thread davidcousens49
Mattia A reconciliation deals with all the splits to a specifc account for a specified date range from any transactions to any other account. There is not a single entity transaction or split to associate a document with. At present AFAIK there is no way of associating the external statement

Re: [GNC] elementary questions

2021-10-23 Thread Glenn Fowler
Hi, You are obviously concerned about security/privacy with your procedure of disconnecting from your network. However, you mentioned you still have Windows 7 which no longer receives security updates and patches. It has been EOL for almost 2 years! Patching and updating is one of the first

Re: [GNC] elementary questions

2021-10-23 Thread Chris Green
On Sat, Oct 23, 2021 at 02:23:20PM -0400, m.x. keating wrote: > > As suggested, I do use LibreOffice when composing a message, because of the > poor quality of the in-built text editor in Thunderbird. LO does not help > with formatting, however, since all formatting but the most basic is lost >

[GNC] elementary questions

2021-10-23 Thread m.x. keating
GnuCash User List ahoy: A thank you to Derek Atkins & to David Carlson for confirming my suspicion that attaching a .pdf caused the assassination of my previous message. I thought it possible that the .pdf would not survive, but didn’t expect the entire message to be rejected as if it had a

[GNC] link bank statement to all reconciled transactions?

2021-10-23 Thread Mattia Rizzolo
Hi all, somehow my googling doesn't even suggest anybody ever asked this… Is there a way so that all reconciled transactions link to a document (say, the actual bank statement) while also linking to their own attached documents? It feels like this would be solved if a document was property of a

[GNC] Processing a customer payment

2021-10-23 Thread davidvernonlong
Hi, if a customer makes one payment to cover say two invoices, how do I process that in accounts receivable without having two cash receipts showing up on my checking account in GNUCASH whereas there should only be one? I can imagine various clumsy manual ways of doing it, but am thinking there

Re: [GNC] Error importing QIF file

2021-10-23 Thread Greg Feneis
As I understand, GnuCash for Android is no longer supported by its creator and is not supported by GnuCash desktop developers. It's a separate project that happens to have GnuCash in its title. My best recommendations include taking over and continuing development of GnuCash for Android. Or,

[GNC] Error importing QIF file

2021-10-23 Thread parag puranik via gnucash-user
I exported a data file from Gnucash Android App version 2.4.0 in QIF format. While importing this QIF file into Gnucash desktop version 2.6.19 or even in version 3.10, I get error saying "Share price: Unrecognized or inconsistent format.", The import process has to be aborted. The QIF data file

Re: [GNC] SpamAssassin??

2021-10-23 Thread Chris Green
On Fri, Oct 22, 2021 at 08:18:53PM -0500, David Carlson wrote: > Can I make a suggestion? > > Sometimes, when I want to post a rather complex statement to a text based > medium I will compose the statement in a higher level editor, possibly > Libre Office, then copy and paste into the