Re: Error Connecting with MySql

[Mubasher Usman]

Hello John,I hope Your are doing well.AS per your last email, I shifted my
MySQL server 5.7 to 5.5.58. GnuCash version is same as 2.6.18.First I tried
to connect with localhost string but it did not worked then I tried with
127.0.0.1. This time connection was made but again I get the error I posted
at first place.* 13:13:35  CRIT  g_utf8_to_utf16: assertion 'str != NULL'
failed* 13:13:39  CRIT  [mysql_error_fn()] DBI error: 1292: Incorrect
datetime value: '1970010100' for column 'timespec_val' at row 1*
13:13:39  CRIT  [conn_execute_nonselect_statement()] Error executing SQL
INSERT INTO
slots(obj_guid,name,slot_type,int64_val,string_val,double_val,timespec_val,guid_val,numeric_val_num,numeric_val_denom,gdate_val)
VALUES('a45d5c866dc46a8f1a7cf3fc69409530','options',9,0,NULL,0,'1970010100','2c0920f95b0a000ef37a30ad2e7bdf6e',0,1,NULL)*
13:13:39  CRIT  [gnc_sql_do_db_operation()] SQL error: INSERT INTO
slots(obj_guid,name,slot_type,int64_val,string_val,double_val,timespec_val,guid_val,numeric_val_num,numeric_val_denom,gdate_val)
VALUES('a45d5c866dc46a8f1a7cf3fc69409530','options',9,0,NULL,0,'1970010100','2c0920f95b0a000ef37a30ad2e7bdf6e',0,1,NULL)*
13:13:39  CRIT  save_slot: assertion 'pSlot_info->is_ok' failed* 13:13:39 
CRIT  gnc_dbi_transaction_rollback: assertion 'sql_savepoint > 0' failedCan
You guide me what can I do Now?



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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: Error Connecting with MySql

[Mubasher Usman]

John Ralls-2 wrote
> Close. See https://bugzilla.gnome.org/show_bug.cgi?id=784623
> .Executive
> summary: MySQL later than 5.5 doesn’t work with GnuCash.Regards,John
> Ralls___gnucash-user mailing
> list

> gnucash-user@

> 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.

Thank you for Pointing Out to right direction. AS you suggest that later
than 5.5 not worked so I re install the MySQL ver 5.5.58. Now this time The
error is different. I tried two times. in first try there was no schema with
name gnucash exists. in 2nd try i created schema with name gnucash but the
error was same. Here is the stack trace."* 12:43:47  CRIT  g_utf8_to_utf16:
assertion 'str != NULL' failed* 12:43:48  CRIT 
[gnc_dbi_mysql_session_begin()] Unable to connect to database 'gnucash'*
12:43:57  CRIT  gnc_dbi_unlock: assertion 'dbi_conn_error( dcon, NULL ) ==
0' failed* 12:43:57  CRIT  gnc_sx_get_sxes_referencing_account: assertion
'sxactions != NULL' failed* 12:52:46  CRIT  g_utf8_to_utf16: assertion 'str
!= NULL' failed* 12:52:47  CRIT  [gnc_dbi_mysql_session_begin()] Unable to
connect to database 'gnucash'* 12:52:55  CRIT  gnc_dbi_unlock: assertion
'dbi_conn_error( dcon, NULL ) == 0' failed* 12:52:55  CRIT 
gnc_sx_get_sxes_referencing_account: assertion 'sxactions != NULL'
failed"*What could be the reason*RegardsMubasher



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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: Finance-Quote 1.47 released!

[Pierre Keller]

Le 12.11.2017 à 17:27, Erik Colson a écrit :

New version 1.47 of Finance-Quote is available with the following changes:
 * Use AlphaVantage for currency quotes instead of Yahoo (Mike 
Alexander)


This resolved my problem !

Thank you very very much Erik for all your efforts !

--

   Pierre Keller
   3006 Bern

___
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: Error Connecting with MySql

[Mubasher Usman]

John Ralls-2 wrote
>> Close. See https://bugzilla.gnome.org/show_bug.cgi?id=784623
>> ;.
> 
>> Executive summary: MySQL later than 5.5 doesn’t work with GnuCash.
> 
>> Regards,
>> John Ralls
> 
>> ___
>> gnucash-user mailing list
>> 

> gnucash-user@

>> 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.

I have read your link and the root cause is 1970010100 value. In my
gnucash database there is a table slots. so GnuCash tried to save
1979010100 value in the timespec_val column.

I search all in my xml file and did not found that value in xml backend. I
dont know where does this value come from and how to set this some
acceptable value.

For Your info I am now using MySQL 5.5.58 with GnuCash 2.6.18 on windows.

I really appreciate Your help to point me the direction in which I can use
mysql as I need this because I want to show the reports on web. I am a
software engineer in java and trying to build a front end for gnucash to
show the reports.

Thanks.
Mubasher



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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.

Scheduled Bills - No Number

[keithwjones]

I was a long time Quicken XG 2004 user but in Win 10 it would not add new
vendors. So the time was right for a change.

I had GnuCash in my sights for sometime so started to use it - 2.6.18.
Always helps to read manual before you start, all up and runnning smooothly.
I was manually adding bills and paying them and issuing invoices. 

Thought I would try scheduled transactions, never did in Quicken. First
attempt I had a payment but no bill. So I created two entries a bill and a
payment. This appears to work fine with entries in AP, general ledger, money
taken from bank account and an entry in expenses. Do I need two separate
entries?

Entering each one manually I get a bill number from the system but when I do
it by schedule no bill number is created. Am I missing something or is this
how the sytem works? 

I am impressed with the way GnuCash works, thank you to all those involved. 

Keith 



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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: Bank reconciliation

[Mike or Penny Novack]

On 11/13/2017 1:14 PM, Cam Ellison wrote:

On 13/11/17 09:45 AM, David Goodenough wrote:

Does no-one else have this problem?



I have dealt with this by setting up a separate Asset account for 
receiving payments, similar to what you have. When a payment is 
received, it goes into this "Payment" account, and then when the bank 
deposit is made the appropriate amount is debited from the Payment 
account. This process adds a step between receipt of the cheque (thus 
acknowledging the invoice as paid) and depositing it.
Not JUST acknowledging as paid. The customer is NOT responsible for your 
delay in depositing a check. Nor does any government I know of consider 
the date you received money to be the date you got around to depositing 
it << the LEGAL date might in fact be the date of "constructive 
delivery" which is why the postmark on a mailed payment might be 
important >>


The common name for an account of this sort is "undeposited cash". 
Especially if you normally are depositing several payments/checks at one 
time you might prefer to always have them first go to "undeposited cash" 
(each can be split on the other side as needed) and then the deposit 
transaction itself is simple/clean/uncluttered.


BTW , another account of this sort often used by businesses is 
"suspense". Say you receive a check but there is uncertainty what it is 
for, the correctness of the amount, etc.


Michael D Novack
___
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.

More F:Q Issues

[Les]

First, I had an upgrade of Perl to 5.22.1.  Not sure if that is what 
caused my Linux Get Quotes to just stop without any message. Perl on Mac 
is still at 5.18.


Second, I just checked currencies in Security Editor.  Over the weekend, 
I changed the 9 currencies I use to use Alphavantage. When I checked 
today, all the currencies what reverted to "Single".  I tried to change 
them back to Alphavantage but as soon as I had made the change, they 
reverted back to "Single".  This is also true of my Mac.


Third, I have no clue (nor any way to check) why Get Quotes on my Mac 
stopped with a message that retrieval encountered an unknown error.


Any suggestions as to how to fix these issues would be greatly appreciated.

Regards,

Les



___
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: Error Connecting with MySql

[John Ralls]

> On Nov 14, 2017, at 4:00 AM, Mubasher Usman  
> wrote:
> 
> John Ralls-2 wrote
>>> Close. See https://bugzilla.gnome.org/show_bug.cgi?id=784623
>>> ;.
>> 
>>> Executive summary: MySQL later than 5.5 doesn’t work with GnuCash.
>> 
>>> Regards,
>>> John Ralls
>> 
>>> ___
>>> gnucash-user mailing list
>>> 
> 
>> gnucash-user@
> 
>>> 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.
> 
> I have read your link and the root cause is 1970010100 value. In my
> gnucash database there is a table slots. so GnuCash tried to save
> 1979010100 value in the timespec_val column.
> 
> I search all in my xml file and did not found that value in xml backend. I
> dont know where does this value come from and how to set this some
> acceptable value.
> 
> For Your info I am now using MySQL 5.5.58 with GnuCash 2.6.18 on windows.
> 
> I really appreciate Your help to point me the direction in which I can use
> mysql as I need this because I want to show the reports on web. I am a
> software engineer in java and trying to build a front end for gnucash to
> show the reports.

Rats,

Did you unset STRICT_TRANS_TABLES as suggested in 
https://bugzilla.gnome.org/show_bug.cgi?id=784623#c13? 


If that doesn’t help you can try GnuCash 2.6.15.

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.

Re: Scheduled Bills - No Number

[Adrien Monteleone]

I’ve not used SX (Scheduled Transactions) for business features yet. I’m not 
sure that you can.

Sure, you can create the entry itself, but then it won’t go ‘through’ the 
business features. The AR & AP accounts are special accounts, and direct entry 
via their respective registers, or I would presume via SX, could introduce some 
issues.

Particularly, if you enter a payment directly in AP, it is not linked to the 
respective bill. You’d have to do this manually each time. (using the ‘Assign 
as Payment’ entry in the context menu) The same would work in reverse for AR. 
But if the bill/invoice wasn’t entered via the business features in the first 
place, I doubt this function would see it to assign the payment to.

I don’t think you get any means for bill reminders either if they are manually 
entered since you are skipping the mechanism to set due dates.

As for numbering bills, I suppose you could manually assign one to the 
transaction, possibly even enter a formula into the SX template editor, but the 
business features, particularly with the bill search feature will not recognize 
it at all. It’s also unlikely that a Vendor report would recognize any bill 
entered this way.

I do use SX for some business feature related entries.

For example, my auto insurance is pre-paid for six months. I enter a bill and 
then pay it via the business features but assign the bill’s amount to 
Assets:Current Assets:Pre-Paid Expenses:Auto Insurance instead of directly to 
Expenses:Auto:Insurance.

Then each month, I have a SX set to credit the asset and debit the expense for 
one-sixth of the original bill amount. (since I’ve now ‘used’ one month’s worth 
of insurance)

My Internet service is also pre-paid, but monthly at a different date than the 
bill. I enter the bill when received, marked due as the date on the bill, enter 
a payment when I actually do pay it, and then have a SX credit my pre-paid 
internet asset and debit my Expenses:Utilities:Internet account on the day of 
the month when the service cycle noted on the bill rolls over.

Hope that helps.

Regards,
Adrien

> On Nov 14, 2017, at 6:07 AM, keithwjones  wrote:
> 
> I was a long time Quicken XG 2004 user but in Win 10 it would not add new
> vendors. So the time was right for a change.
> 
> I had GnuCash in my sights for sometime so started to use it - 2.6.18.
> Always helps to read manual before you start, all up and runnning smooothly.
> I was manually adding bills and paying them and issuing invoices. 
> 
> Thought I would try scheduled transactions, never did in Quicken. First
> attempt I had a payment but no bill. So I created two entries a bill and a
> payment. This appears to work fine with entries in AP, general ledger, money
> taken from bank account and an entry in expenses. Do I need two separate
> entries?
> 
> Entering each one manually I get a bill number from the system but when I do
> it by schedule no bill number is created. Am I missing something or is this
> how the sytem works? 
> 
> I am impressed with the way GnuCash works, thank you to all those involved. 
> 
> Keith 
> 
> 
> 
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> 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.

Fwd: Need to print vouchers

[Frank H. Ellenberger]

forwarding to the user list ...


 Weitergeleitete Nachricht 
Betreff: Need to print vouchers
Datum: Thu, 26 Oct 2017 23:51:26 -0700
Von: Md. Amirul Islam 
An: alex.aycin...@gmail.com, frank.h.ellenber...@gmail.com,
ch...@wilddev.net

Dear All,

Do you have any option in Gnucash to print vouchers from software? Other
Accounting software have vouchers print option.

Best Regards,

AMIRUL

___
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: Scheduled Bills - No Number

[Derek Atkins]

Hi,

keithwjones  writes:

> I was a long time Quicken XG 2004 user but in Win 10 it would not add new
> vendors. So the time was right for a change.
>
> I had GnuCash in my sights for sometime so started to use it - 2.6.18.
> Always helps to read manual before you start, all up and runnning smooothly.
> I was manually adding bills and paying them and issuing invoices. 
>
> Thought I would try scheduled transactions, never did in Quicken. First
> attempt I had a payment but no bill. So I created two entries a bill and a
> payment. This appears to work fine with entries in AP, general ledger, money
> taken from bank account and an entry in expenses. Do I need two separate
> entries?
>
> Entering each one manually I get a bill number from the system but when I do
> it by schedule no bill number is created. Am I missing something or is this
> how the sytem works? 

You cannot schedule bills or invoices.  When you try what happens is
that is gets based on the original transaction but misses all the
Bill/Invoice metadata that gets created through the Business features.

Doing it this way will also cause the business reports to fail, because
the metadata will be missing.

> I am impressed with the way GnuCash works, thank you to all those involved. 
>
> Keith 

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-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: files

[John Ralls]

Christine,

Please remember to copy the list on all replies.

Is it read-only because you got the "unable to obtain the lock" dialog and 
selected "open read only"?

Regards,
John Ralls

> On Nov 14, 2017, at 10:12 AM, Christine  wrote:
> 
> Hi john
> I have windows 7 and can't remember how I opened it before, but this time I
> used open with and the file is read only so I cannot add more to the
> accounts. 
> Regards
> Christine 
> 
> 
> -Original Message-
> From: John Ralls [mailto:jra...@ceridwen.us] 
> Sent: 14 November 2017 03:56
> To: Christine
> Cc: GnuCash
> Subject: Re: files
> 
> Christine,
> 
> That is what I meant. How did you then open the file in the new location?
> What operating system/distro are you using?
> 
> Regards,
> John Ralls
> 
> 
>> On Nov 13, 2017, at 8:35 AM, Christine  wrote:
>> 
>> Hi John
>> Sorry I panicked and could not find out where to send messages. 
>> Gnucash was not open when I placed the files in a folder. If that is what
> you mean.
>> Kind regards
>> Christine
>> 
>> -Original Message-
>> From: John Ralls [mailto:jra...@ceridwen.us]
>> Sent: 13 November 2017 01:55
>> To: Christine
>> Cc: GnuCash
>> Subject: Re: files
>> 
>> 
>>> On Nov 12, 2017, at 4:27 PM, Christine via gnucash-user
>>  wrote:
>>> 
>>> Hello
>>> All my files are on the desktop where I saved them. So I put them in 
>>> a folder and now when I try to open one of the pages, it asks me to 
>>> save it, if I click on save it wants a new path, how can I work from 
>>> a main folder pls?
>>> Christine
>>> 
>> 
>> Please don't reply to messages when you want to start a new thread, it 
>> doesn't work.
>> 
>> Was GnuCash running when you moved the files?
>> 
>> Regards,
>> John Ralls
>> 
>> 
>> ---
>> This email has been checked for viruses by Avast antivirus software.
>> https://www.avast.com/antivirus
>> 
> 

___
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: files

[Christine via gnucash-user]

Hi john
Yes

-Original Message-
From: John Ralls [mailto:jra...@ceridwen.us] 
Sent: 14 November 2017 18:18
To: Christine
Cc: GnuCash
Subject: Re: files

Christine,

Please remember to copy the list on all replies.

Is it read-only because you got the "unable to obtain the lock" dialog and
selected "open read only"?

Regards,
John Ralls

> On Nov 14, 2017, at 10:12 AM, Christine  wrote:
> 
> Hi john
> I have windows 7 and can't remember how I opened it before, but this 
> time I used open with and the file is read only so I cannot add more 
> to the accounts.
> Regards
> Christine
> 
> 
> -Original Message-
> From: John Ralls [mailto:jra...@ceridwen.us]
> Sent: 14 November 2017 03:56
> To: Christine
> Cc: GnuCash
> Subject: Re: files
> 
> Christine,
> 
> That is what I meant. How did you then open the file in the new location?
> What operating system/distro are you using?
> 
> Regards,
> John Ralls
> 
> 
>> On Nov 13, 2017, at 8:35 AM, Christine  wrote:
>> 
>> Hi John
>> Sorry I panicked and could not find out where to send messages. 
>> Gnucash was not open when I placed the files in a folder. If that is 
>> what
> you mean.
>> Kind regards
>> Christine
>> 
>> -Original Message-
>> From: John Ralls [mailto:jra...@ceridwen.us]
>> Sent: 13 November 2017 01:55
>> To: Christine
>> Cc: GnuCash
>> Subject: Re: files
>> 
>> 
>>> On Nov 12, 2017, at 4:27 PM, Christine via gnucash-user
>>  wrote:
>>> 
>>> Hello
>>> All my files are on the desktop where I saved them. So I put them in 
>>> a folder and now when I try to open one of the pages, it asks me to 
>>> save it, if I click on save it wants a new path, how can I work from 
>>> a main folder pls?
>>> Christine
>>> 
>> 
>> Please don't reply to messages when you want to start a new thread, 
>> it doesn't work.
>> 
>> Was GnuCash running when you moved the files?
>> 
>> Regards,
>> John Ralls
>> 
>> 
>> ---
>> This email has been checked for viruses by Avast antivirus software.
>> https://www.avast.com/antivirus
>> 
> 

___
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: files

[John Ralls]

Christine,

That confirms my earlier belief that GnuCash was in fact running when you moved 
your files.
Quit GnuCash and re-start it. This time when you get that dialog click "Open 
Anyway".

Regards,
John Ralls

> On Nov 14, 2017, at 10:44 AM, Christine  wrote:
> 
> Hi john
> Yes
> 
> -Original Message-
> From: John Ralls [mailto:jra...@ceridwen.us] 
> Sent: 14 November 2017 18:18
> To: Christine
> Cc: GnuCash
> Subject: Re: files
> 
> Christine,
> 
> Please remember to copy the list on all replies.
> 
> Is it read-only because you got the "unable to obtain the lock" dialog and
> selected "open read only"?
> 
> Regards,
> John Ralls
> 
>> On Nov 14, 2017, at 10:12 AM, Christine  wrote:
>> 
>> Hi john
>> I have windows 7 and can't remember how I opened it before, but this 
>> time I used open with and the file is read only so I cannot add more 
>> to the accounts.
>> Regards
>> Christine
>> 
>> 
>> -Original Message-
>> From: John Ralls [mailto:jra...@ceridwen.us]
>> Sent: 14 November 2017 03:56
>> To: Christine
>> Cc: GnuCash
>> Subject: Re: files
>> 
>> Christine,
>> 
>> That is what I meant. How did you then open the file in the new location?
>> What operating system/distro are you using?
>> 
>> Regards,
>> John Ralls
>> 
>> 
>>> On Nov 13, 2017, at 8:35 AM, Christine  wrote:
>>> 
>>> Hi John
>>> Sorry I panicked and could not find out where to send messages. 
>>> Gnucash was not open when I placed the files in a folder. If that is 
>>> what
>> you mean.
>>> Kind regards
>>> Christine
>>> 
>>> -Original Message-
>>> From: John Ralls [mailto:jra...@ceridwen.us]
>>> Sent: 13 November 2017 01:55
>>> To: Christine
>>> Cc: GnuCash
>>> Subject: Re: files
>>> 
>>> 
 On Nov 12, 2017, at 4:27 PM, Christine via gnucash-user
>>>  wrote:
 
 Hello
 All my files are on the desktop where I saved them. So I put them in 
 a folder and now when I try to open one of the pages, it asks me to 
 save it, if I click on save it wants a new path, how can I work from 
 a main folder pls?
 Christine
 
>>> 
>>> Please don't reply to messages when you want to start a new thread, 
>>> it doesn't work.
>>> 
>>> Was GnuCash running when you moved the files?
>>> 
>>> Regards,
>>> John Ralls
>>> 
>>> 
>>> ---
>>> This email has been checked for viruses by Avast antivirus software.
>>> https://www.avast.com/antivirus
>>> 
>> 
> 

___
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.

Alphavantage does not recognise ASX

[WasserLand]

I have followed, as best I can, all the instuctions in the Wiki. 
Alphavantage returns prices from USA stock(?) via Amsterdam exchange.  
My stock is ASX (Australia).  Can't seem to get thee correct configuration.


Dave W
___
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: Scheduled Bills - No Number

[keithwjones]

Derek Atkins wrote
> You cannot schedule bills or invoices.  When you try what happens is
> that is gets based on the original transaction but misses all the
> Bill/Invoice metadata that gets created through the Business features.
> 
> Doing it this way will also cause the business reports to fail, because
> the metadata will be missing.

All noted will enter manually.




-
GnuCash 2.6.18 - Windows 10
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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.

Continued Discover Card woes

[Chris Szilagyi]

Hello:

I've been continuing to try to get Discover Card working again with OFX 
and so far have been unsuccessful.  I'm getting a 403 (forbidden) error 
when trying to download transactions.  I've been combing various OFX 
forums that mention Discover has changed their side a couple of times 
and I've tried various Special Settings in the AQBanking setup with no 
luck.  A couple of recent posts from May 2017 state that Discover has 
gone to an account number format of : "Discovr##x##xx", however 
I'm unable to find out what this account number is anywhere on their 
site.  So, I have tried to do a Retrieve Account List under the 
AQBanking setup, and I get nothing. The output is:


18:39:04 Sending request...
18:39:04 TLS: SSL-Cipher priority list: SECURE256:SECURE128
18:39:04 TLS: SSL-Ciphers negotiated: TLS1.2:ECDHE-RSA-AES-256-GCM:AEAD
18:39:04 Waiting for response...
18:39:05 Operation finished, you can now close this window.

But it seems no accounts are found or retrieved.

Just curious if anybody has been able to get any Discover accounts 
working with AQBanking and if so, how?


Thanks for the help.
___
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: Alphavantage does not recognise ASX

[Frank H. Ellenberger]

Hi Dave,

Am 14.11.2017 um 23:14 schrieb WasserLand:
> I have followed, as best I can, all the instuctions in the Wiki.
> Alphavantage returns prices from USA stock(?) via Amsterdam exchange. 
> My stock is ASX (Australia).  Can't seem to get thee correct configuration.
> 
> Dave W

Alphavantage tries to become a replacement for the recently closed yahoo
csv interface. Aliases of this are:
 Currency, yahoo* (with exception of json), canada, usa, nyse, nasdaq,
vanguard.

AEX (Amsterdam Euronext eXchange) and
ASX (Australia Stock eXchange) are totally different sources and
modules. They are not affected.

See also Appendix A of gnucash-help
https://code.gnucash.org/docs/C/gnucash-help/apas01.html

HTH

Frank
___
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.