locked
Microsoft Money 2000, german version - data migration. RRS feed

  • Question

  • Hello!

    1) I have yoused Microsoft Money 2000 German Version) since a very Long time for private use with several accounts on it - for a few years and started than another new file for the next years.

    As a result I have now I have several seperate files for different years - is it possible to merge These files to make one out of it and if, how to proceed?

    2. I thought that Microsoft Money 2000 has been stopped since a long time but I see here in this Forum, that there my be some updates availible? Which one would be useful to be downloaded?

    Thanks for any advise,

    Henry.

    Sunday, March 29, 2020 7:02 PM

All replies

  • Keep several appropriately named backups on different media, in case you get a disk crash. These are how you can undo things.

    To merge or combine Money file, make a copy of the more complex
    account using the operating system.  Give that file a new name to
    represent the shared accounts.  Export each account that you want to
    merge from the other file (the least complex).  Use loose qif.

    Import the files all at once into the now-shared account.  Use
    Cntl-click to select files for the single import.

    Another option would be to install Money Plus Deluxe Sunset, preferably onto a different computer. Then import the QIF files. When you import, always import all of the QIF files that you are merging, all at once. Money takes inferences to allow it to match up transfers that way. 

    QIF export and import have limitations. For example, the symbols don't export or import. You will also have some cleaning up to do for things that don't come in as you hope.



    Sunday, March 29, 2020 8:07 PM
    Moderator
  • Hi Henry,

    No, there is no update available for the German version. Each language version of Money is unique and cannot read the file from another language or geographic version.


    Bob - MSN Mobile

    Sunday, March 29, 2020 9:52 PM
  • Thanks for the Information. I have tried out both Options today, unfortunately, both did not work out for me:

    With Money 2000 I could get the "Export" done, but was not able to merge. I could choose the files to merge but when it came to choose the master file it gave me only file names which did not include my "master file". I have tried it also with exporting a copy of my master file too and with a backup-master file - non of them came up in the options to choose.

    After that I tried it on another computer (laptop) with an newly downloaded Money Sunset - I got the following message when trying to open my Money 2000 file with Sunset: "Money can´t open this file because it was created with a different Version of Money" - this may be what Bob is talking about in the thread below.

    One more question came up in my mind:

    How much data can Money 2000 handle - is there a limit on entries or file size? I have not found anything about it ich the help files (my Money file has About 16000 KB).

    By the way, my Money 2000 is Version "8", I may have bought it 1999 or 2000. (before I was using Money 1997.

    Thanks in Advance,

    Henry.

    Monday, March 30, 2020 2:51 PM
  • Thanks for the Information. I have tried out both Options today, unfortunately, both did not work out for me:

    With Money 2000 I could get the "Export" done, but was not able to merge. I could choose the files to merge but when it came to choose the master file it gave me only file names which did not include my "master file". I have tried it also with exporting a copy of my master file too and with a backup-master file - non of them came up in the options to choose.

    The master file would be a copy one of the files  that you don't get QIFs from, or it would be a new empty file, if you want to get QIFs from each file. So money does not ask the name of the master file. It is the file that is open when you import.

    Remember to change the backup file names in  so your new file's backups don't overwrite your other backups. Tools->Options->Backup would be the path in English.

    For an Investment account, where you track cash, export and import QIFs for both the cash account and the investment account.




    Monday, March 30, 2020 6:14 PM
    Moderator
  • Hello again and thank you for your quick reply.!

     

    I tried once more and it seems that it worked out this time with importing the old files to Money 2000.

    I overlooked at the first time, that the program asked me to create some new  accounts which were missing in the main file. I have now more than 21000KB of file size.

    Do you know how many entries or what the size limit of Money 2000 is? 

    Many thanks and best Regards,

    Henry.

    Monday, March 30, 2020 6:57 PM
  • Nice. It has been a long time since I experimented with QIF export and import.

    I expect 21 meg is not near the limits, but I am not sure when the limits and constraints got really big. It might have been with Money 99.

    My Money Plus file is over 10x that size, but most of that is probably quotes.

    Do make a backup strategy that gives you more than one vintage of backup, and survives a drive failure.


    Monday, March 30, 2020 7:30 PM
    Moderator
  • Do you know how many entries or what the size limit of Money 2000 is? 

    Don't know about 'Money 2000', but for Sunset, my *.mny file is 113M.

    My biggest space usage is in transactions, followed by security prices. Those two accounts for 81% of all usage space.

    And the rest of the space usage break down.

    <google-sheets-html-origin>
    tableName bytes rows indexes bytes (%) bytes (r %) notes
    TRN 86429696 120577 32 73.1024% 73.1024% Transactions
    SP 10407936 64071 5 8.8030% 81.9054% Security prices
    PAY 5033984 12311 17 4.2578% 86.1632% Payees
    LOT 3936256 7922 24 3.3293% 89.4925% Lot
    CRIT 3063808 22544 5 2.5914% 92.0838% Internal table for msmoney (criteria?)
    TRN_SPLIT 2031616 32838 4 1.7183% 93.8022% Transactions split data
    TRN_XFER 991232 22822 3 0.8384% 94.6406% Transactions transfer data
    X_ITM 622592 1274 3 0.5266% 95.1672% Internal table for msmoney
    VIEW 544768 4299 7 0.4608% 95.6279%
    STMT 520192 1113 5 0.4400% 96.0679%
    XPAY 495616 12311 2 0.4192% 96.4871%
    ACCT 385024 375 31 0.3257% 96.8127%
    TRN_INV 372736 4613 6 0.3153% 97.1280%
    CAT 290816 677 24 0.2460% 97.3740%
    PROV_FI 258048 79 10 0.2183% 97.5922%
    SEC 200704 255 16 0.1698% 97.7620%
    BGT_ITM 180224 578 11 0.1524% 97.9144%
    XBAG 172032 1193 4 0.1455% 98.0599%
    BILL 143360 247 13 0.1213% 98.1812%
    ADDR 106496 458 12 0.0901% 98.2713%
    SOQ 102400 500 5 0.0866% 98.3579%
    CLI_DAT 94208 346 2 0.0797% 98.4376%
    FI 81920 76 8 0.0693% 98.5068%
    ITM 81920 190 7 0.0693% 98.5761%
    TXSRC 73728 180 5 0.0624% 98.6385%
    X_PARM 73728 247 5 0.0624% 98.7008%
    PREF_LIST 57344 152 6 0.0485% 98.7494%
    SVC 57344 148 6 0.0485% 98.7979%
    MAIL 49152 4 7 0.0416% 98.8394%
    Worksheet Custom Pool 49152 23 3 0.0416% 98.8810%
    CRNC 45056 155 11 0.0381% 98.9191%
    ... truncated to due posting limit
    118231040 314396 507
    </google-sheets-html-origin>

    Sunday, April 5, 2020 5:59 PM