Online Safety Community

Using MS Excel for Component Interface utility

A Component Interface (CI) helps expose a PeopleSoft component -defined as a set of pages grouped together for a business purpose -for synchronous access from another application such as PeopleCode, Java, C/C++, COM, or XML. One can think of CI’s as black boxes that capture and compress PeopleSoft data and business processes, while hiding the details of the underlying page and data.

CI's can be used for integrating one application with either another application or with external systems. In executing the business logic built into the component; CI's carry a higher level of data validation than a simple SQL insert.

A CI can map to only one PeopleSoft component. However, multiple component interfaces can be created for the same component using PeopleSoft Application Designer.

Teaching about using MS Excel for CI's

Compliance4All, a leading provider of professional trainings for all the areas of regulatory compliance, will show how to use MS Excel for Component Interface utility and CI's to upload data from Microsoft Excel into PeopleSoft databases.

Nitika Sagar, a senior IT professional who brings more than 13 years’ experience, 11 of which have been in PeopleSoft, will be the speaker at this webinar. Please visit http://www.compliance4all.com/control/w_product/~product_id=501628LIVE to enroll for this session. 

Method of working

Nitika will demonstrate the actual way by which one can use MS Excel for Component Interface utility and CI's to upload data from Microsoft Excel into PeopleSoft databases. This is how it is done: Each source workbook contains both worksheets and Excel Visual Basic code modules that execute business logic for each transaction. Nitika will show how to use the Microsoft Excel workbooks as a template to create worksheets that are specific to the business logic that need to be used when uploading data to the PeopleSoft system. The data input sheet can be copied to other workbooks for distribution without copying the code modules.

The code formats spreadsheet data into a PeopleSoft readable Document Object Model (DOM) structure, and submits it to the PeopleSoft database. Next, a PeopleCode program parses the DOM structure and uses the component interface to create entries in the PeopleSoft database, validating the data submitted against the business logic that is built into the PeopleSoft component. Because the component interface is a wrapper around the component, all logic applied during data entry is applied when data is loaded through this tool.

The CI executes all the necessary PeopleCode events and the field-level edits. Based upon results from saving the component interface, another DOM is created in the PeopleCode that returns success, warnings, errors, or a combination of the three to the Microsoft Excel document. It allows for correction and resubmission of erroneous records.

Nitika will cover the following topics at this webinar:

  • To educate the community on Excel-to-CI: What it is? Creating a new Excel-to-CI? How to create and modify new/existing templates? How to identify errors and create solutions?
  • To present a live demo of building Excel-to-CI, which will try to close the gap between the slides and actual hands on process
  • To educate the community on Architecture of Component Interface and how to debug it

This session will be of benefit to professionals such as Business Analyst, PeopleSoft Developer, Functional Manager, Project Manager, Testing Team on the project, Project Coordinator, HR Analyst and Students.

Views: 39

Comment

You need to be a member of Online Safety Community to add comments!

Join Online Safety Community

Take our poll!

Take our poll!

Latest Activity

Larry Labelle posted a blog post

Keeping the Loading Dock Safe

The loading dock can be a very dangerous area if proper safety procedures aren’t followed. Forklift accidents alone cost businesses over $135 million each year. The accompanying infographic details best practices for truckers and warehouse workers to consider so that the loading dock can be a safe working environment for all involved.Infographic created by Verduyn…See More
10 hours ago
Mark Nilson posted events
12 hours ago
Russel Stuart posted events
14 hours ago
Morgan Franklin posted a blog post

How to Keep Employees Safe at Work

Workplace safety plays a big part in both staff performance and staff retention. Having a safe and secure premises, particularly for workers who are on site outside of daylight hours, is extremely important. And it’s crucial to create a warm and hospitable environment where employees are happy to work, and alongside team members they trust. Not only does improving the safety and security of your site boost the growth and development of people and your business, but it can prevent crime, injury,…See More
14 hours ago

Forum

Safety - A Prerequisite 12 Replies

Whether working at home or outside, to observe safety should be our pre-requisite. The employer before anything must be sure of the safety of its employees especially the ones working in mines or any…Continue

Tags: products, safety

Started by Enna Henry. Last reply by Jen McDade yesterday.

5 TECHNOLOGY-BASED LONE WORKER SAFETY SOLUTIONS

ABOUT 75% OF EMPLOYEES IN NORTH AMERICA ARE MOBILE WORKERS. ADVANCES IN COMMUNICATIONS TECHNOLOGY MEANS THESE WORKERS CAN WORK ANYWHERE AT ANY TIME. THESE NEW TECHNOLOGIES ALSO MEAN THESE MOBILE…Continue

Tags: Solutions, People, IoT, Monitoring, Remote

Started by Jen McDade May 31.

Road Safety Solutions 14 Replies

The Road Safety Signs ,Barriers,Humps,Hazard Markers and Visual Warnings are some of the important marks to be observed. Signs such as "keep left",stop, "give way" should not be casually treated.…Continue

Tags: safety, gear, wear, Equipment, &

Started by Enna Henry. Last reply by Jen McDade May 31.

Remote Monitoring

Get "Safe Assets and Sound Productivity" Through Remote Monitoring.Visit:…Continue

Tags: Solutions, People, IoT, Monitoring, Remote

Started by Jen McDade May 23.

Python Condition Objects Tutorial in 2018 1 Reply

If you have knowledge of other programming languages, then you would know the importance of conditional statements. Conditional statements are required for taking decisions. Whenever we operate the…Continue

Tags: course, certification, training, languages, programming

Started by Elena Lauren. Last reply by Jim Chesters May 15.

Badge

Loading…

© 2018   Created by Safety Community.   Powered by

Badges  |  Report an Issue  |  Terms of Service