item name type #0 $DesignVersion Text #1 $Version Text #2 $Formula Formula #3 $FormulaClass Text #4 $Collation Collation #5 $UpdatedBy TextList #6 $Name Text #7 $TITLE Text #8 IconBitmap Icon #9 $Flags Text #10 $Daos Text #11 $LargeSummary Text #12 $ACLDigest UserData #13 $Signature Signature #14 $Collection Object #15 $ViewContainer Object #16 $DesignerVersion Text #17 $FileSize Number #18 $FileData Composite #19 $FileNames Text #20 $FlagsExt Text #21 $HTMLCode Composite #22 $Comment Text #23 $Info Composite #24 $$ScriptName Text #25 $Body Composite #26 $WindowTitle Formula #27 Subject InvalidOrUnknown #28 Category_1 InvalidOrUnknown #29 Category_2 InvalidOrUnknown #30 Category_3 InvalidOrUnknown #31 Body InvalidOrUnknown #32 SubTotal_1 Number #33 SubTotal_2 Number #34 SubTotal_3 Number #35 DueDate Time #36 CreatedDate Time #37 ModifiedDate Time #38 $Fields TextList UNKテーブルを NotesPeekで確認
Sub Initialize Dim ss As New NotesSession Dim exporter As NotesDXLExporter Dim db As New NotesDatabase("","UNKTable.nsf") Dim out$ Dim filenum As Integer Set exporter = ss.CreateDXLExporter out = exporter.Export(db) filenum = FreeFile Open "c:¥temp¥UNKTable.dxl" For Output As filenum Write #filenum, out Close filenum End Sub 【参考】 UNKテーブルは DXL出力に 含まれない DXL (Domino XML Language)
item name Type #0 $DesignVersion Text #1 $Version Text #2 $Formula Formula #3 $FormulaClass Text #4 $Collation Collation #5 $UpdatedBy TextList #6 $Name Text #7 $TITLE Text #8 IconBitmap Icon #9 $Flags Text #10 $Daos Text #11 $LargeSummary Text #12 $ACLDigest UserData #13 $Signature Signature #14 $Collection Object #15 $ViewContainer Object #16 $DesignerVersion Text #17 $FileSize Number #18 $FileData Composite #19 $FileNames Text #20 $FlagsExt Text #21 $HTMLCode Composite #22 $Comment Text #23 $Info Composite #24 $$ScriptName Text #25 $Body Composite #26 $WindowTitle Formula #27 Subject InvalidOrUnknown #28 Category_1 InvalidOrUnknown #29 Category_2 InvalidOrUnknown #30 Category_3 InvalidOrUnknown #31 Body InvalidOrUnknown #32 SubTotal_1 Number #33 SubTotal_2 Number #34 SubTotal_3 Number #35 DueDate Time #36 CreatedDate Time #37 ModifiedDate Time #38 $Fields TextList #39 RevisedDate Time #40 Category_0 InvalidOrUnknown #41 SubTotal_0 Number item name Type #0 $DesignVersion Text #1 $Version Text #2 $Formula Formula #3 $FormulaClass Text #4 $Collation Collation #5 $UpdatedBy TextList #6 $Name Text #7 $TITLE Text #8 IconBitmap Icon #9 $Flags Text #10 $Daos Text #11 $LargeSummary Text #12 $ACLDigest UserData #13 $Signature Signature #14 $Collection Object #15 $ViewContainer Object #16 $DesignerVersion Text #17 $FileSize Number #18 $FileData Composite #19 $FileNames Text #20 $FlagsExt Text #21 $HTMLCode Composite #22 $Comment Text #23 $Info Composite #24 $$ScriptName Text #25 $Body Composite #26 $WindowTitle Formula #27 Subject InvalidOrUnknown #28 Category_1 InvalidOrUnknown #29 Category_2 InvalidOrUnknown #30 Category_3 InvalidOrUnknown #31 Body InvalidOrUnknown #32 SubTotal_1 Number #33 SubTotal_2 Number #34 SubTotal_3 Number #35 DueDate Time #36 CreatedDate Time #37 ModifiedDate Time #38 $Fields TextList フォーム変更前 フォーム変更後 削除した3つのフィールドは まだUNKテーブルに存在する
item name Type #0 $DesignVersion Text #1 $Version Text #2 $Formula Formula #3 $FormulaClass Text #4 $Collation Collation #5 $UpdatedBy TextList #6 $Collection Object #7 $ViewContainer Object #8 $Name Text #9 $TITLE Text #10 $ACLDigest UserData #11 $Signature Signature #12 $Flags Text #13 $DesignerVersion Text #14 $FileSize Number #15 $FileData Composite #16 $FileNames Text #17 $FlagsExt Text #18 $Comment Text #19 SubTotal_3 Number #20 ModifiedDate Time #21 $HTMLCode Composite #22 $Info Composite #23 $WindowTitle Formula #24 $$ScriptName Text #25 Subject InvalidOrUnknown #26 Category_1 InvalidOrUnknown #27 Category_2 InvalidOrUnknown #28 SubTotal_1 Number #29 SubTotal_2 Number #30 DueDate Time #31 CreatedDate Time #32 RevisedDate Time #33 Body InvalidOrUnknown #34 Category_0 InvalidOrUnknown #35 SubTotal_0 Number #36 $Fields TextList #37 $Body Composite #38 IconBitmap Icon #39 $Daos Text #40 $LargeSummary Text item name Type #0 $DesignVersion Text #1 $Version Text #2 $Formula Formula #3 $FormulaClass Text #4 $Collation Collation #5 $UpdatedBy TextList #6 $Name Text #7 $TITLE Text #8 IconBitmap Icon #9 $Flags Text #10 $Daos Text #11 $LargeSummary Text #12 $ACLDigest UserData #13 $Signature Signature #14 $Collection Object #15 $ViewContainer Object #16 $DesignerVersion Text #17 $FileSize Number #18 $FileData Composite #19 $FileNames Text #20 $FlagsExt Text #21 $HTMLCode Composite #22 $Comment Text #23 $Info Composite #24 $$ScriptName Text #25 $Body Composite #26 $WindowTitle Formula #27 Subject InvalidOrUnknown #28 Category_1 InvalidOrUnknown #29 Category_2 InvalidOrUnknown #30 Category_3 InvalidOrUnknown #31 Body InvalidOrUnknown #32 SubTotal_1 Number #33 SubTotal_2 Number #34 SubTotal_3 Number #35 DueDate Time #36 CreatedDate Time #37 ModifiedDate Time #38 $Fields TextList #39 RevisedDate Time #40 Category_0 InvalidOrUnknown #41 SubTotal_0 Number フォーム変更後 UNKテーブル更新後 削除したフィールドのうち テキスト型のCategory_3だけ 削除されたが 数値型と日付時刻型の2つは まだ存在する
item name Type #0 $DesignVersion Text #1 $Version Text #2 $Formula Formula #3 $FormulaClass Text #4 $Collation Collation #5 $UpdatedBy TextList #6 $Collection Object #7 $ViewContainer Object #8 $Name Text #9 $TITLE Text #10 $ACLDigest UserData #11 $Signature Signature #12 $Flags Text #13 $DesignerVersion Text #14 $FileSize Number #15 $FileData Composite #16 $FileNames Text #17 $FlagsExt Text #18 $Comment Text #19 SubTotal_3 Number #20 ModifiedDate Time #21 $HTMLCode Composite #22 $Info Composite #23 $WindowTitle Formula #24 $$ScriptName Text #25 Subject InvalidOrUnknown #26 Category_1 InvalidOrUnknown #27 Category_2 InvalidOrUnknown #28 SubTotal_1 Number #29 SubTotal_2 Number #30 DueDate Time #31 CreatedDate Time #32 RevisedDate Time #33 Body InvalidOrUnknown #34 Category_0 InvalidOrUnknown #35 SubTotal_0 Number #36 $Fields TextList #37 $Body Composite #38 IconBitmap Icon #39 $Daos Text #40 $LargeSummary Text 【確認】 この時点では、UNKテーブル上の型は テキストに更新されていない
item name Type #0 $DesignVersion Text #1 $Version Text #2 $Formula Formula #3 $FormulaClass Text #4 $Collation Collation #5 $UpdatedBy TextList #6 $Collection Object #7 $ViewContainer Object #8 $Name Text #9 $TITLE Text #10 $ACLDigest UserData #11 $Signature Signature #12 $Flags Text #13 $DesignerVersion Text #14 $FileSize Number #15 $FileData Composite #16 $FileNames Text #17 $FlagsExt Text #18 $Comment Text #19 SubTotal_3 Number #20 ModifiedDate Time #21 $HTMLCode Composite #22 $Info Composite #23 $WindowTitle Formula #24 $$ScriptName Text #25 Subject InvalidOrUnknown #26 Category_1 InvalidOrUnknown #27 Category_2 InvalidOrUnknown #28 SubTotal_1 Number #29 SubTotal_2 Number #30 DueDate Time #31 CreatedDate Time #32 RevisedDate Time #33 Body InvalidOrUnknown #34 Category_0 InvalidOrUnknown #35 SubTotal_0 Number #36 $Fields TextList #37 $Body Composite #38 IconBitmap Icon #39 $Daos Text #40 $LargeSummary Text 【確認】 UNKテーブルに変化なし
item name Type #0 $DesignVersion Text #1 $Version Text #2 $Formula Formula #3 $FormulaClass Text #4 $Collation Collation #5 $UpdatedBy TextList #6 $Collection Object #7 $ViewContainer Object #8 $Name Text #9 $TITLE Text #10 $ACLDigest UserData #11 $Signature Signature #12 $Flags Text #13 $DesignerVersion Text #14 $FileSize Number #15 $FileData Composite #16 $FileNames Text #17 $FlagsExt Text #18 $Comment Text #19 SubTotal_3 Number #20 ModifiedDate Time #21 $HTMLCode Composite #22 $Info Composite #23 $WindowTitle Formula #24 $$ScriptName Text #25 Subject InvalidOrUnknown #26 Category_1 InvalidOrUnknown #27 Category_2 InvalidOrUnknown #28 SubTotal_1 Number #29 SubTotal_2 Number #30 DueDate Time #31 CreatedDate Time #32 RevisedDate Time #33 Body InvalidOrUnknown #34 Category_0 InvalidOrUnknown #35 SubTotal_0 Number #36 $Fields TextList #37 $Body Composite #38 IconBitmap Icon #39 $Daos Text #40 $LargeSummary Text Item name Type #0 $DesignVersion Text #1 $Version Text #2 $Formula Formula #3 $FormulaClass Text #4 $Collation Collation #5 $UpdatedBy TextList #6 $Collection Object #7 $ViewContainer Object #8 $Name Text #9 $TITLE Text #10 $ACLDigest UserData #11 $Signature Signature #12 $Flags Text #13 $DesignerVersion Text #14 $FileSize Number #15 $FileData Composite #16 $FileNames Text #17 $FlagsExt Text #18 $Comment Text #19 $HTMLCode Composite #20 $Info Composite #21 $WindowTitle Formula #22 $$ScriptName Text #23 Subject InvalidOrUnknown #24 Category_0 InvalidOrUnknown #25 Category_1 InvalidOrUnknown #26 Category_2 InvalidOrUnknown #27 SubTotal_0 Number #28 SubTotal_1 Number #29 SubTotal_2 Number #30 DueDate Time #31 CreatedDate Time #32 RevisedDate Time #33 Body InvalidOrUnknown #34 $Fields TextList #35 $Body Composite #36 IconBitmap Icon #37 $Daos Text #38 $LargeSummary Text UNKテーブル更新前 UNKテーブル更新後 【確認】 UNKテーブルから 削除された!!