To clear a field mapping, double-click a mapped Source field, or select the corresponding row and click the button.Ĭlick the button to clear all field mappings.
To map a field in the source file to a field in the destination table, select a field from the Source field column and double-click the corresponding field in the Available destination fields list.Īlternatively, you can select a Source field, select a field in the Available destination fields list, and then click the button to map the fields, or you can simply drag a field from the Available destination field list to the corresponding field in the Source field column. The Destination field column displays the fields in the destination table to which the source fields are mapped. The Source field column displays the fields in the source file, in the order in which they appear in the file. This table, along with the Available destination fields list, allows you to map fields in the specified Source file to fields in the specified Destination table. This window allows you to preview the content of the file in a table format.Įnter the name of the table into which you want to import data, or click the button to select a table from the Choose table dialog.Ĭlick the button to display the table in the Table Preview window.
csv file you want to import into your Counterpoint database, or click the button to browse for the file.Ĭlick the button to display the specified. Source fileĮnter the path and file name of the. The fields and settings that are available in the Database Import utility are described on the following pages. You can save sets of import parameters, including field mappings, and then load them whenever you need to import data from a particular source. The Database Import utility includes a variety of parameters that allow you to control how the data in the source file is imported. You can map fields manually, using a drag-and-drop interface, or you can allow Counterpoint to map source fields to destination fields with names that match the values in the first row of the source file. The Database Import utility allows you to assign, or map, the fields in your source file to the corresponding fields in the destination table.
#Idatabase import update
csv file directly into a table in the Counterpoint database in order to create new records, update existing records, or both. Use the Database Import utility ( Data Interchange > Data Interchange Import) to import data from a.
0 kommentar(er)
