Bulkload from the Command Line - Intergraph Smart 3D - Reference Data

Intergraph Smart 3D Reference Data

Language
English
Product
Intergraph Smart 3D
Subproduct
Reference Data
Search by Category
Reference Data
Smart 3D Version
12.1 (2019)

You can run the Bulkload utility from the command line using option switches.

Here is an example of the syntax for updating the catalog using the add/modify/delete mode:

"C:\Program Files\Smart3D\CatalogData\BulkLoad\Bin\Bulkload.exe" -i C:\Program Files (x86)\Smart3D\CatalogData\BulkLoad\DataFiles\AllCommon.xls -l Ismaning.log -ds SP3D -dn Ismaning_catalog -ss SP3D -sn Ismaning_catalog_SCHEMA -sp \\SP3d\Symbols -a 0 -u 1 -r 0 -f 0

Here is an example for a bulkload to a new catalog with MSSQL:

"C:\Program Files (x86)\Smart3D\CatalogData\BulkLoad\Bin\Bulkload.exe" -i C:\BulkloadFiles.lst -ci C:\CodelistFiles.lst -l C:\CatalogDB.log -ds IN-SP3D5 -dn NEWCATALOG -ss IN-SP3D5 -sn C:\apprepos.dat -a 0 -u 0 -r 0 -f 0 -sp M:\CatalogData\Symbols

  • The command prompt must point directly to the folder under which the executable is located, or the complete path to the executable must be specified at the command prompt as required to execute any Windows application.

  • The input file names and paths to the files must not contain any blanks. If you have an input file with one or more blank spaces in its name or path, such as C:\Program Files\My Data\AllCommon.xls, you must use a temporary list file (.LST) to list the file. The command will not work otherwise, even if you enclose the file name and path with quotation marks.

Option

Description

-i

Input Excel file (.XLS) or .LST file with .XLS entries.

-ci

Input codelist file (.XLS) or .LST file with .XLS entries.

-l

Log file (.LOG).

-ds

Database Server name or Oracle Service name.

-dn

Catalog Database name.

-ss

Schema Server name or Oracle Service name.

-sn

Catalog Schema Database name. For a fresh bulkload (if the -a 0 -u 0 -r 0 options are used), you must provide the full path to the template schema file here.

-a

Append mode. Set to 1 for append.

-u

Update mode (add/modify/delete). Set to 1 for add/modify/delete.

-r

Replace mode. Set to 1 for replace.

-f

Create flavors mode. Set to 1 to create flavors.

-sp

Symbol path.

-pt

Provider type for the catalog database. Specify Oracle if the database type is Oracle. The default is MSSQL.

-st

Provider type for the Catalog Schema Database. Specify Oracle if the database type is Oracle. The default is MSSQL.

-un

User name.

-pd

Password.

-bv

Updates the Object Type Hierarchy and Catalog views. Set to 1 to update. Set to 0 to not update. The default is 1 if this option is not specified. Set to 0 only if you are bulk loading to a test catalog.

See Also

Bulk Load Database with Data
Using the Bulkload Modes