The Data Exchange - Survey Import process will import Survey details from an Excel spreadsheet output from the SNAP survey program.
- The file must be in .xlsx format (NOT just renamed - do a Save As).
Required Columns:
- A - Phoenix File ID - must match File ID on Opening
- B and C - Dates - Format: YYYY-MM-DD
- H, I, J - Base, Tech, Method
- AF - Unit - must match Standard Unit on Opening
- AG - Area - sum of Units in XLS must match Standard Unit on Opening
- AH - Survey Result - can only contain these values: NSR, SR, REGEN or FG
- CV and CW Status/Type - NSR/ART or IMM/ART
- CX-EK - Inv and Silv Species, Age, Height
- EN and EO - Site Index and Source
Optional with Rules:
- Column E - Project ID - maximum 10 characters (to match RESULTS)
- Pest Codes = maximum 3 characters. Eg. codes only, not descriptions (Columns: EV, EX, EZ)
See the link below for details on how to import survey data:
Importing Survey data from Spreadsheet