Home → Problems →

I'm an absolute idiot and I edited the WRONG FILE! [cartoon curse words. . .]

• Edit

jimrh

Mar 31, 2022 @ 06:00 PM

Greetings!

I am a [insert desired invective] idiot. I freely acknowledge that - head-banging and everything.

Issue:
I just imported all my primary bank account data for the last year, and have painstakingly gone through every transaction, renamed as appropriate, classified, confirmed, burned brown rice, the works - spent an entire week doing it.

When I imported the next account's data, everything looked good until I scrolled up to the top of the new data:
Ending date of last transaction of the file: December 2019
Beginning date of imported data: January 2021. (!!!!)
[insert 15 minutes of anguished cursing]

I now have an entire weeks work entered into an old file that I cannot use and I am looking at an entire week of duplicating the work I did before, now that I have found the correct file.

Question:
Is it possible to abstract just the new data and then import it into the correct year's file? I know I can "export a backup" but that's everything.

If I have to do it all over again, that just stinks being me, but I'd really rather not do that if I don't have to.

Suggestions?

Thanks!
Jim

1. 1 Posted by Stuart Beesley ... on Mar 31, 2022 @ 06:06 PM

   

   Try File... Export... QIF... Select Date range...
   Then import the QIF
   AFTER A BACKUP

   • Edit

2. 2 Posted by jimrh on Mar 31, 2022 @ 07:31 PM

   

   Stuart,

   You are DA BOMB! - A Wizard and a lifesaver. (not the candy kind :wink: )

   It took a couple of tries to get dates to line up correctly, (and I had to nuke a couple of duplicates), but this was absolutely wizard - everything's in and the final balance in Moneydance matches the bank to the penny!

   There's still some classification to do, but the transactions are all there and correct. Thank you good sir, I am sure there is a special place in Heaven for you.

   Thanks!
   Jim

   • Edit

3. 3 Posted by Stuart Beesley ... on Mar 31, 2022 @ 08:01 PM

   

   👍 🧙‍♀️ 😃

   • Edit

4. 4 Posted by dwg on Mar 31, 2022 @ 09:02 PM

   

   Or we make you did it the hard way and then you never make the same mistake again :)

   Most of us have had multiple attempts at getting the imports right - I took a backup after doing every account and I had to restore a few times when it didn't quite turn out as I wanted.

   • Edit

5. 5 Posted by jimrh on Apr 01, 2022 @ 10:50 AM

   

   I said:

   I am a [insert desired invective] idiot. I freely acknowledge that - head-banging and everything.

   Dwg said:

   Or we make you did it the hard way and then you never make the same mistake again :)

   If I were less an idiot, I would have learned from the last time! :wink:

   I do, kind-of, protect myself from things like this by making a named backup every time there's a major change.

   Viz.:

   • I carry forward and rename for the new year
   • I finish importing data to a particular account
   • I finish categorizing
   • a particular account balances
   • etc.

   This way there's always a "saved" game to go back to when I make a balls-up of things.

   My big problem is the naming convention: Jim_Svetlana_2021_[string of tiny numbers that are difficult to read].moneydancebackup - and it's easy to confuse them. If it's been a hard day, I'm tired, and then I open an older file and well - it happens! That's why I make named backups frequently.

   Kind of like playing a video game - save the game before fighting the huge boss - it saves you from having to spend a half-day or so, fighting all the small monsters again.

   • Edit

6. jimrh closed this discussion on Apr 05, 2022 @ 04:35 PM.