Creating Time Lag (Delay )

&current_time = %Datetime;
&delay_time = AddToDateTime(&current_time, 0, 0, 0, 0, 0, 120);
While True
   If %Datetime > &delay_time Then
      Break;
   End-If;
End-While;

Excel to CI Utility

Excel to CI Utility
I am Gng to write about how to use Excel to load data in the Component .I am gng to give a just basic steps to use this utility.


How to enter Connection Data .
1)Web Server Machine Name :Without any protocol Name
(E.g  hrmsonlinedev.somecompany.com)


2)Protocol:Http


3)HTTP Port :Give the port name of your Instance(LOOK into Address bar of your Instance)


4)Portal:psp/Employee


5)PeopleSoft Site Name: This will be your database name. This is the second field after the port number in the URL. e.g (HCMDEV)

6)Node: The PeopleSoft default local node name. The default is PT_LOCAL. To determine the default local node, log into PIA and navigate to PeopleTools > Integration Broker > Node Definitions. Then press the search button without providing any values. The default local node will have a 1 in the Local Node column and a “Y” in the Default Local Node column.
 7)Actions:

Create: if the component interface has create keys. Use this mode when new keys are being added at level 0.


Update: if the component interface does not have create keys. Use this mode if you are adding new children to an existing parent (e.g. inserting new rows into existing collections).


UpdateData: requires you to select this option from the drop-down list. This mode is used to update specific non-key values that already exist but need to be updated. The system uses the keys to locate the row, and when a match is found, the row is updated with new data. If a key match is not found by the system, it displays an error message indicating which collection was missing a key match.

 

• After filling connection information

• Select the field  and Click on Select Input Cell to Select the field for which   you want to enter data.Similary Select All the fields.Then click on New Input Cell

• In Data Input sheet , fill the sheet with the data which you want to upload and the  click on Stage Data For Submission & Finally Click  on Submit on the Last Sheet.That will upload the DATA .If any error comes then check the data which you are uploading.To see the error just keep cursor on Error.

Note that:

Level 0 is indicated 000

Level 1--100

Level 2-110

Limitation of Excel to CI.

1) We can upload max 65000  rows .

2)Can’t load Components that have no keys at level 0, but rely on logic at level 0 to load the level 1 collection

Tip: For safer side, please create new CI. Don't use existing CI for which code has written, as existing CI may corrupt your excel to CI.

Go to Next Sheet "Template".log in with ur PIA credential and give CI name.