<4D F736F F D C8E868AD320895E97418CF092CA95AA96EC2E646F63>

Size: px

Start display at page:

Download "<4D F736F F D C8E868AD320895E97418CF092CA95AA96EC2E646F63>"

ともみたておか
4 years ago
Views:

1 JICACRANES Results of Field Survey on Padma Bridge Project JICA

2 JICA CRANES JICA CRANES CRANES with Google Earth

3 CRANES Web GoogleEarth Web CRANES export import

4 JICACRANES OSWindows ServerWindows Server IIS Sybase SQL Anywhere JRE 1.4 BASP21.Net Framework2.0 Zip.exeInfo-Zip OSWindows XPWindows Vista Google Earth PHPWeb.Net Framework2.0 XML

5 JICACRANESCD client web CRANESGoogleEarthPHP install client Excel install server CRANES doc server bin CRANES server bin conf CRANES server bin lib CRANES server db SQL SQL server web CRANESWeb server document server log server request CRANES server temp CRANES server treedata server db backup JICACRANES CRANES IIS SybaseSQLAnywhere JRE BASP.Net Framework

6 CRANES CRANESHOME C CRANES servercraneshome CRANES CDserverweb%CRANESHOME% IUSRXXXIWAMXXX XXX %CRANESHOME% documents %CRANESHOME% log %CRANESHOME% request %CRANESHOME% temp %CRANESHOME% treedata Info-ZipzipxN.zipzip.exe%CRANESHOME% bin

7 Web IISC: Inetpub wwwrootcranes CD server web IIS IIStemp

8 IUSRXXXIWAMXXX XXX IIS temp CRANES

9 %CRANESHOME% bin CranesGEvbs

11 SybaseCentral InteractiveSQL SQL SQL%CRANES_HOME% db SQL create_tables.sql SybaseCentral SPACEINFO Spaceid ID Spacename Mainlanguage jpen Systemversion Range KMLrange Indate SybaseCentral

12 USERMST Spaceid Userid Usertype Password Username Validflg ID ID %CRANES_HOME% bin cranes-config.xml CRANES <?xml version="" encoding="utf-"?> <CranesConfigXml>   <Driver>Adaptive Server Anywhere </Driver>  <Uid>dba</Uid>  <Password>sql</Password>  <Database>cranes-ge</Database>  <Host>localhost</Host>  <Port></Port>  <LogFolder>C: CRANES server log</logfolder> </CranesConfigXml> %CRANES_HOME% bin conf cranes.properties CRANES cranes.database.cranes1.connection.url=jdbc:sybase:tds:localhost:

13 IndexCalc.cmd CRANES set JAVA_HOME=C: Program Files Java jre1. JRE C cd "%CRANES_HOME% bin" CRANES TreeAutoMake.cmd set JAVA_HOME=C: Program Files Java jre JRE C cd "%CRANES_HOME% bin" CRANES

14 %CRANES?_HOME% bin CranesGE.vbs CRANES ' ' ' '' C_DBDriver --- ODBC Const C_DBDriver = "Adaptive Server Anywhere 8.0" '' C_DBUser --- DBID Const C_DBUser = "dba" '' C_DBPassword --- DB Const C_DBPassword = "sql" '' C_DBDatabase --- Const C_DBDatabase = "cranes-ge" '' C_DBHost --- Const C_DBHost = "localhost" '' C_DBPort --- Const C_DBPort = "" '' C_LOGDir --- Const C_LOGDir = "C: CRANES server log" '' C_MakeTreeProg --- Const C_MakeTreeProg = "C: CRANES server bin TreeAutoMake.cmd"

15 IIS/CranesGE/include/setenv.inc CRANESWeb <SCRIPT LANGUAGE=VBScript RUNAT=Server> ' ' setenv.inc ' ' ' ' ' ' IIS ' '' C_DBDriver --- ODBC Const C_DBDriver = "Adaptive Server Anywhere " '' C_DBUser --- DBID Const C_DBUser = "dba" '' C_DBPassword --- DB Const C_DBPassword = "sql" '' C_DBDatabase --- Const C_DBDatabase = "cranes-ge" '' C_DBHost --- Const C_DBHost = "localhost" '' C_DBPort --- Const C_DBPort = "" </SCRIPT>

GoogleEarthCOM C ProgramFiles Google GoogleEarthGoogleEarth Microsoft.

16 JICACRANES GoogleEarth GoogleEarthhttp://earth.google.com/ GoogleEartrhGoogleEarthCOMAPI GoogleEarthCOMAPIGoogleEarth GoogleEarthCOM C ProgramFiles Google GoogleEarthGoogleEarth Microsoft.NET Framework PCMicrosoft.NET Framework CRANES with Google Earth Installer.msi CRANESCD install client

PATH C: Program Files CRANES CRANES with Google Earth CRANES with Google Earth.exe.config KML CRANES with Google Earth.exe.config <applicationsettings> <CRANES_with_Google_Earth.My.

18 PATH C: Program Files CRANES CRANES with Google Earth CRANES with Google Earth.exe.config KML CRANES with Google Earth.exe.config <applicationsettings> <CRANES_with_Google_Earth.My.MySettings> <setting name="kmlpath" serializeas="string"> <value>c: CRANES kml</value> </setting> <setting name="docpath" serializeas="string"> <value>c: CRANES doc</value> </setting> <setting name="xmlpath" serializeas="string"> <value>c: CRANES xml</value> </setting> </CRANES_with_Google_Earth.My.MySettings> </applicationsettings>

KML CRANESKML <setting name="kmlpath" serializeas="string"> <value>c: CRANES kml</value> </setting> CRANES <setting name=" docpath " serializeas="string"> <value>c: CRANES doc</value> </setting>

19 KML CRANESKML <setting name="kmlpath" serializeas="string"> <value>c: CRANES kml</value> </setting> CRANES <setting name=" docpath " serializeas="string"> <value>c: CRANES doc</value> </setting> CRANES <setting name=" xmlpath " serializeas="string"> <value>c: CRANES xml</value> </setting> Web GoogleEarthPHPWeb ApacheWebPHP XAMPPLite XAMPPLite xampplitewinaexe Extract Windows Vista Program Files

20 xampplite xampplitexamppcontrolexe XAMPP Apache Apache OK StartApache Running Apache XAMPP

21 XAMPP xampplite htdocs htdocs cranes cranes PHP treeview.php PHPCRANES CD client web

22 CRANES <header> <title></title> <venue></venue> <date></date> <organizer></organizer> <longitude></longitude> <latitude></latitude> </header> <general></general> <body> <opinion> <type>opinion category</type> <name></name> <address></address> <organization></organization> <occupation></occupation> <summary></summary> <content></content> <response></response> <longitude></longitude> <latitude></latitude> <etc></etc> </opinion> <opinion></opinion> </body> <others></others> <opinion> </opinion> Excel Excel Excel CRANES CD installclientminutesxls

23 ADDOPINION DELETEOPINION SAVE TITLE VENUE DATE ORGANIZER LONGITUDE LATITUDE GENERAL

24 OPINION opinioncategory NAME ADDRESS ORGANIZATION OCCUPATION SUMMARY CONTENT RESPONSE LONGITUDE LATITUDE ETC OTHERS

25 CRANES CRANESCRANES Web IDLogin

26 CRANES a b P c P.kml KML.xml dexport

27 eimport f g CRANES

28 zip KMLzip

29 export XMLXML XMLNotepad opinion

30 import CRANES

31 XML GoogleEarth Google Earth

32 C: CRANES xml GoogleEarth GoogleEarth GoogleEarth GoogleEarth Google Earth

33 Google Earth Apache

OfficeAPI_sample_program_joyzo_ver1

OfficeAPI_sample_program_joyzo_ver1 Office 8 API 1 ... 2 1... 3 1.1... 3 1.2... 4 1.3... 5 1.4... 5 1.5... 6 1.6... 7 1.6.1... 7 1.6.2... 8 1.6.3... 9 1.6.4... 10 2... 11 2.1... 11 2.1.1 CSV... 11 2.1.2... 12 2.2... 13 2.2.1 CSV... 13 2.2.2...