Focal Point
[SOLVED] Uploading Data Files - getting error that says "Unable to Open/Read Files"

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/8141050892

September 03, 2008, 01:49 PM
CherylB
[SOLVED] Uploading Data Files - getting error that says "Unable to Open/Read Files"
I am following the instructions from the Online Help for Creating a Reporting Application - Uploading Data Files. BUT, I keep getting this error message "Unable to Open/Read File".
I am in Developer Studio. I'm on WF 765, soon to go to version 766. The file I'm trying to import is an excel file saved as .xls. Does anyone have a suggestion as to what could be wrong. The location of the .xls has been moved to several different directories to see if this was the problem, still doesn't work. Help.
Thanks

This message has been edited. Last edited by: Kerry,


WF 7.7
Unix/Tomcat
ZLinux on System Z
DB2 Relational DB
September 03, 2008, 02:28 PM
GinnyJakes
Cheryl,

Please update your profile signature with your product suite, releases, and platform, especially the latter. You didn't indicate what the backend platform was for your WebFOCUS environment and that could affect the answer we give you.

If it is a local installation, you will have to give us more information as to what you are trying to do with the file. Are you trying to report from it, open it? Please provide more detail.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
September 05, 2008, 08:51 AM
CherylB
I am on WF version 7.6.4, soon to be 7.6.6.
WebClient Platform: Unix/Solaris
Reporting Server Platform: zLinux running on mainframe
Data: Oracle Relational Data Base soon to be DB2.

I am trying to take a excel spreadsheet and import it into WebFOCUS to report on it. Possible JOIN it to another Data Table. Do I need to use the Synanym Editor??


WF 7.7
Unix/Tomcat
ZLinux on System Z
DB2 Relational DB
September 05, 2008, 09:47 AM
GinnyJakes
Since you are on a Unix platform as we are, what you are trying to do is challenging. Since your reporting server is on Unix, it doesn't know about xls files. One recommendation would be to be to save it as a csv (comma-delimited), ftp it to the Unix box and then create a master file description for it.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
September 05, 2008, 10:42 AM
GamP
I've tried to analyse what happens when you do the upload.
As I understand the process this is as follows:
Since it is a developer studio feature, it runs on windows. Windows knows xls files.
When you select a file to be uploaded, it looks at your local file system, the file has to be present on your pc. The processing of the file however is not done by focshell (Developer studio), but by the servlets. This is why it may be challenging. The servlets will read the xls file, determine what columns there are, build the master file, read the data, convert it to csv data, and when it is done, it will send the master file, access file and data file to the server to be stored. The server will not create the synonym or the data file, it will just store whatever it is being offered.
The challenge here is to get the servlets to read the data file. If, as is the case here, the servlets can not read the file, then you get the above error message. Most likely issue is security. Most servlets run in a anonymous mode, which means that the permissions for reading the file must be such that everyone (including anonymous) can read the file.

Hope I'm right ... Sweating


GamP

- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
September 08, 2008, 08:33 AM
linus
I've been doing this exact thing a lot lately in a UNIX envirornment. Save the file as a csv file, ftp it to the server, then check the permissions of the file you just placed on the UNIX box. I have found that the first time I place the file on the UNIX box I need to change the permissions to read, write, execute before I can read the file. And you have to create your mfd somewhere along the line with suffix=com. Hope this helps.


WF 7.7.05
HP-UX - Reporting Server, Windows 2008 - Client, MSSQL 2008, FOCUS Databases, Flat Files
HTML, Excel, PDF
October 22, 2008, 11:27 AM
CherylB
Sorry for the delay in replying to your last suggestion(s). I've read all the prior tips, but what I was hoping to accomplish was to have Upload Data File utility creat my MFD. I manually create many MFDs and I wanted to have a tool for the end-user to do this easily for them. So, are you telling me that the upload utility will not work for me because of the UNIX box? Is this something I need to request from IBI for a fix/enhancement? OR, am I doing something incorrectly? I've tried creating a .csv, changing permissions, moving file into the correct location (ftp) and I still can not get the file to open. I still get this message "Unable to Open/Read File". Any other thoughts/suggestions. I really would like this feature to work for me, it would be very helpful. Thanks.
CherylB

WF 7.6.6
Unix/Solaris
ZLinux on Mainframe/converting to DB2
Oracle Relational DB


WF 7.7
Unix/Tomcat
ZLinux on System Z
DB2 Relational DB
October 24, 2008, 03:06 PM
Kerry
Hi CherylB,

Has this issue been resolved on your side? Many thanks for everyone's input on this one.

I passed this one to internals and was suggested that the last response from linus maybe works, just needs an extra step. Can you please try again and let us know the outcome? Wink

Cheers,

Kerry


Kerry Zhan
Focal Point Moderator
Information Builders, Inc.
October 24, 2008, 03:13 PM
RickW
I think I had that problem with 7.6.4 but it got fixed in 7.6.6. Can you try it on 7.6.6?

check this link


WebFOCUS 7.6.6/TomCat/Win2003,SQL Server 2005,Oracle