Batch Bulkloading - Intergraph Smart 3D - Reference Data

Intergraph Smart 3D Structural Manufacturing Reference Data

PPMProductFamily
3D Design and Visualization
PPMProduct
Intergraph Smart 3D
PPMCategory
Reference Data
Version_S3D
12.x(2018)

Smart 3D provides a batch file to automatically bulkload the spreadsheets related to pre-nesting to the site database and related schema.

  1. Edit the .lst files to contain the entire path to the spreadsheets you need to bulkload. For example:

    • StructManufacturing\Data\bulkload\Pre-Nesting\SM_MFG_CodelistFiles.lst

    • StructManufacturing\Data\bulkload\Pre-Nesting\SM_MFG_BulkloadFiles.lst

  2. Double click the StructManufacturing\Data\bulkload\Pre-Nesting \SM_MFG_BulkLoad_PreNesting.bat file.

  3. Type the server type after the prompt Database Type [M]SSQL/[O]racle:

    • o - Indicates an Oracle server

    • m - Indicates an MSSQL server

  4. Type the database server name after the prompt Database Server:

  5. Type the site database name after the prompt Site Database Name:

  6. Type the site schema name after the prompt Site Schema Name:

  7. Type the location of the .lst and spreadsheet files after the prompt lstfiles and excel files folder:

  8. Type the path to the symbol share after the prompt Symbol share path:

    Smart 3D starts the bulk load.

If you do not provide an answer for any of the prompts, the system continues to ask that question.

The bulk load cannot start if any parameter is missing. If you are running the batch file from the command line, you must provide these six parameters in the above order.

Example:

SM_MFG_BulkLoad_PreNesting.bat m sever site site_schema Excel_locwtion symbol_path

The following bulkload options are available:

  • The path in yellow indicates the full path to the bulkload executable.

  • -i - Indicates input.

  • -ci - Indicates codelist input.

  • The inputs in green are the .lst files containing the full path to the spreadsheets that you want to bulkload.

    A PUSHD statement in the batch file sets the current folder. If you use .\ in any file path, the software searches for the file in the current folder.

  • -l - Indicates the log file.

  • The input in grey indicates the path for the log file. If you want the log file in the same folder, then give the path name as shown above. If want to place it in a different folder, type the entire path.

  • -ds - Indicates the database server.

  • %DB_Server% - A variable containing the database server name.

  • -dn - Indicates the database name.

  • %DB_Name% - A variable containing the site database name.

  • -ss - Indicates the schema server.

  • %DB_Server% - A variable containing the schema database server name.

    The software uses the same variable for both the site database server and its schema server.

  • -sn - Indicates the site schema name.

  • %DB_Name_Schema% - A variable containing the site schema name.

  • %Symbol_path% - A variable containing the symbol share path.

  • -a 1 -u 1 -f 0 - Indicates whether the bulk load should be done in Append mode or Add, Modify, and Delete mode.

    • -a 1 -u 1 -f 0 - If a is set to 1 and u is set to 1, then the software uses the Add, Modify and Delete mode.

    • -a 1 -u 0 -f 0 - If a is set to 1 and u is set to 0, then the software uses the Append mode.

    • -a * -u * -f 1 - In either case, if f is set to 1, then the software turns on the Flavors option. If f is set to 0, then the software clears the Flavors option.

  • -sp - Indicates the symbols share path.

  • The input in pink is the path to the symbols share. Type the path appropriate for your organization.

Instead of typing the file paths with a dot, you can type fully qualified paths. If any path given in the batch files contains spaces, enclose those paths in double quotation marks.