Knowledge Base

Bulk Enrollment for SSL Certificates: CSV Format Guidelines

To ensure successful bulk enrollment requests for SSL certificates, the data must be structured correctly and submitted in a .csv format. Each certificate’s parameters must be listed on a single line, separated by commas, except for the last parameter. All parameters are mandatory, except for Subject Alternate Names (SAN). If a certificate does not have SANs, leave the SAN parameter blank. If a parameter contains commas within its string, enclose the entire parameter in quotation marks.


Required Parameters

Each line in the .csv file must include the following parameters in the specified order:
  1. Common Name: String
  2. SAN: Enclose the entire value in quotation marks, with domains inside separated by commas
  3. Certificate Type: String, must match the certificate profile exactly
  4. Certificate Term: String, must match the certificate profile exactly
  5. Server Software: String, recommended value: OTHER

 

Example Entries
  • Without SANs: To request enrollment for an EliteSSL Certificate profile for 1 year with a common name of scm.com and no SANs, the line in the .csv file should be:
scm.com,,EliteSSL Certificate,1 year,OTHER
  • With SANs: To request enrollment for an AMT Multi-Domain SSL Certificate for 2 years with a common name of scm.com and SANs cert.com and secured.com, the line in the .csv file should be:

 

scm.com,"cert.com,secured.com",AMT Multi-Domain SSL Certificate,2 years,OTHER
Bulk SSL Certificate File Errors
When submitting a bulk enrollment request with a .csv file that contains errors, you might encounter error messages like the ones listed below. These errors indicate issues that need to be corrected in the .csv file.

 

2CSV file parsing error(s): Line <line ID> - Required field certType is not specified.The CSV file contains a line without a certificate type.
3CSV file parsing error(s): Line <line ID> - Required field certTerm is not specified.The CSV file contains a line without a certificate validity period (term).
4CSV file parsing error(s): Line <line ID> - Required field serverSoftware is not specified.The CSV file contains a line without a server software.
5CSV file parsing error(s): Line <line ID> - Please use commas only to delimit domain alternative names (for example - domain_one.com, domain_two.com, etc.).The CSV file contains a line in which not all parameters are separated by commas.
6CSV file parsing error(s): Line <line ID> - Field certType contains disallowed value: <value>.The specified certificate type is not found among certificate profiles allowed for the organization for which this request is being submitted, or this certificate type does not exist.
7CSV file parsing error(s): Line <line ID> - Field certTerm contains disallowed value: <value>.The specified certificate term is not permitted for the certificate type specified in the same line.
8CSV file parsing error(s): Line <line ID> - Field serverSoftware contains disallowed value: <value>.The specified server software is not found among the server software allowed for the organization for which the request is being submitted.
9CSV file parsing error(s): Line <line ID> - Incorrect values - Actual fields quantity: <value>, expected fields quantity: <value>.The number of commas in a line of the CSV file is other than four.
10CSV file parsing error(s): Line <line ID> - Field san contains nonempty value: <0>. Subject alternative names are not allowed for <specified certType> certificate type.A line in the CSV file contains Subject Alternative Names, whereas the certificate type specified in the same line is not multi-domain.

Need assistance?

Contact our team for help with your purchase or issuing your certificate.

Live chat

Call us today