Exporting your data for the Menstrual Cycle Study

This article assumes:

  • You are participating in the Diabetes Center Berne Menstrual Cycle Phases and Type 1 Diabetes Management study.
  • Before beginning the menstrual study survey, please make sure you have your diabetes data uploaded to your Tidepool account. You will need to be using a computer to export this data and ready to share in the survey.
  • See Exporting your Tidepool data for the standard Tidepool steps on this topic if above does not apply.

 

Watch this video for instructions on exporting and anonymizing your data, or follow the written steps below. Click the word YouTube in the video below to see it bigger on YouTube.com or click the Full screen icon to make it easier to watch.

Exporting your diabetes data from Tidepool

  1. Log into your Tidepool Web account by visiting app.tidepool.org using Google Chrome or Microsoft Edge.
  2. Click on your name with the cog wheel at the top middle of the page.
  3. Scroll down until you see the Export My Data section
  4. Select three month increments of data. For the latest period you're sharing data for, make sure that includes the day during which you had a period start plus one week prior to that. E.g. If your latest period started on November 11th, select November 4th. This means your export will be November 4 through August 11 to encompass three months + an extra week prior). If you're in the middle of a menstrual cycle, just export from the first day of that cycle.

  5. Leave the options for Units and File Type to their defaults unless otherwise instructed.
  6. Click the Export button.

An XLSX file will be generated and downloaded to your computer. This is the file(s) you will upload to the REDCap link.

2023-12-06_09-21-38 (2).gif

Anonymize your Tidepool Data

  1. Open the exported XLSX file, and delete the following columns from every tab in your Excel file.  
    1. Payload
    2. Annotations
    3. Device Serial Number 
    4. Device ID 
    5. Upload ID 
    6. Active Schedule
    7. Schedule
  2. On the Upload tab, delete the following columns
    1. Device Serial Number
    2. Device ID
    3. By User
    4. Upload ID
  3. Save the file with the following naming convention: TPPData-Date. Do not use any personally identifiable information like names. 
  4. Share/upload the modified file in the menstrual cycle study questionnaire. If you do not have the link already open you can find it here.