Changes for page BatchImport Sharepoint Blog Extension
Last modified by Admin on 2021/03/19 00:49
From version 19.1
edited by Danilo Oliveira
on 2014/02/28 14:45
on 2014/02/28 14:45
Change comment:
There is no comment for this version
To version 20.1
edited by Danilo Oliveira
on 2014/03/05 13:38
on 2014/03/05 13:38
Change comment:
There is no comment for this version
Summary
-
Objects (1 modified, 0 added, 0 removed)
Details
- ExtensionCode.ExtensionClass[0]
-
- Prerequisites & Additional Installation Instructions
-
... ... @@ -5,37 +5,47 @@ 5 5 In order to export the Sharepoint 2013 blog posts and categories you will need use Microsoft Access. 6 6 (More and better info and images to come). 7 7 8 -1) Import to Access 9 -1.1) Open your Access. 8 +1) Import to Microsoft Access 9 +1.1) Open your Microsoft Access. 10 10 1.2) Create a local database 11 11 1.3) In "Extern Data" tab, choose "Sharepoint list" 12 +[[image:access1.png||height="665" width="730"]] 13 + 12 12 1.4) Point your blog address, for example (http://www.sharepointsite.com/yourblog) 13 13 1.5) choose to import the data to a new table 16 +[[image:access2.png||height="665" width="730"]] 14 14 1.6) Choose import Category and Posts 18 +[[image:access3.png||height="665" width="730"]] 15 15 1.7) Import the data. 16 -1.8) Exclude unnecessary columns ( You will need just the (title, published date, category and body) ) 20 +1.8) IN the "Edit Mode" Exclude unnecessary columns ( You will need just the following columns: title, published date, category and body ) 21 +[[image:access4.png||height="665" width="730"]] 17 17 18 -2) Export to Excel (or csv, whatever) 19 -Now, you will have two tables. Posts and Category. 20 -After that, you will need export the Post table to a txt archive. 23 + 24 +2) Export the Post table (Excel or CSV) 21 21 2.1) In the tab "external Data", choose Txt Archive button 26 +[[image:access5.png||height="665" width="730"]] 22 22 2.2) Choose (;) as the separator character 23 23 2.3) Export the archive (try to maintain the following order of the tables |title| published date| category |body| 24 -2.4) Open it in a excel and organize it in columns 25 -2.5) Replace the Category column in excel by the category column of access (this step is necessary, because the category in the "post table" after the exportation show the category ID, not the category name. You need to replace it. 26 -2.6)Exclude unnecessary columns imported in the Access that will be exported 27 -2.7)After that you have the archive in excel. 29 +2.4) Open it in a text editor and save it as csv. 30 +2.5) Open the csv file in the excel. 31 +{{warning}} 32 +IMPORTANT 33 +{{/warning}} 34 +2.6) When you export the post table, the category column come with the ID category number. It will be necessary by hand to replace the id to the respective category name. You can take this information on the "Category table" that was imported in the Microsoft Access. 35 + 36 +2.7)Exclude unnecessary columns (if exists) imported in the Access that will be exported 37 +2.8)Save the archive as xls or csv. See an example of the final product here: [[this file>>attach:blogcontent.xls]] 28 28 29 -3) Get blog directories39 +3) Get blog set documents 30 30 3.1) Open you sharepoint site in IE (http://www.sharepoint.com) 31 31 3.2) Login as administrator 32 32 3.3) In the sharepoint menu, open the sharepoint site in the explorer mode 33 33 3.5) Look and find the sharepoint blog directory 34 -3.5) Copy all content to your machine.44 +3.5) Copy all content to your xwiki server. 35 35 36 36 The result of the export should be: 37 37 38 -* An xls xfile which youwill need to **convertto xls** (Excel 97). The result depends on the language of your interface and should look like [[this file>>attach:blogcontent.xls]] (the example is an export coming out of a Brasilian/Portuguese Sharepoint installation).48 +* An xls or csv file. The result depends on the language of your interface and should look like [[this file>>attach:blogcontent.xls]] (the example is an export coming out of a Brasilian/Portuguese Sharepoint installation). 39 39 * A set of directories. In the case of the Brasilian/Portuguese installation the directory tree should contain at least the following directories 40 40 ** Documentos 41 41 ** Lists