Import Entries

You can add entries by importing them from a .csv file. This helps you import data collected in platforms outside of Crisis Track, such as 311 or dispatch systems. You can select and download a CSV template for a specific form. The template and the imported entries will contain different fields depending on the form.

To import entries

  1. On the upper left of the Entries module, click Import. The Import Entries page opens.

    Fields used to import entries, including fields to select a form, select a new or existing task, and upload a file

  2. In the Form list, select a form. Text appears showing all the fields in that form.

  3. Click Download CSV Template. The CSV template is downloaded according to your browser settings.

  4. Open the CSV template using spreadsheet software such as Microsoft Excel®.

    The first row of the template contains headers corresponding to each field in the selected form. The second and third rows of the template are example data.

  5. Add the data for entries. Each row corresponds to one entry.

  6. If you have not done so already, delete the example data in the second and third rows.

  7. Save your changes.

  8. In Crisis Track, in the Tasks section of the Import Entries page, do one of the following:

    • Select Upload into a new task. In the Task Name box, enter a name for the new task.

    • Select Upload into an existing task. In Task menu, select an existing task.

  9. Click Choose File. Select the CSV file you just completed.

  10. Click Upload.