187292 - files downloaded in qif format from my bank not recognized by Quicken, so cannot import to checkbook

Status: NEW

(Firefox :: File Handling, defect)

Description

[Erin Craig]

User-Agent:       Mozilla/5.0 (Macintosh; U; PPC; en-US; rv:1.2.1) Gecko/20021130
Build Identifier: Mozilla/5.0 (Macintosh; U; PPC; en-US; rv:1.2.1) Gecko/20021130

When I download files in .qif format from my bank (http://techcu.com), and save
them directly to disk (without trying to open them), they are saved... but
Quicken 2000 (Mac version) does not recognize them. There is no way to open the
files and import them into my Quicken checkbook. This behavior started when I
upgraded to Netscape 7.0 and persists on this build of Mozilla. I can still
access the files fine and dandy using Netscape 4.79 and using IE 5.01 (all Mac
versions). It does not matter if I try to open the file by telling Netscape to
use Quicken (I get an error message saying it is not a Quicken data file), or if
I save it directly to disk.

Reproducible: Always

Steps to Reproduce:
1.log in to checking account at http://techcu.com
2.get to history page, and click on "download as .qif file"
3.when download manager window appears, click "save to disk"
4.Open quicken 2000 and click "Import .qif file"
5. Quicken will not recognize/see the file, so you cannot import.

Actual Results:  
File is on the desktop, as it should be. Quicken does not see it. Since it works
fine with other browsers, I am concluding this is a Mozilla issue, not a Tech CU
issue. 

Expected Results:  
Mozilla should download the file, and Quicken should know what it is so it can
be  imported.

When I download the file using Internet Explorer, it appears on the desktop as
"history_qif.asp". When I download it using NS or Mozilla, it appears as
"history.qif".

Comment 1

[brewthatistrue]

i think this is related to (and might even be a DUPE of)
http://bugzilla.mozilla.org/show_bug.cgi?id=126782.
basically, if the web server does not provide mozilla (the web browser) with a
content-type then mozilla runs some heuristics on the file (the "unknown
content decoder") to test if it should be saved as text or binary. sometimes it
fails.

i think that your .qif file is being saved as text even thought it is binary.

Comment 2

[nnooiissee]

brewthatistrue is incorrect here. QIF files should be saved as text, but are
instead saved as binary. The mime type in question is application/qif.

Mac OS X seems to think these .qif files are QuickTime Image Format. I don't
know whose fault that is, but I expect it goes away if it is a TEXT file.

Comment 3

[Asa Dotzler [:asa]]

->file handling. I'm guessing this needs some of that "sniffing for common
formats" mentioned at http://bugzilla.mozilla.org/show_bug.cgi?id=126782#c70

Comment 4

[Christian :Biesinger (don't email me, ping me on IRC)]

possibly what this requires is setting correct type/creator codes...

Comment 5

[Boris Zbarsky [:bzbarsky]]

What does "MacOSX thinks" mean in comment 2?  OSX uses extensions and only falls
back on type/creator, no?

Someone able to reproduce the problem needs to provide some useful information
here (like what the type/creator set on the file are, what the IC settings for
that MIME type and for that extension are, what the Launch Services settings for
the MIME type and the extension are, etc, etc).

Comment 6

[Erin Craig]

Hello -

I originally reported this bug. I have since upgraded to OS X, and to 1.6, and (on someone's advice) 
created a new  blank profile. I get the same behavior. when I download the my checkbook history 
file, Mozilla says it is a file of type "Quicktime Image Format (QTIF)", which it is not. Nonetheless, 
when it is saved on my desktop, the downloaded file is of type .qif.

when I download the same file using Explorer, it downloads as a .asp file (that is what it shows on 
my desktop), and then Quicken recognizes it and imports it correctly as a .qif.

I am using a "classic" version of quicken (Quicken 2000), not sure if this makes a difference. I am 
on OS 10.2.8.

Note that when I originally reported the bug, I was using OS 9. The behavior started with my 
change from Netscape 4.7 to Netscape 7 on OS 9, and has persisted through both the OS and 
Mozilla updates since then.

Comment 7

[Boris Zbarsky [:bzbarsky]]

> Mozilla says it is a file of type "Quicktime Image Format (QTIF)"

This is what the helper app dialog says? What is the MIME type it lists?  Could
you get an HTTP log following the directions at
http://www.mozilla.org/projects/netlib/http/http-debugging.html (for loading as
few pages as possibly needed to reproduce the bug) and attach it to this bug
report via http://bugzilla.mozilla.org/attachment.cgi?bugid=187292&action=enter ?

Comment 8

[Erin Craig]

Yes, that is what the helper app dialog box says.  I tried to get you an html log, but either because 
I am running 1.6 production not a nightly build (sorry, that's a bit beyond me), or because the 
procedure didn't launch Mozilla from the console as the instructions implied  - setting the log files 
didn't result in any logs.  (I set the logs and then launch mozilla from the dock).

If there's another way to try again (without doing a build), be happy to have a go at it.

Comment 9

[Christian :Biesinger (don't email me, ping me on IRC)]

(In reply to comment #8)
> (I set the logs and then launch mozilla from the dock).

that won't work. please follow the instructions. using a release build should be
fine.

Comment 10

[Boris Zbarsky [:bzbarsky]]

> Yes, that is what the helper app dialog box says.

It should also say a MIME type (application/xxxxxxxx, probably).  What's the
"xxxxxxx" part?

Comment 11

[nnooiissee]

I said in comment 2 that the MIME type was application/qif but I have not been
able to double check recently.

For the moment all I have to add is that the type and creator of a quicken
export come out to 'TEXT' '????', and Moz/NS7 saves these files as 'qtif' 'prvw'.

Comment 12

[Boris Zbarsky [:bzbarsky]]

hmm... what are the extensions and types listed for 'qtif' in Internet Config
and Launch Services?

Comment 13

[Erin Craig]

Attachment: moz mimetype dialog box

Here is the dialog box which shows when I try to download the file.

sorry, but I still can't get that log file. I do follow instructions pretty
well, but Moz is not launching following the instructions on that page. I get "
./mozilla : no such command" at the last step.

Comment 14

[Boris Zbarsky [:bzbarsky]]

> I get "./mozilla : no such command"

That part won't work unless you are in the Mozilla install directory.