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: 47

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

John Robinson posted a blog post

FDA Scrutiny of Promotion and Advertising Practices

If you go "off label" with advertising and promotion, FDA's hammer can hit hard and seemingly out of the blue. Advertising and promotion for devices is weak and lacks legal clarity. For drugs, the regulations are prescriptive and guidance documents clamp down on nuances. Marketing and regulatory affairs departments must collaborate to avoid the hammer and penalties of FDA. The roadblock, however is that marketing managers and regulatory affairs managers rarely reach common ground and are loathe…See More
1 hour ago
kate smith posted blog posts
2 hours ago
Traininngdotcom-LLC posted blog posts
3 hours ago
Mark Nilson posted events
3 hours ago

Forum

How to provide safety to the small laboratories at schools? 4 Replies

Most schools in villages are opening small chemistry laboratories and allowing the students to experiment whatever they have been taught. The education quality of village schools is not up to the…Continue

Started by charlieelectra. Last reply by Jen McDade 8 hours ago.

Workers paticipation in safety management 1 Reply

Workers paticipation in safety management is the aspect which is required to be implemented in the OHSAS 18001 2007 version. , I invite our experience community members to share their views on the…Continue

Tags: management, safety, in, paticipation, Workers

Started by SafetyRaja. Last reply by Jen McDade yesterday.

Road Safety

What can be the best measures for Road Safety?Continue

Started by Jen McDade Sep 27.

safety equipments in breweries 4 Replies

safety equipments in breweries -- kindly provide detailsContinue

Started by ajit. Last reply by Jen McDade Sep 24.

Unusual Safety Tips 10 Replies

Please share some unusual but genuine safety precautions.My unusual safety tips - Don't drink sweet fruity juice while driving in the night as it contains sugar and sugar slows down your blood…Continue

Started by Arnold Brame. Last reply by Jen McDade Sep 24.

Badge

Loading…

© 2018   Created by Safety Community.   Powered by

Badges  |  Report an Issue  |  Terms of Service