• Send feedback
• Copy URL
• Print this page

NIPO Fieldwork System Version 1.14

Bulk Import

The Bulk Import feature allows fast import of sample table data. Instead of passing import records separately over the network connection from NIPO FMS Client to NIPO FMS Server to Microsoft SQL Server, it places the file to be imported on a network location and instructs the Microsoft SQL Server to take care of direct import. This feature requires the database user account in use by the NIPO FMS Server to have a Bulkadmin server role.

To configure Bulk Import

1. Make sure the user account used by the NIPO FMS Server to access the Microsoft SQL Server has a bulkadmin server role. Consult your Microsoft SQL Server documentation for details on configuration.
2. The NIPO FMS Server and the Microsoft SQL Server require a shared directory to place and retrieve the import file. Create or share a directory on the network and make sure the account that runs the Microsoft SQL Server has read/write access to this directory.
3. Select Configure > Directories from the menu and select the General tab.
4. Click Change… to set the temporary path to the directory shared in the previous step. Specify account information under which the NIPO FMS Server may access this directory with read/write access.
5. Select Configure > Options from the menu and select the Preferences tab.
6. Check Do bulk imports when supported and set additional configuration settings, if required.
7. Click OK.