License Type CSV Format
You must import license types before you import any licenses which reference those license types.
For information about using CSV format files, see Best Practices for Importing Data with CSV Files.
License Type File Format
|
SDITYPE=LicenseType |
|||
|---|---|---|---|
|
Column Name |
Format |
Req? |
Description |
|
LicenseTypeName |
varchar2(100) |
Y |
The name of the license type. |
|
DefaultTerm |
number |
N |
The default term for any license not specifying an end date. |
|
TemporaryDaysValid |
number |
N |
If temporary licenses are enabled, the default term for any license not specifying a validity period. |
|
LicenseMask |
varchar2(100) |
N |
The license mask to which licenses using this license type must conform. |
|
Description |
varchar2(200) |
N |
An optional description for the license type. |
|
EndDateRequiredFlag |
varchar2(1) |
N |
Indicates whether an associated license must include an end date (Y) or does not need to include an end date (N). |
|
LicenseNumberRequiredFlag |
varchar2(1) |
N |
Indicates whether an associated license does (Y) or does not (N) need to include a license number. |
|
PhysicalLicenseRequiredFlag |
varchar2(1) |
N |
Indicates whether a physical copy of a license must be provided (Y) or does not need to be provided (N). |
|
StartDate |
mm/dd/yyyy |
Y |
The start date for the license type. |
|
EndDate |
mm/dd/yyyy |
N |
The end date for the license type. |
License Types File Example
This file includes the minimum required fields and two license types.
-
sdiType=LicenseType
-
LicenseTypeName,StartDate
-
Organic Farmer, 01/02/2012
-
Vintner, 01/02/2012
Updating an Existing License Type
You can update a license type by including data in the LicenseTypeName and StartDate columns to match a license type and then modifying additional columns as needed.
License Types File Import Prerequisites
There are no pre-requisites before importing license types with the Import/Export Wizard.
License Types File Import Options
When importing a license type file, the Import/Export Wizard prompts for Company Selection. Select the desired company.