I have seen previous posts whereby a file imported from Quicken is fairly
large but after a while goes down to something more "friendly".

--
Regards
Bob Peel,
Microsoft MVP - Money

For UK tips & fixes see
http://support.microsoft.com/default...d=fh;EN-GB;mny.


I do not respond to any emails that I have not specifically asked for.

"- Bobb -" <bobb[at]netscape.net> wrote in message
news:eBwyPawYGHA.4120[at]TK2MSFTNGP04.phx.gbl...
- quote -

In microsoft.public.money, - Bobb - wrote:

- quote -

I wonder if you would have gotten a similar effect by archiving all
data prior to 1950. ;-)

File-> RepairMoneyFile-> QuickFileRepair might also have a useful
effect.

The file you have ... did you start it from scratch ( vs import from
quicken or old Money) ?
Reason I ask is , I imported my info from quicken in 2000 ( for the Y2k
problem ) and my file grew to ~100mb.
At end of 2001 I copied my file ( in case I did some damage I could
always go back) and then opened the copy.

I then chose to "Archive" all data prior to 1999 and although no
difference in my balaances ( i had no outstanding bills, stocks from
pre 1999 ) my file size went to about 13mb. I suspected that I had a lot
of overhead with the import and once I flushed it, it's been fine since
( same file years later is now only14mb). SO I'd suggest to make a copy
of the .mny file and try it - worst case - go back to what you have. If
it does work, then keep the copy as a backup ( I do that a few times a
year anyway to be safe)

Bobb

<ajtdawe[at]gmail.com> wrote in message
news:1145114187.800544.27290[at]j33g2000cwa.googlegroups.com...
- quote -

In microsoft.public.money, ajtdawe[at]gmail.com wrote:

- quote -

Perhaps with time it will. Perhaps it won't. I don't know.

I could see having a separate Money file to watch investments so as
to not bog down the Money file that contains the real transactions.

- quote -

While the export is one account at a time, it is important that the
import into the new file NOT be one account at a time. That is to
allow Money to recognize transfers. But yes, it would be tedious.

Re-integrating the transactions from the archive file should be
considered. I see some problems there. Your post-archive file would
initial balance records in the QIF files. So I would consider
removing those before import by using a text editor. It won't be
easy to re-integrate.

If you want to do the QIF export/import, I would follow the steps
in http://support.microsoft.com/default...b;en-us;178830
except in the first step 4, I would suggest this: start the name of
the QIF file for the investment accounts with an underscore (_),
and start the name of QIF files for the cash accounts associated
with the investments with a letter. Thus you might have
_BrownInvestment.qif and BrownInvestmentCash.qif. This would cause
the investment account to be processed prior to the associated cash
account. When the BrownInvestment got created, you would specify
that you want to track the cash transactions. Then specify that
the cash transactions account for BrownInvestment was where the
BrownInvestmentCash.qif transactions get sent.

Then File-> Import ALL AT ONCE using Ctrl+<click> to select files.
Specify "New or Recovered" account when asked.

Of course you will use a different filename for the new file, and
you will have both versions to choose from when done. I would also
set up the backups to make sure they are using different names.

There are some limitations to QIF export/import. For example, the
symbols for investments and the online setup info is not carried. So
you would have build that back up in the new trimmed-down file.

Clearing the historical quotes did not change the file size.

What are you ideas on the QIF export / import. That is a bit tedious,
one account at a time.

In microsoft.public.money, ajtdawe[at]gmail.com wrote:

- quote -

Don't archive for that purpose.

Don't watch so many stocks.

Portfolio-> More-> ClearHistoricalQuotes looks like it could be of
use. Let us know what happens if you use that.

Consider QIF export+Import to a new file. You could possibly
re-consolidate those transactions that you archived while you are at
it. If you want to try that, check back for some more ideas on that.

My "mny" file is 175MB and takes 2-3 minutes to back up. I have
archived everything prior to 1/1/06 and "repaired" the file, but the
file size stays the same.

Any suggestions?