Fund Manager
PORTFOLIO MANAGEMENT SOFTWARE
Contact Us

Re: Import from Quicken

[ Q3 01 - Q1 03 Archive ] [ Current Message Board ] [ Archives ] [ Search ]

Posted by Alan Cooper on December 03, 2002 at 13:22:58:

In Reply to: Re: Import from Quicken posted by Mark on November 29, 2002 at 19:44:57:

: : : : I recently downloaded FM 6 to evaluate and cannot import from Quicken. The message "Imported 0 Transactions" appears. Another message preceeds this but is immediately covered, so I do not know its content.

: : : : Is there a import restriction in the evaluation version?

: : : : Here is a sample from the QIF file that I am attempting to import:

: : : : !Type:Invst
: : : : D01.01.02
: : : : NShrsIn
: : : : YABN Nikkei 225
: : : : I134.672657
: : : : Q350
: : : : U47,135.43
: : : : T47,135.43
: : : : ^
: : : : D01.01.02
: : : : NShrsIn
: : : : YBASF
: : : : I41.639667
: : : : Q150
: : : : U6,245.95
: : : : T6,245.95
: : : : ^

: : : : Any ideas?
: : : : Thank you,
: : : : Alan Cooper

: : : Hi Alan,

: : : The problem is the format of the date line. It has periods, and
: : : FM is expecting forward slashes. Which version of Quicken are you
: : : using? I will make FM support this format with version 6.1. Would
: : : you like to test out a beta version of 6.1 with this fix? If so, let
: : : me know, and I'll e-mail it to you. You could also use a workaround
: : : of modifying the QIF file to change all the lines beginning with a 'D'
: : : as shown here:

: : : From:
: : : D01.01.02

: : : To:
: : : D01/01/02

: : : Thanks,
: : : Mark
: : : --
: : : Mark Beiley
: : :
: : : Fund Manager, portfolio management software for Windows 95/98/ME/NT/00/XP
: : : /XP
: : :

: : Hi Mark,
: : Thank you for the quick reply. I manually converted a few of the dates and that did indeed solve the problem. As I do have a lot of data to import I would like to take you up on your offer of emailing a beta version 6.1 with the fix. The quicken version I am using is called "Swiss Edition". Thanks again,
: : Alan

: Hi Alan,

: Thanks for the information. Sounds like the "Swiss Edition" has a different
: format for the QIF files. I've added support for this in 6.1, thank you.
: I've also just now sent you via e-mail a beta 6.1 to test this out.

: Thanks,
: Mark
: --
: Mark Beiley
:
: Fund Manager, portfolio management software for Windows 95/98/ME/NT/00/XP
: /XP
:

Hi Mark,

Unfortunately, my Quicken prn files also do not import into FM. Same date format problem it seems. Here is a sample:

"Date","Price","High","Low","Volume"
"19.11.01",4.35,,,
"17.11.01",4.17,,,
"13.11.01",4.32,,,
"08.11.01",3.95,,,
"24.10.01",3.56,,,
"22.09.01",2.17,,,
"01.09.01",3.18,,,
"25.08.01",3.63,,,
"11.08.01",3.69,,,
"28.07.01",3.43,,,
"14.07.01",3.19,,,
"30.06.01",3.95,,,
"23.06.01",3.38,,,
"16.06.01",3.40,,,
"11.06.01","3 3/4",,,

Do you have a fix here too?
Thanks and regards,
Alan


Replies:



FundManagerSoftware.com | Search | Site Map | About Us | Privacy Policy