FPT Software Citus Migration Suite Owner's manual

Brand: FPT

Model: Software Citus Migration Suite

Category: Software

Type: Owner's manual







CITUS MIGRATION SUITE.................................................................................................................1
USER’S MANUAL..................................................................................................................................1
TABLE OF CONTENT...........................................................................................................................2
INTRODUCTION..........................................................................................................................6
 
  
DATA MIGRATION PROCESS..................................................................................................7
CITUS DATA MIGRATION SUITE USAGE............................................................................8
! "#$%&'(
1.1 Verify environment variable..............................................................................................8
1.2 Configure tool (Mandatory)............................................................................................10
SCREENSHOT OF CITUS EXTRACTOR TOOL...........................................................................10
1.2.1. Connect to Notes database.....................................................................................11
1.2.2. Connect to SQL server...........................................................................................11
1.2.3. Export users and links............................................................................................12
1.2.4. Setting log file path................................................................................................12
1.2.5. Setting Temporary folder.......................................................................................13
1.2.6. Store attachments to a separate table.....................................................................13
1.3 Configure Advance functions of tool (Optional).............................................................14
1.3.1. Get Access Control List Permission of Notes Database........................................14
1.3.2. Filter data by date..................................................................................................14
1.3.3. Filter data by UNID...............................................................................................15
1.3.4. Extract only from designed fields..........................................................................15
1.3.5. Extract from fields not in design fields..................................................................16
1.3.6. Extract computed fields.........................................................................................16
1.3.7. Only fill data to database.......................................................................................17
1.3.8. Store all fields type changed to table.....................................................................17
1.3.9. Create database structure from excel file...............................................................17
1.3.10. Create table name using prefix..............................................................................18
1.3.11. Only create database structure...............................................................................19
1.3.12. Store path’s attachments........................................................................................19
1.3.13. Select form to extract.............................................................................................20
1.3.14. Extract by select Fields..........................................................................................21
1.3.15. Extract with exclude selected fields......................................................................21
)


1.3.16. Setting files (Optional)..........................................................................................22
1.4 Save Configuration file....................................................................................................23
1.5 Extract execution.............................................................................................................23
1.6 Migrate multiple Notes Database....................................................................................23
1.7 Verify result.....................................................................................................................25
! $%&'
2.1 Configure tool..................................................................................................................27
2.1.1. Export users from text fields (Optional)................................................................28
2.1.2. Update mapping file..............................................................................................29
2.1.3. Connect to SQL Server..........................................................................................31
2.1.4. Create Job..............................................................................................................32
2.1.5. Create new SQL database......................................................................................33
2.1.6. Transform Richtext................................................................................................34
2.1.7. Mapping user.........................................................................................................35
2.1.8. Create SQL script..................................................................................................37
2.1.9. Collect users which hadn’t used............................................................................38
2.1.10. Provide template for processing tab characters.....................................................38
2.1.11. Display icons which are not available in Images Library of SharePoint...............39
2.2 Execute Pre-process........................................................................................................40
2.3 Verify result.....................................................................................................................40
!! %*$%&!'+
3.1 Configure tool..................................................................................................................42
3.1.1. Connect to SQL Server..........................................................................................42
3.1.2. Connect to SharePoint Site....................................................................................43
3.1.3. Common settings of Transformer tool...................................................................44
3.1.4. Create jobs and mapping fields..............................................................................46
3.1.5. Migrate ACL Permission to SharePoint Site (Optional).......................................50
3.2 Execute transformation...................................................................................................51
3.2.1. Resume transforming data.....................................................................................51
3.2.2. Transform duplicate data.......................................................................................52
3.2.3. Transform Document List......................................................................................52
3.3 Verify result.....................................................................................................................52
!+ $%&+',!
4.1 Configure tool (Mandatory)............................................................................................54
4.2.1 Connect to SharePoint site.....................................................................................54
4.2.2 Create jobs.............................................................................................................56
4.2 Other Setting (Optional)..................................................................................................57
4.3 Setup environment to use Post-process service (Using for SharePoint 2007)................60
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 34
++ 1*-./5
+, 1*1/
+ 03/
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
)



5.4.4 Tool did not perform the post process correctly on the date-time data of System fields.

)



 

1.1 

17%*3**

.21*189!,%1

131 

:  1          1        1      ;

13*3<:=>

1.2 !"#$%

&%

'&#$ () 

  %1*3

*

#1*.

2**

1

-.8?@A



  **.2

1

1

*

* 

B% B% %1 

3* 

 

 1 *13

**

@ 

.2 .2 :@3*

)



 $

*.2C 1

D1E# F 



%1 1 *31

31313311

)



 $

3.1 ()*+,

B  1        *  2    3    #          -.

 -.1*

3

B 16

0*   61 G2B:

 6*311.2@#311-. 



"## 

0*# 

 

 "#GG 3G

 -#%$%

"#2B:22 ,

12..1(%$

-./0*1 G2B:

73136

68#$G(%$-

)



6:#$-1/"1G(

!6B1*2*%%

7#6<;6H7$#('HH>**131.

2 ,A3/1

)



 !*#,

1*"#

@*16%1

I311%16

#

2

-. 

"#G

1

%*

1

1

=B.*2

7

72:

"#*

"#*

"#

8

1

*#

#

8

1I1

*#







73131

)



3.1.2.1. Connect to Notes database

%11*.2111*36

6G 

6@31%1*

 

:*12**3136

2313

G23

@32

813 12         *3 1

36

$%13

: %$#

G

1

3.1.2.2. Connect to SQL server

%1*-. -.

111*36

6G 

6: %$#

!6:*-. B11G 43&/ :

-. B11*36

:1#12311311-. 



)



:13#13*1131

1-. 

+6G@1

,63113 

:      3   *      @ 1     

D31

3.1.2.3. Export users and links

A1*.211 1

23131%1"# 

*  1      GJ  *  2   #               1

1*%11*3D

7313*16

G151

:1 () 6 111# 

$Mapping le'

3.1.2.4. Setting log le path

%1%16

G1

:17!/#111

)



3.1.2.5. Setting Temporary folder

%##K%7L3*1%1* 

11#

 !"#$

%&' #$#$

&

 !"(

 #$&

3.1.2.6. Store attachments to a separate table

% *1*-.  1

113%1**

12*61*111

*<<MB1>9#

)



)*%#)$!&

 !&%*1,

3.1.3.

3.1.3.1. Get Access Control List Permission of Notes Database

*NOP#1Q$B.'R2#



G1G#()6 #11G#

#

G1G#8&7

3.1.3.2. Filter data by date

%13*%G1

1   *3

173136

)



G159

:()$

3.1.3.3. Filter data by UNID

%1311*2:

1136

G159

:2:()#: 

3.1.3.4. Extract only from designed elds

%13#113#

*6

72*1127$2727

27!'1 311312

7231F27!**

1313*%123

362727

:*313$2727'3127!1

3 <"#*>%1*3 

G1#2*1

)



3.1.3.5. Extract from elds not in design elds

%1*3311#2

I

3.1.3.6. Extract computed elds

%1*3 *# *<*>

2

)



3.1.3.7. Only ll data to database

S1*3131*2

#  -.     %1      *  31    3   *  -.  



%1*31#1-.;1

1

3.1.3.8. Store all elds type changed to table

B()# ! 12

1%1*3-.3111



)



3.1.3.9. Create database structure from excel le

%1311313

*T1-.1$'%16

?#.2"#*

*1"#F

?"#31<2>

%*1"#3111G231

"#

73126

)



3.1.3.10. Create table name using prex

%1*3#*111

#%1#1##13%1*

 -.  3

311

26

( )+,&

2@2M555M72

:*1##11-.

)/2@2M555M72

:**#1#31111

 3

71 *1$*1 01201323/2/45&1&1&67 .

 '11*1*2

@

)



3.1.3.11. Only create database structure

:1C1-.12

1G1 1133#

:6G1-.13112%1

16

?"#31<8>311

*11F$

'

?"#311<8>

3.1.3.12. Store path’s attachments

A13G312-.@

D1*1*3 1

*11G111-.

)

Page is loading ...

FPT Software Citus Migration Suite Owner's manual

Brand: FPT

Model: Software Citus Migration Suite

Category: Software

Type: Owner's manual

Download PDF

report

FPT Software Citus Migration Suite Owner's manual

FPT Software Citus Migration Suite Owner's manual

Other documents