Import Export Data Migration Tools

Supported Operations

Import/Export provides IMPORT, EXPORT and DELETE operations for supported portal entities.

Import

Adds the entities defined in the specified XML file(s) to the portal database. If the specified entities are already present – determined by Id, Name, or other primary key, as appropriate – this operation will update the existing entity to match the information provided in the XML.

Usage

  >ant crn-import -Ddir={path-to-directory} [-Dpattern={regex}]

Where path-to-directory is a file system directory, absolute or relative, containing uPortal Import/Export XML files; and regex is an (optional) Java Regular Expression specifying a file name pattern that candidate files must match or be ignored by the importer.

The -Dpattern Argument

Regex special characters overlap heavily with OS/Shell special characters. It's often better to avoid the -Dpattern argument altogether. You can always place desired files into a new directory for import.

Export

Creates XML files representing the requested entities and writes them to the specified file system location.

Usage

  >ant crn-export [-Ddir={path-to-directory}] -Dtype={entity-type} [-Dsysid={entity-identifier}]

Where path-to-directory is a file system directory, absolute or relative, wherein XML will be written; and entity-type is any supported entity type (see table below); and entity-identifier is the Id or Name of a single entity of the specified type. The -Dsysid argument is not required for entity types that begin with "all-."

Named Sub-directories

On export, XML documents will be organized into sub-directories by entity type: e.g. channel, layout, user, etc.

Table of Entity Types

entity-type	sysid	export	notes
all		All portal entities
all-layouts		All user layouts	Normal users generate `.layout` files on export; fragment owners generate `.fragment-layout`
all-permissions		All permissions	A `permission` entity is one owner, target, activity, type, and principal
all-permission_sets		All permission_sets	A `permission_set` entity is one owner, target, activity, and type, but zero or more principals
all-memberships		All local (RDBMS) memberships
all-channels		All channels
all-channel-types		All channel types
all-groups		All local (RDBMS) groups
all-group_memberships		All local (RDBMS) group_memberships
all-users		All users
all-themes		All themes
all-structures		All structures
all-entity-types		All entity types	"Entity types" here refers to the `UP_ENTITY_TYPES` table; these are not the same as Import/Export entity types
all-fragment-definitions		All fragment definitions	Requires the `RDBMConfigurationLoader`
layout	`username`
channel	`fname`
channel-type	`name`
group	`name`
group_membership	`name`
user	`username`
theme	`name`
structure	`name`
entity-type	`name`
fragment-definition	`name`

=not specified or not supported