External Data Upload

External Data can be uploaded in two ways: by dragging and dropping a CSV or XLSX file into the upload space, or by using a Google Sheet URL. This article outlines both methods.

Starting your upload

Step 1: Open Nexus

To start, go to the Nexus page from the left-hand navigation:

Step 2: Choose your Object

This takes you to the Nexus dashboard, which displays all your created Objects. To add data to one of them, find the Object you want to upload to and click Add new data:

Step 3: Open the External Data Upload page

This takes you to your External Data Upload page. If you have uploaded data before, you will see a list of all the uploads completed for that Object. This page is also where you can track the progress of your uploads, and see whether anything could not be uploaded, along with any errors:

Step 4: Click Upload new data

Click Upload new data to continue with your upload. If this is your first upload, you will go straight to the upload section instead, which is similar to a standard data upload:

Option 1: Uploading a CSV or XLSX file

You will arrive at a page with a target to drop your file onto. You must use either an XLSX or CSV file. Drag and drop your file onto the target, or double click inside the box to open your file finder window:

Select the file you want to import. The system will automatically check your file's column headers and try to map them to any existing Force24 fields. If this is successful, it will automatically select the data map and map all the fields appropriately:

Once your file has been uploaded into our staging area, you will be given the option to choose the External Data Object you want to map it to. Then move on to the mapping section below.

Option 2: Uploading a Google Sheet

Step 1: Switch to Google Sheet

You will arrive at a page with a target to drop your file onto. To change this view and upload a Google Sheet instead, click the Google Sheet toggle button:

Step 2: Enter your Google Sheet URL

You will then be prompted to enter your Google Sheet URL:

To generate a Google Sheet URL, click the Share option in Google Sheets and make sure the access is set to Anyone with the link can view. Then click Copy and paste the link into the option provided:

Step 3: Submit and choose your Object

Click Submit beside the generated URL, then select the External Data Object you want to map to:

Mapping your fields

These steps are the same for both upload methods. On the right-hand panel you will see two columns. The column on the left is a list of all the fields in your uploaded file. The column on the right is the corresponding field within the Force24 platform:

You can change the corresponding field to any other field that has not yet been mapped.

If you do not want to use a particular field, select the -DO NOT MAP- option. This ignores the field and does not import the data it holds:

Uploading your data

Once you are happy with your mapping, click Upload. If you have missed a field and left it unmapped, the Upload button will not be clickable.