GNUCash Import QIF - Help Please!

[Derek Atkins]

Dear GTI,

GT-I9070 H <gti9070h at gmail.com> writes:

> Yes Atkins,

"Atkins" is my family name, my given name is "Derek".  This is, for
example, why I sign my messages "-derek" at the end every time.

> Are years of transaction before I start using GnuCash.
>
> Before I used a robust MS Excel spreadsheet with much code in VBA all made by
> me.
>
> You Devs could enable, even temporarily, some .qif field or another to import
> exchange rates for GnuCash exchange rate field!
>
> Please! [cid]   

This is a volunteer, open source project.  If you want to see a feature
you're welcome to add it yourself, and if you think it's useful you're
welcome to even submit it back for inclusion.  However that would be a
message for gnucash-devel, not gnucash-user.

As far as I know, there is no space in the QIF import format for an
exchange rate.  If you could show us how Quicken would create such a
transaction (which would imply there *is* space in QIF for it) then we
could update the QIF importer to accept it.  But right now, there's just
no field in QIF that supplies an exchange rate for currency transactions
and re-using one would be wrong (as would be creating one out of thin
air).

Perhaps you might be better off just starting over?  Keep your
historical records where they are, and enter new data directly into
gnucash instead of trying to import them?

> Regards
> GTI

-derek

> 2015-06-23 16:22 GMT-04:00 Derek Atkins <warlord at mit.edu>:
>
>     David,
>    
>     David Carlson <david.carlson.417 at gmail.com> writes:
>    
>     > On 6/22/2015 10:25 PM, GT-I9070 H wrote:
>     >> Hi David,
>     >>
>     >> Thanks for the tip!
>     >>
>     >> But I do not want the Internet exchange rates, I want to exchange
>     >> rates (currency prices) that I practiced on that date in every
>     >> transaction that I have written in an MS Excel spreadsheet.
>     >>
>     >> Regards
>     >> GTI
>     >>
>     >
>     > I am still not fully understanding what you are looking for.  If a given
>     > transaction involves two (or more) currencies, it will have an inherent
>     > exchange rate which should be correct therein if it is entered
>     > correctly.  I.e., if I buy a bag of candy marked US$5.00 and pay for it
>     > with a certain number of Euros, there is an exact exchange rate within
>     > the transaction.
>    
>     What he's looking for is a way to *import* these transactions.
>    
>     Sure, he could enter them into the register, but he's (for some reason)
>     already entered them into some other spreadsheet program and wants to
>     import them into Gnucash instead of re-keying them into the Gnucash UI.
>    
>     AFAIK, none of the importers will do that.
>    
>     > 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, SB '93 MIT EE, SM '95 MIT Media Laboratory
>            Member, MIT Student Information Processing Board  (SIPB)
>            URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
>            warlord at MIT.EDU                        PGP key available
>

-- 
       Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
       Member, MIT Student Information Processing Board  (SIPB)
       URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
       warlord at MIT.EDU                        PGP key available