[GNC] Yahoo JSON - throwing unauthorized error

[David T.]

It's a wiki, so you could put it in. You'd get to decide where that would best live, too.

FWIW, my method for doing this is to save the file as an SQLite file, open the result in a DB reader, locate the appropriate table there, and execute the change globally. Then I reopen the file in GnuCash and save it back to xml.

It feels easier to me to do it this way and it doesn't take much time.

⁣
David T.​

On May 8, 2023, 04:03, at 04:03, Bruce Schuck <bschuck at asgard-systems.com> wrote:
>To the maintainers of the Wiki, would this be something perhaps helpful
>
>to include in the section about stocks and commodities?
>
>I can also add 'xmlstarlet' commands as an alternative to manually 
>editing the file.
>
>- Bruce S.
>
>On 05/07/23 15:12:21 EDT Bruce Schuck bschuck at asgard-systems.com
>wrote:
>
>> Last time I switched en-masse (alphavantage to yahoo_json) I manually
> > edited my foobar.gnucash file. Worked like a charm.
>
>** Create a backup ** of foobar.gnucash before following these steps.
>Replace 'vim' with your preferred editor.
>
>~$ cp <pathtofile>/foobar.gnucash /tmp/foobar.gnucash.gz
>~$ cd /tmp
>/tmp $ gunzip foobar.gnucash
>/tmp $ vim foobar.gnucash
>
>In vim, change lines
>
><cmdty:quote_source>alphavantage</cmdty:quote_source>
>
>to
>
><cmdty:quote_source>yahoo_json</cmdty:quote_source>
>
>Save and exit
>
>/tmp $ gzip foobar.gnucash
>/tmp $ cp foobar.gnucash.gz <pathtofile>/foobar.gnucash
>
> > Run GnuCash, confirm quote sources for a random few securities.
>
> > There is also a handy tool for editing XML files on the fly,
> > xmlstarlet. It can also be used to modify the uncompressed
> > .gnucash file.
>
>- Bruce S.
>_______________________________________________
>gnucash-user mailing list
>gnucash-user at gnucash.org
>To update your subscription preferences or to unsubscribe:
>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.