loading

The myColitis application will import two formats tab delineated txt files or JSON files.  The scenarios below import new bowel movements into the application from a text file which can be edited in excel or other spreadsheet softwares.  Below are a few steps to help guide you through importing data in several scenarios;

Scenario 1 – You have no data entered into the myColitis application.

  • (1) Download this example file to edit.  Make sure to delete all example data or it will import into the application.
  • (2) You can then modify this txt file in excel or any other spreadsheet program, it is import that the columns stay in the order exported.
    • You will need to delete all previous entries in the txt file before re-importing or you will get duplicates in the myColitis application.  MyColitis does not override previous entries, but adds new ones when importing a text file.
    • Some columns require specific values ie the type column and pain columns.  These values are the same as when entering via a form.  Columns like the comments column you can enter any values.
    • Once modified save as a tab delineated txt file to re-import in myColitis.
  • (3) Go to Settings – Import Data – Excel File – Press Select File – Select Event type “Bowel Movements” – Press Import.  This will import the new entries into myColitis.

Scenario 2 – You have been using the myColitis application and already have entries recorded.

  • (1) Go to Settings – Export Data – With Application Back-Up selected press export and save the file. This will create a backup file of all your data in case something happens.
  • (2) Download this example file to edit.  Make sure to delete all example data or it will import into the application.
  • (3) You can then modify this txt file in excel, it is import that the columns stay in the order exported.
    • You will need to delete all previous entries in the txt file before re-importing or you will get duplicates in the myColitis application.  MyColitis does not override previous entries, but adds new ones when importing a text file.  JSON files will overwrite all data.
    • Some columns require specific values ie the type column and pain columns.  These values are the same as when entering via a form.  Columns like the comments column you can enter any values.
    • Once modified save as a tab delineated txt file to re-import in myColitis.
  • (4) Go to Settings – Import Data – Excel File – Press Select File – Select Event type “Bowel Movements” – Press Import.  This will import the new entries into myColitis.