Salesforce Docs Portal

Set Article Import Parameters

Specify import parameters in a property file using key names and corresponding values. For example, use the key DateFormat to specify that a date custom field appears in the DateFormat=dd/MM/YYYY format. Or, specify the character encoding and field separator used for the import file.

Required Editions

Available in Salesforce Classic and Lightning Experience. View supported editions.
User Permissions Needed
To import articles:

Manage Salesforce Knowledge

AND

Manage Articles

AND

Manage Knowledge Article Import/Export

AND

Read, Create, Edit, and Delete on the article type
  1. Create a file with required parameters, as described in this table.
    Key Description Default Value
    DateFormat Format of the date to read in the .csv file yyyy-MM-dd
    DateTimeFormat Format of the date and time to read in the .csv file yyyy-MM-dd HH:mm:ss
    CSVEncoding Character encoding used to read the .csv file ISO8859_15_FDIS
    CSVSeparator .csv field separator ,
    RTAEncoding

    Default encoding used for the HTML files (if not specified in the charset attribute from the HTML meta tag).

    Salesforce does not support UTF-32 character encoding. We recommend using UTF-8. If you use specify UTF-16 character encoding, ensure that your HTML files specify the right byte-order mark.

    		 ISO8859_15_FDIS
    Note
    Note Specify only Java date formats. Make sure that the date format is not misleading. For example, if you choose the format yyyy-M-d, a date entered as 2011111 can be interpreted as 2011-01-11 or 2011-11-01. Specify at least:
    • Two digits for month and day format (MM, dd)
    • Four digits for year format (yyyy)

    If a date in the .csv file does not match the date format specified in the property file, the related article is not imported.

  2. Save the file with the .properties extension.
Example
Example

Example offerarticlesimport.properties property file:

DateFormat=yyyy-MM-dd
DateTimeFormat=yyyy-MM-dd HH:mm:ss
CSVEncoding=ISO8859_15_FDIS
CSVSeparator=,
RTAEncoding=UTF-8

Create a .zip file and import into Salesforce Knowledge.

See Also