1. On the Home window, from the Data Management branch, double click on the Import Properties branch.
2. Click on the Sighting Data tab.
3. Check the Text File check box. Do not check the Prompt for Event Year check box unless you will be importing data older than a few days.
4. Click Save.
5. Place text files of sightings in the Flat File Directory. Note: the sightings must be formatted in either standard CLM Format D or H and the files must be named according to the conventions listed at the bottom of this topic.
6. Click the Data Mgmt | Import Data Only or the Import Data and Create Cycles (may take a lot longer – it is recommended that Cycles be run overnight during a scheduled Import Data and Create Cycles activity) menu.
WARNING: Do not import more than one year at a time. RMS cannot distinguish between CLM records from the same month, but in different years.
CLM File Naming Conventions
Part of Name Character Position Explanation
Import flag indicator 1 - 14 "NotImported" (this indicates that the file needs to be imported)
Type of records 15 - 17 Always "CLM"
Format of records 18 "D" or "H" depending on the format of the records
Format of file 19 - 23 Either "Fixed" for fixed length or "Comma" for comma delimited
Source of records 24 - 26 "TXT" for text file
Date / Time Stamp 26 - 39 Example: 6/11/2007 12:01:01 PM would be: "20070611120101"
File extension ".txt"
The naming convention allows files to be dropped into the Flat File Directory and if they are named properly, RMS will automatically import them upon the next import process, keeping things very simple. After the file is imported successfully, the "NotImported" part of the file name is removed by RMS.