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 |