Difference between revisions of "JavOO"

From Wikili
Jump to: navigation, search
(→‎How to create a selection in Excel)
 
(21 intermediate revisions by 4 users not shown)
Line 4: Line 4:
 
JavOO is a small multithread secure server written in [[Java]] and working on Windows platform.
 
JavOO is a small multithread secure server written in [[Java]] and working on Windows platform.
  
−
It allows you to share MSAccess and MSExcel resources, which will be accessed through the native
+
It allows you to share Microsoft Access and Excel resources, which will be accessed by a distant client program through the native
−
ODBC driver of Windows.
+
ODBC driver of Windows. The client will be able to do SQL select queries on these resources.
 +
 
 +
  For example:
 +
  a laboratory in Madrid has an PC running on Windows and wants to make accessible its Access database to a collaborator in Strasbourg.
 +
  For that, install JavOO on the PC in Madrid, configure the path and access rights to the Access file
 +
  and open the port 18000 (and/or 18001 for SSL secure connection).
 +
  The computer in Strasbourg can now do SQL select queries on the remote Access database in Madrid.
  
 
==Download==
 
==Download==
 
The actual version is beta 1.0 .
 
The actual version is beta 1.0 .
  
−
You can download the Windows installer [http://www-bio3d-igbmc.u-strasbg.fr/~berthomg/JavOO/JavOOsetup.exe here].
+
<!--You can download the Windows installer-->
 +
To get Windows installer of JavOO, please send an email to [mailto:Guillaume.Berthommier@igbmc.u-strasbg.fr Guillaume.Berthommier@igbmc.u-strasbg.fr ]
  
−
==Installation==
+
==Installation and Configuration==
 
Double-click on the file ''JavOOsetup.exe'' and follow the instructions.
 
Double-click on the file ''JavOOsetup.exe'' and follow the instructions.
  
 
By default the program will be installed in the directory ''C:\Program Files\JavOO\'' .
 
By default the program will be installed in the directory ''C:\Program Files\JavOO\'' .
  
−
==Configuration==
+
===Interface Description===
 +
 
 +
This is what you get when you launch JavOO:
 +
 
 +
<center>[[Image:JavOO.png]]</center>
 +
 
 +
; STOP button (<span style="color:#F00;">1</span>) : Stop the server, disconnecting all clients.
 +
; START button (<span style="color:#F00;">2</span>) : Start the server, the server is ready to accept connections from clients.
 +
; Server Log Area (<span style="color:#F00;">3</span>) : Some actions executed by the server are logged in this text area.
 +
; Clear button (<span style="color:#F00;">4</span>) : This button clears the Server Log Area (<span style="color:#F00;font-weight:bold;">3</span>).
 +
; Save button (<span style="color:#F00;">5</span>) : This button is not used at the moment. In further development you will be able to save the content of the Server Log Area (<span style="color:#F00;font-weight:bold;">3</span>).
 +
; Config button (<span style="color:#F00;">6</span>) : This button display the configuration window. It will be described below.
 +
; Test Client button (<span style="color:#F00;">7</span>) : This button is used to test the server, the result output of the test will be shown in the Server Log Area (<span style="color:#F00;font-weight:bold;">3</span>).
 +
 
 +
 
 +
<!--
 +
Here is the content of the installation directory:
 +
*JavOO
 +
**lib
 +
***jaxen-1.1-beta-5.jar
 +
***jdom.jar
 +
***log4j-1.2.13.jar
 +
***microba-0.4.4.jar
 +
***swing-layout-1.0.jar
 +
**client_keystore
 +
**JavOO.ico
 +
**JavOO.jar
 +
**javoo.log: this is the application log, you can delete it if it takes too much space
 +
**javooconfig.default.xml : the default config file, in case you messed up with ''javooconfig.xml'' : delete ''javooconfig.xml'', do a copy of ''javooconfig.default.xml'' and rename it to ''javooconfig.xml''.
 +
**javooconfig.xml
 +
**README.TXT
 +
**server_keystore
 +
**testAccess.mdb
 +
**testExcel.xls
 +
**unins000.dat
 +
**unins000.exe
 +
-->
 +
The first thing you have to do is declaring one or more resources (Excel and/or Access files), which is describe in the Configuration Section.
 +
 
 +
===Configuration Section===
 
Now that you've installed JavOO, you need to add your Excel and/or Access resources.
 
Now that you've installed JavOO, you need to add your Excel and/or Access resources.
 +
For that, click on the <b>Config button (<span style="color:#F00;">6</span>)</b>, you get the <b>JavOO Server Configuration</b> window.
 +
 +
<center>[[Image:JavOOServerConfig.png]]</center>
 +
 +
; Resource list (<span style="color:#F00;">1</span>) : All defined resources are declared here. There are already three declared resources in JavOO that are here for testing purpose : see <b>Test Client button (<span style="color:#F00;">7</span>)</b> in the Interface Description section.
 +
; Add New Excel (<span style="color:#F00;">2</span>) : Add a new empty Excel resource. Don't forget to enter a proper name for the resource (see further).
 +
; Add New Access (<span style="color:#F00;">3</span>) : Add a new empty Access resource. Don't forget to enter a proper name for the resource (see further).
 +
; Edit (<span style="color:#F00;">4</span>) : Allows you to edit an existing resource declared in the <b>Resource list (<span style="color:#F00;">1</span>)</b>. For that, select a resource in the list then press the button.
 +
; Clone (<span style="color:#F00;">5</span>) : Allows you to clone an existing resource declared in the <b>Resource list (<span style="color:#F00;">1</span>)</b>. For that, select a resource in the list then press the button.
 +
; Remove (<span style="color:#F00;">6</span>) : Allows you to remove an existing resource declared in the <b>Resource list (<span style="color:#F00;">1</span>)</b>. For that, select a resource in the list then press the button.
 +
  
 +
 +
<!--
 
In the install directory you'll find a file named '''''javooconfig.xml'''''.  
 
In the install directory you'll find a file named '''''javooconfig.xml'''''.  
 
This file is in [[XML]] format. It defines a root element '''''serverconfig''''' in which an element '''''resources''''' is defined.
 
This file is in [[XML]] format. It defines a root element '''''serverconfig''''' in which an element '''''resources''''' is defined.
Line 26: Line 85:
  
 
You can edit this file with you favorite text editor.
 
You can edit this file with you favorite text editor.
 +
  
 
===Excel file===
 
===Excel file===
Line 36: Line 96:
 
                     readonly="true" />
 
                     readonly="true" />
  
 +
-->
 +
 +
====Excel File====
 +
 +
*Usually people do not define username and password for Excel files, so if your file doesn't have this kind of protection you can leave them blank.
 
*The declaration of an Excel resource is a bit specific, let's see:
 
*The declaration of an Excel resource is a bit specific, let's see:
 
**An Excel file has one or many sheets, each one has a specific name, depending on the localisation of your computer, ie "Feuil1" in french, "Sheet1" in english, "Tabelle1" in german, etc. These names can be edited. Because many sheets can be accessible, you will have to define the proper name in the '''''sheet''''' attribute of the Excel resource.
 
**An Excel file has one or many sheets, each one has a specific name, depending on the localisation of your computer, ie "Feuil1" in french, "Sheet1" in english, "Tabelle1" in german, etc. These names can be edited. Because many sheets can be accessible, you will have to define the proper name in the '''''sheet''''' attribute of the Excel resource.
−
**Now the tricky part: the '''''selection''''' is a specific zone of you sheet, containing the header line of the table and it's content. Here is an example of a selection.
+
**Now the tricky part: the '''''selection''''' is a specific region of you sheet, containing the header line of the table and it's content. Here is an example of a selection:
 +
 
 +
 
  
 
{| border="1"
 
{| border="1"
Line 53: Line 120:
 
  |}
 
  |}
  
−
The nice part here is that you can define one or many selections in the same sheet, but you will have to declare as many resources as the number of selections you want to be accessible.
 
  
−
====How to create a selection in Excel====
+
The nice part here is that you can define one or many selections in the same sheet, but you will have to declare as many Excel resources as the number of selections you want to be accessible.
−
#First select a zone of your sheet containing the '''''header''''' and the '''''data''''' of your table.
+
 
 +
=====How to create a selection in Excel=====
 +
#First select a region of your sheet containing the '''''header''''' and the '''''data''''' of your table.
 
#Then, in the menu, choose '''Insert''' -> '''Name''' -> '''Define'''.
 
#Then, in the menu, choose '''Insert''' -> '''Name''' -> '''Define'''.
 
#A new window should appear, enter the name you want for the selection, press '''OK''' then '''Close'''.
 
#A new window should appear, enter the name you want for the selection, press '''OK''' then '''Close'''.
 
#Do not forget to save the file.
 
#Do not forget to save the file.
  
−
===Access file===
+
====Access file====
 +
<!--
 
   <access_resource name="testAccess"  
 
   <access_resource name="testAccess"  
 
                     filepath="C:/path/to/the/file.mdb"  
 
                     filepath="C:/path/to/the/file.mdb"  
Line 67: Line 136:
 
                     password="userpassword"  
 
                     password="userpassword"  
 
                     readonly="true" />
 
                     readonly="true" />
 +
-->
  
−
*Usually people do not define username and password for Excel files, so if your file doesn't have this kind of protection you can
+
==Troubleshooting==
−
leave them blank.
+
If you any problem, please send me an email at [mailto:Guillaume.Berthommier@igbmc.u-strasbg.fr?subject=On%20JavaOO <Guillaume.Berthommier@igbmc.u-strasbg.fr> ] .
−
 
 
−
==Usage==
 
−
Here is a screenshot of the JavOO application: [[Image:JavOO.png]]
 
−
#'''STOP button''': Stop the server, deconnecting all clients.
 
−
#'''START button''': Start the server, the server is ready to accept connections from clients.
 
−
#'''Server Log Area''': Some actions executed by the server are logged in this text area.
 
−
#'''Clear button''': This button clears the Server Log Area ('''3''').
 
−
#'''Save button''': This button will be used for further development.
 
−
#'''Config button''': This button will be used for further development.
 
−
#'''Test Client button''': This button is used to test the server, the result output of the test will be shown in the Server Log Area ('''3''').
 

Latest revision as of 14:49, 31 May 2007

JavOO : Java Odbc for Office.

Introduction

JavOO is a small multithread secure server written in Java and working on Windows platform.

It allows you to share Microsoft Access and Excel resources, which will be accessed by a distant client program through the native ODBC driver of Windows. The client will be able to do SQL select queries on these resources. 

 For example:
 a laboratory in Madrid has an PC running on Windows and wants to make accessible its Access database to a collaborator in Strasbourg. 
 For that, install JavOO on the PC in Madrid, configure the path and access rights to the Access file 
 and open the port 18000 (and/or 18001 for SSL secure connection).
 The computer in Strasbourg can now do SQL select queries on the remote Access database in Madrid.

Download

The actual version is beta 1.0 .

To get Windows installer of JavOO, please send an email to Guillaume.Berthommier@igbmc.u-strasbg.fr

Installation and Configuration

Double-click on the file JavOOsetup.exe and follow the instructions.

By default the program will be installed in the directory C:\Program Files\JavOO\ .

Interface Description

This is what you get when you launch JavOO:

Error creating thumbnail: Unable to save thumbnail to destination
STOP button (1) 
Stop the server, disconnecting all clients.
START button (2) 
Start the server, the server is ready to accept connections from clients.
Server Log Area (3) 
Some actions executed by the server are logged in this text area.
Clear button (4) 
This button clears the Server Log Area (3).
Save button (5) 
This button is not used at the moment. In further development you will be able to save the content of the Server Log Area (3).
Config button (6) 
This button display the configuration window. It will be described below.
Test Client button (7) 
This button is used to test the server, the result output of the test will be shown in the Server Log Area (3).


The first thing you have to do is declaring one or more resources (Excel and/or Access files), which is describe in the Configuration Section.

Configuration Section

Now that you've installed JavOO, you need to add your Excel and/or Access resources. For that, click on the Config button (6), you get the JavOO Server Configuration window.

Error creating thumbnail: Unable to save thumbnail to destination
Resource list (1) 
All defined resources are declared here. There are already three declared resources in JavOO that are here for testing purpose : see Test Client button (7) in the Interface Description section.
Add New Excel (2) 
Add a new empty Excel resource. Don't forget to enter a proper name for the resource (see further).
Add New Access (3) 
Add a new empty Access resource. Don't forget to enter a proper name for the resource (see further).
Edit (4) 
Allows you to edit an existing resource declared in the Resource list (1). For that, select a resource in the list then press the button.
Clone (5) 
Allows you to clone an existing resource declared in the Resource list (1). For that, select a resource in the list then press the button.
Remove (6) 
Allows you to remove an existing resource declared in the Resource list (1). For that, select a resource in the list then press the button.



Excel File

  • Usually people do not define username and password for Excel files, so if your file doesn't have this kind of protection you can leave them blank.
  • The declaration of an Excel resource is a bit specific, let's see:
    • An Excel file has one or many sheets, each one has a specific name, depending on the localisation of your computer, ie "Feuil1" in french, "Sheet1" in english, "Tabelle1" in german, etc. These names can be edited. Because many sheets can be accessible, you will have to define the proper name in the sheet attribute of the Excel resource.
    • Now the tricky part: the selection is a specific region of you sheet, containing the header line of the table and it's content. Here is an example of a selection:


Name Age Gender
Bob 30 Male
Jane 28 Female
Cindy 45 Female


The nice part here is that you can define one or many selections in the same sheet, but you will have to declare as many Excel resources as the number of selections you want to be accessible.

How to create a selection in Excel
  1. First select a region of your sheet containing the header and the data of your table.
  2. Then, in the menu, choose Insert -> Name -> Define.
  3. A new window should appear, enter the name you want for the selection, press OK then Close.
  4. Do not forget to save the file.

Access file

Troubleshooting

If you any problem, please send me an email at <Guillaume.Berthommier@igbmc.u-strasbg.fr> .

Retrieved from "http://lbgi.fr/wikili/index.php?title=JavOO&oldid=1692"