GNUCash Import QIF - Help Please!

[GT-I9070 H]

2015-06-24 9:16 GMT-04:00 Derek Atkins <warlord at mit.edu>:

> Dear GTI,
>
> "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.
>

Ok Derek, excuse me.

I do not know how to refer to people from another country, each country has
its own customs, I tried to be respectful not calling you by your first
name.


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

I know, people tell me that all the time. This intimidates people to
suggest something for projects.

I do not write code in C and even though I write, I imagine that I would
have to submit my modifications the approval of others and this can not be
approved. There is a problem that seems to be eternal, the migration of a
SW to the other.


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

I studied a little QIF format and as far as I know, which is not a lot,
there isn't a field for exchange rate and I never used Quicken.

The fact GnuCash not import exchange rates of any file format is a major
problem that must be solved someday and that day may be coming.

My suggestion is to create a field in the QIF file that does not affect
existing and pass the call this QIF format changed to another name as Eg
QIG (QIF to GnuCash Exchange rate import) and enable the import of this new
field in GnuCash importer for QIG format.

So you will have already created an entryway for off-line exchange rate
data!

What do you think?


>
> 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?
>

I'm already with my data well fragmented and would not want to create
another fragment.

Regards
GTI


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