== case sensitivity issue in mysql (linux on vm7) ==
Set how table and database names are stored on disk and used in MySQL is affected by the[http://download.oracle.com/docs/cd/E17952_01/refman-5.1-en/server-system-variables.html#sysvar_lower_case_table_names lower_case_table_names] system variable, which you can set when starting '''[http://download.oracle.com/docs/cd/E17952_01/refman-5.1-en/mysqld.html mysqld]'''.

{{{
lower_case_table_names=2
}}}
[Info : http://download.oracle.com/docs/cd/E17952_01/refman-5.1-en/identifier-case-sensitivity.html]

== Spss Export ==
Add log4j.logger.org.apache.commons.digester=OFF

log4j.logger.org.ajax4jsf=ERROR

log4j.logger.org.apache.commons.digester=ERROR

log4j.logger.org.apache.commons.beanutils=ERROR

in log4j settings . Where that lives?

  "META-INF/log4j.properties" --> /gcc_lifelines/handwritten/java/log4j.properties

= '''Another spss writer java library''' =
'''http://sourceforge.net/projects/spss-writer/'''

= SPSS file format =
{{{
male 	37 102
male 	22 115
male 	27 99
....    .. ...
female  48 107
female  21 103
female  28 122
......  .. ...

}}}
{{{
================================
}}}
{{{
In this specific example there are 	
}}}
 1. There are 3 variables
 1. Variable 1 is a '' string '', Variable 2 and 3 are ''  numeric ''
 1. Variable 1: first column=1, last column=6
   * Notice that none of the columns overlap.  The longest case for  column one is the name "female", that spans from the first column to the sixth - or, the letter ''' e'''.  As you can see, one has to manually locate  the first and last column, of each variable.
 1. Variable 2: first column=9, last column=10
 1. Variable 3: first column=12, last column=14

{{{
-----------------------------
}}}
{{{
The corresponding variables are the columns that are selected by the user in the UI , this is returned by getColNames() , and the data of this matrix are returned by the matrix.getData(); for example if the user has selected in the matrix viewer : PA_ID , ztgewicht and gewicht  the exported SPSS file should contain : 
}}}
{{{
PA_ID     1 2 3 4 3 7
}}}
{{{
ztgewicht 1 2 3 4 3 7
}}}
{{{
gewicht   1 2 3 4 3 7
}}}
= BBMRI on VM7 =
 * Admin page is shown in first page . (without login ) - delete user  - mysql> delete from molgenispermission where id = 7;
 * Admin cannot see the Biobank contents (Admin is set to View All)  * restart server  - change setting on view settings  - still remaining the same problem .