Printing to .tsv file


Printing to .tsv file

Groups | Search | About

User Password

Lost Password?

Quicken Personal Finance Discussions - Quicken - personal finance software discussions

get this group's latest topics as an RSS feed

add this group's latest topics to your My MSN content

add this group's latest topics to your My Yahoo content

add this group's latest topics to your Google content

Yahoo!

Google

Windows Live

del.icio.us digg

digg

Netscape

Subject

Author

Date

Printing to .tsv file

Stubby

12-26-2006

Re: Printing to .tsv file

12-26-2006

Re: Printing to .csv file

John Pollard

12-27-2006

Posted by Han on December 27, 2006, 4:49 pm

Please log in for more thread options

> Thanks. I did that but all that turned up was foo.dat.lnk the

> shortcut. It's

> as if the real file never quite got closed and doesn't exist.

> Did you try it? Did it work????

I have Q2006DL, XP Pro. You're right:
Printing an "overview" of my checking account to a *.txt file only yields a
shortcut, no real file. That may be partially correct, since an overview
is not really something you can do calculations on, especially with the
graphs on it (I think). Still, either it should give you an error message,
or do what it is saying it will do.

On the other hand, I was successful in printing a register view to a tab-
delimited file named test.txt, and opening it *with* Excel.

I think what you perhaps want to do is set up a report with the data you
want it to contain, then (save it and) print that to a txt file.

HTH
--
Best regards
Han
email address is invalid

Posted by DP on December 27, 2006, 8:44 pm

Please log in for more thread options

This doesn't solve the mystery of where that .tsv file goes, but have you
tried EXPORTING into an excel-format file?
I just tried it on Q06 Basic and it seems to work for me. In fact, I can't
find a "print to file" option. It's probably there somewhere, I just haven't
dug deep enough to find it.

If I have a register report up, there is an "export data" pull-down menu.
Excel-compatible format is one of the options on that menu.
Also, if I click on the "print report" icon with a register report up,
excel-compatibile is another available option there.
It also offers to export to a PRN file. Is that what you're trying to do?

> DP wrote:

>>> Win2kPsp4, QD07

>>>

>>> I put up a summary display of an account and hit the Printer icon,

>>> selecting "print to file" and "tab separated values (Excel compatible)".

>> I've never done what you're trying myself, but doesn't it also ask you

>> where you want to put the file? If so, put it on your desktop for

>> starters. That way you shouldn't have to go searching for it. You can

>> always move it to another folder later.

>> Lemme know if that helps at all.

> Of course. But it doesn't work. That's why I had to ask. I'm beginning

> to think I have to do something to close the file to make it real.

> Certainly non-intuitive.

Posted by Han on December 27, 2006, 9:06 pm

Please log in for more thread options

> This doesn't solve the mystery of where that .tsv file goes, but have

> you tried EXPORTING into an excel-format file?

> I just tried it on Q06 Basic and it seems to work for me. In fact, I

> can't find a "print to file" option. It's probably there somewhere, I

> just haven't dug deep enough to find it.

> If I have a register report up, there is an "export data" pull-down

> menu. Excel-compatible format is one of the options on that menu.

> Also, if I click on the "print report" icon with a register report up,

> excel-compatibile is another available option there.

> It also offers to export to a PRN file. Is that what you're trying to

> do?

>> DP wrote:

>>>> Win2kPsp4, QD07

>>>>

>>>> I put up a summary display of an account and hit the Printer icon,

>>>> selecting "print to file" and "tab separated values (Excel

>>>> compatible)".

>>>

>>> I've never done what you're trying myself, but doesn't it also ask

>>> you where you want to put the file? If so, put it on your desktop

>>> for starters. That way you shouldn't have to go searching for it.

>>> You can always move it to another folder later.

>>> Lemme know if that helps at all.

>> Of course. But it doesn't work. That's why I had to ask. I'm

>> beginning to think I have to do something to close the file to make

>> it real. Certainly non-intuitive.

I think Stubby was trying to print an account overview. When I tried
that I got the same symptoms as he did: A shortcut was generated, but no
file. I think you have to have a report or register to print, not an
overview/summary.

--
Best regards
Han
email address is invalid

Posted by DP on December 28, 2006, 12:52 am

Please log in for more thread options

OK, even in account overview, I get the same options I mentioned earlier.
There are two radio buttons, one connects to a printer including PDF, the
other is an export option. The export option gives me Excel-compatible,
ASCII and PRN options.
Maybe 06 basic doesn't offer the same options as 07 versions do.

But my question still stands: Will exporting to an excel file accomplish
the same thing that Stubby was trying to do? Or is there a reason he has to
do it the way he described in the OP. Seems to me that if he can get the
data into an Open Office spreadsheet, it doesn't matter how he gets it
there.

>> This doesn't solve the mystery of where that .tsv file goes, but have

>> you tried EXPORTING into an excel-format file?

>> I just tried it on Q06 Basic and it seems to work for me. In fact, I

>> can't find a "print to file" option. It's probably there somewhere, I

>> just haven't dug deep enough to find it.

>> If I have a register report up, there is an "export data" pull-down

>> menu. Excel-compatible format is one of the options on that menu.

>> Also, if I click on the "print report" icon with a register report up,

>> excel-compatibile is another available option there.

>> It also offers to export to a PRN file. Is that what you're trying to

>> do?

>>>

>>> DP wrote:

>>>>> Win2kPsp4, QD07

>>>>>

>>>>> I put up a summary display of an account and hit the Printer icon,

>>>>> selecting "print to file" and "tab separated values (Excel

>>>>> compatible)".

>>>>

>>>> I've never done what you're trying myself, but doesn't it also ask

>>>> you where you want to put the file? If so, put it on your desktop

>>>> for starters. That way you shouldn't have to go searching for it.

>>>> You can always move it to another folder later.

>>>> Lemme know if that helps at all.

>>> Of course. But it doesn't work. That's why I had to ask. I'm

>>> beginning to think I have to do something to close the file to make

>>> it real. Certainly non-intuitive.

> I think Stubby was trying to print an account overview. When I tried

> that I got the same symptoms as he did: A shortcut was generated, but no

> file. I think you have to have a report or register to print, not an

> overview/summary.

> --

> Best regards

> Han

> email address is invalid

Posted by Han on December 28, 2006, 6:48 am

Please log in for more thread options

> OK, even in account overview, I get the same options I mentioned

> earlier. There are two radio buttons, one connects to a printer

> including PDF, the other is an export option. The export option gives

> me Excel-compatible, ASCII and PRN options.

> Maybe 06 basic doesn't offer the same options as 07 versions do.

My Q2006DL does offer the 3 options. I think a tab delimited txt file is
very similar to a prn file. The ASCII option does not have the same
delimiter properties, so Shop Rite as payee gets distributed over 2 columns
(since you have to choose space as delimiter).

> But my question still stands: Will exporting to an excel file

> accomplish the same thing that Stubby was trying to do? Or is there a

> reason he has to do it the way he described in the OP. Seems to me

> that if he can get the data into an Open Office spreadsheet, it

> doesn't matter how he gets it there.

Have you successfully opened a file (in Excel) generated from the account
overview tab? Does not go to completion in the OP's case, and neither in
my case. A shortcut gets generated, but no real file.
--
Best regards
Han
email address is invalid

Similar Threads	Posted
Re: Printing to Adobe pdf	April 20, 2006, 10:35 am
Re: Printing to Adobe pdf	April 20, 2006, 11:38 pm
Printing to Adobe pdf	April 20, 2006, 9:35 am
printing of reports screwed up	October 24, 2006, 3:26 pm
Attachment Printing Size	December 4, 2006, 7:00 pm
Check Printing Font	January 26, 2007, 8:40 am
Printing Reports from Q 2007	February 3, 2007, 10:07 am
Printing with Quicken QIF alternatives	March 23, 2007, 4:27 pm
Tranaction Report Printing	June 12, 2007, 6:36 pm
Address Book not printing	June 24, 2007, 11:27 am

Contact Us | Privacy Policy
This site is not affiliated with Intuit - makers of Quickbooks and Quicken software
This site is not affiliated with Sage Software - makers of Peachtree accounting software

XML Sitemap