Tutorial: Uploader

Preparing the File:

• Make sure your shapefiles are projected to EPSG:3857 – WGS 84 / Pseudo-Mercator. Navigate to where you saved the file using Windows Explorer and highlight all files that are part of the shapefile. Right-click on it and click Send To – Compressed Zip File.

To prepare a .csv file for upload, open it in Microsoft Excel and use the “Save As” button to save it as a Comma Separated Variable file (.csv) or UTF-8. To prepare a CSV be sure to have the CSV meet the following requirements: 

• Remove spaces and special characters in the headers. Make sure headers are 10 characters or less.
• Keep the file name within ten characters and remove special characters
• Remove special characters (@, #, $, %, *, …) throughout the data

Next you will have to prepare your data and TreePlotter™ for your Upload. To get a complete list of tips, please visit our Support Article here to learn more about preparing your data. 

Uploading the File:

If the Uploader tool was included in your INVENTORY app, it will appear under My Data when logged in. Click on the tool and then click Open Uploader to open the tool in a separate window.

This will open the Uploader, which is broken up into six different steps:

 

1. Overview:

First, select what kind of file the data is saved in, either CSV or Shapefile. Then choose what organization(if applicable) and which inventory layer you would like your data uploaded to. 

Finally, click Next (bottom right) to continue.

2. Info:

This page provides information and instruction on the type of file you uploaded.

3. Upload:

Browse to the desired upload file and add it to the Uploader. Click the Upload File to add it.

4. Confirm:

If you have chosen a .csv file, you will be asked to specify which columns in the upload contain the xy coordinates for the points. Confirm that you see red dots showing up in the approximate location of the features you uploaded.

Note: If you do not see red dots showing up on your map, do not continue with the upload as your data will not import correctly. Check to make sure your zipped file has all the necessary components or contact the support team.

5. Crosswalk:

The Crosswalk tab is where upload data can be converted from its existing format to fit within the framework of INVENTORY. There are several different components of this tool to be aware of. First is the Preview Results button(1). Clicking this will provide a snapshot of uploaded data. Use it to track your progress and verify that data is being uploaded correctly. Next, the Reset All Data button will clear all data from the crosswalk process to start it over. The window at the far right shows a preview of the column contents (1). To preview a column, hover over it with the mouse.

Columns from the uploaded file appear on the left under Source (2). The INVENTORY framework appears on the right under Destination (4). To crosswalk a field, click a field on the left (3), then click the field you wish to map it to on the right (5). Click the arrow button to begin the crosswalk process (6). For cross walking the Species we recommend only cross walking one of the two species fields Species Common or Species Latin because all Species fields will be populated by cross walking just one of these two species fields. It is best to see which field has the most matches in the Species Table with your data to determine which to use. After Cross-Walking the species field either Species Common or Species Latin check your progress at the top where it says # features uploaded: percent species mapped: (7) the percent species mapped should be at least 99% or you may have problems with the species uploading correctly.

Types of Fields to crosswalk:

There are two types of fields that the Uploader handles. They are referred to as “map” fields and “copy” fields. Map fields require the user to drag and drop the select options from the upload file over to the Destination, or INVENTORY framework. This includes any field where there are dropdown select or check box options, including condition, maintenance needs, clearance conflicts, and more. This process is detailed below. Copy fields take the exact content of the records from the upload and paste them into the field in INVENTORY. This includes fields like date planted, dbh, notes, and more.

If the field you have chosen is a “Map” field, the interface will look like the figure below. The Automatch button will try to match your upload options with a current TreePlotter™ value. Try this function first to save some time on mapping your values. If some values don’t match, the user will click and drag the item from the left side to the corresponding one on the right. It should be noted that more than one selection from the left can be mapped to one option on the right. For example, if your upload file contains data on tree condition for “Poor” and “Very Poor”, you can combine them into “Poor – Major Problems” to coincide with INVENTORY’s standard condition choices. What options are available within the INVENTORY framework is defined by the client and PlanIT Geo™ prior to building the application.

Once you have dragged all options over from the left side, click Done With This Field. If you have null values we recommend not mapping them to anything including “Do not map”

For “Copy” fields, the buttons will look slightly different. The Submit Your Data button will copy all of the contents directly into the INVENTORY column. After you select Submit Your Data, select Done With This Field to return to the previous screen. These fields include Address, DBH, or Height (numbers and text).

When you are satisfied with all of your crosswalk choices, click Next.

6. Complete:

The last step is to click the “Import the Trees Into the Map” button. Once this has been clicked, the trees will show up as points on the map. Once the Import button has been clicked, the changes are final. Double check your data before pressing “Import the Trees Into the Map”. This page also specifies the generated upload ID for your upload. This upload id will be relevant if the user has the need to Mass Delete data by upload id. After capturing your upload id click the Finish button.

Troubleshooting:

• ‘Error Loading Shapefile to Database’ or ‘Invalid File Please try again’
  • Check your zip file contains all of the shapefile files and that they aren’t in a subfolder

• Error Loading CSV file
  • Delete any columns labelled Photos or Geom (they may appear if you initially exported the data from TreePlotter)

Known Limitations: 

• The uploader will only work if all the data in your Input file matches what is in TreePlotter™
  • If it does not match for instance if you are trying to put Text data into a Numeric field, the data may not upload successfully or in some instances the data will upload but that field will be empty
• Invalid headers might cause data not to upload. See Preparing Data for the Uploader.
• Cross walking data incorrectly can cause your data not to upload or to upload incorrectly

Next Steps:

Tutorial: Lookup Table Editor

Tutorial: Data Field Editor

Video Tutorial:

Back to Data Tools