Basic usage

Create script

  • Open the command-line window. Type cmd in Windows search and click it.
  • Navigate to the Data Pump folder (Please check the Reference Card for location of StatMap Data Pump software).
  • If you want to create an import script run DataPump with the folderWithMask /g generatedFileName parameter set, e.g.:
    ..\Tools\DataPump\DataPump.exe "s:\Files To Upload\*.shp" /g "s:\Files To Upload\my_import.script"

folderWithMask – is the source folder path ended with a file marking mask: *.tab – MapInfo TAB files, *.shp – ESRI Shapefile, *.csv – Comma Separated Value text files, *.gz – Geographic Markup Language (GML) files, etc.
generatedFileName – is the script file name which may include specified folder path.

If you only provide DataPump with generatedFileName without specifying folder, then the script file will be generated in DataPump folder.

Execute script

On demand execution

To execute script please run DataPump.exe with the path to and name of the script file you want to execute.

..\Tools\DataPump\DataPump.exe "s:\Files To Upload\my_import.script"
Execution on regular basis

If you plan to execute the same script regularly (Gazetteer upload script is a good example of a script that is uploaded into Earthlight on a daily basis) you will have to create batch file that will execute Data Pump script and add this batch file to the Task Scheduler.
Example of a batch file for our myTabScript.script is shown below:

..\Tools\DataPump\DataPump.exe "s:\Files To Upload\my_import.script" > "s:\Files To Upload\my_import_result.txt"

The section after and including the more than sign is optional. It is a command that will write the results of the Data Pump operations to a specified file. It is very useful when scheduled tasks are executed, since you are able to check after the fact if there were any errors during import.
When creating a new task please check the Run whether user is logged on or not and Run with highest privileges.
Please note that the user account that executes the task has to have the right to use elevated privileges on the machine (has to be an administrator).