Grower Level Add Data - Field Samples

Importing of Field sample layers at the Grower level allows for the bulk import of Shapefiles with identical formatting for the DBF files typically from the same source/lab. This option can import Sample points with elemental Data or Sample points without elemental data.  Field Samples loaded without elemental data can have the data loaded via an Integration with a soil lab or CSV upload at the field level. 

Steps to Import Field Samples from the Grower Level

1. Right Click on the desired Grower Name in the Profile Tree
2. Click "Add Data"
3. The Data Upload window will open, select the Data Type "Field Sample"[1]
4. Input the "Date"[2] to be applied to all imported field Sample layers or  use the "In File"[3] option to assign a date column from the imported files. 
5. Select desired inputs[4] for Sample Type(Soil, Tissue, Water, Nematode), Lab, and File Type(Shp or CSV).
6. Click "Choose File"[5] then choose the file for import, click "open"
7. Click "Add/Upload"[6]
8. The system opens "Import Sample Data" window
9. If using the "In File" option this requires the Date column to be assigned along with the Date format in the file.
10. The File Type "CSV" requires the Longitude and Latitude columns to be assigned.
11. Use the "Sample ID Column:"[7] drop down menu to select the column that contains Soil Sampling ID numbers. Please Note: Options found within this drop-down menu populate directly from the CSV or Shape File. Additionally, if the file was obtained as an export from the FieldAlytics system, the "FieldAlytics Template Check"[8] button may now be clicked, and all other help steps below may be skipped, except for clicking the "Import"[19] button on Import Sample Data window.
12. If a "Load Template" was created from a previous upload of similar sourced elemental data, use the "Load Template"[9] to select a template, then "Load" Please Note: Templates saved by the logged in user are only visible to this user. Templates can be shared using the "Tools - Field Sample Template". Reference Related Article below for help sharing Field Sample Templates.
13. In the absence of a template, use "Add Element"[10] drop-down menu to select the Soil sampling Nutrients to be imported, click "Add"[11]. Please note: Options in this drop-down menu are system generated.
14. Continue using "Add Element" menu until all Field Sample elements have been entered. 
15. The "DBF Column"[12] drop down menu will populate directly from the CSV or Shape File, if the DBF column header match the selected element. If the system was not able to match the element to a DBF column from within the file, the drop-down menu will be blank. 
16. Ensure all elements have been mapped to the DBF column[12] they represent. Review all Unit[13] and Method[14] columns to ensure they are as desired.
17. Select additional desired Options[16] for "Email results", "Exclude points outside of boundary" and "Import field sample without element data". Click the "Import"[19]  button when finished. Please Note: Before hitting the import button at this point the "Save as Template"[15]  button may be clicked to save reoccurring Field Sample import nutrient scenarios as templates. Simply click the button and name the template, then save. The template associates with the file type(Shape or CSV) being imported. 
18. Elements can be removed from the imported element list by hitting the "red X"[17] to the right of the desired element.

Field Sample Upload FAQ

Can multiple depths be added to nutrients?

• Yes. Select the element from the "Add Element" drop down menu, then click "Allow multiple depths for Element"[18] check box, then click "Add". The system will allow you to then add the same element again, and define separate depths and DBF columns for each. See image below.

What should be chosen for "DBF Column"?

• To determine the nutrients stored within a shape file, Unzip/Extract the file, then open the .dbf portion of the shape file within a spreadsheet viewer like LibreOffice Calc, or older versions of Microsoft Excel. All of the "DBF Column" drop-down menus within the "Import Sample Data" window are populated directly by the column header texts within the .dbf portion of the shape file.

If the wrong nutrient is chosen can that information be edited within FieldAlytics?

• A new nutrient may be added through the Edit Sample Values utility, and existing nutrient point values may be edited, however existing nutrients may not be deleted directly through FieldAlytics. If a different nutrient lineup must be achieved, re-upload the data and select the needed nutrients. For more help with editing sample values(Reference related Article below: Editing Field Sample Values)

Can CSV Field Sample files be uploaded ?

• Yes, field level CSV files can be uploaded- however they are uploaded through the CSV File Upload/Merge option that is displayed on empty Field Sample Layers. (Reference related article below: Field Sample CSV File Uploading/Merging)