Using an AR Export file to change the request ID field format

You can edit AR Export (.arx ) files regardless of the database underlying your BMC Remedy AR System. You can use the .arx strategy or a different strategy that bypasses BMC Remedy AR System to operate directly in the database.

To change the Request ID field format through an AR Export file

1. In the browser, open the form that you want to change.
2. Create a report. See Creating-reports-from-the-AR-System-Report-Console.

3. Perform the following to export the results of the BMC Remedy AR System report to the .arx file format: 

   1. Select the report from the list.
   2. In the Destination field, select File.
   3. In the Format field, select .arx output format for the report.
   4. Run the report.

   For more information, see Exporting-a-custom-AR-System-report

   Warning

   To export a complete record to an ARX file on the Report Console > Reportcreator form, select each field manually. 

4. Edit the file to change the format of the Request ID field.
    See Editing the .arx file.
5. In the browser, delete all requests in the form.
6. In Data Import, choose File > New Mapping.
7. In the Source Data File field, enter the .arx file you edited.
8. In the Source Form Name, enter the form from which you created the .arx file.
9. In the Target Server and Target Form Name fields, enter the server and form to which to import the data.
    This is the same server name and form name you used to create the .arx file. (You are simply changing the Request ID field on the same form.)
10. Click Auto Map to map the fields.
11. Click the Options tab.
12. Under the Data Handling panel, select the following options:
    • Make Non-Core Required Fields Optional
    • Disable Pattern Matching
13. Under the Duplicates panel, select Reject Duplicate Records from the Handle Duplicate Request IDs By list.
14. Choose Import > Start Import.