Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #5  
Old 10-19-2005, 04:09 PM
Old Geezer
Guest
 
Posts: n/a
Default Re: How to change Payee column width in Money?


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

> In microsoft.public.money, Old Geezer wrote:
> > > "Cal Learner-- MVP" <via_newsgroup[at]please.tnx> wrote in message

> > news:rej7l1lk5ied4t85tsi8s47qub53pcorum[at]4ax.com...
> > > In microsoft.public.money, Old Geezer wrote:
> > > > > > Glyn, thanks for the reply.
> > > > > > > Since I can't change the field width, is there any way I can have the
> > > > downloaded titles automatically changed to something else? (I could
> > > > easily
> > > > abbreviate the first four words, leaving more room for a payee
> > > > description.)
> > > > > *Any* way?
> > > > > Including pre-processing the QIF outside of Money?
> > > Is there some way I could do that automatically? I have five online bill

> > payments every month. Normally I just download the QIF from my bank, Money
> > spots this and asks if I want to start Money, and so on. So I don't deal
> > with the QIF at all outside of Money, normally, but I'm sure I could if I
> > wanted to. As I recall it's downloaded as "history.qif" or something close
> > to that.

> I don't know how adept or motivated you are. It would be fairly
> easy to have Money not field the downloads automatically. Then you
> would run a batch file or program that would modify the file as it
> sits in a known place with a known name.
> More sophisticated would be to have a program that automatically
> fields QIF files, does the modification, and forwards the file on to
> Money. That would probably not end up being a time saver
> intrinsically. You would have to be motivated beyond taking the
> easiest solution.


Cal, I guess what you imply is correct, I am just not *that* motivated. :-)


- quote -

> > > Of course I can edit the entries once they're in Money, but it'd be a
> > nuisance to do this with each and every one manually.

> The first thing to do would be to see if the QIF actually has the
> data beyond the 32 characters that Money shows you. If there are no
> more characters in the QIF file, then there is really nothing you
> can do about it.
> The best, but probably naive, solution would be to ask the bank to
> put the useful information into the 32 characters.


You're right, of course. I will ask the bank to do this, and I'll be
surprised if they agree to change their procedure to suit me.


- quote -

> In case you want to experiment, here is some information to get you
> started:
> Start-> Settings-> ControlPanel-> FolderOptions-> FileTypes
> Select QIF
> Click Advanced. Check Confirm Open After Download unless
> you would not like the pop-up box. That is the one I am suggesting
> you try now. That way you have the option to select to save the file
> to disk, or to click Open and feed the file to Money as you do not.
> You could always change it back.
> I would check the Always Show Extension, but
> you may choose not to.
> See that the "Actions" box contains "Open" in bold. If it is not
> bold, you can select Open as the default action by clicking the
> Set Default button. No change is anticipated for you at this stage.
> Click Edit.
> When you click edit, the application used to perform action should
> be similar to the following line:
> "C:\Program Files\Microsoft Money\System\mnyimprt.exe" %1
> WITH the quotes, and the %1 after the quote. Adjust the path
> according to where Money is installed on your system. Modify for
> your setup. Use DDE should be checked. This is the section that you
> would modify if you made your own handler. I don't expect you will
> choose to go that far, but it is compatible with "possible" and
> "some way".


Thanks very much for taking the time and trouble to try to help me, and I'll
save this just in case I do get that ambitious. This appears to be one of
those cases where the cure would be more bothersome than the ailment. The
one completely satisfactory solution would be for Money to allow that column
width to be changed, and since that's out I guess I'm stuck with it.

Thanks again.


  #4  
Old 10-18-2005, 02:59 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: How to change Payee column width in Money?

In microsoft.public.money, Old Geezer wrote:

- quote -

> "Cal Learner-- MVP" <via_newsgroup[at]please.tnx> wrote in message
> news:rej7l1lk5ied4t85tsi8s47qub53pcorum[at]4ax.com...
> > In microsoft.public.money, Old Geezer wrote:
> > > > Glyn, thanks for the reply.
> > > > > Since I can't change the field width, is there any way I can have the
> > > downloaded titles automatically changed to something else? (I could easily
> > > abbreviate the first four words, leaving more room for a payee
> > > description.)
> > > *Any* way?
> > > Including pre-processing the QIF outside of Money?

> Is there some way I could do that automatically? I have five online bill
> payments every month. Normally I just download the QIF from my bank, Money
> spots this and asks if I want to start Money, and so on. So I don't deal
> with the QIF at all outside of Money, normally, but I'm sure I could if I
> wanted to. As I recall it's downloaded as "history.qif" or something close
> to that.


I don't know how adept or motivated you are. It would be fairly
easy to have Money not field the downloads automatically. Then you
would run a batch file or program that would modify the file as it
sits in a known place with a known name.

More sophisticated would be to have a program that automatically
fields QIF files, does the modification, and forwards the file on to
Money. That would probably not end up being a time saver
intrinsically. You would have to be motivated beyond taking the
easiest solution.
- quote -

> Of course I can edit the entries once they're in Money, but it'd be a
> nuisance to do this with each and every one manually.


The first thing to do would be to see if the QIF actually has the
data beyond the 32 characters that Money shows you. If there are no
more characters in the QIF file, then there is really nothing you
can do about it.

The best, but probably naive, solution would be to ask the bank to
put the useful information into the 32 characters.

In case you want to experiment, here is some information to get you
started:

Start-> Settings-> ControlPanel-> FolderOptions-> FileTypes

Select QIF

Click Advanced. Check Confirm Open After Download unless
you would not like the pop-up box. That is the one I am suggesting
you try now. That way you have the option to select to save the file
to disk, or to click Open and feed the file to Money as you do not.
You could always change it back.

I would check the Always Show Extension, but
you may choose not to.


See that the "Actions" box contains "Open" in bold. If it is not
bold, you can select Open as the default action by clicking the
Set Default button. No change is anticipated for you at this stage.

Click Edit.

When you click edit, the application used to perform action should
be similar to the following line:
"C:\Program Files\Microsoft Money\System\mnyimprt.exe" %1
WITH the quotes, and the %1 after the quote. Adjust the path
according to where Money is installed on your system. Modify for
your setup. Use DDE should be checked. This is the section that you
would modify if you made your own handler. I don't expect you will
choose to go that far, but it is compatible with "possible" and
"some way".


  #3  
Old 10-18-2005, 02:44 PM
Old Geezer
Guest
 
Posts: n/a
Default Re: How to change Payee column width in Money?


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

> In microsoft.public.money, Old Geezer wrote:
> > Glyn, thanks for the reply.
> > > Since I can't change the field width, is there any way I can have the

> > downloaded titles automatically changed to something else? (I could easily
> > abbreviate the first four words, leaving more room for a payee
> > description.)

> *Any* way?
> Including pre-processing the QIF outside of Money?


Is there some way I could do that automatically? I have five online bill
payments every month. Normally I just download the QIF from my bank, Money
spots this and asks if I want to start Money, and so on. So I don't deal
with the QIF at all outside of Money, normally, but I'm sure I could if I
wanted to. As I recall it's downloaded as "history.qif" or something close
to that.

Of course I can edit the entries once they're in Money, but it'd be a
nuisance to do this with each and every one manually.


  #2  
Old 10-17-2005, 04:15 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: How to change Payee column width in Money?

In microsoft.public.money, Old Geezer wrote:

- quote -

> Glyn, thanks for the reply.
> Since I can't change the field width, is there any way I can have the
> downloaded titles automatically changed to something else? (I could easily
> abbreviate the first four words, leaving more room for a payee description.)


*Any* way?

Including pre-processing the QIF outside of Money?
  #1  
Old 10-17-2005, 03:59 PM
Old Geezer
Guest
 
Posts: n/a
Default Re: How to change Payee column width in Money?

Glyn, thanks for the reply.

Since I can't change the field width, is there any way I can have the
downloaded titles automatically changed to something else? (I could easily
abbreviate the first four words, leaving more room for a payee description.)



"Glyn Simpson, MVP" <glyn[at]serf.org> wrote in message
news:%23V1sWyu0FHA.560[at]TK2MSFTNGP12.phx.gbl...
- quote -

> The width of the payee field is 32 characters. The example below is 32
> characters long, hence the truncation. The is the same in later versions
> (and the OFX spec I think has a 32 character limit on this field).
> --
> Glyn Simpson, Microsoft MVP - Money
> http://money.mvps.org/
> Check http://money.mvps.org/faq/ for tips and fixes for MS Money. To send
> Microsoft your product wishes see http://money.mvps.org/wishes.aspx
> I do not respond to any unsolicited email regarding Money
> "Old Geezer" <nowhere[at]all.net> wrote in message
> news:%23X%23mWlo0FHA.4032[at]TK2MSFTNGP15.phx.gbl...
> > Money 2002 Standard OEM does all I need, and though I have a couple of
> > later versions around here I've seen no reason to upgrade.
> > > The one annoying thing is, when I download a QIF file from my bank,

> > online bill payments show up in the Payee column like this:
> > PEOPLE'S ONLINE BILL PAYMENT CON
> > etc., always with only the first three characters of the payee's name,
> > and since some of the payees' names have similar first three letters it
> > is not as clear as it could be.
> > > Is there any way to increase the column width (number of characters)? I

> > have loads of space in that column going unused. I can't find anything in
> > the Help section that addresses this.
> > > If I can't in Money 2002, would a later version allow me to increase this

> > column width?
> > > >


 
Old 10-17-2005, 07:28 AM
Glyn Simpson, MVP
Guest
 
Posts: n/a
Default Re: How to change Payee column width in Money?

The width of the payee field is 32 characters. The example below is 32
characters long, hence the truncation. The is the same in later versions
(and the OFX spec I think has a 32 character limit on this field).

--
Glyn Simpson, Microsoft MVP - Money
http://money.mvps.org/

Check http://money.mvps.org/faq/ for tips and fixes for MS Money. To send
Microsoft your product wishes see http://money.mvps.org/wishes.aspx

I do not respond to any unsolicited email regarding Money

"Old Geezer" <nowhere[at]all.net> wrote in message
news:%23X%23mWlo0FHA.4032[at]TK2MSFTNGP15.phx.gbl...
- quote -

> Money 2002 Standard OEM does all I need, and though I have a couple of
> later versions around here I've seen no reason to upgrade.
> The one annoying thing is, when I download a QIF file from my bank, online
> bill payments show up in the Payee column like this:
> PEOPLE'S ONLINE BILL PAYMENT CON
> etc., always with only the first three characters of the payee's name, and
> since some of the payees' names have similar first three letters it is not
> as clear as it could be.
> Is there any way to increase the column width (number of characters)? I
> have loads of space in that column going unused. I can't find anything in
> the Help section that addresses this.
> If I can't in Money 2002, would a later version allow me to increase this
> column width?



  #-1  
Old 10-16-2005, 07:39 PM
Old Geezer
Guest
 
Posts: n/a
Default How to change Payee column width in Money?

Money 2002 Standard OEM does all I need, and though I have a couple of later
versions around here I've seen no reason to upgrade.

The one annoying thing is, when I download a QIF file from my bank, online
bill payments show up in the Payee column like this:
PEOPLE'S ONLINE BILL PAYMENT CON
etc., always with only the first three characters of the payee's name, and
since some of the payees' names have similar first three letters it is not
as clear as it could be.

Is there any way to increase the column width (number of characters)? I have
loads of space in that column going unused. I can't find anything in the
Help section that addresses this.

If I can't in Money 2002, would a later version allow me to increase this
column width?




 

Tags
change, column, money, payee, width
Similar Threads
Thread Forum Replies Last Post
Today's Total Change column
HalB: This column is always blank for my mutual funds, even though the Last Price and Change columns have the current/correct information. There was a...
Microsoft Money 4 11-04-2004 11:30 PM
Change Column in Portfolio
Jan: When looking at the portfolio view of investments, the change column is only updated when prices are updated on- line. It reflects 0's when updated...
Microsoft Money 1 06-04-2004 07:36 AM



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 01:49 PM.