Exporting spatial data as a fixed width file

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 Ranges. The Range Selection 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 Shift/Ctrl and click functionality to select multiple items. Otherwise, click Select All 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 Fixed Width.

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.	Click Next. The Polygon Export Template Setup - Step 2 window displays.

13.	Complete the settings for step 2: (see Field Setup data sheet for more information). For example, you can:

a.	Click Insert to insert a column, then set the properties in the Field Properties window.

b.	Click Delete to remove the selected column.

c.	Click Properties to change the properties of a field from the Field Properties window.

d.	Click Clear All to clear the definitions of all fields.

e.	If required, change the value that displays in the View and Edit Line <X> of 1 lines text box.

14.	Review the data that displays in the File Preview section.

15.	Click Finish.

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.

Field Setup data sheet

The Field Setup section displays each field that XPAC will write data to. For example:

•	Line: 1 defines the source of the data in XPAC.

•	Example displays a preview of the data according to the Start and Finish values.

•	Start specifies the number in which to begin writing data to.

•	Finish specifies the number to stop writing data.

You can change the source, start and finish values by clicking Properties, then changing the values in the Field Properties window.

Field Properties window

1.	Set the Field Positioning:

a.	Specify the Start Column.

b.	Specify the Field Width.

As you adjust these numbers, the highlighted field in the Current Line of File section moves accordingly.

2.	Set the Field Details to determine the source for the data:

a.	Set 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 Attribute field.

•	Record Name to specify a record name that you specify in the 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 exports it to the default activity.

b.	If required, set the Attribute, for example, if you selected PIL Number or Record Name.

3.	Set the Multiplier. Select either:

a.	None to multiply the number in the field by a factor of 1.0

b.	% (*0.01) to convert the number in the field from a percentage to a fraction; or

c.	Other to multiply the number in the field by a factor, then specify the value in the field that displays.

4.	Specify the Constant to add a constant to the number in the field.

Click OK.

The Polygon Import Template Setup - Step 2 window redisplays (click here to return to exporting spatial data as a fixed width file).