CSV File Formats for Importing and Exporting Data
NOTE "Contacts" in the CSV files refer to the Users entity.
>CSV File Format for Customers >CSV File Format for Users (also known as Contacts) |
Related Topic
|
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, such as 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.
You can also use the data and examples in this section to understand what you might receive when you export data in CSV format. The examples are from the sample CSV files that you can download from Sentinel EMS. For instructions on how to download the sample CSV files, see Importing and Exporting Entity Data.
Important
>Header names are case-sensitive. The data values that you provide for the headers are not case-sensitive.
>Any header name other than those defined in the CSV is treated as a custom attribute. The custom attributes must exist in Sentinel EMS before you import the data. For details on creating custom attributes, see Custom Attributes.
>Custom attributes for some entities require a prefix. To ensure that the header name is processed correctly, make sure to append the relevant prefix, as defined in Using Custom Attributes
> When importing the data contained in the CSV file, ensure that the maximum number of records does not exceed 5000.
>To ensure that a CSV file containing special characters is imported successfully, save the CSV file in UTF-8 format.
>Third-party enforcement data depends on your implementation and is not covered on this page.
Using Custom Attributes
If you use custom attributes, you can add them to a CSV file before you import the data.
To add custom attributes to a CSV file:
1.Create the custom attributes in Sentinel EMS. For details, see Custom Attributes
2.In the relevant CSV file for the entitles listed in the table below, enter the custom attribute name exactly as defined in the Custom Attributes page. For example, if you use a custom attribute for customers named "Alternate Name", enter the header value as Alternate Name.
Some custom attributes require a prefix as shown in the table below. The prefix is not case-sensitive, but the custom attribute header name is case-sensitive. Make sure to enter the name exactly as defined in the Custom Attributes page. For example, if you use a custom attribute for downloads named "Alternate Download", enter the header value as CA_DWNLD.Alternate Download. Any entity that is not listed in the table does not require a prefix.
Entity | Prefix (not case-sensitive) | Notes |
---|---|---|
Download | CA_DWNLD. | |
Entitlement |
CA_ENT. |
Date-type custom attribute values use the YYYY-MM-DD format. |
Entitlement > Product Key |
CA_ENT_LI. |
CSV File Format for Customers
The following sample displays the 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. For details on adding a custom attribute, see Using Custom Attributes.
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 Users (also known as Contacts)
The following sample displays the CSV file format for importing end user data. The first line shows the headers. The next lines show sample data.
contactEmail,contactPassword,contactName,contactUserId,contactExternalId,contactNumber,locale,refId1,refId2,loginAllowed,shipAddr,shipAddrCity,shipAddrState,shipAddrCountry,shipAddrZip,billAddr,billAddrCity,billAddrState,billAddrCountry,billAddrZip,customerName,identityProviderName jsmith@example.com,xxxxxxx,J. Smith,601a00,369f,(213) 555-1234,en,2,3,TRUE,148 Humberto Street,Los Angeles,CA,United States,12345,148 Humberto Street,Los Angeles,CA,United States,12345,Trace Purdy,SentinelIDP jjones@example.com,xxxxxxx,Jean Jones,80bn88,908g,(518) 555-1234,en,2,3,TRUE,444 Lark Street,Albany,NY,United States,12222,444 Lark Street,Albany,NY,United States,12222,Clark Kent,SentinelIDP
The following table describes the headers in a users CSV file. For more details on adding a user, see Users. For details on adding a custom attribute, see Using Custom Attributes.
Header | Description |
---|---|
contactEmail | (Required) Email address for the user. |
contactPassword | Password for the user. |
contactName | Name of the user. |
contactNumber | User's telephone or mobile number. |
contactUserId | Unique identifier of the user. |
contactExternalId |
External reference identifier that uniquely identifies the user in an external system. Required only if you specify an identity provider other than "SentinelIDP". |
locale | Language for the user. |
refId1 | Reference identifier that identifies the user in an external system. Used to connect to an external CRM. |
refId2 | Reference identifier that identifies the user in an external system. Used to connect to an external CRM. |
loginAllowed |
Specified whether the user is allowed to log on to the Sentinel EMS customer portal. |
shipAddr | Street address or post office box details for shipping. |
shipAddrCity | City for the shipping address. |
shipAddrState | State, province, county, territory, or other any other regional information required for the shipping address. |
shipAddrCountry | Country for the shipping address. |
shipAddrZip | ZIP or postal code for the shipping address. |
billAddr | Street address or post office box details for billing statements (for example credit card statements). |
billAddrCity | City for the billing address. |
billAddrState | State, province, county, territory, or other any other regional information required for the billing address. |
billAddrCountry | Country for the billing address. |
billAddrZip | ZIP or postal code for the billing address. |
customerName | Name of the customer associated with the user. |
identityProviderName |
Name of the identity provider that manages user identities and authentication processes when accessing the vendor’s application or service. If you do not specify a value, Sentinel EMS automatically assigns SentinelIDP to the user. SentinelIDP is the default identity provider for Sentinel EMS. If you are using your own identity provider and specify a value other than SentinelIDP, you must also provide a value for contactExternalId. Possible values: >SentinelIDP >Your identity provider |
CSV File Format for Features
The following sample displays the CSV file format for importing feature data. The sample also shows what might be generated when exporting a CSV file from the Features page. The first line shows the headers. The next lines show sample data.
namespaceName,externalFtrId,featureIdentifier,featureName,description,refId1,refId2 DEMOMA,137d,,Edit_File,Permanently saves the unsaved changes in a file,102,202
The following table describes the headers in a feature CSV file. For more details on adding a feature, see Features. For details on adding a custom attribute, see Using Custom Attributes.
Header | Description |
---|---|
namespaceName | (Required) Associated namespace. |
externalFtrId | External feature ID used for integration with external systems. |
featureIdentifier |
Unique feature identifier provided by customer. |
featureName | (Required) Name of the feature. |
description | Feature description. |
refId1 | Reference ID. Used to connect to an external CRM. |
refId2 | Alternate reference ID. Used to connect to an external CRM. |
CSV File Format for Products
The following
IsLDKEnforcement,NamespaceName,ExternalPrdId,ProductName,ProductVersion,RefId1,RefId2,Description,State,ExternalFtrId,FeatureName,FeatureVersion,ProductFeatureState,DefaultLicenseModel,IsLicenseModelFixed ,componentMultiplier,familyName,ActivationMethod,FixedQuantity,productType,ProductIdentifier,isProvisioning,isAutoActivation,LDK.lockingType,LDK.rehostState,LDK.upgradeToDriverless,LDK.vclock,LDK.isNotLockedToDevice,LDKMemory.fileName,LDKMemory.text,LDKMemory.fileId,LDKMemory.applyMemory,LDKMemory.allowTextOverwrite TRUE,DEMOMA,428b,Spreadsheet-4U,,2002,D-2002,Spreadsheet-4U is a spreadsheet program for business applications,DRAFT,137d,Edit_File,,DefaultOn,Perpetual,FALSE,1,Default,SAOT,0,DEFAULT,,FALSE,FALSE,HL_or_SL_AdminMode_or_SL_UserMode,DISABLE,FALSE,FALSE,FALSE,TestMemory,44656661756c74,1,ADD,TRUE
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
Header | Description |
---|---|
IsLDKEnforcement |
Specifies whether the product is defined for Sentinel LDK. |
NamespaceName | (Required) Associated namespace. |
ExternalPrdId | External product identifier used for integration with external systems. |
ProductName | (Required) The name of the product. |
ProductVersion |
Not relevant. Leave blank. |
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 |
Status of the product. Possible values: >DRAFT >ENABLE >DISABLE Default if no value is specified: DRAFT |
ExternalFtrId |
External feature ID used for integration with external systems. |
FeatureName | Feature name. |
FeatureVersion |
Not relevant. Leave blank. |
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 license model 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 supported license model. |
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 |
(Required) Multiplying factor at product feature relationship level. Minimum value: 1 |
familyName | Product family name |
ActivationMethod | The activation method (SAOT (also known as "Define in Entitlement"), Fixed, Partial, Full). |
FixedQuantity | For Fixed activation method: the quantity that must be consumed for each activation. |
ProductIdentifier | Custom-defined or system-generated identifier of the product. |
isProvisioning |
Whether provisioning requests are supported for the product. For more information, see Provisioning. Possible values: >TRUE >FALSE Default if no value is specified: FALSE |
isAutoActivation |
When isProvisioning is set to TRUE, specifies whether the product is activated automatically without any intervention when an entitlement is marked as complete. For more information, see Provisioning. Possible values: >TRUE >FALSE Default if no value is specified: FALSE |
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. Possible values: > 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. Possible values: >TRUE >FALSE 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. Possible values: >TRUE >FALSE Default: FALSE |
LDK.isNotLockedToDevice |
Whether the license is locked to a device. Possible values: >TRUE >FALSE 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 Default: FALSE |
CSV File Format for Entitlements
The following sample displays the CSV file format for importing entitlement data. The first line shows the headers. The next lines show sample data.
entId,eId,externalId,startDate,endDate,customer,custIdentifier,ccEmail,contact,contactExternalId,channelPartner,userRegistration,refId1,refId2,activationAllowed,allowActivationBy,lifeCycleStage,sendNotification,comments,productKey,PK_StartDate,PK_ExternalId,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,10.0,,LDKTest,1,,LDKTest,Perpetual,FALSE,,,,TRUE,10,,,TRUE,TRUE,FALSE,1, ,eId2,,,,,,,,,,,,,TRUE,VENDOR_ONLY,DRAFT,,,,,,,100,100,FIXED,1,,,,,Sentinel LDK,10.0,,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. For details on adding a custom attribute, see Using Custom Attributes.
Header | Description |
---|---|
entId | Entitlement ID to identify entitlement in database uniquely. |
eId | Entitlement ID to identify entitlement in the Sentinel EMS user interface and REST APIs. |
externalId | External reference identifier that uniquely identifies the entitlement in an external system. |
NOTE When importing entitlement data from a CSV file, you must provide one of the following to identify the entitlement: >eId (if the Allow Manual Creation of EID and PKID property is set to Yes in Administration Console) >externalId |
|
startDate | (Required) Entitlement start date. The format is YYYY-MM-DD. If left blank, the current date is inserted. |
endDate | (Required) Entitlement end date. The format is YYYY-MM-DD. If left blank, the date "2500-12-31" is inserted. |
NOTE For date-type custom attributes (CA_ENT.date-attribute-name), the format is YYYY-MM-DD format, similar to startDate and endDate. |
|
customer | Customer name |
custIdentifier | Custom-defined or automatically generated unique identifier of the customer. |
ccEmail |
Email addresses to receive entitlement certificate (up to 15 comma-separated email addresses). |
contact | Email address of the user. |
channelPartner | Channel partner name. |
userRegistration |
Specifies whether end user registration is required when logging on to the Sentinel EMS customer portal. Possible values: > None >Optional >Mandatory |
refId1 | Reference identifier that identifies the entitlement in an external system. |
refId2 |
Reference identifier that identifies the entitlement in an external system. |
activationAllowed |
Whether the entitlement can be activated to generate a license. Requires lifeCycleStage be set to Complete. Possible values: >TRUE >FALSE Default if another value or no value is provided: TRUE |
allowActivationBy |
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 |
lifeCycleStage |
The state of the entitlement. Possible values: >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: > TRUE >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). Format: YYYY-MM-DD If left blank, the value will be same as startDate. |
PK_EndDate |
Product key end date (line item end date). Format: 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. Relevant only for activated entitlements. For draft entitlements, the value is always totalQuantity, irrespective of input. |
activationMethod |
The method of defining and allocating the quantity of licenses available for the product in the entitlement. Possible values: >FIXED >PARTIAL >FULL |
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 |
(Required) 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 |
(Required) 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. |
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. Not relevant. Leave blank. |
NOTE You must provide a combination of productName and productVersion to create any type of entitlement. |
|
featureId | Feature ID that identifies the product feature in the entitlement. |
featureName | Feature name that identifies the product feature in the entitlement. |
EntitlementAsWhole |
Whether to perform activations on all associated products (also referred to as product keys) together. For line items with unlocked products, must be set to true. Default: false |
Various license model attributes |
Specify only the relevant license model values for the entitlement. 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 sample displays the CSV file format for importing download data. The first line shows the headers. The next lines show sample data.
Action,name,version,externalId,releasedDate,description,isEnable,eol,isAttachable,fileName,fileSize,logobinary,downloadLocation,Productid,ProductIdentifier,ProductExtenalId,ProductName,ProductVersion,ProductAssociationState,AssociateDownloadId,AssociateDownloadName,AssociateDownloadVersion,AssociateDownloadExternalId,CustomerId,CustomerName,CustIdentifier,CustExternalId,ISLEGACY CREATE,D501,1.2,501a,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,801e,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. For details on adding a custom attribute, see Using Custom Attributes.
Header | Description |
---|---|
Action |
Operation performed during data-load through CSV. Possible value: CREATE |
name | (Required) Download name. |
version | Download version. |
externalId | External reference identifier that uniquely identifies the download in an external system. |
releasedDate |
Date from which the content will be available for download. Format: YYYY-MM-DD |
description | Download description. |
isEnable |
Download status, where true creates an enabled download and false creates a disabled download that cannot be downloaded. Possible 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.. Possible values: > TRUE >FALSE |
fileName | (Required) 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 Identifier 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. Possible values: > Active >Inactive Default value: Active |
AssociateDownloadId | Associated download ID for the main download. |
AssociateDownloadName | Associated download name for the main download. |
AssociateDownloadVersion | Associated download version for the main download. |
AssociateDownloadExternalId | External reference identifier that identifies the associated downloads. |
CustomerId | Customer Identifier. |
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. |