gnucash-user Digest, Vol 159, Issue 17

[Jack Cahn]

Thank you.  Maybe next spring.    Jack

On 06/10/2016 07:40 PM, gnucash-user-request at gnucash.org wrote:
> Send gnucash-user mailing list submissions to
> 	gnucash-user at gnucash.org
>
> To subscribe or unsubscribe via the World Wide Web, visit
> 	https://lists.gnucash.org/mailman/listinfo/gnucash-user
> or, via email, send a message with subject or body 'help' to
> 	gnucash-user-request at gnucash.org
>
> You can reach the person managing the list at
> 	gnucash-user-owner at gnucash.org
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of gnucash-user digest..."
>
>
> Today's Topics:
>
>     1. Re: API questions (John Ralls)
>     2. Re: My Messages Go to Spam (Fred Bone)
>     3. Re: API questions (John Ralls)
>     4. Re: My Messages Go to Spam (John Ralls)
>     5. Re: API questions (David Goodenough)
>     6. Re: My Messages Go to Spam (Fred Bone)
>     7. Re: API questions (Art)
>     8. fixed assets (Elmar Schmeisser)
>     9. Re: Advance portfolio (Mike Alexander)
>    10. Re: fixed assets (John Ralls)
>    11. Re: External Program (Mark Mercer)
>    12. Re: fixed assets (Elmar Schmeisser)
>    13. Re: fixed assets (John Ralls)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Fri, 10 Jun 2016 09:24:58 -0700
> From: John Ralls <jralls at ceridwen.us>
> To: David Goodenough <david.goodenough at linkchoose.co.uk>
> Cc: gnucash-user at gnucash.org
> Subject: Re: API questions
> Message-ID: <436A6E56-5F73-4E4B-AA1A-AF3396B586BF at ceridwen.us>
> Content-Type: text/plain; charset=us-ascii
>
>
>> On Jun 10, 2016, at 8:43 AM, David Goodenough <david.goodenough at linkchoose.co.uk> wrote:
>>
>> On Friday 10 June 2016 08:29:01 John Ralls wrote:
>>>> On Jun 10, 2016, at 7:06 AM, David Goodenough
>>>> <david.goodenough at linkchoose.co.uk> wrote:>
>>>> On Friday 10 June 2016 06:59:38 John Ralls wrote:
>>>>>> On Jun 10, 2016, at 2:05 AM, David Goodenough
>>>>>> <david.goodenough at linkchoose.co.uk> wrote:
>>>>>>
>>>>>> I notice when looking at the API pages that a method is defined as
>>>>>> starting
>>>>>> at a given line, and then the code below always starts on the next line,
>>>>>> i.e. missing out the prototype.  For example:-
>>>>>>
>>>>>> Definition at line 116 of file print-session.c.
>>>>>>
>>>>>> 117 {
>>>>>> 118     return print_settings;
>>>>>> 119 }
>>>>>>
>>>>>> Would it not be possible to show line 116 as well?  This seems to be a
>>>>>> consistent problem throughout the docs.
>>>>> The prototype is in very large print above the description. Repeating it
>>>>> in
>>>>> the listing would be redundant.
>>>> OK, missed that.  It just looked odd at first glance that the line number
>>>> immedately before the code was not in the code that was shown.
>>>>
>>>>>> The reason I was looking was to generate customer reports via the API.
>>>>>> I would like to be able to generate a report for each customer who
>>>>>> either
>>>>>> has a non-zero balance or where some transaction (invoice or receipt of
>>>>>> payment) happened last month (or since rather since I last ran the
>>>>>> program). I then want to export the report as a PDF.  I have looked my
>>>>>> way through the API docs but could not see how to generate reports, or
>>>>>> to
>>>>>> check for the balance or the presence of transactions since a date.
>>>>>>
>>>>>> I found docs on how to create invoices, but also need to be able to
>>>>>> export them as PDFs and could not locate the API for that either.  I
>>>>>> notice
>>>>>> in the gnucash XML files that the last direcorty to which invoices ( and
>>>>>> I
>>>>>> guess customer reports ) were exported is stored, is this available from
>>>>>> the API.
>>>> I think having read a bit further that this is in the customer dictionary?
>>>>
>>>>>> What I want to be able to write is a program that will generate reports
>>>>>> for all relevant customers, and then send an email to each customer who
>>>>>> has either an invoice and/or a report containing both.
>>>>>>
>>>>>> Any pointers gratefully received.
>>>>> PDF generation is provided by (IIRC) libgtk as part of printing support.
>>>>> You won't find the code for that in GnuCash itself.
>>>> OK, but I still need to tell it to generate the customer report, and to
>>>> check whether I need to do so?
>>> Sorry, neither of those questions make sense.
>> I will try to restate them:-
>>
>> 1) From the UI I can request a customer report and tell the UI to export it as
>> a PDF.  How do I achieve the same from the API?
> The reports module is written in Scheme, so anything having to do with reports must use Scheme. That API isn't documented via Doxygen (Doxygen doesn't know how to parse Scheme), so you'll have to study the code in src/reports. You may find http://wiki.gnucash.org/wiki/Custom_Reports helpful.
>
> I already told you that GnuCash's API doesn't know how to export PDFs. It knows how to write HTML. You'll have to find an external library or utility to convert the HTML to PDF.
>
>>   
>>
>> 2) Looking at the customer report I can see if the report shows a non-zero
>> balance or has transactions in the last month.  How can I check the balance
>> and see if there are invoices or receipts for a given customer in the last
>> month though the API?
> You will have to extract the logic of the report to replicate its query and calculations and test the results.
>
>> Obviously I would like to have dataset format independance rather than going
>> direct to the data, so I want to do as much as possible through the API.
>>
>> David
>>> Regards,
>>> John Ralls
>
>
>
> ------------------------------
>
> Message: 2
> Date: Fri, 10 Jun 2016 17:26:11 +0100
> From: "Fred Bone" <Fred.Bone at dial.pipex.com>
> To: gnucash-user at gnucash.org
> Subject: Re: My Messages Go to Spam
> Message-ID: <575AEA23.23125.11942C6F at Fred.Bone.dial.pipex.com>
> Content-Type: text/plain; charset=UTF-8
>
> On 10 June 2016 at 11:55, Oon-Ee Ng said:
>
>> On Thu, Jun 9, 2016 at 11:52 PM, Fred Bone <Fred.Bone at dial.pipex.com>
>> wrote: > On 8 June 2016 at 10:52, David T. said: > >> Indeed. Thanks for
>> the confirmation. I see that when this came up in 2014, >> Derek had
>> indicated that the appropriate Mailman patches would need to be >>
>> installed. >> >> I don?t plan to change my subscription at
>> Gnucash-users, so let this be >> an alert to gmail subscribers: if you
>> want to see all the messages from >> gnucash-users, add a whitelist entry
>> for the list. > > Or switch to MIME-Digest mode.
>>
>> Not a satisfactory solution both for the recipient and for the list,
>> replies to digests tend to be troublesome to parse.
> Why? They are no different from responses to single messages. That is the
> whole point.
>
>
>
>
>
> ------------------------------
>
> Message: 3
> Date: Fri, 10 Jun 2016 09:32:46 -0700
> From: John Ralls <jralls at ceridwen.us>
> To: David Goodenough <david.goodenough at linkchoose.co.uk>
> Cc: gnucash-user at gnucash.org
> Subject: Re: API questions
> Message-ID: <35BBA6E9-6CD4-47E0-9137-8A8DFE7DA8BA at ceridwen.us>
> Content-Type: text/plain; charset=us-ascii
>
>
>> On Jun 10, 2016, at 9:24 AM, John Ralls <jralls at ceridwen.us> wrote:
>>
>>> On Jun 10, 2016, at 8:43 AM, David Goodenough <david.goodenough at linkchoose.co.uk> wrote:
>>>
>>>
>>> 1) From the UI I can request a customer report and tell the UI to export it as
>>> a PDF.  How do I achieve the same from the API?
>> The reports module is written in Scheme, so anything having to do with reports must use Scheme. That API isn't documented via Doxygen (Doxygen doesn't know how to parse Scheme), so you'll have to study the code in src/reports. You may find http://wiki.gnucash.org/wiki/Custom_Reports helpful.
>
> I should have added that the query API that the reports use is in C and are documented at http://code.gnucash.org/docs/MAINT/group__Query.html, so once you've figured out from the Customer Report what queries to run you can use C or Python to extract the data and then use other libraries to perform whatever calculations you like and to format it the way you need it.
>
> Regards,
> John Ralls
>
>
>
>
> ------------------------------
>
> Message: 4
> Date: Fri, 10 Jun 2016 09:34:09 -0700
> From: John Ralls <jralls at ceridwen.us>
> To: Fred.Bone at dial.pipex.com
> Cc: gnucash-user at gnucash.org
> Subject: Re: My Messages Go to Spam
> Message-ID: <6BF3D677-D711-486C-9D6A-0F268F392762 at ceridwen.us>
> Content-Type: text/plain; charset=utf-8
>
>
>> On Jun 10, 2016, at 9:26 AM, Fred Bone <Fred.Bone at dial.pipex.com> wrote:
>>
>> On 10 June 2016 at 11:55, Oon-Ee Ng said:
>>
>>> On Thu, Jun 9, 2016 at 11:52 PM, Fred Bone <Fred.Bone at dial.pipex.com>
>>> wrote: > On 8 June 2016 at 10:52, David T. said: > >> Indeed. Thanks for
>>> the confirmation. I see that when this came up in 2014, >> Derek had
>>> indicated that the appropriate Mailman patches would need to be >>
>>> installed. >> >> I don?t plan to change my subscription at
>>> Gnucash-users, so let this be >> an alert to gmail subscribers: if you
>>> want to see all the messages from >> gnucash-users, add a whitelist entry
>>> for the list. > > Or switch to MIME-Digest mode.
>>>
>>> Not a satisfactory solution both for the recipient and for the list,
>>> replies to digests tend to be troublesome to parse.
>> Why? They are no different from responses to single messages. That is the
>> whole point.
> Not exactly. When replying to a digest one should change the subject and edit the quoted text to match the one message in the digest to which one is replying.
>
> Regards,
> John Ralls
>
>
>
>
> ------------------------------
>
> Message: 5
> Date: Fri, 10 Jun 2016 17:34:26 +0100
> From: David Goodenough <david.goodenough at linkchoose.co.uk>
> To: gnucash-user at gnucash.org
> Subject: Re: API questions
> Message-ID: <3415511.fZeOJaVnJ8 at stargate>
> Content-Type: text/plain; charset="us-ascii"
>
> On Friday 10 June 2016 09:24:58 John Ralls wrote:
>>> On Jun 10, 2016, at 8:43 AM, David Goodenough
>>> <david.goodenough at linkchoose.co.uk> wrote:>
>>> On Friday 10 June 2016 08:29:01 John Ralls wrote:
>>>>> On Jun 10, 2016, at 7:06 AM, David Goodenough
>>>>> <david.goodenough at linkchoose.co.uk> wrote:>
>>>>>
>>>>> On Friday 10 June 2016 06:59:38 John Ralls wrote:
>>>>>>> On Jun 10, 2016, at 2:05 AM, David Goodenough
>>>>>>> <david.goodenough at linkchoose.co.uk> wrote:
>>>>>>>
>>>>>>> I notice when looking at the API pages that a method is defined as
>>>>>>> starting
>>>>>>> at a given line, and then the code below always starts on the next
>>>>>>> line,
>>>>>>> i.e. missing out the prototype.  For example:-
>>>>>>>
>>>>>>> Definition at line 116 of file print-session.c.
>>>>>>>
>>>>>>> 117 {
>>>>>>> 118     return print_settings;
>>>>>>> 119 }
>>>>>>>
>>>>>>> Would it not be possible to show line 116 as well?  This seems to be a
>>>>>>> consistent problem throughout the docs.
>>>>>> The prototype is in very large print above the description. Repeating
>>>>>> it
>>>>>> in
>>>>>> the listing would be redundant.
>>>>> OK, missed that.  It just looked odd at first glance that the line
>>>>> number
>>>>> immedately before the code was not in the code that was shown.
>>>>>
>>>>>>> The reason I was looking was to generate customer reports via the API.
>>>>>>> I would like to be able to generate a report for each customer who
>>>>>>> either
>>>>>>> has a non-zero balance or where some transaction (invoice or receipt
>>>>>>> of
>>>>>>> payment) happened last month (or since rather since I last ran the
>>>>>>> program). I then want to export the report as a PDF.  I have looked my
>>>>>>> way through the API docs but could not see how to generate reports, or
>>>>>>> to
>>>>>>> check for the balance or the presence of transactions since a date.
>>>>>>>
>>>>>>> I found docs on how to create invoices, but also need to be able to
>>>>>>> export them as PDFs and could not locate the API for that either.  I
>>>>>>> notice
>>>>>>> in the gnucash XML files that the last direcorty to which invoices (
>>>>>>> and
>>>>>>> I
>>>>>>> guess customer reports ) were exported is stored, is this available
>>>>>>> from
>>>>>>> the API.
>>>>> I think having read a bit further that this is in the customer
>>>>> dictionary?
>>>>>
>>>>>>> What I want to be able to write is a program that will generate
>>>>>>> reports
>>>>>>> for all relevant customers, and then send an email to each customer
>>>>>>> who
>>>>>>> has either an invoice and/or a report containing both.
>>>>>>>
>>>>>>> Any pointers gratefully received.
>>>>>> PDF generation is provided by (IIRC) libgtk as part of printing
>>>>>> support.
>>>>>> You won't find the code for that in GnuCash itself.
>>>>> OK, but I still need to tell it to generate the customer report, and to
>>>>> check whether I need to do so?
>>>> Sorry, neither of those questions make sense.
>>> I will try to restate them:-
>>>
>>> 1) From the UI I can request a customer report and tell the UI to export
>>> it as a PDF.  How do I achieve the same from the API?
>> The reports module is written in Scheme, so anything having to do with
>> reports must use Scheme. That API isn't documented via Doxygen (Doxygen
>> doesn't know how to parse Scheme), so you'll have to study the code in
>> src/reports. You may find http://wiki.gnucash.org/wiki/Custom_Reports
>> helpful
> Great, I will have a look and see what is there.
>> .
>>
>> I already told you that GnuCash's API doesn't know how to export PDFs. It
>> knows how to write HTML. You'll have to find an external library or utility
>> to convert the HTML to PDF.
> Yes I know how to convert HTML toPDF, so that is no problem.
>>> 2) Looking at the customer report I can see if the report shows a non-zero
>>> balance or has transactions in the last month.  How can I check the
>>> balance
>>> and see if there are invoices or receipts for a given customer in the last
>>> month though the API?
>> You will have to extract the logic of the report to replicate its query and
>> calculations and test the results.
> WIll do,
>
> Thank you
>
> David
>>> Obviously I would like to have dataset format independance rather than
>>> going direct to the data, so I want to do as much as possible through the
>>> API.
>>>
>>> David
>>>
>>>> Regards,
>>>> John Ralls
>
>
> ------------------------------
>
> Message: 6
> Date: Fri, 10 Jun 2016 18:22:56 +0100
> From: "Fred Bone" <Fred.Bone at dial.pipex.com>
> To: John Ralls <jralls at ceridwen.us>
> Cc: gnucash-user at gnucash.org
> Subject: Re: My Messages Go to Spam
> Message-ID: <575AF770.848.11C8207B at Fred.Bone.dial.pipex.com>
> Content-Type: text/plain; charset=UTF-8
>
> On 10 June 2016 at 9:34, John Ralls said:
>
>>> On Jun 10, 2016, at 9:26 AM, Fred Bone <Fred.Bone at dial.pipex.com> wrote:
>>>
>>> On 10 June 2016 at 11:55, Oon-Ee Ng said:
>>>
>>>> On Thu, Jun 9, 2016 at 11:52 PM, Fred Bone <Fred.Bone at dial.pipex.com>
>>>> wrote: > On 8 June 2016 at 10:52, David T. said: > >> Indeed. Thanks
>>>> for the confirmation. I see that when this came up in 2014, >> Derek
>>>> had indicated that the appropriate Mailman patches would need to be >>
>>>> installed. >> >> I don?t plan to change my subscription at
>>>> Gnucash-users, so let this be >> an alert to gmail subscribers: if you
>>>> want to see all the messages from >> gnucash-users, add a whitelist
>>>> entry for the list. > > Or switch to MIME-Digest mode.
>>>>
>>>> Not a satisfactory solution both for the recipient and for the list,
>>>> replies to digests tend to be troublesome to parse.
>>> Why? They are no different from responses to single messages. That is
>>> the whole point.
>> Not exactly. When replying to a digest one should change the subject and
>> edit the quoted text to match the one message in the digest to which one
>> is replying.
> Wrong. The whole point is that one is reading a single message at a time,
> and replying to it is therefore no different from what it would be if
> receiving non-digested messages. With the sole exception that most
> digestifiers fail to include the References: header, which can mess up
> threading ... but then many mail readers can't cope with it anyway.
>
> You may be thinking of plaintext digests.
>
>
>
>
> ------------------------------
>
> Message: 7
> Date: Fri, 10 Jun 2016 19:42:19 +0000 (UTC)
> From: Art <pinaart at yahoo.com>
> To: David Goodenough <david.goodenough at linkchoose.co.uk>
> Cc: "gnucash-user at gnucash.org" <gnucash-user at gnucash.org>
> Subject: Re: API questions
> Message-ID:
> 	<457821586.1111123.1465587739247.JavaMail.yahoo at mail.yahoo.com>
> Content-Type: text/plain; charset=UTF-8
>
> If I were writing a program to do things, I'd be looking at the source code, though it would be nice if the API stood alone. (I haven't used the API, so I am not familiar with what you're trying to do specifically. I usually just tweak GC and rebuild it to make it do what I want or access the SQL database directly, carefully if I am writing to it.)
> On exporting to PDF, I always use a PDF printer driver (in Windows and Linux). I've seen some apps that do export to PDF, but I never do that with my code - it's not worth bloating it (my software apps do create ASCII text files and write to the clipboard). I can also see where you may want to export v. print programmatically (avoid modal printer dialogs, if you need to change the default printer).
>
>        From: David Goodenough <david.goodenough at linkchoose.co.uk>
>   To: gnucash-user at gnucash.org
>   Sent: Friday, June 10, 2016 2:05 AM
>   Subject: API questions
>     
> I notice when looking at the API pages that a method is defined as starting
> at a given line, and then the code below always starts on the next line, i.e.
> missing out the prototype.? For example:-
>
> Definition at line 116 of file print-session.c.
>
> ? 117 {
> ? 118? ? return print_settings;
> ? 119 }
>
> Would it not be possible to show line 116 as well?? This seems to be a
> consistent problem throughout the docs.
>
> The reason I was looking was to generate customer reports via the API.
> I would like to be able to generate a report for each customer who either
> has a non-zero balance or where some transaction (invoice or receipt of
> payment) happened last month (or since rather since I last ran the program).
> I then want to export the report as a PDF.? I have looked my way through
> the API docs but could not see how to generate reports, or to check for
> the balance or the presence of transactions since a date.
>
> I found docs on how to create invoices, but also need to be able to
> export them as PDFs and could not locate the API for that either.? I notice
> in the gnucash XML files that the last direcorty to which invoices ( and I
> guess customer reports ) were exported is stored, is this available from
> the API.
>
> What I want to be able to write is a program that will generate reports
> for all relevant customers, and then send an email to each customer who
> has either an invoice and/or a report containing both.
>
> Any pointers gratefully received.
>
> David
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at 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.
>
>
>    
>
> ------------------------------
>
> Message: 8
> Date: Fri, 10 Jun 2016 18:42:16 -0400
> From: Elmar Schmeisser <eschmeisser at nc.rr.com>
> To: gnucash-user at gnucash.org
> Subject: fixed assets
> Message-ID: <c4a76225-c40b-5f08-c145-3b0cda59a2ce at nc.rr.com>
> Content-Type: text/plain; charset=utf-8
>
> I have a question on how to update the value of fixed assets (car,
> house, etc.).  One can of course assign a value when the asset is
> created in GC, but what account does the appreciation/depreciation come
> from? - Elmar
>
>
>
>
> ------------------------------
>
> Message: 9
> Date: Fri, 10 Jun 2016 19:02:43 -0400
> From: Mike Alexander <mta at umich.edu>
> To: Roy Hammerstr?m <roy.hammerstrom at outlook.com>
> Cc: gnucash-user <gnucash-user at gnucash.org>
> Subject: Re: Advance portfolio
> Message-ID: <60E1CBA8-0171-481F-822D-D7056ED4C093 at umich.edu>
> Content-Type: text/plain;	charset=utf-8
>
> Sorry fir the delay replying.  I?ve inserted some comments in the text below.
>
>> On Jun 2, 2016, at 9:20 AM, Roy Hammerstr?m <roy.hammerstrom at outlook.com> wrote:
>>
>> In "price source" I did try them both to see if that helped, but as far as I can tell, it didn't.
>> Can it maybe be something that I've done, or should have done to connect the price list database and the shares?
>> Or should that not matter?
> They are connected automatically, there is nothing you need to do except make sure you enter (or download) prices for the correct stock.
>
>> It looks weird that the report don't take the prices from the database. I've tried to look at all the options I could find to see if that had anything to do with it. When I go "accounts" and then click on the "edit" button to change the share, one of the thing there is "smallest subdivision" (or what it is called in English, the one where you select "use product value", "1/10", "1/100", "1/1000" etc), what is the best one to select there?
> I don?t think the report cares what you select for that option.  It determines the smallest fraction of a share you can record, but dowsn?t affect the price.
>
>> I just had at the "investment portfolio" report and in that one, it looks like the report uses the correct numbers.
>> In fact, I just did double check the numbers in the investment portfolio, and the total value for each share is correct.
>> And the total value for all my shares according to the investment portfolio, is the same as it is in the advanced portfolio.
>> So I also did check the total value for my share when I bought them, and that amount is also correct in the advanced portfolio.
>> So it then looks like the buying price and value in the advance portfolio is correct, but not the price.
>> Therefore, since so much is correct, with the exception of the price, I wonder how much more we should put in to this.
>>
> So you?re saying that the current value doesn?t equal the number of shares times the price?  Is that correct?  This seems odd.  Perhaps it is a currency exchange rate problem.  You probably said before, but I can?t recall the answer.  Is the currency of the report the same as the currency in the price database for the stocks in question?  The price fields in the report should be links.  If you click on one of them it should open the price DB entry from which the price was taken.  Does this work and if so what do you find?   Is the currency what you expect?  Is it the same as the report?s currency?  Is the price the same as shown in the report?
>
>               Mike
>   
>
> ------------------------------
>
> Message: 10
> Date: Fri, 10 Jun 2016 16:11:38 -0700
> From: John Ralls <jralls at ceridwen.us>
> To: Elmar Schmeisser <eschmeisser at nc.rr.com>
> Cc: gnucash-user at gnucash.org
> Subject: Re: fixed assets
> Message-ID: <479DE104-C514-4ABE-9108-670D3D3C929A at ceridwen.us>
> Content-Type: text/plain; charset=us-ascii
>
>
>> On Jun 10, 2016, at 3:42 PM, Elmar Schmeisser <eschmeisser at nc.rr.com> wrote:
>>
>> I have a question on how to update the value of fixed assets (car,
>> house, etc.).  One can of course assign a value when the asset is
>> created in GC, but what account does the appreciation/depreciation come
>> from? - Elmar
> That's more of an accounting question than a GnuCash one, and if this is for a business you should consult a licensed accountant for advice. In the USA depreciation is normally an expense. Change in market value is not normally entered into accounts until the asset is sold unless one is a bank large enough to be subject to Dodd-Frank which requires those banks to "mark to market" certain liabilities. In GnuCash one could create a security representing the asset and add prices for it in the price editor; its "market value" will then show on the Accounts page without affecting its "book value" in the register.
>
> Regards,
> John Ralls
>
>
>
>
>
>
> ------------------------------
>
> Message: 11
> Date: Fri, 10 Jun 2016 20:41:45 -0230
> From: Mark Mercer <markm at woodjoint.ca>
> To: Wm <tcnw81 at tarrcity.demon.co.uk>
> Cc: gnucash-user at gnucash.org
> Subject: Re: External Program
> Message-ID: <6f54109e-5086-6965-4cdf-0790118ab069 at woodjoint.ca>
> Content-Type: text/plain; charset=windows-1252; format=flowed
>
> thanks Wm,
>
> Lol yes I'm aware that if I go writing to the gnc db with an external
> prog it could result in tears.  My hope is I get it right from the
> beginning and its smooth sailing.  This is a brand new business startup
> so I don't have any old data to screw up.  As such I also don't have any
> "immediate" business to get done (that is unless I cant figure this out
> by Monday).  I did consider using the import files and I will likely go
> that route if this method doesn't work but it adds that extra step and a
> whole lot of shenanigans with remembering to import and having your code
> remember which records have already been exported.  It would be much
> simpler to bypass all that.
>
> I'll read up on the links you gave me.  I'm just in the process now of
> putting together the gnucash file that aaron suggested so that he can
> help me out.
>
> Thanks again.
>
> Mark
>
> On 10/06/2016 6:21 PM, Wm wrote:
>> [FYI: This is a copy of a message posted to <news:gmane.comp.gnome.apps.gnucash.user> Message-ID: <1wl0ubhhw5w4r.dlg at tcnw81.tarrcity.invalid>]
>>
>> On Thu, 9 Jun 2016 20:04:53 -0230, in gmane.comp.gnome.apps.gnucash.user,
>> Mark Mercer <markm at woodjoint.ca> wrote:
>>
>>> Thank you both for your replies.
>>>
>>> What I actually did was I went into gnucash and created a record in one
>>> of the sections and then I opened up SQL workbench and looked through
>>> the tables.  The record I created actually made entries in three or four
>>> tables so I studied what each table was for which guid's pointed to
>>> where and then duplicated the records in the database and assigned new
>>> guid's that I made up.  I opened gnucash and it did not display the new
>>> records that I created. Any idea's?  I must be missing something.
>>>
>>> I will use gnucash to enter most records but for these sales receipts I
>>> think it will be a bit clunky.  I would rather create a robust app on my
>>> own that can enter the data in a few clicks and selecting stuff from
>>> dropdows etc.
>>>
>>> If you could help me a little further to get this working it would make
>>> everything so much simpler for me.
>>>
>>> Thanks again.
>> If you've an immediate business problem to solve get your external prog to
>> create perfectly formed gnc import files, that way you can get on with
>> doing the important stuff and solve any API issues at your leisure.
>> Imports are only fiddly if you are doing them as a one off, done regularly
>> they are efficient.
>>
>> Meanwhile if you're familiar with relational databases
>> https://wiki.gnucash.org/wiki/images/8/86/Gnucash_erd.png
>> can be a good starting point.
>>
>> I strongly recommend looking at Sebastien's work if you are going to be
>> looking at gnc from an sql POV in a non-trivial way, start here:
>>
>> http://piecash.readthedocs.io/en/latest/tutorial/index_existing.html#other-objects
>>
>> Warning: discussion of writing to a gnc database in an unapproved way may
>> result in tears.
>>
>
>
> ------------------------------
>
> Message: 12
> Date: Fri, 10 Jun 2016 19:30:46 -0400
> From: Elmar Schmeisser <eschmeisser at nc.rr.com>
> To: gnucash-user at gnucash.org
> Subject: Re: fixed assets
> Message-ID: <1238ac07-4027-befc-099e-3e71bc2df4f3 at nc.rr.com>
> Content-Type: text/plain; charset=windows-1252
>
> This is strictly non-business :)  MY house, MY car - I want to get GC to
> calculate my "net worth" in essence.  So I have the purchase price of my
> house (paid off btw if that matters), and Zillow will every so often
> give me an updated value on my house.  Likewise, Kelly Blue Book (among
> others) will give me updated (lower of course) values on my (paid off)
> car.  How can I handle this in GC? - Elmar
>
> On 6/10/2016 7:11 PM, John Ralls wrote:
>>> On Jun 10, 2016, at 3:42 PM, Elmar Schmeisser
>>> <eschmeisser at nc.rr.com> wrote:
>>>
>>> I have a question on how to update the value of fixed assets (car,
>>> house, etc.).  One can of course assign a value when the asset is
>>> created in GC, but what account does the appreciation/depreciation
>>> come from? - Elmar
>> That's more of an accounting question than a GnuCash one, and if this
>> is for a business you should consult a licensed accountant for
>> advice. In the USA depreciation is normally an expense. Change in
>> market value is not normally entered into accounts until the asset is
>> sold unless one is a bank large enough to be subject to Dodd-Frank
>> which requires those banks to "mark to market" certain liabilities.
>> In GnuCash one could create a security representing the asset and add
>> prices for it in the price editor; its "market value" will then show
>> on the Accounts page without affecting its "book value" in the
>> register.
>>
>> Regards, John Ralls
>>
>>
>>
>>
>
>
> ------------------------------
>
> Message: 13
> Date: Fri, 10 Jun 2016 16:38:03 -0700
> From: John Ralls <jralls at ceridwen.us>
> To: Elmar Schmeisser <eschmeisser at nc.rr.com>
> Cc: gnucash-user at gnucash.org
> Subject: Re: fixed assets
> Message-ID: <CA8F77C8-4A75-4E4A-8CD3-E9607779B34E at ceridwen.us>
> Content-Type: text/plain; charset=us-ascii
>
>
>> On Jun 10, 2016, at 4:30 PM, Elmar Schmeisser <eschmeisser at nc.rr.com> wrote:
>>
>> This is strictly non-business :)  MY house, MY car - I want to get GC to
>> calculate my "net worth" in essence.  So I have the purchase price of my
>> house (paid off btw if that matters), and Zillow will every so often
>> give me an updated value on my house.  Likewise, Kelly Blue Book (among
>> others) will give me updated (lower of course) values on my (paid off)
>> car.  How can I handle this in GC? - Elmar
>>
>> On 6/10/2016 7:11 PM, John Ralls wrote:
>>> In GnuCash one could create a security representing the asset and add
>>> prices for it in the price editor; its "market value" will then show
>>> on the Accounts page without affecting its "book value" in the
>>> register.
> Just as I said. That will also reflect in the Net Worth reports.
>
> Regards,
> John Ralls
>
>
>
>
> ------------------------------
>
> Subject: Digest Footer
>
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>
>
> ------------------------------
>
> End of gnucash-user Digest, Vol 159, Issue 17
> *********************************************