Feedback

[Dr. Friedrich G. Zuther]

Watching kmymoneys development for some time now, I am Impressed. With the  
new Version I tried to convert a bigger amount of Data from Quicken, to  
make kmymoney my working system. Imports of qif work fine (to some  
astonishment), execpt for investment accounts. kmymoney always complains  
not to know the funds ... but wouldn`t it make sense to create them, when  
I import from anoher financial application? Even if I manually enter the  
funds... they never match. There seems no way to import portfolios.

Can you give me a clue or change kmymoneys behavior, so it creates all  
necessary funds etc?

Best regards
Friedrich Zuther


------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
KMyMoney2-developer mailing list
KMyMoney2-developer@...
https://lists.sourceforge.net/lists/listinfo/kmymoney2-developer

[allan-52]

Dr. Friedrich G. Zuther wrote:

> Watching kmymoneys development for some time now, I am Impressed. With the  
> new Version I tried to convert a bigger amount of Data from Quicken, to  
> make kmymoney my working system. Imports of qif work fine (to some  
> astonishment), execpt for investment accounts. kmymoney always complains  
> not to know the funds ... but wouldn`t it make sense to create them, when  
> I import from anoher financial application? Even if I manually enter the  
> funds... they never match. There seems no way to import portfolios.
>
> Can you give me a clue or change kmymoneys behavior, so it creates all  
> necessary funds etc?
>
> Best regards
> Friedrich Zuther
>

I answered a similar query a little while back, but can I find it? NO!!!

So, here goes again.  In short, yes, KMM can import data for investments
from Quicken.  However, the QIF standard is not really a standard and
different applications implement it differently, unfortunately.  It may,
or almost probably will, need some editing of your file.

In order for KMM to import successfully investments, the file format
needs to be similar to this:-

!Option:AutoSwitch
!Account
NBank Account A
TBank
Daccount no.
^
NBank Account B
TBank
^
NInvestment A
TMutual
^
NInvestment B
TMutual
^
NInvestment C
TMutual
^
!Clear:AutoSwitch
!Type:Security
NSecurity A
SSymbol A
TUnit/Inv. Trust
^
!Type:Security
NSecurity B
SSymbol B
TUnit/Inv. Trust
^
!Type:Security
NSecurity C
SSymbol C
TUnit/Inv. Trust
^
!Account
NInvestment A
TInvst
^
!Type:Invst
D3/11/04
NBuyX
YSecurity A
I1.472445
Q1,546.93
U2,277.77
T2,277.77
L[Investment A (Brokerage)]
$2,277.77
^
D30/4/05
NDivX
YSecurity A
U39.58
T39.58
L[Investment A (Brokerage)]
$39.58
^
!Account
NInvestment B
TInvst
^
!Type:Invst
D5/12/01
NShrsIn
YSecurity B
I0.7038
Q4,737.14
U3,334.00
T3,334.00
^
D7/4/02
NDivX
YSecurity B
U40.88
T40.88
MEst. price as of 07/04/02
L[account]
$40.88
^
!Account
NInvestment C
TInvst
^
!Type:Invst
D3/11/04
NBuyX
YSecurity C
I1.370518
Q1,478.645
U2,026.51
T2,026.51
L[Investment C (Brokerage)]
$2,026.51
^
D1/7/05
NDivX
YSecurity C
U36.42
T36.42
L[Investment C (Brokerage)]
$36.42
^
!Type:Prices
"Symbol A",0.7038,"5/12/01"
^
!Type:Prices
"Symbol A",1.4457,"1/12/04"
^
!Type:Prices
"Symbol A",1.4594,"1/1/05"
^
!Type:Prices
"Symbol A",1.4589,"1/2/05"
^
!Type:Prices
"Symbol B",0.684,"1/1/02"
^

I've just constructed and tested this and it seems to be OK, with a few
minor issues, like the creation of a few apparently unnecessary
accounts.  Personally, I don't use brokerage accounts, and just use
relevant bank type accounts.  Obviously, you'll need to substitute your
own account details.  Try importing this first, then edit your own file
along the same lines, obviously keeping a good backup!!

Good luck, but let's know of any problems.

Allan





------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
KMyMoney2-developer mailing list
KMyMoney2-developer@...
https://lists.sourceforge.net/lists/listinfo/kmymoney2-developer

[Thomas Baumgart]

Hi,

on Wednesday 07 October 2009 allan wrote:

> Dr. Friedrich G. Zuther wrote:

> > Watching kmymoneys development for some time now, I am Impressed. With
> > the new Version I tried to convert a bigger amount of Data from Quicken,
> > to make kmymoney my working system. Imports of qif work fine (to some
> > astonishment), execpt for investment accounts. kmymoney always complains
> > not to know the funds ... but wouldn`t it make sense to create them, when
> > I import from anoher financial application? Even if I manually enter the
> > funds... they never match. There seems no way to import portfolios.

[...]

> Good luck, but let's know of any problems.

... and of course any success stories are appreciated as well.


--


Regards

Thomas Baumgart

GPG-FP: E55E D592 F45F 116B 8429   4F99 9C59 DB40 B75D D3BA
-------------------------------------------------------------
As soon as there is an optimist who discovers a light that does not exist
there is a pessimist who blows it out. (Giovanni Guareschi)
-------------------------------------------------------------


------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
KMyMoney2-developer mailing list
KMyMoney2-developer@...
https://lists.sourceforge.net/lists/listinfo/kmymoney2-developer

[allan-52]

Thomas Baumgart wrote:

> Hi,
>
> on Wednesday 07 October 2009 allan wrote:
>
>> Dr. Friedrich G. Zuther wrote:
>
>>> Watching kmymoneys development for some time now, I am Impressed. With
>>> the new Version I tried to convert a bigger amount of Data from Quicken,
>>> to make kmymoney my working system. Imports of qif work fine (to some
>>> astonishment), execpt for investment accounts. kmymoney always complains
>>> not to know the funds ... but wouldn`t it make sense to create them, when
>>> I import from anoher financial application? Even if I manually enter the
>>> funds... they never match. There seems no way to import portfolios.
>
> [...]
>
>> Good luck, but let's know of any problems.
>
> ... and of course any success stories are appreciated as well.
>
>

Hi Thomas

My post hasn't appeared yet.  I suspect I might have sent it as a c.c.
by mistake.  It is on Nabble, though.

Allan

------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
KMyMoney2-developer mailing list
KMyMoney2-developer@...
https://lists.sourceforge.net/lists/listinfo/kmymoney2-developer

[allan anderson]

Hello Friedrich again

Before you go to too much trouble editing your file, could you tell me
what you chose to export from Quicken?  I've just selected one
investment, then specified Transactions and Securities Lists.  When I
imported this, KMM complained that "No account information has been
found in the selected statement file" and gave the option to create an
account.  This sounds rather like your description of the problem.

I then tried again, and specified in addition, Accounts Lists.  On
importing, no difficulty ensued, the correct information was created and
 imported, albeit with, in Ledger view, three accounts for the one
imported account.  For each other security on the list, just one
Investment account was created and one security Investment account.

Tomorrow/today, I'll go back to Quicken again, as a little light is
beginning to glimmer.

Allan

------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
KMyMoney2-developer mailing list
KMyMoney2-developer@...
https://lists.sourceforge.net/lists/listinfo/kmymoney2-developer

[allan anderson]

allan wrote:

> Hello Friedrich again
>
> Before you go to too much trouble editing your file, could you tell me
> what you chose to export from Quicken?  I've just selected one
> investment, then specified Transactions and Securities Lists.  When I
> imported this, KMM complained that "No account information has been
> found in the selected statement file" and gave the option to create an
> account.  This sounds rather like your description of the problem.
>
> I then tried again, and specified in addition, Accounts Lists.  On
> importing, no difficulty ensued, the correct information was created and
>  imported, albeit with, in Ledger view, three accounts for the one
> imported account.  For each other security on the list, just one
> Investment account was created and one security Investment account.
>
> Tomorrow/today, I'll go back to Quicken again, as a little light is
> beginning to glimmer.
>
> Allan
>
> ------------------------------------------------------------------------------

Hi Friedrich

To continue...

What I've now done is go back to Quicken and export all accounts and all
securities. On importing into KMM, and choosing as source for QIF,
'other application'.  What results is as follows:-

Accounts view - for each investment, an (Investment) account with
its stock account below
Ledger view - for each investment, an (Investment) account.
Investment view - for each investment, the associated stock account.

As expected, all the accounts are empty.  So far, so good.

Now, going back to Quicken, export just one investment account.
Importing into KMM, as above, KMM reports "No account information has
been found in the selected statement file."  Now, select from the list
the appropriate (Investment) account.  The import succeeds, although you
now have two stock account, one containing your transactions, the other,
empty so just delete it.  This can then be repeated for each single
investment account, and no QIF file editing is needed, although surplus
stock account have to be deleted.

If an attempt is made to import transactions from all accounts together,
thing go haywire and all sorts of duplicate accounts are produced. I
think much depends on how you've set up Quicken, as there are various
options.  Possibly, if you have Brokerage accounts, things may work
better, but if the payments and dividends instead go into bank type
accounts, when importing 'all accounts', things go astray as each
transaction has two parts, and KMM does not seem to handle this well, it
seems to me.   I think this needs to be investigated by Thomas.

Hope this helps

Allan

------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
KMyMoney2-developer mailing list
KMyMoney2-developer@...
https://lists.sourceforge.net/lists/listinfo/kmymoney2-developer

[allan anderson]

Hi Friedrich

First, the good news - the rain has stopped here in Liverpool! <BG>

Dr. Friedrich G. Zuther wrote:

> Hi Alan,
>
> I do not succeed. IT seems kmm is missing a description what investments
> (stocks / funds) I own. Quicken doesn`t gerate a section like that (from
> the testfile) in my files:
>
>
> ^
> NInvestment A
> TMutual
> ^
> NInvestment B
> TMutual
> ^
> NInvestment C
> TMutual
> ^
>
> and (besides) I don`t get Quicken to export prices
>
> ^
> !Type:Prices
> "Symbol A",1.4594,"1/1/05"
> ^

It looks like you haven't exported from Quicken the Account List and the
security list, or that, if you have, you didn't import it into KMM
before importing your transactions.  Apart from it listing the accounts,
that file will also have after the the accounts, your symbols and prices.

>
> The simplest file I have is an account with just one investment bought
> once. Quicken generates this file (and I translate KaufX to BuyX)
>
> !Type:Invst
> D4.1.09
> NBuyX
> YGenoanteile Mittelhessen
> I1
> Q250
> U250.00
> T250.00
> MGA-PFLICHTEINZAHLUNG       ZUR GUTSCHRIFT AUF GESCHAEFT
> L[Vb Mittelhessen]
> $250.00
> ^
>
> Importing this into kmm:
> 1) Generate brokerage account "Depot Mittelhesen" and start importing
> into that account:
> kmm komplains, that the freshly generated account does not contain any
> investments "Genoanteile Mittelhessen".
> 2) I generate the Investment manually and import again:
> Voila I now own "Genoanteile Mittelhessen"
>

That file looks OK so far, so try again after the accounts import.

> So what I want kmm to do, is create the investments itself - at last
> when I am importing from another aplication. Or I`ll generate a list of
> my investments (via printout from quicken) and transform it to a qif
> format. But that is not suited for users.
>

Agreed - that's how it used to be, but you should find it will now do it
for you.  Just one thought though.  What revision are you on, and what
distro?  The current revision is 1.0.2.

> Anyhow I'll play around some more and report. Is there any list of "qif
> commands" around, I need to translate some more of the german and this
> part of financial english is not my best...
>

Firstly, the lead developer, Thomas Baumgart, is German.  I will copy
this post to the Kmymoney2-developer list as there are always other
users who can contribute, or perhaps learn from your experience, but
will also start a new thread with your specific query.
> Greetings from a rainy day in Berlin
> Friedrich

> Am 10.10.2009, 13:44 Uhr, schrieb allan <aganderson@...>:
>
>> Dr. Friedrich G. Zuther wrote:
>>> Yes Alan, too fast ;-)
>>
>> Sorry about that!!
>>
>> this is interleaving my last mail
>>
>> As is mine.
>>>
>>>> Hi Friedrich
>>>>
>>>> To continue...
>>>>
>>>> What I've now done is go back to Quicken and export all accounts and
>>>> all
>>>> securities. On importing into KMM, and choosing as source for QIF,
>>>> 'other application'.  What results is as follows:-
>>>>
>>>> Accounts view - for each investment, an (Investment) account with
>>>> its             stock account below
>>>> Ledger view - for each investment, an (Investment) account.
>>>> Investment view - for each investment, the associated stock account.
>>>
>>> -> This is what I still have to find in quicken. How did you do that?
>>>
>>
>> Those are the views in KMM, not in Quicken.  In KMM, after import, in
>> the left pane , select Accounts, after that you can see transactions in
>> Ledger view, again on the left.  Finally, the stock account itself
>> appears in Investment view, showing the summary, symbol, etc.  Also, you
>> should find all your pricing in the Tools/Prices menu.
>>
>>>> As expected, all the accounts are empty.  So far, so good.
>>>>
>>>> Now, going back to Quicken, export just one investment account.
>>>> Importing into KMM, as above, KMM reports "No account information has
>>>> been found in the selected statement file."  Now, select from the list
>>>> the appropriate (Investment) account.  The import succeeds, although
>>>> you
>>>> now have two stock account, one containing your transactions, the
>>>> other,
>>>> empty so just delete it.  This can then be repeated for each single
>>>> investment account, and no QIF file editing is needed, although surplus
>>>> stock account have to be deleted.
>>>
>>> -> However: I`need to translate all trnscation codes from german to
>>> english, first.
>>>
>>>> If an attempt is made to import transactions from all accounts
>>>> together,
>>>> thing go haywire and all sorts of duplicate accounts are produced. I
>>>> think much depends on how you've set up Quicken, as there are various
>>>> options.  Possibly, if you have Brokerage accounts, things may work
>>>> better, but if the payments and dividends instead go into bank type
>>>> accounts, when importing 'all accounts', things go astray as each
>>>> transaction has two parts, and KMM does not seem to handle this
>>>> well, it
>>>> seems to me.   I think this needs to be investigated by Thomas.
>>>>
>>>> Hope this helps
>>>>
>>>> Allan
>>>
>>
>> I'll leave you alone now, but do get back if you have problems/progress.
>>  I'm trying to get a minimum file for Thomas to look at.
>>
>> Allan
>

------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
KMyMoney2-developer mailing list
KMyMoney2-developer@...
https://lists.sourceforge.net/lists/listinfo/kmymoney2-developer

[allan anderson]

> Dr. Friedrich G. Zuther wrote:

Hi Friedrich

Sorry to hear you're still having trouble.  My comments are interspersed
below.

<snip>
>>
>> It looks like you haven't exported from Quicken the Account List and the
>> security list, or that, if you have, you didn't import it into KMM
>> before importing your transactions.  Apart from it listing the accounts,
>> that file will also have after the the accounts, your symbols and prices.
>
> Well my version of quicken (2007) will export a list for just one
> account. I cannot find the options you describe.

OK, my Quicken is 2002 and the 'free' version!  I'll open it up and
describe the dialog I see, and what result I get.

File/Export/QIF -> Dialog Box:- At the bottom there is a panel, 'Include
in Export'.  I select only Account List and Security List, no
Transactions at this stage.  I click OK and get a large file, 120kb
here.  This starts with a list of accounts, followed by a list of
securities.  The remaining 95% of the file is a list of prices for those
securities.  I can immediately import that file into KMM and have all
the accounts listed in Account view, and all the securities show in
Investment view.  If I select Tools/Prices, tick the box for 'Show all
stored prices', they are all there.

I think I'll stop there, and you can describe what you get, before going
any further.

Allan

>
> I can get quicken to export a list of all accounts and import them into
> kmm. Good! (just choose one account and tell quicken to export accounts
> as well)
> But still, I see no direct way to export a security list nor prices. Via
> the printing dialog I can get quicken to export a list of all securities
> as comma seperated file and prices as well as csv (just for one security
> at a time, that will be some effort...)
>
> How did you get quicken to export securities and prices? If I have to
> migrate to quicken 2010 to get this done - I will. Can you tell where to
> find those options in your version?
>
> I'll probably suceed with transforming the csv to qif (like in the
> reference qif file) and import as well as translating the keywords for
> brokerage - but it seems a lot of work and i'd prefer to even buy
> another version of quicken if export gets easier - or move to starmoney
> first? If you have a more convenient way, please let me know.
>
> Best regards
> Friedrich
>
> Besides: I do not understand why you do not want to improve the qif import
> function: creating the security instead of giving an error message that
> there is no such security in the account does not make sense when
> importing "from another application". Even when importing from (manually,
> faulty) data file it's better to give notice, but to proceed instead to
> err and breackup, isn`t it?
>
>

------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
KMyMoney2-developer mailing list
KMyMoney2-developer@...
https://lists.sourceforge.net/lists/listinfo/kmymoney2-developer

[allan anderson]

Dr. Friedrich G. Zuther wrote:

> Hi Alan,
>
> here you see the restricted options quicken 2007 offers me (Quicken
> export options.png)
>
> just transactions, accounts, categories and "memorized transactions"
> however that is named in the english version... no security list available.
>
> Youre outdated and free verion seems much more capable than mine...
> Friedrich
>
> However I can generate a securities list via the printing option as cvs
> (Wertpapierliste.prn) and prices for one paper at a time (Kurse DWS Top
> 50..prn).
>

Hi Friedrich

Amazing!!  I suppose that's called progress.  I can see on the shot of
the dialog that two options have been removed, although one of them was
for Mac users.

It looks like you can get a separate security list.  But this is a
disgrace.  Each entry is going to need editing to conform to QIF format:-

!Type:Security
NyourSecurity Name [your own item name]
SyourSymbol
TUnit/Inv. Trust
^

What about an account list which includes the Mutual/Unit Trust accounts
in which the securities appear?  Do you have that?

Each prices list also will have to be edited to QIF format.  It looks
like quite a bit of work for you still, I'm afraid.

I've seen mention of importing from CSV, so I'll look at that.  It might
help.

Allan

>
>
> Am 20.10.2009, 21:06 Uhr, schrieb allan <aganderson@...>:
>
>>> Dr. Friedrich G. Zuther wrote:
>>
>> Hi Friedrich
>>
>> Sorry to hear you're still having trouble.  My comments are interspersed
>> below.
>>
>> <snip>
>>>>
>>>> It looks like you haven't exported from Quicken the Account List and
>>>> the
>>>> security list, or that, if you have, you didn't import it into KMM
>>>> before importing your transactions.  Apart from it listing the
>>>> accounts,
>>>> that file will also have after the the accounts, your symbols and
>>>> prices.
>>>
>>> Well my version of quicken (2007) will export a list for just one
>>> account. I cannot find the options you describe.
>>
>> OK, my Quicken is 2002 and the 'free' version!  I'll open it up and
>> describe the dialog I see, and what result I get.
>>
>> File/Export/QIF -> Dialog Box:- At the bottom there is a panel, 'Include
>> in Export'.  I select only Account List and Security List, no
>> Transactions at this stage.  I click OK and get a large file, 120kb
>> here.  This starts with a list of accounts, followed by a list of
>> securities.  The remaining 95% of the file is a list of prices for those
>> securities.  I can immediately import that file into KMM and have all
>> the accounts listed in Account view, and all the securities show in
>> Investment view.  If I select Tools/Prices, tick the box for 'Show all
>> stored prices', they are all there.
>>
>> I think I'll stop there, and you can describe what you get, before going
>> any further.
>>
>> Allan
>>>
>>> I can get quicken to export a list of all accounts and import them into
>>> kmm. Good! (just choose one account and tell quicken to export accounts
>>> as well)
>>> But still, I see no direct way to export a security list nor prices. Via
>>> the printing dialog I can get quicken to export a list of all securities
>>> as comma seperated file and prices as well as csv (just for one security
>>> at a time, that will be some effort...)
>>>
>>> How did you get quicken to export securities and prices? If I have to
>>> migrate to quicken 2010 to get this done - I will. Can you tell where to
>>> find those options in your version?
>>>
>>> I'll probably suceed with transforming the csv to qif (like in the
>>> reference qif file) and import as well as translating the keywords for
>>> brokerage - but it seems a lot of work and i'd prefer to even buy
>>> another version of quicken if export gets easier - or move to starmoney
>>> first? If you have a more convenient way, please let me know.
>>>
>>> Best regards
>>> Friedrich
>>>
>>> Besides: I do not understand why you do not want to improve the qif
>>> import
>>> function: creating the security instead of giving an error message that
>>> there is no such security in the account does not make sense when
>>> importing "from another application". Even when importing from
>>> (manually,
>>> faulty) data file it's better to give notice, but to proceed instead to
>>> err and breackup, isn`t it?
>>>
>>>
>>
>>
>
> ------------------------------------------------------------------------
>

------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
KMyMoney2-developer mailing list
KMyMoney2-developer@...
https://lists.sourceforge.net/lists/listinfo/kmymoney2-developer

[allan anderson]

Dr. Friedrich G. Zuther wrote:
> Hi Alan,
>
> your scripts work! Although no unix expert and not at all used to python
> ... unsing the instructions in the header, it was easy.
> Thanks a lot.

Pleased to hear that!  It just so happened that this last week my own
bank has just ceased giving ofx support, supplying only csv instead.  So
I had to write myself another script!

Now I have a lot of work to do.
>
> A lot of securities and their pricing histories have to be converted. If
> you could - it would be lots easier, if your scripts could convert all
> files in one directory at once - ideally into one qif. I`d name the file
> as securities ids (anyway). This would save a lot of typing ...

<snip>

If I'm right, you have one file with all your securities listed, which
you have now been able to convert and import.  Also, I think you will
have a number of individual files with prices history, one file per
security.  Each of these latter files will have a number of entries with
symbol plus date and price.  So each entry has only its own symbol, with
no security name, but these you should already have imported.  No
additional formatting is necessary.

So, what you might do is have all the prices history files in a
directory by themselves then do:-

cat *.PRN > outputfile.csv

which will concatenate all your .PRN files into a single file, which,
all being well, you can then convert to qif with the csvpricesqif.py script.

I hope things go well for you, but let me know either way.


Good luck

Allan

> I`ll probably start converting a lot of files at the weekend - I promise
> to write a little manual how to convert from quicken 2007 (german
> version) with securities. Anything else I can do to reward your work?
>
> Best regards
> Friedrich
>

PS  If it's any consolation, the later versions of Quicken have even
fewer export options, I'm told.  The older ones seem to be better.  A
good way of locking users to Quicken, they seem to think.  Also, with MS
Money now being dropped, they have even less competition - at least
until KMM appears in Windows.

AA

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
KMyMoney2-developer mailing list
KMyMoney2-developer@...
https://lists.sourceforge.net/lists/listinfo/kmymoney2-developer

[allan anderson]

Dr. Friedrich G. Zuther wrote:

> Hi Alan,
>
> I' ve been troubling with all this work... You already solved one
> problem, that will appear later on ;-)
>
>> If I'm right, you have one file with all your securities listed, which
>> you have now been able to convert and import.
>
> No, I started exporting one by one. But getting tired, I found a
> different way. Quicken can indeed still export all security transactions
> at once! So now I have one file with all the securities. This is
> formatted differently, however. I'll start converting manually
> (OpenOffice will do), may need your help, but won`t bother you again
> before I'm at the end of my knowledge.
>

Does that file have a list of all securities, followed by all their
prices?  That's how my Quicken works.  If you can give me an extract, I
might be able to edit my script to cope with that.  It's a bit of a slog
doing it manually, and fraught with error.

>> Also, I think you will
>> have a number of individual files with prices history, one file per
>> security.  Each of these latter files will have a number of entries with
>> symbol plus date and price.  So each entry has only its own symbol, with
>> no security name, but these you should already have imported.  No
>> additional formatting is necessary.
>
> Yes, probably I won't convert prices... having to export them one by
> one. As long as I can calculate performance correctly from now on, I am
> not so keen on historic values (you should have sold by 2007,3,3).
>>
>> So, what you might do is have all the prices history files in a
>> directory by themselves then do:-
>>
>> cat *.PRN > outputfile.csv
>>
>> which will concatenate all your .PRN files into a single file, which,
>> all being well, you can then convert to qif with the csvpricesqif.py
>> script.
>
> If I decide otherway, that wil save a lot of work, thanks.
>
>> I hope things go well for you, but let me know either way.
>>
> still inbetween ;-)
>
> Have a nice weekend
> Friedrich
>

Hi Friedrich

Don't be afraid to ask if you have a problem.  I'm happy to try and help.

You have a good week-end too.

Allan


------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
KMyMoney2-developer mailing list
KMyMoney2-developer@...
https://lists.sourceforge.net/lists/listinfo/kmymoney2-developer

[allan anderson]

Dr. Friedrich G. Zuther wrote:

> > Pleased to hear your offer - of course you are right. Since I never used
> > python, I can use your help.
> >
> > 1) I had to go for a tab separated file instead of colons - in German, a
> > colon separated the decimals and the file gets rotten. Can the
> > csv-library handle that or do I have to convert?
> > 2) I put my trail in the comments before yours... however I do not know
> > the if syntax and the test if the field is empty
> >
> >
> > thanx again
> > Friedrich
> >
>> >> Hi Friedrich
>> >>
>> >> Don't be afraid to ask if you have a problem.  I'm happy to try

and help.
>> >>
>> >> You have a good week-end too.
>> >>
>> >> Allan
>> >>

Hello Friedrich

I've been working with another user's conversion and realised the
problem with decimal separator = ',' .  Easy enough to fix.  Hmm.. Not
quite that easy as I had to get a suitable input file.  I'm not
absolutely sure what file type you're actually talking about, but as
you've said you're not going to import prices, I'm assuming it's the
securities list.  But then in your previous email you said you've found
your Quicken "...can indeed still export all security transactions at
once", which presumably is a qif file?

Anyway, assuming it is the securities list, attached is a modified
script with ":" (colon) specified as delimiter.  You'll see line 41 has
the new variable delim_char = ':' , which you can alter if needed.

I'm afraid I didn't quite understand your point 2).  Perhaps you could
either re-phrase it, or give it in German, and we'll ask for a
translation.  Sadly, my German is infinitely poorer than your technical
English!

Best wishes

Allan



------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
KMyMoney2-developer mailing list
KMyMoney2-developer@...
https://lists.sourceforge.net/lists/listinfo/kmymoney2-developer