Generate Geopackage mapping file...

<< Click to Display Table of Contents >>

dpPower > Menu reference > File > Import > Geopackage >

Generate Geopackage mapping file...

Importing a Geopackage file and setting up its mapping file is a complex process consisting of several steps. The user performing the import needs to have a good knowledge of the file format and is expected to understand how object types, subtypes and component types are applied in the application.

There are no requirements of a specific administrative role to import a Geopackage file. It is possible to view details about changed objects in the application before posting changes to the database. Select File > Show changes  > changed objects, or File > Post > Show > changed objects.

Settings that are made in the window for generating mapping files are applicable during the entire session provided that no changes are made during the session.

 

1.Select File > Import > Geopackage > Generate Geopackage mapping file....

2.Select the Geopackage file for which the mapping file will be applied on.

3.Select settings for the mapping file, this is optional:

a.Table settings.

b.Symbol Preferences.

c.Text Preferences.

4. Select Open.

5. Select where to save the draft for the mapping file.

6. Select character set for mapping file.

7. Select Save.

8. Select OK.

9. Open the mapping file in a text editor and complete it by mapping the objects in the file against suitable objects in the application.

 

Settings

Look In

Catalog where the file is located.

File Name

Name of the selected file.

Files of Type

Filters files of the selected file format from the current directory.

Table settings

Select table

Specifies which table to handle.

Grouping field

Specifies which data to handle, that is from which column in the table the data is processed. The grouping fields can differ between different tables.

Load table

 

Symbol Preferences

Rotation

Sets the angle at which the symbol is to be placed on the map.

Text Preferences

Text

Specifies the column in the table from which the text is retrieved.

Justification

Sets the insertion point of the text. That is, how the text will grow when edited.

Rotation

Sets the angle at which the text is to be placed on the map. Most common is horizontal.

Height

Sets the height of the text.

Open

Opens a new window for selection of the file name of the mapping file and where to save it.

Cancel

Cancels the session and closes the window.

 

More information

When importing Geopackage files, it is possible to map attributes to a constant. Also add support for some specific constants: $FILENAME$, $FILEPATH$, $FILE_PARENT_DIR$ and $FILE_ROOT_DIR$, to be used to store information from where the object is imported from.

 

$FILENAME$ - name of the import file

$FILEPATH - path + name of the import file

$FILE_PARENT_DIR$ - the parent directory of the import file

$FILE_ROOT_DIR$ - the root directory of the import file

 

The generated mapping file will include the text <NULL_OR_EMPTY> as a grouping field value if your data source file has null or empty values in this column. The Geopackage mapping file generator offers three configuration options for controlling null/empty string matching:

mapping_for_null

mapping_for_empty_string

mapping_for_null_or_empty

 

It is currently set to the third one, mapping_for_null_or_empty, meaning

that a section that matches null or empty string will be generated.

If you want two separate sections, then

 

mapping_for_null=true

mapping_for_empty_string=true

 

should be set.

 

 

If the Geopackage file does not have rotations according to the standard (integers), you should add the following lines:

angle_unit=FACTOR_OF_DEGREE

angle_unit.offset=0.0

angle_unit.conversion_factor=0.1

In the Geopackage mapping file.