Re: [GNC] Importing Accounts with non-English Characters

2021-03-16 Thread viking
:09 schrieb viking: >> However, there is no such option when importing *Accounts*. Quite an old bug from 2017. Is there a workaround to be able to import accounts with non-English characters? I am also not able to /manually/ create a new account including non-English characters. For example,

Re: [GNC] Importing Accounts with non-English Characters

2021-03-16 Thread Frank H. Ellenberger
right, it is on the list: https://bugs.gnucash.org/show_bug.cgi?id=785860 - "Export Account Tree to CSV" and "Import Accounts from CSV" should use the same dialogs as "...Transactions..." Am 16.03.21 um 09:09 schrieb viking: > However, there is no suc

Re: [GNC] Importing Accounts with non-English Characters

2021-03-16 Thread viking
Jim DeLaHunt wrote > On 2021-03-15 22:39, viking wrote: > >> There does nto appear to be an option in GnuCash to select UTF-8 when >> importing? > > According to the GnuCash Help documentation, section 6.16.5. "Import > CSV" (https://www.gnucash.org/viewdoc.

Re: [GNC] Importing Accounts with non-English Characters

2021-03-15 Thread Jim DeLaHunt
On 2021-03-15 22:39, viking wrote: There does nto appear to be an option in GnuCash to select UTF-8 when importing? According to the GnuCash Help documentation, section 6.16.5. "Import CSV" (https://www.gnucash.org/viewdoc.phtml?rev=4&lang=C&doc=help <https://www.gnuc

[GNC] Importing Accounts with non-English Characters

2021-03-15 Thread viking
e that I just exported, and the characters are "corrupted". When I open the exported CSV file in Excel, I need to select UTF-8 to avoid "corruption". There does nto appear to be an option in GnuCash to select UTF-8 when importing? I tested on v3.11 and v4.4 -- Sent from: htt

Re: [GNC] Remembering transactions when importing .qif transaction

2020-12-20 Thread David Cousens
went straight to importing. i have not tried importing the test files I had used recently so I don't know the current position. I will try to get some time to take another look at it, but the chances are not looking all that good with Christmas imminent at the moment.Maybe in the New Year. Dav

Re: [GNC] Remembering transactions when importing .qif transaction

2020-12-20 Thread David Carlson
I thought the Bayesian matching worked with QIF imports too. Has that been discontinued? Unfortunately, I rarely use the QIF format and I only have one poorly formed sample easily available to test. That sample fails completely. On Sun, Dec 20, 2020 at 2:56 AM David Cousens wrote: > Bruce > >

Re: [GNC] Remembering transactions when importing .qif transaction

2020-12-20 Thread David Cousens
Bruce You describe your problem as not remembering transactions. Is what you mean not remembering which external QIF category and account name map onto which GnuCash internal account name? That map is constructed the first time you import records to a particular GnuCash account. Under Tools_>Impo

[GNC] Remembering transactions when importing .qif transaction

2020-12-19 Thread BRUCE POULTER
Hello I have searched high and low for information on how GnuCash 'remembers transactions' in checking account registers when importing. My situation is that I have 3 business checking accounts and when I do my monthly (haha) importing of .qif files, only one of the accounts '

Re: [GNC] Importing qif from Moneydance

2020-11-20 Thread David H
See https://wiki.gnucash.org/wiki/Flatpak for Gnucash Flatpak install and run instructions - excerpt below # Install FlatPak (on debian based distributions, others have to replace 'apt-get install'): sudo apt-get install flatpak# Register FlatHub repository: sudo flatpak remote-add --if-not-ex

Re: [GNC] Importing qif from Moneydance

2020-11-20 Thread Adrien Monteleone
Reed, Sorry for the late reply, I don’t think your reply made it to the list. (I think the server was down that day and I found this in my regular mail client.) I see now you’ve installed the Flatpak. When you mentioned you installed from the Software Center, I guessed the standard version. I f

Re: [GNC] Importing qif from Moneydance

2020-10-28 Thread Reed Nelson via gnucash-user
I removed the CX from the gif and I am now able to import the gif files. Thank you Derek! Reed On Wednesday, October 28, 2020, 11:44:45 AM CDT, Derek Atkins wrote: Hi, On Wed, October 28, 2020 12:16 pm, Reed Nelson via gnucash-user wrote: > I tried to import a test bank account qif

Re: [GNC] Importing qif from Moneydance

2020-10-28 Thread Adrien Monteleone
Derek already explained the errors, but for completeness and future reference: Simply type `gnucash` at the command line. You may see some messages there which might be helpful, otherwise see the wiki about where the tracefile is stored on your system. Regards, Adrien On 10/28/20 11:16 AM,

Re: [GNC] Importing qif from Moneydance

2020-10-28 Thread Derek Atkins
Hi, On Wed, October 28, 2020 12:16 pm, Reed Nelson via gnucash-user wrote: > I tried to import a test bank account qif from Moneydance version > 2020.1(1928) into GnuCash version 4.2 (Ubuntu 20.04.1 LTS).   I installed > GnuCash with the software install app  (Software 3.36.1) > > Below is the err

[GNC] Importing qif from Moneydance

2020-10-28 Thread Reed Nelson via gnucash-user
I tried to import a test bank account qif from Moneydance version 2020.1(1928) into GnuCash version 4.2 (Ubuntu 20.04.1 LTS).   I installed GnuCash with the software install app  (Software 3.36.1) Below is the error message and qif file contents.    I could not find the log file to get more inf

Re: [GNC] Importing Liability Transactions to AP/Bills

2020-09-15 Thread Fran_3 via gnucash-user
FYI, this has been solved. Thanks. On Monday, September 14, 2020, 7:20:55 PM EDT, Fran_3 via gnucash-user wrote: David, That worked great. thanks! Next question... anyway to import payments? And, actually, instead of Assets: Checking making the payments...I want the payments to come

Re: [GNC] Importing Liability Transactions to AP/Bills

2020-09-14 Thread Fran_3 via gnucash-user
David, That worked great. thanks! Next question... anyway to import payments? And, actually, instead of Assets: Checking making the payments...I want the payments to come from...Liabilities: Reimbursements To/From Entity B Because Entity B paid a bunch of Bills for Entity A...So Entity A wants t

Re: [GNC] Importing Liability Transactions to AP/Bills

2020-09-14 Thread david whiting
Hi Fran, I import lots of bills and use File -> Import -> Import bills and Invoices (not transactions). See this help page for details: https://code.gnucash.org/docs/C/gnucash-guide/import-invoices.html For my purposes I found it useful to create a spreadsheet for entering details that has a struc

[GNC] Importing Liability Transactions to AP/Bills

2020-09-14 Thread Fran_3 via gnucash-user
Note: When I say "Bill" here I mean a Bill from a Vendor to us. I'm trying to import a CSV  file to AP and also have it create the corresponding Bill.I have 100+ of these to import else a lot of labor to do it by hand... So... to experiment I exported the Entities AP register as a CSV file.Then

Re: [GNC] Importing transactions in multi-currency accounting

2020-08-30 Thread andrepd via gnucash-user
I'm using the flatpak version, so I'm on the latest version (4.1). Build ID: Flathub 4.1-2, on Linux Mint 18.3. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To upd

Re: [GNC] Importing transactions in multi-currency accounting

2020-08-30 Thread David Carlson
If you have been using GnuCash for over a year and a half, you may not have the current release. There have been some changes to the import processes in that time. Please tell us your OS and GnuCash versions to get the best advice. On Sun, Aug 30, 2020 at 6:02 AM andrepd via gnucash-user < gnuca

Re: [GNC] Importing transactions in multi-currency accounting

2020-08-30 Thread andrepd via gnucash-user
Bump? -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-use

[GNC] Importing transactions in multi-currency accounting

2020-08-26 Thread andrepd via gnucash-user
hange rate at 1! For my aforementioned currency pairs this is an error of ~15% on every such transaction... Now I'm faced with the following two questions: * How to ensure that, when importing transactions, the (most recent) exchange rate I set in the price editor is used * How to edit my p

Re: [GNC] Importing Transactions from Bank

2020-07-20 Thread Stephen M. Butler
On 7/20/20 2:43 PM, Jon Griffith wrote: > Is Gnucash smart enough to recognize transactions that have already been > imported, or do we have to keep tight tabs on the import date range? > OFX keeps track.  CSV usually does but sometimes suppresses one that should be loaded. -- Stephen M Butler, P

Re: [GNC] Importing Transactions from Bank

2020-07-20 Thread David Carlson
That depends on the method used. OFX imports of well formed data do not import transactions more than once because each transaction has a unique identifier. QIF imports and CSV imports depend on 'training' to recognize duplicates because there is no unique identifier in each transaction. On Mon,

Re: [GNC] Importing Transactions from Bank

2020-07-20 Thread Jean Laroche
GC does not re-import transactions that have previously been imported. On 7/20/20 2:43 PM, Jon Griffith wrote: Is Gnucash smart enough to recognize transactions that have already been imported, or do we have to keep tight tabs on the import date range? _

Re: [GNC] Importing Transactions from Bank

2020-07-20 Thread Adrien Monteleone
Yes, read the manual. Regards, Adrien On 7/20/20 4:43 PM, Jon Griffith wrote: Is Gnucash smart enough to recognize transactions that have already been imported, or do we have to keep tight tabs on the import date range? ___ gnucash-user mailing lis

[GNC] Importing Transactions from Bank

2020-07-20 Thread Jon Griffith
Is Gnucash smart enough to recognize transactions that have already been imported, or do we have to keep tight tabs on the import date range? -- [image: photo] *Jon Griffith* REALTOR®, HomeSmart 480-463-4062 | j...@jongriffith.com http://realtor.jongriffith.com 10601 N. Hayden Road, Suite I-100

Re: [GNC] importing multiple CSVs to Gnucash

2020-06-06 Thread Geert Janssens
Op vrijdag 5 juni 2020 12:57:44 CEST schreef Gio Bacareza: > Thank you Adrien, David and @flywire for your very helpful responses. > > I actually created a script that would transform different file formats and > data structures and through a machine learning classifier autopopulate the > "Transfe

Re: [GNC] importing multiple CSVs to Gnucash

2020-06-05 Thread Chris Graves
I’m sorry Gnucash Users for this rant, but flywire, just chill, all you have done since you joined the mailing list is complain. If you don’t like the product, be productive in change or just choose another product and move along. The time, thought and effort placed by each of the developers is

Re: [GNC] importing multiple CSVs to Gnucash

2020-06-05 Thread flywire
I started a thread before the one I linked where I explained I had been through an equivalent process of adding transfer accounts. David explained it well in the thread I linked which is supported by https://wiki.gnucash.org/wiki/images/8/86/Gnucash_erd.png and the code. > I really want to avoid d

Re: [GNC] importing multiple CSVs to Gnucash

2020-06-05 Thread Gio Bacareza
memo fields are different. It will pay > to check all matches are actually valid. You can swap between viewing the > register(s) and the import matcher window. > The Help manual section on importing will help you with understanding the > significance of the background colours to the >

Re: [GNC] Importing XLM into GNUCash

2020-06-03 Thread John Ralls
> On Jun 2, 2020, at 6:42 PM, Daming Gao wrote: > > Dear community members, > > I am very new to GNUCash and here might be a dumb question to ask. > > We are using Logitude software to keep track of our invoices. They are > exportable XML format. Is there a way to import XML into GNUCash?

Re: [GNC] Importing XLM into GNUCash

2020-06-03 Thread David Carlson
GnuCash for years. I > don't know if there exists a current solution > > to importing xml data, but it would seem to me to be a simple matter to > write a translator that could convert xml into > > csv or some other format. Most languages (python, ruby, perl) have > support fo

Re: [GNC] Importing XLM into GNUCash

2020-06-03 Thread David Cousens
lution > to importing xml data, but it would seem to me to be a simple matter to write > a translator that could convert xml into > csv or some other format. Most languages (python, ruby, perl) have support > for reading xml. Writing csv is easy. > > Will > > On 2020 Jun 2, a

Re: [GNC] Importing XLM into GNUCash

2020-06-03 Thread w...@theprescotts.com
I am new to this mailing list although I have used GnuCash for years. I don't know if there exists a current solution to importing xml data, but it would seem to me to be a simple matter to write a translator that could convert xml into csv or some other format. Most languages (python,

[GNC] Importing XLM into GNUCash

2020-06-03 Thread Daming Gao
Dear community members, I am very new to GNUCash and here might be a dumb question to ask. We are using Logitude software to keep track of our invoices. They are exportable XML format. Is there a way to import XML into GNUCash? Since the import function does not support that (I only saw QIF/F

[GNC] importing multiple CSVs to Gnucash

2020-06-02 Thread flywire
This is a bad idea. You are thinking logically like other software but you don't understand it MUST go through account matching which is ALWAYS a manual process that doesn't really recognise the Transfer Account in your data (details in thread: https://lists.gnucash.org/pipermail/gnucash-user/2020-

Re: [GNC] importing multiple CSVs to Gnucash

2020-06-02 Thread David Cousens
ot; in older GnuCash versions) chceckbox checked if it is not a very close match ( usually if descriptions and memo fields are different. It will pay to check all matches are actually valid. You can swap between viewing the register(s) and the import matcher window. The Help manual section on import

Re: [GNC] importing multiple CSVs to Gnucash

2020-06-02 Thread Adrien Monteleone
manipulation might be in order though) Piecemeal importing is much better as you’re training the importer as you go. The workload reduces for subsequent imports. Regards, Adrien > On Jun 2, 2020 w23d154, at 4:57 AM, Gio Bacareza wrote: > > Hi GNUCash experts, > > I'm pla

[GNC] importing multiple CSVs to Gnucash

2020-06-02 Thread Gio Bacareza
Hi GNUCash experts, I'm planning to consolidate all my statements into 1 big CSV. This CSV would naturally have an account field and a transfer field. Since all transactions are there, there will be instances where there will be duplicates. For example, a statement from bank1 could have a transfe

Re: [GNC] Importing data from a CSV file

2020-05-10 Thread David Cousens
Geoff There is an import mapping step which maps an account name in the Transfer account field onto an account in the GnuCash CoA structure the first time the account name occurs. It will then be remembered for any subsequent imports. https://www.gnucash.org/docs/v3/C/gnucash-help/trans-import.ht

[GNC] Importing data from a CSV file

2020-05-08 Thread flywire
lol - Welcome to GnuCash. That's how it is designed. Discussed https://lists.gnucash.org/pipermail/gnucash-user/2020-April/090631.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https

Re: [GNC] Importing data from a CSV file

2020-05-08 Thread stephen.m.butler51
Original message From: Geoff Palmer Date: 5/7/20 18:13 (GMT-08:00) To: gnucash-user@gnucash.org Subject: [GNC] Importing data from a CSV file I've edited my .csv file to include a column of things like "Expenses:Bank Charges" and "Income:Other Income" --

[GNC] Importing data from a CSV file

2020-05-08 Thread Geoff Palmer
I've edited my .csv file to include a column of things like "Expenses:Bank Charges" and "Income:Other Income" -- exactly the way they're recorded in GnuCash's account tree, but there doesn't seem to be a way to import these. I can assign this column to "Account" at import, but when I continue,

Re: [GNC] Missing Bank Interest Transactions When Importing with QFX

2020-04-28 Thread Keith Fetterman
PM, Chris Good wrote: > > Message: 2 > Date: Mon, 27 Apr 2020 18:51:41 -0700 > From: Keith Fetterman > To: GnuCash users group > Subject: [GNC] Missing Bank Interest Transactions When Importing with > QFX > Message-ID: <5fc46e9e-f08a-4ba1-b13e-0dad30c1f...@gmail.c

Re: [GNC] Missing Bank Interest Transactions When Importing with QFX

2020-04-27 Thread Chris Good
Message: 2 Date: Mon, 27 Apr 2020 18:51:41 -0700 From: Keith Fetterman To: GnuCash users group Subject: [GNC] Missing Bank Interest Transactions When Importing with QFX Message-ID: <5fc46e9e-f08a-4ba1-b13e-0dad30c1f...@gmail.com> Content-Type: text/plain; charset=us-ascii

[GNC] Missing Bank Interest Transactions When Importing with QFX

2020-04-27 Thread Keith Fetterman
When I import the transactions from my bank using QFX, the small interest transactions are not appearing in the import screen? The amounts are usually less than a $1 dollar. Does anyone know why this is? Is there a threshold somewhere that might be filtering them out? I discovered it with Gn

Re: [GNC] importing transactions with splits

2020-04-05 Thread David Cousens
Jeremy, Generally when importing transactions to a specific account the second split for the transaction is generated during the import process in the Import Matching Window. This has an automatic process to try and identify transactions which may already exist in Gnucash so you don't c

Re: [GNC] importing transactions with splits

2020-04-05 Thread David Carlson
way I would love to see it On Sun, Apr 5, 2020 at 8:56 PM Jeremy Mordkoff wrote: > This has to be a solved problem, but I cannot find the solution. > > I am importing amazon transactions. Date and description are easy. But how > do I create a split transaction from the item cost, sh

[GNC] importing transactions with splits

2020-04-05 Thread Jeremy Mordkoff
This has to be a solved problem, but I cannot find the solution. I am importing amazon transactions. Date and description are easy. But how do I create a split transaction from the item cost, shipping, taxes and total columns? Can I do that as a CSV or do I have to convert it to some other format

Re: [GNC] How to export the security list for importing to other Gnucash files

2020-03-31 Thread David Cousens
AFAIK there is currently no way to export the security database from GnuCash. The data is contained in the main GnuCash XML datafile between tags as follows: ASX COL Coles Group 1 . Presumably the main data file can be edited with a general text editor and the relevant entries copi

[GNC] How to export the security list for importing to other Gnucash files

2020-03-31 Thread davygc
New user here. After I define new securities using \Tools\Security Editor and enter all the necessary information for online quote, is there a way to backup all these entries to a file so that I can reuse these securities for another set of Gnucash Files. Thanks. -- Sent from: http://gnucash.14

Re: [GNC] Importing gnu files

2020-03-21 Thread David H
*To:* Jackie Bowden > *Cc:* gnucash-user@gnucash.org > *Subject:* Re: [GNC] Importing gnu files > > Have you tried File >> Open. Check the wiki there's other files apart > from your data file that you might want to copy over. > > Cheers David H. > > &g

Re: [GNC] Importing gnu files

2020-03-21 Thread David H
7;s everything ... I'll look at the > wiki. > > Thanks again, > Jackie > > -- > *From:* David H > *Sent:* 21 March 2020 11:00 > *To:* Jackie Bowden > *Cc:* gnucash-user@gnucash.org > *Subject:* Re: [GNC] Importing gnu files >

Re: [GNC] Importing gnu files

2020-03-21 Thread Jackie Bowden
That's great - really helpful - thank you. From: David H Sent: 21 March 2020 11:06 To: Jackie Bowden Cc: gnucash-user@gnucash.org Subject: Re: [GNC] Importing gnu files A bit more info from the wiki you might want to read... Q: I just got a new computer.

Re: [GNC] Importing gnu files

2020-03-21 Thread Jackie Bowden
ser@gnucash.org Subject: Re: [GNC] Importing gnu files Have you tried File >> Open. Check the wiki there's other files apart from your data file that you might want to copy over. Cheers David H. On Sat, 21 Mar 2020 at 19:55, Jackie Bowden mailto:jackie.butterc...@outlook.com&g

Re: [GNC] Importing gnu files

2020-03-21 Thread David H
A bit more info from the wiki you might want to read... *Q:* I just got a new computer. What should I copy over from my old one?*A*: You need to copy the same files that you'd backup, so see Backup . - If your new computer runs a *different operating syste

Re: [GNC] Importing gnu files

2020-03-21 Thread David H
Have you tried File >> Open. Check the wiki there's other files apart from your data file that you might want to copy over. Cheers David H. On Sat, 21 Mar 2020 at 19:55, Jackie Bowden wrote: > Hi, > > I'm trying to transfer my gnucash accounts from my Windows 7 computer to > my new Windows 10

[GNC] Importing gnu files

2020-03-21 Thread Jackie Bowden
Hi, I'm trying to transfer my gnucash accounts from my Windows 7 computer to my new Windows 10 computer. I have copied all of the files from the old computer to the new computer and have installed gnucash on the new computer but can't see how to import the files from the old computer into gnuca

Re: [GNC] Importing transactions problem

2020-03-17 Thread John Ralls
some reason, >>> everything is being autoassigned to my checking account instead of an >>> expense or imbalance. >>> >>> Regards, >>> Joe Vernice >>> >>> On 3/17/2020 12:40 PM, John Ralls wrote: >>>>> On Mar 17, 2020, a

Re: [GNC] Importing transactions problem

2020-03-17 Thread Joseph Vernice
reason, everything is being autoassigned to my checking account instead of an expense or imbalance. Regards, Joe Vernice On 3/17/2020 12:40 PM, John Ralls wrote: On Mar 17, 2020, at 8:44 AM, Joseph Vernice wrote: There seems to be a problem with importing transactions. I am importing a QFX file

Re: [GNC] Importing transactions problem

2020-03-17 Thread John Ralls
Joe Vernice > > On 3/17/2020 12:40 PM, John Ralls wrote: >> >>> On Mar 17, 2020, at 8:44 AM, Joseph Vernice wrote: >>> >>> There seems to be a problem with importing transactions. I am importing a >>> QFX file from my credit card company and all

Re: [GNC] Importing transactions problem

2020-03-17 Thread Joseph Vernice
wrote: There seems to be a problem with importing transactions. I am importing a QFX file from my credit card company and all seems fine. When I close and re-open the gnucash file, the transactions offsetting account all change to my checking account. Is this s bug? How can I fix it? How can

Re: [GNC] Importing transactions problem

2020-03-17 Thread John Ralls
> On Mar 17, 2020, at 8:44 AM, Joseph Vernice wrote: > > There seems to be a problem with importing transactions. I am importing a > QFX file from my credit card company and all seems fine. When I close and > re-open the gnucash file, the transactions offsetting accoun

[GNC] Importing transactions problem

2020-03-17 Thread Joseph Vernice
There seems to be a problem with importing transactions.  I am importing a QFX file from my credit card company and all seems fine.  When I close and re-open the gnucash file, the transactions offsetting account all change to my checking account.  Is this s bug?  How can I fix it?  How can it

Re: [GNC] importing csv multisplit multicurrency problems

2020-03-11 Thread Gio Bacareza
may be wrong, is not the price database but the importing > multicurrency transactions. > > I even made it simpler. Pre-import, I calculated and populated the > currency conversions using just 1 exchange rate. I thought that by doing > this I avoid having to maintain a price database tha

Re: [GNC] importing csv multisplit multicurrency problems

2020-03-10 Thread pobox . deva
> Hi Pobox.Deva, > > Thank you for the suggestion. I'll try that out. However my problem, I think > though I may be wrong, is not the price database but the importing > multicurrency transactions. > > I even made it simpler. Pre-import, I calculated and populated the curr

Re: [GNC] importing csv multisplit multicurrency problems

2020-03-10 Thread Gio Bacareza
Hi Pobox.Deva, Thank you for the suggestion. I'll try that out. However my problem, I think though I may be wrong, is not the price database but the importing multicurrency transactions. I even made it simpler. Pre-import, I calculated and populated the currency conversions using just 1 exc

Re: [GNC] importing csv multisplit multicurrency problems

2020-03-06 Thread Adrien Monteleone
Thanks, I had seen that link, but hadn’t looked it over carefully enough. I realize now you had 2 transactions with 2 splits each. (I first thought it was one with 4) I tried a similar test import without a price in the db. Indeed it imported as imbalanced, and would not let me fix it no matter

Re: [GNC] importing csv multisplit multicurrency problems

2020-03-06 Thread Geert Janssens
think it's > > currently possible to do such imports. Sorry. > > > > Geert > > > > Op donderdag 5 maart 2020 14:14:56 CET schreef Gio Bacareza: > > > I'm encountering problems with importing transactions in csv when > > > > accounts >

Re: [GNC] importing csv multisplit multicurrency problems

2020-03-05 Thread Gio Bacareza
Adrien, results here https://docs.google.com/document/d/1d-j6195r3-hHyKopCCwFmGDu94f_8m5bj-fVPb4IJwk/edit?usp=sharing On Fri, Mar 6, 2020 at 3:05 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > I might have misunderstood your earlier reply, but what if you leave off > the Trading

Re: [GNC] importing csv multisplit multicurrency problems

2020-03-05 Thread Adrien Monteleone
I might have misunderstood your earlier reply, but what if you leave off the Trading accounts from the import entirely and don’t have a price defined in the database? (that is, only 2 splits, not 4) What does GnuCash do then? I should think it should add the Trading account splits as exact base

Re: [GNC] importing csv multisplit multicurrency problems

2020-03-05 Thread pobox . deva
. > On 06-Mar-2020, at 9:53 AM, gnucash-user-requ...@gnucash.org wrote: > > Date: Fri, 6 Mar 2020 12:23:17 +0800 > From: Gio Bacareza mailto:gbacar...@gmail.com>> > To: GnuCash Users mailto:gnucash-user@gnucash.org>> > Subject: Re: [GNC] importing csv multisplit multi

Re: [GNC] importing csv multisplit multicurrency problems

2020-03-05 Thread Gio Bacareza
; >> >> > On Mar 5, 2020 w10d65, at 7:14 AM, Gio Bacareza >> wrote: >> > >> > I'm encountering problems with importing transactions in csv when >> accounts >> > have different currencies. >> > >> > I've been reading

Re: [GNC] importing csv multisplit multicurrency problems

2020-03-05 Thread Gio Bacareza
ugs with multi-currency csv imports. I don't think it's > currently possible to do such imports. Sorry. > > Geert > > Op donderdag 5 maart 2020 14:14:56 CET schreef Gio Bacareza: > > I'm encountering problems with importing transactions in csv when > accounts &

Re: [GNC] importing csv multisplit multicurrency problems

2020-03-05 Thread Gio Bacareza
. i'll do some test with a blank price database and let everyone know. On Fri, Mar 6, 2020 at 12:55 AM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > > > > On Mar 5, 2020 w10d65, at 7:14 AM, Gio Bacareza > wrote: > > > > I'm encountering

Re: [GNC] importing csv multisplit multicurrency problems

2020-03-05 Thread Geert Janssens
There are several bugs with multi-currency csv imports. I don't think it's currently possible to do such imports. Sorry. Geert Op donderdag 5 maart 2020 14:14:56 CET schreef Gio Bacareza: > I'm encountering problems with importing transactions in csv when accounts > have

Re: [GNC] importing csv multisplit multicurrency problems

2020-03-05 Thread Adrien Monteleone
> On Mar 5, 2020 w10d65, at 7:14 AM, Gio Bacareza wrote: > > I'm encountering problems with importing transactions in csv when accounts > have different currencies. > > I've been reading the debates. So this is not about definitions of > multi-split or termin

[GNC] importing csv multisplit multicurrency problems

2020-03-05 Thread Gio Bacareza
I'm encountering problems with importing transactions in csv when accounts have different currencies. I've been reading the debates. So this is not about definitions of multi-split or terminology. I did a test with a sample csv with the following contents: Date,Description,Accou

Re: [GNC] Problems importing American Express QFX files into GNUCash

2020-03-03 Thread Greg Feneis
3, 2020, 15:10 Jonathan Bentz wrote: > Does this also apply to offline importing? > > I'm just downloading the transactions locally then importing them, not > connected directly via the online banking tools.Thanks. > > On Tue, Mar 3, 2020 at 4:47 PM David Reiser wrote:

Re: [GNC] Problems importing American Express QFX files into GNUCash

2020-03-03 Thread Jonathan Bentz
Does this also apply to offline importing? I'm just downloading the transactions locally then importing them, not connected directly via the online banking tools.Thanks. On Tue, Mar 3, 2020 at 4:47 PM David Reiser wrote: > > > On Mar 3, 2020, at 4:14 PM, Jonathan Bentz wrot

Re: [GNC] Problems importing American Express QFX files into GNUCash

2020-03-03 Thread David Reiser via gnucash-user
> On Mar 3, 2020, at 4:14 PM, Jonathan Bentz wrote: > > I'm running GNUCash 3.8 and was manually importing my credit card > statements yesterday via QFX and when I tried to import a QFX file from > AMEX, it was blank. I have successfully imported QFX files from AMEX for a

[GNC] Problems importing American Express QFX files into GNUCash

2020-03-03 Thread Jonathan Bentz
I'm running GNUCash 3.8 and was manually importing my credit card statements yesterday via QFX and when I tried to import a QFX file from AMEX, it was blank. I have successfully imported QFX files from AMEX for a few years now and as recently as December of 2019 I have never encountered thi

Re: [GNC] Importing Vendor Bills: Field Definitions Questions

2020-02-17 Thread Rob Laan
Hi, See my comments below, Regards, Rob > On 15 Feb 2020, at 19:53, Fran_3 via gnucash-user > wrote: > > Referring to the field definitions in > 18.1. Importing Bills and Invoices > I tried to line those up with the three dialog boxes that come up as you > create and p

Re: [GNC] importing account info

2020-02-15 Thread David Cousens
s but have been ignored. I have not yet noticed any problems in 3.8 importing the downloaded files from the bank but if the change back to 3.7 fixed yours then that is great. David - David Cousens -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819

Re: [GNC] importing account info

2020-02-15 Thread Alan Schold
is stored in the XML data file so any work done on the copy will not automatically transfer back to your main datafile. If the datafile contains a lot of incorrect matching information as it is a Bayesian system continuing to fix the assigned accounts and completing the import will eventually fix things as i

[GNC] Importing Vendor Bills: Field Definitions Questions

2020-02-15 Thread Fran_3 via gnucash-user
Referring to the field definitions in 18.1. Importing Bills and Invoices I tried to line those up with the three dialog boxes that come up as you create and post a new bill. New Bill DialogEdit Bill DialogPost Bill Dialog (aka Question) I think I have most of them properly associated but need

Re: [GNC] importing account info

2020-02-09 Thread David Cousens
ngs as it will change the weightings on tokens in the files. Maybe importing in smaller batches, fixing each batch up as you go may be the safest way to approach this. I would like to see a feature which would allow the existing transactions in selected accounts to be used in generating the matc

Re: [GNC] importing account info

2020-02-09 Thread Adrien Monteleone
Mailman probably stripped it because it was HTML. The PNG came through fine though. Regards, Adrien > On Feb 9, 2020 w7d40, at 10:59 AM, Alan Schold wrote: > > Not sure why you couldn't see my screenshot. My program showed the attachment > to be 70.8 KB. Anyway, I saved it as a .png; maybe th

Re: [GNC] importing account info

2020-02-09 Thread Alan Schold
in the import matcher and not later in the account register after importing as only assignments made during the import process are used in defining the import matcher database of tokenized information from the description field. That information is only stored when you complete the import process af

Re: [GNC] Does date order matter for Importing Checking Transactions?

2020-02-07 Thread Fran_3 via gnucash-user
Thank you David! Now I know how to assign multiple checking transactions at once. Great tip. And "Roger That" on debit/credit description fields. Very long & often very confusing. Thanks again. On Friday, February 7, 2020, 04:49:37 PM EST, David Cousens wrote: Fran "That brings up an

Re: [GNC] Does date order matter for Importing Checking Transactions?

2020-02-07 Thread David Cousens
Fran "That brings up another question... is there anyway in GC to assign multiple checking transactions at once to a single expense account?" Yes there is. In the import matcher window you can multiply select the transactions you want to assign to a given transfer account (click on them while hol

Re: [GNC] importing account info

2020-02-07 Thread Alan Schold
n what caused this. I think there may have been some changes to the parsing of tokens and maybe storage, but I am not sure of this. If the import matcher is incorrectly assigning an account, it is important that it is corrected in the import matcher and not later in the account register after impo

Re: [GNC] Does date order matter for Importing Checking Transactions?

2020-02-07 Thread Fran_3 via gnucash-user
Thank you David. Good info. FYI, I'm importing checking transactions which I downloaded a csv file from the bank, imported into Google Sheets I re-formatted the columns to have the following... Date, Num, Description, Deposit, Withdrawal I then exported this from Google Sheets to a csv fil

Re: [GNC] Does date order matter for Importing Checking Transactions?

2020-02-07 Thread David Cousens
Fran, The date shouldn't matter but having them date ordered can help when sorting out any problems (easier to locate in the data file). David Carlson's reason for suggesting importing in small batches initially are twofold. 1. The importer has a Bayesian matcher which will automatic

Re: [GNC] Does date order matter for Importing Checking Transactions?

2020-02-07 Thread David Carlson
ser@gnucash.org> wrote: > Does date order matter when importing checking transactions? > I'm guessing they are ordered by date in the Check Register view and not > by the order in which they were entered or imported in the system... right? > I'm asking because this next account I

[GNC] Does date order matter for Importing Checking Transactions?

2020-02-07 Thread Fran_3 via gnucash-user
Does date order matter when importing checking transactions? I'm guessing they are ordered by date in the Check Register view and not by the order in which they were entered or imported in the system... right? I'm asking because this next account I'll be working on has almost 2,00

Re: [GNC] Importing Checking Transactions: Expense Acct Assignment Question.

2020-02-05 Thread Fran_3 via gnucash-user
Derek, your answer confirmed Adrian's post and both gave me the confident to experiment today. I'll pull the trigger on the big import tomorrow and report back. On Wednesday, February 5, 2020, 09:18:35 AM EST, Derek Atkins wrote: Hi, Fran_3 via gnucash-user writes: > Will assigning

Re: [GNC] Importing Checking Transactions: Expense Acct Assignment Question.

2020-02-05 Thread Fran_3 via gnucash-user
benefit of training the importer) You might want to start with just importing basic expenses and get some of those payees trained and make sure the importer matches subsequent imports correctly. Then move on to the business payments that need to be assigned. All of them should go to AP and each

<    1   2   3   4   5   6   7   >