The Import Process

 

 Top  Previous  Next
1. The first step is to make sure that your configuration files are being specified under the Utilities, Configuration defaults, File names menu options.  You need to have the Lookup file (.LUC), Draw data file (.DRD) and Object Table (.TAB) files available.  If they aren't select the Clear Config at the bottom of the box and then select the Lookup file.  At this point the rest should be filled in for you.  Say OK to the box.
2.The next step is to create a database, if you already have a database you don't want to overwrite it, so you can skip this step.  If you don't have a database, choose to create one from the Utilities, Database menu options.  It will ask you if you want to create the Milepost, Hundred Block, and Node indexes as well as if you want to Swap Streets.  If you know you have Milepost, Hundred Block and Node information, then select all of these.  If you don't know, go ahead and select them anyway, it won't make a difference if you don't have them.  Unless you are running from a coordinate - based system, (which is unlikely) you want to select the Swap Streets option.  Say OK to the box and it will ask you for a four letter database name.
3.
4.Now your ready to import, select from the Utilities, Database, Import menu options.  It will ask you for your ASCII database name, the Import Definition File (.IML) and the Changes file (.CNG).  Then it will begin the importing process.  You will get a progress box up telling you the percentage of how much has finished and how much it has to go.
5.When the import is complete, it will tell you if you should check your CGFAL#.LOG or the ERROR#.LOG files.  These files will tell you if there was any text that couldn't be converted (CGFAL) or if there were any errors such as duplicate case numbers, or data not found (ERROR).  In general if there isn't a lot of data in these files, then the import process was successful.  See Import Errors - Errors.log for more information.

6.        

Checking the Database Statistics box (F5) will tell you how many records are now in the database and how many street names, as well as give you system information.

 

Now you're ready to create diagrams and do analysis in the program with your new database.