EZ-Pickin’s lets you transform System i reports into ‘Live’ Interactive views. Extract report data to Excel, Graph, Query, Sort, Summarize… Give Financial, Sales and Management pros the power tools that improve workflow, analysis, decision making and printing costs. EZ-Pickin’s also integrates with Catapult and Spool-Explorer to further modernize business applications and processes.
EZ-Pickin’s allows you to view, analyze and distribute data created from iSeries reports or virtually any computer generated report. Easily accomplish this with NO programming, NO rekeying and NO changes to your applications! EZ-Pickin’s can use spooled report files, such as those from Spool-Explorer or Catapult as a source for data. Use any new or existing report and out comes live data you can view, query, filter, analyze, visualize, distribute, and even extract without rekeying to other PC laptop or desktop applications.
EZ-Pickin’s models can include one or more of these views.
1. Green Bar Report – You can utilize such features as: Find, view, zoom, next, copy…
2. Customized Table – You can create tables from any fields in the report and sort the data any way you wish. On the fly.
3. Customized Summary Reports – If desired, different users can create their own customized summary views based on what they need.
4. Customized Charts / Graphs – Create colorful and informative charts and graphs based on report data.
5. Customized Data Extraction – Extract report, data into Excel Spreadsheets…

How does EZ-Pickin works

Input to EZ-Pickin’s

EZ-Pickin’s can extract data from virtually any computer generated report, including complex reports with headers, footers and multiple sort levels. It automatically recognizes different data types so date fields and numeric fields are properly maintained in appropriate formats. EZ-Pickin’s reads report files sent from any AS/400 – iSeries – i5, mainframe, client/server or PC system.

Data Extraction

At the heart of EZ-Pickin’s is a powerful data extraction engine that can pull data out of virtually any report, from simple columnar reports to complex reports with headers, footers and multiple sort levels. You define a data extraction template to identify desired data elements. Templates can be saved and reused any time a periodic report is run.

User Interface

EZ-Pickin’s offers four views of report data: 1. A ‘softcopy’ of the original report is displayed in EZ-Pickin’s report window 2. Data extracted from the report is displayed in the table window 3. User defined summaries which analyze report data are displayed in the summary window 4. Dynamic charts linked to summary reports are also displayed

Data Processing and Analysis

EZ-Pickin’s provides a range of features to help you manipulate and analyze the data extracted from reports. You can create calculated fields using and extensive library of numeric, logical and string functions. You can define filters to boil down the data, sort the data on one or more keys and create new reports with data extracted from the original report. You can drill down through summary data to reveal successive layers of detail and create charts that change dynamically as you explore the data. Create and run saved templates/models over reports to automatically extract and export data directly into any of 100’s of Windows applications (e.g. Excel, Access, MS-Word, Lotus 1-2-3… ) without rekeying! Even send reports, graphs… via E-mail, Internet, Intranet, Lotus Notes…. Using EZ-Pickin’s also saves you 6?for every page you don’t print!

EZ-Pickin’s Feature

Input Sources
  • Text files from virtually any computer generated report
  • iSeries Reports using Spool-Explorer
  • Catapult to Automate iSeries Report Workflow
User Interface Live Interactive Views
  • Report View with Green Bar option
  • Table with Extracted Data
  • User Defined Summaries
  • Dynaic Charts
  • Combined View
  • Report Tree View
Export to Multiple Windows Applications
  • Excel, Access, XML SS, MS-Word, HTML, Lotus 1-2-3 and More
  • Printing & Copying
  • Advanced Formatting Options
Data Extraction
  • Reusable Templates
  • Header, Detail, Append and Footer Templates
  • Field Attributes Recognized
Data Processing and Analysis
  • Record Selection Filters
  • Calculated Fields
  • Sorting Data
  • Query Data
  • Drill Up or Down
Translate »
Web Design MymensinghPremium WordPress ThemesWeb Development

New White Paper – Two Factor Authentication on the IBM i by Townsend Security

April 22, 2016April 22, 2016

Security Beyond Usernames and Passwords

Today's organizations must take a defensive strategy against the constant threat of network data breaches. Recent password leaks from high-profile sites (Anthem, Target, etc.) suggest that their sensitive data may not be as secure as once thought. Companies and web properties have to do a better job protecting security credentials.

Download this white paper to learn:

  • Why the IBM i may not be as secure as you think
  • The need for verification on the IBM i
  • How to meet compliance requirements (PCI DSS, FFIEC, etc.)

[Download Now]

For More Information:
Contact: Mr. Savio Sin (savio.sin@hkwiseco.com)
         Sales Manager - Wiseco Consultants Ltd. 

White paper – Simplifying Security for IBM i by Townsend Security

February 27, 2016February 27, 2016

Collecting real-time security events and actively monitoring system logs is one of the most effective security tools any organization can deploy. 

Request the Simplifying Security for IBM i and IBM Security QRadar white paper to find out more about: 

  • How IBM i customers can make integration with QRadar simple, fast, and inexpensive
  • How IBM Security QRadar users can rapidly experience success and better security
  • How continuous, active monitoring is a key security control
  • The security benefits of the combining IBM Security QRadar and Townsend Security's Alliance LogAgent for IBM QRadar

Now, the integration between Alliance LogAgent for IBM QRadar and IBM Security QRadar has dramatically reduced the effort and expense required to deploy an effective SIEM solution for the IBM i (AS/400, iSeries).

White paper – Top 10 Reasons to Choose PHP for IBM i Web Application Development by Townsend Security

February 13, 2016February 13, 2016

Learn why PHP is a great choice for IBM i web development and application modernization.

PHP ebook

When deciding on an IBM i web development strategy, it's important to choose technologies that are easy for RPG programmers to learn, attract new programmers and grow with technologies like mobile. PHP gives you all of this and more.

Download this free eBook to get a detailed look at the top 10 reasons why PHP is a great web development choice for IBM i shops, including:

  • Why PHP is easy for RPGers to learn
  • How you can leverage DB2 and RPG with PHP
  • The benefits of choosing an open-source language
  • Why PHP makes mobile applications easy to deploy

This eBook, which was co-sponsored by BCD and Zend, also features a foreword written by Alan Seiden.

Complete the form to the right to download it now!