In microsoft.public.money, Kevin wrote:

- quote -

While I am really glad it worked well for you, I don't suggest
periodic QIF export/import. I haven't done so, and fortunately the
great majority of users never have the need. I suspect most of that
shrinkage is quotes.

Dear NG,

I started a new thread here because I was afraid that this would get buried
in the original thread and overlooked.

Cal helped me with an Import/Export of a corrupted data file. Money 2003,
20+ accounts: investment, asset and regular checking/savings accounts.

After accomplishing the Import/Export operation, my data file shrunk in size
from over 14 MB to just under 5 MB.

Now that I've experienced the rigors of performing this endeavor, and
realizing that it's not at all as nightmarish as it's made out to be, I
can't help but think that this is something that might become an annual
ritual. If nothing other than just to remove the bloat from the data file.

Don't get me wrong, this procedure is not for the faint of heart... there
is definitely reconciliation to do, you have to be very well-versed with
this program and your data. Stock price updates are lost. Stock splits
have to be reset. Some of the transferred data is just plain
wrong!...you'll need access to your statements. All scheduled bills have to
be reset. I'm sure there is other information that has to be reapplied as
well.

Still I think that for the more prolific user, the Import/Export course of
action might be something to look into as something other than just a rescue
mission.

Thank you again Cal for all of your assistance, it is greatly appreciated.

Kevin

P.S. An important tip that Cal gave me involved the handling of investment
cash accounts.

- quote -

Long story short: Export investment accounts with a name that starts with
an _ underscore and you'll be able to associate its corresponding cash
account to it.

- quote -

That goes without saying.

Kevin

In microsoft.public.money, Kevin wrote:

- quote -

Richard Bollar discovered that after much experimenting.

- quote -

Great. And now you have a really clean file and you have already
burned a couple backups onto CD... right?

Hi Cal

After carefully studying the whole Import/Export process again, I
was able to successfully rebuild a new data file with only minor
discrepancies that were easily reconciled by adjusting the
opening balances of the investment Cash accounts.

Thanks so much for the tip on how to handle investment Cash
accounts.

I didn't want to have to input an entire years worth of entries.

You saved the day!

Thanks again,

Kevin

"Cal Learner-- MVP" <via_newsgroup[at]please.tnx> wrote in message
news:nbncnvg1j8o7hg0ih5tqmdtenhajj0pp6q[at]4ax.com...
- quote -

Thanks Cal

The Import/Export option makes you choose between
"Regular" or "Investment" accounts.

Since the "Investment" accounts are funded through
transfers from "Regular" accounts, the QIF
Import/Export of accounts "all at once" just became too
overwhelming.

The key word here seems once again to be Backup!

The four weeks worth of backups that I usually keep are
all inflicted with the same problem.

However, I was able to find a copy that I had burned to
CD last October, 2002.

Guess what this puppy is going to be doing on a rainy
Sunday in New York City.

Thanks again.

Kevin
"Cal Learner-- MVP" <via_newsgroup[at]please.tnx> wrote in
message
news:l0ncnvcdqvhln9457rlfgkbk84vp6l2o2b[at]4ax.com...
- quote -

In microsoft.public.money, Kevin wrote:

- quote -

One more thing. Try salv.exe from your Money 2004 installation on
your Money 2003 file. May not help, but worth a try.

In microsoft.public.money, Kevin wrote:

- quote -


If you do QIF export/import, make sure to avoid transfers from
turning into two separate transactions: it is important to import
the QIFs into the new file all at once.

This is done by selecting using Ctrl+<click> to highlight all of
the files you want including. Further, before doing the import,
the names of the investment cash accounts should be named something
alphanumerically higher than the investment transactions of the
account. So you could have "Merrill" and "Merrill Cash", but you
would not want "Merrill Inv" and "Merrill Cash". "_Merrill Inv"
and "Merrill Cash". Would be good. So one way around this is to
export investment accounts to files who's name starts with an
underscore.

Dear NG:

I obviously have a corrupted data file. Money 2003.

28 various accounts, most open, some closed.

Investment data dating back to 1994.

I've read and performed the required recovery methods as per "bollar.org's
Money FAQ's" as they pertained to corrupted data files.

Ran both salvage programs on several different copies of the data file.

I've narrowed the possible problem down to one particular investment entry.
A dividend reinvestment back in August 2001.

The entry has been marked as Reconciled. Attempts to change the "Mark As"
setting to anything else yields no change.

The entry cannot be deleted. Attempts to delete yield 2 Error Messages -
Change reconciled transaction? Which is expected and - This item has just
been deleted, possibly by another application.

The entry can be opened for editing but if any changes are made, clicking
Enter yields 2 Error Messages - Again the Change reconciled transaction?
and - This transaction cannot be entered.

I've tried cutting and pasting to a new temporary investment account. -
Change... and - This transaction cannot be entered.

I've Archived the file which really doesn't have any effect on investment
data.

I've tried Export/Import to a new file but the investment accounts are so
cross-threaded with transferred transactions that I'd need a CPA to set it
all straight again.

I CAN run the program. However I can't convert the data file to Money
2004 - It crashes the program before in finishes the conversion.

I apologize for the lengthy post but I wanted to include all of the
information that I could.

Thanks in advance for any suggestions that I could try.

I think I see a new file in my future.

Kevin