OHDSI / WhiteRabbit

WhiteRabbit is a small application that can be used to analyse the structure and contents of a database as preparation for designing an ETL. It comes with RabbitInAHat, an application for interactive design of an ETL to the OMOP Common Data Model with the help of the the scan report generated by White Rabbit.
http://ohdsi.github.io/WhiteRabbit
Apache License 2.0
173 stars 85 forks source link

Bug open ScanReport in RabbitInAHat v0.10.8 #376

Closed elisahenke closed 1 year ago

elisahenke commented 1 year ago

Cannot import ScanReport.xlsx in RabbitInAHat v0.10.8.

Steps to reproduce the behavior for RabbitInAHat:

  1. Open scan report
  2. Select file (ScanReport.xlsx)
  3. Error: Invalid File Format
janblom commented 1 year ago

Hi @elisahenke ,

I am unable to reproduce this, at least with the small set of csv's that I use for testing (attached). Steps taken:

  1. Perform source scan on csv files with whiterabbit
  2. Open the generated xlsx file with rabbitinahat => no error, expected source tables are visible

Could you try starting rabbitinahat from the command line, repeat the steps that result in the error and share the stack trace that should be visible in your command window?

Thanks in advance, Jan

ScanReport.xlsx person.csv cost.csv

elisahenke commented 1 year ago

Hi @janblom, sorry for the confusion. Now it also worked for my ScanReport. Thanks for helping!

Best, Elisa

janblom commented 1 year ago

Hi @elisahenke , well that is good news, thanks for letting me know. Closing this issue.