The file that i give to you what is the proper transfer fir "deposit, " its under checking account. Can u send it bank sample
On Fri, Aug 25, 2023, 5:06 AM David Cousens <davidcousen...@gmail.com> wrote: > Jackielou, > > The file looks ok. You will need to have created the accounts in the > transfer > column before importing. You may have to experiment with the header to > apply to > the amount column. Assuming you are importing the transactions into an > account > of type Asset, e.g. a bank account then normally assigning the deposit > header to > the column with the Amounts should import OK. Try a small sample first and > if it > doesn't import with debit transactions for the +ve amounts in the Amount > column > of your import file switch the header assigned to Withdrawal. For the other > columns assigning the header that matches the column name should be ok. > Make > sure the date format is "mm-dd-yyy" in the CSV setup dialogue. > Unfortunately > with CSV importing it takes a bit of fiddling but once you have a correct > setup > for importing for a given source you can save the setup and recall it next > time > you have to import from the same source > > > You will need to either specify transfer accounts for all the entries and > the > accounts will have to have been created prior to the import or you will > need to > assign them at the import matcher dialogue of the import procedure. You can > create new accounts from the account tab while in the import matcher > dialogue > (while keeping it open) if they do not exist and then assign them to the > transactions in the import matcher dialogue. In most cases these appear to > be > transfers to the account you are importing into from another asset account > most > likely a main bank account to cover salary expenses. > > If this doesn't work for you can you post some screenshots of the import > matching process for the above file. > > David Cousens > > > On Thu, 2023-08-24 at 22:06 +0800, jackielou wong wrote: > > 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. > > > > > _______________________________________________ > > 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. > _______________________________________________ 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.
