# Tuesday, March 09, 2010
InphoniteVoice includes the ability to import any delimited file (comma delimited, tab delimited, etc.) Included with this new capability is the ability to map any field (or multiple fields) to an InphoniteVoice field. This new import is included free for all users of InphoniteVoice and can be downloaded here:
ftp://ftp.inphonite.com/downloads/InphoniteVoice/CSV-Import.zip

The zip file contains a readme.txt file with directions on how to install the new import. Once the new import is installed you can create an instance of the new Flexible Delimited Import. The configuration screen looks like this:




The new key fields are the Source Columns and the Column Mappings in the File layout section. The Source Columns allows you to define what your delimited file looks like. Here's an example of a simple Source Columns definition:




In the above sample, the import would look for LastName, FirstName, PrimaryNumber, CompanyName and Groups as valid headers in the source file. You can import column headers from a delimited file by selecting Import | Import Column Headers from the menu. This will look at the CSV file and import the headers for you. You can also export the columns as a template to save as a backup or to import into a different import instance. Now that you created the source columns you need to map the data to the destination columns. To accomplish this open the Column Mappings configuration. Here's what that dialog looks like:



The above example maps the columns in the source file to the available fields in InphoniteVoice. To map a new column, select the column you would like to map to. Then select the column to map to from the Source Columns list and select Insert. You can combine multiple source columns fields into one InphoniteVoice field by specifying multiple fields in the template. You can also put static text into the template field to have a particular import always fill out a field with a static value.

InphoniteVoice's new Flexible Delimited Import gives you to ability to control the format of the data and make changes with ease.
Bookmark and Share
Comments are closed.