PeopleTools 8.52: Feed Publishing Framework

Administering Feeds

This chapter discusses how to:

Administer the Feed Publishing Framework.
Convert feed metadata between PeopleTools releases.
Use SysAudit information.
Archive feeds.

Administering the Feed Publishing Framework

This section discusses how to:

Set Feed Publishing Framework options.
Define feed categories.
Copy feed definitions.
Delete feed definitions.
Edit feed templates.

Pages Used to Administer the Feed Publishing Framework

Page Name	Definition Name	Navigation	Usage
Feed Options	PTFP_OPTIONS	PeopleTools, Feeds, Feed Options	Define system-wide options for the Feed Publishing Framework.
Define Feed Categories	PTFP_CATEGORIES	PeopleTools, Feeds, Define Feed Categories	Manage the categories used to organize feeds.
Copy Feed Definitions	PTFP_SAVEAS	PeopleTools, Feeds, Copy Feed Definitions	Clone an existing feed definition to one with a new feed ID.
Delete Feed Definitions	PTFP_DELETE	PeopleTools, Feeds, Delete Feed Definitions	Delete the selected feed definitions from all sites.
Define Feed Categories - Delete Confirmation	PTFP_CONFIRM_DEL	Click the Delete Category button on the Define Feed Categories page.	Confirm the deletion of a feed category.
Delete selected feeds? - Delete Confirmation	PTFP_CONFIRM_DEL	Click the Delete Selected Feeds button on the Delete Feed Definitions page.	Confirm the deletion of a feed definition.
Copy Feed Definitions - Copy confirmed	PTFP_CONFIRM_SAVE	Click the Save Selected Feed button on the Copy Feed Definitions page.	Confirm the copy of a feed definition.
Edit Feed Templates	PTFP_TEMPLATE	PeopleTools, Feeds, Edit Feed Templates	Edit or delete feed templates.
Delete feed template? - Delete Confirmation	PTFP_TEMPLATE_DEL	Click a Delete button on the Edit Feed Templates page.	Confirm the deletion of a feed template.

Setting Feed Publishing Framework Options

Access the Feed Options page (PeopleTools, Feeds, Feed Options).

Use the Feed Options page to define system-wide options for the Feed Publishing Framework.

Log client request	Select Yes to enable logging of feed requests in the PTFP_ACCESS_LOG table. The default value is No.
Last Log ID	Displays the log ID of the last feed request.
Max Rows Limit	Specify the limit for the maximum number of feed entries in a feed. This limit applies to all feed types except paged scheduled feeds.
Show Inactive Feed Menu	Select No to hide the related feeds hover menu when it is inactive—that is, when no feeds of that type have been defined. The default value is Yes, show the related feeds hover menu when it is inactive.

Defining Feed Categories

Access the Define Feed Categories page (PeopleTools, Feeds, Define Feed Categories).

Use the Define Feed Categories page to manage categories used to organize feeds.

Category ID	Specify a unique ID for the feed category. Note. The category ID is a user-specified, not system-defined, value.
Description	Enter a short description for the feed category. This description appears wherever a category can be assigned to a feed definition and in locations where you can search for feeds.
Active	Indicate whether the feed category is active or inactive. An inactive category is not available to assign to feed definitions or in locations where you can search for feeds. However, if a feed definition is assigned to a category and then that category is made inactive, the feed definition no longer displays an assigned category.
Long Description	Enter a long description for the feed category.
Owner ID	Select the owner ID for the feed category. The owner ID is a way to identify which definitions are owned by which PeopleSoft applications, such as PeopleSoft General Ledger, Accounts Receivables, PeopleTools, and so on. The values in the drop-down list box are Translate table values associated with the OBJECTOWNERID field.
Save Category	Click to save the feed category.
Delete Category	Click to delete the feed category. If a feed definition is assigned to a category and then that category is deleted, the feed definition no longer displays an assigned category.

Copying Feed Definitions

Access the Copy Feed Definitions page (PeopleTools, Feeds, Copy Feed Definitions).

Use the Copy Feed Definitions page to clone an existing feed definition to one with a new feed ID. The new feed definition is published with the same feed options and to the same sites as the original.

Data Type	Select from the following feed data types: All Data Types returns a list of all feeds to which you have access. Note. This value is the default. IB Generic Message Feeds returns a list of Integration Broker generic message feeds. List of Feeds returns a list of all feed list feeds. PS Query Feeds returns a list of PeopleSoft Query feeds. Worklist Feeds returns a list of worklist feeds. Note. The previous list includes only the base feed data types delivered with PeopleTools. The results can differ on your system depending which other PeopleSoft applications you have installed and whether any custom feed data types have been developed.
Feed Type	Select from the following feed types: Real Time returns a list of real-time feeds. Scheduled returns a list of scheduled feeds.
Site Name	Select from the sites available on your system. This field does not filter the search results; the results indicate whether a feed definition is published to the selected site.
Category	Select from the active feed categories defined on your system.
Keyword	Enter a keyword to narrow the search criteria. Keywords search the Feed ID, Feed Title, and Description fields and are not case sensitive.
Search	Click the Search button to return the list of available feeds that satisfy the search criteria that you entered.
Reset	Click the Reset button to clear the search results and reset all search criteria to their default values.
Feed Definitions	Select the feed from this grid that you wish to copy. Note. The Published field indicates that the feed definition is published to the site selected in the Site Name field.
New Feed ID	Enter an ID for the new feed definition using only alphabetic characters (A–Z), numeric characters (0–9), and the underscore character (_). Note. The system converts all lowercase characters to uppercase. In addition, it will convert any other special characters, such as a space, #, @, and so on, to an underscore.
Include Personalization Data	Select this option to copy user-specified and administrator-specified data source parameter values along with the feed definition.
Save Selected Feed	Click to copy the selected feed definition to a new feed definition.

Deleting Feed Definitions

Access the Delete Feed Definitions page (PeopleTools, Feeds, Delete Feed Definitions).

Use the Delete Feed Definitions page to delete selected feed definitions. The system deletes the feed definition from all sites to which it has been published.

Data Type	Select from the following feed data types: All Data Types returns a list of all feeds to which you have access. Note. This value is the default. IB Generic Message Feeds returns a list of Integration Broker generic message feeds. List of Feeds returns a list of all feed list feeds. PS Query Feeds returns a list of PeopleSoft Query feeds. Worklist Feeds returns a list of worklist feeds. Note. The previous list includes only the base feed data types delivered with PeopleTools. The results can differ on your system depending which other PeopleSoft applications you have installed and whether any custom feed data types have been developed.
Feed Type	Select from the following feed types: Real Time returns a list of real-time feeds. Scheduled returns a list of scheduled feeds.
Site Name	Select from the sites available on your system. This field does not filter the search results; the results indicate whether a feed definition is published to the selected site.
Category	Select from the feed categories defined on your system.
Keyword	Enter a keyword to narrow the search criteria. Keywords search the Feed ID, Feed Title, and Description fields and are not case sensitive.
Search	Click the Search button to return the list of available feeds that satisfy the search criteria that you entered.
Reset	Click the Reset button to clear the search results and reset all search criteria to their default values.
Feed Definitions	Select the feed definition or definitions from this grid that you want to delete. Note. The Published field indicates that the feed definition is published to the site selected in the Site Name field.
Select All	Click to select all feed definitions in the list.
Clear All	Click to clear the selection of any feed definitions.
Delete Selected Feeds	Click to delete the selected feed definition or definitions.

Editing Feed Templates

Access the Edit Feed Templates page (PeopleTools, Feeds, Edit Feed Templates).

Use the Edit Feed Templates page to edit or delete feed templates.

Data Type	Select from the following feed data types: All Data Types returns a list of all feed templates to which you have access. Note. This value is the default. IB Generic Message Feeds returns a list of Integration Broker generic message feed templates. List of Feeds returns a list of all feed list feed templates. PS Query Feeds returns a list of PeopleSoft Query feed templates. Worklist Feeds returns a list of worklist feed templates. Note. The previous list includes only the base feed data types delivered with PeopleTools. The results can differ on your system depending which other PeopleSoft applications you have installed and whether any custom feed data types have been developed.
Feed Type	Select from the following feed types: Real Time returns a list of real-time feed templates. Scheduled returns a list of scheduled feed templates.
Category	Select from the active feed categories defined on your system.
Keyword	Enter a keyword to narrow the search criteria. Keywords search the Feed ID, Feed Title, and Description fields and are not case sensitive.
Search	Click the Search button to return the list of available feed templates that satisfy the search criteria that you entered.
Reset	Click the Reset button to clear the search results and reset all search criteria to their default values.
Edit	Click the Edit button to edit the feed template in the Feed Publishing Wizard. See Step 1: Specifying Feed Properties.
Delete	Click to delete the feed template.

Converting Feed Metadata Between PeopleTools Releases

This section discusses how to:

Convert feed metadata from PeopleTools 8.50 or 8.51 to the current release (ad hoc conversions).
Convert feed metadata from the current release to PeopleTools 8.50 or 8.51.

Starting with PeopleTools 8.52, feed definitions, feed templates, feed categories, and feed data types can be managed as PeopleTools managed objects. This enhancement required a change to the data structures that store feed metadata. Starting with PeopleTools 8.52, new tables were introduced to store feed metadata—specifically, tables with a PSFP_ prefix. In addition, the pre-PeopleTools 8.52 tables (that is, tables with a PS_PTFP_ prefix) are now used as staging tables for importing and converting metadata to the PeopleTools 8.52 format. The appendix provides a list showing the mapping of pre-8.52 tables to their current equivalents.

See Feed Metadata Table Structures in PeopleTools 8.52.

Page Used to Convert Feed Metadata Between PeopleTools Releases

Page Name	Definition Name	Navigation	Usage
Metadata Conversion	PTFP_MDATA_CON	PeopleTools, Feeds, Metadata Conversion	Convert feed metadata from a previous release to the current release.

Converting Feed Metadata from PeopleTools 8.50 or 8.51 to the Current Release (Ad Hoc Conversions)

This section provides an overview of using the Metadata Conversion page and discusses how to:

Convert feed definitions to the current release.
Convert feed data types to the current release.
Convert feed categories to the current release.

The PeopleTools upgrade process automatically converts existing feed metadata to the format introduced in PeopleTools 8.52. Therefore, if you have upgraded your PeopleSoft system from a previous release, then you do not need to complete any of these ad hoc conversions. However, if you have feed definitions, feed data types, or feed categories in a PeopleSoft system that has not been upgraded and want those feed objects to be migrated to an instance on the current release, then you can use the Metadata Conversion page and the procedures in this section to convert that metadata in an ad hoc manner to the PeopleTools 8.52 format.

Overview of Using the Metadata Conversion Page

Access the Metadata Conversion page (PeopleTools, Feeds, Metadata Conversion).

Use the Metadata Conversion page to convert feed metadata from a previous release (PeopleTools 8.50 or 8.51) to the current release. Each object type (feed definition, feed data type, and feed category) can be loaded and converted separately of the other object types.

Data Type	Enter any text to search for and retrieve all imported feed data types matching the search string in its initial characters. The following search strings each retrieve the data type named ADMN_TYPE: AD AD% %MN If no search string is specified, then all imported feed data types are retrieved.
Category	Enter any text to search for and retrieve all imported feed categories matching the search string in its initial characters. The following search strings each retrieve the category named FINANCE: FI FI% %NA If no search string is specified, then all imported feed categories are retrieved.
Feed	Enter any text to search for and retrieve all imported feed definitions matching the search string in its initial characters. The following search strings each retrieve the feed definition named ADMN_WORKLIST1: AD AD% %WORKLIST If no search string is specified, then all imported feed definitions are retrieved.
Search	Click the Search button to search for imported objects matching the search criteria. If no search string is specified, then all imported objects of that type are retrieved.
Select	Select an object to convert or delete.
Convert	Click the Convert button to converted the selected objects to the PeopleTools 8.52 format. Clicking the Convert button converts the data only and doesn't delete data from the staging tables (the PS_PTFP_ tables). Use the Delete button to manually delete data from the staging tables. Important! If an object with the same ID already exists in the database, then a new version of that object is created, which becomes the current version of the object.
Delete	Click the Delete button to remove the selected objects from the pre-PeopleTools 8.52 staging tables—that is, from the tables with a PS_PTFP_ prefix. See Feed Metadata Table Structures in PeopleTools 8.52.

Converting Feed Definitions to the Current Release

Converting feed definitions from PeopleTools 8.50 or 8.51 to the current release consists of three major steps:

Exporting the feed definitions from the source system.
Importing the feed definitions into the PeopleTools 8.52 (or later) system.
Converting the metadata to the PeopleTools 8.52 format.

To export the feed definitions from the source system, retrieve and run the appropriate Data Mover script:

In the browser logged into the PeopleTools 8.52 (or later) system, select PeopleTools, Utilities, Administration, Message Catalog.
Enter 219 in the Message Set Number field and press the ENTER key.
Click the Find link and enter one of the following values in the Enter Search String field:
- Enter 3300 to retrieve the script for exporting feed definitions without user personalization data.
- Enter 3302 to retrieve the script for exporting feed definitions with user personalization data.
Click the OK button
Copy the script from the Description field.
Run PeopleSoft Data Mover on the source database.
Paste the script into the upper pane.
Modify the script as follows:
- Change all occurrences of %3 to a value for this export of data—for example:
```
PRODSYS01
```
- Provide a complete path to the .DAT and .LOG files as needed.
- Change all occurrences of %4 to identify the specific feed ID or IDs that you want to export—for example:
```
'ADMN_WORKLIST_01'
'ADMN_WORKLIST_01', 'ADMN_WORKLIST_02'
'ADMN_WORKLIST%', 'ADMN_MY_%'
```
- Optionally, replace %1 and %2 with values to provide a timestamp and the user ID who performed the conversion.
Run the script.

To import the feed definitions into the PeopleTools 8.52 (or later) system, retrieve and run the appropriate Data Mover script:

In the browser logged into the PeopleTools 8.52 (or later) system, select PeopleTools, Utilities, Administration, Message Catalog.
Enter 219 in the Message Set Number field and press the ENTER key.
Click the Find link and enter one of the following values in the Enter Search String field:
- Enter 3301 to retrieve the script for importing feed definitions without user personalization data. Use this script if you selected 3300 in the previous step 3.
- Enter 3303 to retrieve the script for importing feed definitions with user personalization data. Use this script if you selected 3302 in the previous step 3.
Click the OK button
Copy the script from the Description field.
Run PeopleSoft Data Mover on the PeopleTools 8.52 (or later) database.
Paste the script into the upper pane.
Modify the script as follows:
- Change all occurrences of %3 to the value that you specified for %3 in the previous step 8—for example:
```
PRODSYS01
```
- Provide a complete path to the .DAT and .LOG files as needed.
- Change all occurrences of %4 to the value that you specified for %4 in the previous step 8—for example:
```
'ADMN_WORKLIST_01'
'ADMN_WORKLIST_01', 'ADMN_WORKLIST_02'
'ADMN_WORKLIST%', 'ADMN_MY_%'
```
- Optionally, replace %1 and %2 with values to provide a timestamp and the user ID who performed the conversion.
Run the script.

To convert the metadata to the PeopleTools 8.52 format:

In the browser logged into the PeopleTools 8.52 (or later) system, select PeopleTools, Feeds, Metadata Conversion.
Click the Search button next to the text field labeled Feed to retrieve all imported feed definitions. Alternatively, enter the initial letters of the feed IDs for the feed definitions that you want to retrieve in the Feed text field and click Search.

The Non-Metadata Feed Definitions grid is loaded with imported feed definitions.
Click in the Select column to select each of the feed definitions that you want to convert.
Click the Convert button.
To verify that the selected feed definitions were converted to the PeopleTools 8.52 format, go to the My Feeds page.
Click the Search button to list all feed definitions. Alternatively, enter search criteria to retrieve selected feeds only.

Converting Feed Data Types to the Current Release

Converting feed data types from PeopleTools 8.50 or 8.51 to the current release consists of three major steps:

Exporting the feed data types from the source system.
Importing the feed data types into the PeopleTools 8.52 (or later) system.
Converting the metadata to the PeopleTools 8.52 format.

To export the feed data types from the source system, retrieve and run the appropriate Data Mover script:

In the browser logged into the PeopleTools 8.52 (or later) system, select PeopleTools, Utilities, Administration, Message Catalog.
Enter 219 in the Message Set Number field and press the ENTER key.
Click the Find link and enter 3304 in the Enter Search String field
Click the OK button
Copy the script from the Description field.
Run PeopleSoft Data Mover on the source database.
Paste the script into the upper pane.
Modify the script as follows:
- Change all occurrences of %3 to a value for this export of data—for example:
```
PRODSYS01
```
- Provide a complete path to the .DAT and .LOG files as needed.
- Change all occurrences of %4 to identify the specific feed data type ID or IDs that you want to export—for example:
```
'MY_DATATYPE_01'
'MY_DATATYPE_01', 'MY_DATATYPE_02'
'%FEED', 'MY_%'
```
- Optionally, replace %1 and %2 with values to provide a timestamp and the user ID who performed the conversion.
Run the script.

To import the feed data types into the PeopleTools 8.52 (or later) system, retrieve and run the appropriate Data Mover script:

In the browser logged into the PeopleTools 8.52 (or later) system, select PeopleTools, Utilities, Administration, Message Catalog.
Enter 219 in the Message Set Number field and press the ENTER key.
Click the Find link and enter 3305 in the Enter Search String field.
Click the OK button
Copy the script from the Description field.
Run PeopleSoft Data Mover on the PeopleTools 8.52 (or later) database.
Paste the script into the upper pane.
Modify the script as follows:
- Change all occurrences of %3 to the value that you specified for %3 in the previous step 8—for example:
```
PRODSYS01
```
- Provide a complete path to the .DAT and .LOG files as needed.
- Change all occurrences of %4 to the value that you specified for %4 in the previous step 8—for example:
```
'MY_DATATYPE_01'
'MY_DATATYPE_01', 'MY_DATATYPE_02'
'%FEED', 'MY_%'
```
- Optionally, replace %1 and %2 with values to provide a timestamp and the user ID who performed the conversion.
Run the script.

To convert the metadata to the PeopleTools 8.52 format:

In the browser logged into the PeopleTools 8.52 (or later) system, select PeopleTools, Feeds, Metadata Conversion.
Click the Search button next to the text field labeled Data Type to retrieve all imported feed data types. Alternatively, enter the initial letters of the feed data type IDs for the feed data types that you want to retrieve in the Data Type text field and click Search.

The Non-Metadata Feed Datatypes grid is loaded with imported feed data types.
Click in the Select column to select each of the feed data types that you want to convert.
Click the Convert button.
To verify that the selected feed data types were converted to the PeopleTools 8.52 format, go to the Define Feed Data Types page (select PeopleTools, Feeds, Define Feed Data Types).
Click the Search button to list all feed data types.

Converting Feed Categories to the Current Release

Converting feed categories from PeopleTools 8.51 to the current release consists of three major steps:

Exporting the feed categories from the source system.
Importing the feed categories into the PeopleTools 8.52 (or later) system.
Converting the metadata to the PeopleTools 8.52 format.

Note. Feed categories were introduced in PeopleTools 8.51. Therefore, these procedures apply to PeopleTools 8.51 only, and not to 8.50.

To export the feed categories from the source system, retrieve and run the appropriate Data Mover script:

In the browser logged into the PeopleTools 8.52 (or later) system, select PeopleTools, Utilities, Administration, Message Catalog.
Enter 219 in the Message Set Number field and press the ENTER key.
Click the Find link and enter 3306 in the Enter Search String field
Click the OK button
Copy the script from the Description field.
Run PeopleSoft Data Mover on the source database.
Paste the script into the upper pane.
Modify the script as follows:
- Change all occurrences of %3 to a value for this export of data—for example:
```
PRODSYS01
```
- Provide a complete path to the .DAT and .LOG files as needed.
- Change all occurrences of %4 to identify the specific feed category ID or IDs that you want to export—for example:
```
'MY_CATEGORY_01'
'MY_CATEGORY_01', 'MY_CATEGORY_02'
'%'
```
- Optionally, replace %1 and %2 with values to provide a timestamp and the user ID who performed the conversion.
Run the script.

To import the feed categories into the PeopleTools 8.52 (or later) system, retrieve and run the appropriate Data Mover script:

In the browser logged into the PeopleTools 8.52 (or later) system, select PeopleTools, Utilities, Administration, Message Catalog.
Enter 219 in the Message Set Number field and press the ENTER key.
Click the Find link and enter 3307 in the Enter Search String field.
Click the OK button
Copy the script from the Description field.
Run PeopleSoft Data Mover on the PeopleTools 8.52 (or later) database.
Paste the script into the upper pane.
Modify the script as follows:
- Change all occurrences of %3 to the value that you specified for %3 in the previous step 8—for example:
```
PRODSYS01
```
- Provide a complete path to the .DAT and .LOG files as needed.
- Change all occurrences of %4 to the value that you specified for %4 in the previous step 8—for example:
```
'MY_CATEGORY_01'
'MY_CATEGORY_01', 'MY_CATEGORY_02'
'%'
```
- Optionally, replace %1 and %2 with values to provide a timestamp and the user ID who performed the conversion.
Run the script.

To convert the metadata to the PeopleTools 8.52 format:

In the browser logged into the PeopleTools 8.52 (or later) system, select PeopleTools, Feeds, Metadata Conversion.
Click the Search button next to the text field labeled Category to retrieve all imported feed categories. Alternatively, enter the initial letters of the feed category IDs for the feed categories that you want to retrieve in the Category text field and click Search.

The Non-Metadata Feed Categories grid is loaded with imported feed categories.
Click in the Select column to select each of the feed categories that you want to convert.
Click the Convert button.
To verify that the selected feed categories were converted to the PeopleTools 8.52 format, go to the Define Feed Categories page (select PeopleTools, Feeds, Define Feed Categories).
Click the Search button to list all feed categories.

Converting Feed Metadata from the Current Release to PeopleTools 8.50 or 8.51

This section discusses how to:

Convert from the current release to 8.51.
Convert from the current release to 8.50.

Converting from the Current Release to 8.51

Converting feed definitions from the current release to PeopleTools 8.51 consists of two major steps:

Creating a change package on the current release.
Importing the change package into the PeopleTools 8.51 system using PeopleSoft Change Assistant.

To create a change package on the current release:

Sign into Application Designer on the current release in two-tier mode.
Create a new project.
Add the feed objects (feed definitions, feed data types, feed categories, or any combination of these objects) that you want to convert to the project.
From the menu, select File, Project Properties.
Select the Change Project option.
Go to the Update IDs tab.
Specify an update ID. If necessary, create a new update ID.
If there are prerequisite updates associated with this update, go to the Pre-Requisites tab and specify the update IDs there.
From the menu, select Tools, Create Change Package.
Specify the export directory—for example, C:\temp.
Select the option to generate a new template.
Click OK to begin the process of creating the change package.

Several Application Engine processes will be launched in separate windows. A pop-up status message will indicate the success of the change package creation.

After the change package has been created, you can examine the data files, scripts, and miscellaneous files created in the update ID subdirectory of the export directory—C:\temp\updupdate_ID.

To import the change package into PeopleTools 8.51 using PeopleSoft Change Assistant:

Run PeopleSoft Change Assistant on the PeopleTools 8.51 system.
Apply this update to the system.

See Applying Updates.

Converting from the Current Release to 8.50

Converting feed definitions from the current release to PeopleTools 8.50 consists of two major steps:

Creating a change package on the current release.
Importing the exported data into the PeopleTools 8.50 system using PeopleSoft Data Mover.

To create a change package on the current release:

Sign into Application Designer on the current release in two-tier mode.
Create a new project.
Add the feed objects (feed definitions, feed data types, or any combination of these objects) that you want to convert to the project.

Note. Because feed categories were introduced in PeopleTools 8.50, feed category definitions cannot be converted to a PeopleTools 8.50 system. Do not include any feed category objects in your project.
From the menu, select File, Project Properties.
Select the Change Project option.
Go to the Update IDs tab.
Specify an update ID. If necessary, create a new update ID.
If there are prerequisite updates associated with this update, go to the Pre-Requisites tab and specify the update IDs there.
From the menu, select Tools, Create Change Package.
Specify the export directory—for example, C:\temp.
Select the option to generate a new template.
Click OK to begin the process of creating the change package.

Several Application Engine processes will be launched in separate windows. A pop-up status message will indicate the success of the change package creation.

After the change package has been created, you can examine the data files, scripts, and miscellaneous files created in the update ID subdirectory of the export directory—for example, C:\temp\updupdate_ID.

To import the exported data into PeopleTools 8.50 using PeopleSoft Data Mover:

Go to the batch scripts subdirectory of the export directory. For example, go to C:\temp\updupdate_ID\updupdate_ID_batch\scripts directory.
If you exported feed definitions, edit the updupdate_ID_FeedDef_i.dms script.
Replace the <%STAGINGDIRECTORY%> placeholder with the path to the batch directory—for example, C:\temp\updupdate_ID\updupdate_ID_batch.

Replace the IMPORT *; command with the following commands:

REPLACE_ALL PS_PTFP_FEED AS TEMP_PS_PTFP_FEED;


INSERT INTO PS_PTFP_FEED 
    SELECT 
	T.PTFP_FEED_ID,
	T.DESCR,
	T.DESCR254,
	T.OBJECTOWNERID,
	T.PTFP_CATEGORY_ID,
	T.PTFP_DATATYPE_ID,
	T.PTFP_FEED_FORMAT,
	T.PTFP_CACHE_TYPE,
	T.PTFP_CACHE_TIME,
	T.PTFP_OPR_AUTH_TYPE,
	T.PTFP_OPR_ID,
	T.PTFP_OPR_PWD,
	T.PTFP_SEC_TYPE,
	T.IB_OPERATIONNAME,
	T.PORTAL_NAME,
	T.MSGNODENAME,
	T.CREATEDTTM,
	T.CREATEOPRID,
	T.LASTUPDDTTM,
	T.LASTUPDOPRID        
  FROM TEMP_PS_PTFP_FEED T;

IMPORT PS_PTFP_ADMN_PREF;
IMPORT PS_PTFP_ATTRS;
IMPORT PS_PTFP_ATTRS_LANG;
IMPORT PS_PTFP_FEED_LANG;
IMPORT PS_PTFP_PARMS;
IMPORT PS_PTFP_PARMS_LANG;
IMPORT PS_PTFP_PUB_SITES;
IMPORT PS_PTFP_PVALS;
IMPORT PS_PTFP_PVALS_LANG;
IMPORT PS_PTFP_SECURITY;
IMPORT PS_PTFP_SETTINGS;


UPDATE PSSTATUS SET LASTREFRESHDTTM = %currentdatetimein;

Save your changes to the script.
Run PeopleSoft Data Mover on the PeopleTools 8.50 system.
Paste the script into the upper pane.
Run the script.
If you exported feed data types, edit the updupdate_ID_FeedDat_i.dms script.
Replace the <%STAGINGDIRECTORY%> placeholder with the path to the batch directory—for example, C:\temp\updupdate_ID\updupdate_ID_batch.
Paste the script into the upper pane in PeopleSoft Data Mover.
Run the script.

Using SysAudit Information

SysAudit information is available for:

Feed definition integrity.
PS Query feed integrity.
Worklist feed integrity.

Archiving Feeds

This section provides an overview of archiving feed data and discusses how to archive scheduled feed data.

Understanding the Archiving of Feed Data

Scheduled feeds are published asynchronously and stored as messages in Integration Broker queues. The process of archiving feed data archives the messages stored in the Integration Broker queues used by scheduled feeds. You run a batch process to archive and delete the queue message data.

This section provides an overview of:

Feed archiving parameters.
Feed archiving options and logic.

Feed Archiving Parameters

The following parameters specified in the feed definition are used for archiving the Integration Broker queue messages:

Integration Broker Service Operation name

For generic scheduled feeds, the service operation name is the value of the IB_OPERATIONNAME data source setting.

For other scheduled feeds, the system uses the service operations listed in the Feed Service Operations grid on the Define Data Types page.
Integration Broker subqueue name, when applicable

For generic scheduled feeds, no subqueue name exists.

For other scheduled feeds, the Feed ID value is the sub queue name.
PTFP_FEED:UTILITY:Utility DSPARAMETER_MAXROW

For scheduled feeds, you must define this parameter in the data source parameter for the data type.

This parameter indicates the number of feed items that will appear to the user.
- If the parameter value is PTFP_FEED:UTILITY:Utility SF_MAXROWOPTION_LATESTMSG, then only the latest message in the Integration Broker queue appears to the user.
- If the parameter value is PTFP_FEED:UTILITY:Utility SF_MAXROWOPTION_ALLMSGS, then all the messages in the Integration Broker queue appear to the user.
- The parameter can be a number, for example, 4, which indicates that only 4 items appear to the user.
PTFP_FEED:UTILITY:Utility DSPARAMETER_SF_MAXMINUTES

For scheduled feeds, you must define this parameter in the data source parameter for the data type.

This parameter tells the length of time for which the feed messages are valid in the Integration Broker queues.
- If the parameter value is PTFP_FEED:UTILITY:Utility SF_MAXMINUTES_ALLMSGS, then all the messages appear to the user.
- If the parameter value is a number, for example 100, then all the feed messages existing in the Integration Broker queue for fewer than 100 minutes appear to the user.

Feed Archiving Options and Logic

This table describes the feeds archiving options and logic:

Option Value	Description	Archiving Logic
0	Archive all messages that are not within the specified date and time range.	When DSPARAMETER_SF_MAXMINUTES is not SF_MAXMINUTES_ALLMSGS.
1	Archive all messages except latest 1 message per subqueue per language.	When DSPARAMETER_SF_MAXMINUTES is SF_MAXMINUTES_ALLMSGS and DSPARAMETER_MAXROW is SF_MAXROWOPTION_LATESTMSG.
2	Archive all messages except latest n messages per subqueue per language.	When DSPARAMETER_SF_MAXMINUTES is SF_MAXMINUTES_ALLMSGS and DSPARAMETER_MAXROW is some number. This number indicates the number of messages that should not be archived.
3	Archive nothing.	When DSPARAMETER_SF_MAXMINUTES is SF_MAXMINUTES_ALLMSGS and DSPARAMETER_MAXROW is SF_MAXROWOPTION_ALLMSGS.

Note. The feed archiving options are implicitly arrived at based on the feed definition. These cannot be specified when the PTIBFEEDARCH process runs.

Page Used to Archive Feeds

Page Name	Definition Name	Navigation	Usage
Run Feed Archive	IB_FEEDARCHIVE	PeopleTools, Feeds, Archive Feed Data	Archive the messages stored in the Integration Broker queues used by scheduled feeds. Run a batch process to archive and delete the queue message data.

Page Name

Definition Name

Navigation

Usage

Run Feed Archive

IB_FEEDARCHIVE

PeopleTools, Feeds, Archive Feed Data

Archive the messages stored in the Integration Broker queues used by scheduled feeds.

Run a batch process to archive and delete the queue message data.

Archiving Scheduled Feed Data

Access the Run Feed Archive page (PeopleTools, Feeds, Archive Feed Data).

Click the Run button to access the PTIBFEEDARCH process:

Use the Run Feed Archive page to archive Integration Broker messages that are used by scheduled feeds. Archiving takes no parameters from the user; parameters for archiving come from the feed definitions themselves.

All scheduled feeds are archived simultaneously; you cannot selectively archive feeds. The process archives and deletes the feed data based on the Archive flag in the Integration Broker queue used in the service operations that published messages to Integration Broker queues. If the Archive flag is enabled, then the messages are archived and then deleted; otherwise, the messages are just deleted.

You can view archived Integration Broker messages by using the Service Operations Monitor. Look for asynchronous services with the Archive flag enabled.

Note. A scheduled feed can be archived only if the service operations involved in the scheduled feeds are listed in the Feed Service Operations grid on the Define Feed Data Types page.

Note. Feeds archiving logic is comparable to Integration Broker archiving logic. For a feed message to be archived, you must select the Archive check box on the Queue Definition page for the service operation. If you do not select the Archive check box, then the feeds archiving process deletes the feed messages and the messages do not appear on the Service Operation Monitor - Asynchronous Services page when the Archive check box is selected.

See Monitoring Asynchronous Service Operation Transactions.