Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #4  
Old 01-02-2005, 03:33 AM
KEITH A
Guest
 
Posts: n/a
Default Re: Rebuilding Money file...

I experienced an error message when attempting multiple QIF file imports.
The message was something like "file name length on imported file cannot
exceed about 1500 characters". I never found an answer to what this meant
but assume the file name length is the result of concatenations of all QIF
file names. I'd try to keep the QIF file names as sort as possible.


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

> In microsoft.public.money, Dick Watson wrote:
> > Ctrl+Click (multi-select of all of the QIF files) applies to any accounts
> > that involve transfers from one to another. There is also some order
> > dependence, but I don't recall what it is. Cal would.

> You will have to have your existing version of Money installed when
> you export each of your accounts to a loose QIF file. You will
> have one file for each account. For an investment account, you
> will have a file for the investment transactions, and a separate
> file for the cash transactions.
> A non-obvious thing: Richard Bollar has discovered that it is
> important that the investment accounts be imported first in the
> process. How? Name the QIF files such that they come first
> alphabetically. So you could, for example, lead off each
> investment account's QIF file name with an underscore. That will
> alphabetize before numbers and letters.
> > > "Jonathan" <liljonny[at]comcast.net> wrote in message

> > news:f51bt0lusr8s6r6bk4li6chn16s60eslpi[at]4ax.com...
> > > You also have to use Ctrl click to highlight all investment accounts
> > > first to import them at the same time. Then use Ctrl click to
> > > highlight all other accounts to import them at the same time. If you
> > > don't do this, you will end up with duplicate transactions. Another
> > > limit on QIF import is no stock splits are imported.

>


  #3  
Old 12-31-2004, 08:55 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Rebuilding Money file...

In microsoft.public.money, Dick Watson wrote:

- quote -

> Ctrl+Click (multi-select of all of the QIF files) applies to any accounts
> that involve transfers from one to another. There is also some order
> dependence, but I don't recall what it is. Cal would.




You will have to have your existing version of Money installed when
you export each of your accounts to a loose QIF file. You will
have one file for each account. For an investment account, you
will have a file for the investment transactions, and a separate
file for the cash transactions.

A non-obvious thing: Richard Bollar has discovered that it is
important that the investment accounts be imported first in the
process. How? Name the QIF files such that they come first
alphabetically. So you could, for example, lead off each
investment account's QIF file name with an underscore. That will
alphabetize before numbers and letters.


- quote -

> "Jonathan" <liljonny[at]comcast.net> wrote in message
> news:f51bt0lusr8s6r6bk4li6chn16s60eslpi[at]4ax.com...
> > You also have to use Ctrl click to highlight all investment accounts
> > first to import them at the same time. Then use Ctrl click to
> > highlight all other accounts to import them at the same time. If you
> > don't do this, you will end up with duplicate transactions. Another
> > limit on QIF import is no stock splits are imported.


  #2  
Old 12-31-2004, 08:39 PM
Dick Watson
Guest
 
Posts: n/a
Default Re: Rebuilding Money file...

Ctrl+Click (multi-select of all of the QIF files) applies to any accounts
that involve transfers from one to another. There is also some order
dependence, but I don't recall what it is. Cal would.

"Jonathan" <liljonny[at]comcast.net> wrote in message
news:f51bt0lusr8s6r6bk4li6chn16s60eslpi[at]4ax.com...
- quote -

> You also have to use Ctrl click to highlight all investment accounts
> first to import them at the same time. Then use Ctrl click to
> highlight all other accounts to import them at the same time. If you
> don't do this, you will end up with duplicate transactions. Another
> limit on QIF import is no stock splits are imported.



  #1  
Old 12-31-2004, 04:08 PM
Jonathan
Guest
 
Posts: n/a
Default Re: Rebuilding Money file...

You also have to use Ctrl click to highlight all investment accounts
first to import them at the same time. Then use Ctrl click to
highlight all other accounts to import them at the same time. If you
don't do this, you will end up with duplicate transactions. Another
limit on QIF import is no stock splits are imported.

Jonathan.



On Fri, 31 Dec 2004 07:24:54 -0700, "Dick Watson"
<littlegreengecko[at]mind-enufalready-spring.com> wrote:

- quote -

> The issues with your proposal include:
> 1) You will have to hand-edit each QIF file to eliminate the old data. QIF
> export is all or nothing, on an account-by-account basis. You will also have
> to somehow compute the starting balance for the accounts you are going to
> recreate from that arbitrary date.
> 2) QIF export/import has limits like no Loan accounts.
> 3) You will have to recreate any scheduled bills/DRP/Lifetime Planner/BP etc
> info.
> By itself, the size of your file is not a certain problem. Mine's pushing
> 54MB.
> "Tom" <tom[at]nospam.com> wrote in message
> news:eHRKN1z7EHA.2124[at]TK2MSFTNGP14.phx.gbl...
> > I think I am having some issues with my Money 2005 file that just doing a
> > file repair is not going to fix. These issues include error messages when
> > cashing in a CD; online problems with just one account; random crashes,
> > etc. My file is 40MB and contains a number of years of data; some of which
> > I really no longer need. Basically, what I am thinking of doing is
> > completely rebuilding my data file. This would (1) Give me a fresh copy
> > which may resolve some of my issues; and (2) Allow me to import only the
> > last 5 years of data, which is really all that I want to use now (but keep
> > the rest for archival purposes); and (3) Reduce the size of my data file.
> > > Anyone have ideas or instructions on doing a complete rebuild of Money's

> > data file? Basically, I believe I need to do something like this: Create
> > the new data file; Create all the accounts, categories, payees, etc as my
> > old file; then reimport each account based upon the date (i.e. everything
> > starting with 1/1/2000).
> > > Any advice appreciated. Thanks in advance.


 
Old 12-31-2004, 01:24 PM
Dick Watson
Guest
 
Posts: n/a
Default Re: Rebuilding Money file...

The issues with your proposal include:

1) You will have to hand-edit each QIF file to eliminate the old data. QIF
export is all or nothing, on an account-by-account basis. You will also have
to somehow compute the starting balance for the accounts you are going to
recreate from that arbitrary date.

2) QIF export/import has limits like no Loan accounts.

3) You will have to recreate any scheduled bills/DRP/Lifetime Planner/BP etc
info.

By itself, the size of your file is not a certain problem. Mine's pushing
54MB.

"Tom" <tom[at]nospam.com> wrote in message
news:eHRKN1z7EHA.2124[at]TK2MSFTNGP14.phx.gbl...
- quote -

> I think I am having some issues with my Money 2005 file that just doing a
> file repair is not going to fix. These issues include error messages when
> cashing in a CD; online problems with just one account; random crashes,
> etc. My file is 40MB and contains a number of years of data; some of which
> I really no longer need. Basically, what I am thinking of doing is
> completely rebuilding my data file. This would (1) Give me a fresh copy
> which may resolve some of my issues; and (2) Allow me to import only the
> last 5 years of data, which is really all that I want to use now (but keep
> the rest for archival purposes); and (3) Reduce the size of my data file.
> Anyone have ideas or instructions on doing a complete rebuild of Money's
> data file? Basically, I believe I need to do something like this: Create
> the new data file; Create all the accounts, categories, payees, etc as my
> old file; then reimport each account based upon the date (i.e. everything
> starting with 1/1/2000).
> Any advice appreciated. Thanks in advance.



  #-1  
Old 12-31-2004, 12:33 PM
Tom
Guest
 
Posts: n/a
Default Rebuilding Money file...

I think I am having some issues with my Money 2005 file that just doing a
file repair is not going to fix. These issues include error messages when
cashing in a CD; online problems with just one account; random crashes, etc.
My file is 40MB and contains a number of years of data; some of which I
really no longer need. Basically, what I am thinking of doing is completely
rebuilding my data file. This would (1) Give me a fresh copy which may
resolve some of my issues; and (2) Allow me to import only the last 5 years
of data, which is really all that I want to use now (but keep the rest for
archival purposes); and (3) Reduce the size of my data file.

Anyone have ideas or instructions on doing a complete rebuild of Money's
data file? Basically, I believe I need to do something like this: Create the
new data file; Create all the accounts, categories, payees, etc as my old
file; then reimport each account based upon the date (i.e. everything
starting with 1/1/2000).

Any advice appreciated. Thanks in advance.

Tom


 

Tags
file, money, rebuilding
Similar Threads
Thread Forum Replies Last Post
restoring Backup file and money file
SC: Hi, I have a problem restoring my backup file. I was playing with money and was attempting to create a new budget. They told me to create a new...
Microsoft Money 1 09-06-2004 01:50 PM
Can I convert Money Standard 2004 file to Money Business 200 file
Pamela: Can I convert my Money Standard 2004 files to Money Business files without problems? I run a small business out of my home and I would like to...
Microsoft Money 2 05-10-2004 12:28 AM
corrupt file or not a money back up file
Cammy: I know that this has been posted before, but never saw any where the issue was resolved and how it was resolved. I have three sets of back up...
Microsoft Money 2 02-02-2004 01:17 PM
Want to save a Money 2004 file as Money 2003 file at end of trial
DTK: I have been using Money 2001/2003 for about a couple years, but I accepted the internet offer of a 90 day(?) trial of Money 2004. My trial period...
Microsoft Money 3 10-18-2003 01:05 PM



Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

All times are GMT. The time now is 04:47 AM.