9.2 Export/Import Utility

You can use the InfoConnect Enterprise Export/Import Utility to export data from any InfoConnect database into a text (*.ini) or comma-separated value (*.csv) and to import data from either of these file formats into an InfoConnect database. You can also create a detail file that provides information about each field in the exported files (such as the maximum number of bytes allowed in each field, the type of data that each field can contain, etc.)

You can use this utility to perform a number of tasks:

  • Create a backup copy of your InfoConnect database so that you can easily restore it should your original database become deleted or corrupted.

  • Edit InfoConnect paths in an exported .ini or .csv file that you can subsequently import into an InfoConnect database.

  • Export path information from multiple InfoConnect databases and then import the data into a single master database.

If you are copying your InfoConnect database for use on multiple servers, you might need to use the Copy ICS Database Utility, which lets you change certain directory names within the database.

Export Data From

The name of the InfoConnect database from which data will be exported. You can export data from a database on any available system.

Export

Opens the Export Options dialog box, which you can use to set the options for your data file and detail file, and create these files.

Import Data Into

The name of the InfoConnect database into which data will be imported. You can import data into a database on any available system.

NOTE:The library for which you are importing data must already be installed in the destination database.

Import

Click to select the file to import and import it.

Database type

The database type is 32-bit. Earlier versions of InfoConnect Enterprise used a 16-bit database.

 

Ini saves the exported content to a text file (*.ini) that can be edited using a text editor.

Csv saves the exported content to a comma-separated values file (*.csv) that can be edited using a spreadsheet.