CSV XML 2007 1 18
2007/1/18
CSV XML 1...4 1.1...4 1.2...4 1.3...4 1.4...5 2...6 2.1...6 2.1.1 csv2xml.properties...6 2.2 CSV...7 2.2.1 CSV...7 2.2.2 CSV...9 2.2.2.1...9 2.2.2.2...9 2.2.2.3 CSV...9 2.2.2.4...10 2.2.3...11 2.2.3.1...11 2.2.3.1.1 company /**/ company_category.csv...11 2.2.3.1.2 company /**/ post/post.csv...11 2.2.3.1.3 company /**/ post/post_term_i18n_ja.csv...11 2.2.3.1.4 company /**/ company_version_include.csv...11 2.2.3.1.5 company /**/ company_version_note.csv...11 2.2.3.1.6 company /**/ department.csv...12 2.2.3.1.7 company /**/ department_term.csv...12 2.2.3.1.8 company /**/ department_term_i18n_ja.csv...12 2.2.3.2...13 2.2.3.2.1 public_group /**/ public_group_category.csv...13 2.2.3.2.2 public_group /**/ public_group.csv...13 2.2.3.2.3 public_group /**public_group_term_i18n_ja.csv...13 2.2.3.2.4 public_group /**/ public_group_set_version_include.csv...13 2.2.3.2.5 public_group /**/ public_group_set_version_note.csv...13 2.2.3.3...14 2.2.3.3.1 user / user_department_term.csv...14 2.2.3.3.2 user / user_public_group_term.csv...14 2.2.3.3.3 user / application_role.csv...14 2.2.3.3.4 user / role.csv...14 2.2.3.3.5 user / user_term.csv...15 2.2.3.3.6 user / user_term_i18n_ja.csv...15 2.2.3.3.7 user / user.csv...16 2.2.4 CSV...17 2.2.4.1...17 2.2.4.2 XML CSV...18 2.2.4.3...18 2.2.4.3.1...18 2.2.4.3.2...18 2.2.4.4...19 Page i
intra-mart 2.3... 20 2.3.1... 20 Page ii Copyright 2005 NTT All rights Reserved.
CSV XML Page iii
1 1.1 intra-mart ver6.0 XML CSV CSV 1582/10/15 9999/12/31 1.2 _ 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 5
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
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_ja.csv department_term.csv company_category.csv post post.csv post_term_i18n_ja.csv public_group ** public_group_category.csv public_group.csv public_group_term_i18n_ja.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_ja.csv user_term.csv Page 7
company(public_group) company public_group_set 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.csv post post.csv post_term_i18n_ja.csv company_02 company_03
CSV XML 2.2.2 CSV 2.2.2.1-2.2.2.2 1 2 3 4 5 2.2.2.2 XML 2_2 int 0 truefalse 2.2.4 2.2.3 2.2.2.3 CSV comp_sample_01,zone,i, 1582/10/15,9999/12/31 comp_sample_01,zone,e, 1582/10/15,9999/12/31 comp_sample_01,attribute,o, 1582/10/15,9999/12/31 Page 9
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 1 2 3 4 5 2.2.3.1.2 company /**/ post/post.csv 1 2 3 2.2.3.1.3 company /**/ post/post_term_i18n_ja.csv 1 2 3 4 2.2.3.1.4 company /**/ company_version_include.csv 1 2 3 2.2.3.1.5 company /**/ company_version_note.csv 1 2 3 4 Page 11
2.2.3.1.6 company /**/ department.csv 1 2 3 2.2.3.1.7 company /**/ department_term.csv 1 2 3 4 5 6 7 8 9 10 11 12 2.2.3.1.8 company /**/ department_term_i18n_ja.csv 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 1 2 3 4 5 2.2.3.2.2 public_group /**/ public_group.csv 1 2 3 2.2.3.2.3 public_group /**public_group_term_i18n_ja.csv 1 2 3 4 5 6 2.2.3.2.4 public_group /**/ public_group_set_version_include.csv 1 2 3 2.2.3.2.5 public_group /**/ public_group_set_version_note.csv 1 2 3 4 Page 13
2.2.3.3 2.2.3.3.1 user / user_department_term.csv 1 2 3 4 5 6 7 2.2.3.3.2 user / user_public_group_term.csv 1 2 3 4 5 2.2.3.3.3 user / application_role.csv 1 2 2.2.3.3.4 user / role.csv 1 2 4 5
CSV XML 2.2.3.3.5 user / user_term.csv 1 2 3 4 5 6 7 8 9 10 11 12 13 14 2.2.3.3.6 user / user_term_i18n_ja.csv 1 2 3 4 5 6 7 Page 15
2.2.3.3.7 user / user.csv 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_ja.csv 0002 1582/10/15 9999/12/31 0003 1582/10/15 9999/12/31 CSV0002 0003 CSV 0003 CSV0003 (post.csv) Page 17
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_ja.csv company_category.csv company_version_include.csv company_version_note.csv post.csv post_term_i18n_ja.csv public_group.csv public_group_term_i18n_ja.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_ja.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 19
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 CSV XML Page 21