GRASS-Wiki - User contributions [en]

GRASS-Wiki

2018-02-21T22:41:50Z

⚠️Epifanio:

__NOTOC__
{| width="100%"
|-
| width="68%" style="vertical-align:top" |
<div style="margin:0; margin-right:10px; border:1px solid #dfdfdf; background-color:#f8f8ff;">

<div style="padding:0.3em 1em 0.7em 1em;">

[[Image:grasslogo_vector_small.png|right|link=https://grass.osgeo.org]]

=== Welcome to the GRASS GIS Users Wiki ===

{{website|documentation/general-overview|'''GRASS GIS'''}} is a [http://en.wikipedia.org/wiki/Geographic_information_system Geographic Information System] used for geospatial data management and analysis, image processing, graphics/map production, spatial modeling, and visualization.

On this Wiki, you can get and contribute to GRASS related information, documents and community provided add-ons programs. To edit here, you need to register and login first (see top right link).

For GRASS at a glance, see [[core features]]. For usage examples, see the [https://grass.osgeo.org/screenshots screenshots gallery] and [[Applications]].

Wiki read-only mirror (updated daily): http://grass.fsv.cvut.cz/wiki-mirror/
</div>
</div>

<div style="margin:0; margin-top:10px; margin-right:10px; border:1px solid #dfdfdf; padding:0em 1em 1em 1em; background-color:#FFE5E5;">
'''What's hot:'''
* <font size="+1">[https://trac.osgeo.org/grass/wiki/Release/7.4.0-News '''GRASS GIS 7.4.0''' is available!]</font> {{bullet}} [https://grass.osgeo.org/download/software/#g74x] {{bullet}} [https://trac.osgeo.org/grass/report/19 report any problems]
* <font size="+1">[[GRASS Community Sprint Bonn 2018]]</font>
* [http://trac.osgeo.org/grass/wiki/Grass7/NewFeatures List of new features in GRASS GIS 7] ([https://grass.osgeo.org/download/software/#g72x help testing])
* [https://grass.osgeo.org/news/58/15/GRASS-GIS-6-4-6-released/ '''GRASS GIS 6.4.6''' is here!] {{bullet}} [https://grass.osgeo.org/download download]

* Try the [[Quick wxGUI tutorial]]
* Temporal support and other new [[Initiatives]]
</div>

<div style="margin:0; margin-top:10px; margin-right:10px; border:1px solid #dfdfdf; padding:0em 1em 1em 1em; background-color:#f8f8ff;">
==== User Documentation and Support ====
* [[GRASS Help|GRASS Help and Getting Started]]
* [[GRASS Documents|In depth GRASS Documentation]]
* [[Installation Guide]] for precompiled binaries
* '''[[Faq|FAQ]] - Frequently Asked Questions'''
* [[Applications]] - use cases of GRASS in various disciplines
* [[wxGUI]] - Graphical User Interface based on wxPython
</div>

<div style="margin:0; margin-top:10px; margin-right:10px; border:1px solid #dfdfdf; padding:0em 1em 1em 1em; background-color:#f8f8ff;">

==== Community ====
* [[GRASS Community]]: Getting in touch
* [[Applications|Research applications]]: What people are doing with GRASS
* [[GRASS migration hints|Migrating to GRASS]]
* [[GRASS Blogger]]
* Get involved: [[Project jobs]]
* [https://grass.osgeo.org/wiki/Special:Recentchanges?feed=rss RSS feed] of recent changes of this Wiki
</div>

<div>Have a look at the GRASS GIS users worldwide [https://grass.osgeo.org/community GRASS GIS User Online]. If you operate a GRASS GIS installation, you are welcome to enter your user data there.
</div>

<div><p>''[[GRASS-Wiki:Language policy|Translate this Wiki]]''</p></div>


| width="38%" style="vertical-align:top" |
<div style="margin:0; border:1px solid #dfdfdf; padding:0em 1em 1em 1em; background-color:#f8f8ff;">
[[Image:osgeo_logo.png|center|220px|link=http://www.osgeo.org]]
<center>[http://www.osgeo.org OSGeo] Foundation Project</center>
</div>

<div style="margin:0; margin-top:10px; border:1px solid #dfdfdf; padding:1em 1em 1em 1em; background-color:#f8f8ff;">
[[Image:Btn_donate_SM.gif|center|link=https://grass.osgeo.org/donations/]]
</div>

<div style="margin:0; margin-top:10px; border:1px solid #dfdfdf; padding: 0em 1em 1em 1em; background-color:#f8f8ff;">
* [https://grass.osgeo.org/screenshots GRASS Screenshots]
* [https://trac.osgeo.org SVN/trac] Source Code Repository
* [https://grass.osgeo.org/support/mailing-lists Mailing lists] and [[IRC]]
* [https://trac.osgeo.org/grass/ Report errors or wishes]
* [https://svn.osgeo.org/grass/grass/branches/releasebranch_7_0/COPYING Licensed under GNU GPL]
</div>

<div style="margin:0; margin-top:10px; border:1px solid #dfdfdf; padding:0em 1em 1em 1em; background-color:#f8f8ff;">

==== Download ====
* [https://grass.osgeo.org/download Source code and binaries]
* '''[[AddOns]]'''
* [[Promotional material]]
* [[Sample datasets]]
* [[Global datasets]]
</div>

<div style="margin:0; margin-top:10px; border:1px solid #dfdfdf; padding:0em 1em 1em 1em; background-color:#f8f8ff;">

==== Development ====
* [[Compile and Install]] of Source Code
* [[Development|GRASS Development]] intro
* [http://trac.osgeo.org/grass/wiki GRASS-trac]: the development Wiki, bugtracker, source code browser
* [[Release Roadmap]]
* [[GRASS 7 ideas collection]]
* [[GRASS SoC Ideas|Google Summer of Code ideas collection]]
* [http://trac.osgeo.org/grass/wiki/HowToContribute How to contribute to GRASS development] (getting write access and such)
</div>


|}

R.basin

2013-12-08T15:14:34Z

⚠️Epifanio: /* References */

== Introduction ==

The module {{AddonCmd|r.basin}} has been designed to perform the delineation and the morphometric characterization of a given basin, on the basis of an elevation raster map and the coordinates of the outlet.
Please note that it is designed to work only in projected coordinates.
Here a tutorial based on NC sample dataset is presented.

== Preparation ==

As a first step, we set the computational region to match the elevation raster map:

<pre>
g.region rast=elevation@PERMANENT -ap
projection: 99 (Lambert Conformal Conic)
zone: 0
datum: nad83
ellipsoid: a=6378137 es=0.006694380022900787
north: 228500
south: 215000
west: 630000
east: 645000
nsres: 10
ewres: 10
rows: 1350
cols: 1500
cells: 2025000
</pre>

For the basin's delineation, a pair of coordinates is required. Usually coordinates belonging to the natural river network don't exactly match with the calculated stream network. What we should do is to calculate the stream network first, and then to find the coordinates on the calculated stream network closest to the coordinates belonging to the natural stream network.

<pre>
# Calculate flow accumulation map (MFD)
r.watershed -af elevation=elevation@PERMANENT accumulation=accum

# Extract the stream network
r.stream.extract elevation=elevation@PERMANENT accumulation=accum threshold=20 stream_rast=stream_network stream_vect=streams
</pre>

We no longer need the accumulation map:

<pre>
g.remove rast=accum
</pre>

Now that we have the calculated stream network, we should choose a pair of coordinates for the outlet belonging to it. Let's choose:

<pre>
easting=638855.136465 northing=223565.144462
</pre>

We no longer need the stream network map:

<pre>
g.remove rast=stream_network
</pre>

== Preparation for multiple basins' analysis ==

If there are a lot of basins to be analysed, the coordinate pairs of the intersections between the calculated stream network and basins (outlet points) can be found by:

<pre>
# Convert basins polygon vector boundaries to lines
v.type input=basinspoly output=basinsline type=boundary,line

# Patch basins lines with stream network
v.patch input=basinsline,streams output=basins_streams

# Find cross points at intersections
v.clean input=basins_streams output=basins_streams_clean error=crosspoints_err tool=break

# Add categories to cross points vector
v.category input=crosspoints_err output=crosspoints

# Add table to cross points vector with columns for category, x and y coordinates
v.db.addtable map=crosspoints columns="cat integer,xcoor double precision, ycoor double precision"

# Upload category to cross points attribute table
v.to.db map=crosspoints option=cat columns=cat

# Upload x and y coordinates to cross points attribute table
v.to.db map=crosspoints option=coor columns=xcoor,ycoor
</pre>

At this point we can create a text file called ''crosspoints'' with the coordinates in this form:

<pre>
xcoor1 ycoor1
xcoor2 ycoor2
xcoor3 ycoor3
...
</pre>

Now we can parse this coordinates file in order to create a new file called ''commands'' in which we'll have the r.basin commands for each sub-watershed, ready to be run in a GRASS session. Let's create a script in python for parsing:

<pre>
#!/usr/bin/env python

# Open the ''crosspoints'' text file to read the coordinates
fin = open("crosspoints","r")

# Create the ''commands'' text file
fout = open("commands","w")

# Read the ''crosspoints'' lines
linesout = (line.rstrip().split() for line in fin)

# Build the r.basin command
# Put your threshold parameter instead of threshold=10000 and the name of your DEM instead of map=elevation
cmd = 'r.basin map=elevation prefix=bas%s easting=%s northing=%s threshold=10000\n'

# Write the file ''commands''
fout.writelines(cmd % (n, easting, northing) for n,(easting,northing) in enumerate(linesout))
</pre>

This is a Python script, it is supposed to run externally from GRASS GIS. Save this script as ''parsing.py'' in a separate folder on your Desktop, and put the file ''crosspoints'' in such folder. To run it, open a terminal and type:

<pre>
cd yourfolder
python parsing.py
</pre>

Now in the same folder you will find the file ''commands'', in which we have the r.basin commands to run in GRASS.

== Usage ==

We can run r.basin:

<pre>
r.basin map=elevation@PERMANENT prefix=out easting=636654.791181 northing=218824.126649 threshold=20
</pre>

Prefix parameter is a string given by the user in order to distinguish all the maps produced by every run of the program, i.e. every set of outlet's coordinates. Prefix must start with a letter.

Threshold is the same parameter given in r.watershed and r.stream.extract. Physically, it means the number of cells that determine "where the river begins". (This is an open issue for the hydrological science and a wide literature has been produced on the topic). Threshold value is usually determined by trials and errors. r.basin has a flag -a, which uses an authomatic value of threshold, corresponding to 1km^2. Such value comes from literature and is usually suitable for Italian territory, but could be definitely wrong for other territories.
In order to determine the threshold, see also {{AddonCmd|r.threshold}} and {{AddonCmd|r.stream.preview}}.

The output of r.basin consists of:

* Several morphometric parameters, which are printed in terminal and also stored in a csv file called out_elevation_parameters.csv, in the working directory;
* Maps;
* Plots.

== Morphometric parameters ==

The main parameters are:

* The coordinates of the vertices of the '''rectangle containing the basin'''.
* The '''center of gravity''' of the basin: the coordinates of the pixel nearest to the center of gravity of the geometric figure resulting from the projection of the basin on the horizontal plane.
* The '''area''' of the basin: is the area of a single cell multiplied by the number of cells belonging to the basin.
* The '''perimeter''': is the length of the contour of the figure resulting by the projection of the basin on the horizontal plane.
[As a side note, a paper namely [http://en.wikipedia.org/wiki/How_Long_Is_the_Coast_of_Britain%3F_Statistical_Self-Similarity_and_Fractional_Dimension "How Long Is the Coast of Britain? Statistical Self-Similarity and Fractional Dimension"] points out that perimeter is affected by a fractal problem and the number is mostly meaningless taken by itself. Hence, perimeter should never be mixed with anything from another dataset or even the same data set at a different cell resolution; it is only good as a percentage comparison to its neighbors in the same dataset].
* '''Characteristic values of elevation''': the highest and the lowest altitude, the difference between them and the mean elevation calculated as the sum of the values of the cells divided by the number of the cells.
* The '''mean slope''', calculated averaging the slope map.
* The '''length of the directing vector''': the length of the vector linking the outlet to basin's barycenter.
* The '''prevalent orientation''': is the orientation of the directing vector.
* The '''length of main channel''': is the length of the longest succession of segments that connect a source to the outlet of the basin.
* The '''mean slope of main channel''': it is calculated as follows:

<center>
[[File:R.basin1.gif]]
</center>

where N is the topological diameter, i.e. the number of links in which the main channel can be divided on the basis of the junctions.
* The '''circularity ratio''': is the ratio between the area of the basin and the area of the circle having the same perimeter of the basin.
* The '''elongation ratio''': is the ratio between the diameter of the circle having the same area of the basin and the length of the main channel.
* The '''compactness coefficient''': is the ratio between the perimeter of the basin and the diameter of the circle having the same area of the basin.
* The '''shape factor''': is the ratio between the area of the basin and the square of the length of the main channel.
* The '''concentration time''' (Giandotti, 1934):

<center>
[[File:R.basin2.gif]]
</center>

Where A is the area, L the length of the main channel and H the difference between the highest and the lowest elevation of the basin.
* The '''mean hillslope length''': is the mean of the distances calculated along the flow direction of each point non belonging to the river network from the point in which flows into the network.
* The '''magnitudo''': is the number of the branches of order 1 following the Strahler hierarchy.
* The '''max order''': is the order of the basin, following the Strahler hierarchy.
* The '''number of streams''': is the number of the branches of the river network.
* The '''total stream length''': is the sum of the length of every branches.
* The '''first order stream frequency''': is the ratio between the magnitudo and the area of the basin.
* The '''drainage density''': is the ratio between the total length of the river network and the area.
* The '''Horton ratios''' (Horton, 1945; Strahler, 1957).

<pre>
##################################
Morphometric parameters of basin :
##################################
Easting Centroid of basin : 635195.00
Northing Centroid of Basin : 220715.00
Rectangle containing basin N-W : 632870 , 222890
Rectangle containing basin S-E : 637000 , 218720
Area of basin [km^2] : 7.8559625
Perimeter of basin [km] : 16.8287990515
Max Elevation [m s.l.m.] : 151.7396
Min Elevation [m s.l.m.]: 94.82206
Elevation Difference [m]: 56.91754
Mean Elevation [m s.l.m.]: 127.6772
Mean Slope : 2.93
Length of Directing Vector [km] : 2.38880562659
Prevalent Orientation [degree from north, counterclockwise] :
0.913351005341
Compactness Coefficient : 5.32106255399
Circularity Ratio : 0.348580442132
Topological Diameter : 127.0
Elongation Ratio : 0.470961456397
Shape Factor : 1.16984953656
Concentration Time (Giandotti, 1934) [hr] : 3.52654267443
Length of Mainchannel [km] : 6.715361467
Mean slope of mainchannel [percent] : 0.957339
Mean hillslope length [m] : 8145.381
Magnitudo : 621.0
Max order (Strahler) : 5
Number of streams : 884
Total Stream Length [km] : 96.3436
First order stream frequency : 79.0482388377
Drainage Density [km/km^2] : 12.2637550778
Bifurcation Ratio (Horton) : 5.7374
Length Ratio (Horton) : 2.6902
Area ratio (Horton) : 5.6815
Slope ratio (Horton): 1.5533
</pre>

The '''hypsographic curve''' provides the distribution of the areas at different altitudes. Each point on the hypsographic curve has on the y-axis the altitude and on the x-axis the percentage of basin surface placed above that altitude. The '''hypsometric curve''' has the same shape but is dimensionless.
Quantiles of the hypsometric curve are displayed:

<pre>
Tot. cells 78560.0
===========================
Ipsometric | quantiles
===========================
145 | 0.025
143 | 0.05
141 | 0.1
137 | 0.25
129 | 0.5
119 | 0.75
121 | 0.7
110 | 0.9
100 | 0.975
</pre>

The '''width function W(x)''' gives the area of the cells in the basin at a certain flow distance x from the outlet (distance-area function). Note that the distance is not intended in the euclidean sense, but it's calculated considering the hydrological path of the water.

<pre>
Tot. cells 78560.0
Tot. area 7856000.0
Max distance 6809.546521
===========================
Whidth Function | quantiles
===========================
784 | 0.05
1477 | 0.15
2137 | 0.3
2543 | 0.4
2933 | 0.5
3606 | 0.6
4169 | 0.7
5144 | 0.85
6105 | 0.95
</pre>

The output of r.stream.stats is also displayed:

<pre>
Summary:
Max order | Tot.N.str. | Tot.str.len. | Tot.area. | Dr.dens. | Str.freq.
(num) | (num) | (km) | (km2) | (km/km2) | (num/km2)
5 | 884 | 96.3436 | 7.8339 | 12.2983 | 112.8429

Stream ratios with standard deviations:
Bif.rt. | Len.rt. | Area.rt. | Slo.rt. | Grd.rt.
5.7374 | 2.6902 | 5.6815 | 1.5533 | 1.7962
3.1961 | 1.9514 | 5.2294 | 0.1250 | 0.7482

Order | Avg.len | Avg.ar | Avg.sl | Avg.grad. | Avg.el.dif
num | (km) | (km2) | (m/m) | (m/m) | (m)
1 | 0.0750 | 0.0069 | 0.0523 | 0.0384 | 3.1062
2 | 0.1428 | 0.0311 | 0.0342 | 0.0277 | 4.1701
3 | 0.4834 | 0.1732 | 0.0243 | 0.0205 | 9.0641
4 | 2.4205 | 2.1885 | 0.0155 | 0.0134 | 24.1708
5 | 1.1247 | 7.8339 | 0.0091 | 0.0046 | 5.1594

Order | Std.len | Std.ar | Std.sl | Std.grad. | Std.el.dif
num | (km) | (km2) | (m/m) | (m/m) | (m)
1 | 0.0600 | 0.0052 | 0.0398 | 0.0287 | 3.2301
2 | 0.1244 | 0.0230 | 0.0250 | 0.0196 | 4.4835
3 | 0.4554 | 0.1353 | 0.0132 | 0.0122 | 7.1065
4 | 2.2874 | 2.3843 | 0.0046 | 0.0061 | 12.9175
5 | 0.0000 | 0.0000 | 0.0000 | 0.0000 | 0.0000

Order | N.streams | Tot.len (km) | Tot.area (km2)
1 | 712 | 53.4067 | 4.8998
2 | 137 | 19.5657 | 4.2562
3 | 31 | 14.9849 | 5.3684
4 | 3 | 7.2616 | 6.5655
5 | 1 | 1.1247 | 7.8339

Order | Bif.rt. | Len.rt. | Area.rt. | Slo.rt. | Grd.rt. | d.dens. | str.freq.
1 | 5.1971 | 1.9040 | 0.0000 | 1.5311 | 1.3892 | 10.8998 | 145.3120
2 | 4.4194 | 3.3847 | 4.5144 | 1.4046 | 1.3472 | 4.5970 | 32.1883
3 | 10.3333 | 5.0075 | 5.5742 | 1.5691 | 1.5365 | 2.7913 | 5.7745
4 | 3.0000 | 0.4646 | 12.6376 | 1.7083 | 2.9120 | 1.1060 | 0.4569
5 | 0.0000 | 0.0000 | 3.5796 | 0.0000 | 0.0000 | 0.1436 | 0.1277
</pre>

== Maps ==

Since r.basin performs the delimitation of the river basin, all the maps produced are cropped over the basin. They are:

* Raster maps

<pre>
g.list rast

out_elevation_accumulation out_elevation_hillslope_distance
out_elevation_aspect out_elevation_horton
out_elevation_dist2out out_elevation_shreve
out_elevation_drainage out_elevation_slope
out_elevation_hack out_elevation_strahler

</pre>

<center>
<gallery perrow=5 widths=200>

File:Out_elevation_slope.png|Slope
File:Out_elevation_aspect.png|Aspect
File:Out_elevation_drainage.png|Flow direction
File:Out_elevation_accumulation.png|Flow accumulation
File:Out_elevation_dist2out.png|Distance to outlet (width function)
File:Out_elevation_hillslope_distance.png|Length of hillslopes
File:Out_elevation_strahler.png|Stream network ordered according to Strahler
File:Out_elevation_horton.png|Stream network ordered according to Horton
File:Out_elevation_shreve.png|Stream network ordered according to Shreve
File:Out_elevation_hack.png|Stream network ordered according to Hack

</gallery>
</center>

* Vector maps

<pre>
g.list vect

out_elevation_basin out_elevation_network
out_elevation_mainchannel out_elevation_outlet
</pre>

<center>
<gallery perrow=4 widths=200>

File:Out_elevation_basin.png|Basin
File:Out_elevation_mainchannel.png|Main channel
File:Out_elevation_network.png|Stream network
File:Out_elevation_outlet.png|Outlet

</gallery>
</center>

== Graphics ==

Graphics are stored in the working directory:

* out_elevation_ipsographic.png
* out_elevation_ipsometric.png
* out_elevation_width_function.png

<center>
<gallery perrow=3 widths=200>

File:Out_elevation_Ipsographic.png|Ipsographic curve
File:Out_elevation_Ipsometric.png|Ipsometric curve (Nondimensional ipsographic curve)
File:Out_elevation_width_function.png|Width function

</gallery>
</center>

== Known issues ==

r.basin hasn't been designed for working in lat/long coordinates. This means that if you are working in lat/long coordinates, you need to reproject your map first in order to apply the tool. <br />
Furthermore, r.basin is designed to work in meters unit. The values that you get using feet are just nonsense.

== See also ==

[[R.stream.*]]

== References ==

* Di Stefano M., Di Leo M., An Open-Source Approach for Catchment's Physiographic Characterization, In: Proceedings of AGU Fall Meeting 2013, S.Francisco, CA, USA.
* Di Leo Margherita, Working report: Extraction of morphometric parameters from a digital elevation model - Panama. North Carolina State University, 2010 ([http://dl.dropbox.com/u/1599323/Report_Panama.pdf PDF])
* Di Leo M., Di Stefano M., Claps P., Sole A., Caratterizzazione morfometrica del bacino idrografico in GRASS GIS (Morphometric characterization of the catchment in GRASS GIS environment), Geomatics Workbooks n.9, 2010. ([http://geomatica.como.polimi.it/workbooks/n9/GW9-FOSS4Git_2010.pdf PDF]).
* Rodriguez-Iturbe I., Rinaldo A., Fractal River Basins, Chance and Self-Organization. Cambridge Press, 2001.

[[Category: Documentation]]
[[Category: Tutorial]]
[[Category: Hydrology]]

GRASS Community Sprint Genova 2013

2013-02-03T19:39:43Z

⚠️Epifanio: /* Via IRC chat or hangout */

The GRASS GIS team will organize a '''GRASS Developer and Power User Meeting, aka 'GRASS Community Sprint'''' from '''2-7 Feb, 2013'''. The sprint is at the same time of the [http://geomorfolab.arch.unige.it/genova2013/index.php?lang=en XIV Meeting degli Utenti Italiani Grass e Gfoss], 6-9 Feb 2013, University of Genova, Dipartimento di Scienze per l'Architettura della Scuola Politecnica, [http://en.wikipedia.org/wiki/Genoa Genova], [http://en.wikipedia.org/wiki/Italy Italy].
[[Image:community_sprint_genova2013.png|center|640px|thumb|Thanks to '''Sonia Bertolone''' for the logo]]

<center>
Our logo — In the left of the GRASS Logo the [http://en.wikipedia.org/wiki/Lighthouse_of_Genoa Lanterna], in the right the [http://en.wikipedia.org/wiki/Mortar_and_pestle ''murtà''] to prepare [http://en.wikipedia.org/wiki/Pesto ''pestu'']

</center>

== Purpose ==

This next edition of the GRASS GIS community sprint 2013 is a great occasion for folks to support the development by actively contributing to the source code, manuals or likewise. The '''community''' sprint is a get-together for GRASS project members and supporters and related [http://www.osgeo.org/ OSGeo] projects to make decisions and tackle larger problems. For this meeting, we welcome people committed to improving the GRASS GIS project and the interfaces to [[QGIS GRASS Cookbook|QGIS]], [[GDAL]], [[PostGIS]], [[R statistics]], [[GRASS and Sextante|Sextante, gvSIG]], OGC Services (esp. [[WPS]]) and more. This includes developers, documenters, bug reporters, translators and others.

For this meeting, we welcome people committed to improving the GRASS GIS and related projects. This includes developers, document writers, wish and bug reporters, translators etc.

== Sponsors ==

We welcome '''financial contributions''' to support the meeting and we are looking for '''sponsors''' to cover costs such as meals or to help reducing travelling and accommodation expenses for GRASS developers with far arrival. If you are interested to sponsor the GRASS Community Sprint, please read about

:::'''sponsoring the GRASS project at [http://grass.osgeo.org/donations/ http://grass.osgeo.org/donations/]'''

For questions, please contact [[User:Lucadelu|Luca Delucchi]] <tt><lucadeluge at gmail.com></tt>. Any surplus at the end of the event will be turned over to the GRASS GIS project.

The third GRASS Community Sprint is a great occasion for you to support the development of GRASS. With your contribution you'll enable more developers to meet. The community sprint is an important opportunity for the GRASS developers to discuss and collaboratively resolve bugs, plan the direction for the project and work on new features. Please see below for the more detailed agenda. The developers and contributors are donating their valuable time, so it would be great if in-kind funding can be made available from within the community to cover out-of-pocket expenses. All of the work that takes place at the community sprint will be directly contributed back into the GRASS project to the benefit of everyone who uses it.

=== Thanks to our sponsors ===

* Anonymous donor - 100 euro
* [http://www.r3-gis.com/ R3 GIS], Merano, Italy - 300 euro
* [http://www.intevation.de Intevation Gmbh], Osnabrück, Germany - 100 euro
* Flavio Rigolon - 30 euro
* Nobusuke Iwasaki - 200 euro
* Giuliano Urgeghe - 50 euro

== Timing ==

'''When''': 2-7 Feb, 2013

Of course you are invited to join or leave the community sprint whenever you want.

'''Duration''': 6 days

== Venue ==

For the 2nd and 3rd of February we are hosted by the [http://www.alid.it ALID association] at Circolo Zenzero in [http://osm.org/go/xX0m6qo~B-- Via Torti 35, Genova] (in Italy universities are closed during weekends).

From 4th to 7th at University of Genova, Dipartimento di Scienze per l'Architettura della Scuola Politecnica, Genova, Italy.

'''[http://geomorfolab.arch.unige.it/ Geomorfolab]''',
Dipartimento di Scienze per l'Architettura,
Scuola Politecnica - Università degli Studi di Genova,
[http://osm.org/go/xX0ml6cj7-- Stradone S. Agostino 37, 16128 Genova]

Rooms: TBD

== Accommodation and Costs ==

* Bed and breakfast (few rooms) - close to venue (please contact [[User:Lucadelu|Luca Delucchi]] <tt><lucadeluge at gmail.com></tt>)
* New youth hostel, http://www.manenahostel.it/ - close to venue (please contact [[User:Lucadelu|Luca Delucchi]] <tt><lucadeluge at gmail.com></tt>)
* List of [http://geomorfolab.arch.unige.it/genova2013/index.php?option=com_content&view=article&id=42&Itemid=18 Site of XIV Meeting degli utenti italiani GRASS e GFOSS]

== Weather and Common Item Prices ==

== Agenda ==

=== Timeline ===

==== Saturday, 2 Feb ====
* Kick-off in the [http://www.alid.it ALID association] at Circolo Zenzero in [http://osm.org/go/xX0m6qo~B-- Via Torti 35, Genova]
* Participants presentation
* Dinner: at Circolo Zenzero

==== Sunday, 3 Feb ====
* 9:00-evening
* Meeting again in the at Circolo Zenzero

List of topics:
* TBD
* Dinner: at Circolo Zenzero

==== Monday, 4 Feb ====
* 9:00-evening
* Meeting at University of Genova, Dipartimento di Scienze per l'Architettura della Scuola Politecnica, Genova, Italy at the '''[http://geomorfolab.arch.unige.it/ Geomorfolab]''', [http://osm.org/go/xX0ml6cj7-- Stradone S. Agostino 37, 16128 Genova]

List of topics:
* TBD

==== Tuesday, 5 Feb ====
* 9:00-evening
* Meeting again at University of Genova, Geomorfolab

List of topics:
* TBD

==== Wednesday, 6 Feb ====
* 9:00-evening
* Meeting again at University of Genova, Geomorfolab

List of topics:
* TBD
* Group photo!!
* Prepare press release

==== Thursday, 7 Feb ====
* 9:00-evening
* Meeting again at University of Genova, Geomorfolab

List of topics:
* TBD
* Prepare short presentations for Friday at the Italian GFOSS meeting
* Finish and publish press release

Closing of community sprint

==== Friday, 8 Feb ====
* Two hours of time for '''presenting Community Sprint results''' at Italian GFOSS meeting ([http://geomorfolab.arch.unige.it/genova2013/index.php?option=com_content&view=article&id=29&Itemid=21&lang=en venue])

== Participation ==

=== In person ===

{|class="wikitable sortable" border="2" cellspacing="0" cellpadding="4" rules="all" style="margin:1em 1em 1em 0; border:solid 1px #AAAAAA; border-collapse:collapse; background-color:#edf9c7; font-size:95%; empty-cells:show;"
!width=50px|'''Number'''
!width=130px|'''Participant '''
!width=100px|'''Country'''
!width=100px|'''Arrival'''
!width=100px|'''Departure'''
!'''Topic'''
!width=75px|'''T-Shirt'''
!'''Notes'''
|-
|1
|[[User:Lucadelu|Luca Delucchi]]
|Italy
| Feb 2
| Feb 10
|
| L
|
|-
|2
|<strike>[[User:Neteler|Markus Neteler]]</strike>
|Italy
|
|
|
| M + S
| ... unable to come, still in rehabilitation :-(
|-
|3
|[[User:Madi|Margherita Di Leo]]
|Italy
| Feb 5
| Feb 7
| Workshop Advanced GRASS, and some maintenance works
| L
|
|-
|4
|[[User:pcav|Paolo Cavallini]]
|Italy
| Feb 6
| Feb 9
|
| L
|
|-
|5
|[[User:lcasagrande|Luca Casagrande]]
|Italy
|
|
| GRASS Tutorial with Open Data from Italy
| L
|
|-
|6
|[[User:Annakrat|Anna Kratochvilova]]
|Czech Republic
| Feb 1
| Feb 8
|
| M
|
|-
|7
|Vaclav Petras
|Czech Republic
| Feb 1
| Feb 8
|
| M
|
|-
|8
|[[User:pietro|Pietro Zambelli]]
|Italy
| Feb 2
| Feb 9
| Python and Pygrass workshops
| M
|
|-
|9
|<strike>[[User:Landa|Martin Landa]]</strike>
|Czech Republic
| Feb 2
| Feb 10
| [[wxGUI]], vector architecture, GRASS 7 development
| L
| ... unable to come :-(
|-
|10
|[[User:Maxi|Massimiliano Cannata]]
|Italy
|
|
|
| XL
|
|-
|11
|[[User:NikosA|Nikos Alexandris]]
|Greece
| Feb 1
| Feb 10
| GRASS-wiki, (re-)working on the idea for a practical & visual guide to GRASS-GIS, testing all landsat related (core + addons) modules
| M
| Will be there with Nikos Ves!
|-
|12
|[[User:AnneGhisla|Anne Ghisla]]
|Italy
| Feb 5
| Feb 8
| fix v.krige, examine i.atcorr problems with RapidEye
| M
|
|-
|13
|[[User:vesnikos|Ves Nikos]]
|Greece
| Feb 1
| Feb 10
|
| L
| Will be there with Nikos Alexandris
|-
|14
|[[User:ychemin|Yann Chemin]]
|Sri Lanka
| Feb 3
| Feb 10
| Remote Sensing, raster/image processing, will help with Landsat and i.atcorr, i.ortho.photo Block/Bundle.
| XXXLL
| 100% confirmed trip
|-
|15
|[[User:mmetz|Markus Metz]]
|Italy
| Feb 2
| Feb 8
| GRASS 7 vector processing, hydrology, orthorectification.
| L
|
|-
|16
|[[User:Annazanchetta|Anna Zanchetta]]
|Italy
| Feb 5?
|
|
| S
| Hopefully will be there on the 5th
|-
|-
|17
|[[User:robertomarzocchi|Roberto Marzocchi]]
|Italy
| Feb 4?
|
| adjust the G-Pastro modules
| M
|
|-
|18
|Stefano 'chiui' Cavallari
|Italy
| Feb 5
| Feb 8
| random Python stuff
| M
|
|-
|}

=== Via IRC chat or hangout===

: [irc://freenode/grass #grass] on Freenode
: [http://www.google.com/+/learnmore/hangouts/ G+ hangout] (to be investigated; smartphones only? is Jitsi on a desktop computer compatible?)

For details, see [[IRC]]

Please add yourself here below (please add also your gmail account for G+ hangout):

* [[User:Landa|Martin Landa]], [http://www.timeanddate.com/worldclock/city.html?n=204 timezone]. Gmail is <landa.martin@> expanded
* [[User:huhabla|Soeren Gebbert]], [http://www.timeanddate.com/worldclock/city.html?n=971 timezone]
* [[User:Ecologeek|Sylvain Maillard]], [http://www.timeanddate.com/worldclock/city.html?n=333 timezone] : available sunday and week evenings
* [[User:HamishBowman|Hamish]], [http://www.timeanddate.com/worldclock/city.html?n=952 timezone] : limited availability, but best effort. Gmail is <h.b@> expanded
* [[User:Madi|Margherita Di Leo]], [http://www.timeanddate.com/worldclock/city.html?n=2500 timezone] dileomargherita AT gmail DOT com
* [[User:epifanio|Massimo Di Stefano]], [http://www.timeanddate.com/worldclock/city.html?n=43 timezone] massimodisasha AT gmail DOT com

'''Timing hangout meetings:'''

* Date, time

[http://doodle.com/f2qfqixqeqkkmskh doodle-pool]

=== Collaborative document scratching ===

Wish: please reduce to one Etherpad server to avoid confusion:

* (This wiki)
* '''[http://etherpad.osuosl.org OSU OSL's Etherpad]'''
* [http://typewith.me Etherpad Lite]
* [http://etherpad.mozilla.org Mozilla's Etherpad]
* [http://titanpad.com TitanPad's Etherpad]

== Individual Preparation ==

* Bring your own computer
* Bring [http://en.wikipedia.org/wiki/Mains_electricity_by_country your power connector adapter] if needed ([http://en.wikipedia.org/wiki/File:L_plug.jpg Italy])
* Install subversion and the compiler tools, and come with a working GRASS development environment if possible.

== Photos ==

Also during the event :)

== FAQ ==

* '''How was it last time?'''
** Very cool, see [[GRASS Community Sprint Prague 2012]]!

* '''Is the GRASS Community Sprint just a coding event?'''
** It is mainly a coding and documentation event. It is a working session for people who are already participants in the GRASS project and/or are committed to improving the GRASS project.
** On demand, however, we can do some presentations of current working GRASS implementations and new upcoming features to spread the idea of Open Source GIS software.

* '''Is the GRASS Community Sprint for developers only?'''
** ''Not at all!'' Anybody can help with testing, checking out bugs and fixes, documentation and more.

* '''Where can I get help and more information about the community sprint?'''
** Contact [[User:Lucadelu|Luca Delucchi]] <tt><lucadeluge at gmail dot com></tt> or [[User:Neteler|Markus Neteler]]

[[Category: Workshops]]

GRASS Community Sprint Genova 2013

2013-02-03T19:32:53Z

⚠️Epifanio: /* Via IRC chat or hangout */

The GRASS GIS team will organize a '''GRASS Developer and Power User Meeting, aka 'GRASS Community Sprint'''' from '''2-7 Feb, 2013'''. The sprint is at the same time of the [http://geomorfolab.arch.unige.it/genova2013/index.php?lang=en XIV Meeting degli Utenti Italiani Grass e Gfoss], 6-9 Feb 2013, University of Genova, Dipartimento di Scienze per l'Architettura della Scuola Politecnica, [http://en.wikipedia.org/wiki/Genoa Genova], [http://en.wikipedia.org/wiki/Italy Italy].
[[Image:community_sprint_genova2013.png|center|640px|thumb|Thanks to '''Sonia Bertolone''' for the logo]]

<center>
Our logo — In the left of the GRASS Logo the [http://en.wikipedia.org/wiki/Lighthouse_of_Genoa Lanterna], in the right the [http://en.wikipedia.org/wiki/Mortar_and_pestle ''murtà''] to prepare [http://en.wikipedia.org/wiki/Pesto ''pestu'']

</center>

== Purpose ==

This next edition of the GRASS GIS community sprint 2013 is a great occasion for folks to support the development by actively contributing to the source code, manuals or likewise. The '''community''' sprint is a get-together for GRASS project members and supporters and related [http://www.osgeo.org/ OSGeo] projects to make decisions and tackle larger problems. For this meeting, we welcome people committed to improving the GRASS GIS project and the interfaces to [[QGIS GRASS Cookbook|QGIS]], [[GDAL]], [[PostGIS]], [[R statistics]], [[GRASS and Sextante|Sextante, gvSIG]], OGC Services (esp. [[WPS]]) and more. This includes developers, documenters, bug reporters, translators and others.

For this meeting, we welcome people committed to improving the GRASS GIS and related projects. This includes developers, document writers, wish and bug reporters, translators etc.

== Sponsors ==

We welcome '''financial contributions''' to support the meeting and we are looking for '''sponsors''' to cover costs such as meals or to help reducing travelling and accommodation expenses for GRASS developers with far arrival. If you are interested to sponsor the GRASS Community Sprint, please read about

:::'''sponsoring the GRASS project at [http://grass.osgeo.org/donations/ http://grass.osgeo.org/donations/]'''

For questions, please contact [[User:Lucadelu|Luca Delucchi]] <tt><lucadeluge at gmail.com></tt>. Any surplus at the end of the event will be turned over to the GRASS GIS project.

The third GRASS Community Sprint is a great occasion for you to support the development of GRASS. With your contribution you'll enable more developers to meet. The community sprint is an important opportunity for the GRASS developers to discuss and collaboratively resolve bugs, plan the direction for the project and work on new features. Please see below for the more detailed agenda. The developers and contributors are donating their valuable time, so it would be great if in-kind funding can be made available from within the community to cover out-of-pocket expenses. All of the work that takes place at the community sprint will be directly contributed back into the GRASS project to the benefit of everyone who uses it.

=== Thanks to our sponsors ===

* Anonymous donor - 100 euro
* [http://www.r3-gis.com/ R3 GIS], Merano, Italy - 300 euro
* [http://www.intevation.de Intevation Gmbh], Osnabrück, Germany - 100 euro
* Flavio Rigolon - 30 euro
* Nobusuke Iwasaki - 200 euro
* Giuliano Urgeghe - 50 euro

== Timing ==

'''When''': 2-7 Feb, 2013

Of course you are invited to join or leave the community sprint whenever you want.

'''Duration''': 6 days

== Venue ==

For the 2nd and 3rd of February we are hosted by the [http://www.alid.it ALID association] at Circolo Zenzero in [http://osm.org/go/xX0m6qo~B-- Via Torti 35, Genova] (in Italy universities are closed during weekends).

From 4th to 7th at University of Genova, Dipartimento di Scienze per l'Architettura della Scuola Politecnica, Genova, Italy.

'''[http://geomorfolab.arch.unige.it/ Geomorfolab]''',
Dipartimento di Scienze per l'Architettura,
Scuola Politecnica - Università degli Studi di Genova,
[http://osm.org/go/xX0ml6cj7-- Stradone S. Agostino 37, 16128 Genova]

Rooms: TBD

== Accommodation and Costs ==

* Bed and breakfast (few rooms) - close to venue (please contact [[User:Lucadelu|Luca Delucchi]] <tt><lucadeluge at gmail.com></tt>)
* New youth hostel, http://www.manenahostel.it/ - close to venue (please contact [[User:Lucadelu|Luca Delucchi]] <tt><lucadeluge at gmail.com></tt>)
* List of [http://geomorfolab.arch.unige.it/genova2013/index.php?option=com_content&view=article&id=42&Itemid=18 Site of XIV Meeting degli utenti italiani GRASS e GFOSS]

== Weather and Common Item Prices ==

== Agenda ==

=== Timeline ===

==== Saturday, 2 Feb ====
* Kick-off in the [http://www.alid.it ALID association] at Circolo Zenzero in [http://osm.org/go/xX0m6qo~B-- Via Torti 35, Genova]
* Participants presentation
* Dinner: at Circolo Zenzero

==== Sunday, 3 Feb ====
* 9:00-evening
* Meeting again in the at Circolo Zenzero

List of topics:
* TBD
* Dinner: at Circolo Zenzero

==== Monday, 4 Feb ====
* 9:00-evening
* Meeting at University of Genova, Dipartimento di Scienze per l'Architettura della Scuola Politecnica, Genova, Italy at the '''[http://geomorfolab.arch.unige.it/ Geomorfolab]''', [http://osm.org/go/xX0ml6cj7-- Stradone S. Agostino 37, 16128 Genova]

List of topics:
* TBD

==== Tuesday, 5 Feb ====
* 9:00-evening
* Meeting again at University of Genova, Geomorfolab

List of topics:
* TBD

==== Wednesday, 6 Feb ====
* 9:00-evening
* Meeting again at University of Genova, Geomorfolab

List of topics:
* TBD
* Group photo!!
* Prepare press release

==== Thursday, 7 Feb ====
* 9:00-evening
* Meeting again at University of Genova, Geomorfolab

List of topics:
* TBD
* Prepare short presentations for Friday at the Italian GFOSS meeting
* Finish and publish press release

Closing of community sprint

==== Friday, 8 Feb ====
* Two hours of time for '''presenting Community Sprint results''' at Italian GFOSS meeting ([http://geomorfolab.arch.unige.it/genova2013/index.php?option=com_content&view=article&id=29&Itemid=21&lang=en venue])

== Participation ==

=== In person ===

{|class="wikitable sortable" border="2" cellspacing="0" cellpadding="4" rules="all" style="margin:1em 1em 1em 0; border:solid 1px #AAAAAA; border-collapse:collapse; background-color:#edf9c7; font-size:95%; empty-cells:show;"
!width=50px|'''Number'''
!width=130px|'''Participant '''
!width=100px|'''Country'''
!width=100px|'''Arrival'''
!width=100px|'''Departure'''
!'''Topic'''
!width=75px|'''T-Shirt'''
!'''Notes'''
|-
|1
|[[User:Lucadelu|Luca Delucchi]]
|Italy
| Feb 2
| Feb 10
|
| L
|
|-
|2
|<strike>[[User:Neteler|Markus Neteler]]</strike>
|Italy
|
|
|
| M + S
| ... unable to come, still in rehabilitation :-(
|-
|3
|[[User:Madi|Margherita Di Leo]]
|Italy
| Feb 5
| Feb 7
| Workshop Advanced GRASS, and some maintenance works
| L
|
|-
|4
|[[User:pcav|Paolo Cavallini]]
|Italy
| Feb 6
| Feb 9
|
| L
|
|-
|5
|[[User:lcasagrande|Luca Casagrande]]
|Italy
|
|
| GRASS Tutorial with Open Data from Italy
| L
|
|-
|6
|[[User:Annakrat|Anna Kratochvilova]]
|Czech Republic
| Feb 1
| Feb 8
|
| M
|
|-
|7
|Vaclav Petras
|Czech Republic
| Feb 1
| Feb 8
|
| M
|
|-
|8
|[[User:pietro|Pietro Zambelli]]
|Italy
| Feb 2
| Feb 9
| Python and Pygrass workshops
| M
|
|-
|9
|<strike>[[User:Landa|Martin Landa]]</strike>
|Czech Republic
| Feb 2
| Feb 10
| [[wxGUI]], vector architecture, GRASS 7 development
| L
| ... unable to come :-(
|-
|10
|[[User:Maxi|Massimiliano Cannata]]
|Italy
|
|
|
| XL
|
|-
|11
|[[User:NikosA|Nikos Alexandris]]
|Greece
| Feb 1
| Feb 10
| GRASS-wiki, (re-)working on the idea for a practical & visual guide to GRASS-GIS, testing all landsat related (core + addons) modules
| M
| Will be there with Nikos Ves!
|-
|12
|[[User:AnneGhisla|Anne Ghisla]]
|Italy
| Feb 5
| Feb 8
| fix v.krige, examine i.atcorr problems with RapidEye
| M
|
|-
|13
|[[User:vesnikos|Ves Nikos]]
|Greece
| Feb 1
| Feb 10
|
| L
| Will be there with Nikos Alexandris
|-
|14
|[[User:ychemin|Yann Chemin]]
|Sri Lanka
| Feb 3
| Feb 10
| Remote Sensing, raster/image processing, will help with Landsat and i.atcorr, i.ortho.photo Block/Bundle.
| XXXLL
| 100% confirmed trip
|-
|15
|[[User:mmetz|Markus Metz]]
|Italy
| Feb 2
| Feb 8
| GRASS 7 vector processing, hydrology, orthorectification.
| L
|
|-
|16
|[[User:Annazanchetta|Anna Zanchetta]]
|Italy
| Feb 5?
|
|
| S
| Hopefully will be there on the 5th
|-
|-
|17
|[[User:robertomarzocchi|Roberto Marzocchi]]
|Italy
| Feb 4?
|
| adjust the G-Pastro modules
| M
|
|-
|18
|Stefano 'chiui' Cavallari
|Italy
| Feb 5
| Feb 8
| random Python stuff
| M
|
|-
|}

=== Via IRC chat or hangout===

: [irc://freenode/grass #grass] on Freenode
: [http://www.google.com/+/learnmore/hangouts/ G+ hangout] (to be investigated; smartphones only? is Jitsi on a desktop computer compatible?)

For details, see [[IRC]]

Please add yourself here below (please add also your gmail account for G+ hangout):

* [[User:Landa|Martin Landa]], [http://www.timeanddate.com/worldclock/city.html?n=204 timezone]. Gmail is <landa.martin@> expanded
* [[User:huhabla|Soeren Gebbert]], [http://www.timeanddate.com/worldclock/city.html?n=971 timezone]
* [[User:Ecologeek|Sylvain Maillard]], [http://www.timeanddate.com/worldclock/city.html?n=333 timezone] : available sunday and week evenings
* [[User:HamishBowman|Hamish]], [http://www.timeanddate.com/worldclock/city.html?n=952 timezone] : limited availability, but best effort. Gmail is <h.b@> expanded
* [[User:Madi|Margherita Di Leo]], [http://www.timeanddate.com/worldclock/city.html?n=2500 timezone] dileomargherita AT gmail DOT com
* [[User:epifanio|Massimo Di Stefano]], [http://www.timeanddate.com/worldclock/city.html?n=43 timezone] massimodisasha AT gmail DOT com

'''Timing hangout meetings:'''

* Date, time

[http://doodle.com/ri7v4ytz9itvmu2e doodle-pool-request]

=== Collaborative document scratching ===

Wish: please reduce to one Etherpad server to avoid confusion:

* (This wiki)
* '''[http://etherpad.osuosl.org OSU OSL's Etherpad]'''
* [http://typewith.me Etherpad Lite]
* [http://etherpad.mozilla.org Mozilla's Etherpad]
* [http://titanpad.com TitanPad's Etherpad]

== Individual Preparation ==

* Bring your own computer
* Bring [http://en.wikipedia.org/wiki/Mains_electricity_by_country your power connector adapter] if needed ([http://en.wikipedia.org/wiki/File:L_plug.jpg Italy])
* Install subversion and the compiler tools, and come with a working GRASS development environment if possible.

== Photos ==

Also during the event :)

== FAQ ==

* '''How was it last time?'''
** Very cool, see [[GRASS Community Sprint Prague 2012]]!

* '''Is the GRASS Community Sprint just a coding event?'''
** It is mainly a coding and documentation event. It is a working session for people who are already participants in the GRASS project and/or are committed to improving the GRASS project.
** On demand, however, we can do some presentations of current working GRASS implementations and new upcoming features to spread the idea of Open Source GIS software.

* '''Is the GRASS Community Sprint for developers only?'''
** ''Not at all!'' Anybody can help with testing, checking out bugs and fixes, documentation and more.

* '''Where can I get help and more information about the community sprint?'''
** Contact [[User:Lucadelu|Luca Delucchi]] <tt><lucadeluge at gmail dot com></tt> or [[User:Neteler|Markus Neteler]]

[[Category: Workshops]]

GRASS Community Sprint Genova 2013

2013-02-03T19:32:24Z

⚠️Epifanio: /* Via IRC chat or hangout */

The GRASS GIS team will organize a '''GRASS Developer and Power User Meeting, aka 'GRASS Community Sprint'''' from '''2-7 Feb, 2013'''. The sprint is at the same time of the [http://geomorfolab.arch.unige.it/genova2013/index.php?lang=en XIV Meeting degli Utenti Italiani Grass e Gfoss], 6-9 Feb 2013, University of Genova, Dipartimento di Scienze per l'Architettura della Scuola Politecnica, [http://en.wikipedia.org/wiki/Genoa Genova], [http://en.wikipedia.org/wiki/Italy Italy].
[[Image:community_sprint_genova2013.png|center|640px|thumb|Thanks to '''Sonia Bertolone''' for the logo]]

<center>
Our logo — In the left of the GRASS Logo the [http://en.wikipedia.org/wiki/Lighthouse_of_Genoa Lanterna], in the right the [http://en.wikipedia.org/wiki/Mortar_and_pestle ''murtà''] to prepare [http://en.wikipedia.org/wiki/Pesto ''pestu'']

</center>

== Purpose ==

This next edition of the GRASS GIS community sprint 2013 is a great occasion for folks to support the development by actively contributing to the source code, manuals or likewise. The '''community''' sprint is a get-together for GRASS project members and supporters and related [http://www.osgeo.org/ OSGeo] projects to make decisions and tackle larger problems. For this meeting, we welcome people committed to improving the GRASS GIS project and the interfaces to [[QGIS GRASS Cookbook|QGIS]], [[GDAL]], [[PostGIS]], [[R statistics]], [[GRASS and Sextante|Sextante, gvSIG]], OGC Services (esp. [[WPS]]) and more. This includes developers, documenters, bug reporters, translators and others.

For this meeting, we welcome people committed to improving the GRASS GIS and related projects. This includes developers, document writers, wish and bug reporters, translators etc.

== Sponsors ==

We welcome '''financial contributions''' to support the meeting and we are looking for '''sponsors''' to cover costs such as meals or to help reducing travelling and accommodation expenses for GRASS developers with far arrival. If you are interested to sponsor the GRASS Community Sprint, please read about

:::'''sponsoring the GRASS project at [http://grass.osgeo.org/donations/ http://grass.osgeo.org/donations/]'''

For questions, please contact [[User:Lucadelu|Luca Delucchi]] <tt><lucadeluge at gmail.com></tt>. Any surplus at the end of the event will be turned over to the GRASS GIS project.

The third GRASS Community Sprint is a great occasion for you to support the development of GRASS. With your contribution you'll enable more developers to meet. The community sprint is an important opportunity for the GRASS developers to discuss and collaboratively resolve bugs, plan the direction for the project and work on new features. Please see below for the more detailed agenda. The developers and contributors are donating their valuable time, so it would be great if in-kind funding can be made available from within the community to cover out-of-pocket expenses. All of the work that takes place at the community sprint will be directly contributed back into the GRASS project to the benefit of everyone who uses it.

=== Thanks to our sponsors ===

* Anonymous donor - 100 euro
* [http://www.r3-gis.com/ R3 GIS], Merano, Italy - 300 euro
* [http://www.intevation.de Intevation Gmbh], Osnabrück, Germany - 100 euro
* Flavio Rigolon - 30 euro
* Nobusuke Iwasaki - 200 euro
* Giuliano Urgeghe - 50 euro

== Timing ==

'''When''': 2-7 Feb, 2013

Of course you are invited to join or leave the community sprint whenever you want.

'''Duration''': 6 days

== Venue ==

For the 2nd and 3rd of February we are hosted by the [http://www.alid.it ALID association] at Circolo Zenzero in [http://osm.org/go/xX0m6qo~B-- Via Torti 35, Genova] (in Italy universities are closed during weekends).

From 4th to 7th at University of Genova, Dipartimento di Scienze per l'Architettura della Scuola Politecnica, Genova, Italy.

'''[http://geomorfolab.arch.unige.it/ Geomorfolab]''',
Dipartimento di Scienze per l'Architettura,
Scuola Politecnica - Università degli Studi di Genova,
[http://osm.org/go/xX0ml6cj7-- Stradone S. Agostino 37, 16128 Genova]

Rooms: TBD

== Accommodation and Costs ==

* Bed and breakfast (few rooms) - close to venue (please contact [[User:Lucadelu|Luca Delucchi]] <tt><lucadeluge at gmail.com></tt>)
* New youth hostel, http://www.manenahostel.it/ - close to venue (please contact [[User:Lucadelu|Luca Delucchi]] <tt><lucadeluge at gmail.com></tt>)
* List of [http://geomorfolab.arch.unige.it/genova2013/index.php?option=com_content&view=article&id=42&Itemid=18 Site of XIV Meeting degli utenti italiani GRASS e GFOSS]

== Weather and Common Item Prices ==

== Agenda ==

=== Timeline ===

==== Saturday, 2 Feb ====
* Kick-off in the [http://www.alid.it ALID association] at Circolo Zenzero in [http://osm.org/go/xX0m6qo~B-- Via Torti 35, Genova]
* Participants presentation
* Dinner: at Circolo Zenzero

==== Sunday, 3 Feb ====
* 9:00-evening
* Meeting again in the at Circolo Zenzero

List of topics:
* TBD
* Dinner: at Circolo Zenzero

==== Monday, 4 Feb ====
* 9:00-evening
* Meeting at University of Genova, Dipartimento di Scienze per l'Architettura della Scuola Politecnica, Genova, Italy at the '''[http://geomorfolab.arch.unige.it/ Geomorfolab]''', [http://osm.org/go/xX0ml6cj7-- Stradone S. Agostino 37, 16128 Genova]

List of topics:
* TBD

==== Tuesday, 5 Feb ====
* 9:00-evening
* Meeting again at University of Genova, Geomorfolab

List of topics:
* TBD

==== Wednesday, 6 Feb ====
* 9:00-evening
* Meeting again at University of Genova, Geomorfolab

List of topics:
* TBD
* Group photo!!
* Prepare press release

==== Thursday, 7 Feb ====
* 9:00-evening
* Meeting again at University of Genova, Geomorfolab

List of topics:
* TBD
* Prepare short presentations for Friday at the Italian GFOSS meeting
* Finish and publish press release

Closing of community sprint

==== Friday, 8 Feb ====
* Two hours of time for '''presenting Community Sprint results''' at Italian GFOSS meeting ([http://geomorfolab.arch.unige.it/genova2013/index.php?option=com_content&view=article&id=29&Itemid=21&lang=en venue])

== Participation ==

=== In person ===

{|class="wikitable sortable" border="2" cellspacing="0" cellpadding="4" rules="all" style="margin:1em 1em 1em 0; border:solid 1px #AAAAAA; border-collapse:collapse; background-color:#edf9c7; font-size:95%; empty-cells:show;"
!width=50px|'''Number'''
!width=130px|'''Participant '''
!width=100px|'''Country'''
!width=100px|'''Arrival'''
!width=100px|'''Departure'''
!'''Topic'''
!width=75px|'''T-Shirt'''
!'''Notes'''
|-
|1
|[[User:Lucadelu|Luca Delucchi]]
|Italy
| Feb 2
| Feb 10
|
| L
|
|-
|2
|<strike>[[User:Neteler|Markus Neteler]]</strike>
|Italy
|
|
|
| M + S
| ... unable to come, still in rehabilitation :-(
|-
|3
|[[User:Madi|Margherita Di Leo]]
|Italy
| Feb 5
| Feb 7
| Workshop Advanced GRASS, and some maintenance works
| L
|
|-
|4
|[[User:pcav|Paolo Cavallini]]
|Italy
| Feb 6
| Feb 9
|
| L
|
|-
|5
|[[User:lcasagrande|Luca Casagrande]]
|Italy
|
|
| GRASS Tutorial with Open Data from Italy
| L
|
|-
|6
|[[User:Annakrat|Anna Kratochvilova]]
|Czech Republic
| Feb 1
| Feb 8
|
| M
|
|-
|7
|Vaclav Petras
|Czech Republic
| Feb 1
| Feb 8
|
| M
|
|-
|8
|[[User:pietro|Pietro Zambelli]]
|Italy
| Feb 2
| Feb 9
| Python and Pygrass workshops
| M
|
|-
|9
|<strike>[[User:Landa|Martin Landa]]</strike>
|Czech Republic
| Feb 2
| Feb 10
| [[wxGUI]], vector architecture, GRASS 7 development
| L
| ... unable to come :-(
|-
|10
|[[User:Maxi|Massimiliano Cannata]]
|Italy
|
|
|
| XL
|
|-
|11
|[[User:NikosA|Nikos Alexandris]]
|Greece
| Feb 1
| Feb 10
| GRASS-wiki, (re-)working on the idea for a practical & visual guide to GRASS-GIS, testing all landsat related (core + addons) modules
| M
| Will be there with Nikos Ves!
|-
|12
|[[User:AnneGhisla|Anne Ghisla]]
|Italy
| Feb 5
| Feb 8
| fix v.krige, examine i.atcorr problems with RapidEye
| M
|
|-
|13
|[[User:vesnikos|Ves Nikos]]
|Greece
| Feb 1
| Feb 10
|
| L
| Will be there with Nikos Alexandris
|-
|14
|[[User:ychemin|Yann Chemin]]
|Sri Lanka
| Feb 3
| Feb 10
| Remote Sensing, raster/image processing, will help with Landsat and i.atcorr, i.ortho.photo Block/Bundle.
| XXXLL
| 100% confirmed trip
|-
|15
|[[User:mmetz|Markus Metz]]
|Italy
| Feb 2
| Feb 8
| GRASS 7 vector processing, hydrology, orthorectification.
| L
|
|-
|16
|[[User:Annazanchetta|Anna Zanchetta]]
|Italy
| Feb 5?
|
|
| S
| Hopefully will be there on the 5th
|-
|-
|17
|[[User:robertomarzocchi|Roberto Marzocchi]]
|Italy
| Feb 4?
|
| adjust the G-Pastro modules
| M
|
|-
|18
|Stefano 'chiui' Cavallari
|Italy
| Feb 5
| Feb 8
| random Python stuff
| M
|
|-
|}

=== Via IRC chat or hangout===

: [irc://freenode/grass #grass] on Freenode
: [http://www.google.com/+/learnmore/hangouts/ G+ hangout] (to be investigated; smartphones only? is Jitsi on a desktop computer compatible?)

For details, see [[IRC]]

Please add yourself here below (please add also your gmail account for G+ hangout):

* [[User:Landa|Martin Landa]], [http://www.timeanddate.com/worldclock/city.html?n=204 timezone]. Gmail is <landa.martin@> expanded
* [[User:huhabla|Soeren Gebbert]], [http://www.timeanddate.com/worldclock/city.html?n=971 timezone]
* [[User:Ecologeek|Sylvain Maillard]], [http://www.timeanddate.com/worldclock/city.html?n=333 timezone] : available sunday and week evenings
* [[User:HamishBowman|Hamish]], [http://www.timeanddate.com/worldclock/city.html?n=952 timezone] : limited availability, but best effort. Gmail is <h.b@> expanded
* [[User:Madi|Margherita Di Leo]], [http://www.timeanddate.com/worldclock/city.html?n=2500 timezone] dileomargherita AT gmail DOT com
* [[User:epifanio|Massimo Di Stefano]], [http://www.timeanddate.com/worldclock/city.html?n=43 timezone] massimodisasha AT gmail DOT com

'''Timing hangout meetings:'''

* Date, time

http://doodle.com/ri7v4ytz9itvmu2e

=== Collaborative document scratching ===

Wish: please reduce to one Etherpad server to avoid confusion:

* (This wiki)
* '''[http://etherpad.osuosl.org OSU OSL's Etherpad]'''
* [http://typewith.me Etherpad Lite]
* [http://etherpad.mozilla.org Mozilla's Etherpad]
* [http://titanpad.com TitanPad's Etherpad]

== Individual Preparation ==

* Bring your own computer
* Bring [http://en.wikipedia.org/wiki/Mains_electricity_by_country your power connector adapter] if needed ([http://en.wikipedia.org/wiki/File:L_plug.jpg Italy])
* Install subversion and the compiler tools, and come with a working GRASS development environment if possible.

== Photos ==

Also during the event :)

== FAQ ==

* '''How was it last time?'''
** Very cool, see [[GRASS Community Sprint Prague 2012]]!

* '''Is the GRASS Community Sprint just a coding event?'''
** It is mainly a coding and documentation event. It is a working session for people who are already participants in the GRASS project and/or are committed to improving the GRASS project.
** On demand, however, we can do some presentations of current working GRASS implementations and new upcoming features to spread the idea of Open Source GIS software.

* '''Is the GRASS Community Sprint for developers only?'''
** ''Not at all!'' Anybody can help with testing, checking out bugs and fixes, documentation and more.

* '''Where can I get help and more information about the community sprint?'''
** Contact [[User:Lucadelu|Luca Delucchi]] <tt><lucadeluge at gmail dot com></tt> or [[User:Neteler|Markus Neteler]]

[[Category: Workshops]]

GRASS Community Sprint Genova 2013

2013-02-03T19:31:27Z

⚠️Epifanio: /* Via IRC chat or hangout */

The GRASS GIS team will organize a '''GRASS Developer and Power User Meeting, aka 'GRASS Community Sprint'''' from '''2-7 Feb, 2013'''. The sprint is at the same time of the [http://geomorfolab.arch.unige.it/genova2013/index.php?lang=en XIV Meeting degli Utenti Italiani Grass e Gfoss], 6-9 Feb 2013, University of Genova, Dipartimento di Scienze per l'Architettura della Scuola Politecnica, [http://en.wikipedia.org/wiki/Genoa Genova], [http://en.wikipedia.org/wiki/Italy Italy].
[[Image:community_sprint_genova2013.png|center|640px|thumb|Thanks to '''Sonia Bertolone''' for the logo]]

<center>
Our logo — In the left of the GRASS Logo the [http://en.wikipedia.org/wiki/Lighthouse_of_Genoa Lanterna], in the right the [http://en.wikipedia.org/wiki/Mortar_and_pestle ''murtà''] to prepare [http://en.wikipedia.org/wiki/Pesto ''pestu'']

</center>

== Purpose ==

This next edition of the GRASS GIS community sprint 2013 is a great occasion for folks to support the development by actively contributing to the source code, manuals or likewise. The '''community''' sprint is a get-together for GRASS project members and supporters and related [http://www.osgeo.org/ OSGeo] projects to make decisions and tackle larger problems. For this meeting, we welcome people committed to improving the GRASS GIS project and the interfaces to [[QGIS GRASS Cookbook|QGIS]], [[GDAL]], [[PostGIS]], [[R statistics]], [[GRASS and Sextante|Sextante, gvSIG]], OGC Services (esp. [[WPS]]) and more. This includes developers, documenters, bug reporters, translators and others.

For this meeting, we welcome people committed to improving the GRASS GIS and related projects. This includes developers, document writers, wish and bug reporters, translators etc.

== Sponsors ==

We welcome '''financial contributions''' to support the meeting and we are looking for '''sponsors''' to cover costs such as meals or to help reducing travelling and accommodation expenses for GRASS developers with far arrival. If you are interested to sponsor the GRASS Community Sprint, please read about

:::'''sponsoring the GRASS project at [http://grass.osgeo.org/donations/ http://grass.osgeo.org/donations/]'''

For questions, please contact [[User:Lucadelu|Luca Delucchi]] <tt><lucadeluge at gmail.com></tt>. Any surplus at the end of the event will be turned over to the GRASS GIS project.

The third GRASS Community Sprint is a great occasion for you to support the development of GRASS. With your contribution you'll enable more developers to meet. The community sprint is an important opportunity for the GRASS developers to discuss and collaboratively resolve bugs, plan the direction for the project and work on new features. Please see below for the more detailed agenda. The developers and contributors are donating their valuable time, so it would be great if in-kind funding can be made available from within the community to cover out-of-pocket expenses. All of the work that takes place at the community sprint will be directly contributed back into the GRASS project to the benefit of everyone who uses it.

=== Thanks to our sponsors ===

* Anonymous donor - 100 euro
* [http://www.r3-gis.com/ R3 GIS], Merano, Italy - 300 euro
* [http://www.intevation.de Intevation Gmbh], Osnabrück, Germany - 100 euro
* Flavio Rigolon - 30 euro
* Nobusuke Iwasaki - 200 euro
* Giuliano Urgeghe - 50 euro

== Timing ==

'''When''': 2-7 Feb, 2013

Of course you are invited to join or leave the community sprint whenever you want.

'''Duration''': 6 days

== Venue ==

For the 2nd and 3rd of February we are hosted by the [http://www.alid.it ALID association] at Circolo Zenzero in [http://osm.org/go/xX0m6qo~B-- Via Torti 35, Genova] (in Italy universities are closed during weekends).

From 4th to 7th at University of Genova, Dipartimento di Scienze per l'Architettura della Scuola Politecnica, Genova, Italy.

'''[http://geomorfolab.arch.unige.it/ Geomorfolab]''',
Dipartimento di Scienze per l'Architettura,
Scuola Politecnica - Università degli Studi di Genova,
[http://osm.org/go/xX0ml6cj7-- Stradone S. Agostino 37, 16128 Genova]

Rooms: TBD

== Accommodation and Costs ==

* Bed and breakfast (few rooms) - close to venue (please contact [[User:Lucadelu|Luca Delucchi]] <tt><lucadeluge at gmail.com></tt>)
* New youth hostel, http://www.manenahostel.it/ - close to venue (please contact [[User:Lucadelu|Luca Delucchi]] <tt><lucadeluge at gmail.com></tt>)
* List of [http://geomorfolab.arch.unige.it/genova2013/index.php?option=com_content&view=article&id=42&Itemid=18 Site of XIV Meeting degli utenti italiani GRASS e GFOSS]

== Weather and Common Item Prices ==

== Agenda ==

=== Timeline ===

==== Saturday, 2 Feb ====
* Kick-off in the [http://www.alid.it ALID association] at Circolo Zenzero in [http://osm.org/go/xX0m6qo~B-- Via Torti 35, Genova]
* Participants presentation
* Dinner: at Circolo Zenzero

==== Sunday, 3 Feb ====
* 9:00-evening
* Meeting again in the at Circolo Zenzero

List of topics:
* TBD
* Dinner: at Circolo Zenzero

==== Monday, 4 Feb ====
* 9:00-evening
* Meeting at University of Genova, Dipartimento di Scienze per l'Architettura della Scuola Politecnica, Genova, Italy at the '''[http://geomorfolab.arch.unige.it/ Geomorfolab]''', [http://osm.org/go/xX0ml6cj7-- Stradone S. Agostino 37, 16128 Genova]

List of topics:
* TBD

==== Tuesday, 5 Feb ====
* 9:00-evening
* Meeting again at University of Genova, Geomorfolab

List of topics:
* TBD

==== Wednesday, 6 Feb ====
* 9:00-evening
* Meeting again at University of Genova, Geomorfolab

List of topics:
* TBD
* Group photo!!
* Prepare press release

==== Thursday, 7 Feb ====
* 9:00-evening
* Meeting again at University of Genova, Geomorfolab

List of topics:
* TBD
* Prepare short presentations for Friday at the Italian GFOSS meeting
* Finish and publish press release

Closing of community sprint

==== Friday, 8 Feb ====
* Two hours of time for '''presenting Community Sprint results''' at Italian GFOSS meeting ([http://geomorfolab.arch.unige.it/genova2013/index.php?option=com_content&view=article&id=29&Itemid=21&lang=en venue])

== Participation ==

=== In person ===

{|class="wikitable sortable" border="2" cellspacing="0" cellpadding="4" rules="all" style="margin:1em 1em 1em 0; border:solid 1px #AAAAAA; border-collapse:collapse; background-color:#edf9c7; font-size:95%; empty-cells:show;"
!width=50px|'''Number'''
!width=130px|'''Participant '''
!width=100px|'''Country'''
!width=100px|'''Arrival'''
!width=100px|'''Departure'''
!'''Topic'''
!width=75px|'''T-Shirt'''
!'''Notes'''
|-
|1
|[[User:Lucadelu|Luca Delucchi]]
|Italy
| Feb 2
| Feb 10
|
| L
|
|-
|2
|<strike>[[User:Neteler|Markus Neteler]]</strike>
|Italy
|
|
|
| M + S
| ... unable to come, still in rehabilitation :-(
|-
|3
|[[User:Madi|Margherita Di Leo]]
|Italy
| Feb 5
| Feb 7
| Workshop Advanced GRASS, and some maintenance works
| L
|
|-
|4
|[[User:pcav|Paolo Cavallini]]
|Italy
| Feb 6
| Feb 9
|
| L
|
|-
|5
|[[User:lcasagrande|Luca Casagrande]]
|Italy
|
|
| GRASS Tutorial with Open Data from Italy
| L
|
|-
|6
|[[User:Annakrat|Anna Kratochvilova]]
|Czech Republic
| Feb 1
| Feb 8
|
| M
|
|-
|7
|Vaclav Petras
|Czech Republic
| Feb 1
| Feb 8
|
| M
|
|-
|8
|[[User:pietro|Pietro Zambelli]]
|Italy
| Feb 2
| Feb 9
| Python and Pygrass workshops
| M
|
|-
|9
|<strike>[[User:Landa|Martin Landa]]</strike>
|Czech Republic
| Feb 2
| Feb 10
| [[wxGUI]], vector architecture, GRASS 7 development
| L
| ... unable to come :-(
|-
|10
|[[User:Maxi|Massimiliano Cannata]]
|Italy
|
|
|
| XL
|
|-
|11
|[[User:NikosA|Nikos Alexandris]]
|Greece
| Feb 1
| Feb 10
| GRASS-wiki, (re-)working on the idea for a practical & visual guide to GRASS-GIS, testing all landsat related (core + addons) modules
| M
| Will be there with Nikos Ves!
|-
|12
|[[User:AnneGhisla|Anne Ghisla]]
|Italy
| Feb 5
| Feb 8
| fix v.krige, examine i.atcorr problems with RapidEye
| M
|
|-
|13
|[[User:vesnikos|Ves Nikos]]
|Greece
| Feb 1
| Feb 10
|
| L
| Will be there with Nikos Alexandris
|-
|14
|[[User:ychemin|Yann Chemin]]
|Sri Lanka
| Feb 3
| Feb 10
| Remote Sensing, raster/image processing, will help with Landsat and i.atcorr, i.ortho.photo Block/Bundle.
| XXXLL
| 100% confirmed trip
|-
|15
|[[User:mmetz|Markus Metz]]
|Italy
| Feb 2
| Feb 8
| GRASS 7 vector processing, hydrology, orthorectification.
| L
|
|-
|16
|[[User:Annazanchetta|Anna Zanchetta]]
|Italy
| Feb 5?
|
|
| S
| Hopefully will be there on the 5th
|-
|-
|17
|[[User:robertomarzocchi|Roberto Marzocchi]]
|Italy
| Feb 4?
|
| adjust the G-Pastro modules
| M
|
|-
|18
|Stefano 'chiui' Cavallari
|Italy
| Feb 5
| Feb 8
| random Python stuff
| M
|
|-
|}

=== Via IRC chat or hangout===

: [irc://freenode/grass #grass] on Freenode
: [http://www.google.com/+/learnmore/hangouts/ G+ hangout] (to be investigated; smartphones only? is Jitsi on a desktop computer compatible?)

For details, see [[IRC]]

Please add yourself here below (please add also your gmail account for G+ hangout):

* [[User:Landa|Martin Landa]], [http://www.timeanddate.com/worldclock/city.html?n=204 timezone]. Gmail is <landa.martin@> expanded
* [[User:huhabla|Soeren Gebbert]], [http://www.timeanddate.com/worldclock/city.html?n=971 timezone]
* [[User:Ecologeek|Sylvain Maillard]], [http://www.timeanddate.com/worldclock/city.html?n=333 timezone] : available sunday and week evenings
* [[User:HamishBowman|Hamish]], [http://www.timeanddate.com/worldclock/city.html?n=952 timezone] : limited availability, but best effort. Gmail is <h.b@> expanded
* [[User:Madi|Margherita Di Leo]], [http://www.timeanddate.com/worldclock/city.html?n=2500 timezone] dileomargherita AT gmail DOT com
* [[User:epifanio|Massimo Di Stefano]], [http://www.timeanddate.com/worldclock/city.html?n=43 timezone] massimodisasha AT gmail DOT com

'''Timing hangout meetings:'''

* Date, time

=== Collaborative document scratching ===

Wish: please reduce to one Etherpad server to avoid confusion:

* (This wiki)
* '''[http://etherpad.osuosl.org OSU OSL's Etherpad]'''
* [http://typewith.me Etherpad Lite]
* [http://etherpad.mozilla.org Mozilla's Etherpad]
* [http://titanpad.com TitanPad's Etherpad]

== Individual Preparation ==

* Bring your own computer
* Bring [http://en.wikipedia.org/wiki/Mains_electricity_by_country your power connector adapter] if needed ([http://en.wikipedia.org/wiki/File:L_plug.jpg Italy])
* Install subversion and the compiler tools, and come with a working GRASS development environment if possible.

== Photos ==

Also during the event :)

== FAQ ==

* '''How was it last time?'''
** Very cool, see [[GRASS Community Sprint Prague 2012]]!

* '''Is the GRASS Community Sprint just a coding event?'''
** It is mainly a coding and documentation event. It is a working session for people who are already participants in the GRASS project and/or are committed to improving the GRASS project.
** On demand, however, we can do some presentations of current working GRASS implementations and new upcoming features to spread the idea of Open Source GIS software.

* '''Is the GRASS Community Sprint for developers only?'''
** ''Not at all!'' Anybody can help with testing, checking out bugs and fixes, documentation and more.

* '''Where can I get help and more information about the community sprint?'''
** Contact [[User:Lucadelu|Luca Delucchi]] <tt><lucadeluge at gmail dot com></tt> or [[User:Neteler|Markus Neteler]]

[[Category: Workshops]]

GRASS Community Sprint Genova 2013

2013-02-03T19:28:40Z

⚠️Epifanio: /* Via IRC chat or hangout */

The GRASS GIS team will organize a '''GRASS Developer and Power User Meeting, aka 'GRASS Community Sprint'''' from '''2-7 Feb, 2013'''. The sprint is at the same time of the [http://geomorfolab.arch.unige.it/genova2013/index.php?lang=en XIV Meeting degli Utenti Italiani Grass e Gfoss], 6-9 Feb 2013, University of Genova, Dipartimento di Scienze per l'Architettura della Scuola Politecnica, [http://en.wikipedia.org/wiki/Genoa Genova], [http://en.wikipedia.org/wiki/Italy Italy].
[[Image:community_sprint_genova2013.png|center|640px|thumb|Thanks to '''Sonia Bertolone''' for the logo]]

<center>
Our logo — In the left of the GRASS Logo the [http://en.wikipedia.org/wiki/Lighthouse_of_Genoa Lanterna], in the right the [http://en.wikipedia.org/wiki/Mortar_and_pestle ''murtà''] to prepare [http://en.wikipedia.org/wiki/Pesto ''pestu'']

</center>

== Purpose ==

This next edition of the GRASS GIS community sprint 2013 is a great occasion for folks to support the development by actively contributing to the source code, manuals or likewise. The '''community''' sprint is a get-together for GRASS project members and supporters and related [http://www.osgeo.org/ OSGeo] projects to make decisions and tackle larger problems. For this meeting, we welcome people committed to improving the GRASS GIS project and the interfaces to [[QGIS GRASS Cookbook|QGIS]], [[GDAL]], [[PostGIS]], [[R statistics]], [[GRASS and Sextante|Sextante, gvSIG]], OGC Services (esp. [[WPS]]) and more. This includes developers, documenters, bug reporters, translators and others.

For this meeting, we welcome people committed to improving the GRASS GIS and related projects. This includes developers, document writers, wish and bug reporters, translators etc.

== Sponsors ==

We welcome '''financial contributions''' to support the meeting and we are looking for '''sponsors''' to cover costs such as meals or to help reducing travelling and accommodation expenses for GRASS developers with far arrival. If you are interested to sponsor the GRASS Community Sprint, please read about

:::'''sponsoring the GRASS project at [http://grass.osgeo.org/donations/ http://grass.osgeo.org/donations/]'''

For questions, please contact [[User:Lucadelu|Luca Delucchi]] <tt><lucadeluge at gmail.com></tt>. Any surplus at the end of the event will be turned over to the GRASS GIS project.

The third GRASS Community Sprint is a great occasion for you to support the development of GRASS. With your contribution you'll enable more developers to meet. The community sprint is an important opportunity for the GRASS developers to discuss and collaboratively resolve bugs, plan the direction for the project and work on new features. Please see below for the more detailed agenda. The developers and contributors are donating their valuable time, so it would be great if in-kind funding can be made available from within the community to cover out-of-pocket expenses. All of the work that takes place at the community sprint will be directly contributed back into the GRASS project to the benefit of everyone who uses it.

=== Thanks to our sponsors ===

* Anonymous donor - 100 euro
* [http://www.r3-gis.com/ R3 GIS], Merano, Italy - 300 euro
* [http://www.intevation.de Intevation Gmbh], Osnabrück, Germany - 100 euro
* Flavio Rigolon - 30 euro
* Nobusuke Iwasaki - 200 euro
* Giuliano Urgeghe - 50 euro

== Timing ==

'''When''': 2-7 Feb, 2013

Of course you are invited to join or leave the community sprint whenever you want.

'''Duration''': 6 days

== Venue ==

For the 2nd and 3rd of February we are hosted by the [http://www.alid.it ALID association] at Circolo Zenzero in [http://osm.org/go/xX0m6qo~B-- Via Torti 35, Genova] (in Italy universities are closed during weekends).

From 4th to 7th at University of Genova, Dipartimento di Scienze per l'Architettura della Scuola Politecnica, Genova, Italy.

'''[http://geomorfolab.arch.unige.it/ Geomorfolab]''',
Dipartimento di Scienze per l'Architettura,
Scuola Politecnica - Università degli Studi di Genova,
[http://osm.org/go/xX0ml6cj7-- Stradone S. Agostino 37, 16128 Genova]

Rooms: TBD

== Accommodation and Costs ==

* Bed and breakfast (few rooms) - close to venue (please contact [[User:Lucadelu|Luca Delucchi]] <tt><lucadeluge at gmail.com></tt>)
* New youth hostel, http://www.manenahostel.it/ - close to venue (please contact [[User:Lucadelu|Luca Delucchi]] <tt><lucadeluge at gmail.com></tt>)
* List of [http://geomorfolab.arch.unige.it/genova2013/index.php?option=com_content&view=article&id=42&Itemid=18 Site of XIV Meeting degli utenti italiani GRASS e GFOSS]

== Weather and Common Item Prices ==

== Agenda ==

=== Timeline ===

==== Saturday, 2 Feb ====
* Kick-off in the [http://www.alid.it ALID association] at Circolo Zenzero in [http://osm.org/go/xX0m6qo~B-- Via Torti 35, Genova]
* Participants presentation
* Dinner: at Circolo Zenzero

==== Sunday, 3 Feb ====
* 9:00-evening
* Meeting again in the at Circolo Zenzero

List of topics:
* TBD
* Dinner: at Circolo Zenzero

==== Monday, 4 Feb ====
* 9:00-evening
* Meeting at University of Genova, Dipartimento di Scienze per l'Architettura della Scuola Politecnica, Genova, Italy at the '''[http://geomorfolab.arch.unige.it/ Geomorfolab]''', [http://osm.org/go/xX0ml6cj7-- Stradone S. Agostino 37, 16128 Genova]

List of topics:
* TBD

==== Tuesday, 5 Feb ====
* 9:00-evening
* Meeting again at University of Genova, Geomorfolab

List of topics:
* TBD

==== Wednesday, 6 Feb ====
* 9:00-evening
* Meeting again at University of Genova, Geomorfolab

List of topics:
* TBD
* Group photo!!
* Prepare press release

==== Thursday, 7 Feb ====
* 9:00-evening
* Meeting again at University of Genova, Geomorfolab

List of topics:
* TBD
* Prepare short presentations for Friday at the Italian GFOSS meeting
* Finish and publish press release

Closing of community sprint

==== Friday, 8 Feb ====
* Two hours of time for '''presenting Community Sprint results''' at Italian GFOSS meeting ([http://geomorfolab.arch.unige.it/genova2013/index.php?option=com_content&view=article&id=29&Itemid=21&lang=en venue])

== Participation ==

=== In person ===

{|class="wikitable sortable" border="2" cellspacing="0" cellpadding="4" rules="all" style="margin:1em 1em 1em 0; border:solid 1px #AAAAAA; border-collapse:collapse; background-color:#edf9c7; font-size:95%; empty-cells:show;"
!width=50px|'''Number'''
!width=130px|'''Participant '''
!width=100px|'''Country'''
!width=100px|'''Arrival'''
!width=100px|'''Departure'''
!'''Topic'''
!width=75px|'''T-Shirt'''
!'''Notes'''
|-
|1
|[[User:Lucadelu|Luca Delucchi]]
|Italy
| Feb 2
| Feb 10
|
| L
|
|-
|2
|<strike>[[User:Neteler|Markus Neteler]]</strike>
|Italy
|
|
|
| M + S
| ... unable to come, still in rehabilitation :-(
|-
|3
|[[User:Madi|Margherita Di Leo]]
|Italy
| Feb 5
| Feb 7
| Workshop Advanced GRASS, and some maintenance works
| L
|
|-
|4
|[[User:pcav|Paolo Cavallini]]
|Italy
| Feb 6
| Feb 9
|
| L
|
|-
|5
|[[User:lcasagrande|Luca Casagrande]]
|Italy
|
|
| GRASS Tutorial with Open Data from Italy
| L
|
|-
|6
|[[User:Annakrat|Anna Kratochvilova]]
|Czech Republic
| Feb 1
| Feb 8
|
| M
|
|-
|7
|Vaclav Petras
|Czech Republic
| Feb 1
| Feb 8
|
| M
|
|-
|8
|[[User:pietro|Pietro Zambelli]]
|Italy
| Feb 2
| Feb 9
| Python and Pygrass workshops
| M
|
|-
|9
|<strike>[[User:Landa|Martin Landa]]</strike>
|Czech Republic
| Feb 2
| Feb 10
| [[wxGUI]], vector architecture, GRASS 7 development
| L
| ... unable to come :-(
|-
|10
|[[User:Maxi|Massimiliano Cannata]]
|Italy
|
|
|
| XL
|
|-
|11
|[[User:NikosA|Nikos Alexandris]]
|Greece
| Feb 1
| Feb 10
| GRASS-wiki, (re-)working on the idea for a practical & visual guide to GRASS-GIS, testing all landsat related (core + addons) modules
| M
| Will be there with Nikos Ves!
|-
|12
|[[User:AnneGhisla|Anne Ghisla]]
|Italy
| Feb 5
| Feb 8
| fix v.krige, examine i.atcorr problems with RapidEye
| M
|
|-
|13
|[[User:vesnikos|Ves Nikos]]
|Greece
| Feb 1
| Feb 10
|
| L
| Will be there with Nikos Alexandris
|-
|14
|[[User:ychemin|Yann Chemin]]
|Sri Lanka
| Feb 3
| Feb 10
| Remote Sensing, raster/image processing, will help with Landsat and i.atcorr, i.ortho.photo Block/Bundle.
| XXXLL
| 100% confirmed trip
|-
|15
|[[User:mmetz|Markus Metz]]
|Italy
| Feb 2
| Feb 8
| GRASS 7 vector processing, hydrology, orthorectification.
| L
|
|-
|16
|[[User:Annazanchetta|Anna Zanchetta]]
|Italy
| Feb 5?
|
|
| S
| Hopefully will be there on the 5th
|-
|-
|17
|[[User:robertomarzocchi|Roberto Marzocchi]]
|Italy
| Feb 4?
|
| adjust the G-Pastro modules
| M
|
|-
|18
|Stefano 'chiui' Cavallari
|Italy
| Feb 5
| Feb 8
| random Python stuff
| M
|
|-
|}

=== Via IRC chat or hangout===

: [irc://freenode/grass #grass] on Freenode
: [http://www.google.com/+/learnmore/hangouts/ G+ hangout] (to be investigated; smartphones only? is Jitsi on a desktop computer compatible?)

For details, see [[IRC]]

Please add yourself here below (please add also your gmail account for G+ hangout):

* [[User:Landa|Martin Landa]], [http://www.timeanddate.com/worldclock/city.html?n=204 timezone]. Gmail is <landa.martin@> expanded
* [[User:huhabla|Soeren Gebbert]], [http://www.timeanddate.com/worldclock/city.html?n=971 timezone]
* [[User:Ecologeek|Sylvain Maillard]], [http://www.timeanddate.com/worldclock/city.html?n=333 timezone] : available sunday and week evenings
* [[User:HamishBowman|Hamish]], [http://www.timeanddate.com/worldclock/city.html?n=952 timezone] : limited availability, but best effort. Gmail is <h.b@> expanded
* [[User:Madi|Margherita Di Leo]], [http://www.timeanddate.com/worldclock/city.html?n=2500 timezone] dileomargherita AT gmail DOT com
* [[User:epifanio|Massimo Di Stefano]], [http://www.timeanddate.com/worldclock/city.html?n=43 timezone] massimodisasha AT gmail DOT com

'''Timing hangout meetings:'''

* Date, time

* [http://doodle.com/gubtsh66gshzsqdg doodle-pool]

=== Collaborative document scratching ===

Wish: please reduce to one Etherpad server to avoid confusion:

* (This wiki)
* '''[http://etherpad.osuosl.org OSU OSL's Etherpad]'''
* [http://typewith.me Etherpad Lite]
* [http://etherpad.mozilla.org Mozilla's Etherpad]
* [http://titanpad.com TitanPad's Etherpad]

== Individual Preparation ==

* Bring your own computer
* Bring [http://en.wikipedia.org/wiki/Mains_electricity_by_country your power connector adapter] if needed ([http://en.wikipedia.org/wiki/File:L_plug.jpg Italy])
* Install subversion and the compiler tools, and come with a working GRASS development environment if possible.

== Photos ==

Also during the event :)

== FAQ ==

* '''How was it last time?'''
** Very cool, see [[GRASS Community Sprint Prague 2012]]!

* '''Is the GRASS Community Sprint just a coding event?'''
** It is mainly a coding and documentation event. It is a working session for people who are already participants in the GRASS project and/or are committed to improving the GRASS project.
** On demand, however, we can do some presentations of current working GRASS implementations and new upcoming features to spread the idea of Open Source GIS software.

* '''Is the GRASS Community Sprint for developers only?'''
** ''Not at all!'' Anybody can help with testing, checking out bugs and fixes, documentation and more.

* '''Where can I get help and more information about the community sprint?'''
** Contact [[User:Lucadelu|Luca Delucchi]] <tt><lucadeluge at gmail dot com></tt> or [[User:Neteler|Markus Neteler]]

[[Category: Workshops]]

GRASS Community Sprint Genova 2013

2013-02-03T19:05:31Z

⚠️Epifanio: /* Via IRC chat or hangout */

The GRASS GIS team will organize a '''GRASS Developer and Power User Meeting, aka 'GRASS Community Sprint'''' from '''2-7 Feb, 2013'''. The sprint is at the same time of the [http://geomorfolab.arch.unige.it/genova2013/index.php?lang=en XIV Meeting degli Utenti Italiani Grass e Gfoss], 6-9 Feb 2013, University of Genova, Dipartimento di Scienze per l'Architettura della Scuola Politecnica, [http://en.wikipedia.org/wiki/Genoa Genova], [http://en.wikipedia.org/wiki/Italy Italy].
[[Image:community_sprint_genova2013.png|center|640px|thumb|Thanks to '''Sonia Bertolone''' for the logo]]

<center>
Our logo — In the left of the GRASS Logo the [http://en.wikipedia.org/wiki/Lighthouse_of_Genoa Lanterna], in the right the [http://en.wikipedia.org/wiki/Mortar_and_pestle ''murtà''] to prepare [http://en.wikipedia.org/wiki/Pesto ''pestu'']

</center>

== Purpose ==

This next edition of the GRASS GIS community sprint 2013 is a great occasion for folks to support the development by actively contributing to the source code, manuals or likewise. The '''community''' sprint is a get-together for GRASS project members and supporters and related [http://www.osgeo.org/ OSGeo] projects to make decisions and tackle larger problems. For this meeting, we welcome people committed to improving the GRASS GIS project and the interfaces to [[QGIS GRASS Cookbook|QGIS]], [[GDAL]], [[PostGIS]], [[R statistics]], [[GRASS and Sextante|Sextante, gvSIG]], OGC Services (esp. [[WPS]]) and more. This includes developers, documenters, bug reporters, translators and others.

For this meeting, we welcome people committed to improving the GRASS GIS and related projects. This includes developers, document writers, wish and bug reporters, translators etc.

== Sponsors ==

We welcome '''financial contributions''' to support the meeting and we are looking for '''sponsors''' to cover costs such as meals or to help reducing travelling and accommodation expenses for GRASS developers with far arrival. If you are interested to sponsor the GRASS Community Sprint, please read about

:::'''sponsoring the GRASS project at [http://grass.osgeo.org/donations/ http://grass.osgeo.org/donations/]'''

For questions, please contact [[User:Lucadelu|Luca Delucchi]] <tt><lucadeluge at gmail.com></tt>. Any surplus at the end of the event will be turned over to the GRASS GIS project.

The third GRASS Community Sprint is a great occasion for you to support the development of GRASS. With your contribution you'll enable more developers to meet. The community sprint is an important opportunity for the GRASS developers to discuss and collaboratively resolve bugs, plan the direction for the project and work on new features. Please see below for the more detailed agenda. The developers and contributors are donating their valuable time, so it would be great if in-kind funding can be made available from within the community to cover out-of-pocket expenses. All of the work that takes place at the community sprint will be directly contributed back into the GRASS project to the benefit of everyone who uses it.

=== Thanks to our sponsors ===

* Anonymous donor - 100 euro
* [http://www.r3-gis.com/ R3 GIS], Merano, Italy - 300 euro
* [http://www.intevation.de Intevation Gmbh], Osnabrück, Germany - 100 euro
* Flavio Rigolon - 30 euro
* Nobusuke Iwasaki - 200 euro
* Giuliano Urgeghe - 50 euro

== Timing ==

'''When''': 2-7 Feb, 2013

Of course you are invited to join or leave the community sprint whenever you want.

'''Duration''': 6 days

== Venue ==

For the 2nd and 3rd of February we are hosted by the [http://www.alid.it ALID association] at Circolo Zenzero in [http://osm.org/go/xX0m6qo~B-- Via Torti 35, Genova] (in Italy universities are closed during weekends).

From 4th to 7th at University of Genova, Dipartimento di Scienze per l'Architettura della Scuola Politecnica, Genova, Italy.

'''[http://geomorfolab.arch.unige.it/ Geomorfolab]''',
Dipartimento di Scienze per l'Architettura,
Scuola Politecnica - Università degli Studi di Genova,
[http://osm.org/go/xX0ml6cj7-- Stradone S. Agostino 37, 16128 Genova]

Rooms: TBD

== Accommodation and Costs ==

* Bed and breakfast (few rooms) - close to venue (please contact [[User:Lucadelu|Luca Delucchi]] <tt><lucadeluge at gmail.com></tt>)
* New youth hostel, http://www.manenahostel.it/ - close to venue (please contact [[User:Lucadelu|Luca Delucchi]] <tt><lucadeluge at gmail.com></tt>)
* List of [http://geomorfolab.arch.unige.it/genova2013/index.php?option=com_content&view=article&id=42&Itemid=18 Site of XIV Meeting degli utenti italiani GRASS e GFOSS]

== Weather and Common Item Prices ==

== Agenda ==

=== Timeline ===

==== Saturday, 2 Feb ====
* Kick-off in the [http://www.alid.it ALID association] at Circolo Zenzero in [http://osm.org/go/xX0m6qo~B-- Via Torti 35, Genova]
* Participants presentation
* Dinner: at Circolo Zenzero

==== Sunday, 3 Feb ====
* 9:00-evening
* Meeting again in the at Circolo Zenzero

List of topics:
* TBD
* Dinner: at Circolo Zenzero

==== Monday, 4 Feb ====
* 9:00-evening
* Meeting at University of Genova, Dipartimento di Scienze per l'Architettura della Scuola Politecnica, Genova, Italy at the '''[http://geomorfolab.arch.unige.it/ Geomorfolab]''', [http://osm.org/go/xX0ml6cj7-- Stradone S. Agostino 37, 16128 Genova]

List of topics:
* TBD

==== Tuesday, 5 Feb ====
* 9:00-evening
* Meeting again at University of Genova, Geomorfolab

List of topics:
* TBD

==== Wednesday, 6 Feb ====
* 9:00-evening
* Meeting again at University of Genova, Geomorfolab

List of topics:
* TBD
* Group photo!!
* Prepare press release

==== Thursday, 7 Feb ====
* 9:00-evening
* Meeting again at University of Genova, Geomorfolab

List of topics:
* TBD
* Prepare short presentations for Friday at the Italian GFOSS meeting
* Finish and publish press release

Closing of community sprint

==== Friday, 8 Feb ====
* Two hours of time for '''presenting Community Sprint results''' at Italian GFOSS meeting ([http://geomorfolab.arch.unige.it/genova2013/index.php?option=com_content&view=article&id=29&Itemid=21&lang=en venue])

== Participation ==

=== In person ===

{|class="wikitable sortable" border="2" cellspacing="0" cellpadding="4" rules="all" style="margin:1em 1em 1em 0; border:solid 1px #AAAAAA; border-collapse:collapse; background-color:#edf9c7; font-size:95%; empty-cells:show;"
!width=50px|'''Number'''
!width=130px|'''Participant '''
!width=100px|'''Country'''
!width=100px|'''Arrival'''
!width=100px|'''Departure'''
!'''Topic'''
!width=75px|'''T-Shirt'''
!'''Notes'''
|-
|1
|[[User:Lucadelu|Luca Delucchi]]
|Italy
| Feb 2
| Feb 10
|
| L
|
|-
|2
|<strike>[[User:Neteler|Markus Neteler]]</strike>
|Italy
|
|
|
| M + S
| ... unable to come, still in rehabilitation :-(
|-
|3
|[[User:Madi|Margherita Di Leo]]
|Italy
| Feb 5
| Feb 7
| Workshop Advanced GRASS, and some maintenance works
| L
|
|-
|4
|[[User:pcav|Paolo Cavallini]]
|Italy
| Feb 6
| Feb 9
|
| L
|
|-
|5
|[[User:lcasagrande|Luca Casagrande]]
|Italy
|
|
| GRASS Tutorial with Open Data from Italy
| L
|
|-
|6
|[[User:Annakrat|Anna Kratochvilova]]
|Czech Republic
| Feb 1
| Feb 8
|
| M
|
|-
|7
|Vaclav Petras
|Czech Republic
| Feb 1
| Feb 8
|
| M
|
|-
|8
|[[User:pietro|Pietro Zambelli]]
|Italy
| Feb 2
| Feb 9
| Python and Pygrass workshops
| M
|
|-
|9
|<strike>[[User:Landa|Martin Landa]]</strike>
|Czech Republic
| Feb 2
| Feb 10
| [[wxGUI]], vector architecture, GRASS 7 development
| L
| ... unable to come :-(
|-
|10
|[[User:Maxi|Massimiliano Cannata]]
|Italy
|
|
|
| XL
|
|-
|11
|[[User:NikosA|Nikos Alexandris]]
|Greece
| Feb 1
| Feb 10
| GRASS-wiki, (re-)working on the idea for a practical & visual guide to GRASS-GIS, testing all landsat related (core + addons) modules
| M
| Will be there with Nikos Ves!
|-
|12
|[[User:AnneGhisla|Anne Ghisla]]
|Italy
| Feb 5
| Feb 8
| fix v.krige, examine i.atcorr problems with RapidEye
| M
|
|-
|13
|[[User:vesnikos|Ves Nikos]]
|Greece
| Feb 1
| Feb 10
|
| L
| Will be there with Nikos Alexandris
|-
|14
|[[User:ychemin|Yann Chemin]]
|Sri Lanka
| Feb 3
| Feb 10
| Remote Sensing, raster/image processing, will help with Landsat and i.atcorr, i.ortho.photo Block/Bundle.
| XXXLL
| 100% confirmed trip
|-
|15
|[[User:mmetz|Markus Metz]]
|Italy
| Feb 2
| Feb 8
| GRASS 7 vector processing, hydrology, orthorectification.
| L
|
|-
|16
|[[User:Annazanchetta|Anna Zanchetta]]
|Italy
| Feb 5?
|
|
| S
| Hopefully will be there on the 5th
|-
|-
|17
|[[User:robertomarzocchi|Roberto Marzocchi]]
|Italy
| Feb 4?
|
| adjust the G-Pastro modules
| M
|
|-
|18
|Stefano 'chiui' Cavallari
|Italy
| Feb 5
| Feb 8
| random Python stuff
| M
|
|-
|}

=== Via IRC chat or hangout===

: [irc://freenode/grass #grass] on Freenode
: [http://www.google.com/+/learnmore/hangouts/ G+ hangout] (to be investigated; smartphones only? is Jitsi on a desktop computer compatible?)

For details, see [[IRC]]

Please add yourself here below (please add also your gmail account for G+ hangout):

* [[User:Landa|Martin Landa]], [http://www.timeanddate.com/worldclock/city.html?n=204 timezone]. Gmail is <landa.martin@> expanded
* [[User:huhabla|Soeren Gebbert]], [http://www.timeanddate.com/worldclock/city.html?n=971 timezone]
* [[User:Ecologeek|Sylvain Maillard]], [http://www.timeanddate.com/worldclock/city.html?n=333 timezone] : available sunday and week evenings
* [[User:HamishBowman|Hamish]], [http://www.timeanddate.com/worldclock/city.html?n=952 timezone] : limited availability, but best effort. Gmail is <h.b@> expanded
* [[User:Madi|Margherita Di Leo]], [http://www.timeanddate.com/worldclock/city.html?n=2500 timezone] dileomargherita AT gmail DOT com
* [[User:epifanio|Massimo Di Stefano]], [http://www.timeanddate.com/worldclock/city.html?n=43 timezone] massimodisasha AT gmail DOT com

'''Timing hangout meetings:'''

* Date, time

=== Collaborative document scratching ===

Wish: please reduce to one Etherpad server to avoid confusion:

* (This wiki)
* '''[http://etherpad.osuosl.org OSU OSL's Etherpad]'''
* [http://typewith.me Etherpad Lite]
* [http://etherpad.mozilla.org Mozilla's Etherpad]
* [http://titanpad.com TitanPad's Etherpad]

== Individual Preparation ==

* Bring your own computer
* Bring [http://en.wikipedia.org/wiki/Mains_electricity_by_country your power connector adapter] if needed ([http://en.wikipedia.org/wiki/File:L_plug.jpg Italy])
* Install subversion and the compiler tools, and come with a working GRASS development environment if possible.

== Photos ==

Also during the event :)

== FAQ ==

* '''How was it last time?'''
** Very cool, see [[GRASS Community Sprint Prague 2012]]!

* '''Is the GRASS Community Sprint just a coding event?'''
** It is mainly a coding and documentation event. It is a working session for people who are already participants in the GRASS project and/or are committed to improving the GRASS project.
** On demand, however, we can do some presentations of current working GRASS implementations and new upcoming features to spread the idea of Open Source GIS software.

* '''Is the GRASS Community Sprint for developers only?'''
** ''Not at all!'' Anybody can help with testing, checking out bugs and fixes, documentation and more.

* '''Where can I get help and more information about the community sprint?'''
** Contact [[User:Lucadelu|Luca Delucchi]] <tt><lucadeluge at gmail dot com></tt> or [[User:Neteler|Markus Neteler]]

[[Category: Workshops]]

Openoffice.org with SQL Databases

2008-03-22T15:00:29Z

⚠️Epifanio:

Do you also dislike it to manually convert Excel tables into PostgreSQL? Not having real fun in exporting to CSV, then manually writing the SQL header and importing the stuff in PG? This article here '''explains how to convert a table into an SQL database via OpenOffice'''. Essentially you open the Excel (or whatever) table with OpenOffice-Calc, select and copy the full table or a subset to the clipboard, and simply paste it into OpenOffice-Base with the right mouse button. A wizard pops up which let's you define the type of each column and a primary key. Save & done. Can't be easier!

== Usage of OpenOffice-Base with various drivers ==

* See [http://dba.openoffice.org/drivers/index.html Database drivers] page for overview. There are drivers for PostgreSQL, SQLite and MS-Access mdb files.

=== PostgreSQL (OpenOffice.org 2.x) ===

==== Installation of PostgreSQL driver (MS-Windows and Linux) ====

* http://dba.openoffice.org/drivers/postgresql/index.html

# download postgresql-sdbc-X.Y.Z.zip driver (take the "recommended" file) and save the file to your disk.
# Start OpenOffice, choose 'Tools/Package Manager'. Click on the add button and select the downladed file (DO NOT EXTRACT IT !) in the upcoming File dialog. The driver gets installed now, afterwards, the file is listed in the dialog with state enabled. In case you have installed an older version of the driver, remove it now. Close the dialog.
# Restart openoffice (even the quickstarter on windows must be shut down !!!).
# Done (did you really close openoffice? Please do.)

==== Usage of PostgreSQL driver (MS-Windows and Linux) ====

After starting OpenOffice.org again, use: File -> New -> Database to enter the DB dialog.

* Connect to existing database (select driver): postgresql
* Connection settings: We have to define the server ("host") name and the name of the database, probably also the user name in case you have to connect with a different user name. To find out, '''ask your DB administrator''' or use in a terminal "psql -l " or, if the database is on a remote server, "psql -h host.mydomain.org -l". An entry may look like this:
dbname=pgtest host=my.databaseserver.org
* User name (the login name): yourname
* Finish brings you to a 'Save as' dialog for the connection, saves these settings as file. This file you can use later to re-establish the connection (instead of defining all again).
* Then click on 'Tables' in the next screen to see the existing PG tables in the database. Usually the 'public' scheme contains the user tables.
* The 'Queries' button takes you to the query mode, it contains a graphical query designer.

==== Installation of PostgreSQL driver (MacOSX) ====

Please use the [http://jdbc.postgresql.org/download.html JDBC driver].

There are not mac OSX version of official SDBC driver, you can connect your postgreSQL database using the JDBC driver.

<br>
1)Download the JDBC driver at :
[http://jdbc.postgresql.org/download.html PosgreeSQL]
<br>
(select the driver for your pgsql version)
for example with postgreSQL-8.2 (postgresql framework installation - until 20/3/2008)we need to download this driver:

[http://jdbc.postgresql.org/download/postgresql-8.2-508.jdbc2.jar pgsql_8.2_driver]

2) Open Neooffice
- preferences:

http://img118.imageshack.us/img118/109/preferenzeap3.png

select :

Java

http://img236.imageshack.us/img236/6004/javaqr9.png

clik on :

classpath

http://img50.imageshack.us/img50/3504/immagine1tb1.png

click on :

add archive ( aggiungi archivio )

select the downloaded driver

click on :

ok

3) Come back to :

neooffice - database

http://img67.imageshack.us/img67/2043/databasevn2.png

In the database configuration window:

http://img54.imageshack.us/img54/3386/selezionadatabnv6.png

at the point : connect to an existant database (collega a un database esistente), select the option :

JDBC

clik on :

next (avanti)

http://img111.imageshack.us/img111/2128/immagine3uw6.png

insert the url to your pgsql database (in this example we have host=localhost, dbname=grassdb):

postgreesql://localhost/grassdb

class driver JDBC :

org.postgresql.Driver

click on :

try class (classe di prova)

if oll is ok :

http://img125.imageshack.us/img125/9330/immagine2kw6.png

clik on :

ok

go to the next step

http://img67.imageshack.us/img67/8527/immagine13dv9.png

insert :

user name

chek the flag 'request password'

clik on :

try connection ( connessione di prova )

http://img300.imageshack.us/img300/9965/immagine6ck5.png

insert :

password

click on :

ok

if oll is ok :

http://img64.imageshack.us/img64/896/immagine7ak2.png

click on :

next (avanti)

http://img103.imageshack.us/img103/8379/immagine8kf6.png

click on

end ( fine )

to save the database

http://img109.imageshack.us/img109/815/immagine9ph2.png

database succesfooll created:

http://img113.imageshack.us/img113/686/immagine10di9.png

[[Category: FAQ]]

=== MySQL (OpenOffice.org 2.x) ===

* Connection via JODBC driver: http://kienlein.com/pages/mysql-jdbc-howto-en.html

=== DBF files (OpenOffice.org 2.x) ===

No installation needed, the driver is included in the standard version of OpenOffice.org.

=== MS-Access mdb files (OpenOffice.org 2.x) ===

<strike>
* http://dba.openoffice.org/drivers/mdb/index.html Note that the driver is somewhat behind the mdbtools.sf.net development.
</strike>

* Connect through ODBC based connection: http://www.openoffice.org/FAQs/ms-access/ms-access.html . For Linux, you need [http://www.unixodbc.org/ unixODBC] to be installed (your preferred distribution most likely contains this package). Get also the [http://mdbtools.sourceforge.net/ MDB Tools] (preferably fresh from CVS since the 0.5 release is old; compile with unixodbc support enabled). Then follow instructions at http://www.gdal.org/ogr/drv_pgeo.html (or add them here).

=== SQLite files (OpenOffice.org 2.x) ===

* <strike>[http://dba.openoffice.org/drivers/sqlite/index.html OO-Base SQLite driver] (driver still in alpha state)</strike>
* [http://www.ch-werner.de/sqliteodbc/ SQLite ODBC Driver] (wrapped SQLite library into an ODBC driver). Installation:

After installation of 'sqliteodbc', add the driver to /etc/odbcinst.ini (either add next lines or create as new file if the file does not yet exist):
[SQLite]
Description=SQLite ODBC Driver
Driver=/usr/local/lib/libsqlite3odbc.so
Setup=/usr/local/lib/libsqlite3odbc.so

Now the SQLite driver is available for ODBC. The next step is to add the definition(s) of the database you want to connect to. Add an ODBC Data Source Name (DSN) to your definition file at $HOME/.odbc.ini (replace 'user' and 'mymapset' with the correct entries):
[nc_sqlite]
Description=North Carolina SQLite DB
Driver=SQLite
Database=/home/user/grassdata/nc_spm/mymapset/sqlite.db
# optional lock timeout in milliseconds
Timeout=2000

== Converting Excel, CSV, ... to PostgreSQL/MySQL/... via OO-Base ==

* [http://searchopensource.techtarget.com/tip/0,289483,sid39_gci1222186,00.html Bringing data into OpenOffice 2.0's database]: You can for example open an Excel file with OpenOffice, select contents, then open a DB connection in OpenOfficeBase and paste the table into it. The wizard allows to define the type of each column before creating the table. Using the right mouse button on a column name, you can define it as primary key. '''Important:''' If generating a PostgreSQL table, prefix the new table name with "public." (example: public.table1) to avoid that the user name is used as schema name.

=== Step by step DB import procedure (MS-Windows and Linux) ===

Here we show how to get a spreadsheet table into a SQL database.

'''1. Mark and copy to clipboard the relevant table parts in the Excel/CSV/whatever table (OO-Calc):'''

Open the original table with OpenOffice-Calc. For CSV files, they need the .csv extension.

[[Image:oo_calc_small.png|none]] (see also [[media:oo_calc.png|larger screenshot]])

'''2. Open OO-Base and establish a connection to the database (see above for driver installation):'''

Go File -> New -> Database to launch OO-Base.

[[Image:oobase_pg_connect1_small.png|none]] (see also [[media:oobase_pg_connect1.png|larger screenshot]])

[[Image:oobase_pg_connect2_small.png|none]] (see also [[media:oobase_pg_connect2.png|larger screenshot]])

[[Image:oobase_pg_connect3_small.png|none]] (see also [[media:oobase_pg_connect3.png|larger screenshot]])

'''3. In the table wizard, paste (right mouse button) earlier selected OO-Calc spreadsheet into the table section:'''

First select "table" from left menu, then paste into it:

[[Image:oo_base_paste_small.png|none]] (see also [[media:oo_base_paste.png|larger screenshot]])

'''4. A wizard opens, define a table name:'''

When connecting to PostgreSQL, be sure to write a prefix for the schema, usually "public.":

[[Image:oo_base_newtable1_small.png|none]] (see also [[media:oo_base_newtable1.png|larger screenshot]])

'''5. Select the columns you want to transfer:'''

[[Image:oo_base_newtable2_small.png|none]] (see also [[media:oo_base_newtable2.png|larger screenshot]])

'''6. Define primary key (right mouse button on desired column) and all column types:'''

WARNING: If you make a mistake in defining the column types, all rows after the first failing conversion will be silently ignored. Verify later that all rows arrived in the final SQL table.

[[Image:oo_base_newtable3_small.png|none]] (see also [[media:oo_base_newtable3.png|larger screenshot]])

'''7. Save and enjoy. The table is now written into your SQL database.'''

Note that the conversion can take some time.

You can now connect the table to GRASS, R-stats, ... as you like.

=== Step by step DB import procedure (MacOSX) ===

There are not difference between osx and linux.
<br/>Look for 'Step by step DB import procedure (MS-Windows and Linux)'.

Compiling on MacOSX

2007-03-04T10:24:35Z

⚠️Epifanio:

To build Grass from source you can use the frameworks that are on :
http://www.kyngchaos.com/software/unixport/frameworks
great thanks to W.Kyngesbury

after install the "all frameworks" you can add some library such "motif" needed by Xganim, using fink or build the source code

install from source the tcl-tk library : http://www.tcl.tk/software/tcltk/downloadnow84.tml in /usr/local

download a cvs version http://grass.itc.it/download/index.php

then configure and make grass cvs :

cd /path_to_grass_source

./configure --prefix=/usr/local --enable-sysv --with-x --with-opengl=x11 --without-odbc --with-cxx --with-freetype

--with-freetype-includes=/Library/Frameworks/FreeType.framework/unix/include

--with-freetype-libs=/Library/Frameworks/FreeType.framework/unix/lib

--with-gdal=/Library/Frameworks/GDAL.framework/Versions/1.4/Programs/gdal-config

--with-proj-includes=/Library/Frameworks/PROJ.framework/unix/include

--with-proj-libs=/Library/Frameworks/PROJ.framework/unix/lib

--with-proj-share=/Library/Frameworks/PROJ.framework/Versions/4.5/unix/share/

--with-jpeg --with-jpeg-includes=/Library/Frameworks/UnixImageIO.framework/unix/include

--with-jpeg-libs=/Library/Frameworks/UnixImageIO.framework/unix/lib

--with-tiff --with-tiff-includes=/Library/Frameworks/UnixImageIO.framework/unix/include

--with-tiff-libs=/Library/Frameworks/UnixImageIO.framework/unix/lib

--with-png-includes=/Library/Frameworks/UnixImageIO.framework/unix/include

--with-png-libs=/Library/Frameworks/UnixImageIO.framework/unix/lib

--with-sqlite --with-sqlite-libs=/Library/Frameworks/SQLite3.framework/unix/lib

--with-sqlite-includes=/Library/Frameworks/SQLite3.framework/unix/include

--with-fftw --with-fftw-includes=/Library/Frameworks/FFTW3.framework/unix/include

--with-fftw-libs=/Library/Frameworks/FFTW3.framework/unix/lib

--with-postgres-includes=/usr/local/pgsql/include --with-postgres-libs=/usr/local/pgsql/lib

--with-freetype --with-freetype-includes=/Library/Frameworks/FreeType.framework/unix/include

--with-freetype-libs=/Library/Frameworks/FreeType.framework/unix/lib --with-python --with-readline

--with-readline-includes=/sw/include/readline --with-readline-libs=/sw/lib --with-tcltk-includes=/usr/local/include

--with-tcltk-libs=/usr/local/lib

--with-blas --with-blas-libs=/System/Library/Frameworks/Accelerate.framework/Versions/A/Frameworks/vecLib.framework/Versions/A/

--with-lapack --with-lapack-libs=/System/Library/Frameworks/Accelerate.framework/Versions/A/Frameworks/vecLib.framework/Versions/A/

--with-motif --with-motif-includes=/sw/include --with-motif-libs=/sw/lib --with-glw

Compile and Install

2007-03-04T10:00:54Z

⚠️Epifanio: /* Mac OSX */

== How to do compilation and installation of GRASS 6? ==

Here we explain the procedure to compile GRASS from CVS, but it also applies to official GRASS 6 releases.

''For installation of precompiled binary packages, see the main [[Installation Guide]].''

For detailed information on compilation, please see the [http://grass.itc.it/grass61/source/INSTALL INSTALL] file in the source code.

=== Prerequisites ===

GRASS needs at least two extra libraries: PROJ and GDAL/OGR

''Note: if you want to have DBMS support in GDAL (subsequently in GRASS) you have to perform the "Optional" steps below as well.''

* [http://proj.maptools.org PROJ4] for management of projections (with proj-datumgrid-1.3.zip support)
* Optional: [http://geos.refractions.net GEOS]
* Optional: [http://www.postgresql.org PostgreSQL], [http://www.mysql.org mySQL], [http://www.unixodbc.org unixODBC], [http://www.sqlite.org SQLite] (SQLite is needed for QGIS)
* [http://www.gdal.org GDAL/OGR] for reading and writing various GIS data formats (interoperability)

You have to install these two libraries '''first'''.

It is easiest to obtain a prepackaged version of these libraries (e.g., .rpm; .deb) for your particular operating system and run the corresponding package installation (e.g., rpm -Uhv packagename.rpm; apt-get) in a terminal window. Take care to also install the development packages of these libraries (...-devel packages). If there is no prepackage version, then you will have to download the source code (see links above, source code packages usually ends in .tar.gz or .zip) and compile it (you must have a C compiler installed as part of your operating system). The Web sites show the steps to compile the libraries.

Other libraries needed to run GRASS are listed here: [http://grass.itc.it/grass63/source/REQUIREMENTS.html REQUIREMENTS]. To compile, you will also need the respective "-devel" packages.

=== Generic Compilation and installation procedure ===

* checkout the grass6 module from cvs (read http://grass.itc.it/faq/cvs_howto.html grass CVS howto instructions)
* It is wise that compilation processes are carried out as a normal user: If you want to get the source code in a place where you do not have write permissions (e.g. in /usr/local/src/cvs) just follow this:
cd /usr/local/src/cvs
su -c 'mkdir grass6'
su -c 'chown yourlogin:yourgroup grass6'
* do a checkout (co) of the repository
cvs -z3 co grass6
* in the grass6 directory, you will find the precious INSTALL file, open it with your favourite pager/editor and read it carefully!
* run configure with parameters to adapt the compile process to your own system. To see what options can be passed to it, run configure --help. The minimum set of configure parameters is (refers to GRASS 6 from CVS, not to 6.x release):
./configure ### It may (!) look like this:
./configure \
--with-cxx \
--with-sqlite \
--with-postgres-libs=/usr/include/pgsql/libpq \
--with-postgres-includes=/usr/include/pgsql \
--with-freetype \
--with-freetype-includes=/usr/include/freetype2 \
--with-motif \
--with-glw \
--with-proj-share=/usr/share/proj

You may have to explicitly state the path for certain packages (i.e., gdal). The Unix 'locate' command will come in handy for finding the path of the package you need (you may have to run locate as root ex: sudo locate gdal-config).

Please note that the paths mentioned may widely vary due to the distribution used. At the end of configuration process you should get report not much different from this:

GRASS is now configured for: i686-pc-linux-gnu

Source directory: /usr/src/grass6
Build directory: /usr/src/grass6
Installation directory: /usr/local/grass-6.1.cvs
Startup script in directory: ${exec_prefix}/bin
C compiler: gcc -g -O2
C++ compiler: c++ -g -O2
FORTRAN compiler:
Building shared libraries: yes
64bit support: no

NVIZ: yes

BLAS support: no
C++ support: yes
DWG support: no
FFMPEG support: no
FFTW support: yes
FreeType support: yes
GDAL support: yes
GLw support: no
JPEG support: yes
LAPACK support: no
Large File Support (LFS): no
Motif support: no
MySQL support: no
NLS support: no
ODBC support: no
OGR support: yes
OpenGL(R) support: yes
PNG support: yes
PostgreSQL support: yes
Readline support: no
SQLite support: no
Tcl/Tk support: yes
TIFF support: yes
X11 support: yes

* Let's compile it (takes a little while...)!
make
* At the end, you should get report not much different from this:
----------------------------------------------------------------------
Following modules are missing the 'description.html' file in src code:
----------------------------------------------------------------------
GRASS GIS compilation log
-------------------------
Started compilation: Ne kvě 28 13:18:43 CEST 2006
--
Errors in:
--
Finished compilation: Ne kvě 28 13:43:40 CEST 2006
(In case of errors please change into the directory with error and run 'make')

* If there is any error, change directory to directory with error and run "make" again. Report occuring bug to grass mailing list
* Once the installation process is finished, you're ready to install GRASS system wide.
su -c 'make install'
* enjoy GRASS:
grass61

=== What else? ===

If you want to use [http://www.qgis.org QGIS], then also compile the GRASS-GDAL/OGR plugin. This is also useful to access your GRASS-data
from other application using GDAL/OGR like [http://thuban.intevation.de thuban].
* [[Compile and install GRASS and QGIS with GDAL/OGR Plugin]] (enables QGIS to read GRASS data directly)

=== Platform Specific Notes ===

==== Debian ====

# first install PROJ, then GDAL.
cd grass63/
fakeroot buildpackage

* [http://hamish.bowman.googlepages.com/debiangisfiles#compile Compiling GRASS 6.1-CVS on Debian/Stable (aka 3.1, Sarge)]

* Official [http://pkg-grass.alioth.debian.org/cgi-bin/wiki.pl DebianGIS] packaging [http://svn.debian.org/wsvn/pkg-grass/packages/grass/branches/ control files].

==== Ubuntu 6.06 ====

* [http://david.p.finlayson.googlepages.com/makegrass.sh makegrass.sh] is script designed to automate most of the download, configuration and compilation of GRASS 6.x-CVS
* [[User:Steko/Automated_CVS_compiling|Here]] is another of these scripts, it's homemade so probably you'll find the above more useful for production sites.

==== RPM SPEC files ====

... can be found in the source code, rpm/ directory, or [http://www.gdf-hannover.de/media.php?id=1&lg=en here]

==== MS-Windows/Cygwin ====

... see [http://grass.itc.it/platforms/wingrass.html here] (should be moved to the Wiki)

==== MS-Windows/native ====

See also [[WinGRASS Current Status]] for latest updates.

For this, you need MinGW and MSys, including gcc, g++, binutils, flex, bison, make, and pdcurses, all from:
http://www.mingw.org/download.shtml

You also need this version of the XDR library:
http://wiki.qgis.org/qgiswiki/BuildingWindowsBinaryOnLinux?action=AttachFile&do=get&target=xdr-4.0-mingw2.tar.gz

The above is a stripped-down version of the Sun RPC library, which only includes the XDR [de]serialisation code, with the networking code removed.

You will first need to build and install zlib, PNG, PROJ, GDAL and the above XDR library. Then, building GRASS is similar to building it on Linux, except that you need to disable most of the optional features (including the use of shared libraries).

Aside: it might encourage more people to work on the Windows version if the GRASS site contained binary versions of the necessary libraries. Having to build XDR, PROJ, GDAL, zlib, PNG, Tcl/Tk and possibly other stuff from source before you can start to compile GRASS is a major nuisance.

... or see [http://wiki.qgis.org/qgiswiki/BuildingWindowsBinaryOnLinux here incl. QGIS compilation] (with MinGW)

==== Mac OSX ====

... see [http://grass.itc.it/platforms/macgrass.php here] for instructions

... [[or this other way]]

==== Zaurus====

... see [http://wiki.debian.org/?GrassGISonZaurus here] for instructions

=== Common problems and solutions ===

During compilation, error can occur if certain packages are not installed. Here a list of problems with solution:

* error: X11/Xlib.h: No such file or directory
** this suggests that you don't have the X headers installed
** Solution: Install the libx11-dev package

=== Configure options and their meanings ===

For configure there are many options and some GRASS modules are built only if some options are set. Here are listed common configuration options with short explanation.

* --prefix=/path - Sets path where GRASS will be installed. GRASS will reside in /path/grass-version.
* --enable-largefile - Enables large (>2Gb on 32bit systems) support. For current large file support status look at [[Large File Support]] page.
* --with-cxx - Enables compilation of C++ code. Required for r.terraflow module.
* --with-readline - Enables readline support. If readline is enabled, you can use its history/editing facilities when entering r.mapcalc expressions on stdin.
* --with-glw - Enables GLw support. The GLw library provides OpenGL "canvas" widgets for Athena and Motif.

That switch is unnecessary for normal compilation. It's only
required for r3.showdspf, which isn't normally built; if you
want it, you have build it manually
(e.g. "make -C raster3d/r3.showdspf").
As similar functionality is now provided by NVIZ, r3.showdspf
is deprecated.
r3.showdspf uses the Motif widget (so you also need a
Motif library, e.g. Lesstif or OpenMotif).
[http://grass.itc.it/pipermail/grassuser/2006-December/037475.html Glynn Clements at GRASS-user mailing list]

[[Category:Development]]
[[Category:Documentation]]
[[Category:Installation]]

Openoffice.org with SQL Databases

2006-12-04T12:27:40Z

⚠️Epifanio: /* Step by step DB import procedure (MacOSX) */

Do you also dislike it to manually convert Excel tables into PostgreSQL? Not having real fun in exporting to CSV, then manually writing the SQL header and importing the stuff in PG? This article here '''explains how to convert a table into an SQL database via OpenOffice'''. Essentially you open the Excel (or whatever) table with OpenOffice-Calc, select and copy the full table or a subset to the clipboard, and simply paste it into OpenOffice-Base with the right mouse button. A wizard pops up which let's you define the type of each column and a primary key. Save & done. Can't be easier!

== Usage of OpenOffice-Base with various drivers ==

* See [http://dba.openoffice.org/drivers/index.html Database drivers] page for overview. There are drivers for PostgreSQL, SQLite and MS-Access mdb files.

=== PostgreSQL (OpenOffice.org 2.x) ===

==== Installation of PostgreSQL driver (MS-Windows and Linux) ====

* http://dba.openoffice.org/drivers/postgresql/index.html

# download postgresql-sdbc-X.Y.Z.zip driver (take the "recommended" file) and save the file to your disk.
# Start OpenOffice, choose 'Tools/Package Manager'. Click on the add button and select the downladed file (DO NOT EXTRACT IT !) in the upcoming File dialog. The driver gets installed now, afterwards, the file is listed in the dialog with state enabled. In case you have installed an older version of the driver, remove it now. Close the dialog.
# Restart openoffice (even the quickstarter on windows must be shut down !!!).
# Done (did you really close openoffice? Please do.)

==== Usage of PostgreSQL driver (MS-Windows and Linux) ====

After starting OpenOffice.org again, use: File -> New -> Database to enter the DB dialog.

* Connect to existing database (select driver): postgresql
* Connection settings: We have to define the server ("host") name and the name of the database, probably also the user name in case you have to connect with a different user name. To find out, '''ask your DB administrator''' or use in a terminal "psql -l " or, if the database is on a remote server, "psql -h host.mydomain.org -l". An entry may look like this:
dbname=pgtest host=my.databaseserver.org
* User name (the login name): yourname
* Finish brings you to a 'Save as' dialog for the connection, saves these settings as file. This file you can use later to re-establish the connection (instead of defining all again).
* Then click on 'Tables' in the next screen to see the existing PG tables in the database. Usually the 'public' scheme contains the user tables.
* The 'Queries' button takes you to the query mode, it contains a graphical query designer.

==== Installation of PostgreSQL driver (MacOSX) ====

Please use the [http://jdbc.postgresql.org/download.html JDBC driver].

There are not mac OSX version of official SDBC driver, you can connect your postgreSQL database using the JDBC driver.

<br>
1)Download the JDBC driver at :
[http://jdbc.postgresql.org/download.html PosgreeSQL]
<br>
(select the driver for your pgsql version)
for example with postgreSQL-8.1 we need to download this driver:

JDBC 8.1-407 JDBC 2

2) Open Neooffice
- preferences:

http://img118.imageshack.us/img118/109/preferenzeap3.png

select :

Java

http://img236.imageshack.us/img236/6004/javaqr9.png

clik on :

classpath

http://img50.imageshack.us/img50/3504/immagine1tb1.png

click on :

add archive ( aggiungi archivio )

select the downloaded driver

click on :

ok

3) Come back to :

neooffice - database

http://img67.imageshack.us/img67/2043/databasevn2.png

In the database configuration window:

http://img54.imageshack.us/img54/3386/selezionadatabnv6.png

at the point : connect to an existant database (collega a un database esistente), select the option :

JDBC

clik on :

next (avanti)

http://img111.imageshack.us/img111/2128/immagine3uw6.png

insert the url to your pgsql database (in this example we have host=localhost, dbname=grassdb):

postgreesql://localhost/grassdb

class driver JDBC :

org.postgresql.Driver

click on :

try class (classe di prova)

if oll is ok :

http://img125.imageshack.us/img125/9330/immagine2kw6.png

clik on :

ok

go to the next step

http://img67.imageshack.us/img67/8527/immagine13dv9.png

insert :

user name

chek the flag 'request password'

clik on :

try connection ( connessione di prova )

http://img300.imageshack.us/img300/9965/immagine6ck5.png

insert :

password

click on :

ok

if oll is ok :

http://img64.imageshack.us/img64/896/immagine7ak2.png

click on :

next (avanti)

http://img103.imageshack.us/img103/8379/immagine8kf6.png

click on

end ( fine )

to save the database

http://img109.imageshack.us/img109/815/immagine9ph2.png

database succesfooll created:

http://img113.imageshack.us/img113/686/immagine10di9.png

[[Category: FAQ]]

=== MySQL (OpenOffice.org 2.x) ===

* Connection via JODBC driver: http://kienlein.com/pages/mysql-jdbc-howto-en.html

=== DBF files (OpenOffice.org 2.x) ===

No installation needed, the driver is included in the standard version of OpenOffice.org.

=== MS-Access mdb files (OpenOffice.org 2.x) ===

* http://dba.openoffice.org/drivers/mdb/index.html

Note that the driver is somewhat behind the mdbtools.sf.net development.

* See also ODBC based connection: http://www.openoffice.org/FAQs/ms-access/ms-access.html

=== SQLite files (OpenOffice.org 2.x) ===

* http://dba.openoffice.org/drivers/sqlite/index.html

== Converting Excel, CSV, ... to PostgreSQL/MySQL/... via OO-Base ==

* [http://searchopensource.techtarget.com/tip/0,289483,sid39_gci1222186,00.html Bringing data into OpenOffice 2.0's database]: You can for example open an Excel file with OpenOffice, select contents, then open a DB connection in OpenOfficeBase and paste the table into it. The wizard allows to define the type of each column before creating the table. Using the right mouse button on a column name, you can define it as primary key. '''Important:''' If generating a PostgreSQL table, prefix the new table name with "public." (example: public.table1) to avoid that the user name is used as schema name.

=== Step by step DB import procedure (MS-Windows and Linux) ===

Here we show how to get a spreadsheet table into a SQL database.

'''1. Mark and copy to clipboard the relevant table parts in the Excel/CSV/whatever table (OO-Calc):'''

Open the original table with OpenOffice-Calc. For CSV files, they need the .csv extension.

[[Image:oo_calc_small.png|none]] (see also [[media:oo_calc.png|larger screenshot]])

'''2. Open OO-Base and establish a connection to the database (see above for driver installation):'''

Go File -> New -> Database to launch OO-Base.

[[Image:oobase_pg_connect1_small.png|none]] (see also [[media:oobase_pg_connect1.png|larger screenshot]])

[[Image:oobase_pg_connect2_small.png|none]] (see also [[media:oobase_pg_connect2.png|larger screenshot]])

[[Image:oobase_pg_connect3_small.png|none]] (see also [[media:oobase_pg_connect3.png|larger screenshot]])

'''3. In the table wizard, paste (right mouse button) earlier selected OO-Calc spreadsheet into the table section:'''

First select "table" from left menu, then paste into it:

[[Image:oo_base_paste_small.png|none]] (see also [[media:oo_base_paste.png|larger screenshot]])

'''4. A wizard opens, define a table name (when connecting to PostgreSQL, write "public." as prefix for the schema):'''

[[Image:oo_base_newtable1_small.png|none]] (see also [[media:oo_base_newtable1.png|larger screenshot]])

'''5. Select the columns you want to transfer:'''

[[Image:oo_base_newtable2_small.png|none]] (see also [[media:oo_base_newtable2.png|larger screenshot]])

'''6. Define primary key (right mouse button on desired column) and all column types:'''

[[Image:oo_base_newtable3_small.png|none]] (see also [[media:oo_base_newtable3.png|larger screenshot]])

'''7. Save and enjoy. The table is now written into your SQL database.'''

Note that the conversion can take some time.

You can now connect the table to GRASS, R-stats, ... as you like.

=== Step by step DB import procedure (MacOSX) ===

There are not difference between osx and linux.
<br/>Look for 'Step by step DB import procedure (MS-Windows and Linux)'.

Openoffice.org with SQL Databases

2006-12-04T12:25:52Z

⚠️Epifanio: /* Step by step DB import procedure (MacOSX) */

Do you also dislike it to manually convert Excel tables into PostgreSQL? Not having real fun in exporting to CSV, then manually writing the SQL header and importing the stuff in PG? This article here '''explains how to convert a table into an SQL database via OpenOffice'''. Essentially you open the Excel (or whatever) table with OpenOffice-Calc, select and copy the full table or a subset to the clipboard, and simply paste it into OpenOffice-Base with the right mouse button. A wizard pops up which let's you define the type of each column and a primary key. Save & done. Can't be easier!

== Usage of OpenOffice-Base with various drivers ==

* See [http://dba.openoffice.org/drivers/index.html Database drivers] page for overview. There are drivers for PostgreSQL, SQLite and MS-Access mdb files.

=== PostgreSQL (OpenOffice.org 2.x) ===

==== Installation of PostgreSQL driver (MS-Windows and Linux) ====

* http://dba.openoffice.org/drivers/postgresql/index.html

# download postgresql-sdbc-X.Y.Z.zip driver (take the "recommended" file) and save the file to your disk.
# Start OpenOffice, choose 'Tools/Package Manager'. Click on the add button and select the downladed file (DO NOT EXTRACT IT !) in the upcoming File dialog. The driver gets installed now, afterwards, the file is listed in the dialog with state enabled. In case you have installed an older version of the driver, remove it now. Close the dialog.
# Restart openoffice (even the quickstarter on windows must be shut down !!!).
# Done (did you really close openoffice? Please do.)

==== Usage of PostgreSQL driver (MS-Windows and Linux) ====

After starting OpenOffice.org again, use: File -> New -> Database to enter the DB dialog.

* Connect to existing database (select driver): postgresql
* Connection settings: We have to define the server ("host") name and the name of the database, probably also the user name in case you have to connect with a different user name. To find out, '''ask your DB administrator''' or use in a terminal "psql -l " or, if the database is on a remote server, "psql -h host.mydomain.org -l". An entry may look like this:
dbname=pgtest host=my.databaseserver.org
* User name (the login name): yourname
* Finish brings you to a 'Save as' dialog for the connection, saves these settings as file. This file you can use later to re-establish the connection (instead of defining all again).
* Then click on 'Tables' in the next screen to see the existing PG tables in the database. Usually the 'public' scheme contains the user tables.
* The 'Queries' button takes you to the query mode, it contains a graphical query designer.

==== Installation of PostgreSQL driver (MacOSX) ====

Please use the [http://jdbc.postgresql.org/download.html JDBC driver].

There are not mac OSX version of official SDBC driver, you can connect your postgreSQL database using the JDBC driver.

<br>
1)Download the JDBC driver at :
[http://jdbc.postgresql.org/download.html PosgreeSQL]
<br>
(select the driver for your pgsql version)
for example with postgreSQL-8.1 we need to download this driver:

JDBC 8.1-407 JDBC 2

2) Open Neooffice
- preferences:

http://img118.imageshack.us/img118/109/preferenzeap3.png

select :

Java

http://img236.imageshack.us/img236/6004/javaqr9.png

clik on :

classpath

http://img50.imageshack.us/img50/3504/immagine1tb1.png

click on :

add archive ( aggiungi archivio )

select the downloaded driver

click on :

ok

3) Come back to :

neooffice - database

http://img67.imageshack.us/img67/2043/databasevn2.png

In the database configuration window:

http://img54.imageshack.us/img54/3386/selezionadatabnv6.png

at the point : connect to an existant database (collega a un database esistente), select the option :

JDBC

clik on :

next (avanti)

http://img111.imageshack.us/img111/2128/immagine3uw6.png

insert the url to your pgsql database (in this example we have host=localhost, dbname=grassdb):

postgreesql://localhost/grassdb

class driver JDBC :

org.postgresql.Driver

click on :

try class (classe di prova)

if oll is ok :

http://img125.imageshack.us/img125/9330/immagine2kw6.png

clik on :

ok

go to the next step

http://img67.imageshack.us/img67/8527/immagine13dv9.png

insert :

user name

chek the flag 'request password'

clik on :

try connection ( connessione di prova )

http://img300.imageshack.us/img300/9965/immagine6ck5.png

insert :

password

click on :

ok

if oll is ok :

http://img64.imageshack.us/img64/896/immagine7ak2.png

click on :

next (avanti)

http://img103.imageshack.us/img103/8379/immagine8kf6.png

click on

end ( fine )

to save the database

http://img109.imageshack.us/img109/815/immagine9ph2.png

database succesfooll created:

http://img113.imageshack.us/img113/686/immagine10di9.png

[[Category: FAQ]]

=== MySQL (OpenOffice.org 2.x) ===

* Connection via JODBC driver: http://kienlein.com/pages/mysql-jdbc-howto-en.html

=== DBF files (OpenOffice.org 2.x) ===

No installation needed, the driver is included in the standard version of OpenOffice.org.

=== MS-Access mdb files (OpenOffice.org 2.x) ===

* http://dba.openoffice.org/drivers/mdb/index.html

Note that the driver is somewhat behind the mdbtools.sf.net development.

* See also ODBC based connection: http://www.openoffice.org/FAQs/ms-access/ms-access.html

=== SQLite files (OpenOffice.org 2.x) ===

* http://dba.openoffice.org/drivers/sqlite/index.html

== Converting Excel, CSV, ... to PostgreSQL/MySQL/... via OO-Base ==

* [http://searchopensource.techtarget.com/tip/0,289483,sid39_gci1222186,00.html Bringing data into OpenOffice 2.0's database]: You can for example open an Excel file with OpenOffice, select contents, then open a DB connection in OpenOfficeBase and paste the table into it. The wizard allows to define the type of each column before creating the table. Using the right mouse button on a column name, you can define it as primary key. '''Important:''' If generating a PostgreSQL table, prefix the new table name with "public." (example: public.table1) to avoid that the user name is used as schema name.

=== Step by step DB import procedure (MS-Windows and Linux) ===

Here we show how to get a spreadsheet table into a SQL database.

'''1. Mark and copy to clipboard the relevant table parts in the Excel/CSV/whatever table (OO-Calc):'''

Open the original table with OpenOffice-Calc. For CSV files, they need the .csv extension.

[[Image:oo_calc_small.png|none]] (see also [[media:oo_calc.png|larger screenshot]])

'''2. Open OO-Base and establish a connection to the database (see above for driver installation):'''

Go File -> New -> Database to launch OO-Base.

[[Image:oobase_pg_connect1_small.png|none]] (see also [[media:oobase_pg_connect1.png|larger screenshot]])

[[Image:oobase_pg_connect2_small.png|none]] (see also [[media:oobase_pg_connect2.png|larger screenshot]])

[[Image:oobase_pg_connect3_small.png|none]] (see also [[media:oobase_pg_connect3.png|larger screenshot]])

'''3. In the table wizard, paste (right mouse button) earlier selected OO-Calc spreadsheet into the table section:'''

First select "table" from left menu, then paste into it:

[[Image:oo_base_paste_small.png|none]] (see also [[media:oo_base_paste.png|larger screenshot]])

'''4. A wizard opens, define a table name (when connecting to PostgreSQL, write "public." as prefix for the schema):'''

[[Image:oo_base_newtable1_small.png|none]] (see also [[media:oo_base_newtable1.png|larger screenshot]])

'''5. Select the columns you want to transfer:'''

[[Image:oo_base_newtable2_small.png|none]] (see also [[media:oo_base_newtable2.png|larger screenshot]])

'''6. Define primary key (right mouse button on desired column) and all column types:'''

[[Image:oo_base_newtable3_small.png|none]] (see also [[media:oo_base_newtable3.png|larger screenshot]])

'''7. Save and enjoy. The table is now written into your SQL database.'''

Note that the conversion can take some time.

You can now connect the table to GRASS, R-stats, ... as you like.

=== Step by step DB import procedure (MacOSX) ===

There are not difference between osx and linux. Look for 'Editing Openoffice SQL Databases' ( Linux ).

Openoffice.org with SQL Databases

2006-12-03T21:59:08Z

⚠️Epifanio: /* Step by step DB import procedure (MacOSX) */

Do you also dislike it to manually convert Excel tables into PostgreSQL? Not having real fun in exporting to CSV, then manually writing the SQL header and importing the stuff in PG? This article here '''explains how to convert a table into an SQL database via OpenOffice'''. Essentially you open the Excel (or whatever) table with OpenOffice-Calc, select and copy the full table or a subset to the clipboard, and simply paste it into OpenOffice-Base with the right mouse button. A wizard pops up which let's you define the type of each column and a primary key. Save & done. Can't be easier!

== Usage of OpenOffice-Base with various drivers ==

* See [http://dba.openoffice.org/drivers/index.html Database drivers] page for overview. There are drivers for PostgreSQL, SQLite and MS-Access mdb files.

=== PostgreSQL (OpenOffice.org 2.x) ===

==== Installation of PostgreSQL driver (MS-Windows and Linux) ====

* http://dba.openoffice.org/drivers/postgresql/index.html

# download postgresql-sdbc-X.Y.Z.zip driver (take the "recommended" file) and save the file to your disk.
# Start OpenOffice, choose 'Tools/Package Manager'. Click on the add button and select the downladed file (DO NOT EXTRACT IT !) in the upcoming File dialog. The driver gets installed now, afterwards, the file is listed in the dialog with state enabled. In case you have installed an older version of the driver, remove it now. Close the dialog.
# Restart openoffice (even the quickstarter on windows must be shut down !!!).
# Done (did you really close openoffice? Please do.)

==== Usage of PostgreSQL driver (MS-Windows and Linux) ====

After starting OpenOffice.org again, use: File -> New -> Database to enter the DB dialog.

* Connect to existing database (select driver): postgresql
* Connection settings: We have to define the server ("host") name and the name of the database, probably also the user name in case you have to connect with a different user name. To find out, '''ask your DB administrator''' or use in a terminal "psql -l " or, if the database is on a remote server, "psql -h host.mydomain.org -l". An entry may look like this:
dbname=pgtest host=my.databaseserver.org
* User name (the login name): yourname
* Finish brings you to a 'Save as' dialog for the connection, saves these settings as file. This file you can use later to re-establish the connection (instead of defining all again).
* Then click on 'Tables' in the next screen to see the existing PG tables in the database. Usually the 'public' scheme contains the user tables.
* The 'Queries' button takes you to the query mode, it contains a graphical query designer.

==== Installation of PostgreSQL driver (MacOSX) ====

Please use the [http://jdbc.postgresql.org/download.html JDBC driver].

There are not mac OSX version of official SDBC driver, you can connect your postgreSQL database using the JDBC driver.

<br>
1)Download the JDBC driver at :
[http://jdbc.postgresql.org/download.html PosgreeSQL]
<br>
(select the driver for your pgsql version)
for example with postgreSQL-8.1 we need to download this driver:

JDBC 8.1-407 JDBC 2

2) Open Neooffice
- preferences:

http://img118.imageshack.us/img118/109/preferenzeap3.png

select :

Java

http://img236.imageshack.us/img236/6004/javaqr9.png

clik on :

classpath

http://img50.imageshack.us/img50/3504/immagine1tb1.png

click on :

add archive ( aggiungi archivio )

select the downloaded driver

click on :

ok

3) Come back to :

neooffice - database

http://img67.imageshack.us/img67/2043/databasevn2.png

In the database configuration window:

http://img54.imageshack.us/img54/3386/selezionadatabnv6.png

at the point : connect to an existant database (collega a un database esistente), select the option :

JDBC

clik on :

next (avanti)

http://img111.imageshack.us/img111/2128/immagine3uw6.png

insert the url to your pgsql database (in this example we have host=localhost, dbname=grassdb):

postgreesql://localhost/grassdb

class driver JDBC :

org.postgresql.Driver

click on :

try class (classe di prova)

if oll is ok :

http://img125.imageshack.us/img125/9330/immagine2kw6.png

clik on :

ok

go to the next step

http://img67.imageshack.us/img67/8527/immagine13dv9.png

insert :

user name

chek the flag 'request password'

clik on :

try connection ( connessione di prova )

http://img300.imageshack.us/img300/9965/immagine6ck5.png

insert :

password

click on :

ok

if oll is ok :

http://img64.imageshack.us/img64/896/immagine7ak2.png

click on :

next (avanti)

http://img103.imageshack.us/img103/8379/immagine8kf6.png

click on

end ( fine )

to save the database

http://img109.imageshack.us/img109/815/immagine9ph2.png

database succesfooll created:

http://img113.imageshack.us/img113/686/immagine10di9.png

[[Category: FAQ]]

=== MySQL (OpenOffice.org 2.x) ===

* Connection via JODBC driver: http://kienlein.com/pages/mysql-jdbc-howto-en.html

=== DBF files (OpenOffice.org 2.x) ===

No installation needed, the driver is included in the standard version of OpenOffice.org.

=== MS-Access mdb files (OpenOffice.org 2.x) ===

* http://dba.openoffice.org/drivers/mdb/index.html

Note that the driver is somewhat behind the mdbtools.sf.net development.

* See also ODBC based connection: http://www.openoffice.org/FAQs/ms-access/ms-access.html

=== SQLite files (OpenOffice.org 2.x) ===

* http://dba.openoffice.org/drivers/sqlite/index.html

== Converting Excel, CSV, ... to PostgreSQL/MySQL/... via OO-Base ==

* [http://searchopensource.techtarget.com/tip/0,289483,sid39_gci1222186,00.html Bringing data into OpenOffice 2.0's database]: You can for example open an Excel file with OpenOffice, select contents, then open a DB connection in OpenOfficeBase and paste the table into it. The wizard allows to define the type of each column before creating the table. Using the right mouse button on a column name, you can define it as primary key. '''Important:''' If generating a PostgreSQL table, prefix the new table name with "public." (example: public.table1) to avoid that the user name is used as schema name.

=== Step by step DB import procedure (MS-Windows and Linux) ===

Here we show how to get a spreadsheet table into a SQL database.

'''1. Mark and copy to clipboard the relevant table parts in the Excel/CSV/whatever table (OO-Calc):'''

Open the original table with OpenOffice-Calc. For CSV files, they need the .csv extension.

[[Image:oo_calc_small.png|none]] (see also [[media:oo_calc.png|larger screenshot]])

'''2. Open OO-Base and establish a connection to the database (see above for driver installation):'''

Go File -> New -> Database to launch OO-Base.

[[Image:oobase_pg_connect1_small.png|none]] (see also [[media:oobase_pg_connect1.png|larger screenshot]])

[[Image:oobase_pg_connect2_small.png|none]] (see also [[media:oobase_pg_connect2.png|larger screenshot]])

[[Image:oobase_pg_connect3_small.png|none]] (see also [[media:oobase_pg_connect3.png|larger screenshot]])

'''3. In the table wizard, paste (right mouse button) earlier selected OO-Calc spreadsheet into the table section:'''

First select "table" from left menu, then paste into it:

[[Image:oo_base_paste_small.png|none]] (see also [[media:oo_base_paste.png|larger screenshot]])

'''4. A wizard opens, define a table name (when connecting to PostgreSQL, write "public." as prefix for the schema):'''

[[Image:oo_base_newtable1_small.png|none]] (see also [[media:oo_base_newtable1.png|larger screenshot]])

'''5. Select the columns you want to transfer:'''

[[Image:oo_base_newtable2_small.png|none]] (see also [[media:oo_base_newtable2.png|larger screenshot]])

'''6. Define primary key (right mouse button on desired column) and all column types:'''

[[Image:oo_base_newtable3_small.png|none]] (see also [[media:oo_base_newtable3.png|larger screenshot]])

'''7. Save and enjoy. The table is now written into your SQL database.'''

Note that the conversion can take some time.

You can now connect the table to GRASS, R-stats, ... as you like.

=== Step by step DB import procedure (MacOSX) ===

The same procedure that is used for linux.
You can start an existant Neooffice-Pgsql database, or create a new.
To import a file open it :
for example :point.csv

http://img49.imageshack.us/img49/6703/immagine19oc8.png

copy the contens in the klipboard.

if you have an existent database, you can open it with:

http://img126.imageshack.us/img126/8664/immagine12xd0.png

select :

open

and browse to your "database.odb" file
chos it and clik:

open

now you have a window like this:

http://img106.imageshack.us/img106/9451/immagine13gk5.png

go to the table section, if you have a password it ask you for insert it.

http://img106.imageshack.us/img106/2706/immagine15xi8.png

copy the last selection from the clipboard to your database "schema"

http://img115.imageshack.us/img115/6281/immagine16ah6.png

clik on:

next

http://img108.imageshack.us/img108/5508/immagine17xf9.png

select the coloumn that you want import into your database

click on:

next

create

http://img163.imageshack.us/img163/4044/immagine18jg7.png

your table was succesfool loaded ito postgresql

note: if you do not have a "file.odb" to create it look for the Installation of PostgreSQL driver (MacOSX)

Openoffice.org with SQL Databases

2006-12-03T21:54:29Z

⚠️Epifanio: /* Step by step DB import procedure (MacOSX) */

Do you also dislike it to manually convert Excel tables into PostgreSQL? Not having real fun in exporting to CSV, then manually writing the SQL header and importing the stuff in PG? This article here '''explains how to convert a table into an SQL database via OpenOffice'''. Essentially you open the Excel (or whatever) table with OpenOffice-Calc, select and copy the full table or a subset to the clipboard, and simply paste it into OpenOffice-Base with the right mouse button. A wizard pops up which let's you define the type of each column and a primary key. Save & done. Can't be easier!

== Usage of OpenOffice-Base with various drivers ==

* See [http://dba.openoffice.org/drivers/index.html Database drivers] page for overview. There are drivers for PostgreSQL, SQLite and MS-Access mdb files.

=== PostgreSQL (OpenOffice.org 2.x) ===

==== Installation of PostgreSQL driver (MS-Windows and Linux) ====

* http://dba.openoffice.org/drivers/postgresql/index.html

# download postgresql-sdbc-X.Y.Z.zip driver (take the "recommended" file) and save the file to your disk.
# Start OpenOffice, choose 'Tools/Package Manager'. Click on the add button and select the downladed file (DO NOT EXTRACT IT !) in the upcoming File dialog. The driver gets installed now, afterwards, the file is listed in the dialog with state enabled. In case you have installed an older version of the driver, remove it now. Close the dialog.
# Restart openoffice (even the quickstarter on windows must be shut down !!!).
# Done (did you really close openoffice? Please do.)

==== Usage of PostgreSQL driver (MS-Windows and Linux) ====

After starting OpenOffice.org again, use: File -> New -> Database to enter the DB dialog.

* Connect to existing database (select driver): postgresql
* Connection settings: We have to define the server ("host") name and the name of the database, probably also the user name in case you have to connect with a different user name. To find out, '''ask your DB administrator''' or use in a terminal "psql -l " or, if the database is on a remote server, "psql -h host.mydomain.org -l". An entry may look like this:
dbname=pgtest host=my.databaseserver.org
* User name (the login name): yourname
* Finish brings you to a 'Save as' dialog for the connection, saves these settings as file. This file you can use later to re-establish the connection (instead of defining all again).
* Then click on 'Tables' in the next screen to see the existing PG tables in the database. Usually the 'public' scheme contains the user tables.
* The 'Queries' button takes you to the query mode, it contains a graphical query designer.

==== Installation of PostgreSQL driver (MacOSX) ====

Please use the [http://jdbc.postgresql.org/download.html JDBC driver].

There are not mac OSX version of official SDBC driver, you can connect your postgreSQL database using the JDBC driver.

<br>
1)Download the JDBC driver at :
[http://jdbc.postgresql.org/download.html PosgreeSQL]
<br>
(select the driver for your pgsql version)
for example with postgreSQL-8.1 we need to download this driver:

JDBC 8.1-407 JDBC 2

2) Open Neooffice
- preferences:

http://img118.imageshack.us/img118/109/preferenzeap3.png

select :

Java

http://img236.imageshack.us/img236/6004/javaqr9.png

clik on :

classpath

http://img50.imageshack.us/img50/3504/immagine1tb1.png

click on :

add archive ( aggiungi archivio )

select the downloaded driver

click on :

ok

3) Come back to :

neooffice - database

http://img67.imageshack.us/img67/2043/databasevn2.png

In the database configuration window:

http://img54.imageshack.us/img54/3386/selezionadatabnv6.png

at the point : connect to an existant database (collega a un database esistente), select the option :

JDBC

clik on :

next (avanti)

http://img111.imageshack.us/img111/2128/immagine3uw6.png

insert the url to your pgsql database (in this example we have host=localhost, dbname=grassdb):

postgreesql://localhost/grassdb

class driver JDBC :

org.postgresql.Driver

click on :

try class (classe di prova)

if oll is ok :

http://img125.imageshack.us/img125/9330/immagine2kw6.png

clik on :

ok

go to the next step

http://img67.imageshack.us/img67/8527/immagine13dv9.png

insert :

user name

chek the flag 'request password'

clik on :

try connection ( connessione di prova )

http://img300.imageshack.us/img300/9965/immagine6ck5.png

insert :

password

click on :

ok

if oll is ok :

http://img64.imageshack.us/img64/896/immagine7ak2.png

click on :

next (avanti)

http://img103.imageshack.us/img103/8379/immagine8kf6.png

click on

end ( fine )

to save the database

http://img109.imageshack.us/img109/815/immagine9ph2.png

database succesfooll created:

http://img113.imageshack.us/img113/686/immagine10di9.png

[[Category: FAQ]]

=== MySQL (OpenOffice.org 2.x) ===

* Connection via JODBC driver: http://kienlein.com/pages/mysql-jdbc-howto-en.html

=== DBF files (OpenOffice.org 2.x) ===

No installation needed, the driver is included in the standard version of OpenOffice.org.

=== MS-Access mdb files (OpenOffice.org 2.x) ===

* http://dba.openoffice.org/drivers/mdb/index.html

Note that the driver is somewhat behind the mdbtools.sf.net development.

* See also ODBC based connection: http://www.openoffice.org/FAQs/ms-access/ms-access.html

=== SQLite files (OpenOffice.org 2.x) ===

* http://dba.openoffice.org/drivers/sqlite/index.html

== Converting Excel, CSV, ... to PostgreSQL/MySQL/... via OO-Base ==

* [http://searchopensource.techtarget.com/tip/0,289483,sid39_gci1222186,00.html Bringing data into OpenOffice 2.0's database]: You can for example open an Excel file with OpenOffice, select contents, then open a DB connection in OpenOfficeBase and paste the table into it. The wizard allows to define the type of each column before creating the table. Using the right mouse button on a column name, you can define it as primary key. '''Important:''' If generating a PostgreSQL table, prefix the new table name with "public." (example: public.table1) to avoid that the user name is used as schema name.

=== Step by step DB import procedure (MS-Windows and Linux) ===

Here we show how to get a spreadsheet table into a SQL database.

'''1. Mark and copy to clipboard the relevant table parts in the Excel/CSV/whatever table (OO-Calc):'''

Open the original table with OpenOffice-Calc. For CSV files, they need the .csv extension.

[[Image:oo_calc_small.png|none]] (see also [[media:oo_calc.png|larger screenshot]])

'''2. Open OO-Base and establish a connection to the database (see above for driver installation):'''

Go File -> New -> Database to launch OO-Base.

[[Image:oobase_pg_connect1_small.png|none]] (see also [[media:oobase_pg_connect1.png|larger screenshot]])

[[Image:oobase_pg_connect2_small.png|none]] (see also [[media:oobase_pg_connect2.png|larger screenshot]])

[[Image:oobase_pg_connect3_small.png|none]] (see also [[media:oobase_pg_connect3.png|larger screenshot]])

'''3. In the table wizard, paste (right mouse button) earlier selected OO-Calc spreadsheet into the table section:'''

First select "table" from left menu, then paste into it:

[[Image:oo_base_paste_small.png|none]] (see also [[media:oo_base_paste.png|larger screenshot]])

'''4. A wizard opens, define a table name (when connecting to PostgreSQL, write "public." as prefix for the schema):'''

[[Image:oo_base_newtable1_small.png|none]] (see also [[media:oo_base_newtable1.png|larger screenshot]])

'''5. Select the columns you want to transfer:'''

[[Image:oo_base_newtable2_small.png|none]] (see also [[media:oo_base_newtable2.png|larger screenshot]])

'''6. Define primary key (right mouse button on desired column) and all column types:'''

[[Image:oo_base_newtable3_small.png|none]] (see also [[media:oo_base_newtable3.png|larger screenshot]])

'''7. Save and enjoy. The table is now written into your SQL database.'''

Note that the conversion can take some time.

You can now connect the table to GRASS, R-stats, ... as you like.

=== Step by step DB import procedure (MacOSX) ===

The same procedure that is used for linux.
You can start an existant Neooffice-Pgsql database, or create a new.
To import a file open it :
for example :point.csv

http://img103.imageshack.us/img103/3870/immagine14tl7.png

copy the contens in the klipboard.

if you have an existent database, you can open it with:

http://img126.imageshack.us/img126/8664/immagine12xd0.png

select :

open

and browse to your "database.odb" file
chos it and clik:

open

now you have a window like this:

http://img106.imageshack.us/img106/9451/immagine13gk5.png

go to the table section, if you have a password it ask you for insert it.

http://img106.imageshack.us/img106/2706/immagine15xi8.png

copy the last selection from the clipboard to your database "schema"

http://img115.imageshack.us/img115/6281/immagine16ah6.png

clik on:

next

http://img108.imageshack.us/img108/5508/immagine17xf9.png

select the coloumn that you want import into your database

click on:

next

create

http://img163.imageshack.us/img163/4044/immagine18jg7.png

your table was succesfool loaded ito postgresql

note: if you do not have a "file.odb" to create it look for the Installation of PostgreSQL driver (MacOSX)

Openoffice.org with SQL Databases

2006-12-03T21:44:57Z

⚠️Epifanio: /* Step by step DB import procedure (MacOSX) */

Do you also dislike it to manually convert Excel tables into PostgreSQL? Not having real fun in exporting to CSV, then manually writing the SQL header and importing the stuff in PG? This article here '''explains how to convert a table into an SQL database via OpenOffice'''. Essentially you open the Excel (or whatever) table with OpenOffice-Calc, select and copy the full table or a subset to the clipboard, and simply paste it into OpenOffice-Base with the right mouse button. A wizard pops up which let's you define the type of each column and a primary key. Save & done. Can't be easier!

== Usage of OpenOffice-Base with various drivers ==

* See [http://dba.openoffice.org/drivers/index.html Database drivers] page for overview. There are drivers for PostgreSQL, SQLite and MS-Access mdb files.

=== PostgreSQL (OpenOffice.org 2.x) ===

==== Installation of PostgreSQL driver (MS-Windows and Linux) ====

* http://dba.openoffice.org/drivers/postgresql/index.html

# download postgresql-sdbc-X.Y.Z.zip driver (take the "recommended" file) and save the file to your disk.
# Start OpenOffice, choose 'Tools/Package Manager'. Click on the add button and select the downladed file (DO NOT EXTRACT IT !) in the upcoming File dialog. The driver gets installed now, afterwards, the file is listed in the dialog with state enabled. In case you have installed an older version of the driver, remove it now. Close the dialog.
# Restart openoffice (even the quickstarter on windows must be shut down !!!).
# Done (did you really close openoffice? Please do.)

==== Usage of PostgreSQL driver (MS-Windows and Linux) ====

After starting OpenOffice.org again, use: File -> New -> Database to enter the DB dialog.

* Connect to existing database (select driver): postgresql
* Connection settings: We have to define the server ("host") name and the name of the database, probably also the user name in case you have to connect with a different user name. To find out, '''ask your DB administrator''' or use in a terminal "psql -l " or, if the database is on a remote server, "psql -h host.mydomain.org -l". An entry may look like this:
dbname=pgtest host=my.databaseserver.org
* User name (the login name): yourname
* Finish brings you to a 'Save as' dialog for the connection, saves these settings as file. This file you can use later to re-establish the connection (instead of defining all again).
* Then click on 'Tables' in the next screen to see the existing PG tables in the database. Usually the 'public' scheme contains the user tables.
* The 'Queries' button takes you to the query mode, it contains a graphical query designer.

==== Installation of PostgreSQL driver (MacOSX) ====

Please use the [http://jdbc.postgresql.org/download.html JDBC driver].

There are not mac OSX version of official SDBC driver, you can connect your postgreSQL database using the JDBC driver.

<br>
1)Download the JDBC driver at :
[http://jdbc.postgresql.org/download.html PosgreeSQL]
<br>
(select the driver for your pgsql version)
for example with postgreSQL-8.1 we need to download this driver:

JDBC 8.1-407 JDBC 2

2) Open Neooffice
- preferences:

http://img118.imageshack.us/img118/109/preferenzeap3.png

select :

Java

http://img236.imageshack.us/img236/6004/javaqr9.png

clik on :

classpath

http://img50.imageshack.us/img50/3504/immagine1tb1.png

click on :

add archive ( aggiungi archivio )

select the downloaded driver

click on :

ok

3) Come back to :

neooffice - database

http://img67.imageshack.us/img67/2043/databasevn2.png

In the database configuration window:

http://img54.imageshack.us/img54/3386/selezionadatabnv6.png

at the point : connect to an existant database (collega a un database esistente), select the option :

JDBC

clik on :

next (avanti)

http://img111.imageshack.us/img111/2128/immagine3uw6.png

insert the url to your pgsql database (in this example we have host=localhost, dbname=grassdb):

postgreesql://localhost/grassdb

class driver JDBC :

org.postgresql.Driver

click on :

try class (classe di prova)

if oll is ok :

http://img125.imageshack.us/img125/9330/immagine2kw6.png

clik on :

ok

go to the next step

http://img67.imageshack.us/img67/8527/immagine13dv9.png

insert :

user name

chek the flag 'request password'

clik on :

try connection ( connessione di prova )

http://img300.imageshack.us/img300/9965/immagine6ck5.png

insert :

password

click on :

ok

if oll is ok :

http://img64.imageshack.us/img64/896/immagine7ak2.png

click on :

next (avanti)

http://img103.imageshack.us/img103/8379/immagine8kf6.png

click on

end ( fine )

to save the database

http://img109.imageshack.us/img109/815/immagine9ph2.png

database succesfooll created:

http://img113.imageshack.us/img113/686/immagine10di9.png

[[Category: FAQ]]

=== MySQL (OpenOffice.org 2.x) ===

* Connection via JODBC driver: http://kienlein.com/pages/mysql-jdbc-howto-en.html

=== DBF files (OpenOffice.org 2.x) ===

No installation needed, the driver is included in the standard version of OpenOffice.org.

=== MS-Access mdb files (OpenOffice.org 2.x) ===

* http://dba.openoffice.org/drivers/mdb/index.html

Note that the driver is somewhat behind the mdbtools.sf.net development.

* See also ODBC based connection: http://www.openoffice.org/FAQs/ms-access/ms-access.html

=== SQLite files (OpenOffice.org 2.x) ===

* http://dba.openoffice.org/drivers/sqlite/index.html

== Converting Excel, CSV, ... to PostgreSQL/MySQL/... via OO-Base ==

* [http://searchopensource.techtarget.com/tip/0,289483,sid39_gci1222186,00.html Bringing data into OpenOffice 2.0's database]: You can for example open an Excel file with OpenOffice, select contents, then open a DB connection in OpenOfficeBase and paste the table into it. The wizard allows to define the type of each column before creating the table. Using the right mouse button on a column name, you can define it as primary key. '''Important:''' If generating a PostgreSQL table, prefix the new table name with "public." (example: public.table1) to avoid that the user name is used as schema name.

=== Step by step DB import procedure (MS-Windows and Linux) ===

Here we show how to get a spreadsheet table into a SQL database.

'''1. Mark and copy to clipboard the relevant table parts in the Excel/CSV/whatever table (OO-Calc):'''

Open the original table with OpenOffice-Calc. For CSV files, they need the .csv extension.

[[Image:oo_calc_small.png|none]] (see also [[media:oo_calc.png|larger screenshot]])

'''2. Open OO-Base and establish a connection to the database (see above for driver installation):'''

Go File -> New -> Database to launch OO-Base.

[[Image:oobase_pg_connect1_small.png|none]] (see also [[media:oobase_pg_connect1.png|larger screenshot]])

[[Image:oobase_pg_connect2_small.png|none]] (see also [[media:oobase_pg_connect2.png|larger screenshot]])

[[Image:oobase_pg_connect3_small.png|none]] (see also [[media:oobase_pg_connect3.png|larger screenshot]])

'''3. In the table wizard, paste (right mouse button) earlier selected OO-Calc spreadsheet into the table section:'''

First select "table" from left menu, then paste into it:

[[Image:oo_base_paste_small.png|none]] (see also [[media:oo_base_paste.png|larger screenshot]])

'''4. A wizard opens, define a table name (when connecting to PostgreSQL, write "public." as prefix for the schema):'''

[[Image:oo_base_newtable1_small.png|none]] (see also [[media:oo_base_newtable1.png|larger screenshot]])

'''5. Select the columns you want to transfer:'''

[[Image:oo_base_newtable2_small.png|none]] (see also [[media:oo_base_newtable2.png|larger screenshot]])

'''6. Define primary key (right mouse button on desired column) and all column types:'''

[[Image:oo_base_newtable3_small.png|none]] (see also [[media:oo_base_newtable3.png|larger screenshot]])

'''7. Save and enjoy. The table is now written into your SQL database.'''

Note that the conversion can take some time.

You can now connect the table to GRASS, R-stats, ... as you like.

=== Step by step DB import procedure (MacOSX) ===

The same procedure that is used for linux.
You can start an existant Neooffice-Pgsql database, or create a new (see the precedent instructions)
Open a worksheet file:
point.csv

http://img103.imageshack.us/img103/3870/immagine14tl7.png

copy the contens in the klipboard.

if you have an existent database, you can open it with:

http://img126.imageshack.us/img126/8664/immagine12xd0.png

select :

open

and browse to your "database.odb" file
chos it and clik:

open

now you have a window like this:

http://img106.imageshack.us/img106/9451/immagine13gk5.png

go to the table section, look that if you have cecked the flag "request a password" now you must insert it to open your database.

http://img106.imageshack.us/img106/2706/immagine15xi8.png

now you can copy the last selection from the clipboard to your database "schema"

http://img115.imageshack.us/img115/6281/immagine16ah6.png

clik on:

next

http://img108.imageshack.us/img108/5508/immagine17xf9.png

select the coloumn that you want import into your database

click on:

next

crea

http://img163.imageshack.us/img163/4044/immagine18jg7.png

your table was succesfool loaded ito postgresql

note: if you do not have a "file.odb" to create it look for the section

Openoffice.org with SQL Databases

2006-12-03T20:56:24Z

⚠️Epifanio: /* Step by step DB import procedure (MacOSX) */

Do you also dislike it to manually convert Excel tables into PostgreSQL? Not having real fun in exporting to CSV, then manually writing the SQL header and importing the stuff in PG? This article here '''explains how to convert a table into an SQL database via OpenOffice'''. Essentially you open the Excel (or whatever) table with OpenOffice-Calc, select and copy the full table or a subset to the clipboard, and simply paste it into OpenOffice-Base with the right mouse button. A wizard pops up which let's you define the type of each column and a primary key. Save & done. Can't be easier!

== Usage of OpenOffice-Base with various drivers ==

* See [http://dba.openoffice.org/drivers/index.html Database drivers] page for overview. There are drivers for PostgreSQL, SQLite and MS-Access mdb files.

=== PostgreSQL (OpenOffice.org 2.x) ===

==== Installation of PostgreSQL driver (MS-Windows and Linux) ====

* http://dba.openoffice.org/drivers/postgresql/index.html

# download postgresql-sdbc-X.Y.Z.zip driver (take the "recommended" file) and save the file to your disk.
# Start OpenOffice, choose 'Tools/Package Manager'. Click on the add button and select the downladed file (DO NOT EXTRACT IT !) in the upcoming File dialog. The driver gets installed now, afterwards, the file is listed in the dialog with state enabled. In case you have installed an older version of the driver, remove it now. Close the dialog.
# Restart openoffice (even the quickstarter on windows must be shut down !!!).
# Done (did you really close openoffice? Please do.)

==== Usage of PostgreSQL driver (MS-Windows and Linux) ====

After starting OpenOffice.org again, use: File -> New -> Database to enter the DB dialog.

* Connect to existing database (select driver): postgresql
* Connection settings: We have to define the server ("host") name and the name of the database, probably also the user name in case you have to connect with a different user name. To find out, '''ask your DB administrator''' or use in a terminal "psql -l " or, if the database is on a remote server, "psql -h host.mydomain.org -l". An entry may look like this:
dbname=pgtest host=my.databaseserver.org
* User name (the login name): yourname
* Finish brings you to a 'Save as' dialog for the connection, saves these settings as file. This file you can use later to re-establish the connection (instead of defining all again).
* Then click on 'Tables' in the next screen to see the existing PG tables in the database. Usually the 'public' scheme contains the user tables.
* The 'Queries' button takes you to the query mode, it contains a graphical query designer.

==== Installation of PostgreSQL driver (MacOSX) ====

Please use the [http://jdbc.postgresql.org/download.html JDBC driver].

There are not mac OSX version of official SDBC driver, you can connect your postgreSQL database using the JDBC driver.

<br>
1)Download the JDBC driver at :
[http://jdbc.postgresql.org/download.html PosgreeSQL]
<br>
(select the driver for your pgsql version)
for example with postgreSQL-8.1 we need to download this driver:

JDBC 8.1-407 JDBC 2

2) Open Neooffice
- preferences:

http://img118.imageshack.us/img118/109/preferenzeap3.png

select :

Java

http://img236.imageshack.us/img236/6004/javaqr9.png

clik on :

classpath

http://img50.imageshack.us/img50/3504/immagine1tb1.png

click on :

add archive ( aggiungi archivio )

select the downloaded driver

click on :

ok

3) Come back to :

neooffice - database

http://img67.imageshack.us/img67/2043/databasevn2.png

In the database configuration window:

http://img54.imageshack.us/img54/3386/selezionadatabnv6.png

at the point : connect to an existant database (collega a un database esistente), select the option :

JDBC

clik on :

next (avanti)

http://img111.imageshack.us/img111/2128/immagine3uw6.png

insert the url to your pgsql database (in this example we have host=localhost, dbname=grassdb):

postgreesql://localhost/grassdb

class driver JDBC :

org.postgresql.Driver

click on :

try class (classe di prova)

if oll is ok :

http://img125.imageshack.us/img125/9330/immagine2kw6.png

clik on :

ok

go to the next step

http://img67.imageshack.us/img67/8527/immagine13dv9.png

insert :

user name

chek the flag 'request password'

clik on :

try connection ( connessione di prova )

http://img300.imageshack.us/img300/9965/immagine6ck5.png

insert :

password

click on :

ok

if oll is ok :

http://img64.imageshack.us/img64/896/immagine7ak2.png

click on :

next (avanti)

http://img103.imageshack.us/img103/8379/immagine8kf6.png

click on

end ( fine )

to save the database

http://img109.imageshack.us/img109/815/immagine9ph2.png

database succesfooll created:

http://img113.imageshack.us/img113/686/immagine10di9.png

[[Category: FAQ]]

=== MySQL (OpenOffice.org 2.x) ===

* Connection via JODBC driver: http://kienlein.com/pages/mysql-jdbc-howto-en.html

=== DBF files (OpenOffice.org 2.x) ===

No installation needed, the driver is included in the standard version of OpenOffice.org.

=== MS-Access mdb files (OpenOffice.org 2.x) ===

* http://dba.openoffice.org/drivers/mdb/index.html

Note that the driver is somewhat behind the mdbtools.sf.net development.

* See also ODBC based connection: http://www.openoffice.org/FAQs/ms-access/ms-access.html

=== SQLite files (OpenOffice.org 2.x) ===

* http://dba.openoffice.org/drivers/sqlite/index.html

== Converting Excel, CSV, ... to PostgreSQL/MySQL/... via OO-Base ==

* [http://searchopensource.techtarget.com/tip/0,289483,sid39_gci1222186,00.html Bringing data into OpenOffice 2.0's database]: You can for example open an Excel file with OpenOffice, select contents, then open a DB connection in OpenOfficeBase and paste the table into it. The wizard allows to define the type of each column before creating the table. Using the right mouse button on a column name, you can define it as primary key. '''Important:''' If generating a PostgreSQL table, prefix the new table name with "public." (example: public.table1) to avoid that the user name is used as schema name.

=== Step by step DB import procedure (MS-Windows and Linux) ===

Here we show how to get a spreadsheet table into a SQL database.

'''1. Mark and copy to clipboard the relevant table parts in the Excel/CSV/whatever table (OO-Calc):'''

Open the original table with OpenOffice-Calc. For CSV files, they need the .csv extension.

[[Image:oo_calc_small.png|none]] (see also [[media:oo_calc.png|larger screenshot]])

'''2. Open OO-Base and establish a connection to the database (see above for driver installation):'''

Go File -> New -> Database to launch OO-Base.

[[Image:oobase_pg_connect1_small.png|none]] (see also [[media:oobase_pg_connect1.png|larger screenshot]])

[[Image:oobase_pg_connect2_small.png|none]] (see also [[media:oobase_pg_connect2.png|larger screenshot]])

[[Image:oobase_pg_connect3_small.png|none]] (see also [[media:oobase_pg_connect3.png|larger screenshot]])

'''3. In the table wizard, paste (right mouse button) earlier selected OO-Calc spreadsheet into the table section:'''

First select "table" from left menu, then paste into it:

[[Image:oo_base_paste_small.png|none]] (see also [[media:oo_base_paste.png|larger screenshot]])

'''4. A wizard opens, define a table name (when connecting to PostgreSQL, write "public." as prefix for the schema):'''

[[Image:oo_base_newtable1_small.png|none]] (see also [[media:oo_base_newtable1.png|larger screenshot]])

'''5. Select the columns you want to transfer:'''

[[Image:oo_base_newtable2_small.png|none]] (see also [[media:oo_base_newtable2.png|larger screenshot]])

'''6. Define primary key (right mouse button on desired column) and all column types:'''

[[Image:oo_base_newtable3_small.png|none]] (see also [[media:oo_base_newtable3.png|larger screenshot]])

'''7. Save and enjoy. The table is now written into your SQL database.'''

Note that the conversion can take some time.

You can now connect the table to GRASS, R-stats, ... as you like.

=== Step by step DB import procedure (MacOSX) ===

Openoffice.org with SQL Databases

2006-12-03T20:55:44Z

⚠️Epifanio: /* Installation of PostgreSQL driver (MacOSX) */

Do you also dislike it to manually convert Excel tables into PostgreSQL? Not having real fun in exporting to CSV, then manually writing the SQL header and importing the stuff in PG? This article here '''explains how to convert a table into an SQL database via OpenOffice'''. Essentially you open the Excel (or whatever) table with OpenOffice-Calc, select and copy the full table or a subset to the clipboard, and simply paste it into OpenOffice-Base with the right mouse button. A wizard pops up which let's you define the type of each column and a primary key. Save & done. Can't be easier!

== Usage of OpenOffice-Base with various drivers ==

* See [http://dba.openoffice.org/drivers/index.html Database drivers] page for overview. There are drivers for PostgreSQL, SQLite and MS-Access mdb files.

=== PostgreSQL (OpenOffice.org 2.x) ===

==== Installation of PostgreSQL driver (MS-Windows and Linux) ====

* http://dba.openoffice.org/drivers/postgresql/index.html

# download postgresql-sdbc-X.Y.Z.zip driver (take the "recommended" file) and save the file to your disk.
# Start OpenOffice, choose 'Tools/Package Manager'. Click on the add button and select the downladed file (DO NOT EXTRACT IT !) in the upcoming File dialog. The driver gets installed now, afterwards, the file is listed in the dialog with state enabled. In case you have installed an older version of the driver, remove it now. Close the dialog.
# Restart openoffice (even the quickstarter on windows must be shut down !!!).
# Done (did you really close openoffice? Please do.)

==== Usage of PostgreSQL driver (MS-Windows and Linux) ====

After starting OpenOffice.org again, use: File -> New -> Database to enter the DB dialog.

* Connect to existing database (select driver): postgresql
* Connection settings: We have to define the server ("host") name and the name of the database, probably also the user name in case you have to connect with a different user name. To find out, '''ask your DB administrator''' or use in a terminal "psql -l " or, if the database is on a remote server, "psql -h host.mydomain.org -l". An entry may look like this:
dbname=pgtest host=my.databaseserver.org
* User name (the login name): yourname
* Finish brings you to a 'Save as' dialog for the connection, saves these settings as file. This file you can use later to re-establish the connection (instead of defining all again).
* Then click on 'Tables' in the next screen to see the existing PG tables in the database. Usually the 'public' scheme contains the user tables.
* The 'Queries' button takes you to the query mode, it contains a graphical query designer.

==== Installation of PostgreSQL driver (MacOSX) ====

Please use the [http://jdbc.postgresql.org/download.html JDBC driver].

There are not mac OSX version of official SDBC driver, you can connect your postgreSQL database using the JDBC driver.

<br>
1)Download the JDBC driver at :
[http://jdbc.postgresql.org/download.html PosgreeSQL]
<br>
(select the driver for your pgsql version)
for example with postgreSQL-8.1 we need to download this driver:

JDBC 8.1-407 JDBC 2

2) Open Neooffice
- preferences:

http://img118.imageshack.us/img118/109/preferenzeap3.png

select :

Java

http://img236.imageshack.us/img236/6004/javaqr9.png

clik on :

classpath

http://img50.imageshack.us/img50/3504/immagine1tb1.png

click on :

add archive ( aggiungi archivio )

select the downloaded driver

click on :

ok

3) Come back to :

neooffice - database

http://img67.imageshack.us/img67/2043/databasevn2.png

In the database configuration window:

http://img54.imageshack.us/img54/3386/selezionadatabnv6.png

at the point : connect to an existant database (collega a un database esistente), select the option :

JDBC

clik on :

next (avanti)

http://img111.imageshack.us/img111/2128/immagine3uw6.png

insert the url to your pgsql database (in this example we have host=localhost, dbname=grassdb):

postgreesql://localhost/grassdb

class driver JDBC :

org.postgresql.Driver

click on :

try class (classe di prova)

if oll is ok :

http://img125.imageshack.us/img125/9330/immagine2kw6.png

clik on :

ok

go to the next step

http://img67.imageshack.us/img67/8527/immagine13dv9.png

insert :

user name

chek the flag 'request password'

clik on :

try connection ( connessione di prova )

http://img300.imageshack.us/img300/9965/immagine6ck5.png

insert :

password

click on :

ok

if oll is ok :

http://img64.imageshack.us/img64/896/immagine7ak2.png

click on :

next (avanti)

http://img103.imageshack.us/img103/8379/immagine8kf6.png

click on

end ( fine )

to save the database

http://img109.imageshack.us/img109/815/immagine9ph2.png

database succesfooll created:

http://img113.imageshack.us/img113/686/immagine10di9.png

[[Category: FAQ]]

=== MySQL (OpenOffice.org 2.x) ===

* Connection via JODBC driver: http://kienlein.com/pages/mysql-jdbc-howto-en.html

=== DBF files (OpenOffice.org 2.x) ===

No installation needed, the driver is included in the standard version of OpenOffice.org.

=== MS-Access mdb files (OpenOffice.org 2.x) ===

* http://dba.openoffice.org/drivers/mdb/index.html

Note that the driver is somewhat behind the mdbtools.sf.net development.

* See also ODBC based connection: http://www.openoffice.org/FAQs/ms-access/ms-access.html

=== SQLite files (OpenOffice.org 2.x) ===

* http://dba.openoffice.org/drivers/sqlite/index.html

== Converting Excel, CSV, ... to PostgreSQL/MySQL/... via OO-Base ==

* [http://searchopensource.techtarget.com/tip/0,289483,sid39_gci1222186,00.html Bringing data into OpenOffice 2.0's database]: You can for example open an Excel file with OpenOffice, select contents, then open a DB connection in OpenOfficeBase and paste the table into it. The wizard allows to define the type of each column before creating the table. Using the right mouse button on a column name, you can define it as primary key. '''Important:''' If generating a PostgreSQL table, prefix the new table name with "public." (example: public.table1) to avoid that the user name is used as schema name.

=== Step by step DB import procedure (MS-Windows and Linux) ===

Here we show how to get a spreadsheet table into a SQL database.

'''1. Mark and copy to clipboard the relevant table parts in the Excel/CSV/whatever table (OO-Calc):'''

Open the original table with OpenOffice-Calc. For CSV files, they need the .csv extension.

[[Image:oo_calc_small.png|none]] (see also [[media:oo_calc.png|larger screenshot]])

'''2. Open OO-Base and establish a connection to the database (see above for driver installation):'''

Go File -> New -> Database to launch OO-Base.

[[Image:oobase_pg_connect1_small.png|none]] (see also [[media:oobase_pg_connect1.png|larger screenshot]])

[[Image:oobase_pg_connect2_small.png|none]] (see also [[media:oobase_pg_connect2.png|larger screenshot]])

[[Image:oobase_pg_connect3_small.png|none]] (see also [[media:oobase_pg_connect3.png|larger screenshot]])

'''3. In the table wizard, paste (right mouse button) earlier selected OO-Calc spreadsheet into the table section:'''

First select "table" from left menu, then paste into it:

[[Image:oo_base_paste_small.png|none]] (see also [[media:oo_base_paste.png|larger screenshot]])

'''4. A wizard opens, define a table name (when connecting to PostgreSQL, write "public." as prefix for the schema):'''

[[Image:oo_base_newtable1_small.png|none]] (see also [[media:oo_base_newtable1.png|larger screenshot]])

'''5. Select the columns you want to transfer:'''

[[Image:oo_base_newtable2_small.png|none]] (see also [[media:oo_base_newtable2.png|larger screenshot]])

'''6. Define primary key (right mouse button on desired column) and all column types:'''

[[Image:oo_base_newtable3_small.png|none]] (see also [[media:oo_base_newtable3.png|larger screenshot]])

'''7. Save and enjoy. The table is now written into your SQL database.'''

Note that the conversion can take some time.

You can now connect the table to GRASS, R-stats, ... as you like.

=== Step by step DB import procedure (MacOSX) ===

There are not mac OSX version of official SDBC driver, you can connct your postgreSQL database using the JDBC driver.

<br>
1)Download the JDBC driver at :
[http://jdbc.postgresql.org/download.html PosgreeSQL]
<br>
(select the driver for your pgsql version)
for example with postgreSQL-8.1 we need to download this driver:

JDBC 8.1-407 JDBC 2

2) Open Neooffice
- preferences:

http://img118.imageshack.us/img118/109/preferenzeap3.png

select :

Java

http://img236.imageshack.us/img236/6004/javaqr9.png

clik on :

classpath

http://img50.imageshack.us/img50/3504/immagine1tb1.png

click on :

add archive ( aggiungi archivio )

select the downloaded driver

click on :

ok

3) Come back to :

neooffice - database

http://img67.imageshack.us/img67/2043/databasevn2.png

In the database configuration window:

http://img54.imageshack.us/img54/3386/selezionadatabnv6.png

at the point : connect to an existant database (collega a un database esistente), select the option :

JDBC

clik on :

next (avanti)

http://img111.imageshack.us/img111/2128/immagine3uw6.png

insert the url to your pgsql database (in this example we have host=localhost, dbname=grassdb):

postgreesql://localhost/grassdb

class driver JDBC :

org.postgresql.Driver

click on :

try class (classe di prova)

if oll is ok :

http://img125.imageshack.us/img125/9330/immagine2kw6.png

clik on :

ok

go to the next step

http://img67.imageshack.us/img67/8527/immagine13dv9.png

insert :

user name

chek the flag 'request password'

clik on :

try connection ( connessione di prova )

http://img300.imageshack.us/img300/9965/immagine6ck5.png

insert :

password

click on :

ok

if oll is ok :

http://img64.imageshack.us/img64/896/immagine7ak2.png

click on :

next (avanti)

http://img103.imageshack.us/img103/8379/immagine8kf6.png

click on

end ( fine )

to save the database

http://img109.imageshack.us/img109/815/immagine9ph2.png

database succesfooll created:

http://img113.imageshack.us/img113/686/immagine10di9.png

[[Category: FAQ]]

Openoffice.org with SQL Databases

2006-12-03T20:53:03Z

⚠️Epifanio: /* Step by step DB import procedure (MacOSX) */

Do you also dislike it to manually convert Excel tables into PostgreSQL? Not having real fun in exporting to CSV, then manually writing the SQL header and importing the stuff in PG? This article here '''explains how to convert a table into an SQL database via OpenOffice'''. Essentially you open the Excel (or whatever) table with OpenOffice-Calc, select and copy the full table or a subset to the clipboard, and simply paste it into OpenOffice-Base with the right mouse button. A wizard pops up which let's you define the type of each column and a primary key. Save & done. Can't be easier!

== Usage of OpenOffice-Base with various drivers ==

* See [http://dba.openoffice.org/drivers/index.html Database drivers] page for overview. There are drivers for PostgreSQL, SQLite and MS-Access mdb files.

=== PostgreSQL (OpenOffice.org 2.x) ===

==== Installation of PostgreSQL driver (MS-Windows and Linux) ====

* http://dba.openoffice.org/drivers/postgresql/index.html

# download postgresql-sdbc-X.Y.Z.zip driver (take the "recommended" file) and save the file to your disk.
# Start OpenOffice, choose 'Tools/Package Manager'. Click on the add button and select the downladed file (DO NOT EXTRACT IT !) in the upcoming File dialog. The driver gets installed now, afterwards, the file is listed in the dialog with state enabled. In case you have installed an older version of the driver, remove it now. Close the dialog.
# Restart openoffice (even the quickstarter on windows must be shut down !!!).
# Done (did you really close openoffice? Please do.)

==== Usage of PostgreSQL driver (MS-Windows and Linux) ====

After starting OpenOffice.org again, use: File -> New -> Database to enter the DB dialog.

* Connect to existing database (select driver): postgresql
* Connection settings: We have to define the server ("host") name and the name of the database, probably also the user name in case you have to connect with a different user name. To find out, '''ask your DB administrator''' or use in a terminal "psql -l " or, if the database is on a remote server, "psql -h host.mydomain.org -l". An entry may look like this:
dbname=pgtest host=my.databaseserver.org
* User name (the login name): yourname
* Finish brings you to a 'Save as' dialog for the connection, saves these settings as file. This file you can use later to re-establish the connection (instead of defining all again).
* Then click on 'Tables' in the next screen to see the existing PG tables in the database. Usually the 'public' scheme contains the user tables.
* The 'Queries' button takes you to the query mode, it contains a graphical query designer.

==== Installation of PostgreSQL driver (MacOSX) ====

Please use the [http://jdbc.postgresql.org/download.html JDBC driver].

=== MySQL (OpenOffice.org 2.x) ===

* Connection via JODBC driver: http://kienlein.com/pages/mysql-jdbc-howto-en.html

=== DBF files (OpenOffice.org 2.x) ===

No installation needed, the driver is included in the standard version of OpenOffice.org.

=== MS-Access mdb files (OpenOffice.org 2.x) ===

* http://dba.openoffice.org/drivers/mdb/index.html

Note that the driver is somewhat behind the mdbtools.sf.net development.

* See also ODBC based connection: http://www.openoffice.org/FAQs/ms-access/ms-access.html

=== SQLite files (OpenOffice.org 2.x) ===

* http://dba.openoffice.org/drivers/sqlite/index.html

== Converting Excel, CSV, ... to PostgreSQL/MySQL/... via OO-Base ==

* [http://searchopensource.techtarget.com/tip/0,289483,sid39_gci1222186,00.html Bringing data into OpenOffice 2.0's database]: You can for example open an Excel file with OpenOffice, select contents, then open a DB connection in OpenOfficeBase and paste the table into it. The wizard allows to define the type of each column before creating the table. Using the right mouse button on a column name, you can define it as primary key. '''Important:''' If generating a PostgreSQL table, prefix the new table name with "public." (example: public.table1) to avoid that the user name is used as schema name.

=== Step by step DB import procedure (MS-Windows and Linux) ===

Here we show how to get a spreadsheet table into a SQL database.

'''1. Mark and copy to clipboard the relevant table parts in the Excel/CSV/whatever table (OO-Calc):'''

Open the original table with OpenOffice-Calc. For CSV files, they need the .csv extension.

[[Image:oo_calc_small.png|none]] (see also [[media:oo_calc.png|larger screenshot]])

'''2. Open OO-Base and establish a connection to the database (see above for driver installation):'''

Go File -> New -> Database to launch OO-Base.

[[Image:oobase_pg_connect1_small.png|none]] (see also [[media:oobase_pg_connect1.png|larger screenshot]])

[[Image:oobase_pg_connect2_small.png|none]] (see also [[media:oobase_pg_connect2.png|larger screenshot]])

[[Image:oobase_pg_connect3_small.png|none]] (see also [[media:oobase_pg_connect3.png|larger screenshot]])

'''3. In the table wizard, paste (right mouse button) earlier selected OO-Calc spreadsheet into the table section:'''

First select "table" from left menu, then paste into it:

[[Image:oo_base_paste_small.png|none]] (see also [[media:oo_base_paste.png|larger screenshot]])

'''4. A wizard opens, define a table name (when connecting to PostgreSQL, write "public." as prefix for the schema):'''

[[Image:oo_base_newtable1_small.png|none]] (see also [[media:oo_base_newtable1.png|larger screenshot]])

'''5. Select the columns you want to transfer:'''

[[Image:oo_base_newtable2_small.png|none]] (see also [[media:oo_base_newtable2.png|larger screenshot]])

'''6. Define primary key (right mouse button on desired column) and all column types:'''

[[Image:oo_base_newtable3_small.png|none]] (see also [[media:oo_base_newtable3.png|larger screenshot]])

'''7. Save and enjoy. The table is now written into your SQL database.'''

Note that the conversion can take some time.

You can now connect the table to GRASS, R-stats, ... as you like.

=== Step by step DB import procedure (MacOSX) ===

There are not mac OSX version of official SDBC driver, you can connct your postgreSQL database using the JDBC driver.

<br>
1)Download the JDBC driver at :
[http://jdbc.postgresql.org/download.html PosgreeSQL]
<br>
(select the driver for your pgsql version)
for example with postgreSQL-8.1 we need to download this driver:

JDBC 8.1-407 JDBC 2

2) Open Neooffice
- preferences:

http://img118.imageshack.us/img118/109/preferenzeap3.png

select :

Java

http://img236.imageshack.us/img236/6004/javaqr9.png

clik on :

classpath

http://img50.imageshack.us/img50/3504/immagine1tb1.png

click on :

add archive ( aggiungi archivio )

select the downloaded driver

click on :

ok

3) Come back to :

neooffice - database

http://img67.imageshack.us/img67/2043/databasevn2.png

In the database configuration window:

http://img54.imageshack.us/img54/3386/selezionadatabnv6.png

at the point : connect to an existant database (collega a un database esistente), select the option :

JDBC

clik on :

next (avanti)

http://img111.imageshack.us/img111/2128/immagine3uw6.png

insert the url to your pgsql database (in this example we have host=localhost, dbname=grassdb):

postgreesql://localhost/grassdb

class driver JDBC :

org.postgresql.Driver

click on :

try class (classe di prova)

if oll is ok :

http://img125.imageshack.us/img125/9330/immagine2kw6.png

clik on :

ok

go to the next step

http://img67.imageshack.us/img67/8527/immagine13dv9.png

insert :

user name

chek the flag 'request password'

clik on :

try connection ( connessione di prova )

http://img300.imageshack.us/img300/9965/immagine6ck5.png

insert :

password

click on :

ok

if oll is ok :

http://img64.imageshack.us/img64/896/immagine7ak2.png

click on :

next (avanti)

http://img103.imageshack.us/img103/8379/immagine8kf6.png

click on

end ( fine )

to save the database

http://img109.imageshack.us/img109/815/immagine9ph2.png

database succesfooll created:

http://img113.imageshack.us/img113/686/immagine10di9.png

[[Category: FAQ]]

Openoffice.org with SQL Databases

2006-12-03T20:50:53Z

⚠️Epifanio: /* Step by step DB import procedure (MacOSX) */

Do you also dislike it to manually convert Excel tables into PostgreSQL? Not having real fun in exporting to CSV, then manually writing the SQL header and importing the stuff in PG? This article here '''explains how to convert a table into an SQL database via OpenOffice'''. Essentially you open the Excel (or whatever) table with OpenOffice-Calc, select and copy the full table or a subset to the clipboard, and simply paste it into OpenOffice-Base with the right mouse button. A wizard pops up which let's you define the type of each column and a primary key. Save & done. Can't be easier!

== Usage of OpenOffice-Base with various drivers ==

* See [http://dba.openoffice.org/drivers/index.html Database drivers] page for overview. There are drivers for PostgreSQL, SQLite and MS-Access mdb files.

=== PostgreSQL (OpenOffice.org 2.x) ===

==== Installation of PostgreSQL driver (MS-Windows and Linux) ====

* http://dba.openoffice.org/drivers/postgresql/index.html

# download postgresql-sdbc-X.Y.Z.zip driver (take the "recommended" file) and save the file to your disk.
# Start OpenOffice, choose 'Tools/Package Manager'. Click on the add button and select the downladed file (DO NOT EXTRACT IT !) in the upcoming File dialog. The driver gets installed now, afterwards, the file is listed in the dialog with state enabled. In case you have installed an older version of the driver, remove it now. Close the dialog.
# Restart openoffice (even the quickstarter on windows must be shut down !!!).
# Done (did you really close openoffice? Please do.)

==== Usage of PostgreSQL driver (MS-Windows and Linux) ====

After starting OpenOffice.org again, use: File -> New -> Database to enter the DB dialog.

* Connect to existing database (select driver): postgresql
* Connection settings: We have to define the server ("host") name and the name of the database, probably also the user name in case you have to connect with a different user name. To find out, '''ask your DB administrator''' or use in a terminal "psql -l " or, if the database is on a remote server, "psql -h host.mydomain.org -l". An entry may look like this:
dbname=pgtest host=my.databaseserver.org
* User name (the login name): yourname
* Finish brings you to a 'Save as' dialog for the connection, saves these settings as file. This file you can use later to re-establish the connection (instead of defining all again).
* Then click on 'Tables' in the next screen to see the existing PG tables in the database. Usually the 'public' scheme contains the user tables.
* The 'Queries' button takes you to the query mode, it contains a graphical query designer.

==== Installation of PostgreSQL driver (MacOSX) ====

Please use the [http://jdbc.postgresql.org/download.html JDBC driver].

=== MySQL (OpenOffice.org 2.x) ===

* Connection via JODBC driver: http://kienlein.com/pages/mysql-jdbc-howto-en.html

=== DBF files (OpenOffice.org 2.x) ===

No installation needed, the driver is included in the standard version of OpenOffice.org.

=== MS-Access mdb files (OpenOffice.org 2.x) ===

* http://dba.openoffice.org/drivers/mdb/index.html

Note that the driver is somewhat behind the mdbtools.sf.net development.

* See also ODBC based connection: http://www.openoffice.org/FAQs/ms-access/ms-access.html

=== SQLite files (OpenOffice.org 2.x) ===

* http://dba.openoffice.org/drivers/sqlite/index.html

== Converting Excel, CSV, ... to PostgreSQL/MySQL/... via OO-Base ==

* [http://searchopensource.techtarget.com/tip/0,289483,sid39_gci1222186,00.html Bringing data into OpenOffice 2.0's database]: You can for example open an Excel file with OpenOffice, select contents, then open a DB connection in OpenOfficeBase and paste the table into it. The wizard allows to define the type of each column before creating the table. Using the right mouse button on a column name, you can define it as primary key. '''Important:''' If generating a PostgreSQL table, prefix the new table name with "public." (example: public.table1) to avoid that the user name is used as schema name.

=== Step by step DB import procedure (MS-Windows and Linux) ===

Here we show how to get a spreadsheet table into a SQL database.

'''1. Mark and copy to clipboard the relevant table parts in the Excel/CSV/whatever table (OO-Calc):'''

Open the original table with OpenOffice-Calc. For CSV files, they need the .csv extension.

[[Image:oo_calc_small.png|none]] (see also [[media:oo_calc.png|larger screenshot]])

'''2. Open OO-Base and establish a connection to the database (see above for driver installation):'''

Go File -> New -> Database to launch OO-Base.

[[Image:oobase_pg_connect1_small.png|none]] (see also [[media:oobase_pg_connect1.png|larger screenshot]])

[[Image:oobase_pg_connect2_small.png|none]] (see also [[media:oobase_pg_connect2.png|larger screenshot]])

[[Image:oobase_pg_connect3_small.png|none]] (see also [[media:oobase_pg_connect3.png|larger screenshot]])

'''3. In the table wizard, paste (right mouse button) earlier selected OO-Calc spreadsheet into the table section:'''

First select "table" from left menu, then paste into it:

[[Image:oo_base_paste_small.png|none]] (see also [[media:oo_base_paste.png|larger screenshot]])

'''4. A wizard opens, define a table name (when connecting to PostgreSQL, write "public." as prefix for the schema):'''

[[Image:oo_base_newtable1_small.png|none]] (see also [[media:oo_base_newtable1.png|larger screenshot]])

'''5. Select the columns you want to transfer:'''

[[Image:oo_base_newtable2_small.png|none]] (see also [[media:oo_base_newtable2.png|larger screenshot]])

'''6. Define primary key (right mouse button on desired column) and all column types:'''

[[Image:oo_base_newtable3_small.png|none]] (see also [[media:oo_base_newtable3.png|larger screenshot]])

'''7. Save and enjoy. The table is now written into your SQL database.'''

Note that the conversion can take some time.

You can now connect the table to GRASS, R-stats, ... as you like.

=== Step by step DB import procedure (MacOSX) ===

There are not mac OSX version of official SDBC driver, you can connct your postgreSQL database using the JDBC driver.

<br>
1)Download the JDBC driver at :
[http://jdbc.postgresql.org/download.html PosgreeSQL]
<br>
(select the driver for your pgsql version)
for example with postgreSQL-8.1 we need to download this driver:

JDBC 8.1-407 JDBC 2

2) Open Neooffice
- preferences:

http://img118.imageshack.us/img118/109/preferenzeap3.png

select :

Java

http://img236.imageshack.us/img236/6004/javaqr9.png

clik on :

classpath

http://img50.imageshack.us/img50/3504/immagine1tb1.png

click on :

add archive ( aggiungi archivio )

select the downloaded driver

click on :

ok

3) Come back to :

neooffice - database

http://img67.imageshack.us/img67/2043/databasevn2.png

In the database configuration window:

http://img54.imageshack.us/img54/3386/selezionadatabnv6.png

at the point : connect to an existant database (collega a un database esistente), select the option :

JDBC

clik on :

next (avanti)

http://img111.imageshack.us/img111/2128/immagine3uw6.png

insert the url to your pgsql database (in this example we have host=localhost, dbname=grassdb):

postgreesql://localhost/grassdb

class driver JDBC :

org.postgresql.Driver

click on :

classe di prova

if oll is ok :

http://img125.imageshack.us/img125/9330/immagine2kw6.png

clik on :

ok

go to the next step

http://img67.imageshack.us/img67/8527/immagine13dv9.png

insert :

user name

chek the flag 'request password'

clik on :

try connection ( connessione di prova )

http://img300.imageshack.us/img300/9965/immagine6ck5.png

insert :

password

click on :

ok

if oll is ok :

http://img64.imageshack.us/img64/896/immagine7ak2.png

click on :

next (avanti)

http://img103.imageshack.us/img103/8379/immagine8kf6.png

click on

end ( fine )

to save the database

http://img109.imageshack.us/img109/815/immagine9ph2.png

database succesfooll created:

http://img113.imageshack.us/img113/686/immagine10di9.png

[[Category: FAQ]]

Openoffice.org with SQL Databases

2006-12-03T20:32:49Z

⚠️Epifanio: /* Step by step DB import procedure (MacOSX) */

Do you also dislike it to manually convert Excel tables into PostgreSQL? Not having real fun in exporting to CSV, then manually writing the SQL header and importing the stuff in PG? This article here '''explains how to convert a table into an SQL database via OpenOffice'''. Essentially you open the Excel (or whatever) table with OpenOffice-Calc, select and copy the full table or a subset to the clipboard, and simply paste it into OpenOffice-Base with the right mouse button. A wizard pops up which let's you define the type of each column and a primary key. Save & done. Can't be easier!

== Usage of OpenOffice-Base with various drivers ==

* See [http://dba.openoffice.org/drivers/index.html Database drivers] page for overview. There are drivers for PostgreSQL, SQLite and MS-Access mdb files.

=== PostgreSQL (OpenOffice.org 2.x) ===

==== Installation of PostgreSQL driver (MS-Windows and Linux) ====

* http://dba.openoffice.org/drivers/postgresql/index.html

# download postgresql-sdbc-X.Y.Z.zip driver (take the "recommended" file) and save the file to your disk.
# Start OpenOffice, choose 'Tools/Package Manager'. Click on the add button and select the downladed file (DO NOT EXTRACT IT !) in the upcoming File dialog. The driver gets installed now, afterwards, the file is listed in the dialog with state enabled. In case you have installed an older version of the driver, remove it now. Close the dialog.
# Restart openoffice (even the quickstarter on windows must be shut down !!!).
# Done (did you really close openoffice? Please do.)

==== Usage of PostgreSQL driver (MS-Windows and Linux) ====

After starting OpenOffice.org again, use: File -> New -> Database to enter the DB dialog.

* Connect to existing database (select driver): postgresql
* Connection settings: We have to define the server ("host") name and the name of the database, probably also the user name in case you have to connect with a different user name. To find out, '''ask your DB administrator''' or use in a terminal "psql -l " or, if the database is on a remote server, "psql -h host.mydomain.org -l". An entry may look like this:
dbname=pgtest host=my.databaseserver.org
* User name (the login name): yourname
* Finish brings you to a 'Save as' dialog for the connection, saves these settings as file. This file you can use later to re-establish the connection (instead of defining all again).
* Then click on 'Tables' in the next screen to see the existing PG tables in the database. Usually the 'public' scheme contains the user tables.
* The 'Queries' button takes you to the query mode, it contains a graphical query designer.

==== Installation of PostgreSQL driver (MacOSX) ====

Please use the [http://jdbc.postgresql.org/download.html JDBC driver].

=== MySQL (OpenOffice.org 2.x) ===

* Connection via JODBC driver: http://kienlein.com/pages/mysql-jdbc-howto-en.html

=== DBF files (OpenOffice.org 2.x) ===

No installation needed, the driver is included in the standard version of OpenOffice.org.

=== MS-Access mdb files (OpenOffice.org 2.x) ===

* http://dba.openoffice.org/drivers/mdb/index.html

Note that the driver is somewhat behind the mdbtools.sf.net development.

* See also ODBC based connection: http://www.openoffice.org/FAQs/ms-access/ms-access.html

=== SQLite files (OpenOffice.org 2.x) ===

* http://dba.openoffice.org/drivers/sqlite/index.html

== Converting Excel, CSV, ... to PostgreSQL/MySQL/... via OO-Base ==

* [http://searchopensource.techtarget.com/tip/0,289483,sid39_gci1222186,00.html Bringing data into OpenOffice 2.0's database]: You can for example open an Excel file with OpenOffice, select contents, then open a DB connection in OpenOfficeBase and paste the table into it. The wizard allows to define the type of each column before creating the table. Using the right mouse button on a column name, you can define it as primary key. '''Important:''' If generating a PostgreSQL table, prefix the new table name with "public." (example: public.table1) to avoid that the user name is used as schema name.

=== Step by step DB import procedure (MS-Windows and Linux) ===

Here we show how to get a spreadsheet table into a SQL database.

'''1. Mark and copy to clipboard the relevant table parts in the Excel/CSV/whatever table (OO-Calc):'''

Open the original table with OpenOffice-Calc. For CSV files, they need the .csv extension.

[[Image:oo_calc_small.png|none]] (see also [[media:oo_calc.png|larger screenshot]])

'''2. Open OO-Base and establish a connection to the database (see above for driver installation):'''

Go File -> New -> Database to launch OO-Base.

[[Image:oobase_pg_connect1_small.png|none]] (see also [[media:oobase_pg_connect1.png|larger screenshot]])

[[Image:oobase_pg_connect2_small.png|none]] (see also [[media:oobase_pg_connect2.png|larger screenshot]])

[[Image:oobase_pg_connect3_small.png|none]] (see also [[media:oobase_pg_connect3.png|larger screenshot]])

'''3. In the table wizard, paste (right mouse button) earlier selected OO-Calc spreadsheet into the table section:'''

First select "table" from left menu, then paste into it:

[[Image:oo_base_paste_small.png|none]] (see also [[media:oo_base_paste.png|larger screenshot]])

'''4. A wizard opens, define a table name (when connecting to PostgreSQL, write "public." as prefix for the schema):'''

[[Image:oo_base_newtable1_small.png|none]] (see also [[media:oo_base_newtable1.png|larger screenshot]])

'''5. Select the columns you want to transfer:'''

[[Image:oo_base_newtable2_small.png|none]] (see also [[media:oo_base_newtable2.png|larger screenshot]])

'''6. Define primary key (right mouse button on desired column) and all column types:'''

[[Image:oo_base_newtable3_small.png|none]] (see also [[media:oo_base_newtable3.png|larger screenshot]])

'''7. Save and enjoy. The table is now written into your SQL database.'''

Note that the conversion can take some time.

You can now connect the table to GRASS, R-stats, ... as you like.

=== Step by step DB import procedure (MacOSX) ===

There are not mac OSX version of official
Nota la mancanza di driver SDBC su piattaforma OSX, un alternativa per connettere Neoofice con PostgreSQL è possibile utilizzando driver JDBC.
<br>
1) Scaricare i driver direttamente del sito posgresql (scegliere il driver corrispondente alla versione di posgree che si utilizza)
[http://jdbc.postgresql.org/download.html PosgreeSQL]
<br>
ad esempio per postgreSQL-8.1 download del driver:

JDBC 8.1-407 JDBC 2

2) Aprire Neooffice
- preferenze:

http://img118.imageshack.us/img118/109/preferenzeap3.png

scegliere :

Java

http://img236.imageshack.us/img236/6004/javaqr9.png

clik su :

classpath

http://img50.imageshack.us/img50/3504/immagine1tb1.png

click su :

aggiungi archivio

selezionare il driver scaricato

click su :

ok

3) Tornare a : neooffice - database

http://img67.imageshack.us/img67/2043/databasevn2.png

nella finestra di configurazione del nuovo database:

http://img54.imageshack.us/img54/3386/selezionadatabnv6.png

nella sezione : collega a un database esistente, selezionare :

JDBC

clik su :

avanti

http://img111.imageshack.us/img111/2128/immagine3uw6.png

inserire l'url per il collegamento al database in postgresql (nel caso in esempio host=localhost, dbname=grassdb):

postgreesql://localhost/grassdb

classe driver JDBC :

org.postgresql.Driver

click su :

classe di prova

se tutto è correto :

http://img125.imageshack.us/img125/9330/immagine2kw6.png

clik su :

ok

avanti e proseguire con la registrazione del database

http://img67.imageshack.us/img67/8527/immagine13dv9.png

inserire :

nome utente

richiesta password

clik su :

connessione di prova

http://img300.imageshack.us/img300/9965/immagine6ck5.png

inserire :

password

click su :

ok

se tutto è corretto :

http://img64.imageshack.us/img64/896/immagine7ak2.png

click su :

avanti

http://img103.imageshack.us/img103/8379/immagine8kf6.png

click su

fine

per salvare il database

http://img109.imageshack.us/img109/815/immagine9ph2.png

il database è stato configurato con successo:

http://img113.imageshack.us/img113/686/immagine10di9.png

[[Category: FAQ]]

Openoffice.org with SQL Databases

2006-12-03T20:31:21Z

⚠️Epifanio: /* Step by step DB import procedure (MacOSX) */

Do you also dislike it to manually convert Excel tables into PostgreSQL? Not having real fun in exporting to CSV, then manually writing the SQL header and importing the stuff in PG? This article here '''explains how to convert a table into an SQL database via OpenOffice'''. Essentially you open the Excel (or whatever) table with OpenOffice-Calc, select and copy the full table or a subset to the clipboard, and simply paste it into OpenOffice-Base with the right mouse button. A wizard pops up which let's you define the type of each column and a primary key. Save & done. Can't be easier!

== Usage of OpenOffice-Base with various drivers ==

* See [http://dba.openoffice.org/drivers/index.html Database drivers] page for overview. There are drivers for PostgreSQL, SQLite and MS-Access mdb files.

=== PostgreSQL (OpenOffice.org 2.x) ===

==== Installation of PostgreSQL driver (MS-Windows and Linux) ====

* http://dba.openoffice.org/drivers/postgresql/index.html

# download postgresql-sdbc-X.Y.Z.zip driver (take the "recommended" file) and save the file to your disk.
# Start OpenOffice, choose 'Tools/Package Manager'. Click on the add button and select the downladed file (DO NOT EXTRACT IT !) in the upcoming File dialog. The driver gets installed now, afterwards, the file is listed in the dialog with state enabled. In case you have installed an older version of the driver, remove it now. Close the dialog.
# Restart openoffice (even the quickstarter on windows must be shut down !!!).
# Done (did you really close openoffice? Please do.)

==== Usage of PostgreSQL driver (MS-Windows and Linux) ====

After starting OpenOffice.org again, use: File -> New -> Database to enter the DB dialog.

* Connect to existing database (select driver): postgresql
* Connection settings: We have to define the server ("host") name and the name of the database, probably also the user name in case you have to connect with a different user name. To find out, '''ask your DB administrator''' or use in a terminal "psql -l " or, if the database is on a remote server, "psql -h host.mydomain.org -l". An entry may look like this:
dbname=pgtest host=my.databaseserver.org
* User name (the login name): yourname
* Finish brings you to a 'Save as' dialog for the connection, saves these settings as file. This file you can use later to re-establish the connection (instead of defining all again).
* Then click on 'Tables' in the next screen to see the existing PG tables in the database. Usually the 'public' scheme contains the user tables.
* The 'Queries' button takes you to the query mode, it contains a graphical query designer.

==== Installation of PostgreSQL driver (MacOSX) ====

Please use the [http://jdbc.postgresql.org/download.html JDBC driver].

=== MySQL (OpenOffice.org 2.x) ===

* Connection via JODBC driver: http://kienlein.com/pages/mysql-jdbc-howto-en.html

=== DBF files (OpenOffice.org 2.x) ===

No installation needed, the driver is included in the standard version of OpenOffice.org.

=== MS-Access mdb files (OpenOffice.org 2.x) ===

* http://dba.openoffice.org/drivers/mdb/index.html

Note that the driver is somewhat behind the mdbtools.sf.net development.

* See also ODBC based connection: http://www.openoffice.org/FAQs/ms-access/ms-access.html

=== SQLite files (OpenOffice.org 2.x) ===

* http://dba.openoffice.org/drivers/sqlite/index.html

== Converting Excel, CSV, ... to PostgreSQL/MySQL/... via OO-Base ==

* [http://searchopensource.techtarget.com/tip/0,289483,sid39_gci1222186,00.html Bringing data into OpenOffice 2.0's database]: You can for example open an Excel file with OpenOffice, select contents, then open a DB connection in OpenOfficeBase and paste the table into it. The wizard allows to define the type of each column before creating the table. Using the right mouse button on a column name, you can define it as primary key. '''Important:''' If generating a PostgreSQL table, prefix the new table name with "public." (example: public.table1) to avoid that the user name is used as schema name.

=== Step by step DB import procedure (MS-Windows and Linux) ===

Here we show how to get a spreadsheet table into a SQL database.

'''1. Mark and copy to clipboard the relevant table parts in the Excel/CSV/whatever table (OO-Calc):'''

Open the original table with OpenOffice-Calc. For CSV files, they need the .csv extension.

[[Image:oo_calc_small.png|none]] (see also [[media:oo_calc.png|larger screenshot]])

'''2. Open OO-Base and establish a connection to the database (see above for driver installation):'''

Go File -> New -> Database to launch OO-Base.

[[Image:oobase_pg_connect1_small.png|none]] (see also [[media:oobase_pg_connect1.png|larger screenshot]])

[[Image:oobase_pg_connect2_small.png|none]] (see also [[media:oobase_pg_connect2.png|larger screenshot]])

[[Image:oobase_pg_connect3_small.png|none]] (see also [[media:oobase_pg_connect3.png|larger screenshot]])

'''3. In the table wizard, paste (right mouse button) earlier selected OO-Calc spreadsheet into the table section:'''

First select "table" from left menu, then paste into it:

[[Image:oo_base_paste_small.png|none]] (see also [[media:oo_base_paste.png|larger screenshot]])

'''4. A wizard opens, define a table name (when connecting to PostgreSQL, write "public." as prefix for the schema):'''

[[Image:oo_base_newtable1_small.png|none]] (see also [[media:oo_base_newtable1.png|larger screenshot]])

'''5. Select the columns you want to transfer:'''

[[Image:oo_base_newtable2_small.png|none]] (see also [[media:oo_base_newtable2.png|larger screenshot]])

'''6. Define primary key (right mouse button on desired column) and all column types:'''

[[Image:oo_base_newtable3_small.png|none]] (see also [[media:oo_base_newtable3.png|larger screenshot]])

'''7. Save and enjoy. The table is now written into your SQL database.'''

Note that the conversion can take some time.

You can now connect the table to GRASS, R-stats, ... as you like.

=== Step by step DB import procedure (MacOSX) ===

Nota la mancanza di driver SDBC su piattaforma OSX, un alternativa per connettere Neoofice con PostgreSQL è possibile utilizzando driver JDBC.
<br>
1) Scaricare i driver direttamente del sito posgresql (scegliere il driver corrispondente alla versione di posgree che si utilizza)
[http://jdbc.postgresql.org/download.html PosgreeSQL]
<br>
ad esempio per postgreSQL-8.1 download del driver:

JDBC 8.1-407 JDBC 2

2) Aprire Neooffice
- preferenze:

http://img118.imageshack.us/img118/109/preferenzeap3.png

scegliere :

Java

http://img236.imageshack.us/img236/6004/javaqr9.png

clik su :

classpath

http://img50.imageshack.us/img50/3504/immagine1tb1.png

click su :

aggiungi archivio

selezionare il driver scaricato

click su :

ok

3) Tornare a : neooffice - database

http://img67.imageshack.us/img67/2043/databasevn2.png

nella finestra di configurazione del nuovo database:

http://img54.imageshack.us/img54/3386/selezionadatabnv6.png

nella sezione : collega a un database esistente, selezionare :

JDBC

clik su :

avanti

http://img111.imageshack.us/img111/2128/immagine3uw6.png

inserire l'url per il collegamento al database in postgresql (nel caso in esempio host=localhost, dbname=grassdb):

postgreesql://localhost/grassdb

classe driver JDBC :

org.postgresql.Driver

click su :

classe di prova

se tutto è correto :

http://img125.imageshack.us/img125/9330/immagine2kw6.png

clik su :

ok

avanti e proseguire con la registrazione del database

http://img67.imageshack.us/img67/8527/immagine13dv9.png

inserire :

nome utente

richiesta password

clik su :

connessione di prova

http://img300.imageshack.us/img300/9965/immagine6ck5.png

inserire :

password

click su :

ok

se tutto è corretto :

http://img64.imageshack.us/img64/896/immagine7ak2.png

click su :

avanti

http://img103.imageshack.us/img103/8379/immagine8kf6.png

click su

fine

per salvare il database

http://img109.imageshack.us/img109/815/immagine9ph2.png

il database è stato configurato con successo:

http://img113.imageshack.us/img113/686/immagine10di9.png

[[Category: FAQ]]