Uploading soil test results to your FarmQA account

Soil test report data can be uploaded to your FarmQA account and associated with the fields the samples were taken in. Check out the article below to learn more about setting up your soil import profiles and getting your soils data imported. 

Table of Contents

Formatting your soil test report(s)

Add a Soil Depth

Creating a Soil Import Profile

Using a Soil Import Profile to upload your soil data

Formatting your soil test report(s)

Your soil test report needs to be uploaded as a .CSV Excel spreadsheet file. If you received your soil test report as a PDF file or in a similar format, enter that data into an Excel spreadsheet and save that as a .CSV file. Your .CSV file should include the following columns: Grower, Field ID, Sample ID, Sample Depth, and Date. Having your data sorted into these columns will help FarmQA easily map your data to your fields

Use the table below as an example of how to format your .CSV file. The example below is for a soil test report for the 'Behind Barn' field under the 'Malmskog Farms' grower. The samples were taken to 6 inches and the test results being reported are nitrogen in lbs/ac, phosphorus in ppm, and potassium in ppm. 

Add a Soil Depth

Available from the: Web App

User permissions: Enterprise Administrator, Agronomist

• Click on the Soil icon, then go to the Settings tab.
• Click on the Add  button next to the SOIL DEPTH header (pictured below). 

• Do the following:
  1. Give your soil depth a Name.
  2. Set the Min depth and Max depth for your soil depth. The units will correspond with the units you've set for your account in your account settings (Imperial: inches; Metric: centimeters). 

• Click the Save button when you're done. 

Creating a Soil Import Profile

Available form the: Web App

User permissions: Enterprise Administrator, Agronomist

• Click on the Soil  icon, then go to the Settings tab. 
• Before you create your import profile, you'll have to add some soil depths to associate with your soil metrics. Click on the Add  icon next to the SOIL DEPTH header to add a soil depth. 
• Give your depth a Name, set a Min depth and Max depth, and click the Save button.
• Now that you've added a soil depth, click on the Add button next to the IMPORT PROFILE header to create your import profile. 

• Either click in the window or drag your formatted .csv file of your formatted soil test report into the window to start making your soil import profile (pictured below).

• Set the following information on the first page of your Soil Import Profile (pictured below): 

1. Name: the name you want to give to this soil import profile.
2. Who produced the file (optional): the soil testing laboratory that was used to generate this report. 
3. Grower: the column in the spreadsheet that corresponds with the name of the grower or farm your fields are associated with. 
4. Field: the column in the spreadsheet that corresponds with the name of the field that your samples were taken from. 
5. Sample ID (optional): the ID of your sample. This could be a letter, number, etc. 
6. Sample date (optional): the date the sample was taken on. 

• Once you've set this information, click the Next button.
• On the next page, check the boxes next to the soils data you want to want to import (pictured below). 

• When you've selected the soil metrics you want to import, click the Next button. 
• On the final page, set the following information for each soil profile you want to import (pictured below):

1. Soil property: use this dropdown to set the soil chemical property that corresponds with the property you are importing (i.e. NO3 will be set to Nitrogen (N)). 
2. Unit of measure: use this dropdown to set the unit of measure for each set of soil information you're importing. The unit of measure you set should correspond with units your imported data are reported in. 
3. Depth: use this dropdown to set the depth to which samples were taken. If you haven't set any depths, click on the Add soil depth button at the bottom right-hand corner of the screen.
4. Metric: associate a desired metric with imported soils data. Click on the Add soil metric button to create a new metric to associate with your data if you haven't already set it up. 

• If needed, click the Add soil depth button to create a soil depth you don't have in your system, or click the Add soil metric button to create a metric to assign to one of your soil properties. 

• Click the Save button at the bottom of the Soil Import Profile window to save your import profile. 

Using a Soil Import Profile to upload your soil data

Available from the: Web App

User permissions: Enterprise Administrator, Agronomist, Grower

• Click on the Soil  icon, then go to the Samples tab.
• Click on the Upload soil data  button, then use the dropdown menu to select the soil import profile you want to use (pictured below). 

• Use the available dropdown menus to setup the following parameters for your import: 
  1. Select the top enterprise to import into
  2. Select the growing season to import your data to
  3. Select the marker type to import your data to (this will default to soil sample)
  4. Select the sample date to import into
• Either click within the dashed box at the bottom of the window or drag your file within the box to upload your soil data.

• This process can also be done on the individual field level. Uploading soil sample data to your individual fields can help you avoid having to map out a Grower > Farm > Field tree in your import files, and it can be more effective if you're just uploading a few fields worth of data. Click on the Upload soil data button for an individual field in the Soil > Samples page and complete the steps as seen above (pictured below).