This repository is for Nature Forward to convert their Salesforce data into usable data for ArcGis.
Old Map: https://natureforward.my.salesforce-sites.com/enterWQMSession/displaymapmostrecentwqm
Quick Links:
Updating Sites Feature Layer
Updating Critters Table
Updating IBI Scores Table
Navigate to the Reports
tab on Salesforce. Under the LimnoTech folder there is a report titled LimnoTech Sites
.
Click Run Report
and then click Export Details
.
Change to the following export settings and then click
Export
.
- Export File Encoding =
Unicode (UTF-8)
- Export File Format =
Comma Delimited .csv
Your file will then download to your browser. The file name will be similar to report1719589800854.csv, but with different numbers.
Under the Notebook tab in ArcGIS online, open the Update Sites FeatureLayer notebook.
Click on the cell with code and then click Run
. While the cell is running, it will have this symbol In [*]
, once finished it will change to In [1]
.
Scroll to the bottom of the notebook and click the Upload
button. Upload the report you downloaded in Step 1, then click Update Layer
.
A progress bar will appear and update while the code is running. The layer is successfully updated when the progress bar reaches 100% and Sites layer updated
is displayed.
Navigate to the Reports
tab on Salesforce. Under the LimnoTech folder there is a report titled LimnoTech Session/Critter
.
Click Run Report
and then click Export Details
.
Change to the following export settings and then click
Export
.
- Export File Encoding =
Unicode (UTF-8)
- Export File Format =
Comma Delimited .csv
Your file will then download to your browser. The file name will be similar to report1719589800854.csv, but with different numbers.
Under the Notebook tab in ArcGIS online, open the Update Critters Table notebook.
Click on the cell with code and then click Run
. While the cell is running, it will have this symbol In [*]
, once finished it will change to In [1]
.
Scroll to the bottom of the notebook and click the Upload
button. Upload the report you downloaded in Step 1, then click Update Table
.
A progress bar will appear and update while the code is running. The layer is successfully updated when the progress bar reaches 100% and Critters table updated
is displayed.
Navigate back to the Reports
tab on Salesforce. Under the LimnoTech folder there is a report titled LimnoTech IBI Over Time
.
Click Run Report
and then click Export Details
.
Change to the following export settings and then click
Export
.
- Export File Encoding =
Unicode (UTF-8)
- Export File Format =
Comma Delimited .csv
Your file will then download to your browser. The file name will be similar to report1719589800854.csv, but with different numbers.
Under the Notebook tab in ArcGIS online, open the Update IBI Scores Table notebook.
Click on the cell with code and then click Run
. While the cell is running, it will have this symbol In [*]
, once finished it will change to In [1]
.
Scroll to the bottom of the notebook and click the Upload
button. Upload the report you downloaded in Step 1, then click Update Table
.
A progress bar will appear and update while the code is running. The layer is successfully updated when the progress bar reaches 100% and IBI Scores table updated
is displayed.