You can export spatial data from XPAC as a fixed width file that you can use in other programs.
| 1. | Select File > Export > Spatial Data. The Select Spatial Data Set window displays. |
| 2. | Select an existing data set from the drop-down list. |
| 3. | Click OK. The Export Spatial Data window displays. |
| 4. | Select Delimited Or Fixed Width (.csv / .txt). |
| 5. | Click Next. The Select Range window displays. |
| 6. | Specify the database range that you want to use: |
| a. | Select a range from the list. |
|
If required, you can create and edit database ranges by clicking . The window displays (see Range Selection window for more information).
|
| b. | Select the Scanning level that you want to use. |
| c. | Click OK. The Select Activities to Export window displays. |
| 7. | Select each activity that you want to include. |
|
You can use the standard / and click functionality to select multiple items. Otherwise, click to select all activities in the list.
|
| 8. | Click Select. A Windows Explorer window displays. |
| 9. | Navigate to the folder in which you want to save the exported file. |
| 10. | Type a name for the file. |
| 11. | Click Save. The Polygon Export Template Setup - Step 1 window displays. |
|
If you want to use settings that you previously saved, you can load a settings template. If you use a template, you will not need to complete the remaining steps.
|
| 12. | Complete the settings for step 1: |
| a. | In the File Data Type section, select Delimited. |
| b. | Type the Comment line character that you want to use in the exported file. XPAC uses this comment character to comment out the file header information (see File header for more information). |
| c. | Specify the Number of fields per item to specify the number of attributes per line. |
| d. | Click Next. The Polygon Export Template Setup - Step 2 window displays. |
| 13. | Complete the settings for step 2: |
| a. | In the Delimiters section, select the check box of each character that you want to use to separate data in the file. |
|
If you select , you also need to specify the character that you want to use, for example, .
|
| b. | If required, select the Treat consecutive delimiters as one check box. |
| c. | Specify the Text Qualifier that you want to use to place around a text field that XPAC writes to the exported file. Either: |
| i. | Select a value from the drop-down list; or |
| ii. | Type a value in the field. |
| d. | Click Next. The Polygon Export Template Setup - Step 3 window displays. |
| 14. | Complete the settings for step 3. Either: |
| 15. | Review the data that displays in the File Preview section. |
XPAC exports the spatial data to the specified folder.
|
If any errors occur during the export process, the Event Log will display the details of the failure.
|
Manually setting up data fields
If required, instead of using the Field Setup Wizard, you can manually set up data fields.
| 1. | Specify the Number of fields per record. This controls the maximum number of rows in the data sheet. |
| 2. | For each row in the data sheet, select the Field Type. For example you can select: |
| ▪ | Ignore if you do not want to write any data into the specified field in the file. |
| ▪ | PIL Number to specify a record position in level at the database level you define in the Field Attribute field. |
| ▪ | Record Name to specify a record name that you specify in the Field Attribute field. |
| ▪ | X Co-ordinate, Y Co-ordinate or Z Co-ordinate if the field is a coordinate for a polygon point. Typically, the X represents the Easting, Y the Northing and Z the elevation. The coordinates are assigned to the record defined by the record identifiers and the specified activity. |
| ▪ | Activity Name or Activity Number to specify the productive activity. If you do not select an activity, XPAC imports it to the default activity. |
| 3. | If required, select the Field Attribute for each row in the data sheet, for example, if you selected PIL Number or Record Name. |
|
You can click at any time to clear all data in the data sheet.
|
