Exporting Product Catalog data

Before you begin

Create a new report of AR System type for each staging form. While designing this report, include all the fields. You use this report to export the data in .arx format.

To export data from the Product Catalog

Perform the following steps to export data from the Product Catalog:

1. Log on to the BMC Remedy ITSM server as an administrator.
2. Use one of the following methods to open the appropriate form:
   • Enter the direct URL:
     http://<midTierServer>:<portNumber>/arsys/forms/<arSystemServer>/yourForm
     For example, to open the PDL:ESIDversioninfoCustom form:
     http://CalbroServer:8080/arsys/forms/SanJoseServer/PDL:ESIDversioninfoCustom
   • Open the Object List to search for the form:
     http://<midTierServer>:<portNumber>/arsys/forms
     If the form has an alias, you must search for the alias. Otherwise, search for the form name. If you see two versions of the form listed, select the object listed as a Form, and not the Join Form. 
     
     For more information about creating reports and configuring the object list, see Using the Object List in the BMC Remedy Action Request System online documentation.
3. Make sure that the form is in Search mode.
4. Search for all records in the form or for just the subset that you want to export. 
   
   To search for all records, leave the form blank and click Search. 
   
   If an error occurs when you perform an unqualified search or if your query hits the 1000-record query limit, perform the following steps:
   1. Open the IT Home page.
   2. Open the AR System Administration Console for the BMC Remedy ITSM server.
   3. Click System > General > Server Information.
   4. On the AR System Administration: Server Information form, click the Configuration tab.
   5. Select Allow Unqualified Searches.
   6. In the Server Table Chunk Size field, enter a different value (for example, 0, for unlimited records returned in the query). This setting can result in slower performance.
   7. Click OK. 
      
      You can then return to the form and perform the search.
5. Create reports to export the data from the staging forms.
   1. Select all the records returned in the search.
   2. Click the Report button. 
      
      When the Reporting Console opens, reports that are associated with the form and that you have permission to access appear in the list. The list can include AR System, and BIRT type of reports. If no reports appear in the Reporting Console list, you must create a new AR System type of report.
   3. To generate .arx output, select an AR System type report, as identified in the Report Type field. 
      
      All the records that you selected are passed to the report. 
      
      If no reports appear in the Reporting Console list, either there is no report associated with this form or you do not have permission to access it. In that case, you must create a new AR System type of report.
   4. In the Destination field, select File.
   5. In the Format field, select AR Export.
   6. Enter a name for your report. 
      
      Change the file name to the form name, and do not use illegal characters.
   7. Click Run.
6. Repeat this procedure for each staging form that you are exporting.