Alternatively, you can easily use an existing CSV that you have locally to populate the table in Registry. To do so, you can click on the “Import” button and choose “Import CSV”.
As an exercise, we will use the metadata sheet from Yost et. al (2019) here. To follow along, download the Google Sheet to your local computer.
Note that Registry CSV import only supports .csv at the moment. If you have an Excel file (.xls, .xlsx) or text file (.txt), please make sure to save them as a CSV first.
Once you have clicked “Import CSV”, a new modal will pop up with a view of your Latch Data. Select “Upload Files” to upload the metadata sheet downloaded in the previous step.
Once the file finishes uploading, choose the CSV and click “Select”.
Once you choose the CSV file, a pop-up window will show up, which lets you map the columns from the CSV to the registry table columns.
You can choose to create new columns for Registry or select existing columns to map the data to. New tables only have one default existing column, which is “Name”. Let’s change the mapped column for the “Sample Name” (in the original CSV) to “Name” (in the Registry).
You can also change the types of the column to be imported. As an exercise, we can change the type of the columns “organism_name” and “Strandedness” to “Select”.
Once the import finishes, you will see your Registry table populated like so.
Pro-tip: If you want to import a CSV with new columns and one of the columns contains values that match record names in the Registry, the columns and their values will be linked with those records automatically.