Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Loading data from excel files

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] Loading data from excel files
 Login/Join
 
Petren
Member
posted
Hi all.
I have a monthly report in excel files and i need to build in Webfocus semiannual report rely on this excel files. Monthly report have one format. Can you show me direction in what I must moving?
1.How better agregate data from monthly report?
2.How I must work with ODBC datasource, because i have a lot of files, but in ODBC administration tools ( Windows) i must show a workbook of file??
P.S. Sorry for my English, I am not speak english well(((

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


WebFOCUS 7.6 on Win 2K/IIS 6/Weblogic 8.1/Servlet Mode
 
Posts: 11 | Registered: August 05, 2008Report This Post
GamP
Virtuoso
posted Hide Post
For each excel workbook:
- define a data-region within the sheet(s) that will become accessable by webfocus
- define an odbc connection for the excel file
- define the data adapter in the reporting server for the created odbc connection
- create the master files for every named region inthe excel file(s)
And remember, that when you connecting to the excel sheet with webfocus, it cannot be open in any other manner.

Hope this helps ...


GamP
- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
 
Posts: 1961 | Location: Netherlands | Registered: September 25, 2007Report This Post
Petren
Member
posted Hide Post
It means than i must define odbc connection for each excel file? When define the data adapter in reporting server, i must enter name of odbc connection, what name i must use?


WebFOCUS 7.6 on Win 2K/IIS 6/Weblogic 8.1/Servlet Mode
 
Posts: 11 | Registered: August 05, 2008Report This Post
GamP
Virtuoso
posted Hide Post
Yes, 1 odbc connection (system DSN) per excel file.
In the data server, for connection name - anything that you fancy; this name will be used in the access file. For the datasource enter the odbc connection name as you defined it - beware, it may be case sensitive.


GamP
- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
 
Posts: 1961 | Location: Netherlands | Registered: September 25, 2007Report This Post
Petren
Member
posted Hide Post
thank you, very much!!!


WebFOCUS 7.6 on Win 2K/IIS 6/Weblogic 8.1/Servlet Mode
 
Posts: 11 | Registered: August 05, 2008Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Loading data from excel files

Copyright © 1996-2020 Information Builders