Versions Compared

Old Version 3

changes.mady.by.user Russell Shirley

Saved on

compared with

New Version Current

changes.mady.by.user Drew Norris

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • Maintenance > Dataset Maintenance
  • Press the Export button.  Only the current dataset can be exported.  The Export button is available only if the current dataset is MSSQL.
  • Select the tables to export
  • Choose to clear any columns upon export (such as Social Security Number).  The syntax is Table:Column.  Separate each table/:column combination by commas. (i.e. N01_NAM_ADR_INF:N01_PHN_NUM_S,N01_NAM_ADR_INF:N01_SSN_FED_ID_S)
  • Press Save to save this configuration as the default export setup for this dataset
  • Press Export to export the selected tables
  • The export process puts several files in the dataset folder
    • BulkIOService.Export.zip - the dataset data
    • BulkIOService.Schema.zip - the database schema
    • BulkIOService.Export.Version.txt - the AGRIS version that is exported
  • The export process is complete.  Copy the dataset folder to the intended destination (archive, send to Cultura, move to another db server, etc)
    • The entire dataset folder is needed after export.  There is non-database information in the dataset folder (package initialization files, CFT setup, spooled reports and forms, and more)
  • NOTE:  The resulting BulkIO files can be quite large.  If the exported dataset needs to be moved across a WAN or transferred to ftp.culturatech.com, it is highly recommended to first zip up the numbered dataset directory that contains the BulkIO files (i.e.  AGRIS\Datasets\001) and then move/transfer the resulting zip (i.e. 001.zip).  


Dataset Import

  • Maintenance > Dataset Maintenance
  • Press the Import button.  The Import button is available only if the current dataset is MSSQL.
  • Select the folder to import
    • If searching for the import path, note that the AGRIS search window is a file search, not a folder search.  Choose any file in the import folder.
    • The folder selected must have the 3 export files in it (BulkIOService.Export.zip, BulkIOService.Schema.zip, BulkIOService.Export.Version.txt)
    • Do not unzip the export zip files
  • Optionally set the dataset number.  If blank the next available dataset number will be assigned.
  • A dataset from a prior AGRIS version may be imported.  A data conversion will run as part of the import process.

...