CSV File Formats for Importing Data

>CSV File Format for Customers

>CSV File Format for Contacts

>CSV File Format for Features

>CSV File Format for Products

>CSV File Format for Product Suites

>CSV File Format for Entitlements

>CSV File Format for Downloads

>CSV File Format for Named Users

Related Topic
Importing and Exporting Entity Data


You can use the information in this section to create a CSV file with data for entities such as customers, features, products, entitlements, or downloads. You can then import the data contained in the CSV file to create one or more instances of the relevant entity, for example, five new features or a new product. When you define the CSV file, make sure to consider and handle any dependencies. For example, you need to define a feature before you can include the feature details in a product.

Important

>When uploading data for an entity using CSV files, any header name other than those defined in the CSV is treated as a custom attribute.

>All required attribute (header) names are reserved. You cannot create a custom attribute with the same name.

>To ensure that a CSV file containing special characters is imported successfully, save the CSV file in UTF-8 format.

>The headers are case-sensitive. The values that you provide for the headers are not case-sensitive.

>Third-party enforcement data depends on your implementation and is not covered on this page.

CSV File Format for Customers

The following is a sample CSV file format for importing customer data. The first line shows the headers. The next lines show sample data.

name,customerCRMId,description,enabled,refId,customerIdentifier,externalId,timeZone
Smith Associates,3,reseller,TRUE,1,someIdentifier,321468527,UTC-5
Customer2,4,Customer2 Description,TRUE,2,CustomerIdentifier2,externalId2,UTC

The following table describes the headers in a customer CSV file. For more details on adding a customer, see Customers.

Header Description
name (Required) Customer name
customerCRMId CRM ID. Used to connect to an external CRM.
description Customer description
enabled Identifies if a customer is active.
refId Ref ID. Used to connect to an external CRM.
customerIdentifier Unique identifier for the customer.
externalId External reference identifier that identifies the customer in an external system.
timeZone Customer time zone. Used for the start date and the end date of a license.

CSV File Format for Contacts

The following is a sample CSV file format for importing contact data. The first line shows the headers. The next lines show sample data.

contactEmail,contactPassword,contactName,contactNumber,locale,refId1,refId2,loginAllowed,shipAddr,shipAddrCity,shipAddrCountry,shipAddrState,shipAddrZip,billAddr,billAddrCity,billAddrCountry,billAddrState,billAddrZip,customerName
jsmith@example.com,xxxxxxx,J. Smith,001-617-555-7979,en,2,3,TRUE,1700 Beacon St. Suite 20A,Boston,USA,MA,012345-1234,1700 Beacon St. Suite 20A,Boston,USA,012345-1234,012345-1234,Smith Associates
contact1@domain.com,xxxxxxx,Jean Jones,Contact Number,en,2,3,FALSE,Shipping Address,Shipping City,Shiping Country,Shiping State,Shiping Zip,Billing Address,Billing City,Billing Country,Billing State,Billing Zip,Customer2

The following table describes the headers in a contact CSV file. For more details on adding a contact, see Contacts.

Header Description
contactEmail (Required) Email address for the contact.
contactPassword Password for the contact.
contactName Name of the contact.
contactNumber Contact's telephone/mobile number.
locale Language for the contact.
refId1 Reference ID. Used to connect to an external CRM.
refId2 Alternate reference ID. Used to connect to an external CRM.
loginAllowed

Contact is allowed to log in to the customer portal.
shipAddr Shipping address street, P.O.Box, or similar
shipAddrCity Shipping address city
shipAddrCountry Shipping address country
shipAddrState Shipping address state
shipAddrZip Shipping address ZIP or postal code
billAddr Billing address
billAddrCity Billing address city
billAddrCountry Billing address country
billAddrState Billing address state
billAddrZip Billing address zip code
customerName Name of the customer associated with the contact.

CSV File Format for Features

The following is a sample CSV file format for importing feature data. The first line shows the headers. The next lines show sample data.

namespaceName,externalFtrId,featureId,featureIdentifier,featureName,featureVersion,description,refId1,refId2,licenseModelName,isDefaultLm
General,111,112,113,RMSFtr1,1.0.0,desc,r111,r112,Trial Standalone,FALSE
DEMOMA,221,222,223,LDKFtr1,,desc,r223,r224,,

The following table describes the headers in a feature CSV file. For more details on adding a feature and associating license models, see Features.

Header Description
namespaceName (Required) Associated namespace
externalFtrId External feature ID
featureId Feature ID is generated in database and should be excluded in the CSV input. A custom attribute of the same name cannot be created.
featureIdentifier Unique feature identifier provided by customer. This field is mandatory for lease licenses.
featureName (Required) Name of the feature.
featureVersion

Feature version.

Not relevant.
description Feature description.
refId1 Reference ID. Used to connect to an external CRM.
refId2 Alternate reference ID. Used to connect to an external CRM.
licenseModelName

(Required) Name of associated license model.

Not relevant.
isDefaultLm

Flag specifying whether or not the license model associated with the feature is marked as default.

Required only if multiple license models are associated with the feature.

Not relevant.

CSV File Format for Products

The following are sample CSV formats for importing product data. The first line shows the headers. The next lines show sample data.

The headers included in the sample CSV file depend on the enforcements available in Sentinel EMS.

If one or more enforcements are supported, excluding Sentinel LDK, the following sample is available:

If at least two enforcements are supported, including Sentinel LDK, the following sample is available:

IsLDKEnforcement,NamespaceName,ExternalPrdId,ProductId,ProductName,ProductVersion,RefId1,RefId2,Description,State,ExternalFtrId,FeatureId,FeatureName,FeatureVersion,ProductFeatureState,DefaultLicenseModel,IsLicenseModelFixed ,componentMultiplier,familyId,familyName,ActivationMethod,FixedQuantity,productType,Prd_Enf.LICENSE_VERSION,Prd_Enf.NUM_CLIENT_LOCKED,Prd_Enf.CLIENT_1_CRITERIA,Prd_Enf.CLIENT_2_CRITERIA,Prd_Enf.CLIENT_3_CRITERIA,Prd_Enf.CLIENT_4_CRITERIA,Prd_Enf.CLIENT_5_CRITERIA,Prd_Enf.CLIENT_6_CRITERIA,Prd_Enf.CLIENT_7_CRITERIA,Prd_Enf.NUM_SERVERS,Prd_Enf.PRIMARY_1_CRITERIA,Prd_Enf.PRIMARY_2_CRITERIA,Prd_Enf.PRIMARY_3_CRITERIA,Prd_Enf.PRIMARY_4_CRITERIA,Prd_Enf.PRIMARY_5_CRITERIA,Prd_Enf.PRIMARY_6_CRITERIA,Prd_Enf.PRIMARY_7_CRITERIA,Prd_Enf.PRIMARY_8_CRITERIA,Prd_Enf.SECONDARY_1_CRITERIA,Prd_Enf.SECONDARY_2_CRITERIA,Prd_Enf.SECONDARY_3_CRITERIA,Prd_Enf.SECONDARY_4_CRITERIA,Prd_Enf.SECONDARY_5_CRITERIA,Prd_Enf.SECONDARY_6_CRITERIA,Prd_Enf.SECONDARY_7_CRITERIA,Prd_Enf.SECONDARY_8_CRITERIA,Prd_Enf.PRIMARY_9_CRITERIA,Prd_Enf.PRIMARY_10_CRITERIA,Prd_Enf.PRIMARY_11_CRITERIA,Prd_Enf.SECONDARY_9_CRITERIA,Prd_Enf.SECONDARY_10_CRITERIA,Prd_Enf.SECONDARY_11_CRITERIA,Prd_Enf.ALLOW_VM_DETECTION,Prd_Enf.NUM_USERNODE,Prd_Enf.USERNODE_1_CRITERIA,Prd_Enf.USERNODE_2_CRITERIA,Prd_Enf.USERNODE_3_CRITERIA,Prd_Enf.USERNODE_4_CRITERIA,Prd_Enf.USERNODE_5_CRITERIA,Prd_Enf.USERNODE_6_CRITERIA,Prd_Enf.USERNODE_7_CRITERIA,Prd_Enf.DURATION,Prd_Enf.USAGE_SYNC_FREQUENCY,Prd_Enf.RENEW_FREQUENCY,Prd_Enf.NAMED_USER_LICENSE,Prd_Enf.NO_OF_NAMEDUSERS,Prd_Enf.IS_REDUNDANT,Prd_Enf.REDUNDANCY_MAJORITY_RULE,Prd_Enf.REDUNDANT_SERVERS,Prd_Enf.FINGERPRINT_REGISTRATION,ProductIdentifier,LDK.lockingType,LDK.rehostState,LDK.upgradeToDriverless,LDK.vclock,LDK.isNotLockedToDevice,LDKMemory.fileName,LDKMemory.text,LDKMemory.fileId,LDKMemory.applyMemory,LDKMemory.allowTextOverwrite
FALSE,General,ExternalPrdId1,,RMSPrd1,1.0.0,RefId11,RefId21,Description1,Draft,,,TestFeatureRMS,1,,Trial Standalone Node Locked,,,,Default,,1,Default,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,1,,,,,,,,,,
TRUE,DEMOMA,ExternalPrdId2,,LDKPrd1,,RefId11,RefId21,Description1,Draft,,,TestFeature,,,Perpetual,,,,Default,,1,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,2,HL_or_SL_AdminMode_or_SL_UserMode,DISABLE,FALSE,FALSE,FALSE,TestMemory,44656661756c74,1,ADD,TRUE
FALSE,General,ExternalPrdId3,,FitPrd1,1,RefId11,RefId21,Description1,Draft,,,FitFtr1,,,Expiry Date,,,,Default,,1,Default,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,3,,,,,,,,,,

The following table describes some of the headers in a product CSV file. For more details on adding a product and associating features, license models, and memory files, see Products.

Header Description
IsLDKEnforcement

(Displayed only if Sentinel LDK is supported.)

Specifies whether the product is defined for Sentinel LDK.

TRUE if the product is defined for Sentinel LDK.

FALSE if the product is defined for Sentinel RMS, Sentinel Fit, Services, and so on.
NamespaceName (Required) Associated namespace.
ExternalPrdId External product ID used for integration with external systems.
ProductId

For internal use. Leave this blank.

Not relevant.
ProductName (Required) The name of the product.
ProductVersion

(Required) Version number

NOTE   For importing versionless products, set the ProductVersion field to "NA". Leaving the field blank will generate an error.

Not relevant.
RefId1 Reference ID. Used to connect to an external CRM.
RefId2 Alternate reference ID. Used to connect to an external CRM.
Description Product description.
State

(Required) Status of the product.

Possible values:

>Complete

>Draft
ExternalFtrId

External feature ID used for integration with external systems.
FeatureId Associated feature ID.
FeatureName Feature name.
FeatureVersion

Feature version.

Not relevant.
ProductFeatureState

Defines behavior of feature in a product when the product is added in an entitlement.

Possible values:

>DefaultOff (same as Excluded (Optional) in Sentinel EMS)

>DefaultOn (same as Included (Optional) in Sentinel EMS)

>Mandatory (same as Mandatory in Sentinel EMS)
DefaultLicenseModel

Name and behavior of the default license model associated with the feature.

Possible values:

>SAOT (also known as "Define in Entitlement"). Enables the required license model to be associated with a feature later while creating an entitlement.

>Any other supported license model.

If a single license model is associated with the feature, specify that license model. Otherwise, if multiple license models are associated with the feature, specify the default license model.

Specify the license model to be associated with the feature.
IsLicenseModelFixed

Specifies whether the order taker can change a feature's license model when creating an entitlement. Relevant only if multiple license models are associated with a feature.

Possible values:

>TRUE. The license model is fixed and cannot be changed.

>FALSE. The license model can be changed.
componentMultiplier Multiplying factor at product feature relationship level.
familyId Product family ID
familyName Product family name
ActivationMethod The activation method (Fixed, Partial, or Full, or Unlimited).
FixedQuantity For Fixed activation method: the quantity that must be consumed for each activation.
productType

(Required) The type of product.

Possible values:

>DEFAULT (same as Default in Sentinel EMS)

>PARENT (same as Versionless in Sentinel EMS)

>CHILD (same as Variant in Sentinel EMS)
Prd_Enf.<license model attribute>

Value for the specified license model attribute. The sample contains many header examples, such as Prd_Enf.LICENSE_VERSION. You can use the Get License Model endpoint to retrieve the header names. Make sure to add the prefix Prd_Enf. to anything that you add.
LDK.lockingType

The locking type for the product. The locking type determines the level of protection for the product according to the type of Sentinel protection key distributed with the product.

> HL: Sentinel HL keys only.

>SL_UserMode: Sentinel SL UserMode keys only.

>SL_AdminMode: Sentinel SL AdminMode keys only.

>HL_or_SL_AdminMode: Either Sentinel HL keys or Sentinel SL AdminMode keys.

>HL_or_SL_AdminMode_or_SL_UserMode: Sentinel HL keys, Sentinel SL AdminMode keys, or Sentinel SL UserMode keys. Default: HL_or_SL_AdminMode_or_SL_UserMode
LDK.rehostState

Whether to enable or disable the rehosting of an SL key.

Possible values:

>ENABLE: Enables rehosting of an SL key for the product.

> DISABLE: Disables rehosting of an SL key for the product.

>LEAVE_AS_IS: Uses the existing rehosting value in the SL key.

Default: LEAVE_AS_IS
LDK.upgradeToDriverless

Whether to upgrade from Sentinel HL keys to Sentinel HL (Driverless configuration) keys.

Default: false
LDK.vclock

Whether to manage time-based licenses for Sentinel HL (Driverless Configuration) keys using a virtual clock when no real-time clock is available.

Default: false
LDK.isNotLockedToDevice

Whether the license is locked to a device.

Default: false
LDKMemory.fileName Unique name of the memory file (up to 50 alphanumeric characters).
LDKMemory.text Contents of the memory file in hexadecimal format.
LDKMemory.fileId File ID of the memory file (range: 1-65471).
LDKMemory.applyMemory

Action to be performed on the memory file.

Possible values:

>ADD: Adds the new data to the memory file. Existing information remains unchanged.

>OVERWRITE: Overwrites the existing information in the memory file by the new data.

>DELETE: Permanently deletes the memory file associated with a license.

Default: ADD
LDKMemory.allowTextOverwrite

Whether the value can be changed when creating an entitlement.

Possible values: True/False

CSV File Format for Product Suites

The following is a sample CSV file format for importing product suite data. The first line shows the headers. The next lines show sample data.

namespaceName,suiteName,suiteVersion,refId1,refId2,description,activationMethod,fixedQuantity,productId,externalId,productName,productVersion,state
myNamespace,mySuite,0.1,ref1,ref2,desc,SAOT,2,,,myProduct,0.1,Complete

The following table describes the headers in a product CSV file. For more details on adding a product suite, see Product Suites.

Header Description
namespaceName (Required) Associated namespace
suiteName (Required) Product suite name
suiteVersion (Required) Version number
refId1 Reference ID. Used to connect to an external CRM.
refId2 Alternate reference ID. Used to connect to an external CRM.
description Product suite description
activationMethod

Method used for activating the product suite in an entitlement.
fixedQuantity Value of fixed quantity if activation method is specified as Fixed.
productId ID of associated product
externalId External ID of associated product
productName Name of associated product
productVersion Version of associated product
state

Status of a product suite - draft, complete, or end of life.

CSV File Format for Entitlements

NOTE   Data import is not supported for cloud-served lease and cloud-served connected entitlements.

The following is a sample CSV file format for importing entitlement data. The first line shows the headers. The next lines show sample data.

For Sentinel RMS, Sentinel Fit, and Services:

For Sentinel LDK:

entId,eId,externalId,startDate,endDate,customer,custIdentifier,ccEmail,contact,channelPartner,userRegistration,refId1,refId2,ccEmail,activationAllowed,allowActivationBy,lifeCycleStage,sendNotification,comments,productKey,PK_StartDate,PK_EndDate,totalQuantity,availableQuantity,activationMethod,fixedQuantity,LDK.rehostState,LDKMemory.fileName,LDKMemory.text,LDKMemory.fileId,enforcementName,enforcementVersion,externalPrdId,productName,productVersion,featureId,featureName,licenseModelIdentifier,EntitlementAsWhole,LIC_TYPE,EXECUTIONS,EXPIRATION_DATE,ENABLE_CONCURRENCY,CONCURRENT_INSTANCES,COUNT_EACH,ALLOW_DETACHING,REMOTE_DESKTOP,NETWORK,VIRTUAL_MACHINE,APPLY_LICENSE,NUMBER_OF_DAYS
,eId1,,,,,,,,,,,,,TRUE,ALL_USERS,DRAFT,,,,,,10,10,FIXED,1,ENABLE,Default (Read-Only),656e7469746c656d656e742076616c7565,65525,Sentinel LDK,8.2,,LDKTest,1,,LDKTest,Perpetual,FALSE,,,,TRUE,10,,,TRUE,TRUE,FALSE,1,
,eId2,,,,,,,,,,,,,TRUE,VENDOR_ONLY,DRAFT,,,,,,100,100,FIXED,1,,,,,Sentinel LDK,8.2,,LDKSample,1,,LDKSample,,TRUE,,,,,,,,,,,,

The following table describes some of the headers in an entitlement CSV file. For more details on adding an entitlement, see Creating Entitlements.

Header Description
entId Entitlement ID to identify entitlement in database uniquely.
eId Entitlement ID to identify entitlement on user interface.
externalId User entry to uniquely identify entitlement.
dummyEid This field identifies all records of an entitlement in CSV data load. The dummy EID is not saved in database. It is only used for identification during entitlement load file processing.
revision Entitlement revision number. Only for output.
startDate Entitlement start date. The format is YYYY-MM-DD. If left blank, the current date is inserted.
endDate Entitlement end date. The format is YYYY-MM-DD. If left blank, the date "2500-12-31" is inserted.
customer Customer name
custIdentifier User-defined or auto-generated unique identifier of the customer.
ccEmail Email addresses to receive entitlement certificate (up to 15 email addresses).
contact Email address of contact
channelPartner Channel partner name
userRegistration Type of registration required for entitlement. Possible values None, Optional, and Mandatory. If blank, the value is derived from user registration configuration in Administration Console.
refId1 Reference ID 1
refId2 Reference ID 2
ccEmail

Email addresses to receive entitlement certificate (up to 15 email addresses).
activationAllowed

Entitlement license activation allowed (entitlement enabled).

Possible values (case-insensitive):

>TRUE

>FALSE

Default if another value or no value is provided: TRUE
allowActivationBy <5.5Preview>

The type of user that can activate the entitlement.

Possible values:

>ALL_USERS

>VENDOR_ONLY

Default if another value or no value is provided: ALL_USERS
revocationAllowed Entitlement license revocation allowed. The possible values are TRUE and FALSE. If another value is provided or no value is provided then default value is TRUE.
lifeCycleStage

The state of the entitlement.

Possible values (case-insensitive):

>DRAFT

>COMPLETE

Default if another value or no value is provided: DRAFT
sendNotification Whether notification must be sent for entitlements marked as "complete". Possible values are TRUE or FALSE. If another value is provided or no value is provided, its value will be derived from Administration Console configuration.
productKey The product key ID to be displayed.
PK_StartDate Product key start date (line item start date). The format is YYYY-MM-DD. If left blank, the value will be same as startDate.
PK_EndDate Product key end date (line item end date). The format is YYYY-MM-DD. If left blank, the value will be same as endDate.
totalQuantity The total quantity available for activation. If left blank, the value is automatically set to 1.
availableQuantity The remaining quantity for entitlement item activation. For draft stage entitlement irrespective of input it is equal to total quantity. Its significance will be only for activated entitlements.
activationMethod

The method of defining and allocating the quantity of licenses available for the product in the entitlement.

Possible values:

>FIXED

>PARTIAL

>FULL

> UNLIMITED
fixedQuantity The fixed number of licenses to consume in each activation.
LDK.rehostState

Whether the end user is allowed to transfer any type of Sentinel SL protection key from one computer to another.

Possible values:

>ENABLE

>DISABLE

>LEAVE_AS_IS
LDKMemory.fileName Name of the memory file.
LDKMemory.text The memory data in text format.
LDKMemory.fileId Integer that identifies the memory file and is used by your application to refer to that file.
enforcementName

The enforcement name for the entitlement item being created.

If you enter a value here, you must also enter a value for enforcementVersion.

If multiple enforcements exist in the system, you must provide the enforcementName and enforcementVersion for each enforcement.
enforcementVersion

The enforcement version for the entitlement item being created. Specify the enforcement version used in Sentinel EMS. Entering any other enforcement version will prevent the entitlement from being generated correctly. You can use the GET call (Get Application Property endpoint) to get the enforcement version.

If you enter a value here, you must also enter a value for enforcementName.

If multiple enforcements exist in the system, you must provide the enforcementName and enforcementVersion for each enforcement.
licenseType License type. Input is string.Possible values are STANDALONE, NETWORK and MIXED. But at present this value is being ignored.

Not in use.

suiteName Name of product suite* for entitlement item.
suiteVersion Version of product suite* for entitlement item.
externalPrdId External ID of product to identify a product for entitlement item.
productName Product name to identify a product for entitlement item. If this is provided then product version must not be blank.
productVersion Product version identify a product version for entitlement item. If this is provided then product name must not be blank, else error is thrown and entitlement is not saved.
featureId Feature ID of feature to identify a feature for entitlement item product.
featureName Feature name of feature to identify a feature for entitlement item product
EntitlementAsWhole

Whether to perform activations/revocations on all associated products (also referred to as product keys) together. For line items with unlocked products, must be set to true.

Default: false
CA_ENT.attr1

Custom attributes input for date type of custom attribute will be in YYYY-MM-DD format. Custom attribute header names are case-sensitive, however the prefix (CA_ENT.) is not case-sensitive.

NOTE   All custom attributes in the CSV file are preceded by the prefix CA.
Various license model attributes

Specify only the relevant license model values for the entitlement.

CAPACITY,CAPACITY_FLAG, COLLECT_USAGE,DURATION,FINGERPRINT_REGISTRATION, IS_SL_LEASE,RENEW_FREQUENCY,USAGE_SYNC_FREQUENCY,END_DATE, GRACE_TIME, LICENSE_DURATION_IN_DAYS,LICENSE_GENERATION_TIME,START_DATE, START_LICENSE_FROM_ACTIVATION_DATE, CONCURRENCY_CRITERIA,CONCURRENCY_LIMIT, FLOATING_SOFT_USER_LIMIT,FLOATING_USER_LIMIT,GRACE_LIMIT,GRACE_TIME_DURATION, KEY_LIFETIME_MINUTES,TRIAL_DURATION_DAYS,TRIAL_DURATION_HOURS,USAGE_LIMIT, CLIENT_1_CRITERIA,CLIENT_1_INFO, CLIENT_2_CRITERIA,CLIENT_2_INFO,CLIENT_3_CRITERIA, CLIENT_3_INFO,CLIENT_4_CRITERIA,CLIENT_4_INFO,CLIENT_5_CRITERIA, CLIENT_5_INFO, CLIENT_6_CRITERIA,CLIENT_6_INFO,CLIENT_7_CRITERIA,CLIENT_7_INFO,CODE_TYPE, CRITERIA, LOCAL_REQUEST_LOCKCRIT_FLAG,LOCAL_REQUEST_LOCKCRIT_FLOAT, LOCAL_REQUEST_LOCKCRIT_MIN_NUM, LOCAL_REQUEST_LOCKCRIT_REQUIRED,LOCKING_MODE,NUM_CLIENT_LOCKED, NUM_SERVERS,NUM_SUBNET,NUM_USERNODE, PRIMARY_10_CRITERIA,PRIMARY_10_INFO, PRIMARY_11_CRITERIA,PRIMARY_11_INFO,PRIMARY_1_CRITERIA,PRIMARY_1_INFO, PRIMARY_2_CRITERIA,PRIMARY_2_INFO,PRIMARY_3_CRITERIA,PRIMARY_3_INFO, PRIMARY_4_CRITERIA,PRIMARY_4_INFO, PRIMARY_5_CRITERIA,PRIMARY_5_INFO, PRIMARY_6_CRITERIA,PRIMARY_6_INFO,PRIMARY_7_CRITERIA,PRIMARY_7_INFO, PRIMARY_8_CRITERIA,PRIMARY_8_INFO,PRIMARY_9_CRITERIA,PRIMARY_9_INFO, REDUNDANT_SERVERS,SECONDARY_10_CRITERIA, SECONDARY_10_INFO, SECONDARY_11_CRITERIA,SECONDARY_11_INFO,SECONDARY_1_CRITERIA,SECONDARY_1_INFO, SECONDARY_2_CRITERIA,SECONDARY_2_INFO,SECONDARY_3_CRITERIA,SECONDARY_3_INFO, SECONDARY_4_CRITERIA,SECONDARY_4_INFO, SECONDARY_5_CRITERIA,SECONDARY_5_INFO, SECONDARY_6_CRITERIA,SECONDARY_6_INFO,SECONDARY_7_CRITERIA,SECONDARY_7_INFO, SECONDARY_8_CRITERIA,SECONDARY_8_INFO,SECONDARY_9_CRITERIA,SECONDARY_9_INFO, SITE_LIC_1_INFO,SITE_LIC_2_INFO, SITE_LIC_3_INFO,SITE_LIC_4_INFO,SITE_LIC_5_INFO, SITE_LIC_6_INFO,SITE_LIC_7_INFO,USERNODE_1_CRITERIA,USERNODE_1_INFO, USERNODE_2_CRITERIA,USERNODE_2_INFO,USERNODE_3_CRITERIA,USERNODE_3_INFO, USERNODE_4_CRITERIA,USERNODE_4_INFO, USERNODE_5_CRITERIA,USERNODE_5_INFO, USERNODE_6_CRITERIA,USERNODE_6_INFO,USERNODE_7_CRITERIA,USERNODE_7_INFO, ALLOW_COMMUTER,ALLOW_GRACE,COMMUTER_MAX_CHECKOUT_DAYS,GRACE_PERIOD_DAYS, GRACE_PERIOD_ELAPSED_HOURS,HOLDING_CRITERIA, IS_NETWORK,KEY_HOLDTIME_MINUTES,SHARING_CRITERIA,SHARING_LIMIT,DEPLOYMENT_TYPE,LICENSE_TYPE, NAMED_USER_LICENSE, NO_OF_NAMEDUSERS,USAGE_TYPE,ALLOW_REDUNDANCY, ALLOW_VM_DETECTION,ELAN_KEY_FLAG,ENFORCE_CLOCK_TAMPERED, ENFORCE_LICENSE_EXCLUSIVE, ENFORCE_REDUNDANCY_MAJORITY,IS_REDUNDANT,IS_TRIAL,KEY_TYPE, LICENSE_VERSION, LOG_ENCRYPT_LEVEL,NUMERIC_TYPE,OUTPUT_TYPE, REDUNDANCY_MAJORITY_RULE,USE_AUTH_CODE,LICENSE_VENDOR_INFO, VENDOR_COMMENTS,VENDOR_INFO, VENDOR_NUM_OF_SECRETS,VENDOR_PRIVATE_INFO,VENDOR_PUBLIC_INFO, VENDOR_SECRETS_1, VENDOR_SECRETS_2,VENDOR_SECRETS_3,VENDOR_SECRETS_4, VENDOR_SECRETS_5,VENDOR_SECRETS_6,VENDOR_SECRETS_7, ENF_ENT.DURATION, ENF_ENT.FINGERPRINT_REGISTRATION,ENF_ENT.RENEW_FREQUENCY,ENF_ENT.USAGE_SYNC_FREQUENCY, ENF_ENT.REDUNDANT_SERVERS,ENF_ENT.IS_REDUNDANT, ENF_ENT.REDUNDANCY_MAJORITY_RULE,,,,USER_LIMIT,EXPIRY_DATE

LIC_TYPE,EXECUTIONS,EXPIRATION_DATE, ENABLE_CONCURRENCY, CONCURRENT_INSTANCES,COUNT_EACH, ALLOW_DETACHING, REMOTE_DESKTOP,NETWORK, VIRTUAL_MACHINE,APPLY_LICENSE,NUMBER_OF_DAYS

CSV File Format for Downloads

The following is a sample CSV file format for importing download data. The first line shows the headers. The next lines show sample data.

Action,name,version,releasedDate,description,isEnable,eol,isAttachable,fileName,fileSize,logobinary,downloadLocation,Productid,ProductIdentifier,ProductExtenalId,ProductName,ProductVersion,ProductAssociationState,AssociateDownloadId,AssocaiteDownloadName,AssocaiteDownloadVersion,CustomerId,CustomerName,CustIdentifier,CustExternalId,ISLEGACY
CREATE,D501,1.2,2014-08-08,Test,TRUE,FALSE,TRUE,P1_Logo.jpg,115kb,22sd23232090hfgfgfgfgfgfggrfgfgfgfg,http://localhost:8080/P1.Logo,1,,,,,Active,1,,,1,,,,1
CREATE,D501,1.2,8/8/2014,Test,TRUE,FALSE,TRUE,P1_Logo.jpg,115kb,22sd23232090hfgfgfgfgfgfggrfgfgfgfg,http://localhost:8080/P1.Logo,1,,,,,Active,1,,,1,,,,1

The following table describes the headers in a download CSV file. For more details on adding a download file, see Downloads.

Header Description
Action Operation performed during data-load through CSV, such as, CREATE, UPDATE, ATTACH, DETACH.
name Download name.
version Download version.
releasedDate

Date from which the content will be available for download.
description Download description.
isEnable

Download status, where true creates an enabled download and false creates a disabled download that cannot be downloaded.

Valid values: TRUE, FALSE
eol Marks download as End of Life. This value is always specified as FALSE as downloads cannot be created in EOL state.
isAttachable

Specifies whether to attach the download link to entitlement and license certificate emails..

Valid values: TRUE, FALSE
fileName Name of the attached download file.
fileSize Size of the attached download file .
logobinary Binary input of the logo.
downloadLocation URL for downloading a product.
Productid

Product ID to link download.
ProductIdentifier

For internal use. Leave blank.
ProductExtenalId External ID of product link to download.
ProductName Name of product linked to download.
ProductVersion Version of product linked to download.
ProductAssociationState

State of product association.

Valid values: Active, Inactive

Default value: Active
AssociateDownloadId Associated download ID for the main download.
AssocaiteDownloadName Associated download name for the main download.
AssocaiteDownloadVersion Associated download version for the main download.
CustomerId Customer ID.
CustomerName Name of the customer.
CustIdentifier Unique identifier for the customer.
CustExternalId External reference identifier that identifies the customer in an external system.
ISLEGACY Record exists from a version of Sentinel EMS earlier than 5.3.

CSV File Format for Named Users

The following is a sample CSV file format for importing named users:

Named Users
User_1
User_2
User_3
User_4
User_5