How to Import Article (without Translation) with help of “Import Article” function.
Prerequisites – Create Root Folder, HTML Folder, & Sub – Folder (if you want to import images as well while importing articles).
1. Create Root Folder (E.g. FAQ), which will consist i. .CSV file (E.g. FAQ) (mentioned in Step 1). ii. .property file (mentioned in Step 2). iii. HTML FOLDER (E.g. HTML). 2. HTML Folder (E.g. HTML) will consist Sub – Folder (E.g. Image). 3. Now, name the image that you will download or save image with its name and ‘extension’ (eg. Download.jpg or Download(1).png) in Sub – Folder (E.g. Image), if you are dealing with images in articles.
Step 1 – Download Specimen CSV file.
1. Click on Setup | Data Management | Import Articles. 2. Read instruction carefully as it may enforce you to retry, if you miss any tiny point mentioned in “Step 1. Create the CSV File”. 3. Then, click on “Download sample .csv file for articles only” to get specimen.
Once, you have specimen downloaded, fill up your data and make sure 1 CSV will only work for particular “Article Type” (E.g. FAQ). If you have 4 Article Types then you will need to create 4 different CSVs and import it 4 times.
Step 2 – Download Specimen CSV file and .properties file.
Now, click on “Download sample (TXT) for articles only.” in “Step 2. Specify Import Parameters”. It may download or open in new web window. Kindly copy the content, which will look similar as below mentioned information (not sure every time it will be similar).
1. Then, open “Notepad” and paste earlier copied content. 2. Now, click on File | Save As | locate ‘Root Folder’ (E.g. FAQ) | Name the file with ‘extension’ as .properties (Eg. ComputerCrash.properties) | select ‘All Files (*.*)’ from ‘Save As Type:’ drop down and click on ‘Save’. 3. Open Properties file (Eg. ComputerCrash.properties) and make sure it is opening in normal notepad mode.
If you want to upload images while importing Article or Knowledge in Salesforce, then only follow below mentioned steps.
Step 2.1 – Create HTML file.
1. Open “Notepad” and copy and paste below mentioned HTML code replace with downloaded image’s name with its ‘extension’ (eg. Download.jpg or Download(1).png). Syntax:- <img src="Sub – Folder (E.g. Image)/downloaded or saved images name.extention">
HTML Code:- <img src="Image/*****.***"> (e.g. <img src="Image/download.jpg">)
2. Now, click on File | Save As | locate ‘Root Folder’ (E.g. FAQ) | HTML Folder (E.g. HTML) | Name the file with ‘extension’ as .html (Eg. ComputerCrash.html) | select ‘All Files (*.*)’ from ‘Save As Type:’ drop down and click on ‘Save’. 3. Open HTML file (Eg. ComputerCrash.html) and make sure we see image embedded in HTML. If not, retry from Step 3.1 as something missed somewhere.
Step 2.2 – Embed HTML file (Eg. ComputerCrash.html) in .csv file (E.g. FAQ)
1. Open .CSV file (E.g. FAQ) and make sure you embed HTML file only on a field where Data Type is Rich Text Area Field, otherwise, it will not work. 2. Below is Sample .CSV file where last column ‘Question__c’ is Rich Text Area field. 3. Syntax to embed HTML file on .csv file is “HTML FOLDER/downloaded or saved image name with extension” (E.g. HTML/ComputerCrash.html where HTML FOLDER is “HTML” and downloaded or saved images name is “ComputerCrash.html”)
I have Data Category - 1. Membership (Sub - Category - Upgrades, Downgrade, Deactivate, & Waived-Off) 2. Important Information (Sub - Category - Incidents, Other, Post-Incident, & Pre-Incident)
In Sample below csv file, i am going to include certain Data Categores with particular Sub-Data Categories.
Title
Summary
datacategorygroup.Membership
datacategorygroup.Important_information
Computer Crash
Computer Crash
Upgrades+Downgrades
Incidents+Other
You just need to replace "datacategorygroup.Membership" to "datacategorygroup.xxxxx" (your data category name). Just make sure you put '+' whenever you add more than one sub-category (e.g. Upgrades'+'Downgrades).
Step 3 - Zip Your Files.
1. Make sure you Zip below mentioned files. 2. .CSV file (E.g. FAQ) (mentioned in Step 1). 2. .property file (mentioned in Step 2). 3. HTML FOLDER (E.g. HTML), (which will have 1. Sub – Folder (E.g. Image) and 2. Actual downloaded/saved image.)
I am sure you would be able to import article, however, if you still getting error message, just give a try from beginning or else create a case with Salesforce.
See the links below,
Creating a .csv File for Article Import
https://help.salesforce.com/HTViewHelpDoc?id=knowledge_article_importer_02csv.htm&language=en_US
"Importing Articles into Salesforce Knowledge" within Help & Training. Here's the link:
https://login.salesforce.com/help/doc/en/salesforce_knowledge_import_cheatsheet.pdf
Regards,
Ashish
Prerequisites – Create Root Folder, HTML Folder, & Sub – Folder (if you want to import images as well while importing articles).
1. Create Root Folder (E.g. FAQ), which will consist
i. .CSV file (E.g. FAQ) (mentioned in Step 1).
ii. .property file (mentioned in Step 2).
iii. HTML FOLDER (E.g. HTML).
2. HTML Folder (E.g. HTML) will consist Sub – Folder (E.g. Image).
3. Now, name the image that you will download or save image with its name and ‘extension’ (eg. Download.jpg or Download(1).png) in Sub – Folder (E.g. Image), if you are dealing with images in articles.
Step 1 – Download Specimen CSV file.
1. Click on Setup | Data Management | Import Articles.
2. Read instruction carefully as it may enforce you to retry, if you miss any tiny point mentioned in “Step 1. Create the CSV File”.
3. Then, click on “Download sample .csv file for articles only” to get specimen.
Once, you have specimen downloaded, fill up your data and make sure 1 CSV will only work for particular “Article Type” (E.g. FAQ). If you have 4 Article Types then you will need to create 4 different CSVs and import it 4 times.
Step 2 – Download Specimen CSV file and .properties file.
Now, click on “Download sample (TXT) for articles only.” in “Step 2. Specify Import Parameters”. It may download or open in new web window. Kindly copy the content, which will look similar as below mentioned information (not sure every time it will be similar).
CSVEncoding=UTF8
RTAEncoding=UTF8
CSVSeparator=,
#DateFormat=yyyy-MM-dd
1. Then, open “Notepad” and paste earlier copied content.
2. Now, click on File | Save As | locate ‘Root Folder’ (E.g. FAQ) | Name the file with ‘extension’ as .properties (Eg. ComputerCrash.properties) | select ‘All Files (*.*)’ from ‘Save As Type:’ drop down and click on ‘Save’.
3. Open Properties file (Eg. ComputerCrash.properties) and make sure it is opening in normal notepad mode.
If you want to upload images while importing Article or Knowledge in Salesforce, then only follow below mentioned steps.
Step 2.1 – Create HTML file.
1. Open “Notepad” and copy and paste below mentioned HTML code replace with downloaded image’s name with its ‘extension’ (eg. Download.jpg or Download(1).png).
Syntax:-
<img src="Sub – Folder (E.g. Image)/downloaded or saved images name.extention">
HTML Code:-
<img src="Image/*****.***"> (e.g. <img src="Image/download.jpg">)
2. Now, click on File | Save As | locate ‘Root Folder’ (E.g. FAQ) | HTML Folder (E.g. HTML) | Name the file with ‘extension’ as .html (Eg. ComputerCrash.html) | select ‘All Files (*.*)’ from ‘Save As Type:’ drop down and click on ‘Save’.
3. Open HTML file (Eg. ComputerCrash.html) and make sure we see image embedded in HTML. If not, retry from Step 3.1 as something missed somewhere.
Step 2.2 – Embed HTML file (Eg. ComputerCrash.html) in .csv file (E.g. FAQ)
1. Open .CSV file (E.g. FAQ) and make sure you embed HTML file only on a field where Data Type is Rich Text Area Field, otherwise, it will not work.
2. Below is Sample .CSV file where last column ‘Question__c’ is Rich Text Area field.
3. Syntax to embed HTML file on .csv file is “HTML FOLDER/downloaded or saved image name with extension” (E.g. HTML/ComputerCrash.html where HTML FOLDER is “HTML” and downloaded or saved images name is “ComputerCrash.html”)
I have Data Category - 1. Membership (Sub - Category - Upgrades, Downgrade, Deactivate, & Waived-Off) 2. Important Information
(Sub - Category - Incidents, Other, Post-Incident, & Pre-Incident)
In Sample below csv file, i am going to include certain Data Categores with particular Sub-Data Categories.
You just need to replace "datacategorygroup.Membership" to "datacategorygroup.xxxxx" (your data category name). Just make sure you put '+' whenever you add more than one sub-category (e.g. Upgrades'+'Downgrades).
Step 3 - Zip Your Files.
1. Make sure you Zip below mentioned files.
2. .CSV file (E.g. FAQ) (mentioned in Step 1).
2. .property file (mentioned in Step 2).
3. HTML FOLDER (E.g. HTML), (which will have 1. Sub – Folder (E.g. Image) and 2. Actual downloaded/saved image.)
Step 4 - Select Article Type and Import Zip File.
1. Select correct Article Type.
2. Attach “Zip file”.
3. Click on ‘Import Now’
I am sure you would be able to import article, however, if you still getting error message, just give a try from beginning or else create a case with Salesforce.
Effective ways to export articles from Salesforce sandbox
https://www.codekiat.com/2020/04/export-knowledge-articles-salesforce.html
--
Naveen K N