![]() |
||||||||||||
Go ![]() | New ![]() | Search ![]() | Notify ![]() | Tools ![]() | Reply ![]() | ![]() |
Gold member |
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 | ||
|
Guru |
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 | |||
|
Virtuoso |
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:
Did you get training for all this? Daniel In Focus since 1982 wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF | |||
|
Member |
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 | |||
|
Guru |
If its a single report, WebFOCUS/APP Studio can handle that! WebFOCUS 8.1.05 / APP Studio | |||
|
Gold member |
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. ![]() WebFOCUS 8201m Windows,AppStudio, DevStudio,All Outputs | |||
|
Gold member |
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 | |||
|
Member |
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 | |||
|
Gold member |
Thanks Ravi WebFOCUS 8201m Windows,AppStudio, DevStudio,All Outputs | |||
|
Powered by Social Strata |
![]() | Please Wait. Your request is being processed... |
|