| Version 10 (modified by , 14 years ago) (diff) |
|---|
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 thelower_case_table_names system variable, which you can set when starting 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
- There are 3 variables
- Variable 1 is a string , Variable 2 and 3 are numeric
- 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.
- Variable 2: first column=9, last column=10
- 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 .
