Upload spreadsheets

Good news! You can now upload your existing data or 'legacy data' directly to MERMAID using the mermaidr R package.

If you are new to MERMAID but have data from past surveys in other formats, you may be trying to figure out how to import your legacy data into MERMAID. The mermaidr package is a way to ingest your old data into MERMAID. 

Ingesting data should only be used for legacy data. For an ongoing project, it is easier to use the app directly.

The ingestion workflow

Steps for ingestion using the mermaidr package:

  1. Create a project in MERMAID with sites, management regimes, and users added.
  2. Adjust your data format to the MERMAID template. You can download the template for each method using the mermaid_import_get_template_and_options function from the mermaidr package. More information on how to use it can be seen here.
  3. Ensure the mandatory fields are filled. Mandatory fields include an asterisk (*) sign in the column name.
  4. Check each field to make sure it matches allowed field options for importing data for a given method. To check each field, use the mermaid_import_check_options function from the mermaidr package. More information and example on how to use it can be seen here. A field that matches will produce a green check sign.
  5. After all fields have passed the checking process, you can import your data using the mermaid_import_project_data function from the mermaidr package. Detailed information and an example can be seen here.

All ingested data will appear on the Collecting page. These data will need to go through the regular validation and submission process. For an example how to ingest your legacy data using the mermaidr package, head to the ingesting fishbelt data example.

Unsubmitted ingested transects appear on the Collecting page of the user who did the ingesting. To transfer unsubmitted sample units to another user, a project admin can use the project's Users page.

Ingested data will appear in your collecting page and will be shown on the Project Page under the COLLECTING tab. The number in the red circle shows the number of sample units in your collecting page, while the number without the red circle show the total unsubmitted sample units in a project.

We have also prepared below a video to walk you through the ingestion steps, using the historical fishbelt data as an example. 

Ingesting historical fish belt data into MERMAID using the mermaidr package.