[GNC] Importing Transactions from CSV

My credit card company recently stopped publishing their transactions in OFX format.  They now only offer the transactions in CSV format. The issue I have is they list both deposits and withdrawals in the same "Amount" column.  They signify deposits as negative amounts, and withdrawals as

Re: [GNC] importing simple investment account

Sorry Ken. > On Nov 20, 2022, at 7:20 PM, Ken Farley wrote: > > Um, I wasn't responding to your question, but rather to the one referenced > in the Subject. > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription

Re: [GNC] importing simple investment account

Um, I wasn't responding to your question, but rather to the one referenced in the Subject. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe:

Re: [GNC] importing simple investment account

I’ll try downloading 4.12 and see if goes better. Thanks > On Nov 20, 2022, at 4:59 PM, Sally Abrams wrote: > > My current problem is I can’t even find the program. I haven’t even gotten > to transferring files because the program isn’t being found. The set up > program says it’s there.

Re: [GNC] importing simple investment account

] importing simple investment account i'll try downloading 4.12 and see if it goes better. thanks -Original Message- From: Sally Abrams via gnucash-user To: Ken Farley Cc: gnucash-user@gnucash.org Sent: Sun, Nov 20, 2022 4:58 pm Subject: Re: [GNC] importing simple investment account My current

Re: [GNC] importing simple investment account

i'll try downloading 4.12 and see if it goes better. thanks -Original Message- From: Sally Abrams via gnucash-user To: Ken Farley Cc: gnucash-user@gnucash.org Sent: Sun, Nov 20, 2022 4:58 pm Subject: Re: [GNC] importing simple investment account My current problem is I can’t even find

Re: [GNC] importing simple investment account

My current problem is I can’t even find the program. I haven’t even gotten to transferring files because the program isn’t being found. The set up program says it’s there. But a search of my computer only comes up with the setup link. No icon. Not on start up menu. Not on list of programs.

Re: [GNC] importing simple investment account

I don't know how complicated the data you are attempting to transfer is. I can tell you that I recently had access to an old computer with Quicken 2011. I used this to write out 10 years of .QIF files, one file for each year, data for that year only. I had it include everything that it would

Re: [GNC] importing simple investment account

I can't speak to your main question, but significant changes were made to the importer(s) in the 4.x series. If you can run the latest, 4.12, that would be a better start. Regards, Adrien On 11/19/22 8:43 PM, ar wrote: Hi, I am downloading my data in the form of .csv file and I have a

[GNC] importing simple investment account

Hi, I am downloading my data in the form of .csv file and I have a simple program to generate an.qif file with proper categories and then import .qif into gnucash. I am adding a program to deal with investment accounts. The problem is that GnuCash investment account consists of a multitude of

Re: [GNC] Importing stock splits via csv

Hi Geoff After running a few tests based on your working example, I can confirm that: 1. Your example format works for me too - when manually formatting a CSV file according to your example and importing it, GnuCash correctly recognizes the transaction as a stock split. 2. After fiddling

Re: [GNC] Importing stock splits via csv

Thank you Geoff, this helps. I will try your example in my local file, play with the input a bit to see what triggers the different behaviour, and report back. \ Original Message On Oct 27, 2022, 13:17, Geoff < cleanoutmys...@gmail.com> wrote: > > Hi Marcus This example

Re: [GNC] Importing stock splits via csv

Thank you Geoff, a working example helps. I will try it and ideally if I can fiddle with the information I might be able to find out what causes the split to "take". Either way I will report back here when done. Thanks again, Marcus Pemer PGP: CC9E1BAA \ Original Message

[GNC] Importing stock splits via csv

Hello everyone! I have recently run into a conundrum that I hope someone would be able to help me with. I am importing transactions from a CSV file into a brokerage account. The CSV data containing the split looks like this:   date,transactionid,description,account,credit,debit,action,

Re: [GNC] Importing transaction issue - “Match payees/memos to GnuCash accounts” are missing

-user@gnucash.org Subject: Re: [GNC] Importing transaction issue - “Match payees/memos to GnuCash accounts” are missing Simon, Try the wiki entry to config file locations @ https://wiki.gnucash.org/wiki/Configuration_Locations and Backup Files @ https://wiki.gnucash.org/wiki/Backup - should

Re: [GNC] Importing transaction issue - “Match payees/memos to GnuCash accounts” are missing

Simon, Try the wiki entry to config file locations @ https://wiki.gnucash.org/wiki/Configuration_Locations and Backup Files @ https://wiki.gnucash.org/wiki/Backup - should hopefully point you in the right direction.. Cheers David H. On Sun, 4 Sept 2022 at 14:30, Simon Harper wrote: > Hi

Re: [GNC] importing csv and negative numbers (gnucash-user Digest, Vol 231, Issue

> > > Sent: Saturday, June 11, 2022 12:44 PM > > To: gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> > > > <mailto:gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> > <

Re: [GNC] importing csv and negative numbers

The difficulty is that the sign convention in a CSV file is normally determined by the originating bank and there is no guarantee that it is what GnuCash thinks it should be. Some banks will use a signed amount column to represent debits and credits, others will provide a debit column and a

Re: [GNC] importing csv and negative numbers

On 2022-06-12 22:00, Kevin T via gnucash-user wrote: > It seems that when importing CSV files, to a CC account, if the > 'credit' column, which when imported is called the 'deposit' field, > has a negative value in it, it is imported as a 'debit' transaction. > I have to refer to the statement,

[GNC] importing csv and negative numbers

It seems that when importing CSV files, to a CC account, if the 'credit' column, which when imported is called the 'deposit' field, has a negative value in it, it is imported as a 'debit' transaction.  I have to refer to the statement, to find which of these transactions are supposed to be

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

I fear Windows 7 is too old and also no longer mainained by MS. Am 09.05.22 um 20:01 schrieb viking...@san.rr.com: > I am using Windows 7 Is there such a setting in WIN7? I haven’t been able > to find it. > ___ gnucash-user mailing list

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

@Frank, I am using Windows 7 Is there such a setting in WIN7? I haven’t been able to find it. -Original Message- From: Frank H. Ellenberger [mailto:frank.h.ellenber...@gmail.com] Sent: 09 May, 2022 08:15 To: viking...@san.rr.com Cc: gnucash-user@gnucash.org Subject: Re: [GNC

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

Another "workaround" is described in https://bugs.gnucash.org/show_bug.cgi?id=782850#c11 That "fixing of Windows" has only to be done once, not for each file. Perhaps I should have sent you directly to that bug instead of ssending a link that again links there. Regards Frank Am 09.05.22 um

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

al Message- From: gnucash-user [mailto:gnucash-user-bounces+viking2ev=san.rr@gnucash.org] On Behalf Of viking...@san.rr.com Sent: 08 May, 2022 18:49 To: gnucash-user@gnucash.org Subject: Re: [GNC] Importing Accounts with non-English Characters I downloaded v4.10, but the bug remains. It i

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

to save my CSV file using Excel and windows 1252 encoding. -Original Message- From: gnucash-user [mailto:gnucash-user-bounces+viking2ev=san.rr@gnucash.org] On Behalf Of viking Sent: 16 March, 2021 01:32 To: gnucash-user@gnucash.org Subject: Re: [GNC] Importing Accounts with non-English

Re: [GNC] importing prices from csv

> On Mar 16, 2022, at 5:08 PM, Art Chimes wrote: > > I well remember agonizing over this when I first set up price imports. > There's a bit of a learning curve here. > > "Namespace" can be FUND (if it's a mutual fund), NYSE or NASDAQ or > AMEX if it's a stock on the New York Stock Exchange,

Re: [GNC] importing prices from csv

d locally for import. Original Message From: George Riner Sent: Wed Mar 16 19:47:26 EDT 2022 To: Gnucash Users Subject: Re: [GNC] importing prices from csv Thanks. One question... I don't know what is "the entry from Gnucash" ? err... what entry from Gnucash? :George On 3/16/

Re: [GNC] importing prices from csv

I track the prices of Mutual Funds, Stocks and Precious Metals and import them all with a single CSV file. In all three cases I do not use any of the pre-defined GNUCash Namespace names. I use all user defined name space. On 3/16/22 8:08 PM, Art Chimes wrote: I well remember agonizing

Re: [GNC] importing prices from csv

I well remember agonizing over this when I first set up price imports. There's a bit of a learning curve here. "Namespace" can be FUND (if it's a mutual fund), NYSE or NASDAQ or AMEX if it's a stock on the New York Stock Exchange, NASDAQ, or the American Stock Exchange, respectively. Most

Re: [GNC] importing prices from csv

om Gnucash. *From:* George Riner *Sent:* Wed Mar 16 11:36:14 EDT 2022 *To:* gnucash-user@gnucash.org *Subject:* [GNC] importing prices from csv My specs: Platform: Windows 10 (64-bit) build 19044.1586 (32Gb RAM) Gnucash: 4.9+(2021-12-18)

Re: [GNC] importing prices from csv

I am able to import prices from csv with a four column source: Ticker,  Namespace, Price,  Date Namespace is the entry from Gnucash. Original Message From: George Riner Sent: Wed Mar 16 11:36:14 EDT 2022 To: gnucash-user@gnucash.org Subject: [GNC] importing prices from csv

[GNC] importing prices from csv

My specs: Platform: Windows 10 (64-bit) build 19044.1586 (32Gb RAM) Gnucash: 4.9+(2021-12-18) Enaaglish Finance Quote: 1.51a I live and work in California, USA. I've been trying to use the "Import Prices from a CSV file..." tool. I've got a CSV with symbols ('ticker symbols'?) and prices, and

Re: [GNC] Importing an OFX file

It is possible that at least part of the note was actually a part of the imported transaction text. To be sure, use a text editor to examine the OFX file. I have seen similar notes when the financial institution's software does not seem to provide some details that GnuCash wants to see. I have

Re: [GNC] Importing an OFX file

Gyle, If anything other than the A column is checked GnuCash is not going to import the transaction. The U+C column checked indicates that it has been matched to an existing transaction and thta existing transaction will be updated with information from the transaction in the OFX file. If the R

[GNC] Importing an OFX file

When I import an OFX file it lists the transactions in red buut when I check the U/C box it shows the matching transaction in GNUCash. However, it puts this message in the notes field: OFX ext. info: |Trans type:Generic debit|Standard Industrial Code:5310|This corrects transaction

[GNC] Importing Account Error

Ciao, Has anyone found a fix for  error: "Too Many Root Sets" exporting an account from 1 Gnucash file then importing into a different Gnucash file? Thank you. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription

Re: [GNC] Importing Multiple Accounts in a single OFX/QFX file

While the files that I import from my bank have content that I want to retain in both sides of the duplicated transactions other use cases probably differ. I expect that this solution would work for some users and I would prefer to keep the multiple source accounts separated during the import

[GNC] Importing Multiple Accounts in a single OFX/QFX file

Hi, Re https://bugs.gnucash.org/show_bug.cgi?id=105334#c13 import multiple account OFX files with transfers between the accounts, duplicate transactions are generated The problem is that when you import OFX transactions for 2 bank accounts from the same file, if there is a

[GNC] Importing accounting data from "Accountz" software.

I'm trying to import accounting data from the Accountz software. The company was UK based and has recently stopped trading. I can list the accounting data (going back several years) as a .csv file. I can also list the Assests, Liabilities, Expenditure and Income in .csv file format. Has

Re: [GNC] importing transactions overwrites notes

Welcome to the GnuCash user list. You can limit what information GnuCash overwrites by choosing the Update option while in the matching phase of a OFX or QIF import. For each transaction note what GnuCash will overwrite, which may be the notes that you want to keep, the amount or the date. If

[GNC] importing transactions overwrites notes

Good morning: I am a new gnucash user and I find it quite useful. When I enter a transaction I often put data in the "notes" field. However, when that transaction is imported via a Quicken file it overwrites the note entry I made. Can I modify this behavior? Thanks -- Bob Crochelt MD, PhD, FACS

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

Yes, well aware of that and I have it on and use it occasionally. I also use key combos as you noted. I don't always remember which option-combos produce which accent. So I usually use something else: MacOS has a feature where you can hold down a key that has accented options and you get a

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

Resent to the list because of a server bounce. Sorry for the dupe, Adrien. There's a checkbox in System Preferences>Keyboard>Input Sources to show input menu in the menu bar. Turn that on: It includes two items, Show Emoji & Symbols, that actually gives access to all code points, and Show

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

Not sure if this is related with the overload, but I noticed that when triggering the accented character selector/pop-up in MacOS, I can't type the number for the character I want like in other apps. I still can use the arrow keys though. Otherwise, I can get most characters by remembering the

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

On 17/3/21 13:39, w...@theprescotts.com wrote: On MacOS, you can access all those special characters from the Keyboard menu. One of the tabs in the Keyboard System Preference has an option to 'Show Input menu in the menu bar'. Then from any app you can open up an 'Emoji and Symbol Viewer'

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

Looks like option is getting used as part of shortcuts, intercepting its use for extending the keyboard. Option-u-u opens that weird entry box and option-o operates the OK key. Option-e still works to create an accent-grave so it's just modifier key overloads. In the transfer dialog option-u-u

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

On MacOS, you can access all those special characters from the Keyboard menu. One of the tabs in the Keyboard System Preference has an option to 'Show Input menu in the menu bar'. Then from any app you can open up an 'Emoji and Symbol Viewer' that will allow you to insert any symbol or

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

On 17/3/21 11:47, prl wrote: On 17/3/21 05:20, viking wrote: Liz wrote On Tue, 16 Mar 2021 03:31:34 -0500 (CDT) viking viking2ev@.rr wrote: 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

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

On 17/3/21 05:20, viking wrote: Liz wrote On Tue, 16 Mar 2021 03:31:34 -0500 (CDT) viking viking2ev@.rr wrote: 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

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

Liz wrote > On Tue, 16 Mar 2021 03:31:34 -0500 (CDT) > viking > viking2ev@.rr > wrote: > >> 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

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

On Tue, 16 Mar 2021 03:31:34 -0500 (CDT) viking wrote: > 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, the letter "å" can

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

Frank H. Ellenberger-3 wrote > 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 such

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

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 such option when importing *Accounts*.

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

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.phtml?rev=4=C=help >

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

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=C=help

[GNC] Importing Accounts with non-English Characters

When I import accounts in a CSV file that contains non-English characters they are "corrupted". For example, Startvärde => Startvärde As a test, I exported accounts (with non-English characters) to a CSV file. The exported accounts look OK in the CSV file. I then imported the file that I just

Re: [GNC] Importing qif from Moneydance

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

Re: [GNC] Importing qif from Moneydance

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

Re: [GNC] Importing qif from Moneydance

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

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

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

[GNC] Importing qif from Moneydance

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

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

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

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

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

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

[GNC] Importing Liability Transactions to AP/Bills

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

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

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

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 <

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

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:

[GNC] Importing transactions in multi-currency accounting

I have current accounts in EUR, USD, and GBP. The way I track my expenses currently is: if the expense is exclusively in one of the currencies (e.g. UK bills in GBP), then the expense account is in GBP. Otherwise, it's in the "home" currency of EUR. This requires using exchange rates when, for

Re: [GNC] Importing Transactions from Bank

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,

Re: [GNC] Importing Transactions from Bank

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

Re: [GNC] Importing Transactions from Bank

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

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

[GNC] Importing Transactions from Bank

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

Re: [GNC] importing multiple CSVs to Gnucash

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 >

Re: [GNC] importing multiple CSVs to Gnucash

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

Re: [GNC] importing multiple CSVs to Gnucash

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

Re: [GNC] importing multiple CSVs to Gnucash

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 "Transfer Account '' depending on the description. My script would scour

Re: [GNC] Importing XLM into GNUCash

> 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

Technically, XML files either follow a companion style sheet or follow an implicit style predetermined specifically for a given application. GnuCash applicable files and OFX files are both of the second type. There is no expectation that a XML type file not created explicitly for either of those

Re: [GNC] Importing XLM into GNUCash

Will In a sense GnuCash does import xml as its main datafile is stored as an xml file if you are not using the database backends. XML is possibly a bit too wordy for general use as you have two tags in addition to the data for each piece of data. you cannot use random tags - the program has to

Re: [GNC] Importing XLM into GNUCash

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, ruby,

[GNC] Importing XLM into GNUCash

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

[GNC] importing multiple CSVs to Gnucash

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:

Re: [GNC] importing multiple CSVs to Gnucash

Gio, The Gnucash import matching procedure searches for duplicate transactions in a time window around the date of the imported recorded set at +-42 days. A match score is then calculated based on the differenes in dates and amounts and the matching of tokenized data. It is generally very good

Re: [GNC] importing multiple CSVs to Gnucash

The Tutorial Guide I believe goes over the situation of both sides of a transaction being listed separately in the file. Others can give better advice than I (and some may be using this exact workflow) but I believe that yes, GnuCash can see that the transactions are the same. (some minor csv

[GNC] importing multiple CSVs to Gnucash

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

Re: [GNC] Importing data from a CSV file

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.

[GNC] Importing data from a CSV file

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:

Re: [GNC] Importing data from a CSV file

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" -- exac

[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" -- 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

Re: [GNC] importing transactions with splits

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 create

Re: [GNC] importing transactions with splits

What I have been able to download from Amazon looks more like an invoice than a transaction. Same with purchases at Kohl's. I have so few transactions that I just open the page with a spreadsheet program then cut and paste the fields I want into a transaction. If someone has a better way I

[GNC] importing transactions with splits

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

Re: [GNC] Importing gnu files

> *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. > > > On Sat, 21 Mar 2020 at

Re: [GNC] Importing gnu files

l 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 > > Have you tried File >&

Re: [GNC] Importing gnu files

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. What

Re: [GNC] Importing gnu files

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>> wrote: Hi,

Re: [GNC] Importing gnu files

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

<    1   2   3   >