In microsoft.public.money, Stacy wrote:

- quote -


How long since you archived?

How much has been added since?

Are the items added fairly simple?

What I am getting at, is that the archive file is a copy of your
file at the time of archiving. You could perhaps File-> Export QIF
files from each of your accounts. Use a text editor to do some
editing of the QIF files.

Copy the archive to a new name such as Stacy05.mny. Open
Stacy05.mny. File-> import the modified QIF files. That procedure
could differ depending on your situation. Importing a checking
account as a statement will look for duplicate transactions, but it
will require each transaction to be accepted. Importing as a new or
recovered account will not look for duplicates, but it can involve
investment transactions. You would be relying on the pre-editing to
remove the older transactions that pre-dated the archive. Plus note
that archiving does not remove investment transactions.



Adjust the initial balance of each account to $0 or a known
appropriate number. Get things entered as well as possible. Make a
single adjusting entry in each account to account for what you were
not able to reconstruct.

This is fairly sketchy, for various reasons. Whatever you try,
remember to keep intermediate copies of your files in case you do
something you would like to undo. Attempting this will probably
result in some trial and error.

Hi,
Your problem sounds very close to mine. After I archived all my balances
were screwed up. There are some transactions in my archives that are before
the archive date also. Money support has no clue how to help me. I think
there may also be some duplicates from archive to archive. Please help! Your
post is a little complex for me to understand what steps to take so any
further advise would be awesome. Thank You,
Stacy

"Teffy" wrote:

- quote -

Thanks again for the help! Finally, the files are merged. In case it
might help someone else, here I my notes on the procedure:

Archive puts a snapshot of the the whole Money file, as it existed at
the time of archiving, in '* Archive.mny'. It removes transactions
from CurrentMoneyFile prior to specified date (i.e. 1/1/2004) EXCEPT
for transfers.

Since Money only allows one file open at a time, I used two computers.
On one I ran Money with the current file, on the other I ran Money with
the archive file. I went through each account noting differences and
deciding which to export from 'CurrentMoneyFile' to '2004 Archive'. I
chose to merge in this direction because no transactions in closed
accounts survived in CurrentMoneyFile after the archive process, and
there were a boatload of them.

Watch out for these: even though the archive was performed on a given
date, there may still be transactions dated earlier, but added to
CurrentMoneyFile later. I made a "What I Have" type report of all
transactions since archive date within CurrentMoneyFile. If the
account needed just a few newer transactions, I entered them by hand.
Otherwise, I exported the account.

I edited the QIF's created by the exports and deleted transactions
already listed in the destination Money file.

Note: When importing, the account to which you add records must be
OPEN, and any other account transferred to or from must be OPEN (All
accounts referred to by transactions in the imported account must be
OPEN) .

As I was importing these accounts (.qif files ALL AT ONCE) I was asked
about a number of closed accounts. I made a note of their names, and
assigned them to a bogus account. I discarded that Money file, and
opened a copy from before the import. I opened those files mentioned
before, then re-imported.

I closed the old accounts I had previously opened, sometimes getting a
message: contains open positions," am I transfering to another
account?". I don't understand the question, but answered "no", and
that seemed to work OK.

Then I compared account balances between CurrentMoneyFile and the
updated archive. There were a couple of problems that I fixed
manually. After fixing, all account balances matched. Whew!

Teffy

Answers inline.

"Teffy" <WGSGNUAYHTTE[at]spammotel.com> wrote in message
news:1105413457.188082.10870[at]f14g2000cwb.googlegroups.com...
- quote -

In Money? No. You should edit the QIF in Notepad to delete duplicates. I
wouldn't delete anything in either Money file.

- quote -

No.

- quote -

In your coase, you INTEND them to line up, so you do not want to change
names.

- quote -

Thanks to all for the help!

Is there a way to select & delete more than one transaction at a time?

Is there a way to open all closed accounts at once, or to select and
open more than one in a single operation?

The 'unofficial microsoft.public.money FAQ and A' says, "Beware that
duplicate account names ("Checking") in the exporting and importing
account will cause problems and one or the other account should be
renamed before you do the export/import." Is this still true with
Money 2004 Standard? Since, during the import process, I am prompted
to match renamed accounts with existing accounts, it seems to me that
renamimg just complicates matters.
Oh, the tedium! ;-) What a project this is.

Teffy

In microsoft.public.money, Teffy wrote:

- quote -

In addition to Dick's info, note that the archive file itself is
named "* Archive.mny", and it is a copy of the whole Money file as
it existed at the time of archiving. That might be more recent than
your .mbf file.

Archive files are not QIF files. QIF files come from File|Export.

See http://umpmfaq.info/faqdb.php?q=90 for info about merging two Money
files. In your case, this will be very complicated as you will need to
assure that the QIFs exported from the to-be-merged file do not contain any
transactions that duplicate those in the merge-with-this file.

"Teffy" <WGSGNUAYHTTE[at]spammotel.com> wrote in message
news:1105348819.105118.178770[at]c13g2000cwb.googlegroups.com...
- quote -

Today is the first time I have understood the difference between backup
and archive. So, I searched the disk and CDs for archive (.qif) files,
and didn't find any. Could archive have been done automatically, or did
I just spasticly do it without realizing?

Anyway, I do have a backup (.mbf) file from six months ago which has
all the transactions missing in my current money file. How can I merge
these two files?

Thanks,

Teffy

Are you sure you haven't archived at some stage?

--
Regards
Bob Peel,
Microsoft MVP - Money

For UK tips & fixes see
http://support.microsoft.com/default...d=fh;EN-GB;mny.
For wishes or suggestions see
http://register.microsoft.com/mswish/suggestion.asp
or for UK wishes http://www.microsoft.com/uk/support/money/feedback

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

<WGSGNUAYHTTE[at]spammotel.com> wrote in message
news:1105179321.488903.16580[at]f14g2000cwb.googlegroups.com...
- quote -

Did you ever get a wild hair that you needed to Archive?

<WGSGNUAYHTTE[at]spammotel.com> wrote in message
news:1105179321.488903.16580[at]f14g2000cwb.googlegroups.com...
- quote -

Additional info: there are some transactions before 2004 which are
visible: they are all "transfers."

And yes, I am selecting "View all transactions covering all dates."
Thanks,
Teffy

I used Microsoft Money 2000 Deluxe until switching last summer to Money
2004 Standard OEM Edition. I just noticed that transactions before the
year 2004 are missing! Holy smokes! What is going on?

All of my old accounts are listed, but if I try to view the
transactions in an old account, the list is empty. Open accounts which
should contain many years worth of data, show only those transactions
for the year 2004. (I have not yet entered any for 2005).

My old reports are present, but when I view reports for years previous
to 2004, they contain no data.
Teffy

P.S. I originally started with Quicken in the 1990's.