What is Excel to CI in PeopleSoft? The Excel to CI is a utility that’s used to import data. It enables you, as the user, to upload data into the PeopleSoft database from an Excel
What is Excel to CI in PeopleSoft?
The Excel to CI is a utility that’s used to import data. It enables you, as the user, to upload data into the PeopleSoft database from an Excel Spreadsheet. There are 6 tabs at the bottom in the spreadsheet, one for each worksheet. Each worksheet has a special function.
How do I run a CI template in PeopleSoft Excel?
When you are adding thousands or hundreds of User profiles to a PeopleSoft System, you first tag a Component Interface (check if it is delivered or not) to the User profile Component, then form the Excel to CI Template. Now we need to add a specific number of rows so choose “Create” in the action text box.
How do you make a component interface in PeopleSoft?
To create a component interface:
- Open the PeopleSoft Application Designer.
- Select New from the File menu.
- Highlight the component to use as a basis for the component interface and click Select.
- To create the component interface without displaying properties and to expose component properties manually, click No.
What is chunking factor in Excel to CI?
Chunking Factor The number of rows of data to be transmitted to the database at one time.
What is Peoplesoft file layout?
A file layout is a definition that represents the data structure of a flat (text) file to be processed. PeopleTools supports reading and writing to plain text files, as well as to files that have a format based on a file layout: If the file is a plain text file, you use text strings to read or write data.
What is the use of component interface in PeopleSoft?
A component interface enables exposure of a PeopleSoft component (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).
What does component interface consist of?
Component interfaces encapsulate PeopleSoft data and business processes, and they hide the details of the structure and implementation of the underlying page and data. The actual interface consists of a set of clearly defined properties and methods that follow an object-oriented programming model.
How do you use file layout in PeopleSoft?
Firstly, to set up the file layout, go into App Designer, and select File -> New, followed by ‘File Layout’. Then open up the properties for the file layout and go into the ‘Use’ tab. Set these fields depending on what your requirement is. The file layout format can be set to ‘FIXED’, ‘CSV’ or ‘XML’.
How do you create a layout in PeopleSoft?
Creating New File Layout Definitions In PeopleSoft Application Designer, select File, New, File Layout. A new file layout contains only one element, the root node to which file records are attached. The default root node name is NEW FILE. Save the new file layout definition.
What does the component interface consist of?
What is a component interface?
A component interface enables exposure of a PeopleSoft component (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). Record fields on the component are mapped to the keys and properties of the component interface.