Extended Format - #26
This is an ASCII text file where 1 record = 1 soil sample. The fields are comma delimited and records are terminated with CR/LF pair. The Growid, Fieldid, and Sampnum data fields are required. To omit a test value or a recommendation value, enter a zero or blank in that spot.
Note: The file does not contain a header record.
When importing this style into Agvance, refer to format # 26.
Field | Type | Max Size | Req |
GROWID | Text | 6 | True |
GROWER FIRST NAME | Text | 20 | False |
GROWER LAST NAME | Text | 40 | False |
FIELDID | Text | 8 | True |
SAMPNUM | Text | 4 | True |
SAMPID | Text | 10 | False |
FieldDescription | Text | 35 | False |
DateTested | Text | 10 | False |
CROP | Text | 15 | False |
YLDGOAL | Text | 6 | False |
PHW | Text | 6 | False |
PHB | Text | 6 | False |
P1 | Text | 6 | False |
P2 | Text | 6 | False |
K | Text | 6 | False |
NO31 | Text | 6 | False |
NO32 | Text | 6 | False |
OM | Text | 6 | False |
ENR | Text | 6 | False |
CA | Text | 6 | False |
MG | Text | 6 | False |
CEC | Text | 6 | False |
HYD | Text | 6 | False |
PERK | Text | 6 | False |
PERCA | Text | 6 | False |
PERMG | Text | 6 | False |
PERH | Text | 6 | False |
PERNA | Text | 6 | False |
BIP | Text | 6 | False |
SOLSALT | Text | 6 | False |
S | Text | 6 | False |
NA | Text | 6 | False |
ZN | Text | 6 | False |
FE | Text | 6 | False |
MN | Text | 6 | False |
CU | Text | 6 | False |
B | Text | 6 | False |
UD | Text | 6 | False (user defined test result, misc) |
Recs start here | |||
NITROGEN | Text | 6 | False |
P2O5 | Text | 6 | False |
K2O | Text | 6 | False |
LIME1 | Text | 6 | False |
LIME2 | Text | 6 | False |
LIME3 | Text | 6 | False |
MANURE | Text | 6 | False |
S | Text | 6 | False |
ELEMS | Text | 6 | False |
MG | Text | 6 | False |
ZN | Text | 6 | False |
FE | Text | 6 | False |
MN | Text | 6 | False |
CU | Text | 6 | False |
B | Text | 6 | False |
UD | Text | 6 | False |
Extended Soil | Tests Start Here | ||
Ext1 | Text | 6 | False |
Ext2 | Text | 6 | False |
Ext3 | Text | 6 | False |
Ext4 | Text | 6 | False |
Ext5 | Text | 6 | False |
Ext6 | Text | 6 | False |
Ext7 | Text | 6 | False |
Ext8 | Text | 6 | False |