Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
ymarcon opened this issue Mar 9, 2015 · 4 comments
Open
Milestone

Comments

@ymarcon
Copy link
Member

ymarcon commented Mar 9, 2015

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
Copy link
Member Author

ymarcon commented Mar 12, 2015

Issue was closed with resolution "Fixed"

@ymarcon
Copy link
Member Author

ymarcon commented Mar 13, 2015

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 c982e41)

@ymarcon
Copy link
Member Author

ymarcon commented Mar 16, 2015

Comment created by @obiba-ci:

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

@ymarcon
Copy link
Member Author

ymarcon commented Mar 16, 2015

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 ymarcon added this to the 1.11.1 milestone May 25, 2018
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant