💡 Tip: You can download a template for your Log data upload here.
💡 Note: To upload a file, you will need a header row. If there isn't one present, the first row of data will be used as a header and will not be included in the uploaded data.
After your logs have been set up, users can bulk upload log data from spreadsheets using the log widget. To do this:
- Click on the three dots on the right corner of the log widget.
- A dropdown menu will appear. Select 'Upload logs.'
- A pop-up will appear on your screen. Click on the "Add File" button and upload a .csv, .tsv, .xls, .xlsx, .xml, or .txt spreadsheet with your log data.
- Select the sheet and press continue.
- You will be taken to the 'Map Fields' section. Here, hovering over a field will show a preview of your data on the right side of your screen.
- If the system cannot automatically match a section, you can use the "Select" dropdown to match the section.
💡Note: if you are unable to find the corresponding section, you can click 'Do Not Import.' Otherwise, you will need to add the section to the Log Settings.
- You will be taken to the 'Review' page. If anything is in the 'Invalid' tab, there is a problem that needs to be addressed. Hover over the highlighted row/column with your cursor to understand the issue.
- You can fix the issue by manually typing in the section or using the dropdown feature if available.
- If everything looks good and all problems are resolved, click 'Submit.'
💡Tip: Refresh your page after you import log data. If you do not refresh, your log widget might not show as complete (depending on your filters).
You can view the data you uploaded in the 'View all logs' section.
End of Article
Support
If you have any questions or need further assistance, please e-mail help@mapistry.com or call (510) 313-1422.