I have 500 transactions under checking account for importing files... how can i put this all in linked accounts...
Everytime i do that they fall to imbalance usd.. can you help to fix it. So i can do it in faster way. Thank you On Fri, Aug 25, 2023, 5:08 AM jackielou wong <jcklcalim...@gmail.com> wrote: > 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.
