Fleet Maintenance Software :: Fleet Management Software :: FLEETMATE
  TECHNICAL ARTICLE: howto_001.htm

 Close Window  

 
 


Title:
HOW TO:  Use Droplist Values from a Different Database


Scenario:
Customer desires to create a new database and use custom drop-list values that have been defined in a different database.

Solution:
Open the database that contains the drop-list values that you want to replicate. Choose the File | Database | Utilities | Export CSV Data... menu option. Using the Data Export window, double-click on FieldValues and Models to select these tables for export. Click on the button (Define Export File) to the right on the Export File Name text box. Choose the folder and file name that will contain your exported information. Click the Export Data button. This process will export the selected tables to the file you defined. Close the Data Export window.

Choose the File | Database | New... menu option to create your new database, choose File | Database | Open... if the target database already exists. Choose the File | Database | Utilities | Import Text Data... menu option. Using the Data Import window, click the Browse button to locate the file containing your exported data. Make certain that the Field Delimiter is set to Comma, then click the Import Data button. This will import all drop-list values that were previously exported from your prior database.

 



If you need additional assistance, please write or call us:
 support@FLEETMATE.com 
410-282-3603


FLEETMATE Software Copyright (c) 1998-2005 by SCB Consulting.  All rights reserved.