Creating a SNAP-Plus soil test import file from a spreadsheet
Snap-Plus can import soil test information from a text file using a specific format.
You can use a spreadsheet
program to edit a comma delimited file which Snap-Plus will recognize
as a soil test import file if you follow a couple of rules.
- Download the following spreadsheet template by right clicking on
the link and then choosing "Save link target as..." from the popup
menu. RIGHT-CLICK HERE.
This spreadsheet has labels for all the columns that need to be in the
import file. Do not delete any of the header labels.
- Open the spreadsheet and enter or copy your data into it.
SNAP-Plus expects that each import file will be for a single farm, but
with as many different crop fields and samples as necessary.
- There is one line per soil sample results. SNAP-Plus DOES NOT import averaged data at
this time.
- The first six columns (LabID through FieldName) require a value,
except that FSAFarm can be missing if the customer has not supplied
one. The remaining columns (7-23) can be empty, except that some value must be entered for BpH
even if it is zero. This is so that when you save the spreadsheet, the
correct number of columns are created in your import file.
- When you are done, save this spreadsheet with a new name using
File/Save As... from the spreadsheet program menu. Make sure it gets
saved as type CSV (in the edit box below where you type in the file
name). If you save it in your SnapPlus\Import directory, then it will
be easy to find from within Snap-Plus.
- You can check the file by viewing it in a text editor such as
NotePad. There should be the same number of comma separated data in
every row.
