How to Export ELB .csv Files from SMS
- Once in the correct SMS project, select the "Batch Command" button.
- Select "Export" from the list and click the "OK" button.
- Using your filters, select the desired Year and Grain Harvest, Merge Filter Result Datasets by..." Field, and click the "Next>" button.
- Filter out any unwanted datasets and click the "Finish" button.
- Select "Export to a Generic File Format" option and then click the "Start Generic File Export Process..." button.
- Select the "Comma delimited text (*.csv)' option and then click the "Export Settings - Comma delimited text (*.csv) button.
- In the lower righthand corner, select the "Load Template..." option.
- Navigate to the "PCS ELB Harvest.xpt" export template. If you do not have this template, see how to get templates into your SMS Project by clicking here.
- Click the "Open" button.
- Click the "OK" button.
- Click the "Export to Selected File Format..." button.
- Place in a folder and click the "OK" button.
- Now that the file(s) are in the folder, navigate to the folder and compress/zip the folder.
- Upload your data via the PCS Website.
- Data Support will email you once the data has been uploaded into the website.
- If you have any questions, do not hesitate to contact your Advisor Support Representative.