Application Engine (AE) uses File Layout to Import the date from CSV file

Application Engine (AE) uses File Layout to Import the date from CSV file

Step #1 : Create Stage Record Field

File > New Select Field

Choose Field Type to Number

Enter Field Labels

Save the Field  - EMU_PROD_NO

Press F7 to insert the Field into Project workspace – Development  

As similarly create one more field EMU_PROC_DESC as Filed Type Charater  and Save the Field as EMU_PROC_DESC

Press F7 to insert the Field into Project workspace – Development  

Step 2 : Create a Stage Record

File > New  Select Record

Menu > Insert > Field  - Search by Field Name and Click the Insert Button to insert the fields into your record

Click Record Type  - SQL Table

From Menu > build > Current Definition – To build the Record

Note : Choose the table space if you create the table at first time

Step # 3 : Create a File Layout

Select File Layout from File > New

From menu > Insert > Record which we recently created

Step # 4 : Create a CVS File to import your data into a SQL table ( EMU_PROD)

Step #5 :  Go back to your File Layout Property – Choose Type CSV

Preview Tab  Provide the Default File Name and Preview

Save the File Layout

Press F7 to include File Layout into your Project  WorkSpace

Step # 6 : Create an Application Engine

File > New > Choose App Engine Program

Choose  Auto Commit After Step Check Box

Right click and insert Action

Choose Action Type to PeopleCode

Save Application Engine – EMU_PROD_IMP and press F7 to insert AE to your project workspace

Double Click the PeopleCode Action to open the code window

From a Project window , click the File Layout (EMU_FILE_LAYOUT ) drag to your code window  then entire code logic will be created by default for you.

Verify your CSV file location is correct from the generated code.

Save the AE

From Tool bar  Press Run Program button

Choose the log option and click OK

In the system task bar you can see the below AE running icon

Now go to the log file location and verify the log file – It should ended normally

Step # 7 : Verify the Data in the back end

Note : Problem is data get inserted with CSV file column header to avoid please remove the column header on your CV file.  

People Tools Miscellaneous Definitions

How to create custom Field Formats , System Colors, Styles , Access Profiles  & File Type Code

Field Formats: Field format specifications affect internal values that are stored in the database, and page format specifications affect the visual presentation of values.Several formatting options are available for U.S. Social Security Numbers, Canadian Social Insurance Numbers, postal codes, telephone numbers, and various currencies, dates, and times.

System Colors: You can establish definitions for colors that you use in your applications.

Styles: This feature is deprecated from PT 8.52. instead of this feature set styles using style sheet definitions.

Access Profiles: Access profiles are the security profiles the system uses to connect to the PeopleSoft database.

File Type Code: The file type code stores generic information that is applicable to a group of files within the same target directory. File Type Code may required to create custom change projects to work  with the Change Packager tool. 

If you wish to Change the Field Style in PeopleSoft

If you wish to Change the Field Style in PeopleSoft

Example: &FieldName1.Style = "PSERROR"

How to know Oracle installed Version ?

select * from v$version where banner like 'Oracle%'

PeopleSoft CRM - Call Center Configuration Navigation

Call Center Definition

Setup CRM> Bu related > Call Center Definition

1. Call Center BU

2. Call Center Options

3. Display Tempate

4. Case Defaults

Display Template

Setup CRM > Common Definition > Component Configuration > Display Template

1. Display Template Details

2. Call Display Tempate Policies

Call center Page Field Values

Setup CRM > Product Related > Call Center >

Case Status

Case Type

Case Priority

Case Severity

Case Impact

Case Source

Problem Type

Problem Category

Problem Type

Problem Detail

Group Work List

Setup CRM > Common Definitons >Work list >Group work list

Provider Group

Workforce > Provider Group

User Profile

People Tools > Security >User profile > User Profile

AAF

Enterprise Components > Active Analytics Framework > Polices > Mange Policies

Message Catalog

People Tools > Utilities > Administration > Message Catalog

Tool Bar Configuration

Setup CRM > Common Definition > Component Configuration > Tool bar

1. Toolbar button Definition

2. Toolbat Definition

3. Toolbar Tester

Email Template

Setup CRM > Common Definition > Work flow > Email Template

Requirement : To disable the Component Save Button in People soft Pages

Solution:

Component Properties > Internet Tab > unchecked the save button option

use Button Object to place the page and attach the code call the DOSAVE() or DOSAVENOW () function

PeopleSoft -Multilingual

English is the default PeopleSoft Base Language.

Requirement is to change the Multilingual Data Base

1. In oracle when you choose to mount your DB dump must choose the Unicode database

2. Once done with you Application Server and Web Server configuration

3. Navigate to People Tools > Utilities> Installation Option - enable the native language which you required

4. Once DB dump extraction successfully completed, run the translation script[ which will be delivered by Oracle installation CD ROM] which is specific to your require native language

Data Mover Script for change the BASE Language (BOOT STRAP MODE)

Only Specific to Record

SET BASE_LANGUAGE < TARGET LANGUAGE>

SWAP_BASE_LANGUAGE

To Entire DATABASE

SWAP_BASE_LANGUAGE < TARGET LANGUAGE>

If you require to ignore the errors

SET ignore Error

To Create your record to support multilingual: [ Association of language Related Record]

1. Open Record in App Designer which you required for multi language support

[ E.g. EMP_NOTE]

2. Choose Save As record option to clone the table and Named as Related Record

[E.g. EMP_REL_NOTE]

3. Add a Language_CD field which is must keyed by you related Record

4. Remove the field which is not required for translate [ E.g. only keyed fields , DESC, LONG

DESC fields]

5. Related Record Must match the key order with Base Record

6. Build your related Record

7. Goto Record Properties of your base record >use Tab > Record relationship must add your

related record

8. Build the Base Record.

Swap Audit: swapaudit.SQR is deliverd SQR program to ensure the swap language record audit.

Best performance : when you create a language related record must remove the alternate search key and search Key fields.