Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Load Multiple Excel into WF table
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] Load Multiple Excel into WF table
 Login/Join
 
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: 69 | Location: India | Registered: November 03, 2015Reply With QuoteReport This Post
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, 2006Reply With QuoteReport This Post
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: 1936 | Location: Tel Aviv, Israel | Registered: March 23, 2006Reply With QuoteReport This Post
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, 2015Reply With QuoteReport This Post
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, 2006Reply With QuoteReport This Post
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: 69 | Location: India | Registered: November 03, 2015Reply With QuoteReport This Post
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: 69 | Location: India | Registered: November 03, 2015Reply With QuoteReport This Post
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, 2015Reply With QuoteReport This Post
Gold member
posted Hide Post
Thanks Ravi


WebFOCUS 8201m
Windows,AppStudio, DevStudio,All Outputs
 
Posts: 69 | Location: India | Registered: November 03, 2015Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Load Multiple Excel into WF table

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.