Create lists from Excel spreadsheets or from prebuilt templates, or create your own custom lists from scratch. When you create a list, it becomes available in the resource catalog to add to any page in the portal .
To perform the tasks in this chapter, you must be a portal manager or a portal member with the portal-level permissions
Manage Security and Configuration or
At a minimum, you must have the following permissions:
Edit Pages(to add the Lists task flow to a page)
Edit Task Flows(to modify the task flow, if necessary).
One or more of the following advanced permissions:
Create, Edit, and Delete Listsor
Edit List Data, and
To create and manage lists, the portal-level permission
Prerequisites for Working with Lists
For lists to be available in a portal, the portal manager or anyone with
Manage Security and Configuration or
Manage Configuration permission must perform the following tasks:
If not already enabled, enable the Lists tool, as described in Enabling and Disabling Tools and Services Available to a Portal.
Provide access for users to lists in any of the following ways:
Provide users with the pretty URL to the Lists page (see Pretty URLs for Pages in a Specified Portal).
Add a page link to the Lists page in the portal navigation (see Adding a Lists Page to a Portal).
Add the Lists task flow to a page in the portal (see Adding a Lists Task Flow to a Page).
When a list is created from the Lists page (or console), that list appears in the Resource Catalog. You can then add that task flow to a page in your portal (see Adding a Lists Task Flow to a Page.).
For information about working with lists, Working with the Lists Task Flow.
Lists provide a means of creating, publishing, and managing lists of information. Lists are useful for tracking issues, capturing project milestones, publishing project assignments, and much more. The lists you create in WebCenter Portal can be widely varied in their complexity. For example, you can start with a list of team members, and then include columns for contact information, project role, and links to relevant documents, such as any plans or proposals associated with a listed team member.
The lists created in a portal are unique to that portal. A portal cannot consume the lists created in another portal.
Create and populate lists using the controls on the Lists page (or console) using the Lists viewer. Place populated lists on a page using the List Viewer task flow. Users must have appropriate permissions to perform actions on lists.
Use the controls on the Lists page to create and revise lists and list data and to view all of a portal's current lists (Figure 47-1).
Figure 47-1 Lists on the Lists Page
Description of "Figure 47-1 Lists on the Lists Page"
On the Lists page, you can make use of templates for rapid creation of lists and other features for designing and revising list structure. If you prefer, you can create a list from scratch, adding, and configuring all of the columns yourself, or you can create a list from an Excel spreadsheet.
The List Viewer task flow (Figure 47-2) provides a means of placing a particular list on a page.
Figure 47-2 A List in the List Viewer Task Flow
Description of "Figure 47-2 A List in the List Viewer Task Flow"
The List Viewer provides easy access to all the features required for adding and revising list data, importing/exporting list data, filtering list data, obtaining a list RSS feed (if RSS is enabled in the portal), and linking to other WebCenter Portal assets from the list and from a list row (see Linking Information in WebCenter Portal in Using Portals in Oracle WebCenter Portal).
Additionally, the List Viewer provides access to customization features that enable you to control the look of a particular list instance and its data. For example, use customization to control color banding of rows or columns or to apply filters to list data. For more information, see About Customizing Lists.
Use the Lists page and the List Viewer to add and revise list data throughout the life of the list. Add and revise content directly on a list, or use the Export and Import features to send list data to an Excel file, revise it there, and then import it back into the original list in the portal (for more information, see Exporting a List and Importing a List from an Excel Spreadsheet).
The list is rendered within a List Viewer task flow. See Working with the Lists Task Flow for more information.
The Lists page is available in any portal where lists is enabled. If the Lists page (or console) is not shown by default when you navigate to a portal, refer to Adding a Lists Page to a Portal to expose the Lists page in the portal.
As a portal manager, you can also access the Lists page from Pages and Portals Actions menu: select Manage, then Lists (see Figure 47-3)
Figure 47-3 Lists Menu in Pages and Portals Actions Menu
Lists are not available in the Home portal.
Through tight integration with links, lists provides the opportunity to associate other WebCenter Portal items with an entire list or an individual list row. Linking enables you to associate documents, notes, and URLs with a list or a list row (see Linking Information in WebCenter Portal in Using Portals in Oracle WebCenter Portal).
Lists additionally provide RSS feeds for all lists, if RSS is enabled in the portal (see Enabling or Disabling RSS News Feeds for a Portal). See Obtaining List News Feeds in Using Portals in Oracle WebCenter Portal for using RSS in lists.
Adding a Lists Page to a Portal
To provide navigation to the Lists page in a portal, you can add a page link to the portal navigation, as described in Adding an Existing Page to the Portal Navigation.
The Lists page (or console) is not automatically exposed when the tool is enabled or when the portal is created. However, if the portal template exposes the Lists page, the portal will also automatically expose this page.
Adding a Lists Task Flow to a Page
For the steps to add a lists task flow to a page, see Adding a Component to a Page.
The presence or location of a lists task flow in the resource catalog depends on how the resource catalog is configured. For example, in the default resource catalog, the Lists folder is included under the Social and Communication folder. The Lists folder contains the lists that have been created using the Lists task flow on the Lists page. If no lists have been created, the default resource catalog shows an empty folder
For more information about creating lists, editing the list structure, copying a list, and deleting a list, see Creating and Managing Lists in Using Portals in Oracle WebCenter Portal.
All of the lists created in a portal are available on the Lists page (or console) and through the portal's resource catalog (Figure 47-4).
Figure 47-4 Lists in the Resource Catalog
Description of "Figure 47-4 Lists in the Resource Catalog"
If the portal has only one list that has been created on the Lists page (or console), you will see only that one list in the portal's resource catalog (Figure 47-5).
Figure 47-5 List in the Resource Catalog
Description of "Figure 47-5 List in the Resource Catalog"
Working with List Viewer Task Flow Properties
The List Viewer task flow has associated properties, which users with sufficient privileges can access through the task flow's View Actions menu. For example, select Parameters to display the Parameters dialog (Figure 47-6).
Figure 47-6 List Viewer Task Flow Parameters in the Component Properties Dialog
Description of "Figure 47-6 List Viewer Task Flow Parameters in the Component Properties Dialog"
The following sections provide information about properties associated with the List Viewer task flow and describe the parameters that are unique to it:
Setting List Viewer Task Flow Properties
In the page editor, selecting any component exposes a View Actions menu (Figure 47-7), which provides access to the component’s properties: Parameters, Access, Display Options, Style, and Content Style.
Figure 47-7 View Actions Menu on a List Viewer Task Flow
To set the List Viewer task flow properties:
- Open the page that contains the task flow in the page editor (see Opening a Page in the Page Editor).
- Select the task flow, then click the View Actions menu and select the properties you want to set:
Parameters control the default task flow content. For descriptions of each parameter, see List Viewer Task Flow Parameters. Parameters can be wired to events, and can be used facilitate the wiring of the task flow to page parameters and page definition variables. For more information, see Wiring Pages and Components.
Access settings show or hide the component to specific roles, users, or groups. For more information, see Setting Component Access.
The Display Options, Style, and Content Style properties affect the appearance and behavior of the task flow for all users. These properties are common to all task flows. For more information, see Modifying Component Properties.
- Save your changes.
List Viewer Task Flow Parameters
Table 47-1 describes the parameters that are unique to the List Viewer task flow. Note that List Viewer task flow parameter values are set automatically and should not be changed.
Table 47-1 List Viewer Task Flow Parameters
A unique identifier for the list to show
A unique identifier for the scope containing the list
If no value is present, the current scope is used. This value is set automatically. Do not edit this value.
A unique identifier within the scope for the list customization
This value is set automatically. Do not edit this value.
A unique identifier within the scope for the list to show
A check box for specifying whether to display the list name and description
If no value is present, the list name and description are not shown. Values include
Working with the Lists Task Flow
This section describes how to use the Lists task flow in the portal manager role. It includes the following subsections:
See Working with Lists in Using Portals in Oracle WebCenter Portal for the following tasks:
Creating and Managing Lists describes how to create lists, edit the list structure (rename a list, add columns to a list, rearrange columns, and delete columns), copy a list, and delete a list.
Adding and Managing List Data describes how to add a specific data type to a list, edit list data, delete list rows, and refresh list data.
Sending a Link to a List to Other Users describes how to send a link of a specific list to other users.
About Customizing Lists
You can perform user customizations on your own view of a list instance, or you as the portal manager or application specialist can perform application customizations on a list instance, affecting everyone's view. User personalizations involve changes made in page view mode; while application customizations involve changes made in the page editor. Everyone can perform user personalizations of their own view of a list; but page edit privileges are always required for application-level list customizations.
User and application customizations apply to a list rendered in a List Viewer task flow. They do not apply to lists rendered on the Lists page.
A second instance of a list is not affected by the customizations you make to the first instance. For example, imagine that you have placed the Issues list on both the Sales page and the What's New page. If you sort the list by the Number column on the Sales page, the Issues list is not automatically sorted by Number on the What's New page.
While application customizations affect everyone's view of a list instance, user customizations are layered over them. For example, you may perform an application customization on a list containing columns A, B, and C, so that column C is first in list column order (C, A, B). A user can then perform a user customization on the list so that column A is first in list column order in their personal view of the same list instance (A, C, B).
In the page editor, you can perform application customizations. In page view mode, you see user customizations layered over application customizations. If the same property is set at both the application and user levels, the user value takes precedence in your own view. For user-level customizations, see Customizing Lists in Using Portals in Oracle WebCenter Portal.
This section includes the following topic:
Performing Application-Level Customizations on a List
You can perform user-level or application level customizations on a list. WebCenter Portal users or portal participants can perform these customizations to manage their personal view of lists. An application specialist or portal manager can perform the same customizations from the page editor to affect the view of all users.
Some user and application customizations apply to a list rendered in a List Viewer task flow. They do not apply to lists rendered on the Lists page.
To perform application-level customizations on a list:
- Go to the List page or List instance.
- Open the page in the page editor.
- Customize the list for all users.
See Using Portals in Oracle WebCenter Portal for the following customization tasks that can be performed on a list:
Exporting a List and Importing a List from an Excel Spreadsheet
Lists provides a means of exporting and importing lists. If you can view the list, you can export it to Microsoft Excel 1997 - 2003 and 2007 formats and revise list data in Excel. If you have sufficient privileges to edit the list, you can import the revised list back into WebCenter Portal.
You can also create a list by importing an Excel spreadsheet. For more information, see Creating Lists in Using Portals in Oracle WebCenter Portal.
This section describes how to export and import lists and provides information about additional software that may be of use in this process. It includes the following subsections:
About Exporting and Importing Lists
Use list export and import options to add and revise list rows in a Microsoft Excel spreadsheet. List structure and links for the list and list rows are unaffected by export and import. When exporting a list, only the list data is exported, not the list structure nor the links. When a list is imported, new links and modified links will not be affected by the import.
After you export a list, if other changes are made to list data in WebCenter Portal, they are overwritten when you import the list. Before content is overwritten, a confirmation dialog provides you with an opportunity to stop the import and preserve WebCenter Portal changes.
Importing a spreadsheet cannot be used to modify list structure. However, you can import any spreadsheet to a list that has the same columns. A warning is raised if the spreadsheet was not created from an export of the list, but you can dismiss this warning and proceed if desired. You can also export a list without rows to a spreadsheet, add rows in Excel, and then import it.
You must take care when you export a list not to revise the list structure in Excel nor in WebCenter Portal. You cannot import an exported list if the list structure is changed in WebCenter Portal after export. You can add and remove list rows in the spreadsheet; such changes are reflected in the list on import.
Adding and removing list columns in the spreadsheet does not affect the list structure. Consequently, when you import a spreadsheet with columns that were removed through Excel, the import succeeds. The columns continue to appear in the imported list; though the deleted column data does not.
When you export a list from WebCenter Portal, you are prompted for the Excel format (1997 - 2003 and 2007 formats are offered). To import a spreadsheet, the same formats are accepted.
Exporting a List to a Spreadsheet
When you can view a list, you can export the list to a Microsoft Excel file. Exporting enables you to use your Excel skills to easily add to and revise list data. Controls for exporting lists are available in both the List Viewer task flow and on the Lists page.
To export a list:
- Select the list you want to export, and select Actions, then Export.
- In the Export to Excel dialog, select a format for the output file.
- Follow the prompts to save the exported file to your local file system.
The list is saved in the Excel format you selected. The file name is the list name, with underscores in place of character spaces. For example,
Figure 47-8 Export to Excel Dialog
Description of "Figure 47-8 Export to Excel Dialog"
Importing an Exported List
After you have created or revised list data and saved it in an Excel format, you can import it using controls available in both the List Viewer task flow and on the Lists page. To import list data, you must have, minimally,
Edit permission on the page that contains the list.
To import an exported list:
- Select the list you want to export, and select Actions, then Import.
- In the Import from Excel dialog, click Browse and navigate to the relevant spreadsheet.
The spreadsheet must have the same columns as the list.
The file must be in Excel 1997-2003 (
*.xls) or 2007 format (
Figure 47-9 Import from Excel Dialog
Description of "Figure 47-9 Import from Excel Dialog"
- Click Import.
If the spreadsheet was not created from an export of the list, a warning is given. Click Import to proceed if you choose.
List data is validated on import. If any rows contain validation errors, such errors are presented in a dialog and the import is terminated. You can correct validation errors in the spreadsheet and import again.