I have a mixture of IIS 5.0, 5.1, and 6.0 giving inconsistant results when
serving up a .csv page. Some of the servers are serving the page up and IE
will open Excel and the page lookes like a normal spreadsheet. Other servers
are loading the page as an HTML page, eventhough it has a .csv extension.
While the page looks OK as HTML, it is not formatted into columns and rows
to import into Excel. I have troubleshooted down to where it appears to be a
server setting. Is there a MIME setting that needs to be made if you want to
server a .csv page and have it opened as an Excel file within IE?

Thanks!

Re: .CSV file does not open Excel by Kristofer

Kristofer
Mon Jun 20 15:09:21 CDT 2005

Hi,

If you send a MIME (Content-Type) type of text/html then of course the
browser will be confused about what to do with the file. I cannot say how
IE behaves in this situation (if it looks at the extension or Content-Type
header field).

So check what Content-Type header field is sent (you can use a utility
such as WFetch from IIS 6.0 Resource Kit Tools to do this).

The mime type for this file should be:

application/octet-stream

Did you use the very same browser for all your testing? Because it is up
to the client to decide what to do with the file, and it uses several ways
to find out what to do. For Internet Explorer, this page may help to
understand the process:

http://msdn.microsoft.com/library/default.asp?url=/workshop/networking/moniker/overview/appendix_a.asp

--
Regards,
Kristofer Gafvert (IIS MVP)
www.gafvert.info - My Articles and help
www.ilopia.com


bushi96 wrote:

> I have a mixture of IIS 5.0, 5.1, and 6.0 giving inconsistant results
when serving up a .csv page. Some of the servers are serving the page up
and IE will open Excel and the page lookes like a normal spreadsheet.
Other servers are loading the page as an HTML page, eventhough it has a
.csv extension. While the page looks OK as HTML, it is not formatted into
columns and rows to import into Excel. I have troubleshooted down to where
it appears to be a server setting. Is there a MIME setting that needs to
be made if you want to server a .csv page and have it opened as an Excel
file within IE?
>
> Thanks!

Re: .CSV file does not open Excel by bushi96

bushi96
Mon Jun 20 17:16:03 CDT 2005

Thanks!

I suspected it to be a client-side browser setting also at first. But using
the same browser hitting different servers gave me different results. For
instance, loading a .csv file and using WFetch on IIS5.0 loaded the page as
HTML and displayed this-
"Content-Type: application/vnd.ms-excel\r\n"
and loading the same page on IIS6.0 using IE on the server ("localhost)
loaded the page as an Excel worksheet and displayed-
"Content-Type: application/vnd.ms-excel\r\n"

So, I am probably wrong thinking that it might have something to do with a
MIME setting. Any other thoughts?

Appreciate the help!

"Kristofer Gafvert [MVP]" <kgafvert@NEWSilopia.com> wrote in message
news:xn0e3qgih35j5yx005@news.microsoft.com...
> Hi,
>
> If you send a MIME (Content-Type) type of text/html then of course the
> browser will be confused about what to do with the file. I cannot say how
> IE behaves in this situation (if it looks at the extension or Content-Type
> header field).
>
> So check what Content-Type header field is sent (you can use a utility
> such as WFetch from IIS 6.0 Resource Kit Tools to do this).
>
> The mime type for this file should be:
>
> application/octet-stream
>
> Did you use the very same browser for all your testing? Because it is up
> to the client to decide what to do with the file, and it uses several ways
> to find out what to do. For Internet Explorer, this page may help to
> understand the process:
>
> http://msdn.microsoft.com/library/default.asp?url=/workshop/networking/moniker/overview/appendix_a.asp
>
> --
> Regards,
> Kristofer Gafvert (IIS MVP)
> www.gafvert.info - My Articles and help
> www.ilopia.com
>
>
> bushi96 wrote:
>
>> I have a mixture of IIS 5.0, 5.1, and 6.0 giving inconsistant results
> when serving up a .csv page. Some of the servers are serving the page up
> and IE will open Excel and the page lookes like a normal spreadsheet.
> Other servers are loading the page as an HTML page, eventhough it has a
> .csv extension. While the page looks OK as HTML, it is not formatted into
> columns and rows to import into Excel. I have troubleshooted down to where
> it appears to be a server setting. Is there a MIME setting that needs to
> be made if you want to server a .csv page and have it opened as an Excel
> file within IE?
>>
>> Thanks!



Re: .CSV file does not open Excel by bushi96

bushi96
Mon Jun 20 17:33:12 CDT 2005

Sorry-
That should have been
*edit* and loading the same page on IIS5.1 (XP Pro)*edit* using IE on the
server ("localhost")
> loaded the page as an Excel worksheet and displayed-
> "Content-Type: application/vnd.ms-excel\r\n"

Thanks!

"bushi96" <bushi96@newsgroup.nospam> wrote in message
news:O$VsnWedFHA.3488@tk2msftngp13.phx.gbl...
> Thanks!
>
> I suspected it to be a client-side browser setting also at first. But
> using the same browser hitting different servers gave me different
> results. For instance, loading a .csv file and using WFetch on IIS5.0
> loaded the page as HTML and displayed this-
> "Content-Type: application/vnd.ms-excel\r\n"
> and loading the same page on IIS6.0 using IE on the server ("localhost)
> loaded the page as an Excel worksheet and displayed-
> "Content-Type: application/vnd.ms-excel\r\n"
>
> So, I am probably wrong thinking that it might have something to do with a
> MIME setting. Any other thoughts?
>
> Appreciate the help!
>
> "Kristofer Gafvert [MVP]" <kgafvert@NEWSilopia.com> wrote in message
> news:xn0e3qgih35j5yx005@news.microsoft.com...
>> Hi,
>>
>> If you send a MIME (Content-Type) type of text/html then of course the
>> browser will be confused about what to do with the file. I cannot say how
>> IE behaves in this situation (if it looks at the extension or
>> Content-Type header field).
>>
>> So check what Content-Type header field is sent (you can use a utility
>> such as WFetch from IIS 6.0 Resource Kit Tools to do this).
>>
>> The mime type for this file should be:
>>
>> application/octet-stream
>>
>> Did you use the very same browser for all your testing? Because it is up
>> to the client to decide what to do with the file, and it uses several
>> ways to find out what to do. For Internet Explorer, this page may help to
>> understand the process:
>>
>> http://msdn.microsoft.com/library/default.asp?url=/workshop/networking/moniker/overview/appendix_a.asp
>>
>> --
>> Regards,
>> Kristofer Gafvert (IIS MVP)
>> www.gafvert.info - My Articles and help
>> www.ilopia.com
>>
>>
>> bushi96 wrote:
>>
>>> I have a mixture of IIS 5.0, 5.1, and 6.0 giving inconsistant results
>> when serving up a .csv page. Some of the servers are serving the page up
>> and IE will open Excel and the page lookes like a normal spreadsheet.
>> Other servers are loading the page as an HTML page, eventhough it has a
>> .csv extension. While the page looks OK as HTML, it is not formatted into
>> columns and rows to import into Excel. I have troubleshooted down to
>> where it appears to be a server setting. Is there a MIME setting that
>> needs to be made if you want to server a .csv page and have it opened as
>> an Excel file within IE?
>>>
>>> Thanks!
>
>



Re: .CSV file does not open Excel by Kristofer

Kristofer
Tue Jun 21 00:47:04 CDT 2005


Have you tried to clear the cache on the client? I have to say that it is
strange, because the MIME seems to be correct and IE should not open that
file as HTML.

Do you have any ISAPI filters that could cause this?
When you say that the page loads as HTML, is it true HTML? Does it have a
"body" tag for example? If so, you must have some custom built code that
does that (ISAPI filter for example), because IIS does not modify the
file. Use View Source in the browser.

Or do you mean that the file just opens in IE, without prompting to be
downloaded?

--
Regards,
Kristofer Gafvert (IIS MVP)
www.gafvert.info - My Articles and help
www.ilopia.com


bushi96 wrote:

> Sorry-
> That should have been
> *edit* and loading the same page on IIS5.1 (XP Pro)*edit* using IE on
the server ("localhost")
> > loaded the page as an Excel worksheet and displayed-
> > "Content-Type: application/vnd.ms-excel\r\n"
>
> Thanks!
>
> "bushi96" <bushi96@newsgroup.nospam> wrote in message
news:O$VsnWedFHA.3488@tk2msftngp13.phx.gbl...
> > Thanks!
> >
> > I suspected it to be a client-side browser setting also at first. But
> using the same browser hitting different servers gave me different >
results. For instance, loading a .csv file and using WFetch on IIS5.0 >
loaded the page as HTML and displayed this-
> > "Content-Type: application/vnd.ms-excel\r\n"
> > and loading the same page on IIS6.0 using IE on the server
("localhost) > loaded the page as an Excel worksheet and displayed-
> > "Content-Type: application/vnd.ms-excel\r\n"
> >
> > So, I am probably wrong thinking that it might have something to do
with a > MIME setting. Any other thoughts?
> >
> > Appreciate the help!
> >
> > "Kristofer Gafvert [MVP]" <kgafvert@NEWSilopia.com> wrote in message >
news:xn0e3qgih35j5yx005@news.microsoft.com...
> >> Hi,
> > >
> >> If you send a MIME (Content-Type) type of text/html then of course
the >> browser will be confused about what to do with the file. I cannot
say how >> IE behaves in this situation (if it looks at the extension or
>> Content-Type header field).
> > >
> >> So check what Content-Type header field is sent (you can use a
utility >> such as WFetch from IIS 6.0 Resource Kit Tools to do this).
> > >
> >> The mime type for this file should be:
> > >
> >> application/octet-stream
> > >
> >> Did you use the very same browser for all your testing? Because it is
up >> to the client to decide what to do with the file, and it uses
several >> ways to find out what to do. For Internet Explorer, this page
may help to >> understand the process:
> > >
> >>
http://msdn.microsoft.com/library/default.asp?url=/workshop/networking/moniker/overview/appendix_a.asp
> > >
> >> -- >> Regards,
> >> Kristofer Gafvert (IIS MVP)
> >> www.gafvert.info - My Articles and help
> >> www.ilopia.com
> > >
> > >
> >> bushi96 wrote:
> > >
> >>> I have a mixture of IIS 5.0, 5.1, and 6.0 giving inconsistant results
> >> when serving up a .csv page. Some of the servers are serving the page
up >> and IE will open Excel and the page lookes like a normal
spreadsheet. >> Other servers are loading the page as an HTML page,
eventhough it has a >> .csv extension. While the page looks OK as HTML, it
is not formatted into >> columns and rows to import into Excel. I have
troubleshooted down to >> where it appears to be a server setting. Is
there a MIME setting that >> needs to be made if you want to server a .csv
page and have it opened as >> an Excel file within IE?
> > > >
> >>> Thanks!
> >
> >