Page is loading ...
CITUS MIGRATION SUITE.................................................................................................................1
USER’S MANUAL..................................................................................................................................1
TABLE OF CONTENT...........................................................................................................................2
1 INTRODUCTION..........................................................................................................................6
2 DATA MIGRATION PROCESS..................................................................................................7
3 CITUS DATA MIGRATION SUITE USAGE............................................................................8
! "#$%&'(
3.1.1 Verify environment variable..............................................................................................8
3.1.2 Configure tool (Mandatory)............................................................................................10
SCREENSHOT OF CITUS EXTRACTOR TOOL...........................................................................10
3.1.2.1. Connect to Notes database.....................................................................................11
3.1.2.2. Connect to SQL server...........................................................................................11
3.1.2.3. Export users and links............................................................................................12
3.1.2.4. Setting log file path................................................................................................12
3.1.2.5. Setting Temporary folder.......................................................................................13
3.1.2.6. Store attachments to a separate table.....................................................................13
3.1.3 Configure Advance functions of tool (Optional).............................................................14
3.1.3.1. Get Access Control List Permission of Notes Database........................................14
3.1.3.2. Filter data by date..................................................................................................14
3.1.3.3. Filter data by UNID...............................................................................................15
3.1.3.4. Extract only from designed fields..........................................................................15
3.1.3.5. Extract from fields not in design fields..................................................................16
3.1.3.6. Extract computed fields.........................................................................................16
3.1.3.7. Only fill data to database.......................................................................................17
3.1.3.8. Store all fields type changed to table.....................................................................17
3.1.3.9. Create database structure from excel file...............................................................17
3.1.3.10. Create table name using prefix..............................................................................18
3.1.3.11. Only create database structure...............................................................................19
3.1.3.12. Store path’s attachments........................................................................................19
3.1.3.13. Select form to extract.............................................................................................20
3.1.3.14. Extract by select Fields..........................................................................................21
3.1.3.15. Extract with exclude selected fields......................................................................21
)
3.1.3.16. Setting files (Optional)..........................................................................................22
3.1.4 Save Configuration file....................................................................................................23
3.1.5 Extract execution.............................................................................................................23
3.1.6 Migrate multiple Notes Database....................................................................................23
3.1.7 Verify result.....................................................................................................................25
! $%&'
3.2.1 Configure tool..................................................................................................................27
3.2.1.1. Export users from text fields (Optional)................................................................28
3.2.1.2. Update mapping file..............................................................................................29
3.2.1.3. Connect to SQL Server..........................................................................................31
3.2.1.4. Create Job..............................................................................................................32
3.2.1.5. Create new SQL database......................................................................................33
3.2.1.6. Transform Richtext................................................................................................34
3.2.1.7. Mapping user.........................................................................................................35
3.2.1.8. Create SQL script..................................................................................................37
3.2.1.9. Collect users which hadn’t used............................................................................38
3.2.1.10. Provide template for processing tab characters.....................................................38
3.2.1.11. Display icons which are not available in Images Library of SharePoint...............39
3.2.2 Execute Pre-process........................................................................................................40
3.2.3 Verify result.....................................................................................................................40
!! %*$%&!'+
3.3.1 Configure tool..................................................................................................................42
3.3.1.1. Connect to SQL Server..........................................................................................42
3.3.1.2. Connect to SharePoint Site....................................................................................43
3.3.1.3. Common settings of Transformer tool...................................................................44
3.3.1.4. Create jobs and mapping fields..............................................................................46
3.3.1.5. Migrate ACL Permission to SharePoint Site (Optional).......................................50
3.3.2 Execute transformation...................................................................................................51
3.3.2.1. Resume transforming data.....................................................................................51
3.3.2.2. Transform duplicate data.......................................................................................52
3.3.2.3. Transform Document List......................................................................................52
3.3.3 Verify result.....................................................................................................................52
!+ $%&+',!
3.4.1 Configure tool (Mandatory)............................................................................................54
3.4.2.1 Connect to SharePoint site.....................................................................................54
3.4.2.2 Create jobs.............................................................................................................56
3.4.2 Other Setting (Optional)..................................................................................................57
3.4.3 Setup environment to use Post-process service (Using for SharePoint 2007)................60
3.4.1.1. Setup Citus Post-Processor service........................................................................60
)
3.4.1.2. Setup Environment variables.................................................................................63
3.4.4 Run Post-Process.............................................................................................................65
3.4.5 Verify result.....................................................................................................................65
4 APPENDIX...................................................................................................................................67
+ -./
+ 0*1*/
+! 1*2 34
++ 1*-./5
+, 1*1/
+ 03/
5 COMMON ERRORS...................................................................................................................72
, %6/!
73
5.1.1 Tool1 crashes when users double click on “CitusExtractor.exe” to start the tool.........73
5.1.2 FILESTREAM feature is disabled...................................................................................73
5.1.3 Error: Could not find a part of the path: “DiskName:\...\Report.xlsx”..........................74
5.1.4 Error create table............................................................................................................75
, %6/,
75
5.2.1 Rich-text was not transformed to HTML format.............................................................75
5.2.2 T-SQL Job run successfully but data were not updated correctly...................................76
5.2.3 Missing tables in Destination Database created by tool2 when Source Database created
by tool1 and Destination Database running in different SQL servers...........................................76
5.2.4 Error happens when opening mapping file in the job Mapping Users...........................76
,! %!6//
77
5.3.1 Cannot migrate attachment files to SP............................................................................77
5.3.2 The tool cannot migrate data with error message:.........................................................78
5.3.3 Cannot display the list to be selected in the Destination Connection.............................78
5.3.4 Cannot fill Replies (Response, Response to Response) into Discussion List..................78
5.3.5 Cannot migrate attachment file larger than 50 Mb.........................................................78
,+ %+6/4
79
5.4.1 After running tool, attachment links, Document Link, View Link, DataBase Link are not
correct. Inline images are not showed...........................................................................................79
5.4.2 Tool cannot perform the post-process with the message:...............................................79
5.4.3 Tool cannot perform post-process correctly on the users of System fields with the error
message:.........................................................................................................................................79
)
1.1
17%*3**
.21*189!,%1
131
: 1 1 1 ;
13*3<:=>
1.2 !"#$%
&%
'&#$ ()
%1*3
*
#1*.
2**
1
-.8?@A
**.2
1
1
*
*
B% B% %1
3*
1 *13
**
@
.2 .2 :@3*
)
$
*.2C 1
D1E# F
%1 1 *31
31313311
)
$
3.1 ()*+,
B 1 * 2 3 # -.
-.1*
3
B 16
0* 61 G2B:
6*311.2@#311-.
"##
0*#
"#GG 3G
-#%$%
"#2B:22 ,
12..1(%$
-./0*1 G2B:
73136
68#$G(%$-
)
6:#$-1/"1G(
!6B1*2*%%
7#6<;6H7$#('HH>**131.
2 ,A3/1
)
!*#,
1*"#
@*16%1
I311%16
#
2
-.
"#G
1
%*
1
1
=B.*2
7
72:
"#*
"#*
"#
8
1
*#
#
8
1I1
*#
73131
)
3.1.2.1. Connect to Notes database
%11*.2111*36
6G
6@31%1*
:*12**3136
2313
G23
@32
813 12 *3 1
36
$%13
: %$#
G
1
3.1.2.2. Connect to SQL server
%1*-. -.
111*36
6G
6: %$#
!6:*-. B11G 43&/ :
-. B11*36
:1#12311311-.
)
:13#13*1131
1-.
+6G@1
,63113
: 3 * @ 1
D31
3.1.2.3. Export users and links
A1*.211 1
23131%1"#
* 1 GJ * 2 # 1
1*%11*3D
7313*16
G151
:1 () 6 111#
$Mapping le'
3.1.2.4. Setting log le path
%1%16
G1
:17!/#111
)
3.1.2.5. Setting Temporary folder
%##K%7L3*1%1*
11#
!"#$
%&' #$#$
&
!"(
#$&
3.1.2.6. Store attachments to a separate table
% *1*-. 1
113%1**
12*61*111
*<<MB1>9#
)
)*%#)$!&
!&%*1,
3.1.3.
3.1.3.1. Get Access Control List Permission of Notes Database
*NOP#1Q$B.'R2#
G1G#()6 #11G#
#
G1G#8&7
3.1.3.2. Filter data by date
%13*%G1
1 *3
173136
)
G159
:()$
3.1.3.3. Filter data by UNID
%1311*2:
1136
G159
:2:()#:
3.1.3.4. Extract only from designed elds
%13#113#
*6
72*1127$2727
27!'1 311312
7231F27!**
1313*%123
362727
:*313$2727'3127!1
3 <"#*>%1*3
G1#2*1
)
3.1.3.5. Extract from elds not in design elds
%1*3311#2
I
3.1.3.6. Extract computed elds
%1*3 *# *<*>
2
)
3.1.3.7. Only ll data to database
S1*3131*2
# -. %1 * 31 3 * -.
%1*31#1-.;1
1
3.1.3.8. Store all elds type changed to table
B()# ! 12
1%1*3-.3111
)
3.1.3.9. Create database structure from excel le
%1311313
*T1-.1$'%16
?#.2"#*
*1"#F
?"#31<2>
%*1"#3111G231
"#
73126
)
3.1.3.10. Create table name using prex
%1*3#*111
#%1#1##13%1*
-. 3
311
26
( )+,&
2@2M555M72
:*1##11-.
)/2@2M555M72
:**#1#31111
3
71 *1$*1 01201323/2/45&1&1&67 .
'11*1*2
@
)
3.1.3.11. Only create database structure
:1C1-.12
1G1 1133#
:6G1-.13112%1
16
?"#31<8>311
*11F$
'
?"#311<8>
3.1.3.12. Store path’s attachments
A13G312-.@
D1*1*3 1
*11G111-.
)
/
