Skip

Pedon PC - Exporting and Importing Pedons from NASIS

If you encounter problems with the file provided on this page, please contact Soil Survey at 406-587-6818.

The information on this page is also available in Microsoft PowerPoint format. Once you have saved the file to a local drive, open Microsoft PowerPoint then open the saved file on your local drive.

Exporting Pedons from NASIS (PPT; 200 KB)

Exporting Pedons from NASIS

  1. Start NASIS.
  2. Go to the NASIS Select Manager and navigate to the _WinPedon_DataDump_select query on the MLRA 04 or MLRA 17 NASIS Site.
    1. Select Site, Pedon, and Transect as the target tables.
  3. Load the placeholder record and then load your selected set of pedons.
  4. Load placeholder
  5. .
    1. Enter placeholder as the User Site ID.
    2. Enter * at the NASIS Site Name and Group prompts.
  6. Run the query again with the same target tables once placeholder is loaded to load the data you want to export.
  7. Load your selected set of site, pedons, and transect data
  8. .
    1. Enter a User Site ID identifier, you can use wildcards (*MT645* or *06MT645*, etc.).
    2. Enter your NASIS Site Name and Group.
  9. Check that the pedons loaded are the set that you want to export.
  10. Go to the NASIS Report Manager and navigate to either NASIS Site MLRA 17 or MLRA 04.
  11. Run the report called _WinPedon_DataDump_AK or _WinPedon_DataDump_MT, depending on which NASIS site you go to.
    1. This report calls a series of subreports and creates a flat-file of all the data tables.
    2. Use the Save Ascii option and save the output of this report as text file with the .txt extension.

Importing Pedons from NASIS

  1. Open Pedon PC
  2. Go to the Setup Menu, then go to the Import Data menu.
  3. Select Import Data File from NASIS
  4. .
    1. This will open the Import NASIS Data File form.
    2. Browse to the location of the text file (MT645_pedon_datadump.txt) generated by the _WinPedon_DataDump_ report, that you saved on your system.
  5. Click the Import button and the data will be imported table by table
  6. .
    1. The import process takes the larger flat-file and breaks it into the individual pedon data tables.
    2. These tables are placed in a folder called NASIS_DataDump_tables at the same location as the import text file.
    3. The process will import the tables one by one.
  7. Check your imported data to make sure the proper number of records came through. One way to do this is to open the site, pedon, and phorizon table and check that the record counts match the counts you saw when loading the data in NASIS.
  8. A known issue that will cause the import process to fail is carriage returns in any text note memo fields within the data; if carriage returns occur, the sites where they occur will not be imported.