How do I upload and use external data?
Upload a CSV file to bring data from outside your Bonterra products into Impact Hub, such as city crime statistics, survey results, or a partner organization's records. The file becomes a dataset you can use in a report on its own or join with your product data.
Important things to know
-
CSV files only. If your data is in Excel or Google Sheets, export it as a CSV first.
-
Storage is limited. Enterprise accounts include 5 MB of external data storage. Essentials and Pro accounts don't include storage and need to purchase an add-on to upload external data. Enterprise accounts can purchase an add-on for more storage. Contact your Bonterra account team to purchase add-on storage.
-
The allowance is one total for your organization, not a limit per file. Only uploaded CSV data counts toward it. Datasets from your Bonterra products don't.
-
Uploaded data is a snapshot. You can't update an uploaded dataset in place yet. To add new data, upload a new file to create a new dataset. See Refresh your data below.
-
Only Impact Hub Authors and Author Pro users can upload and use external data.
-
Only the person who uploaded the dataset can access it. Sharing uploaded datasets isn't available yet.
-
Impact Hub doesn't check uploaded files for sensitive data. Upload only data you're permitted to store.
-
SPICE acceleration is available for uploaded datasets.
Upload a CSV file
Step 1: Start a new dataset
-
Sign in to Impact Hub.
-
From the left-side navigation menu, select Builder.
-
Open the Data sets tab.
-
Select Create data set.
Step 2: Choose the type
-
Select Upload a file. The option shows the file limit: CSV files up to 5 MB.
-
Select Next.
Step 3: Select the destination
-
Confirm the Product.
-
In Organization, select the organization the dataset belongs to.
-
Select Next.
Step 4: Select your data
-
In File, drag your CSV file into the upload area, or browse to select it.
-
Check the storage indicator next to the file. It shows how much of your external data storage you've used.
-
In Name, edit the dataset name if needed. The name defaults to your file's name followed by data set, for example
sample-data.csv data set. Remove the.csvto keep the name clean. -
Review the Data preview. It shows the first three rows of your file, so you can confirm the columns read correctly.
Step 5: Save
-
Select Save.
-
Wait for the Data set created message.
Your new dataset appears in the Data sets list with the type Uploaded file and its file size. This type is separate from System-generated datasets and custom datasets you create from them.
Step 6: Review the dataset
-
Find your new dataset in the Data sets list.
-
Select View data set.
The details page shows the dataset's type, file size, dates, and data connection. Under Enhancements, you can turn on SPICE acceleration if you need faster report performance or want to join the dataset with other SPICE datasets. The section shows your available SPICE credits. See How do I enable SPICE acceleration on datasets?
Objects using this data set lists the reports and datasets that use this dataset.
Use an uploaded dataset in a report
Add it to an existing report
-
Open the report in Builder.
-
In the Data panel, open the dataset dropdown.
-
Select Add data, or select Manage data to add and remove datasets.
-
Select your uploaded dataset.
The dataset's columns appear in the Fields list, and you can add them to any visual in the report. For more on working with datasets in a report, see How do I add and manage datasets in an Impact Hub report?
Start a new report from the dataset
-
On the Data sets tab, select the ... menu on your uploaded dataset.
-
Select Create report.
-
Enter a Report name. Your dataset is already selected in Data set(s).
-
Select Save.
Join uploaded data with your product data
To combine an uploaded dataset with your product data, add it to a custom dataset using a join. See How do I build a custom child dataset?
Refresh your data
You can't replace the file on an existing dataset yet. To bring in updated data:
-
Upload the new CSV file as a new dataset.
-
Add the new dataset to your reports. See Use an uploaded dataset in a report.
-
Delete the old dataset to free its storage.
Check and manage your storage
Check your storage
-
While uploading: the storage indicator in Step 4 shows how much of your allowance you've used.
-
Any time: from the left-side navigation menu, select Data connections, then open the data connection.
Free up storage
-
On the Data sets tab, find the uploaded dataset.
-
Select the ... menu, then select Delete.
Storage is released immediately.
You can't delete a dataset while custom datasets or reports use it. Open the dataset, check Objects using this data set, and remove the dataset from those first.
If a file doesn't fit
If a file is larger than your remaining storage, the upload doesn't complete. You can:
-
Shrink the file. Remove columns and rows you don't need to report on, then upload it again.
-
Delete datasets you no longer use.
-
Add storage. Contact your Bonterra account team about the storage add-on.
Troubleshooting checklist
Pre-checks
- Does your plan include external data storage, or have you purchased the add-on? (Enterprise accounts include 5 MB. Essentials and Pro accounts need the add-on.)
- Is your file a CSV?
- Is the file smaller than your remaining storage?
- Are you signed in as an Author or Author Pro user?
- Are you signed in as the person who uploaded the dataset? Other users can't see it.
Post-change verification
- Did you see the Data set created message?
- Does the dataset appear in the Data sets list with the type Uploaded file?
- Does the dataset appear when you select Add data in a report?
- Does the storage indicator or the Data connections page reflect the new file, or the space freed after a delete?
Known limitations
-
Uploaded datasets can't be shared. Only the person who uploaded a dataset can see it.
-
Uploaded datasets can't be updated in place. To refresh your data, upload a new file as a new dataset, then re-point the custom datasets and reports that used the old one.
-
Every column imports as text. Dates, numbers, and IDs such as ZIP codes all arrive as text. You can convert columns in a custom dataset, but a conversion can fail if the date format in your file doesn't match the format the conversion expects. To reduce the risk, format dates as
YYYY-MM-DDin your CSV before you upload. -
Spatial data isn't available for uploaded datasets. You can't geocode addresses or coordinates in an uploaded dataset, and latitude and longitude columns import as text.
-
You can't delete a dataset that is in use. Remove it from the custom datasets and reports that use it first. The dataset keeps counting toward your storage until you delete it.
Related links
