That would do it - the schema prohibits NULLs.
I don't believe it is possible to import securities, it is not an option
on the Import menu. Depending how many you have, you could consider:-
Learning to script AutoHotKey - https://www.autohotkey.com/ - which is
excellent for automating Windows applications.
Or (big stretch) have a look at PieCash - the securities table is called
"commodities" -
https://github.com/sdementen/piecash/blob/master/piecash/core/commodity.py
- but direct database manipulation may void your GnuCash warranty.
I reckon you will probably find it quicker to type them in yourself -
you can import price data from CSV once the securities themselves are
set up.
Hope this helps.
Regards
Geoff
=====
On 20/10/2021 7:25 pm, Public Address wrote:
Thank you all. Someone last night pointed me to the trace file. I
tried to save as sqlite3, failed then closed down. The last lines are
as follows:
* 17:59:21 ERROR <gnc.engine> gboolean qof_book_is_readonly(const
QofBook*): assertion 'book != NULL' failed
* 17:59:26 ERROR <gnc.backend.dbi> [error_handler()] DBI error: 19: NOT
NULL constraint failed: splits.memo
* 17:59:26 ERROR <gnc.backend.dbi>
[GncDbiSqlConnection::execute_nonselect_statement()] Error executing SQL
INSERT INTO
splits(guid,tx_guid,account_guid,memo,action,reconcile_state,reconcile_date,value_num,value_denom,quantity_num,quantity_denom)
VALUES('[xxx]','[xxy]','[xxz]',NULL,'','c','2021-01-24
17:57:12',46353,100,46353,100)
* 17:59:26 ERROR <gnc.backend.sql>
[GncSqlBackend::execute_nonselect_statement()] SQL error: INSERT INTO
splits(guid,tx_guid,account_guid,memo,action,reconcile_state,reconcile_date,value_num,value_denom,quantity_num,quantity_denom)
VALUES('[xxx]','[xxy]','[xxz]',NULL,'','c','2021-01-24
17:57:12',46353,100,46353,100)
I am not sure how to look for transactions via the guid_tx, but I
searched for 463.53. I was then shown a split transaction view of a
transaction that was put into the imbalance account. The description
was “NULL” where the rectangle is in the attached. Some of my other
imbalance entries had this entry, some did not. So I removed them all
and now it writes.
I don't believe I put these “NULL”s in, I think gnucash did it so might
be something to look into.
Not sure if you saw my other question – can import securities (not the
security transactions) or can I only add them via the GUI?
Many Thanks
Sent from Mail <https://go.microsoft.com/fwlink/?LinkId=550986> for Windows
*From: *Geoff <mailto:cleanoutmys...@gmail.com>
*Sent: *20 October 2021 04:29
*To: *David Carlson <mailto:david.carlson....@gmail.com>
*Cc: *Public Address <mailto:public.addr...@hotmail.co.uk>;
gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>
*Subject: *Re: [GNC] save as sqlite3 error
Good pickup David - Thunderbird dropped the attachment, but I can see it
via Gmail {:--(
Not that it helps much PA, as John said, please check the trace file.
Geoff
=====
On 20/10/2021 2:04 pm, David Carlson wrote:
> It is odd that PA's screenshot made it to my Gmail account in Windows OS
> when it did not get to Geoff's email client, or maybe it did but Geoff
> did not see it because for some reason there was an inline link as well
> as an attachment at the end. In either case I cannot comment on the
> sqlite issue as I have no experience with that. Did I see an email
> elsewhere suggesting that sometimes an incorrect version of some library
> program was incorrectly selected by the installation program?
>
> On Tue, Oct 19, 2021 at 8:16 PM Geoff <cleanoutmys...@gmail.com
> <mailto:cleanoutmys...@gmail.com <mailto:cleanoutmys...@gmail.com>>>
wrote:
>
> Hi PA
>
> I can't help you with this error except to say that I am running
on the
> same build on Windows 10 and cannot reproduce your problem. BUT I do
> not have Trading Accounts switched on.
>
> I successfully saved a 35MB XML file to SQLite and can access
that file
> in both GnuCash and the SQLite DB Browser. See attached screenshot.
>
> (Your screenshot didn't come through - try attaching instead of
> pasting).
>
> Have you tried debugging: https://wiki.gnucash.org/wiki/Logging
<https://wiki.gnucash.org/wiki/Logging>
> <https://wiki.gnucash.org/wiki/Logging
<https://wiki.gnucash.org/wiki/Logging>>
>
> Start gnucash.exe from the command line with the "--debug"
switch. In
> my case, the log files are called gnucash.traceXXXXXX.log in
> ~\AppData\Local\Temp
>
> Being Windows, perhaps a reboot may help?
>
> Good luck.
>
> Regards
>
> Geoff
> =====
>
> On 19/10/2021 6:27 pm, Public Address wrote:
> > Hi - In xml format
> >
> > Trying to save as sqlite3 getting error when file gets to 213kb.
> Plenty of room on disk. I have tried different drives, different
> filenames no luck.
> >
> > [cid:image001.png@01D7C4C2.F1FEDBF0]
> >
> >
> > Many thanks
> >
> > Windows 10
> > GNU 4.8
> > Build ID 4.8a+ (2021-09-28)
> > Finance::Quote 1.49
> >
> > Trading Accounts: on
> >
> > Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986
> <https://go.microsoft.com/fwlink/?LinkId=550986
<https://go.microsoft.com/fwlink/?LinkId=550986>>> for Windows
> >
> >
> >
> > _______________________________________________
> > gnucash-user mailing list
> > gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org
<mailto:gnucash-user@gnucash.org>>
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
<https://lists.gnucash.org/mailman/listinfo/gnucash-user>
> <https://lists.gnucash.org/mailman/listinfo/gnucash-user
<https://lists.gnucash.org/mailman/listinfo/gnucash-user>>
> > If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists
<https://wiki.gnucash.org/wiki/Mailing_Lists>
> <https://wiki.gnucash.org/wiki/Mailing_Lists
<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 <mailto:gnucash-user@gnucash.org
<mailto:gnucash-user@gnucash.org>>
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
<https://lists.gnucash.org/mailman/listinfo/gnucash-user>
> <https://lists.gnucash.org/mailman/listinfo/gnucash-user
<https://lists.gnucash.org/mailman/listinfo/gnucash-user>>
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists
<https://wiki.gnucash.org/wiki/Mailing_Lists>
> <https://wiki.gnucash.org/wiki/Mailing_Lists
<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.
>
>
>
> --
> David Carlson
_______________________________________________
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.
