[WOelsner]

David,
I too, would like a way to upload from Excel into NV1 for our credit card transactions. Bank of America offers to download data as:
1) statement download for Money 2006 and above;
2) WEB Connect for Quicken 2006 and above;
3) .QIF
4) .QIF (with 2-digit year)
5) Comma deliminated

I can use (5) Comma delimited export format to go from Bank of America statements to an Excel spreadsheet to re-arrange the columns and add our cross-accounts, but how should I export to NewViews?

I used to
a) export that updated file from Excel into ascii
b) upload that into a program called Framework where I could add musical note characters and diamonds then resave in ascii
c) open the file in Edline, remove the header, save, then
d) import the file into NV1 as a CTRL-C file.

******* (Complicated is always more fun than straight input) ******

Framework (by Ashton Tate) no longer survives. So now I input the credit card transactions. But I think many old users, would like to be able to concoct a way to export from Excel to ascii to NV1.

Can you give us a hint?

[WOelsner]

Bob Halpern,

This is just a quick note to thank you for your time and effort to help me overcome my lapse in knowledge.

I’m going to tackle the problem again over the week-end. I don’t know why the
the NET USE LPT1 /Delete and NET USE LPT1: \WKOHP2200 /PERSISTENT:YES hasn’t worked. I get all the appropriate confirmations.

I just wanted to thank you for your magnanimous effort, before I disappear for a few days.

Kindest Regards, Bill

[WOelsner]

I think I’ll have to give up. I seem to have learned far more than I wanted to know about net use, but not enough to get it to work. If my printer is returning error codes, and it very well could be because my NewViews program is from 1993 and my HP2200 is probably only 6 years old, I’m in for trouble. Hasn’t everybody els had problems lining up their print pages?
I’ve also noticed that New Views is “freezing” at least once a day. This occurs when I have left the NV DOS window open and come back to it after doing other things in windows 2007. I just think Microsoft is trying to push everyone out of DOS.
Over the long week-end, Presidents Day, for you’ll enjoying the Alberta clipper, I tried someone’s suggestion to employ DOS2USB.com’s program. The best part was it worked, and it allowed me several new formats. There were, though, three drawbacks. First, whenever I print, a dialog box appears asking me to type in an access key while another dialog box informed me I could print 50 times before buying). The second drawback was paying for the $20 product. The cost was reasonable, but I had to pay a firm in India through a Los Angeles intermediary. I wanted to pay using paypal, but the intermediary wanted my Paypal info (and password) so that they could “who knows what??”. The next day I noticed I had recieved an email from India asking if I liked the program? I asked if I could use PayPal, and what was their PayPal email (for those unfamiliar with PayPay, if you agree to a PayPal account, the PayPal company associates a credit card, checking account, or mailing address with a unique email address. A person can then make payments by going to the PayPal websight, signing in, and requesting that they send, in this case $23.00 to paypal@dos2usb.com). Hopefully, I’ll recieve the access key shortly. The third drawback is that the program sometimes printed on its own, especially when I was using NV’s import function. The printer output was one line per page, and required me to turn off the printer, wait for NV to unfreeze, close NV, or the window (we no longer get the “closing this window may not shut down NV correctly” type message). And reboot my computer to get back control.
Now I can’t even print. I don’t know what happened to the DOS2USB program. It no longer shows up.

I really hate to buy the NV windows program. But I may have to. I’m just a small consulting firm, and too old to learn another program.

Is it really hard to convert from NV DOS to NV Windows? Its the middle of end-of the year time, and I really can’t go to school in Markham right now because it is too &*^#%$ cold!!!

[WOelsner]

continuing.

If I don’t designate a “File Name” in NV’s print options, when I try to print I get the message “ERROR: printer busy or not selected”

If I designate “LPT1” as the “File Name” in NV’s print options, when I try to print I get the message “ERROR: Cannot write to file specified in /Print Options”

If I designate “HP2200” as the “File Name” in NV’s print options, when I try to print, the file HP2200 is created”. Nothing prints. Using the DOS prompt, if I go to my NV directory, and type the command > print HP2200, I get the error message “unable to initialize device PRN”. If I use the DOS program named EDIT, by typing at the C:NV> Edit HP2200 the print file opens up. The EDIT program has a “PRINT” command, and when I use that, it finally prints through the USB port to my HP2200.

I think I’m almost there!! Any ideas for the final steps.

BTW, in NV’s Printer Options, I’ve set my Printer to “HP12P”

[WOelsner]

Further to my post earlier, I’m learning.

I set up HP2200 to be my shared printer.

I found my computer name, which is WKO
I ran the command >net use HP2200 \WKOHP2200 /PERSISTENT:YES
The command completed successfully

command> net share (provides following response)
Share name Resource Remark
C$ C: Default share
print $ C:windowssystem32spooldrivers Printer Drivers
IPC$ Remote IPC
ADMIN$ c:windows Remote Admin
Public c:usersPublic
HP2200 DOT4_001 Spooled HP Laserjet2200
Send to OneNote 2007 Send to Microsoft OneN Spooled Send to OneNote 2007
The command completed successfully

command >net use (provides the following)
New Connections will bne remembered
Status Local Remote Network
_____________ ___________________ ______________ _______________
OK LPT1 \WKOHP2200 Microsoft Windows Network
The Command completed successfully.

But When I try to print in NewViews, I get the response:
Error: Printer Busy or not selected

I’ve tested the printer in DOS using the EDIT progam. I can open a batch file And the batch file prints out fine.

Any suggestions?

[WOelsner]

I am having similar difficulty printing with New Views DOS version. I just replaced my broken computer with a Toshiba laptop running Microsoft’s new Vista oeperating system. There are only USB ports to hook up the printer (I have a second printer which is available by wireless network – but I didn’t think it was possible for New Views to print through the network).

I tried Mr. Thibodeau suggestion and ran Net View.
Should I be trying to print through the Network, or rerouting LPT1 through the USB?

JBesMargian, were you running Vista?

I’d certainly be indebted to anyone who might help.

[Author]

Posts