From version 19.1
edited by Danilo Oliveira
on 2014/02/28 14:45
To version 20.1
edited by Danilo Oliveira
on 2014/03/05 13:38
Change comment: There is no comment for this version

Summary

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 directories
39 +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 xlsx file which you will need to **convert to 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

Get Connected