Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. On top navigation bar, click on Action → Import From File

  2. Click Browse… to locate the completed template.

  3. Select the file and then Open.

  4. Click on Continue

  5. A pop up window with any confirmation, errors, or warnings will appear. Review the messages and click on the X to close the window.

  6. To review the new entries, use the “Load Status” filter and select “New” then“Apply” at the bottom.

  7. Select each record to review the data. If you need to update the record, you can click on “Update” at the bottom.

Import via template rules

Below are some good rules to keep in mind when you are working on imports via templates:

  1. Ensure you use the correct template - download “fresh” for each upload

  2. Leave column headers as they are - never change the Column headers in the first row of your import template

  3. Second-row descriptions are your guide - you may change the content of these cells to be more specific to your organization or the type of data you are importing

  4. Empty fields when updating data - never leave a column heading in your template with cleared or blank data below UNLESS you really wish to clear data

  5. Formatting - keep in mind that the file you are working in has a specific format (comma separated values) - amounts should not contain unique characters such as commas, double spaces, or leading zero’s