QCannotations in Panoramaweb

support
QCannotations in Panoramaweb hao pham  2022-06-02 13:05:59
 
Hi Panorama team,

First of all, thank you for your work in creating this platform to monitor instruments.

I'd like to bulk upload QCannotation for an instrument, but there is this error (image attached).
This is what I have tried.
-create a single line dummy annotation, export it as excel or text file, add in the desired annotations. When I upload this file, I received that error.
-download the template and fill out with the desired annotations. When I upload this file, I received that error.

We also want to look into R script for QCannotation, but is there a place to integrate this.

Thank you so much for your suggestion
 
 
vsharma responded:  2022-06-02 14:05:05
Hi Hao,

Thank you for using the QC folders on PanoramaWeb.

From the error message it appears that a number (database Id of the annotation type) rather than text is expected in the "QCAnnotationTypeId" column. However, it should work if you check the box for "Import Lookups by Alternate Key". This worked for me:
- Download the template file from the "Import Data" page
- Open the file in Excel and fill in the annotations
- In the "Upload File" panel, browse and select the file
- Check "Import Lookups by Alternate Key"

Can you please try this and let us know if it works for you? The value in the "QCAnnotationTypeId" column should match the name of an annotation type in the "QC Annotation Type" table .

Thanks,
Vagisha
 
hao pham responded:  2022-06-03 13:14:29
Hi Vagisha

Thank you, this works!