Skip to content

CLI file path conflict with XLSX template #130

Description

@handibles

Thanks for the efforts put into this suite. Part of the same misadventure as #129, but a different issue. With a fresh conda env, ena-upload-cli complains that the files don't match between the glob on the CLI and the filepath entered on the XLSX.

For instance, this fails, despite the file_name field from the run sheet matching the path given to ena-upload-cli. I can't tell from the output which one is the miscreant.

ena-upload-cli \
  --action add \
  --center 'FuntimeSeq Inc.' \
  --checklist ERC000011 \
  --no_data_upload \
  --data $work/path/to/*gz \               #  note path
  --secret ~/.webin.yaml \
  --xlsx path/to/microbiome.xlsx

It's not clear from the error below, but the CLI files and XLSX paths do match, despite the full path only being reported from either the CLI or the XLSX, and not both:

Check if all required columns are present in the study table.
Check if all required columns are present in the experiment table.
Check if all required columns are present in the run table.
Check if all required columns are present in the sample table.
different file names between command line and RUN table: {'/mnt/path/microbiome__18_4_S125_R2.fastq.gz', '/mnt/path/microbiome__1_3_S104_R1.fastq.gz',
'microbiome__1_1_S109_R1.fastq.gz', '/mnt/path/microbiome__12_2_S123_R2.fastq.gz', 
'/mnt/path/microbiome__6_4_S114_R1.fastq.gz', 'microbiome__298_P21_S151_R1.fastq.gz', 
/mnt/path/microbiome__12_3_S101_R1.fastq.gz', 'microbiome__12_3_S101_R2.fastq.gz', 
'/mnt/path/microbiome__4_2_S95_R2.fastq.gz', 'microbiome_ [ ... and so on ... ]

The error can be worked around if I change working directory to the location of the FASTQ, and remove the path from the XLSX - but why does it happen at all?

ena-upload-cli \
  --action add \
  --center 'FuntimeSeq Inc.' \
  --checklist ERC000011 \
  --no_data_upload \
  --data *gz \                            #  note lack of path
  --secret ~/.webin.yaml \
  --xlsx path/to/microbiome.xlsx

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Fields

    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions