Re: [GNC] Importing a CSV with transactions in another currency

[boldstripe]

Thanks to Yoman and David. This seems to be a difficult problem to fix.

Just to clarify the need for this: if you trade and/or live in two different
countries, you need to be able to report worldwide income/expenses in both
currencies. 

Ideally, to do this, the user could:
- import CSV in either currency and
- report in either currency

With these it would be possible to keep a single set of dual-currency books.



--
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-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Importing a CSV with transactions in another currency

[David Cousens]

There is really no way GnuCash can do that at least at the moment. The
easiest way to achieve it would be to use the multiline multisplit import
mode and prior to import into GnuCash import the data into a spreadsheet and
add the additional information in a Rate/Price column for each split.  

If you export a typical transaction of the currency conversion type you want
to import from GnuCash and don't choose the Simple Layout option you will
get a CSV file which will give you the format you need for import. You can
use the copy command to change the rate/price for the splits to the expense
accounts to the desired conversion rate.  One problem is that GnuCash
exports  currency conversion rates in a "3+ 144456/238798" format and my
experience is that it does not parse this correctly on import in some
circumstances.  I haven't confirmed yet that if you convert the rational
rate to a decimal number that it always imports correctly but I suspect it
might.

This is probably easier than duplicating the expense accounts.

David Cousens



-
David Cousens
--
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-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Importing a CSV with transactions in another currency

[Frederico Zica]

Hello!

I have been using gnucash with more than one currency, but recently I got
puzzled about how to proceed with a CSV import.

In that CSV there are USD transactions while my main Gnucash currency is
not USD, and the majority of my accounts don't have USD as their currency.

I'm importing those transactions to a 'Bank' type account that is USD, but
the majority of the counterpart accounts for these transactions are
expenses accounts. These expense accounts are not in USD, so Gnucash
imports them, without issuing any warning, and assumes a 1:1 exchange rate.
Here comes the problem: I could go through all of them and set an exchange
rate, but that would consume a lot of time.

The ideal solution for me would be Gnucash asking me what would be the
conversion rate that I expected for ALL the imported transactions only one
time, or simply assuming the current conversion rate.

I see right now a couple solutions to this:

   1. Duplicating all the expenses account I have in my main currency as
   USD accounts - that would work but would unnecessarily create a lot of
   additional accounts
   2. Setting the exchange rate each time I do it - would be really
   time-consuming


Are there better ways of doing this?


Thanks!
--
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] GC Importing GC Export Format - too many credits

[David Cousens]

That's good . I will add the description of the issues I observed to one or
the other of your bug reports and cross reference them. I suspect the issues
are all related. AFAIK the CSV importer was rewritten for the late v2.7 and
early 3.x versions and possible only received testing for the
straightforward import cases for bank account and credit card  statements
and not completely on all the edge cases on the new features. I had arranged
with Geert to do some more systematic testing late last year and earlier
this year but a couple of overseas trips and publishing a book for my wife
got in the way of the good intentions until recently.

David.



-
David Cousens
--
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-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] GC Importing GC Export Format - too many credits

[David Cousens]

I think you have found the bug in the import and export of stock
transactions. I recently exportedsome dummy stock transactions and the
information in the exported CSV records appears to be correct. I am working
my way through the CSV import process and documenting it as I go with
examples for the guide
and I hadn't made it to doing the stock transactions as yet. 

I have jumped ahead and reimported  stock purchase and stock sale
transactions with no errors at all.I created a dummy dividend reinvestment
transaction for a stock and exported it in the GnuCash Export Format and
then reimported it. On reimporting it created a miscellaneous transaction to
the imbalance account for 3.45.   The price on export was 14+17238/34483 but
when reimported the price is recorded as 13+17238/34483 accounting for this
difference. This appears to be some problem with importing prices expressed
as a whole number + a fractional part.

The transaction recorded before export in the stock account register  was
  
Shares   Price  Debit  Credit
Asset:Investments:Brokerage:Stock:Acme  6.8966  
14+17238/34483   100
Income:Dividend 
 
100

After reimporting after deleting the transaction exported it reappears as

  
Shares   Price  Debit  Credit
Asset:Investments:Brokerage:Stock:Acme  6.8966  
13+17238/34483   96.55
Imbalance   
   
3.45
Income:Dividend 
 
100


1

and there is a spurious line with a 1 in the price column - no account and
no values in the debit and credit columns.

If I edit the 96.55 to 100 and then tab to the next line and ask for the
price to be recalculated when the dialogue to rebalance the transaction
comes up then the price is restored to its original value and a second
imbalance line with a credit of 3.45 is created to balance the debit which
still exists although ithe Imbalance account does not appear in the account
column for that line (it is assigned to the Imbalance account when the edit
is closed). If I then close the edit on the transaction by clicking on
another transaction or at the bottom of the register it closes and when
reopened the Imbalance entries have disappeared as expected. 

Deleting the Imbalance entries in the editor can be tricky as you can't 
select the two matching entries simultaneously and delete them together and
the minute you delete one GnuCash recalulates the other because the
transaction is imbalanced. This is a quirk of the transaction edit operation
as it does not currently check if there is an existing split to an Imbalance
account which could be cancelled out (or its balance changed) by the newly
created balancing split. 

I didn't have a dummy mutual fund setup in the dummy books I am currently
using to develop the documentation but the stock import should be the same
and is likely experiencing  the same problem. If you open the CSV file in a
text editor and find the line you can check if the price recorded on export
is the same after being reimported to see if the problem is the same. If it
is you could report it as a bug at bugs.gnucash .org

David Cousens



-
David Cousens
--
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-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] GC Importing GC Export Format - too many credits

[ornd25]

When I import using GnuCash Export Format it brings in more splits than I 
requested.

This is a simple dividend reinvestment, with one Dr Asset:Mutual fund, and one 
Cr Income:Dividends. I ended up with the wrong number of splits and a wrong 
allocation follows:
Line 1 - Asset: Mutual Fund 3.026 shares
Line 2 - Income:Dividend Dr $100
Line 3 - Income:Dividend Cr $100

I created the format by actually exporting dividend reinvestment lines from the 
applicable account. I did not add any others by copying the first several I 
directly downloaded. I then changed the dates, deleted the TransactionID, price 
calculation, changed Reconciled to "n" and removed the reconciliation dates. 
The import went well with only the two accounts to link - it was just the 
result that was odd.

If this is just a quirk, it's simple enough to work around it by manually 
moving the Dr amount to the Asset:Mutual Fund line and deleting the extra 
Income:Dividend line, but if I'm doing something wrong or there's a way to 
correct it, I'd like to fix it.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Importing FX rates into gnucash

[Jeff Abrahamson]

Aha, thanks!

Jeff Abrahamson
http://p27.eu/jeff/
http://transport-nantes.com/

On 11/08/2019 19:55, John Ralls wrote:
>
>> On Aug 11, 2019, at 10:37 AM, Jeff Abrahamson  wrote:
>>
>> I have a table of historic FX rates I'd like to import into gnucash.  I
>> don't see how to do this inside gnucash, and googling about and reading
>> the docs I don't see mention of it.  Is this possible?  Or is there a
>> work-around?  (I'm using the sqlite backend, if that matters, which I
>> hope it doesn't. ;-)
> Format your table into a CSV and use File>Import>Import prices from a CSV 
> File
>
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Importing FX rates into gnucash

[John Ralls]

> On Aug 11, 2019, at 10:37 AM, Jeff Abrahamson  wrote:
> 
> I have a table of historic FX rates I'd like to import into gnucash.  I
> don't see how to do this inside gnucash, and googling about and reading
> the docs I don't see mention of it.  Is this possible?  Or is there a
> work-around?  (I'm using the sqlite backend, if that matters, which I
> hope it doesn't. ;-)

Format your table into a CSV and use File>Import>Import prices from a CSV 
File

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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Importing FX rates into gnucash

[Jeff Abrahamson]

I have a table of historic FX rates I'd like to import into gnucash.  I
don't see how to do this inside gnucash, and googling about and reading
the docs I don't see mention of it.  Is this possible?  Or is there a
work-around?  (I'm using the sqlite backend, if that matters, which I
hope it doesn't. ;-)

Thanks!

-- 

Jeff Abrahamson
+33 6 24 40 01 57
+44 7920 594 255

http://p27.eu/jeff/
http://transport-nantes.com/


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] importing invoices

[John Ralls]

> On Jul 13, 2019, at 9:07 AM, Jonathan Francoeur  wrote:
> 
> Hi.  I am trying to import invoices after reading this
> 
> .
> I copied the examples into a .csv file because I assumed they would work
> however I keep getting "customer does not exist" error.  I'm confused
> because the error dialogue refers to the data in the first column which
> according to the above link is the invoice ID and not to do with the
> customer.
> Here are some images":
> This one shows the import window.  I changed the id's from what the example
> in the above link gave to match what I have already created.  I also
> changed the dates to be in the future so that I could easily find them and
> delete them.  I also changed the account names to correspond with existing
> accounts.

You're misinterpreting the message, which is admittedly a little ambiguous. 
Since it's an invoice, the Owner type is Customer, and you have a column filled 
with "1" designated as "Owner Id". The importer thinks that there is no 
customer 1. Is it correct?

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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Column Detection when Importing Transactions from CSV

[Patrick]

Sorry, I just saw this response. (I had unsubsribed to try to reduce
flow into inbox, and I just saw it when I was going back through the
archives. I will turn digest back on.)

Thank you for this additional helpful information.

73,
Patrick
ag4jq

On 6/26/19 12:31 PM, Patrick wrote:
>* When importing transactions from a CSV file, is there a way to have GnuCash
*>* automatically detect the meaning of the columns based on the CSV headers?
*>* The headers in my CSV file are "Date", "Description", "Account", etc., so I
*>* was wondering if GnuCash had the ability to determine what the columns were
*>* from these headers, so that I don't have to select them from the dropdown
*>* menus every time I do an import.
*>>* Regards,
*>* Patrick
*

The screen where you pick these has a field at the very top where you
can name this setup and then save it.

You will have to select this name on the next import but it will remember:

* The field assignments

* The account into which you are doing the import

* The date format

* How many lines to skip

It was a big help when I discovered that!

--Steve


-- 
Stephen M Butler, PMP, PSMStephen.M.Butler51 at gmail.com
<https://lists.gnucash.org/mailman/listinfo/gnucash-user>kg7je at
arrl.net <https://lists.gnucash.org/mailman/listinfo/gnucash-user>
253-350-0166
---
GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Reconcile Flag when Importing Transactions from CSV

[Patrick]

In case someone else comes across this and is looking for a temporary
workaround, this is what I did.

In my local copy, I changed this line

https://github.com/Gnucash/gnucash/blob/maint/gnucash/import-export/import-backend.c#L924

to use "NREC" instead of "CREC".

File: gnucash/import-export/import-backend.c
Function: gnc_import_process_trans_item()
case GNCImport_ADD

Old line
xaccSplitSetReconcile(gnc_import_TransInfo_get_fsplit (trans_info), CREC);

New line
xaccSplitSetReconcile(gnc_import_TransInfo_get_fsplit (trans_info), NREC);

On Tue, Jul 2, 2019 at 6:58 AM Patrick  wrote:

> I was looking through the bug reports on Bugzilla, and I think there might
> already be an outstanding request (#796890) to adjust this behavior.
>
> I think that means my best options are to be patient or to stare
> at gnc-imp-props-tx.cpp for a while.
>
> https://bugs.gnucash.org/show_bug.cgi?id=796890
>
> On Mon, Jul 1, 2019 at 7:33 AM Patrick  wrote:
>
>> When I am importing transactions from a CSV, I have a "Reconcile" column
>> that I select as the "Transfer Reconciled" column in the import wizard. I
>> have all of the entries marked as "n" in this column, but after importing
>> them, some of them seem to still show up as "c". Am I misunderstanding the
>> "Transfer Reconciled" option, or am I likely doing something else wrong?
>>
>> I'm not sure if it is relevant, but I am importing in multi-split mode.
>>
>> Regards,
>> Patrick
>>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Reconcile Flag when Importing Transactions from CSV

[Patrick]

When I am importing transactions from a CSV, I have a "Reconcile" column
that I select as the "Transfer Reconciled" column in the import wizard. I
have all of the entries marked as "n" in this column, but after importing
them, some of them seem to still show up as "c". Am I misunderstanding the
"Transfer Reconciled" option, or am I likely doing something else wrong?

I'm not sure if it is relevant, but I am importing in multi-split mode.

Regards,
Patrick
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Column Detection when Importing Transactions from CSV

[Stephen M. Butler]

On 6/26/19 12:31 PM, Patrick wrote:
> When importing transactions from a CSV file, is there a way to have GnuCash
> automatically detect the meaning of the columns based on the CSV headers?
> The headers in my CSV file are "Date", "Description", "Account", etc., so I
> was wondering if GnuCash had the ability to determine what the columns were
> from these headers, so that I don't have to select them from the dropdown
> menus every time I do an import.
>
> Regards,
> Patrick


The screen where you pick these has a field at the very top where you
can name this setup and then save it.

You will have to select this name on the next import but it will remember:

* The field assignments

* The account into which you are doing the import

* The date format

* How many lines to skip

It was a big help when I discovered that!

--Steve


-- 
Stephen M Butler, PMP, PSM
stephen.m.butle...@gmail.com
kg...@arrl.net
253-350-0166
---
GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Column Detection when Importing Transactions from CSV

[Patrick]

Thank you for the response and for the helpful guidance.

I am using version 3.5, and I see now that there is an option to "Save
Settings" in the CSV importer.

Regards,
Patrick

On Wed, Jun 26, 2019 at 2:54 PM Geert Janssens 
wrote:

> Op woensdag 26 juni 2019 21:31:54 CEST schreef Patrick:
> > When importing transactions from a CSV file, is there a way to have
> GnuCash
> > automatically detect the meaning of the columns based on the CSV headers?
> > The headers in my CSV file are "Date", "Description", "Account", etc.,
> so I
> > was wondering if GnuCash had the ability to determine what the columns
> were
> > from these headers, so that I don't have to select them from the dropdown
> > menus every time I do an import.
> >
> > Regards,
> > Patrick
>
> GnuCash can't guess, but as of version 3.0 you can set the columns once
> and
> save this preset for a future import. So if the columns in your csv files
> are
> not changing this should reduce the amount of work on import.
>
> Regards,
>
> Geert
>
>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Importing investment info from Financial Planner's

[Joseph Hymel via gnucash-user]

Thanks for the information. I will try your suggestions. Thanks again.

Sent from Yahoo Mail on Android 
 
  On Tue, May 28, 2019 at 8:31 AM, csingley wrote:   Just 
to summarize what people are telling you:

GnuCash doesn't have any sort of functionality to automatically create
accounts for an investment the first time it's seen, if that's what you're
after.  You will need to manually set up your accounts with beginning
balances.  It's not that bad, unless your RIA is way off the deep end on the
"zillions of ETFs" gameplan.

Having done that, you can import investment transactions into GnuCash. 
GnuCash hasn't implemented direct web connection for investment
transactions, so you'll need to save the transactions to a local file, then
use File -> Import -> Import OFX/QFX inside GnuCash to import the saved file
and map it to your account structure.

Your advisor's website probably has a facility for downloading OFX/QFX data. 
If not, it looks like Ameriprise has a publicly-available OFX server; you
should be able to download the data.



--
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-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Importing investment info from Financial Planner's website

[csingley]

Just to summarize what people are telling you:

GnuCash doesn't have any sort of functionality to automatically create
accounts for an investment the first time it's seen, if that's what you're
after.  You will need to manually set up your accounts with beginning
balances.  It's not that bad, unless your RIA is way off the deep end on the
"zillions of ETFs" gameplan.

Having done that, you can import investment transactions into GnuCash. 
GnuCash hasn't implemented direct web connection for investment
transactions, so you'll need to save the transactions to a local file, then
use File -> Import -> Import OFX/QFX inside GnuCash to import the saved file
and map it to your account structure.

Your advisor's website probably has a facility for downloading OFX/QFX data. 
If not, it looks like Ameriprise has a publicly-available OFX server; you
should be able to download the data.



--
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-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Importing investment info from Financial Planner's website

[David Carlson]

Joseph,

Look on your financial planners website for a link to export your data.
Most investment firms have some such option, often near another option to
download a PDF of your monthly statement.

Since you say you used to do it with Quicken, they may have an option to
download qfx or ofx format.  Else there may be a options for other formats
such as qif or csv.

Any of those options will work with GnuCash, tho, as David T points out, it
my be an arduous process.

David Carlson

On Mon, May 27, 2019, 7:24 AM Joseph Hymel via gnucash-user <
gnucash-user@gnucash.org> wrote:

>  Thanks David T.
> Just to clarify I am only interested in being able to import MY investment
> holdings from my financial planner's website via my login/password for that
> website. I have recently left Quicken software where I had that ability to
> import my investment info, and thought it might exist in GNUCASH also.
> There is so much similarity between the two applications that has amazed me
> and thus caused me to seek this functionality out if it existed. I
> appreciate your prompt response nonetheless.
> Jo
> On Monday, May 27, 2019, 06:55:53 AM CDT, David T. <
> sunfis...@yahoo.com> wrote:
>
>  Jo,
>
> Importing such information is typically a one- time process, and the time
> it would take to programmatically process all possible situations makes it
> expensive, from a programming perspective. The development team has focused
> on other areas. I doubt any developer would take up your request.
>
> Having used gnucash for many years now, I have come to feel that the time
> spent trying to import even a complex set of investment accounts would be
> better spent creating the accounts and transactions to start up. Putting in
> this investment in time (pun intended) also helps one learn how to manage
> these accounts on a day to day basis.
>
>
> David
>
>
>   On Mon, May 27, 2019 at 17:00, Joseph Hymel via gnucash-user<
> gnucash-user@gnucash.org> wrote:   Hello,How do I import stock/bond
> mutual fund investment info from my financial planner's company website
> into gnucash software? I understand that I can setup each individual
> investment myself and have gnucash update the investments values daily,
> etc. I am interested in being able to setup the downloads of my investments
> directly from my financial planner's website (Ameriprise Financial) into my
> gnucash software.
> Is this functionally possible? If yes, how do I do it? If not, then is it
> possible for me to suggest this functionality be incorporated at some point
> in the future?
> Thanks,
> Jo
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Importing investment info from Financial Planner's website

[Joseph Hymel via gnucash-user]

 Thanks David T. 
Just to clarify I am only interested in being able to import MY investment 
holdings from my financial planner's website via my login/password for that 
website. I have recently left Quicken software where I had that ability to 
import my investment info, and thought it might exist in GNUCASH also. There is 
so much similarity between the two applications that has amazed me and thus 
caused me to seek this functionality out if it existed. I appreciate your 
prompt response nonetheless.
Jo
On Monday, May 27, 2019, 06:55:53 AM CDT, David T.  
wrote:  
 
 Jo,

Importing such information is typically a one- time process, and the time it 
would take to programmatically process all possible situations makes it 
expensive, from a programming perspective. The development team has focused on 
other areas. I doubt any developer would take up your request. 

Having used gnucash for many years now, I have come to feel that the time spent 
trying to import even a complex set of investment accounts would be better 
spent creating the accounts and transactions to start up. Putting in this 
investment in time (pun intended) also helps one learn how to manage these 
accounts on a day to day basis. 


David
 
 
  On Mon, May 27, 2019 at 17:00, Joseph Hymel via 
gnucash-user wrote:   Hello,How do I import 
stock/bond mutual fund investment info from my financial planner's company 
website into gnucash software? I understand that I can setup each individual 
investment myself and have gnucash update the investments values daily, etc. I 
am interested in being able to setup the downloads of my investments directly 
from my financial planner's website (Ameriprise Financial) into my gnucash 
software. 
Is this functionally possible? If yes, how do I do it? If not, then is it 
possible for me to suggest this functionality be incorporated at some point in 
the future?
Thanks,
Jo 
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Importing investment info from Financial Planner's website

[David T. via gnucash-user]

Jo,

Importing such information is typically a one- time process, and the time it 
would take to programmatically process all possible situations makes it 
expensive, from a programming perspective. The development team has focused on 
other areas. I doubt any developer would take up your request. 

Having used gnucash for many years now, I have come to feel that the time spent 
trying to import even a complex set of investment accounts would be better 
spent creating the accounts and transactions to start up. Putting in this 
investment in time (pun intended) also helps one learn how to manage these 
accounts on a day to day basis. 


David
 
 
  On Mon, May 27, 2019 at 17:00, Joseph Hymel via 
gnucash-user wrote:   Hello,How do I import 
stock/bond mutual fund investment info from my financial planner's company 
website into gnucash software? I understand that I can setup each individual 
investment myself and have gnucash update the investments values daily, etc. I 
am interested in being able to setup the downloads of my investments directly 
from my financial planner's website (Ameriprise Financial) into my gnucash 
software. 
Is this functionally possible? If yes, how do I do it? If not, then is it 
possible for me to suggest this functionality be incorporated at some point in 
the future?
Thanks,
Jo 
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Importing investment info from Financial Planner's website

[Joseph Hymel via gnucash-user]

Hello,How do I import stock/bond mutual fund investment info from my financial 
planner's company website into gnucash software? I understand that I can setup 
each individual investment myself and have gnucash update the investments 
values daily, etc. I am interested in being able to setup the downloads of my 
investments directly from my financial planner's website (Ameriprise Financial) 
into my gnucash software. 
Is this functionally possible? If yes, how do I do it? If not, then is it 
possible for me to suggest this functionality be incorporated at some point in 
the future?
Thanks,
Jo 
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] importing invoices as paid

[Derek Atkins]

Adrien Monteleone  writes:

> If they are paid, you’d need to have the payment transactions imported
> as well. There isn’t any such thing as ‘paid’ with no actual
> payment. (as far as I’m aware)

You will both have to import the payment transaction, and you will have
to *manually* attach the payment to the invoice/customer.  There is no
importer way to do that.

> I don’t know of a way to auto-assign the transactions as being applied
> in payment of any particular invoice once they are imported. You might
> have to assign those one at a time. (but at least you don’t have to
> create the individual transactions)

Right.

> Perhaps one of the devs familiar with the Business Features can offer
> more insight.

Nope, nothing more; there is no way to import that metadata at this time.

> Regards,
> Adrien

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek
-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] importing invoices as paid

[Adrien Monteleone]

If they are paid, you’d need to have the payment transactions imported as well. 
There isn’t any such thing as ‘paid’ with no actual payment. (as far as I’m 
aware)

I don’t know of a way to auto-assign the transactions as being applied in 
payment of any particular invoice once they are imported. You might have to 
assign those one at a time. (but at least you don’t have to create the 
individual transactions)

Perhaps one of the devs familiar with the Business Features can offer more 
insight.

Regards,
Adrien

> On May 9, 2019, at 12:22 PM, mountain  wrote:
> 
> Hi, is there a way to not only import invoices but to also import data
> indicating that they have been paid? Unfortunately I have hundreds of paid
> invoices to import.
> 


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] importing invoices as paid

[mountain]

Hi, is there a way to not only import invoices but to also import data
indicating that they have been paid? Unfortunately I have hundreds of paid
invoices to import.



--
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-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] My experience importing 19 years of Quicken data into GnuCash

[GWB]

Haven't tested this with the SQLite GnuCash backend, but it is
sometimes possible with PostgreSQL to "roll back" to an earlier state
before the last transactions, or for that matter, any arbitrary number
of transactions before the last one.  I haven't used the PostgreSQL
backend with GnuCash for some time now, since the SQLite format works
extremely well.  But having multiple formats (xml files and sql
databases) was one reason I moved from various other finance programs
(which shall not be named).  SQL Ledger is a financial server-client
model that allows this.

Unless you are willing to spend some time learning various sql query
and dbase commands and functions, I would stick with SQLite and make
snapshots (if your file system allows it) or frequent backups.  And
there is still nothing wrong with the .xml file format that I can see.
I would not suggest the developers try to incorporate some kind of
multiple "undo" within the GnuCash menu (there is already a "replay"
feature, I think, with the .xml file), unless they have lots of spare
time (also not likely!).  But maybe if someone has already had some
success with "rolling back" the SQLite gnucash file to an earlier
state (using command line sql functions and commands?) they could put
it on the wiki.

Keeping changes in memory until commit ("save") works great on most
machines (i.e., the xml file format).  I worry about core dumps and
crashes on linux (less so FreeBSD) so I like various types of sql
backends, but my guess is that most Windows and Mac users (the
majority of gnucash users?) are only rarely affected by crashes.

Gordon

On Sat, Apr 6, 2019 at 1:20 PM Cricket Onebit
 wrote:
>
> That makes sense.
>
> I know with some versions of SQL, you can roll-back. I suspect that each of
> the three versions GNUCash supports does it differently, sigh. If I do use
> SQL, I'll treat it like my novel. Dated daily backups, and add good title
> and change log when I make major changes. Not that I ever regret major
> changes.
>
> 
> Virus-free.
> www.avast.com
> 
> <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
>
> On Tue, 2 Apr 2019 at 15:23, no_more_quicken  wrote:
>
> > Cricket Onebit wrote
> > > Can you explain more about not being able to undo things with the SQL
> > > backend vs XML (or point to more details)? I'm undecided about which
> > > backend. Fully-functional and easy to install and maintain is more
> > > important to me than a few seconds while using, unless those seconds add
> > > up
> > > quickly. I want to do my accounting, not trouble-shoot the installation.
> >
> > With the XML backend, any modifications are kept in memory until you
> > explicitly save the changes.  (You can also setup GnuCash to auto-save at
> > set intervals.) So if you make a major/destructive goof while editing
> > transactions, you can always just not save and get back to your last saved
> > state.  With a SQL backend, modifications are committed immediately to the
> > database, so there is no way to go back.  That said, converting from one
> > format to another is trivially easy and doable at any time, so it's not
> > necessarily a big decision you have to make a priori.
> >
> >
> >
> >
> > --
> > 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-user
> > If you are using Nabble or Gmane, please see
> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> >
>
>
> --
> +++
>
> Not as a ladder from earth to Heaven, not as a witness to any creed,
> But simple service simply given to his own kind in their common need.
> -- Rudyard Kipling
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List 

Re: [GNC] My experience importing 19 years of Quicken data into GnuCash

[Cricket Onebit]

That makes sense.

I know with some versions of SQL, you can roll-back. I suspect that each of
the three versions GNUCash supports does it differently, sigh. If I do use
SQL, I'll treat it like my novel. Dated daily backups, and add good title
and change log when I make major changes. Not that I ever regret major
changes.


Virus-free.
www.avast.com

<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

On Tue, 2 Apr 2019 at 15:23, no_more_quicken  wrote:

> Cricket Onebit wrote
> > Can you explain more about not being able to undo things with the SQL
> > backend vs XML (or point to more details)? I'm undecided about which
> > backend. Fully-functional and easy to install and maintain is more
> > important to me than a few seconds while using, unless those seconds add
> > up
> > quickly. I want to do my accounting, not trouble-shoot the installation.
>
> With the XML backend, any modifications are kept in memory until you
> explicitly save the changes.  (You can also setup GnuCash to auto-save at
> set intervals.) So if you make a major/destructive goof while editing
> transactions, you can always just not save and get back to your last saved
> state.  With a SQL backend, modifications are committed immediately to the
> database, so there is no way to go back.  That said, converting from one
> format to another is trivially easy and doable at any time, so it's not
> necessarily a big decision you have to make a priori.
>
>
>
>
> --
> 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-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


-- 
+++

Not as a ladder from earth to Heaven, not as a witness to any creed,
But simple service simply given to his own kind in their common need.
-- Rudyard Kipling
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Importing AR invoices

[Adrien Monteleone]

If you’re doing manual entries (or importing the invoices as regular 
transactions instead of as invoices) you determine the accounts posted to so 
assign the splits as you wish, manually after the import or adding that info to 
the CSV.

I’d recommend going to the View menu and switching to Transaction Journal mode. 
(and optionally turn on Double Line mode as well which displays a ’note’ field 
for the entire transaction so you aren’t limited to only the memos fields on 
the splits)

This will always show all split information so you can see all debits and 
credits for each transaction. It helps to be able to follow exactly which 
accounts are involved.

Note, how you have this setup here and how this would work with manual entries 
(typed in or imported) is that the A/R sub-accounts will show $0 if all 
invoices have been collected on. They won’t show you how much has been paid, 
but how much is still owed. (if anything)

The signs of the figures you show in this screenshot are backwards for the A/R 
accounts. This looks like the company owes that money to someone, not that 
someone else owes the company. A/R is an asset because it is revenue earned, 
but not yet collected. Once collected it is accounted for in whatever account 
it was paid into. (Cash, Checking, etc.)

If you have outstanding invoices you haven’t collected on, A/R should be 
positive. If someone pre-paid or overpaid, that would be a credit to A/R.

Textbook invoice transaction:

Dr. Assets:Accounts Receivable
Cr. Income:Sales

It looks like you have the preference for Reversed Balance Accounts set to 
’None’ and this is your transaction entry:

Dr. Income:Sales
Cr. Assets:Accounts Receivable

—which is backwards.

Regards,
Adrien

> On Apr 2, 2019, at 11:06 AM, Teresa  wrote:
> 
> What we do is sell IT preventative maintenance for Hotels. I have GL accounts 
> set up for each item we sell, total of 5.
> 
> what I need to be able to do is import in Assets, how much to apply to each 
> gl account, I also have gl accounts set up under income for paid
> 
> Should I skip doing it as an import and just add lines and amounts under each 
> sold account. If I do this will the system create a credit entry under the 
> corresponding paid account?
> 
> Sold GL accounts are 401-9182 through 401-9185
> 
> Paid accounts are 400-9182 through 400-9185
> 
> 
> 
> 
> 
> On 4/1/2019 10:47 PM, Adrien Monteleone wrote:
>> Teresa,
>> 
>> I forgot to mention, GnuCash has no facility to store ‘products’ or ’service 
>> offerings’ or any kind of ‘inventory’. You just create your own invoice line 
>> items each time. But the software does utilize auto-fill based on previous 
>> entries. So you can start typing a line item description and it will fill in 
>> the rest based on a previous entry as well as other line item info like 
>> income account, discounts, quantity, pricing, tax etc.
>> 
>> If the invoices are exact (or even near) duplicates, you can use the 
>> Duplicate Invoice button as a starting point and edit accordingly.
>> 
>> Regards,
>> Adrien
>> 
>> 
>>> On Apr 1, 2019, at 10:55 AM, Teresa 
>>>  wrote:
>>> 
>>>  we invoice up to 75 recurring invoices monthly, that include one of 5 IT 
>>> products that are loaded in GNUCash.
>>> 


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] My experience importing 19 years of Quicken data into GnuCash

[no_more_quicken]

Adrien Monteleone-2 wrote
>> On Apr 2, 2019, at 11:59 AM, no_more_quicken 

> nospam@

>  wrote:
>> 
>> 
>> 5. I still haven't quite figured out the reporting framework; my goal is
>> to
>> generate an "expenses over the last X months grouped by month" report
>> (i.e.,
>> just like the "Expense Over Time" built-in chart, but in a table format
>> with
>> all the numbers for every account).  I found  this thread
>> http://gnucash.1415818.n4.nabble.com/Monthly-Income-Expense-Reports-td1561239.html;
>>   
>> from a decade ago but if anyone has any updated tips that would be
>> appreciated.
> 
> While a Transaction Report might get you the data, I tend to like the
> Budget Report for its layout.
> 
> If you only want to see actual expenses, simply uncheck the “Show Budget”
> in the Display tab.
> 
> You can get each month/period in its own column, optionally have a total
> column, and everything is listed by account just like a P
> 
> I think you have to setup a budget first to define the reporting period to
> get it to work. I haven’t tried it without one created.
> 
> Regards,
> Adrien

Thanks, Adrien.  This approach is working for me -- I just had to create a
new budget and was able to create the report!




--
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-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] My experience importing 19 years of Quicken data into GnuCash

[no_more_quicken]

Cricket Onebit wrote
> Can you explain more about not being able to undo things with the SQL
> backend vs XML (or point to more details)? I'm undecided about which
> backend. Fully-functional and easy to install and maintain is more
> important to me than a few seconds while using, unless those seconds add
> up
> quickly. I want to do my accounting, not trouble-shoot the installation.

With the XML backend, any modifications are kept in memory until you
explicitly save the changes.  (You can also setup GnuCash to auto-save at
set intervals.) So if you make a major/destructive goof while editing
transactions, you can always just not save and get back to your last saved
state.  With a SQL backend, modifications are committed immediately to the
database, so there is no way to go back.  That said, converting from one
format to another is trivially easy and doable at any time, so it's not
necessarily a big decision you have to make a priori.




--
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-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] My experience importing 19 years of Quicken data into GnuCash

[Cricket Onebit]

Thanks for this.

I have a similar project in the near future, and was wondering the best
order for some things. It looks like the major re-categorization should be
done before leaving Quicken.

Good to know there's a workaround for the HiDPI bug.

Is there a bug report / feature request for bulk actions? I'd vote for it
(if I get to the "pay it forward by being active in GnuCash Community" part
of the project).

Can you explain more about not being able to undo things with the SQL
backend vs XML (or point to more details)? I'm undecided about which
backend. Fully-functional and easy to install and maintain is more
important to me than a few seconds while using, unless those seconds add up
quickly. I want to do my accounting, not trouble-shoot the installation.

Thanks,

Cricket / Sandy

-- 
+++

Not as a ladder from earth to Heaven, not as a witness to any creed,
But simple service simply given to his own kind in their common need.
-- Rudyard Kipling


Virus-free.
www.avast.com

<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] My experience importing 19 years of Quicken data into GnuCash

[Adrien Monteleone]

> On Apr 2, 2019, at 11:59 AM, no_more_quicken  wrote:
> 
> 
> 5. I still haven't quite figured out the reporting framework; my goal is to
> generate an "expenses over the last X months grouped by month" report (i.e.,
> just like the "Expense Over Time" built-in chart, but in a table format with
> all the numbers for every account).  I found  this thread
> 
>   
> from a decade ago but if anyone has any updated tips that would be
> appreciated.

While a Transaction Report might get you the data, I tend to like the Budget 
Report for its layout.

If you only want to see actual expenses, simply uncheck the “Show Budget” in 
the Display tab.

You can get each month/period in its own column, optionally have a total 
column, and everything is listed by account just like a P

I think you have to setup a budget first to define the reporting period to get 
it to work. I haven’t tried it without one created.

Regards,
Adrien
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] My experience importing 19 years of Quicken data into GnuCash

[no_more_quicken]

I've been diligently tracking my personal finances since early 2000. I
started with MS Money, then reluctantly switched to Quicken when Money was
discontinued. I LOVED MS Money, but I've never really been happy with
Quicken.  It's hard to pinpoint exaclty why, but some combination of the
clunky UI, subtle bugs in the reporting, upgrades with no new features, etc.
made me lose confidence in the program and made me want to switch. Over the
past 19 years, I've accumulated a large variety of accounts & transactions,
including trades of stocks/commodities/futures, hedge fund investments,
cryptocurrency trades, corporate pension accounts, restricted stock
distributions, IRA accounts, 401k accounts, 529 accounts, home purchases &
sells, auto loans, tax adjustments, cash accounts, etc.

I tried MANY alternatives, including the obvious online ones, but none of
the options supported all of my needs. None of the online solutions could
handle my manual cash accounts, nor maintain the full history from accounts
that have long been closed.  And none of the desktop programs supported all
of the different account/transaction types.

I recently stumbled upon GnuCash, and decided to give it an earnest chance,
partly because the double-entry backend + open source program gave me
confidence that my data would remain safe, exportable & future-proof once it
was converted.  I wrangled with the process for about a week, and finally
got all of my data in, but it was a bumpy road.  Here are some notes from
the process; I am hoping it will help others like me and/or the developers
looking to improve GnuCash.  This was all using GnuCash 3.4 (Build ID: 3.4+
(2018-12-30)) on a Surface Book 2 running Windows 10:

1.  At first, I exported everyting from Quicken into a giant 400k-line QIF
file, and tried to import that into GnuCash.  This took FOREVER (as in, 5+
hours), and eventually failed with an unhelpful message ("import failed", or
something similar). From the log file, I was able to see what appeared to be
the last successfully imported transaction, but no clue as to why the next
transaction didn't import.  Undeterred, I proceeded to export each account
individually from Quicken into ~50 separate QIF files, and imported them one
by one.  I'll note that each import took a VERY long time, which may or may
not be related to  the HiDPI bug

 
, whose existence and workaround I only discovered after finishing the
import process.  During this arduous process, I experienced failures similar
to the giant import, and each time I had to manaully edit the QIF file to
remove offending transactions to make it work. In the end, there were 5
transactions that had to be removed, and they were all transfer transactions
which were duplicates of transactions which had been imported by an earlier
QIF file.

2.  The HiDPI bug mentioned above
(http://gnucash.1415818.n4.nabble.com/GNC-Saving-in-GnuCash-painfully-slow-what-can-I-do-td4701583.html)
nearly caused me to abandon GnuCash altogether, as saving to XML was taking
several minutes.  Before discovering the workaround, I tried using both the
mysql and sqlite3 backends, but not having a way to undo mistakes was a
dealbreaker.  (However, having the ability to export to SQL is amazing.) 
I'll also note that even after changing the HiPDPI scaling to be performed
by "System," the save to XML still takes ~25 seconds for me, which is still
quite slow.  I understand the root cause may be from a third-party library,
but I think somehow addressing this out-of-the-box would make a HUGE
difference to new users.

3.  Having gotten the data into GnuCash, next came the process of cleaning
things up.  Here, not having the ability to multi-select / bulk edit
transactions proved to be quite a handicap.  I found numerous situations in
which I wanted to re-categorize a bunch of stuff, clean up the way my loan
payments had been recorded in the past, etc.  I understand that the best way
would be to get it exactly right at the time of entry/import, but inevitably
people will make mistakes and want to correct them in bulk.  The "delete
account and move" workaround helped a bit, but still proved limited for what
I wanted to do.

4. The online banking setup is quite confusing, mostly because of the UI. 
Since most users (myself included) think in terms of their online
username/login, I think simply having a one-step Quicken-style wizard which
hides the UUID details could go a LONG way toward making things less
daunting. Once I figured out the terminology/UI, I had a relatively smooth
experience with some accounts (e.g., American Express), but for Chase I
ended up having to sniff my old Quicken network traffic to grab the UUID to
make it work, and for E*Trade I can get the account list but not download
any transactions.

5. I still haven't quite figured out the reporting framework; my goal is to
generate an "expenses over 

Re: [GNC] Importing AR invoices

[Adrien Monteleone]

Teresa,

I forgot to mention, GnuCash has no facility to store ‘products’ or ’service 
offerings’ or any kind of ‘inventory’. You just create your own invoice line 
items each time. But the software does utilize auto-fill based on previous 
entries. So you can start typing a line item description and it will fill in 
the rest based on a previous entry as well as other line item info like income 
account, discounts, quantity, pricing, tax etc.

If the invoices are exact (or even near) duplicates, you can use the Duplicate 
Invoice button as a starting point and edit accordingly.

Regards,
Adrien

> On Apr 1, 2019, at 10:55 AM, Teresa  wrote:
> 
>  we invoice up to 75 recurring invoices monthly, that include one of 5 IT 
> products that are loaded in GNUCash.
> 


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Importing AR invoices

[David Cousens]

Teresa 

In addition to the documentation if you open the import invoice dialog you
will see the column headers displayed in the dialog window. These basically
correspond to the data which constitutes the invoice record ( and associated
transaction). These can be matched up to the columns and associated headers
of the invoices you are importing. Not all fields need to be filled.Things
like the billing id and owner_id refer to internal guid's in the GnuCash
data structures. 

David Cousens



-
David Cousens
--
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-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Importing AR invoices

[Adrien Monteleone]

Teresa,

Welcome to GnuCash!

Read over the Tutorial & Concepts Guide, Chapter 18:Importing Business Data.

If your Help menu doesn’t link to it (it should) you can find it on GnuCash.org 
under Documentation.

The column headers and explanation for each of invoices/bills and 
customers/vendors is included.

> On Apr 1, 2019, at 10:55 AM, Teresa  wrote:
> 
> We are just getting started in GNUCash, we are using another system for 
> invoicing.
> 
> I have tried several times to import invoices from Jan 1, each time has 
> failed.
> 
> Please provide the column layout, we invoice up to 75 recurring invoices 
> monthly, that include one of 5 IT products that are loaded in GNUCash.
> 
>  I really need this to work.
> 
> Thank you
> 
> -- 
> 
> Teresa Slack


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Importing AR invoices

[Teresa]

We are just getting started in GNUCash, we are using another system for 
invoicing.


I have tried several times to import invoices from Jan 1, each time has 
failed.


Please provide the column layout, we invoice up to 75 recurring invoices 
monthly, that include one of 5 IT products that are loaded in GNUCash.


 I really need this to work.

Thank you

--

Teresa Slack

Senior Client Manager

*_Coba Enterprise Management, LLC_*

3620 Pelham Road, PMB 107

Greenville, SC 29615

Office: 864.343.8017 x 5

Cell:    864.525.3633

ter...@coba-em.com 
Coba-EM.com 

/NOTICE TO RECIPIENTS: The information contained in and accompanying 
this communication may be confidential, subject to legal privilege, or 
otherwise protected from disclosure, and is intended solely for the use 
of the intended recipient(s). If you are not the intended recipient of 
this communication, please delete and destroy all copies in your 
possession, notify sender that you have received this communication in 
error, and note that any review or dissemination of, or the taking of 
any action in reliance on, this communication is expressly prohibited. 
Email messages may contain computer viruses or other defects, may not be 
accurately replicated on other systems, or may be intercepted, deleted 
or interfered with without the knowledge of the sender or the intended 
recipient. Coba Enterprise Management, LLC makes no warranties in 
relation to these matters. Please note that Coba Enterprise Management, 
LLC reserves the right to intercept, monitor, and retain email messages 
to and from its systems as permitted by applicable law. If you are not 
comfortable with the risks associated with e-mail messages, you may 
decide not to use email to communicate with Coba Enterprise Management, 
LLC. /


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Importing buying shares transactions

[One Click To Qif]

Hi David:

I had version 2.6.14 installed and I installed 3.4.
However, it is obvious that this functionality does not work: GnuCash
cannot import transactions of shares, not even in the format exported
by itself.
I will have to manually introduce them.
Very disappointing.

Thanks for your answer in any case.
Regards


On Mon, Mar 4, 2019 at 10:50 PM David Cousens  wrote:
>
> The following refers primarily to importing in V3.3 and later. The CSV
> importer was rewritten going from 2.6.  to v3.0 and was likely only tested
> on basic functionality. At the moment I am doing extensive systematic
> testing of the CSV importer and settings with a view to identifying as many
> of the problems as possible and fixing them.
>
> The CSV importer currently does not work properly importing multi currency
> transactions. I have not yet tested it on trading accounts specifically but
> that is in the todo loop for the near future. With multicurrency imports one
> problem is associated with applying the price so it is possible the same
> problem extends to trading accounts.  There also appear to be some problems
> with the transaction export using File->Export Transactions to CSV as it
> only appears to export the headers and no data. I have found File->Export
> Transactions from Active Register is working correctly for single currency
> transactions and multicurrency transactions so far.
>
> To have a chance at importing it use the GnuCash Export Settings in the
> import and leave all the other settings at the default settings apart from
> the multisplit check box which needs to be checked to import multiline data
> and setting the correct date format. It is usually necessary to play around
> a bit with the assignment of columns as the headers and column labels aren't
> always a 1-1 match.  If you do find a combination of settings which works
> could you please let me know.
>
> There is a problem with date formats in that the locale setting is not
> currently being used to set the default date format. Once it is matched
> though it usually works OK. I usually have to reset it to my usual local
> format on all imports.
>
> David Cousens
>
>
>
> -
> David Cousens
> --
> 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-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Importing buying shares transactions

[David Cousens]

The following refers primarily to importing in V3.3 and later. The CSV
importer was rewritten going from 2.6.  to v3.0 and was likely only tested
on basic functionality. At the moment I am doing extensive systematic
testing of the CSV importer and settings with a view to identifying as many
of the problems as possible and fixing them. 

The CSV importer currently does not work properly importing multi currency
transactions. I have not yet tested it on trading accounts specifically but
that is in the todo loop for the near future. With multicurrency imports one
problem is associated with applying the price so it is possible the same
problem extends to trading accounts.  There also appear to be some problems
with the transaction export using File->Export Transactions to CSV as it
only appears to export the headers and no data. I have found File->Export
Transactions from Active Register is working correctly for single currency
transactions and multicurrency transactions so far.

To have a chance at importing it use the GnuCash Export Settings in the
import and leave all the other settings at the default settings apart from
the multisplit check box which needs to be checked to import multiline data
and setting the correct date format. It is usually necessary to play around
a bit with the assignment of columns as the headers and column labels aren't
always a 1-1 match.  If you do find a combination of settings which works
could you please let me know.

There is a problem with date formats in that the locale setting is not
currently being used to set the default date format. Once it is matched
though it usually works OK. I usually have to reset it to my usual local
format on all imports.

David Cousens



-
David Cousens
--
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-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Importing buying shares transactions

[One Click To Qif]

Hi:

I have stock accounts in GnuCash, and I want to import data regarding
buying shares, which I have at Excel. I can massage or convert the
Excel data to CSV or any other format, but I do not know if GnuCash
will be able to import them.

For example, if I export stock Transactions to CSV from inside GC, it
creates a file apparently fine, but then it is unable to reimport it,
as the rows with no date produce a "date format could be wrong" error
when reimporting, even when have been created by GC itself.

So, it is possilbe por GC to import shares transactions?

Thanks
Regards
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Importing Quicekn Files

[Derek Atkins]

Sorry, yeah QXF != QFX.  QFX/OFX is readable.  QXF is not.
-derek

On Tue, February 12, 2019 11:04 am, Dan Black wrote:
> QFX is a download format, designed for import of transactions from your
> bank into a single Quicken account. ... QXF is an encrypted file transfer
> format designed to move entire Quicken databases with multiple accounts
> from Windows to Mac or visa versa.
>
> On February 12, 2019 10:46:36 AM Derek Atkins  wrote:
>
>> David Carlson  writes:
>>
>>> I just peeked at Quicken 2019 and they also have a QXF file format
>>> which
>>> does not work for GnuCash either.  I did not have time to figure out
>>> what
>>> they do use that format for.  For us it is another tree in the forest.
>>
>> Are you sure?  QXF should be readable by the OFX importer.
>>
>>> David Carlson
>>
>>> Please remember to CC this list on all your replies.
>>> You can do this by using Reply-To-List or Reply-All.
>>
>> -derek
>>
>> --
>>   Derek Atkins 617-623-3745
>>   de...@ihtfp.com www.ihtfp.com
>>   Computer and Internet Security Consultant
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using Nabble or Gmane, please see
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>
>
>
>


-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Importing Quicekn Files

[Dan Black]

QFX is a download format, designed for import of transactions from your 
bank into a single Quicken account. ... QXF is an encrypted file transfer 
format designed to move entire Quicken databases with multiple accounts 
from Windows to Mac or visa versa.

On February 12, 2019 10:46:36 AM Derek Atkins  wrote:

> David Carlson  writes:
>
>> I just peeked at Quicken 2019 and they also have a QXF file format which
>> does not work for GnuCash either.  I did not have time to figure out what
>> they do use that format for.  For us it is another tree in the forest.
>
> Are you sure?  QXF should be readable by the OFX importer.
>
>> David Carlson
>
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>
> -derek
>
> --
>   Derek Atkins 617-623-3745
>   de...@ihtfp.com www.ihtfp.com
>   Computer and Internet Security Consultant
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Importing Quicekn Files

[Derek Atkins]

David Carlson  writes:

> I just peeked at Quicken 2019 and they also have a QXF file format which
> does not work for GnuCash either.  I did not have time to figure out what
> they do use that format for.  For us it is another tree in the forest.

Are you sure?  QXF should be readable by the OFX importer.

> David Carlson

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Importing Quicekn Files

[Kenneth Schneider]

There is a difference between QXF and QFX formats.

Ken Schneider 

> On Feb 12, 2019, at 8:45 AM, David Carlson  
> wrote:
> 
> I just peeked at Quicken 2019 and they also have a QXF file format which
> does not work for GnuCash either.  I did not have time to figure out what
> they do use that format for.  For us it is another tree in the forest.
> 
> David Carlson
> 
>> On Mon, Feb 11, 2019 at 11:23 PM John Ralls  wrote:
>> 
>> 
>> 
>>> On Feb 11, 2019, at 12:28 PM, David Seltzer via gnucash-user <
>> gnucash-user@gnucash.org> wrote:
>>> 
>>> I am a new user and just tried to import my Quicken files following the
>> instructions.  However, My files are saved as .QDF files, not .QIF and I
>> get a wrong format error message when I try to import them.
>>> 
>>> 
>>> I would appreciate any suggestions for fixing this.
>> 
>> You must export them as QIF or QFX files. GnuCash doesn't know how to read
>> QDF.
>> 
>> 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
>> If you are using Nabble or Gmane, please see
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -
>> 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
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Importing Quicekn Files

[David Carlson]

I just peeked at Quicken 2019 and they also have a QXF file format which
does not work for GnuCash either.  I did not have time to figure out what
they do use that format for.  For us it is another tree in the forest.

David Carlson

On Mon, Feb 11, 2019 at 11:23 PM John Ralls  wrote:

>
>
> > On Feb 11, 2019, at 12:28 PM, David Seltzer via gnucash-user <
> gnucash-user@gnucash.org> wrote:
> >
> > I am a new user and just tried to import my Quicken files following the
> instructions.  However, My files are saved as .QDF files, not .QIF and I
> get a wrong format error message when I try to import them.
> >
> >
> > I would appreciate any suggestions for fixing this.
>
> You must export them as QIF or QFX files. GnuCash doesn't know how to read
> QDF.
>
> 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
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Importing Quicekn Files

[John Ralls]

> On Feb 11, 2019, at 12:28 PM, David Seltzer via gnucash-user 
>  wrote:
> 
> I am a new user and just tried to import my Quicken files following the 
> instructions.  However, My files are saved as .QDF files, not .QIF and I get 
> a wrong format error message when I try to import them.
> 
> 
> I would appreciate any suggestions for fixing this.

You must export them as QIF or QFX files. GnuCash doesn't know how to read QDF.

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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Importing Quicekn Files

[David Seltzer via gnucash-user]

I am a new user and just tried to import my Quicken files following the 
instructions.  However, My files are saved as .QDF files, not .QIF and I 
get a wrong format error message when I try to import them.



I would appreciate any suggestions for fixing this.

Thank you in advance,
David Seltzer
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Importing QIF results into duplicate entry

[Chitresh Bhushan]

Hi David,

Thanks for your suggestion! I exported each of my account into a separate
QIF file and then started importing them one by one. That worked well,
although bit tedious. I had to go through duplicate detection, but that was
reasonably okay as gnucash had already made a very good guess.

Thanks

On Sun, Jan 20, 2019 at 12:03 PM David T.  wrote:

> Hi,
>
> Welcome to GnuCash.
>
> Getting your data into GnuCash always seems to be a challenge; many
> threads on the lists over the years attest to it.
>
> Given your particular problem—that is, your exported data is producing
> overlaps in the results—you might be advised to revisit the export piece
> and separate the accounts into different QIF files. Beginning with the
> account with the most transactions, perform an import into GnuCash. Then,
> **in separate passes**, import the other files, and be sure to use the
> assignment window to link your incoming transactions to those that already
> exist in the file. In this way, you can tell GnuCash to connect the
> transactions together in the final file.
>
> Cheers,
> David T.
>
> > On Jan 20, 2019, at 10:16 PM, Chitresh Bhushan 
> wrote:
> >
> > Hi all,
> >
> > I am trying to switch to gnucash. I have exported all my data in QIF
> format
> > from the old software I was using, moneyguru (
> > https://github.com/hsoft/moneyguru). However, when I import the exported
> > QIF file in gnucash, I see a lot of duplicate entries in gnucash,
> resulting
> > to incorrect balances. Moneyguru also uses double-entry accounting, so I
> > was hoping this transition would be easy.
> >
> > To reproduce the behavior, I have linked below a sample (tiny) QIF file
> > exported from moneyguru. Can someone take a look and check if the file
> > format is correct? Or am I doing something wrong during the import? I am
> > new to gnucash and using gnucash 2.6.19 on Ubuntu.
> >
> > The sample file generates duplicates in checking and credit-card accounts
> > (for $980 entry) on importing. My actual data has more than 8 yrs of
> > entries.. so its quite big with a lot of duplicates.
> >
> > Sample QIF file exported from moneyguru:
> > https://peep.updog.co/shared/tiny_export.qif (381 bytes)
> >
> > Any help is highly appreciated!
> >
> > Thanks,
> > CB
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -
> > 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Importing QIF results into duplicate entry

[David Cousens]

Hi Chitresh,

Had a quick look at the QIF format in your attached file. It seems to be OK.
The QIF format is not all that well defined. Compare the w3c
definition(https://www.w3.org/2000/10/swap/pim/qif-doc/QIF-doc.htm) and that
in Wikipedia (https://en.wikipedia.org/wiki/Quicken_Interchange_Format) for
example. There are several difference which could cause problems with an
import parser. The QIF files I have imported (mainly from paypal) looked
more like the Wikipedia format description than the w3c.

Have you matched your account structure in GnuCash as closely as you can to
the Quicken categories? If accounts matching the categories don't exist, the
new account button in the account matching dialog will allow you to create
appropriate accounts on the fly. You can rearrange and rename accounts after
importing data but having a roughly matching heirarchy will make it easier.

Importing one account at a time (preferrably in small blocks until you have
the process working well) as David T suggested is a good process. 

Understanding the matcher operation and the meaning of the A, U and R flags
is also important. Sometimes the matcher will match to a transaction that is
not the same transaction and will reject import. This can happen with
frequent recurring transactions and you have to manually uncheck the R flag
in that case.

There are a number of threads in the archives like the following
https://lists.gnucash.org/pipermail/gnucash-user/2010-April/034615.html
where the operation of the matcher is discussed. Searching the archives with
Google for "site:lists.gnucash.org import match" will bring up appropriate
threads.

David Cousens



-
David Cousens
--
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-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Importing QIF results into duplicate entry

[David T. via gnucash-user]

Hi,

Welcome to GnuCash. 

Getting your data into GnuCash always seems to be a challenge; many threads on 
the lists over the years attest to it. 

Given your particular problem—that is, your exported data is producing overlaps 
in the results—you might be advised to revisit the export piece and separate 
the accounts into different QIF files. Beginning with the account with the most 
transactions, perform an import into GnuCash. Then, **in separate passes**, 
import the other files, and be sure to use the assignment window to link your 
incoming transactions to those that already exist in the file. In this way, you 
can tell GnuCash to connect the transactions together in the final file.

Cheers,
David T.

> On Jan 20, 2019, at 10:16 PM, Chitresh Bhushan  wrote:
> 
> Hi all,
> 
> I am trying to switch to gnucash. I have exported all my data in QIF format
> from the old software I was using, moneyguru (
> https://github.com/hsoft/moneyguru). However, when I import the exported
> QIF file in gnucash, I see a lot of duplicate entries in gnucash, resulting
> to incorrect balances. Moneyguru also uses double-entry accounting, so I
> was hoping this transition would be easy.
> 
> To reproduce the behavior, I have linked below a sample (tiny) QIF file
> exported from moneyguru. Can someone take a look and check if the file
> format is correct? Or am I doing something wrong during the import? I am
> new to gnucash and using gnucash 2.6.19 on Ubuntu.
> 
> The sample file generates duplicates in checking and credit-card accounts
> (for $980 entry) on importing. My actual data has more than 8 yrs of
> entries.. so its quite big with a lot of duplicates.
> 
> Sample QIF file exported from moneyguru:
> https://peep.updog.co/shared/tiny_export.qif (381 bytes)
> 
> Any help is highly appreciated!
> 
> Thanks,
> CB
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Importing QIF results into duplicate entry

[Chitresh Bhushan]

Hi all,

I am trying to switch to gnucash. I have exported all my data in QIF format
from the old software I was using, moneyguru (
https://github.com/hsoft/moneyguru). However, when I import the exported
QIF file in gnucash, I see a lot of duplicate entries in gnucash, resulting
to incorrect balances. Moneyguru also uses double-entry accounting, so I
was hoping this transition would be easy.

To reproduce the behavior, I have linked below a sample (tiny) QIF file
exported from moneyguru. Can someone take a look and check if the file
format is correct? Or am I doing something wrong during the import? I am
new to gnucash and using gnucash 2.6.19 on Ubuntu.

The sample file generates duplicates in checking and credit-card accounts
(for $980 entry) on importing. My actual data has more than 8 yrs of
entries.. so its quite big with a lot of duplicates.

Sample QIF file exported from moneyguru:
https://peep.updog.co/shared/tiny_export.qif (381 bytes)

Any help is highly appreciated!

Thanks,
CB
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Account ID when importing CSV Transactions

[Geert Janssens]

Op maandag 19 november 2018 01:59:18 CET schreef David Carlson:
> I have been using GnuCash for many years and I am still using release
> 2.6.17 or similar depending on which computer I am using.  I just noticed
> that when I am importing a CSV transactions file and I get to the step to
> determine which account to import the transactions into, the list of
> accounts shows a column named Account ID.  I had previously assumed that
> this was the description column from the Chart of Accounts page, but today
> the accont that I was importing into did not have an account ID in the
> import page but many other accounts do have ID's and most of them match the
> description because that is where I have customarily put the accont number.
> 
> There is no column in the Chart of Accounts page called Account ID or
> containing the same information.  How can I put the missing account number
> into the Account ID column if I cannot see it?

Account ID is not something you can set on an account directly. IIRC it 
originally comes from the csv import data's account column. GnuCash uses this 
to map the value of that column with a real account within GnuCash.

In GnuCash 3.3 you can view/delete this information via a separate dialog.

Regards,

Geert


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Account ID when importing CSV Transactions

[David Carlson]

I have been using GnuCash for many years and I am still using release
2.6.17 or similar depending on which computer I am using.  I just noticed
that when I am importing a CSV transactions file and I get to the step to
determine which account to import the transactions into, the list of
accounts shows a column named Account ID.  I had previously assumed that
this was the description column from the Chart of Accounts page, but today
the accont that I was importing into did not have an account ID in the
import page but many other accounts do have ID's and most of them match the
description because that is where I have customarily put the accont number.

There is no column in the Chart of Accounts page called Account ID or
containing the same information.  How can I put the missing account number
into the Account ID column if I cannot see it?


David C
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Upgrade and Importing

[David Carlson]

Congratulations to Sunfish62 and Fell for doing an incredible job of
revising that page https://wiki.gnucash.org/wiki/Backup.
to make it very easy to read and removing all the fluff.

David C

On Thu, Oct 25, 2018 at 12:31 PM D via gnucash-user <
gnucash-user@gnucash.org> wrote:

> Just copy them. See https://wiki.gnucash.org/wiki/Backup.
>
> On October 25, 2018, at 10:29 PM, Nigel Freestone <
> ni...@paracletesystems.co.uk> wrote:
>
> I have GNU 2.4 on an old rapidly dying PC (Win 7)
>
> I now have the latest version (3.3) on a new PC (Win 10)
>
> How do I get my two sets of accounts data (Work and Home) from the old PC
> into the new one?
>
> Thanks for your help
>
> Nigel
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Upgrade and Importing

[D via gnucash-user]

Just copy them. See https://wiki.gnucash.org/wiki/Backup.

On October 25, 2018, at 10:29 PM, Nigel Freestone 
 wrote:

I have GNU 2.4 on an old rapidly dying PC (Win 7)

I now have the latest version (3.3) on a new PC (Win 10)

How do I get my two sets of accounts data (Work and Home) from the old PC
into the new one?

Thanks for your help

Nigel

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Upgrade and Importing

[Nigel Freestone]

I have GNU 2.4 on an old rapidly dying PC (Win 7)

I now have the latest version (3.3) on a new PC (Win 10)

How do I get my two sets of accounts data (Work and Home) from the old PC
into the new one?

Thanks for your help

Nigel

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Exporting and Importing CSV Transactions from One Book to Another

[David Cousens]

Melissa

You should export with the default conditions, i.e. only comma separated in the 
first panel and make sure the file is
labelled with a csv extension. 

When importing, after selecting the file to import in the second panel in the 
"Load and Save Settings" box select the
"GnuCash  Export Settings" from the drop down list.  Check the data format is 
correct for your data, Select the number
of lines to skip (usually 1) for the headers in the file. Match the column 
names to the header names of the exported
file. You will need to select deposit for the column labelled Amount with SYm 
in the exported file and select the Full
Account Name column for Account and not set the Transaction ID, i.e None. When 
you get to the Transaction Match page
correct any lines which do not have the correct trnsfer account specified ( or 
have Imbalance specified as the transfer
account then   press import. If your accounts are tyhe same in both books it 
should be imported.

Unfortunately the importer has changed considerably in V3 so the previous 
instructions are not valid. Thjey have been
rewritten but have not yet been updated in the documentation.

David Cousens


On Mon, 2018-10-15 at 13:33 -0400, Scales Office wrote:
> Hi I have a question about GnuCash's export and import function. I am
> trying to import CSV transactions from one book to another. I researched
> the same question on google and found a helpful response that said to
> update to GnuCash 3.1 or higher and I have updated to 3.3 but after
> following all of the instructions to export with "semicolon" separators and
> "quotes" marked, I selected everything correctly (or so I thought) but it
> seems despite all of the lines not being highlighted in red, it let me
> continue to import but wouldn't load or actually continue. I thought maybe
> it was just a lot to load so I waited a long time but it didn't work and I
> tried multiple times.
> 
> Would you be able to give me a step by step how to for exporting and
> importing transactions from one book to another?
> 
> Thank you in advance for your help,
> 
> Melissa
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Exporting and Importing CSV Transactions from One Book to Another

[Scales Office]

Hi I have a question about GnuCash's export and import function. I am
trying to import CSV transactions from one book to another. I researched
the same question on google and found a helpful response that said to
update to GnuCash 3.1 or higher and I have updated to 3.3 but after
following all of the instructions to export with "semicolon" separators and
"quotes" marked, I selected everything correctly (or so I thought) but it
seems despite all of the lines not being highlighted in red, it let me
continue to import but wouldn't load or actually continue. I thought maybe
it was just a lot to load so I waited a long time but it didn't work and I
tried multiple times.

Would you be able to give me a step by step how to for exporting and
importing transactions from one book to another?

Thank you in advance for your help,

Melissa
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Importing QIF from Quicken to set up new file

[Adrien Monteleone]

Macs used to be limited (at least as of Snow Leopard) to only re-sizing windows 
via the bottom right corner’s drag handle.

I don’t recall when that changed, but certainly on High Sierra (I’m using it as 
well) you can hover over any window side at any point, the pointer will change 
to an arrow or double-arrow, and you click-drag to resize.

I just tested this with that particular import window and it works fine to 
re-size. I did notice that it first opened full width (not full height) which 
for me is 1920px. I was able to resize it to a narrower window with no issues 
and a subsequent re-launch of the Import QIF feature remembered my new size.

Testing the TAB order on the File selection screen (I don’t have a real file to 
test any further) I see that after I tab away from the main portion of the 
window to the action buttons at the bottom, ’Next’ is the third button. (after 
Cancel and Back) So presumably, 3 TABs and you should be at ’Next’. If you want 
to test this, I would recommend hitting TAB 4 times instead. This should bring 
you back to somewhere near the first button or entry field in the main part of 
the window. (which will highlight blue) You can then safely hit Shift-TAB to 
back up one element and be back at ’Next’ in focus where you can then hit the 
spacebar or ENTER to proceed.

Extra tip - if on the 3rd TAB, you end up back at the beginning of the main 
window, then ’Next’ is not activated because you have required data entry 
missing. The TAB entries are skipping that element because it is not available 
yet. (but physically there, the text is greyed out)

Hope that helps.

Regards,
Adrien

> On Oct 15, 2018, at 4:30 AM, Liz  wrote:
> 
> On Fri, 12 Oct 2018 12:52:37 -0500
> Tom Goodhart  wrote:
> 
>> When I am in the middle of the Import QIF process, the window that
>> lists each security and asks for info for each is so long that I
>> can't see the buttons for Next, etc at the bottom of the window and I
>> cannot scroll down. What is the default response or how can I see the
>> bottom of the window? Are there keystroke shortcuts?
>> 
>> Tom
>> Mac OS-X High Sierra. GnuCash 3.3
> 
> I'm not on Mac.
> I can make my window smaller. 
> There is not an obvious keyboard shortcut for "Next"
> You could try tabbing through but would need to work out how many times
> to press "Tab". It could be a recipe for disaster.
> 
> Liz
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Importing QIF from Quicken to set up new file

[Liz]

On Fri, 12 Oct 2018 12:52:37 -0500
Tom Goodhart  wrote:

>  When I am in the middle of the Import QIF process, the window that
> lists each security and asks for info for each is so long that I
> can't see the buttons for Next, etc at the bottom of the window and I
> cannot scroll down. What is the default response or how can I see the
> bottom of the window? Are there keystroke shortcuts?
> 
> Tom
> Mac OS-X High Sierra. GnuCash 3.3

I'm not on Mac.
I can make my window smaller. 
There is not an obvious keyboard shortcut for "Next"
You could try tabbing through but would need to work out how many times
to press "Tab". It could be a recipe for disaster.

Liz
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Importing QIF from Quicken to set up new file

[Tom Goodhart]

 When I am in the middle of the Import QIF process, the window that lists
each security and asks for info for each is so long that I can't see the
buttons for Next, etc at the bottom of the window and I cannot scroll down.
What is the default response or how can I see the bottom of the window?
Are there keystroke shortcuts?

Tom
Mac OS-X High Sierra. GnuCash 3.3
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Error importing quicken 2017 qif / qfx

[Maf. King]

On Monday, 17 September 2018 17:10:10 BST Diogo Maciel wrote:
> I think it's a bug in the 3.2 version. Installed the 2.6 version and it
> imported without problems
> 

Or, logically, it could be a bug in 2.6.x to allow something bogus into GC 
(that has been fixed in 3.x)? 

0.02
Maf.



___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Error importing quicken 2017 qif / qfx

[Diogo Maciel]

I think it's a bug in the 3.2 version. Installed the 2.6 version and it
imported without problems

On Mon, Sep 17, 2018, 20:24 David T.,  wrote:

> Hello,
>
> In fact, the error is quite clear: something in the QIF file is not as the
> importer expects. As another David has noted, the QIF importer itself is
> functional, and has worked for many users before you. Unfortunately, in
> this case, that erro message is not particularly helpful, as your QIF file
> probably has a lot of transactions in it, any one of which could have
> caused the error. Locating such errors is, quite simply, a challenge.
>
> You might open your QIF file and try to determine whether anything looks
> out of order there, although that is difficult.
>
> You don’t say where you are located, but one of the most common situations
> that causes this error is date formatting. GnuCash attempts to guess
> whether you follow US-style date (MM-DD-) or European-style
> (DD-MM-), but often it fails to guess correctly. I believe it defaults
> to US-style (but I am sure the experts will correct me on this).
>
> One way forward for you at this time would be to try using a subset of
> your data to test the import first; if you can figure out how to get a
> smaller file to import, it will make additional imports easier. Many
> actually recommend using this piece-by-piece approach for import for this
> very reason.
>
> David
>
>
> > On Sep 16, 2018, at 12:19 PM, Diogo Maciel 
> wrote:
> >
> > Hi, hope someone can help me move out from Quicken
> >
> >
> >
> > I tried exporting my data from Quicken in both qif and qfx. The qif
> importer
> > gives me the error below
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > Qfx will only show an empty window
> >
> >
> >
> >
> >
> >
> >
> > My file has multiple securities and currencies, so this may be relevant.
> I
> > understand that with such a generic error one may need more information,
> > which I can surely provide.
> >
> >
> >
> > Thanks!
> >
> >
> ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -
> > 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Error importing quicken 2017 qif / qfx

[David T. via gnucash-user]

> On Sep 17, 2018, at 10:17 AM, cicko  wrote:
> 
> GnuCash - User mailing list wrote
>> It’s not clear that the OP has determined that the content of their QIF
>> file is properly structured ...
>> 
>> The bug to which you refer addresses a very particular aspect of QIF
>> import, while the OP is having troubles importing their Quicken data for
>> the first time.
> 
> I hope you are not implying that a .qif file exported from Quicken, the
> maker of the QIF standard, is "not properly structured". :)

Quicken has been known to play fast and loose with its own “standard” on 
numerous occasions. Regardless, I thought that my further comments regarding 
date formats were a clear example of how ambiguities in the data set could 
result in errors on import. Perhaps I wasn’t clear enough on that point.

> 
> The OP has indicated that he has "multiple securities and currencies" which
> sounds pretty much with the scenario I had when the import failed. It could
> very well be the exact same issue.
> 
> However, without a more comprehensive error message or a log we won't be
> able to know more. One thing for the OP would be to check the GC log files,
> which are generally placed in the Temp folder.
> 
> Not sure if that is convenient here, but I ended up manually entering all
> the investment transactions for the financial year and not importing the
> historical transactions due to this issue. 
> 
> 
> 
> --
> 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-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Error importing quicken 2017 qif / qfx

[David T. via gnucash-user]

Hello,

In fact, the error is quite clear: something in the QIF file is not as the 
importer expects. As another David has noted, the QIF importer itself is 
functional, and has worked for many users before you. Unfortunately, in this 
case, that erro message is not particularly helpful, as your QIF file probably 
has a lot of transactions in it, any one of which could have caused the error. 
Locating such errors is, quite simply, a challenge. 

You might open your QIF file and try to determine whether anything looks out of 
order there, although that is difficult.

You don’t say where you are located, but one of the most common situations that 
causes this error is date formatting. GnuCash attempts to guess whether you 
follow US-style date (MM-DD-) or European-style (DD-MM-), but often it 
fails to guess correctly. I believe it defaults to US-style (but I am sure the 
experts will correct me on this).

One way forward for you at this time would be to try using a subset of your 
data to test the import first; if you can figure out how to get a smaller file 
to import, it will make additional imports easier. Many actually recommend 
using this piece-by-piece approach for import for this very reason.

David


> On Sep 16, 2018, at 12:19 PM, Diogo Maciel  wrote:
> 
> Hi, hope someone can help me move out from Quicken
> 
> 
> 
> I tried exporting my data from Quicken in both qif and qfx. The qif importer
> gives me the error below
> 
> 
> 
> 
> 
> 
> 
> 
> 
> Qfx will only show an empty window
> 
> 
> 
> 
> 
> 
> 
> My file has multiple securities and currencies, so this may be relevant. I
> understand that with such a generic error one may need more information,
> which I can surely provide.
> 
> 
> 
> Thanks!
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Error importing quicken 2017 qif / qfx

[David T. via gnucash-user]

I think it’s a little premature to refer to this bug. 

It’s not clear that the OP has determined that the content of their QIF file is 
properly structured and being properly interpreted by the GnuCash importer—and 
that is a more profitable avenue for them to explore at this time.

The bug to which you refer addresses a very particular aspect of QIF import, 
while the OP is having troubles importing their Quicken data for the first time.

> On Sep 17, 2018, at 3:16 AM, cicko  wrote:
> 
> You may want to subscribe to this issue and add any extra information you
> find useful:
> https://bugs.gnucash.org/show_bug.cgi?id=788474
> 
> 
> 
> 
> --
> 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-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Error importing quicken 2017 qif / qfx

[David Cousens]

Diego,

I have just imported an example file given in the W3C article on QIF format
(https://www.w3.org/2000/10/swap/pim/qif-doc/QIF-doc.htm) without any
problem using the Import QIF wizard  ( have to cut off the comments on the
end of the lines).A copy of the file is attached example1.qif
  . I don't
use qif files or Quicken so it was the only qif files I could dig up
quickly.  You may want to check your file out against the format description
given in that article.

There is also a QFX file viewer available on this page you can check the 
.qfx file with (https://fileinfo.com/extension/qfx).  that file vewer should
also be able to open the QIF file as well.

the manual entry for QIF importer is here 
https://www.gnucash.org/docs/v3/C/gnucash-help/import-qif.html


And  migration from Quicken is covered here  
https://wiki.gnucash.org/wiki/Quicken_Migration

David Cousens



-
David Cousens
--
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-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Error importing quicken 2017 qif / qfx

[cicko]

You may want to subscribe to this issue and add any extra information you
find useful:
https://bugs.gnucash.org/show_bug.cgi?id=788474




--
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-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Error importing quicken 2017 qif / qfx

[Diogo Maciel]

Hi, hope someone can help me move out from Quicken

 

I tried exporting my data from Quicken in both qif and qfx. The qif importer
gives me the error below

 



 

 

Qfx will only show an empty window

 



 

My file has multiple securities and currencies, so this may be relevant. I
understand that with such a generic error one may need more information,
which I can surely provide.

 

Thanks!

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Importing csv transactions

[Geert Janssens]

In addition to the other suggestions, does your csv file contain a line with 
column titles ? If so, you may have to configure the importer to skip that 
line.

Regards,

Geert

Op dinsdag 11 september 2018 02:10:40 CEST schreef David Carlson:
> Paul,
> 
> Actually, during the CSV format you can scroll down the data that you are
> about to import to see if there are any lines that will prevent the
> import.  Just scroll down the date column to see if there are any dates
> that do not match your selected date format.  From experience I can tell
> you that it is very easy to make a mistake in this column, as, at least in
> the release 2.6.xx family of GnuCash releases, the default did not match
> common usage in the US.
> 
> David C
> 
> On Mon, Sep 10, 2018 at 5:32 PM GTI .H  wrote:
> > Probably some date (maybe three) in your CSV file is in the wrong format.
> > Open your CSV file in an editor and check the format of the dates.
> > 
> > Regards
> > GTI
> > 
> > Em seg, 10 de set de 2018 às 18:19, Paul Konnersman 
> > 
> > escreveu:
> > > I'm new to Gnucash and trying to get set up. I successfully imported a
> > > couple of years worth of transactions into one account a few months ago
> > > when I was evaluating Gnucash. Now I'm trying to import more
> > > transactions
> > > into that same account without success.
> > > 
> > > My process:
> > > 1) Menu Bar> File> Input> Import Transactions from CSV
> > > 2) Navigate to CSV file to be imported
> > > 3) Set Date format to y-m-d
> > > 4) Set currency format to "period"
> > > 5) Map columns in imported file to columns in Gnucash
> > > 
> > >1. Date -> Date
> > >2. Num -> Num
> > >3. Description -> Action
> > >4. Account -> Transfer
> > >5. Notes -> C
> > >6. Deposit -> Debit Amount
> > >7. None -> Credit Amount
> > >8. None -> Balance
> > > 
> > > 6) I get a notice repeated three times that reads, "Date Column could
> > > not
> > > be understood."
> > > 
> > > Any suggestions will be appreciated.
> > > 
> > > Paul
> > > 
> > > --
> > > *Paul M. Konnersman*
> > > *konners...@gmail.com *
> > > *781-639-0616*
> > > ___
> > > gnucash-user mailing list
> > > gnucash-user@gnucash.org
> > > To update your subscription preferences or to unsubscribe:
> > > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > > If you are using Nabble or Gmane, please see
> > > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > > -
> > > Please remember to CC this list on all your replies.
> > > You can do this by using Reply-To-List or Reply-All.
> > 
> > --
> > Regards
> > GTI
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see
> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -
> > 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
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Importing csv transactions

[David Carlson]

Paul,

Actually, during the CSV format you can scroll down the data that you are
about to import to see if there are any lines that will prevent the
import.  Just scroll down the date column to see if there are any dates
that do not match your selected date format.  From experience I can tell
you that it is very easy to make a mistake in this column, as, at least in
the release 2.6.xx family of GnuCash releases, the default did not match
common usage in the US.

David C

On Mon, Sep 10, 2018 at 5:32 PM GTI .H  wrote:

> Probably some date (maybe three) in your CSV file is in the wrong format.
> Open your CSV file in an editor and check the format of the dates.
>
> Regards
> GTI
>
> Em seg, 10 de set de 2018 às 18:19, Paul Konnersman 
> escreveu:
>
> > I'm new to Gnucash and trying to get set up. I successfully imported a
> > couple of years worth of transactions into one account a few months ago
> > when I was evaluating Gnucash. Now I'm trying to import more transactions
> > into that same account without success.
> >
> > My process:
> > 1) Menu Bar> File> Input> Import Transactions from CSV
> > 2) Navigate to CSV file to be imported
> > 3) Set Date format to y-m-d
> > 4) Set currency format to "period"
> > 5) Map columns in imported file to columns in Gnucash
> >
> >1. Date -> Date
> >2. Num -> Num
> >3. Description -> Action
> >4. Account -> Transfer
> >5. Notes -> C
> >6. Deposit -> Debit Amount
> >7. None -> Credit Amount
> >8. None -> Balance
> >
> > 6) I get a notice repeated three times that reads, "Date Column could not
> > be understood."
> >
> > Any suggestions will be appreciated.
> >
> > Paul
> >
> > --
> > *Paul M. Konnersman*
> > *konners...@gmail.com *
> > *781-639-0616*
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see
> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> >
>
>
> --
> Regards
> GTI
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Importing csv transactions

[GTI .H]

Probably some date (maybe three) in your CSV file is in the wrong format.
Open your CSV file in an editor and check the format of the dates.

Regards
GTI

Em seg, 10 de set de 2018 às 18:19, Paul Konnersman 
escreveu:

> I'm new to Gnucash and trying to get set up. I successfully imported a
> couple of years worth of transactions into one account a few months ago
> when I was evaluating Gnucash. Now I'm trying to import more transactions
> into that same account without success.
>
> My process:
> 1) Menu Bar> File> Input> Import Transactions from CSV
> 2) Navigate to CSV file to be imported
> 3) Set Date format to y-m-d
> 4) Set currency format to "period"
> 5) Map columns in imported file to columns in Gnucash
>
>1. Date -> Date
>2. Num -> Num
>3. Description -> Action
>4. Account -> Transfer
>5. Notes -> C
>6. Deposit -> Debit Amount
>7. None -> Credit Amount
>8. None -> Balance
>
> 6) I get a notice repeated three times that reads, "Date Column could not
> be understood."
>
> Any suggestions will be appreciated.
>
> Paul
>
> --
> *Paul M. Konnersman*
> *konners...@gmail.com *
> *781-639-0616*
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


-- 
Regards
GTI
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Importing csv transactions

[Paul Konnersman]

I'm new to Gnucash and trying to get set up. I successfully imported a
couple of years worth of transactions into one account a few months ago
when I was evaluating Gnucash. Now I'm trying to import more transactions
into that same account without success.

My process:
1) Menu Bar> File> Input> Import Transactions from CSV
2) Navigate to CSV file to be imported
3) Set Date format to y-m-d
4) Set currency format to "period"
5) Map columns in imported file to columns in Gnucash

   1. Date -> Date
   2. Num -> Num
   3. Description -> Action
   4. Account -> Transfer
   5. Notes -> C
   6. Deposit -> Debit Amount
   7. None -> Credit Amount
   8. None -> Balance

6) I get a notice repeated three times that reads, "Date Column could not
be understood."

Any suggestions will be appreciated.

Paul

--
*Paul M. Konnersman*
*konners...@gmail.com *
*781-639-0616*
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Gnucash unresponsive when importing large Bills & Invoices file

[Nelson Handcock]

Hello All,

This is not reported as a bug (yet) but will do so if initial responses
suggest it's warranted.

I'm running Gnucash Version 3.1


I prepared a csv file to import a number of invoices - about 900 or so. The
spreadsheet file contained about 1300 rows. Some invoices are multi-item -
I've found GN imports multiple items into a single invoice if they are
numbered identically and grouped together in the import file.


With earlier versions it always worked fine. It always took a few minutes
and sometime I wondered if it would finish, but it always seemed to.

Also with earlier versions, the imported invoices were "unsaved" which was
great, because if I realised I had a problem and I wanted to discard the
import, then I could close the file without saving changes.


With version 3.1, I have experienced GN failing to import the full file. The
application is viewed by Windows 10 as "unresponsive", and if you aren't
doing anything, then your PC may time out/go to sleep, and I think from
that point the whole import process dies.

I eventually got my import completed by chopping my initial file up into 3
smaller ones.

I have also noticed that in Version 3.1 that the gnucash file saves itself
on completion of the import... you no longer have the opportunity to "Exit
without saving". This can be resolved by making sure you keep a copy of the
file before you run the import so you have a back-up, so it's not the end
of the world I guess.

Thoughts/Comments anyone?


Thanks & Regards,

Nelson Handcock
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Transaction matcher window blank when importing QFX

[Bo Laurent]

Whoops; never mind. I now see that the import was successful, but I didn't
notice that. I was apparently trying to re-import, and gnucash successfully
noticed that all the transactions had already been imported.

Bo
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Transaction matcher window blank when importing QFX

[Bo Laurent]

I'm brand new to gnucash, but it sure looks like I am encountering Bug
793461, though that was reported fixed.

GnuCash Version: 3.2
Build ID: 3.2+ (2018-06-24)
Finance::Quote: -

OSX High Sierra 10.13.5 (17F77)

I successfully imported data from two accounts at Redwood Credit Union
(checking and mortgage), but when trying to import my Visa credit card
account, I get the blank screen. Deleting all relevant entries for
that account in Tools/Import Map Editor did not help.


Suggestions for how to proceed, please?


Thanks,


Bo
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Issue importing MT940 files

[lemonnie...@bluewin.ch]

Hi.
It seems that Gnucash is not reading in the full character string for the 
identity of the account for a MT940 import (line identifier :25:).  For me, it 
is reading up to the last but one character.  I have 2 accounts where only the 
last digit is different and thus it cannot recognise a difference in the 
accounts.  I thought that I had made a mistake, but having studied the issue, 
it is in the software - in the assignment window for 'Select Account', the 
description at the top states (Full account ID: ) and lacking the last 
character.  Workaround is to manually change before import and that works, but 
something has changed since the 2.6 version, where it was working fine for 
these accounts.  I just installed 3.2 and the error is still present.
Jake
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] importing (QIF/OFX)

[David Carlson]

Jeff,

I think the best answer to your question would be whatever provides the
most direct route from your source to GnuCash.

That may also change when you migrate to release 3.2 or later of GnuCash.
That release has a much improved CSV importer and the other importers have
better transaction matching.  Before migrating carefully read the known bug
list in the release announcement to see if there is a deal breaker for your
use.

David C

On Wed, Jun 27, 2018 at 2:07 PM, Jeff Abrahamson  wrote:

> I wanted to import a bunch of transactions.  I had a CSV file, which
> gnucash (2.6.19) doesn't like to import.  So I wrote a quick CSV to QIF
> translator.  This worked, it recognized account names even though I
> provided only the tail, and it correctly caught duplicates.  But a
> couple quibbles: I'm wondering if they are inevitable.
>
> - The importer asks me a lot of questions. ;-)
>
> - When it finds matching transactions (because I tested importing the
> same file a second time to make sure it wouldn't do it quietly), it
> proposed matches.  (Good!)  In my case, every transaction had a unique
> transaction id (the "number" field in gnucash, the N prefix in QIF) but
> most of the transactions had one of a handful of values.  I would have
> thought that 20180515-XQUFEF-3 would be matched uniquely, but it's not.
> I'm proposed every transaction with that value.
>
> These aren't deal-killers, but it does make automation feel like a weak
> concept.  I'm wondering if I can optimise better.
>
> In passing, since I'll surely write more of these converters, would I
> have been better off converting to OFX?  QIF simply had the advantage of
> being dead simple, permitting splits, and having a wikipedia page that
> describes the format.
>
> Thanks!
>
> --
>
> Jeff Abrahamson
> +33 6 24 40 01 57
> +44 7920 594 255
>
> http://p27.eu/jeff/
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] importing (QIF/OFX)

[Jeff Abrahamson]

I wanted to import a bunch of transactions.  I had a CSV file, which
gnucash (2.6.19) doesn't like to import.  So I wrote a quick CSV to QIF
translator.  This worked, it recognized account names even though I
provided only the tail, and it correctly caught duplicates.  But a
couple quibbles: I'm wondering if they are inevitable.

- The importer asks me a lot of questions. ;-)

- When it finds matching transactions (because I tested importing the
same file a second time to make sure it wouldn't do it quietly), it
proposed matches.  (Good!)  In my case, every transaction had a unique
transaction id (the "number" field in gnucash, the N prefix in QIF) but
most of the transactions had one of a handful of values.  I would have
thought that 20180515-XQUFEF-3 would be matched uniquely, but it's not. 
I'm proposed every transaction with that value.

These aren't deal-killers, but it does make automation feel like a weak
concept.  I'm wondering if I can optimise better.

In passing, since I'll surely write more of these converters, would I
have been better off converting to OFX?  QIF simply had the advantage of
being dead simple, permitting splits, and having a wikipedia page that
describes the format.

Thanks!

-- 

Jeff Abrahamson
+33 6 24 40 01 57
+44 7920 594 255

http://p27.eu/jeff/


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Problems importing credit card transactions via CSV formatted file.

[David Carlson]

John,

I have been told that the current release 3.1 of GnuCash has a greatly
improved CSV importer compared to the importer in the release 2.6.x series.
However, some of us have not updated because of certain regressions in that
release.  We are stuck with a cumbersome CSV importer.  I have noticed that
if I consistently assign the amount column of credit card accounts to
WITHDRAWAL the numbers come in with the correct sign, except for one rogue
account that does not follow the same format.

There is a list of a number of tools posted here <
https://wiki.gnucash.org/wiki/Published_tools> which includes a CSV to QIF
converter which you might find useful.

David C

On Wed, Jun 13, 2018 at 2:14 PM, John Clark via gnucash-user <
gnucash-user@gnucash.org> wrote:

> One of the problems I’ve found with gnucash is in the area of importing
> CSV formatted transactions. I figured out how to do it reasonably well for
> my
> bank statements, and now I’m turning my attention to my credit card
> accounts.
>
> I’m trying to enter in data that spans several years, and I have a
> collection of CSV files. In most cases I don’t have the ability to go back
> and get
> the data in a different format, such as some sort of Quicken file.
>
> When I import the translations, I use the following selection for columns.
>
> DATE, DESCRIPTION, DEPOSIT (or WITHDRAWAL, I’ve done both)
>
> After the file has been processed, and the screen comes up to commit the
> transactions, there are lines that are Green and Yellow. Some have the
> “Liability:Credit Card:XXX” some have “unbalanced USD” designation.
>
> But worse, there are some numbers that are negative, and some which are
> positive. And when I do import the results, the numbers, negative or
> positive, end up scattered between Payment and Credit columns.
>
> Since I’m trying to import 100s of transactions it is very tedious to even
> think about going through each item and correcting the negative sign, etc.
>
> Since there does not seem to be a ‘bulk’ process for selecting a large
> number of transactions and happing the same transaction assignment on all
> of the selected items, this is a major hiccup in
> using gnucash for me.
>
> Any assistance would be appreciated.
>
> John Clark.
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Problems importing credit card transactions via CSV formatted file.

[John Clark via gnucash-user]

One of the problems I’ve found with gnucash is in the area of importing CSV 
formatted transactions. I figured out how to do it reasonably well for my
bank statements, and now I’m turning my attention to my credit card accounts.

I’m trying to enter in data that spans several years, and I have a collection 
of CSV files. In most cases I don’t have the ability to go back and get 
the data in a different format, such as some sort of Quicken file.

When I import the translations, I use the following selection for columns.

DATE, DESCRIPTION, DEPOSIT (or WITHDRAWAL, I’ve done both)

After the file has been processed, and the screen comes up to commit the 
transactions, there are lines that are Green and Yellow. Some have the 
“Liability:Credit Card:XXX” some have “unbalanced USD” designation.

But worse, there are some numbers that are negative, and some which are 
positive. And when I do import the results, the numbers, negative or positive, 
end up scattered between Payment and Credit columns.

Since I’m trying to import 100s of transactions it is very tedious to even 
think about going through each item and correcting the negative sign, etc.

Since there does not seem to be a ‘bulk’ process for selecting a large number 
of transactions and happing the same transaction assignment on all of the 
selected items, this is a major hiccup in 
using gnucash for me.

Any assistance would be appreciated.

John Clark.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] GnuCash 3.1-3 freezes when importing OFX file on Mac

[John Ralls]

> On Jun 10, 2018, at 5:24 AM, Brendan Simon  wrote:
> 
> I just tried GnuCash 3.1-3 on Mac, and it freezes when trying to import
> a small OFX file (downloaded from my bank).  The cursor just turns into
> a spinning beach ball and the app otherwise doesn't respond.
> 
> The OFX file imports just fine with GnuCash-2.6.21-2.
> 
> The OFX file comes from an Australian bank.  I thought it might be
> related to the following bug, but the dates in my OFX file look to be
> ISO format (MMDD).
> 
> https://bugzilla.gnome.org/show_bug.cgi?id=795347
> 
> Any ideas how to solve this?  Right now I'm stuck on 2.6.21-2.

It’s probably updating the matching accounts from account names to GUIDs. If 
you have a lot of import history on the account that can take a while. It’s a 
one-time change so once you let it complete imports will once again be at their 
usual speed.

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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] GnuCash 3.1-3 freezes when importing OFX file on Mac

[Brendan Simon]

I just tried GnuCash 3.1-3 on Mac, and it freezes when trying to import
a small OFX file (downloaded from my bank).  The cursor just turns into
a spinning beach ball and the app otherwise doesn't respond.

The OFX file imports just fine with GnuCash-2.6.21-2.

The OFX file comes from an Australian bank.  I thought it might be
related to the following bug, but the dates in my OFX file look to be
ISO format (MMDD).

https://bugzilla.gnome.org/show_bug.cgi?id=795347

Any ideas how to solve this?  Right now I'm stuck on 2.6.21-2.

Brendan.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Need User friendly guide to importing qfx file

[BC]

I'm using v3.1 and OFX import works on Windows10.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Need User friendly guide to importing qfx file

[D via gnucash-user]

FYI: ofx and qfx are, as I understand, functionally equivalent. OFX is the 
generic version, while QFX is Quicken's version of the same.

David T

On May 17, 2018, at 4:47 PM, Dennis Powless <claven...@gmail.com> wrote:

Is qfx the only output/export you get from your bank?  If you can try ofx  
or try to do the export again, change the parameters on the export ie dates.  
Make sure you’re in the account you’re importing to, ie that register is open.  

Dennis

Sent from my iPhone

> On May 16, 2018, at 4:18 PM, eNews <kken...@gmail.com> wrote:
> 
> Hello!
> 
> 
> 
> I am new to GnuCash and attempted my first import of a qfx file from my
> bank.  When I import the file, the "Generic import transaction matcher" is
> blank/empty.  Although I've researched the answers to similar questions, I
> do not understand the technical answers to them.  The closest I came to a
> solution was from 2014, but I am using version 3.0 uploaded in 2018.
> Wouldn't that bug be fixed by now?  Many of the answers discuss ofx, which I
> do not think applies to the qfx issue I am having.
> 
> 
> 
> I am an accounting end user with no experience in programming.  Can someone
> tell me in childlike laymen's terms how to get GnuCash to import a qfx file
> of my bank's transactions?  I am using Windows 10 Home.
> 
> 
> 
> So far I'm really happy with my conversion from Quicken to GnuCash, so I am
> determined to make this import work.
> 
> 
> 
> Thank you for your time.
> 
> 
> 
> Kate
> 
> 
> 
> ---
> This email has been checked for viruses by Avast antivirus software.
> https://www.avast.com/antivirus
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Need User friendly guide to importing qfx file

[David Carlson]

In Windows  Release 3.0 the OFX import is broken.

Either wait for release 3.2 or downgrade to 2.6.21 or lower, but at least
2.6.17 to avoid other missing features.

David C

On Thu, May 17, 2018, 6:48 AM Dennis Powless <claven...@gmail.com> wrote:

> Is qfx the only output/export you get from your bank?  If you can try
> ofx  or try to do the export again, change the parameters on the export
> ie dates.  Make sure you’re in the account you’re importing to, ie that
> register is open.
>
> Dennis
>
> Sent from my iPhone
>
> > On May 16, 2018, at 4:18 PM, eNews <kken...@gmail.com> wrote:
> >
> > Hello!
> >
> >
> >
> > I am new to GnuCash and attempted my first import of a qfx file from my
> > bank.  When I import the file, the "Generic import transaction matcher"
> is
> > blank/empty.  Although I've researched the answers to similar questions,
> I
> > do not understand the technical answers to them.  The closest I came to a
> > solution was from 2014, but I am using version 3.0 uploaded in 2018.
> > Wouldn't that bug be fixed by now?  Many of the answers discuss ofx,
> which I
> > do not think applies to the qfx issue I am having.
> >
> >
> >
> > I am an accounting end user with no experience in programming.  Can
> someone
> > tell me in childlike laymen's terms how to get GnuCash to import a qfx
> file
> > of my bank's transactions?  I am using Windows 10 Home.
> >
> >
> >
> > So far I'm really happy with my conversion from Quicken to GnuCash, so I
> am
> > determined to make this import work.
> >
> >
> >
> > Thank you for your time.
> >
> >
> >
> > Kate
> >
> >
> >
> > ---
> > This email has been checked for viruses by Avast antivirus software.
> > https://www.avast.com/antivirus
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -
> > 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
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Need User friendly guide to importing qfx file

[Dennis Powless]

Is qfx the only output/export you get from your bank?  If you can try ofx  
or try to do the export again, change the parameters on the export ie dates.  
Make sure you’re in the account you’re importing to, ie that register is open.  

Dennis

Sent from my iPhone

> On May 16, 2018, at 4:18 PM, eNews <kken...@gmail.com> wrote:
> 
> Hello!
> 
> 
> 
> I am new to GnuCash and attempted my first import of a qfx file from my
> bank.  When I import the file, the "Generic import transaction matcher" is
> blank/empty.  Although I've researched the answers to similar questions, I
> do not understand the technical answers to them.  The closest I came to a
> solution was from 2014, but I am using version 3.0 uploaded in 2018.
> Wouldn't that bug be fixed by now?  Many of the answers discuss ofx, which I
> do not think applies to the qfx issue I am having.
> 
> 
> 
> I am an accounting end user with no experience in programming.  Can someone
> tell me in childlike laymen's terms how to get GnuCash to import a qfx file
> of my bank's transactions?  I am using Windows 10 Home.
> 
> 
> 
> So far I'm really happy with my conversion from Quicken to GnuCash, so I am
> determined to make this import work.
> 
> 
> 
> Thank you for your time.
> 
> 
> 
> Kate
> 
> 
> 
> ---
> This email has been checked for viruses by Avast antivirus software.
> https://www.avast.com/antivirus
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Convincing my credit union to support online importing

[Jeff Albrecht]

Here in Arizona, USA Tuesday I attend the annual meeting of my credit 
union. I met with the Senior VP / Chief Information officer. We spoke 
about Quicken and it's rapid price hikes and move to subscription model. 
I told him a bit about GnuCash and that I had just converted to GnuCash 
and had imported a decade of Quicken data. I gave him some old school 
paper with some resources and my contact info. I asked if it would be 
possible to support online banking to support GnuCash. They do have a 
.OFX export. Yesterday he emailed to me;


   "... Intuit has ratcheted up their pricing model for several
   years and good to know there are viable options in the
   marketplace. We have connected with the team here at ___ and
   will look into GNUCash over the next few business days.  Can I
   get back with you by Friday, April 27^th ? My contact
   information is listed below.  Please don’t hesitate to reach out
   with additional ideas or questions."

They seem genuinely interested. I would like to gather up information 
that may be valuable to the credit union in researching and deciding to 
support it, and perhaps links to implementation resources.


Does anyone have links etc. I might want to read and share with my 
Credit Union? Beyond


 * "Setting up OFXDirectConnect in GnuCash 2"
   
https://wiki.gnucash.org/wiki/Setting_up_OFXDirectConnect_in_GnuCash_2#The_AqBanking_Set-up_Wizard
 * "AqBanking" https://wiki.gnucash.org/wiki/AqBanking

I'm also looking for

 * Press
 o public looking for their banks to support it
 o banks that have implemented
 + Success stories
 * Technical
 o Resources
 * ???

Has anyone on the list worked with a bank to convince and/or implement 
support for online connections?



Thanks, - Jeff

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Importing OFX fails with GnuCash 3.0?

[John Ralls]

Close. That lists the known bugs specific to 3.0 (i.e. not carried over from 
earlier versions) at the time of the release.

To see the current list of open bugs (until 1 June when Gnome shuts down 
bugzilla, anyway), go to https://bugzilla.gnome.org/query.cgi 
, select GnuCash in the product column, 
and click the search button. There are 1295 at the moment, so you’ll probably 
want to use some of the other filters on the search page to narrow it down a 
bit.

Regards,
John Ralls


> On Apr 9, 2018, at 1:15 PM, David Carlson  wrote:
> 
> Scroll down to the release announcement for 3.0 in
> https://www.gnucash.org/news.phtml then continue to the paragraph Known
> Problems...
> 
> There have been some additional messages here in the user maillist.
> 
> 
> David C
> 
> On Mon, Apr 9, 2018 at 3:04 PM, Thomas E Moughan  wrote:
> 
>> Thanks, David. I can work around it.
>> 
>> Is there a link where one can see current open bugs for GnuCash?
>> 
>> 
>> On Mon, Apr 9, 2018, 2:56 PM David Carlson 
>> wrote:
>> 
>>> Yes, that is a feature that is in the list of known bugs, so if you need
>>> that, do not upgrade.
>>> 
>>> David C
>>> 
>>> On Mon, Apr 9, 2018, 1:16 PM Thomas E Moughan  wrote:
>>> 
 Haven't see this reported, but when I upgraded from 2.6 to 3.0 on my
 Windows 10 device, I can't import OFX files from my Credit Union.
 
 The normal dialog box appears that would shows matches, but is completely
 blank except for the column headers. I did a Check and Repair all
 transactions, deleted all the records on the Import Map Editor, and
 removed
 the Account Code entries on these bank accounts.. nothing helped.
 
 Any ideas?
 Thanks!
 Tom Moughan
 ___
 gnucash-user mailing list
 gnucash-user@gnucash.org
 To update your subscription preferences or to unsubscribe:
 https://lists.gnucash.org/mailman/listinfo/gnucash-user
 If you are using Nabble or Gmane, please see
 https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
 -
 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
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Importing OFX fails with GnuCash 3.0?

[David Carlson]

Scroll down to the release announcement for 3.0 in
https://www.gnucash.org/news.phtml then continue to the paragraph Known
Problems...

There have been some additional messages here in the user maillist.


David C

On Mon, Apr 9, 2018 at 3:04 PM, Thomas E Moughan  wrote:

> Thanks, David. I can work around it.
>
> Is there a link where one can see current open bugs for GnuCash?
>
>
> On Mon, Apr 9, 2018, 2:56 PM David Carlson 
> wrote:
>
>> Yes, that is a feature that is in the list of known bugs, so if you need
>> that, do not upgrade.
>>
>> David C
>>
>> On Mon, Apr 9, 2018, 1:16 PM Thomas E Moughan  wrote:
>>
>>> Haven't see this reported, but when I upgraded from 2.6 to 3.0 on my
>>> Windows 10 device, I can't import OFX files from my Credit Union.
>>>
>>> The normal dialog box appears that would shows matches, but is completely
>>> blank except for the column headers. I did a Check and Repair all
>>> transactions, deleted all the records on the Import Map Editor, and
>>> removed
>>> the Account Code entries on these bank accounts.. nothing helped.
>>>
>>> Any ideas?
>>> Thanks!
>>> Tom Moughan
>>> ___
>>> gnucash-user mailing list
>>> gnucash-user@gnucash.org
>>> To update your subscription preferences or to unsubscribe:
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>> If you are using Nabble or Gmane, please see
>>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>>> -
>>> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Importing OFX fails with GnuCash 3.0?

[Thomas E Moughan]

Thanks, David. I can work around it.

Is there a link where one can see current open bugs for GnuCash?


On Mon, Apr 9, 2018, 2:56 PM David Carlson 
wrote:

> Yes, that is a feature that is in the list of known bugs, so if you need
> that, do not upgrade.
>
> David C
>
> On Mon, Apr 9, 2018, 1:16 PM Thomas E Moughan  wrote:
>
>> Haven't see this reported, but when I upgraded from 2.6 to 3.0 on my
>> Windows 10 device, I can't import OFX files from my Credit Union.
>>
>> The normal dialog box appears that would shows matches, but is completely
>> blank except for the column headers. I did a Check and Repair all
>> transactions, deleted all the records on the Import Map Editor, and
>> removed
>> the Account Code entries on these bank accounts.. nothing helped.
>>
>> Any ideas?
>> Thanks!
>> Tom Moughan
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using Nabble or Gmane, please see
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -
>> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Importing OFX fails with GnuCash 3.0?

[David Carlson]

Yes, that is a feature that is in the list of known bugs, so if you need
that, do not upgrade.

David C

On Mon, Apr 9, 2018, 1:16 PM Thomas E Moughan  wrote:

> Haven't see this reported, but when I upgraded from 2.6 to 3.0 on my
> Windows 10 device, I can't import OFX files from my Credit Union.
>
> The normal dialog box appears that would shows matches, but is completely
> blank except for the column headers. I did a Check and Repair all
> transactions, deleted all the records on the Import Map Editor, and removed
> the Account Code entries on these bank accounts.. nothing helped.
>
> Any ideas?
> Thanks!
> Tom Moughan
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Importing OFX fails with GnuCash 3.0?

[Thomas E Moughan]

Haven't see this reported, but when I upgraded from 2.6 to 3.0 on my
Windows 10 device, I can't import OFX files from my Credit Union.

The normal dialog box appears that would shows matches, but is completely
blank except for the column headers. I did a Check and Repair all
transactions, deleted all the records on the Import Map Editor, and removed
the Account Code entries on these bank accounts.. nothing helped.

Any ideas?
Thanks!
Tom Moughan
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Importing qfx files, version 3.0

[Jim Poklitar]

Thanks David - bummer.

Back to 2.6.19.

Jim P

On Wed, Apr 4, 2018 at 8:44 PM, David Carlson <david.carlson@gmail.com>
wrote:

> As noted in the release notes that feature is known to not work per
> https://bugzilla.gnome.org/show_bug.cgi?id=793461.
>
> It is not known exactly when that will be fixed.
>
> David C
>
> On Wed, Apr 4, 2018 at 7:42 PM, Jim Poklitar <jim.pokli...@gmail.com>
> wrote:
>
>> ​Until version 3.0, I could download and import .qfx transaction files
>> from
>> my bank for checking and savings ​accounts, as well as credit card
>> transactions from several sources.  File->Import->Import OFX/QFX for any
>> qfx suffixed files from any source worked flawlessly.
>>
>> With version 3.0, attempting to import any of these files yields a blank
>> "Generic import transaction matcher" window.  I've looked at Tools->Import
>> Map Editor, and see all my bank and credit card accounts in each of the
>> Bayesian, Non-Bayesian, and Online ID radio-button tabs, but there doesn't
>> seem to be any way to map a .qfx file.
>>
>> I have set up a couple csv mappings, but this seems to be a clumsy way of
>> doing things, compared to the v 2.xx way of doing things.
>>
>> What am I missing?  How can I restore the ease of importing .qfx files in
>> v
>> 3.0?
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using Nabble or Gmane, please see
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -
>> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Importing qfx files, version 3.0

[David Carlson]

As noted in the release notes that feature is known to not work per
https://bugzilla.gnome.org/show_bug.cgi?id=793461.

It is not known exactly when that will be fixed.

David C

On Wed, Apr 4, 2018 at 7:42 PM, Jim Poklitar <jim.pokli...@gmail.com> wrote:

> ​Until version 3.0, I could download and import .qfx transaction files from
> my bank for checking and savings ​accounts, as well as credit card
> transactions from several sources.  File->Import->Import OFX/QFX for any
> qfx suffixed files from any source worked flawlessly.
>
> With version 3.0, attempting to import any of these files yields a blank
> "Generic import transaction matcher" window.  I've looked at Tools->Import
> Map Editor, and see all my bank and credit card accounts in each of the
> Bayesian, Non-Bayesian, and Online ID radio-button tabs, but there doesn't
> seem to be any way to map a .qfx file.
>
> I have set up a couple csv mappings, but this seems to be a clumsy way of
> doing things, compared to the v 2.xx way of doing things.
>
> What am I missing?  How can I restore the ease of importing .qfx files in v
> 3.0?
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Importing Quicken

[David T. via gnucash-user]

When I did my import (over a decade ago, I believe), I had no problem with 
transfers. Since I was importing all in one pass, there were no duplicates 
created by transfers. 

I believe the duplication problem you describe specifically arises when you opt 
to import transaction data from individual accounts separately, since you have 
to tell the importer when a given transfer is already in the system from the 
other side. It’s precisely why I think it should NOT be the “preferred” way of 
importing from Quicken, since it forces the user to manually identify the other 
side of a transfer every time. That makes my head hurt just thinking about it. 

This is why I chose to run the Export-Import process iteratively, until I got 
the Quicken data massaged to my satisfaction. Then the imported data was all 
good.

Most of the challenge had to do with random category variations, and 
uncategorized transactions—which you well know will end up in IMBALANCE-USD.

David T.

> On Apr 4, 2018, at 7:16 PM, David Carlson <david.carlson@gmail.com> wrote:
> 
> David T,
> 
> Does the QIF importer detect duplicates created by transfers within the same 
> import file?  I seem to recall needing to separate accounts to different 
> files to detect them.
> 
> David C
> 
> On Wed, Apr 4, 2018 at 9:00 AM, David T. <sunfis...@yahoo.com 
> <mailto:sunfis...@yahoo.com>> wrote:
> Alen,
> 
> What you’ve done with the Benefits section is better, but I still feel that 
> any mention of benefits of migration is misplaced here. Someone looking for 
> ways to migrate from Quicken presumably has already come to this conclusion.
> 
> * I have edited the tips portion further. I added a tip regarding the whole 
> Categories/Accounts paradigm.
> 
> * I modified your tip regarding import of categories only, since it isn’t 
> strictly necessary.
> 
> I think it’s useful here to note that I didn’t have to either import the 
> account structure or individual accounts separately when I imported my large 
> QIF file way back in the dark ages—I simply exported everything in one big 
> QIF and did the import from that. That was when I discovered the holes in my 
> Quicken data. I chose to go back in to Quicken, fill in those holes, and 
> re-export the entire file again, repeating until I had a clean enough import 
> to move forward. I know that others have had a different experience.
> 
> * I modified the tip about multiple currencies to more accurately reflect the 
> situation and make it clear that the problem isn’t with GnuCash, but with QIF.
> 
> Cheers,
> David
> 
> > On Apr 4, 2018, at 12:52 PM, Alen Siljak <alen.sil...@gmx.com 
> > <mailto:alen.sil...@gmx.com>> wrote:
> >
> > Hi, David,
> >
> > You are right. I've removed the benefits section but kept the fact about 
> > open data standards. Apart from being a benefit (to me), it is also a 
> > consequence of migration that may or may not be important for users.
> >
> >> You mention multi-currency problems with QIF, saying that GnuCash only 
> >> handles one currency per file. However, I am under the impression that the 
> >> problem of multiple currencies had to do with the *QIF* specification, and 
> >> not GnuCash. In other words, the problem isn't that GnuCash doesn’t handle 
> >> multiple currencies, it’s that QIF doesn’t. Can anyone confirm that for me?
> >
> > Yes, that's probably true. However, if an application interprets a transfer 
> > in such a manner that it takes 100 Euros from one and then deposits 100 AUD 
> > into another account without warning the user, that's a big no-no for me.
> >
> > Thanks for the feedback!
> 
> 

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Importing Quicken

[David Carlson]

David T,

Does the QIF importer detect duplicates created by transfers within the
same import file?  I seem to recall needing to separate accounts to
different files to detect them.

David C

On Wed, Apr 4, 2018 at 9:00 AM, David T.  wrote:

> Alen,
>
> What you’ve done with the Benefits section is better, but I still feel
> that any mention of benefits of migration is misplaced here. Someone
> looking for ways to migrate from Quicken presumably has already come to
> this conclusion.
>
> * I have edited the tips portion further. I added a tip regarding the
> whole Categories/Accounts paradigm.
>
> * I modified your tip regarding import of categories only, since it isn’t
> strictly necessary.
>
> I think it’s useful here to note that I didn’t have to either import the
> account structure or individual accounts separately when I imported my
> large QIF file way back in the dark ages—I simply exported everything in
> one big QIF and did the import from that. That was when I discovered the
> holes in my Quicken data. I chose to go back in to Quicken, fill in those
> holes, and re-export the entire file again, repeating until I had a clean
> enough import to move forward. I know that others have had a different
> experience.
>
> * I modified the tip about multiple currencies to more accurately reflect
> the situation and make it clear that the problem isn’t with GnuCash, but
> with QIF.
>
> Cheers,
> David
>
> > On Apr 4, 2018, at 12:52 PM, Alen Siljak  wrote:
> >
> > Hi, David,
> >
> > You are right. I've removed the benefits section but kept the fact about
> open data standards. Apart from being a benefit (to me), it is also a
> consequence of migration that may or may not be important for users.
> >
> >> You mention multi-currency problems with QIF, saying that GnuCash only
> handles one currency per file. However, I am under the impression that the
> problem of multiple currencies had to do with the *QIF* specification, and
> not GnuCash. In other words, the problem isn't that GnuCash doesn’t handle
> multiple currencies, it’s that QIF doesn’t. Can anyone confirm that for me?
> >
> > Yes, that's probably true. However, if an application interprets a
> transfer in such a manner that it takes 100 Euros from one and then
> deposits 100 AUD into another account without warning the user, that's a
> big no-no for me.
> >
> > Thanks for the feedback!
>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Importing Quicken

[David T. via gnucash-user]

Alen,

What you’ve done with the Benefits section is better, but I still feel that any 
mention of benefits of migration is misplaced here. Someone looking for ways to 
migrate from Quicken presumably has already come to this conclusion.

* I have edited the tips portion further. I added a tip regarding the whole 
Categories/Accounts paradigm. 

* I modified your tip regarding import of categories only, since it isn’t 
strictly necessary. 

I think it’s useful here to note that I didn’t have to either import the 
account structure or individual accounts separately when I imported my large 
QIF file way back in the dark ages—I simply exported everything in one big QIF 
and did the import from that. That was when I discovered the holes in my 
Quicken data. I chose to go back in to Quicken, fill in those holes, and 
re-export the entire file again, repeating until I had a clean enough import to 
move forward. I know that others have had a different experience.

* I modified the tip about multiple currencies to more accurately reflect the 
situation and make it clear that the problem isn’t with GnuCash, but with QIF.

Cheers,
David

> On Apr 4, 2018, at 12:52 PM, Alen Siljak  wrote:
> 
> Hi, David,
> 
> You are right. I've removed the benefits section but kept the fact about open 
> data standards. Apart from being a benefit (to me), it is also a consequence 
> of migration that may or may not be important for users.
> 
>> You mention multi-currency problems with QIF, saying that GnuCash only 
>> handles one currency per file. However, I am under the impression that the 
>> problem of multiple currencies had to do with the *QIF* specification, and 
>> not GnuCash. In other words, the problem isn't that GnuCash doesn’t handle 
>> multiple currencies, it’s that QIF doesn’t. Can anyone confirm that for me?
> 
> Yes, that's probably true. However, if an application interprets a transfer 
> in such a manner that it takes 100 Euros from one and then deposits 100 AUD 
> into another account without warning the user, that's a big no-no for me.
> 
> Thanks for the feedback!

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Importing Quicken

[Alen Siljak]

Hi, David,

You are right. I've removed the benefits section but kept the fact about open 
data standards. Apart from being a benefit (to me), it is also a consequence of 
migration that may or may not be important for users.

> You mention multi-currency problems with QIF, saying that GnuCash only 
> handles one currency per file. However, I am under the impression that the 
> problem of multiple currencies had to do with the *QIF* specification, and 
> not GnuCash. In other words, the problem isn't that GnuCash doesn’t handle 
> multiple currencies, it’s that QIF doesn’t. Can anyone confirm that for me?

Yes, that's probably true. However, if an application interprets a transfer in 
such a manner that it takes 100 Euros from one and then deposits 100 AUD into 
another account without warning the user, that's a big no-no for me.

Thanks for the feedback!
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Importing Quicken

[David T. via gnucash-user]

cicko,

I also like what you’ve done. I will add some edits there. 

Personally, I think the “Benefits” section is pointless; this page is about the 
migration from Quicken—not why someone should use GnuCash. I would recommend 
deleting it altogether, but I defer to you, since you created it.

You mention multi-currency problems with QIF, saying that GnuCash only handles 
one currency per file. However, I am under the impression that the problem of 
multiple currencies had to do with the *QIF* specification, and not GnuCash. In 
other words, the problem isn't that GnuCash doesn’t handle multiple currencies, 
it’s that QIF doesn’t. Can anyone confirm that for me?

Cheers,
David

> On Apr 3, 2018, at 5:15 PM, David Carlson <david.carlson@gmail.com> wrote:
> 
> cicko,
> 
> A very nice start.
> 
> I would add that those with large data files extending back several years
> should consider:
> 
> 1. not importing all of it.
> 
> 2. if you want to import it all, break down your export QIF process to one
> asset or liability account at a time and for limited time intervals such as
> one year at a time.
> 
> The one account at a time procedure makes it possible for GnuCash to detect
> most transfers between accounts so they are not duplicated during the
> import.  I would recommend that to all users.
> 
> I think that split memos are still not imported as of recent GnuCash
> releases up to 2.6.17 or so, but do not quote me on that.  I have not tried
> it recently.
> 
> David C
> 
> 
> 
> On Tue, Apr 3, 2018 at 5:02 AM, cicko <alen.sil...@gmx.com> wrote:
> 
>> I have just copied the instructions from the FAQ page into a separate page
>> on
>> the GnuCash wiki, dedicated to Quicken migration:
>> 
>> https://wiki.gnucash.org/wiki/Quicken_Migration
>> 
>> This is a general hint to anyone considering or performing an actual
>> migration from Quicken to GnuCash, to consult the knowledge shared in this
>> page, try to apply it, and provide some feedback so that the instructions
>> can be improved over time.
>> 
>> 
>> 
>> --
>> 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-user
>> If you are using Nabble or Gmane, please see
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -
>> 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
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Importing Quicken

[cicko]

I have just copied the instructions from the FAQ page into a separate page on
the GnuCash wiki, dedicated to Quicken migration:

https://wiki.gnucash.org/wiki/Quicken_Migration

This is a general hint to anyone considering or performing an actual
migration from Quicken to GnuCash, to consult the knowledge shared in this
page, try to apply it, and provide some feedback so that the instructions
can be improved over time.



--
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-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.