Web user can not open .CSV files

[pduncan]

Hello - we are on ERP 8 (B7334) SP23. Have a 'mixed' environment here - some users are fat clients, the others are web. I have two users (web) at a remote site that cant open csv files. They are both using IE6.
When they try, an explorer window opens, and then closes - too fast to see what is on it.
I found a 'work around' - if they hold the control key before they click on "CSV" a dialog box opens.
The box is the 'normal' one - that gives the option to opn/save/cancel. If they select open - nothing happens. I found that if they select 'save' and then add a .csv extension, they can open it in Excel.

The weird thing - its like a MIME setting or something? The client does not recognize the file. Instead of UBE name and version, the file is named "com.jdedwards,jas.ube"

This is only at one location - my other web users are not having any issues. I am thinking this may be a setting in Explorer, but not sure.

Any suggestions would be greatly appreciated.

Thanks

 

[pduncan]

I think I have this resolved:

I fixed it -
here is what I did:

1. (re) added the CSV registry fix:

Navigate to HKEY_CLASSES_ROOT\MIME\Database\Content Type\
Add key of "application/csv"
Add string value with a name of "Extension" and Value Data ".csv"

Then in IE - I did this:

Tools
Internet Options
On Security tab, click on Custom level, scroll to Downloads section and select: Automatic prompting for file download
Enable and apply
Close Internet Explorer and restart

 

[swallen]

We had a similar problem in the past. This fixed it for us. Create a .REG
file and enter the following lines:

Windows Registry Editor Version 5.00

[HKEY=5FCLASSES=5FROOT\MIME\Database\Content Type\application/csv]
"Extension"=3D".csv"


Scott W. Allen
LAN/CNC Technician
BrassCraft
A Subsidiary of Masco Corporation
39600 Orchard Hill Pl.
Novi, MI 48375 USA
www.brasscraft.com
Tel: 248-305-6000
Fax: 248-374-3820

--
In honor of my daughter, Ashley, please help me fight Leukemia & Lymphoma.
Go to:
http://pages.teamintraining.org/mi/freepres09/LibertyGuy62
Special thanks to Danny Rosales at Corona for his support!




pduncan <[email protected]>
Sent by: [email protected]
08/28/2009 02:20 PM
Please respond to
JD Edwards=AE EnterpriseOne <[email protected]>


To
[email protected]
cc

Subject
Web user can not open .CSV files






Hello - we are on ERP 8 (B7334) SP23. Have a 'mixed' environment here -
some users are fat clients, the others are web. I have two users (web) at
a remote site that cant open csv files. They are both using IE6.
When they try, an explorer window opens, and then closes - too fast to see
what is on it.
I found a 'work around' - if they hold the control key before they click
on "CSV" a dialog box opens.
The box is the 'normal' one - that gives the option to opn/save/cancel. If
they select open - nothing happens. I found that if they select 'save' and
then add a .csv extension, they can open it in Excel.

The weird thing - its like a MIME setting or something? The client does
not recognize the file. Instead of UBE name and version, the file is named
"com.jdedwards,jas.ube"

This is only at one location - my other web users are not having any
issues. I am thinking this may be a setting in Explorer, but not sure.

Any suggestions would be greatly appreciated.

Thanks
ERP 8, B7334 sp23

 

[klwong]

I'm not sure if the fix introduced in SP23_K1 applies to you, since you say this problem only happen on a couple of your client PCs. Hopefully you've got UBEContentDisposition=TRUE in your [OWWEB] of JAS.INI.

Try this: in the PC's registry, navigate to [HKEY_CLASSES_ROOT\MIME\Database\Content Type\applicaion\csv], and see if you have a line for "extension=.csv"

This should allow the file to open in Excel when they hit the Open button.