search

obiba / magma

Data and meta-data abstraction layer.
http://www.obiba.org
GNU General Public License v3.0
6 stars 14 forks source link

MAGMA-253: Excel: do not support interpretation of any sheets as a table #381

Open ymarcon opened 9 years ago

ymarcon commented 9 years ago

Jira issue originally created by user @ymarcon:

Restrict Excel datasource usage to data dictionary = read only "Variables" and "Categories" worksheets, ignore others.

Rational: excel does not scale for data storage and some excel files fail to be loaded because of malformed sheets.

ymarcon commented 9 years ago

Comment created by @obiba-ci:

SUCCESS: Integrated in !http://ci.obiba.org/images/16x16/blue.png! Magma 1.11.x #13 MAGMA-253 excel datasource does not support value tables (yannick.marcon: rev c982e41d074775363808ee045b3d7309ef89aef2)

ymarcon commented 9 years ago

Comment created by @obiba-ci:

SUCCESS: Integrated in !http://ci.obiba.org/images/16x16/blue.png! Magma #462

ymarcon commented 9 years ago

Comment created by @ymarcon:

Cannot export data dictionnary in Excel from opal any more:

2015-03-16 11:31:11,039 [qtp1469107147-285] ERROR org.obiba.opal.web.provider.ErrorDtoExceptionMapper - System error Internal Server Error: java.lang.UnsupportedOperationException
java.lang.UnsupportedOperationException: createWriter() is not supported by datasource of type excel
    at org.obiba.magma.support.AbstractDatasource.createWriter(AbstractDatasource.java:120) <sub>[magma-api-1.12-SNAPSHOT.jar:1.12-SNAPSHOT]
    at org.obiba.magma.support.DatasourceCopier.createValueTableWriter(DatasourceCopier.java:296) </sub>[magma-api-1.12-SNAPSHOT.jar:1.12-SNAPSHOT]
    at org.obiba.magma.support.DatasourceCopier.innerValueTableWriter(DatasourceCopier.java:301) <sub>[magma-api-1.12-SNAPSHOT.jar:1.12-SNAPSHOT]
    at org.obiba.magma.support.DatasourceCopier.copy(DatasourceCopier.java:213) </sub>[magma-api-1.12-SNAPSHOT.jar:1.12-SNAPSHOT]
    at org.obiba.magma.support.DatasourceCopier.copy(DatasourceCopier.java:202) <sub>[magma-api-1.12-SNAPSHOT.jar:1.12-SNAPSHOT]
    at org.obiba.opal.web.magma.DatasourceTablesResourceImpl.getExcelDictionary(DatasourceTablesResourceImpl.java:152) </sub>[opal-core-ws-2.4-SNAPSHOT.jar:na]
ymarcon commented 9 years ago

Issue was closed with resolution "Fixed"