Displaying CSV files in the portal

If you wish to display a file made up of data arranged in comma-separated values (CSV) format (or any other separator for that matter), you can use the CSV Viewer portlet (CSV File Viewer). The CSV data will be displayed in tabular format with alternate row shading and headings.

A maximum of 5 records will be shown. To view all the records, click the maximize button.

 

Set up the CSV Viewer

  1. Edit the portlet by selecting the icon from the title bar.
  2. Enter Data File URL by specifying the location of a CSV data file to view in the CSV Viewer.
  3. Enter Data Separator Character. If the file uses a separator character other than a comma, for example a colon (:) or logical or (|), enter that character in the field.
  4. Select Save to commit your changes.

In order to change the portlet's title from its default of "CSV File Viewer" to something more appropriate to its content, take the following steps:

  1. Go to the Administration page.
  2. Select Portlet Management from the list on the left.
  3. Select Portlets from the options under Portal Management.
  4. Find the CSV File Viewer portlet. You may do this by browsing the list of available portlets, or by using the Search feature, with "Title starts with" set to "CSV File Viewer".
  5. Select the Configure option for the CSV File Viewer portlet.
  6. To change the title of the portlet, select I want to set titles and descriptions. On the following page, select Edit next to the language-specific title you wish to modify, make your changes, then select OK.
  7. Select OK to save your changes.

The settings that you specify when editing this portlet (above) are not global (as opposed to the configuration settings), so the same portlet can be deployed on different pages with different settings. The portlet's title is global, however, so if it needs to be different, you will need to clone the CSV viewer portlet and create a new one. In order to do this, go to Administration > Portlets > Portlet Management > Portlets. There you may select the CSV File Viewer portlet from the given list and select the Copy icon.

 

See also

Home |

 

WebSphere is a trademark of the IBM Corporation in the United States, other countries, or both.

 

IBM is a trademark of the IBM Corporation in the United States, other countries, or both.