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.