1. In the Project Properties window click More and in the menu click CRS Mapping.

Figure: Opening CRS Template

CRS Mapping Template window is displayed.

Figure: Adding a template

2. In the window click Add.

Template Mapping window is displayed. 

Figure: Configuring the mapping template

3. Select the radio button next to a Template Type. Options available are Import, Export and Update. For mapping values to Import and Export template, procedures are the same. In the CRS Template Mapping window, if type selected is Export, in the template mapping window option to browse a template file is available. 
4. Click the browse button next to the field Template File to select a template file from the location where it is stored. Once a template file is selected, options to remove the file and view the file will be displayed. Enter mapping values and save the template.
5. Enter a template name.

Insert New Row: If the checkbox next to this option is selected, then for every row of  ‘CRS Mapping Details’ a new row is created in excel.

Next step is to select the document properties that are to be mapped and define a location for the mapped values in Excel sheet.

5. Select the checkbox next to properties that are listed under Header/Footer Mapping Details. 
6. After selecting the required properties click the arrow pointing forward. Selected properties will now be available under Selected Columns. 
7. For each property enter the location where the values should be mapped in Excel sheet.

Next step is to enter the location where values for  CRS properties should be displayed.

8. Corresponding to the CRS Properties,  enter the location where values are to be mapped in Excel template. 
9. Click Save to store values.

Created templates are displayed in the grid.

Figure: Created templates

1. In the Comments Response Sheet window click Import.

CRS Import Wizard is displayed.

Figure: CRS Import Wizard

CRS data can be imported from files stored in the disk or from files in WRENCH. In some cases user adds the CRS file received from the client as a reference document inside the main document. If user wants to import data from a document already available in the system, then user may select the option My Wrench. MS Excel files containing CRS data, attached as reference documents can be selected.

1. Select the radio button next to From disk.
2. In the drop-down list, templates that contains details for mapping CRS file data will be available. Select the template from the list.
3. Next step is to select the Excel file containing data. Click Select File.
4. File selection window is displayed. Select the excel file where CRS details are saved.
5. After selecting the file click Import.

If the data is successfully imported, Imported Successfully message is displayed. Mapped CRS details will be displayed in the grid as shown in the following figure.

Figure: Imported CRS data

1. In the CRS Import Wizard window click the radio button next to From Wrench.
2. Select a template from the drop-down list.
3. Click Select File

Document Attachments window is displayed.

Figure: Document Attachments window

4. Select the file from the window.
5. Click Import button.

If the data is successfully imported, Imported Successfully message is displayed. Mapped CRS details will be displayed in the grid.

1. In the CRS Export Wizard select the radio button next to Disk.
2. Select the template from the drop-down list.
3. Click Select File to choose the data file stored locally.

Update Existing Template: This option is applicable only if matching property is defined for update template

4. Click Export.

Data  is exported to Excel sheet.

1. In the CRS Export Wizard select the radio button next to Wrench.

2. Select the template from the drop-down list.
3. Select the button Select File.

Document Attachments window is displayed.

4. In the window select the file. 

Figure: Selecting file

5. Click Select.

Comment Resolution Sheet data is exported successfully to the selected associated document.