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] Load Multiple Excel into WF table

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] Load Multiple Excel into WF table
 Login/Join
 
Maran
Gold member
posted
Hi Team,
I have a requirement for automation process. Need to read around 6 excel\csv files from particular path(local or FTP) and load the data in single table. based on that table need to create a report. this is daily process. Every day morning some one place the excel\csv in path.

below are details process flow.
Step 1: Read the Excel\CSV files from particular path.
Step 2: Filter the data based on conditions.
Step 3: Join the filtered data to another table and load the final data in server.
Step 4: Create a excel report based on above table. (Report can be created using Developer studio)
Step 5: Send the Excel output to group of user thru Email. ( we can schedule report in report caster)

Need to automate first 3 steps.(like MS SSIS package)
How to achieve this process using WF\Data Migrator.

Please help me on this.

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


WebFOCUS 8201m
Windows,AppStudio, DevStudio,All Outputs
 
Posts: 86 | Location: India | Registered: November 03, 2015Report This Post
Ricardo Augusto
Guru
posted Hide Post
Hi Maran,

You will need some advance coding to reach your goals.
I will try to resume it.

1: Create metadata to your CSV;

2: TABLE FILE them and filter as you wish then create HOLDs to specific tables;

3: JOIN HOLD with other tables you need then use MOFIDY to load final data to other data source you want;

4: Create your final report using Dev Studio/APP Studio/Info Assist or any text editor;

5: Schedule it using report caster and enjoy!

Good lucky!


Ricardo


WebFOCUS 8.1.05 / APP Studio
 
Posts: 272 | Location: Brazil | Registered: October 31, 2006Report This Post
Danny-SRL
Virtuoso
posted Hide Post
Maran,
What is the reason for automating the first 3 steps only? Is there some more manipulation to be done before Report Caster kicks in?
In any case, as Ricardo has pointed out, there is lots of WebFOCUS involved:

  • Creating metadata.
  • Using the TABLE command extensively.
  • Using the JOIN command judiciously.
  • Maybe some MODIFY to create an output file - but not necessarily. A simple sequential file might be possible.

Did you get training for all this?


Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

 
Posts: 1980 | Location: Tel Aviv, Israel | Registered: March 23, 2006Report This Post
RaviVaradan
Member
posted Hide Post
The first 3 steps can be automated using 'Data Migrator' ETL tool similar to SSIS. It uses the same FOCUS code as WebFocus but it has a GUI (through Data Management console) to extract, transform and load with out writing the Focus code


WebFOCUS 8
Windows, All Outputs
 
Posts: 3 | Registered: October 07, 2015Report This Post
Ricardo Augusto
Guru
posted Hide Post
If its a single report, WebFOCUS/APP Studio can handle that!


WebFOCUS 8.1.05 / APP Studio
 
Posts: 272 | Location: Brazil | Registered: October 31, 2006Report This Post
Maran
Gold member
posted Hide Post
Thanks for all your replies.

Ricardo
Yes, It's a single report. So i used FILEDEF in WF to load the CSV files and created the report successfully.
Thanks for your help. Smiler


WebFOCUS 8201m
Windows,AppStudio, DevStudio,All Outputs
 
Posts: 86 | Location: India | Registered: November 03, 2015Report This Post
Maran
Gold member
posted Hide Post
quote:
Originally posted by RaviVaradan:
The first 3 steps can be automated using 'Data Migrator' ETL tool similar to SSIS. It uses the same FOCUS code as WebFocus but it has a GUI (through Data Management console) to extract, transform and load with out writing the Focus code


Thanks Ravi.
I don't have knowledge on Data Migrator ETL. Iam searching for training materials. Can you share any tutorial/training document for Data Migrator.


WebFOCUS 8201m
Windows,AppStudio, DevStudio,All Outputs
 
Posts: 86 | Location: India | Registered: November 03, 2015Report This Post
RaviVaradan
Member
posted Hide Post
Data Migrator is the ETL tool from IBI. Here is overview
http://www.informationbuilders.../dataintegration/etl
It uses large suite of data adapters to connect the data sources, map them to target and load. You can see more detailed technical documentation here.
http://ecl.informationbuilders.com/iway/index.jsp


WebFOCUS 8
Windows, All Outputs
 
Posts: 3 | Registered: October 07, 2015Report This Post
Maran
Gold member
posted Hide Post
Thanks Ravi


WebFOCUS 8201m
Windows,AppStudio, DevStudio,All Outputs
 
Posts: 86 | Location: India | Registered: November 03, 2015Report 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] Load Multiple Excel into WF table

Copyright © 1996-2020 Information Builders