<h1>Import from excel</h1>
<p>
  Supported file types are: *.xlsx, *.xls
</p>
<p>You can download sample data <%= link_to 'here', easy_imports_download_sample_file_path(file_name: 'excel_sample_import_file.xlsx' ) %>.</p>
<p>
  Required columns are: Project, Task
</p>
<p>
  Other supported columns are: Due date, Assignee, Priority, Status, Tracker,	Description
</p>

<h2>How are they imported?</h2>
<ul>
  <li>Projects and tasks - are always created new</li>
  <li>Due date - column in excel should be formatted as date for successful import. If format is different or not recognized, due date will be left empty.</li>
  <li>Assignee - should be in format John Doe (first name last name). If corresponding user is found in the application, assignee will be set. Otherwise, assignee is left empty.<br />
    Important: After import, you will need to add members to the newly created projects.
    <ul>
      <li>via project settings >> members, or</li>
      <li>via user >> edit >> projects</li>
    </ul>
  </li>
  <li>Priority
    <ul>
      <li>if priority is found in the application, it is used for the imported tasks</li>
      <li>If it is not found, a new priority is created</li>
      <li>if it is left empty, the default priority is used</li>
    </ul>
  </li>
  <li>Status
    <ul>
      <li>if status is found in the application, it is used for the imported tasks</li>
      <li>If it is not found, a new status is created<br />
        Important: After a new status is created, you will need to configure workflow to be able to use it</li>
      <li>if it is left empty, the default priority is used</li>
    </ul>
  </li>
  <li>Tracker (type of task)
    <ul>
      <li>if tracker is found in the application, it is used for the imported tasks</li>
      <li>If it is not found, a new tracker is created<br />
        Important: After a new tracker is created, you will need to configure workflow to be able to use it</li>
      <li>if it is left empty, the default tracker is used</li>
    </ul>
  </li>
  <li>Description - always imported</li>
</ul>
<%= render partial: 'easy_imports/help/en/workflow_and_members' %>
