Hello i tried to import and csv file. Can you help me to transfer all of this into proper account; Here is my sample
On Thu, Aug 24, 2023 at 9:36 PM Murugan Muruganandam < m.muruganan...@hotmail.com> wrote: > hi Jack > > can you be more specific on what help you are looking for. there are > quite a few knowlede base online > > > > Saludos Cordiales > > > Murugan > ------------------------------ > *From:* gnucash-user <gnucash-user-bounces+m.muruganandam= > hotmail....@gnucash.org> on behalf of jackielou wong < > jcklcalim...@gmail.com> > *Sent:* Thursday, August 24, 2023 12:07 AM > *To:* john <jra...@ceridwen.us> > *Cc:* gnucash-user@gnucash.org <gnucash-user@gnucash.org> > *Subject:* Re: [GNC] get quotes via gnucash-cli for unknown quote source > > Hello there > > Can i ask for importing 100 transactions using csv. > > On Thu, Aug 24, 2023, 12:00 PM john <jra...@ceridwen.us> wrote: > > > > > > > > On Aug 23, 2023, at 02:26, Jascha K via gnucash-user < > > gnucash-user@gnucash.org> wrote: > > > > > > Hi, > > > > > > I've been trying to get quotes via gnucash-cli with the following > > command: > > > > > > gnucash-cli --quotes get mysql://<connection-details> > > > > > > However, I get the following message when executing the command and no > > quotes are fetched: 'Price retrieval failed: GncQuotes::Fetch called with > > no commodities.' > > > > > > All of my quote sources are of type 'Unknown' (tradegate, fondsweb). > > > > > > When I get the quotes via 'Get Quotes' in the Price Database, the > quotes > > are fetched normally, so it seems to be a problem with the CLI. > > > > > > After some investigation, I found out 2 things: > > > > > > 1. When switching the quote source for a security to a source that is > > not Unknown, the CLI is able to fetch that security's quote. > > > > > > 2. When I edit the file libgnucash/engine/gnc-commodity.c and add the > > tradegate and fondsweb sources to the 'single_quote_sources' variable > (thus > > making them known sources), the CLI is able to fetch all quotes, no more > > errors. > > > > > > This leads me to believe that the CLI fetching ignores securities where > > the quote source is Unknown, whereas the GUI fetches the quotes > regardless > > of the quote source. I was not able to pin down this behavior in the > > source, but maybe somebody can clarify whether this is the desired > behavior > > for the CLI. > > > > > > Tested with most recent stable branch and Flatpak version 5.3, F::Q > > versions 1.54, 1.56 and 1.58, on Ubuntu 22.04. > > > > Not desired behavior but not surprising either: In order to know about > the > > unknown quote source gnucash-cli -Q get needs to retrieve them from F::Q > > and it doesn't do that. Shouldn't be too hard to fix, but please file a > bug > > so that the problem doesn't get lost in mailing list entropy. > > > > Regards, > > John Ralls > > > > _______________________________________________ > > gnucash-user mailing list > > gnucash-user@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. > > > _______________________________________________ > gnucash-user mailing list > gnucash-user@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. >
Id,Date,Desc,transfer,Amount 1,06/27/2020,Deposit bofa,,30000 2,06/30/2020, LLC : QUICKBOOKS ID: ,,1881.34 3,06/30/2020,LLC : QUICKBOOKS ID: 1722616653CO: ,,18000 4,06/30/2020,Deposit Dividend 0.500% Annual Percentage Yield Earned 0.50% from ,Income: interest,0.82 5,07/21/2020,INTUIT PAYROLL S : QUICKBOOKS ID: 1722616679 CO: INTUIT PAYROLL S Entry Class Code: CCD ACH : 7764315,,-0.56 6,07/21/2020,INTUIT PAYROLL S : QUICKBOOKS ID: 1722616679 CO: INTUIT PAYROLL S Entry Class Code: CCD ACH : 7764314,,-0.94 7,07/28/2020,INTUIT PAYROLL S : QUICKBOOKS ID: 1722616679CO: INTUIT PAYROLL S Entry Class Code: CCD ACH : 8116937,,0.56 8,07/28/2020,INTUIT PAYROLL S : QUICKBOOKS ID: 1722616679CO: INTUIT PAYROLL S Entry Class Code: CCD ACH : 8116938,,0.94 9,07/28/2020, LLC : QUICKBOOKS ID: 1722616653CO: LLC Entry Class Code: PPD ACH : 8223375,,2000.65 10,07/28/2020,INTUIT PAYROLL S : QUICKBOOKS ID: 1722616679 CO: INTUIT PAYROLL S Entry Class Code: CCD ACH : 8116939 (),Expenses:salary,-2002.4 11,07/30/2020, LLC : QUICKBOOKS ID: 1722616653CO: LLC Entry Class Code: PPD ACH : 3946318,,2000.66 12,07/30/2020,INTUIT PAYROLL S : QUICKBOOKS ID: 1722616679 CO: INTUIT PAYROLL S Entry Class Code: CCD ACH : 3220527 (),Expenses:salary,-2002.41 13,07/31/2020,Deposit Dividend 0.500% Annual Percentage Yield Earned 0.50% from ,Income: interest,12.58 14,08/13/2020, LLC : QUICKBOOKS ID: 1722616653CO: LLC Entry Class Code: PPD ACH : 9675915,,2000.66 15,08/13/2020,INTUIT PAYROLL S : QUICKBOOKS ID: 1722616679 CO: INTUIT PAYROLL S Entry Class Code: CCD ACH : 8969843 (),Expenses:salary,-2002.41 16,08/27/2020, LLC : QUICKBOOKS ID: 1722616653CO: LLC Entry Class Code: PPD ACH : 2618667,,2000.65 17,08/27/2020,INTUIT PAYROLL S : QUICKBOOKS ID: 1722616679 CO: INTUIT PAYROLL S Entry Class Code: CCD ACH : 2035498 (),Expenses:salary,-2002.4 18,08/31/2020,Deposit Dividend 0.500% Annual Percentage Yield Earned 0.50% from ,Income: interest,12.58 19,09/10/2020, LLC : QUICKBOOKS ID: 1722616653CO: LLC Entry Class Code: PPD ACH : 5450198,,2000.66 20,09/10/2020,INTUIT PAYROLL S : QUICKBOOKS ID: 1722616679 CO: INTUIT PAYROLL S Entry Class Code: CCD ACH : 4883982 (),Expenses:salary,-2002.41 21,09/29/2020, LLC : QUICKBOOKS ID: 1722616653CO: LLC Entry Class Code: PPD ACH : 1105487,,2000.66 22,09/29/2020,INTUIT PAYROLL S : QUICKBOOKS ID: 1722616679 CO: INTUIT PAYROLL S Entry Class Code: CCD ACH : 0843194 (),Expenses:salary,-2002.41 23,09/30/2020,Deposit Dividend 0.500% Annual Percentage Yield Earned 0.50% from ,Income: interest,12.18 24,10/15/2020, LLC : QUICKBOOKS ID: 1722616653CO: LLC Entry Class Code: PPD ACH : 0212844,,2000.65 25,10/15/2020,INTUIT PAYROLL S : QUICKBOOKS ID: 1722616679 CO: INTUIT PAYROLL S Entry Class Code: CCD ACH : 9614947 (),Expenses:salary,-2002.4 26,10/31/2020,Deposit Dividend 0.500% Annual Percentage Yield Earned 0.50% from ,Income: interest,12.59 27,11/09/2020, LLC : QUICKBOOKS ID: 1722616653CO: LLC Entry Class Code: PPD ACH : 4524420,,2000.67 28,11/19/2020, LLC : QUICKBOOKS ID: 1722616653CO: LLC Entry Class Code: PPD ACH : 0838013,,2000.65 29,11/30/2020,Deposit Dividend 0.500% Annual Percentage Yield Earned 0.50% from ,Income: interest,13.12 30,12/03/2020, LLC : QUICKBOOKS ID: 1722616653CO: LLC Entry Class Code: PPD ACH : 9083083,,2000.65 31,12/17/2020, LLC : QUICKBOOKS ID: 1722616653CO: LLC Entry Class Code: PPD ACH : 3577977,,2000.66 32,12/28/2020, LLC : QUICKBOOKS ID: 1722616653CO: LLC Entry Class Code: PPD ACH : 3965204,,18000 33,12/31/2020, LLC : QUICKBOOKS ID: 1722616653CO: LLC Entry Class Code: PPD ACH : 4323482,,2003.65 34,12/31/2020,peachtree,Expenses:subscription,-2293 35,12/31/2020,Deposit Dividend 0.500% Annual Percentage Yield Earned 0.50% from ,Income: interest,16.47
_______________________________________________ gnucash-user mailing list gnucash-user@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.