|
#5
| |||
| |||
| "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, I guess what you imply is correct, I am just not *that* motivated. :-)> > > "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
You're right, of course. I will ask the bank to do this, and I'll be> > 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. 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
Thanks very much for taking the time and trouble to try to help me, and I'll> 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". 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
| |||
| |||
| In microsoft.public.money, Old Geezer wrote: - quote - > "Cal Learner-- MVP" <via_newsgroup[at]please.tnx> wrote in message
I don't know how adept or motivated you are. It would be fairly> 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. 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
The first thing to do would be to see if the QIF actually has the> nuisance to do this with each and every one manually. 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
| |||
| |||
| "Cal Learner-- MVP" <via_newsgroup[at]please.tnx> wrote in message news:rej7l1lk5ied4t85tsi8s47qub53pcorum[at]4ax.com... - quote - > In microsoft.public.money, Old Geezer wrote:
Is there some way I could do that automatically? I have five online bill> > 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? 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
| |||
| |||
| In microsoft.public.money, Old Geezer wrote: - quote - > Glyn, thanks for the reply.
*Any* way?> 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.) Including pre-processing the QIF outside of Money? |
|
#1
| |||
| |||
| 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? > > > > |
| | |||
| |||
| 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
| |||
| |||
| 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 | |
| |