CSV XML 2007 1 18
2007/1/18
CSV XML 1...6 1.1...6 1.2...6 1.3...6 1.4...7 2...8 2.1...8 2.1.1 csv2xml.properties...8 2.1.2...8 2.1.2.1 config.xml...8 2.1.2.2 encoding.xml...8 2.1.2.3 logging.properties...8 2.2 CSV...9 2.2.1 CSV...9 2.2.2 CSV...11 2.2.2.1...11 2.2.2.2...11 2.2.2.3 CSV...11 2.2.2.4...12 2.2.3...13 2.2.3.1...13 2.2.3.1.1 company /**/ company_category.csv...13 2.2.3.1.2 company /**/ post/post.csv...13 2.2.3.1.3 company /**/ post/post_term_i18n_xx.csv...13 2.2.3.1.4 company /**/ company_version_include.csv...13 2.2.3.1.5 company /**/ company_version_note.csv...13 2.2.3.1.6 company /**/ department.csv...14 2.2.3.1.7 company /**/ department_term.csv...14 2.2.3.1.8 company /**/ department_term_i18n_xx.csv...14 2.2.3.2...15 2.2.3.2.1 public_group /**/ public_group_category.csv...15 2.2.3.2.2 public_group /**/ public_group.csv...15 2.2.3.2.3 public_group /**public_group_term_i18n_xx.csv...15 2.2.3.2.4 public_group /**/ public_group_set_version_include.csv...15 2.2.3.2.5 public_group /**/ public_group_set_version_note.csv...15 2.2.3.3...16 2.2.3.3.1 user / user_department_term.csv...16 2.2.3.3.2 user / user_public_group_term.csv...16 2.2.3.3.3 user / application_role.csv...16 2.2.3.3.4 user / role.csv...16 2.2.3.3.5 user / user_term.csv...17 2.2.3.3.6 user / user_term_i18n_xx.csv...17 2.2.3.3.7 user / user.csv...18 2.2.4 CSV...19 2.2.4.1...19 2.2.4.2 XML CSV...20 Page i
intra-mart 2.2.4.3... 20 2.2.4.3.1... 20 2.2.4.3.2... 20 2.2.4.4... 21 2.3... 22 2.3.1... 22 3... 23 3.1 CW-001 [ ]CSV... 23 3.2 CW-002 [ ] CSV... 23 3.3 CW-003 [ ] CSV... 23 3.4 CW-004 [ ] CSV... 23 3.5 CW-005 [ ] CSV... 24 3.6 CW-006... 24 3.7 CW-007... 24 3.8 CW-100 [ ]... 24 3.9 IW-001 [ ]... 25 3.10 IW-002 [ ]... 25 3.11 IW-003 [ ]... 25 3.12 IW-004 [ ]... 25 3.13 IW-005 [ ]... 25 3.14 IW-006 [ ] [ ]... 26 3.15 OI-002 [ ]... 26 3.16 OW-001 [ ]... 26 3.17 DW-001...27 3.18 DW-002... 27 3.19 DW-003 (yyyy/mm/dd)... 27 3.20 DW-004 (1582/10/15-9999/12/31)... 27 3.21 DW-005... 27 3.22 DW-006... 27 3.23 MW-001... 28 3.24 MW-002... 28 3.25 MW-003... 28 3.26 MW-004... 28 3.27 MW-005... 28 3.28 MW-006... 28 3.29 MW-007... 28 3.30 MW-008... 29 3.31 MW-009... 29 3.32 MW-010... 29 3.33 MW-011... 29 3.34 MW-012... 29 3.35 MW-013... 29 3.36 MW-014... 30 3.37 MW-015... 30 3.38 MW-016... 30 3.39 MW-017 ( )... 30 3.40 MW-018... 30 Page ii Copyright 2005 NTT All rights Reserved.
CSV XML 3.41 MW-019...30 3.42 MW-020...30 3.43 MW-021...31 3.44 MW-022...31 3.45 MW-023...31 3.46 MW-024...31 3.47 MW-101...31 3.48 MW-102...31 3.49 MW-103...32 3.50 MW-104...32 3.51 MW-105...32 3.52 MW-106...32 3.53 MW-201...32 3.54 MW-202...32 3.55 MW-203...32 3.56 MW-204...33 3.57 MW-205...33 3.58 MW-206...33 3.59 MW-207...33 3.60 MW-208...33 3.61 MW-209...33 3.62 MW-210...34 3.63 MW-211...34 3.64 MW-212...34 3.65 MW-213...34 3.66 MW-214...34 3.67 MW-215...34 3.68 MW-216...34 3.69 MW-217 ( )...35 3.70 MW-218...35 3.71 MW-219...35 3.72 MW-220...35 3.73 MW-221...35 3.74 MW-222...36 3.75 MW-223...36 3.76 MW-224...36 3.77 MW-301...36 3.78 MW-302...36 3.79 MW-303...36 3.80 MW-304...37 3.81 MW-305...37 3.82 MW-306...37 3.83 MW-307...37 3.84 MW-308...37 3.85 MW-309...37 3.86 MW-310...37 3.87 MW-311...38 Page iii
intra-mart 3.88 MW-312... 38 3.89 MW-313... 38 3.90 MW-314... 38 3.91 MW-315... 38 3.92 MW-316... 38 3.93 MW-317... 38 3.94 MW-318... 39 3.95 MW-319... 39 3.96 MW-320... 39 3.97 MW-321... 39 3.98 MW-322... 39 3.99 MW-323... 39 3.100 MW-401... 40 3.101 MW-402... 40 3.102 MW-403... 40 Page iv Copyright 2005 NTT All rights Reserved.
CSV XML Page v
1 1.1 1.2 intra-mart ver6.0 XML CSV CSV _ 1_1 OS Microsoft Windows2000 Server ServicePack 4 RedHat AS3 Solaris 9 Java Java 2 SDK, Standard Edition Version 1.4.2 1.3 XML XML XML XML XML XML
CSV XML 1.4 (csv2xml.zip) Windows ZIP RedHat Solaris #upzip csv2xml.zip Windows C: csv2xml RedHat Solaris /usr/local/csv2xml C: csv2xml <%IM_HOME%> C: csv2xml conf dtd lib csv2xmlrun.bat (Windows ) csv2xmlrun.sh RedHat Solaris sample data csv CSV xml XML log Page 7
2 2.1 2.1.1 csv2xml.properties <%IM_HOME%>/conf csv2xml.properties (CSV ) <%IM_HOME%> CSV_PATH CSV <%CSV_PATH%> XML_PATH XML <%XML_PATH%> LOG_PATH <%LOG_PATH%> Csv2Xml.properties #[Environment Setting] CSV_PATH=sample_data/csv/main XML_PATH=sample_data/xml LOG_PATH=sample_data/log 2.1.2 2.1.2.1 config.xml 2.2.1 CSV XML CSV <csv> <model-name> CSV <xml> <name> <type> 2.1.2.2 encoding.xml CSV <default-locale> 2.1.2.3 logging.properties SDK java.util.logging.logger logging.properties
CSV XML 2.2 CSV CSV CSV 2.2.1 CSV <%CSV_PATH%> CSV <%CSV_PATH%> company ** company_version_include.csv company_version_note.csv department.csv department_term_i18n_xx.csv department_term.csv company_category.csv post post.csv post_term_i18n_xx.csv public_group ** public_group_category.csv public_group.csv public_group_term_i18n_xx.csv public_group_set_version_include.csv public_group_set_version_note.csv user user.csv user_department_term.csv user_public_group_term.csv application_role.csv role.csv user_term_i18n_.csv user_term.csv Page 9
company(public_group) company public_group_set CSV ja 2_1 ja en company_01 company_02 company_03 <%CSV_PATH%> company company_01 company_category.csv company_version_include.csv company_version_note.csv department.csv department_term_i18n_ja.csv department_term_i18n_en.csv department_term.csv post post.csv post_term_i18n_ja.csv post_term_i18n_en.csv company_02 company_03
CSV XML 2.2.2 CSV 2.2.2.1-2.2.2.2 No 1 2 3 4 5 2.2.2.2 XML 2_2 (yyyy/mm/dd) int 0 true false 2.2.4 2.2.2.3 CSV comp_sample_01,zone,i,2000/01/01,9999/01/01 comp_sample_01,zone,e,2000/01/01,9999/01/01 comp_sample_01,attribute,o,2000/01/01,9999/01/01 Page 11
2.2.2.4 \ n sample_group,, n,1,,
CSV XML 2.2.3 2.2.3.1 2.2.3.1.1 company /**/ company_category.csv No 1 2 3 4 5 2.2.3.1.2 company /**/ post/post.csv No 1 2 3 2.2.3.1.3 company /**/ post/post_term_i18n_xx.csv No 1 2 3 4 2.2.3.1.4 company /**/ company_version_include.csv No 1 2 3 2.2.3.1.5 company /**/ company_version_note.csv No 1 2 3 4 Page 13
2.2.3.1.6 company /**/ department.csv No 1 2 3 2.2.3.1.7 company /**/ department_term.csv No 1 2 3 4 5 6 7 8 9 10 11 12 2.2.3.1.8 company /**/ department_term_i18n_xx.csv No 1 2 3 4 5 6 7 8
CSV XML 2.2.3.2 2.2.3.2.1 public_group /**/ public_group_category.csv No 1 2 3 4 5 2.2.3.2.2 public_group /**/ public_group.csv No 1 2 3 2.2.3.2.3 public_group /**public_group_term_i18n_xx.csv No 1 2 3 4 5 6 2.2.3.2.4 public_group /**/ public_group_set_version_include.csv No 1 2 3 2.2.3.2.5 public_group /**/ public_group_set_version_note.csv No 1 2 3 4 Page 15
2.2.3.3 2.2.3.3.1 user / user_department_term.csv No 1 2 3 4 5 6 7 2.2.3.3.2 user / user_public_group_term.csv No 1 2 3 4 5 2.2.3.3.3 user / application_role.csv No 1 2 2.2.3.3.4 user / role.csv No 1 2 4 5
CSV XML 2.2.3.3.5 user / user_term.csv No 1 2 3 4 5 6 7 8 9 10 11 12 13 14 2.2.3.3.6 user / user_term_i18n_xx.csv No 1 2 3 4 5 6 7 Page 17
2.2.3.3.7 user / user.csv No 1 2 3 4 5 6 7 8 9 10 false 11 12 13
CSV XML 2.2.4 CSV 2.2.4.1 CSV post.csv 0001 1 0003 AAA post_term_i18n_xx.csv 0002 2000/1/1 2020/1/1 0003 1998/1/1 9999/12/31 CSV 0002 0003 CSV 0003 CSV 0003 (post.csv) Page 19
2.2.4.2 XML CSV (company.xml) (post.xml) (public_group.xml) (account.xml) (profile.xml) department.csv department_term.csv department_term_i18n_xx.csv company_category.csv company_version_include.csv company_version_note.csv post.csv post_term_i18n_xx.csv public_group.csv public_group_term_i18n_xx.csv public_group_category.csv public_group_set_version_include.csv public_group_set_version_note.csv user.csv role.csv application_role.csv user_term.csv user_term_i18n_xx.csv user_department_term.csv user_public_group_term.csv 2.2.4.3 CSV 2.2.4.3.1 2.2.4.3.2 XML XML
CSV XML 2.2.4.4 2_1 2_1 CSV Page 21
2.3 Windows RedHat Solaris <%IM_HOME%>/RunTestData.bat sh <%IM_HOME%>/RunTestData.sh 2.3.1 : [XML ] 2006/01/18 22:45:46 jp.co.intra_mart.tools.bm5.csv2xml.common.logmanager info : [C:/temp/test_sample_data/xml/company.xml] 2006/01/18 22:45:46 jp.co.intra_mart.tools.bm5.csv2xml.common.logmanager info : [C:/temp/test_sample_data/xml/post.xml] 2006/01/18 22:45:46 jp.co.intra_mart.tools.bm5.csv2xml.common.logmanager info : [C:/temp/test_sample_data/xml/public_group.xml] 2006/01/18 22:45:46 jp.co.intra_mart.tools.bm5.csv2xml.common.logmanager info : [C:/temp/test_sample_data/xml/account.xml] 2006/01/18 22:45:46 jp.co.intra_mart.tools.bm5.csv2xml.common.logmanager info : [C:/temp/test_sample_data/xml/profile.xml] 2006/01/18 22:45:46 jp.co.intra_mart.tools.bm5.csv2xml.common.logmanager info : [XML ] <%XML_PATH%> 2_3 XML account.xml company.xml post.xml profile.xml public_group.xml
CSV XML 3 3.1 CW-001 [ ]CSV CSV [ ] <%IM_HOME%>/conf/csv2xml.properties CSV_PATH <%CSV_PATH%> 2.1 3.2 CW-002 [ ] CSV CSV <%CSV_PATH%>/company <%CSV_PATH%> company 2.1 XML 3.3 CW-003 [ ] CSV CSV <%CSV_PATH%>/ public_group XML <%CSV_PATH%> public_group 2.1 3.4 CW-004 [ ] CSV CSV <%CSV_PATH%>/ user XML XML <%CSV_PATH%> user 2.1 Page 23
3.5 CW-005 [ ] CSV CSV <%CSV_PATH%>/ company/<% %>/post <%CSV_PATH%>/ company/<% %> post 2.1 3.6 CW-006 <%CSV_PATH%>/ company <%CSV_PATH%>/ company <% %> 2.1 3.7 CW-007 <%CSV_PATH%>/ public_group <%CSV_PATH%>/ public_group <% %> 2.1 3.8 CW-100 [ ] i18n ja en 2.1
CSV XML 3.9 IW-001 [ ] CSV CSV 3.10 IW-002 [ ] CSV CSV 3.11 IW-003 [ ] CSV CSV 3.12 IW-004 [ ] CSV 3.13 IW-005 [ ] CSV : [IW-005] [C: csv2xml sample_data csv main company comp_sample_02 department_term_i18n_en.csv] 2006/04/18 17:01:26 jp.co.intra_mart.tools.bm5.csv2xml.common.logmanager warning : [MW-004] [ 8 ] =comp_sample_01, = 2006/04/18 17:01:26 jp.co.intra_mart.tools.bm5.csv2xml.common.logmanager info Page 25
3.14 IW-006 [ ] [ ] CSV 2.2.4.4 2.2.4.4 user_term_i18n_xx.csv user_term.csv user_term.csv user.csv user_term_i18n_xx.csv user_term.csv user.csv 3.15 OI-002 [ ] XML CSV CSV XML CSV CSV XML CSV 2.2.4.2XML CSV 3.16 OW-001 [ ] XML XML
CSV XML 3.17 DW-001 3.18 DW-002 3.19 DW-003 (yyyy/mm/dd) yyyy/mm/dd yyyy/mm/dd 3.20 DW-004 (1582/10/15-9999/12/31) 1582/10/15 9999/12/31 3.21 DW-005 < 3.22 DW-006 Page 27
3.23 MW-001 3.24 MW-002 3.25 MW-003 company/**/department.csv 3.26 MW-004 company/**/department.csv company/**/department_term.csv company/**/company_category.csv company/**/company_version_include.csv company/**/department.csv 3.27 MW-005 company/**/company_version_note.csv company/**/company_version_note.csv 3.28 MW-006 company/**/company_version_note.csv company /**/company_version_note.csv 3.29 MW-007 company /**/company_version_note.csv
CSV XML company /**/company_version_include.csv company /**/company_version_note.csv 3.30 MW-008 company /**/department_term.csv 3.31 MW-009 company/**/department_term.csv company/**/department_term_i18n.csv company/**/department_term.csv 3.32 MW-010 company/**/company_version_include.csv 3.33 MW-011 3.34 MW-012 company/**/company_version_include.csv 3.35 MW-013 company/**/company_version_include.csv Page 29
3.36 MW-014 company /**/department_term_i18n.csv 3.37 MW-015 3.38 MW-016 company/**/department.csv == 3.39 MW-017 ( ) company/**/department_term.csv company/**/company_category.csv company/**/department_term.csv 3.40 MW-018 company/**/company_version_include.csv 3.41 MW-019 company /**/department_term.csv 3.42 MW-020
CSV XML company/**/company_version_include.csv 3.43 MW-021 company/**/company_version_note.csv 3.44 MW-022 company/**/department_term.csv company/**/ company_version_include.csv company/**/department_term.csv 3.45 MW-023 company/**/department_term.csv company/**/ company_version_include.csv company/**/department_term.csv 3.46 MW-024 company/**/company_version_include.csv 3.47 MW-101 3.48 MW-102 company/**/post/post.csv Page 31
3.49 MW-103 company/**/post/post_term_i18n.csv company/**/post/post_term_i18n.csv company/**/post/post.csv 3.50 MW-104 company/**/post/post_term_i18n.csv 3.51 MW-105 company /**/post/post_term_i18n.csv 3.52 MW-106 3.53 MW-201 3.54 MW-202 3.55 MW-203 public_group/**/public_group.csv
CSV XML 3.56 MW-204 public_group/**/public_group.csv public_group/**/public_group_term_i18n.csv public_group/**/public_group_set_version_include.csv public_group/**/public_grouop_category.csv public_group/**/public_group.csv 3.57 MW-205 public_group/**/public_group _set_version_note.csv public_group/**/public_group_set_version_note.csv 3.58 MW-206 public_group/**/public_group_set _version_note.csv public_group/**/public_group_set _version_note.csv 3.59 MW-207 public_group/**/public_group_set _version_note.csv public_group /**/public_group_set_version_include.csv public_group/**/public_group_set_version_note.csv 3.60 MW-208 public_group/**/public_group_term_i18n.csv 3.61 MW-209 Page 33
3.62 MW-210 public_group/**/ public_group_set_version_include.csv 3.63 MW-211 3.64 MW-212 public_group/**/public_group_set_version_include.csv 3.65 MW-213 public_group/**/public_group_set_version_include.csv 3.66 MW-214 public_group/**/public_group_term_i18n.csv 3.67 MW-215 3.68 MW-216
CSV XML public_group/**/public_group.csv == 3.69 MW-217 ( ) public_group/**/public_group_term_i18n.csv public_group/**/ategory.csv public_group/**/public_group_term_i18n.csv 3.70 MW-218 public_group/**/public_group_set_version_include.csv 3.71 MW-219 public_group/**/public_group_term_i18n.csv 3.72 MW-220 public_group/**/public_group_set_version_include.csv 3.73 MW-221 public_group/**/public_group_set_version_note.csv Page 35
3.74 MW-222 public_group/**/public_group_term_i18n.csv public_group/**/public_group_set_version_include.csv public_group/**/ public_group_term_i18n.csv 3.75 MW-223 public_group/**/public_group_term_i18n.csv public_group/**/public_group_set_version_include.csv public_group/**/ public_group term_i18n.csv 3.76 MW-224 public_group/**/public_group_set_version_include.csv 3.77 MW-301 3.78 MW-302 3.79 MW-303 user/user_tem.csv
CSV XML 3.80 MW-304 user/user_tem.csv 3.81 MW-305 user/user_term.csv user/user_term_i18n.csv user/user_term.csv 3.82 MW-306 user/user_department.csv 3.83 MW-307 user/user_department.csv 3.84 MW-308 3.85 MW-309 3.86 MW-310 user/user_term_i18n.csv Page 37
3.87 MW-311 3.88 MW-312 user/user.csv 3.89 MW-313 user/user.csv user/user_department_term.csv user/user_public_group_term.csv user/user_term.csv user/user_term_i18n.csv user/user.csv 3.90 MW-314 user/user.csv 3.91 MW-315 3.92 MW-316 3.93 MW-317 user/user_department_term.csv
CSV XML 3.94 MW-318 user/user_department_term.csv 3.95 MW-319 3.96 MW-320 company/**/department_term.csv user/user_department_term.csv company/**/department_term.csv 3.97 MW-321 public_group/**/ public_group_term.csv user/user_public_group_term.csv public_group /**/public_group_term.csv 3.98 MW-322 user/user_public_group_term.csv 3.99 MW-323 user/user_public_group_term.csv Page 39
3.100 MW-401 3.101 MW-402 company/**/company_category.csv public_group/**/public_group_category.csv 3.102 MW-403 company/**/company_category.csv public_group/**/public_group_category.csv
CSV XML CSV XML Page 41