Download ADMS User Manual - Seven Rivers District

When you have finished selecting all of the desired data items, review the order of the items
in the “Fields to Export” list. This is the sequence order in which these fields will appear in
the export file. If you need to change the sequence, highlight the field that needs to be
relocated and click the Move Up or Move Down button.
When exporting adult leaders or other members, you can optionally limit the members
included in the export file based on selection criteria. For example, adult leaders could be
limited to specific unit types or by “Filtered Selection” (see para. 2.10a).
Once you have selected the export type, fields to export, and members to include, you are
ready to create the export file. If you wish to view and/or print a copy of the file format, click
the View Export File button. When finished, click the Export button. ADMS will display a
Save As dialog that allows you name the file and select the target folder.
3.7 Importing Data
To facilitate building your database, ADMS provides several import options. For example,
you can import from an ASCII delimited file or from a ScoutNET unit export file. The
options in this area are “one-time” functions designed to help you get started. ADMS also
provides “routine” import options for receiving periodic updates of your database. On the
Counselors pull-down menu, there are “Receive” and “Transfer” options that allow you to
send/receive data to/from the district leader who is responsible for maintaining the MBC
database. In addition, on the Unit Management dialog, there’s an Import button (see para.
11.1c) for loading revised data from units using TroopMaster and PackMaster.
a. ASCII Delimited.
This option makes it possible to import data that you were
maintaining on some other database system. You’ll need to export the data from the other
system to an ASCII delimited text file using any delimiter you like.
We recommend that you first create an import format structure in ADMS and then use
that format when creating the export file from your other program. First, select the type
of data you plan to import from the “Select area” drop-down list. Then, highlight the
desired data items and click Add. If you add a field by mistake, highlight it and click
remove. If necessary, adjust the data item sequence by highlighting the item that need to
be moved and click the Move Up or Move Down button. When finished, click the View
Import Format button and print a copy of the file format. Use this along with the
delimiter you selected to create your import file.
When you have the file, return to this dialog, recreate the same import structure, and click
Continue. Lastly, browse to the import file and click Open to begin the import process.
The ASCII import options are all one-time operations. When you import data on adult
leaders, MBCs, POCs, or FOS, the members being imported will replace any members
of the same type who are already in the database. For example, if you import adult
leaders, ADMS will erase any existing adult leaders from the database before it
processes the import file.
17