Finding and Viewing Data : Copying Product Data that Displays on a Product List Page
Copying Product Data that Displays on a Product List Page

You can use the “Copy Data to Table� feature to copy to a table the Product data that displays on any Product List page. You can view the data in the table or save the data to a CSV text file on your computer. With either method, you can copy the data from the table and paste it into another application.

Note: Be sure to set the required Internet Explorer options so you can successfully use this feature. See “Setting Internet Explorer (IE) Options for Copy Data to Tableâ€� .

If you do not set the IE options, you may experience inconsistent behavior when you use this feature. Sometimes the data table will appear and sometimes the page may flash momentarily, but there is no indication that your setting is not correct except that the table will not display.

The Copy Data to Table icon appears on the button bar of the following Product List pages:

*
Product List page - All data from this page is copied to the table.
*
Cross Selection Code Product List page - All data from this page is copied to the table.

To copy the Product data that displays on a Product List page

1
On a Product List page, click Copy Data to Table.

One of the following occurs:

*
A table opens displaying the Product data. Go to Step 3 (you can skip Step 2 unless the File Download dialog box opens).
*
The File Download dialog box opens asking if you want to open the file or save it to your computer.
Note: The File Download dialog box will always open unless you deselect the Always ask before opening this type of file check box. This prevents the “Do you want to open or save this fileâ€� question from being asked every time you want to copy data to a table. Continue with Step 2.
2
Do one of the following:
*
Open - To display the Product data in a table format, click Open. Go to Step 3.
*
Save - To save the file as a CSV text file that you can open later in Microsoft Excel, click Save. The Save As dialog box opens.

Do all of the following:

*
Navigate to the location where you want to save the file.
*
In the File name box, enter a name for the file. The file name should have a .csv extension. For example, MensShirts.csv
*
Click Save. The file is saved to the location you selected.
*
Cancel - To cancel your action, click Cancel.
3
Once the table is open, you can select rows and columns of Product data to copy. When you want to close the table, click the X in the upper right corner of the window.

If you modified the table, a dialog box appears when you close the window and asks if you want to save your changes.

To save your changes, click Yes. The Save As dialog box opens.

Do all of the following:

*
Navigate to the location where you want to save the file.
*
In the File name box, enter a name for the file. The file name should have a .csv extension. For example, MensShirts.csv
*
Click Save. The file is saved to the location you selected.

21.2 release. Online Help last updated March 6, 2021

OpenText Active Catalogue Browser Interface User Guide for Vendors PDF


Copyright © 2021 Open Text. All rights reserved.
Trademarks owned by Open Text.