Bulk Update Data with Exports and Imports

You are able to bulk update departments, employees, projects, tasks, incidents, jobs, and other items into WeTrack using the import feature. For a full list of what data you can update, see Introduction to Imports and Exports.

To bulk update data, you will download an export of your current data for the type of import, update data as needed using the in-app guide, and then upload your document. The new data will be available within 15 minutes (you can work while this processes in the background) and you will receive an email confirmation once the import is complete.

To bulk update data:

1. In the lower-left sidebar, click Profile and select Settings. The Settings page displays.
2. In the Settings list, click Export & Update
3. In the drop down, choose the type of data you want to update. The page updates with a button to export your current data, a button to import your updated file, and a list of all columns with instructions how to add the data for that column.
4. Click Export [data type] to XLSX. The data file downloads to your computer.
5. Open the file. There is a column matching each column in the in-app guide, with current data added.
6. Update the file as needed, following the instructions in the in-app guide. Once the update is complete, save the file. 
7. Go back to the Export & Update page (steps 1-3) and click Upload File. A file upload dialogue displays.
8. Choose the completed template from your computer and click Open (button text may vary based on your computer's operating system). WeTrack validates the data in the file. A list of errors displays.
9. Correct any errors in the template file on your computer. You can check the errors off as you go to help you keep track of your work, but be aware that selecting Corrected does not correct any data in the upload.
10. Save your work and click Go Back to re-upload the template file (steps 8-9). We Track again will again validate the data and list any errors to be corrected.
11. If there are no errors in your data, a confirmation message displays letting you know that the file is ready to import and how many records will be added.
12. Click Start Import. The data import begins. The new data will be available within 15 minutes (you can work while this processes in the background) and you will receive an email confirmation once the import is complete.

File Preparation Notes

• When adding multiple items into the same field, such as multiple users, or departments, separate the items by semi-colons and without spaces: John Smith;Joe Bloggs or COM;MKT
• Make sure all information appears exactly as it appears in WeTrack. Typos, skipped spaces, and such will cause import errors.
• Make sure all unused columns and rows are empty.
• When importing risk actions, they must be associated with their parent risk. To do this:
  • For each parent risk, add a value to the Item Number column (column A): #1, #2, #3, and so on.
  • For each risk action, add the Item Number value of its parent to the Parent Risk column (column D).
• When importing sub-tasks, they must be associated with their parent task. To do this:
  • For each parent task, add a value to the Item Number column (column A): #1, #2, #3, and so on.
  • For each sub-task, add the Item Number value of its parent to the Parent column (column F).