Difference between revisions of "JavOO"

From Wikili
Jump to: navigation, search
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 by a distant client program 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. The client will be able to do SQL select queries on these resources.
 
ODBC driver of Windows. The client will be able to do SQL select queries on these resources.
  
Line 10: Line 10:
 
   a laboratory in Madrid has an PC running on Windows and wants to make accessible its Access database to a collaborator in Strasbourg.  
 
   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  
 
   For that, install JavOO on the PC in Madrid, configure the path and access rights to the Access file  
−
   and open the port 18000 (or 18001 for SSL secure connection).
+
   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.
 
   The computer in Strasbourg can now do SQL select queries on the remote Access database in Madrid.
  
Line 23: Line 23:
  
 
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\'' .
 +
 +
===Interface Description===
 +
 +
This is what you get when you launch JavOO:
 +
 +
[[Image:JavOO.png]]
 +
 +
; 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>).
 +
  
 
<!--
 
<!--
Line 46: Line 61:
 
**unins000.exe
 
**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.
  
−
Then, you have to:
+
===Configuration Section===
−
#Give a name for your resource.
 
−
#Declare the path to your file.
 
−
#Declare the name of the sheet and region you want to export (if it is an Excel file).
 
−
 
 
−
==Configuration==
 
 
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.
  
 +
<!--
 
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 71: Line 84:
 
                     password="userpassword"  
 
                     password="userpassword"  
 
                     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.
 
*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.
Line 95: Line 112:
 
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.
 
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====
+
=====How to create a selection in Excel=====
 
#First select a region of your sheet containing the '''''header''''' and the '''''data''''' of your table.
 
#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'''.
Line 101: Line 118:
 
#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 107: Line 125:
 
                     password="userpassword"  
 
                     password="userpassword"  
 
                     readonly="true" />
 
                     readonly="true" />
−
 
+
-->
−
 
 
−
==Usage==
 
−
Here is a screenshot of the JavOO application:
 
−
 
 
−
[[Image:JavOO.png]]
 
−
 
 
−
 
 
−
 
 
−
; 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 soon described.
 
−
; 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>).
 
  
 
==Troubleshooting==
 
==Troubleshooting==
 
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> ] .
 
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> ] .

Revision as of 16:05, 30 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.


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=1690"