DBA Settings - Intergraph Smart Materials - Version 2020 (10.0) - Help - Hexagon PPM

Intergraph Smart Materials Classic Help (2020)

Language
English
Product
Intergraph Smart Materials
Subproduct
Classic
Search by Category
Help
Smart Materials/Smart Reference Data Version
2020 (10.0)

You can find a detailed description of how to set DBA settings and the purpose and usage of each DBA setting in Smart Materials DBA Settings.

The DBA settings needed for the Excel export and import are listed below.

General

EXCEL_DATE_FORMAT - Excel date format.

EXCEL_FUNCTION_IF - The IF keyword in the language of the local Excel installation.

EXCEL_FUNCTION_SUM - The SUM keyword in the language of the local Excel installation.

EXCEL_MAX_LINES - Maximum number of lines for Excel output.

IMPORT_FROM_FILE_DEST - Name of the directory on the application server where an uploaded Excel import file is stored.

LOG_FILE_DEST - Log file destination for online jobs. This setting must point to the directory on the Oracle server where log files are stored.

PRINT_TO_FILE_DEST - Name of the directory used by the Print to File functionality.

PRINT_TO_FILE_SEP - The separator character for CSV file generation (Export format='Excel’) in the language of the local Excel installation. Default value = ;

PRINT_TO_FILE_URL - The URL for accessing the created file via http.

WEBUTIL_DIR_AS - Standard download directory on the client for viewing files stored in the database. If no value is defined, the default directory C:\tmp applies. This directory must exist on all clients using any of the Excel export functionalities.

WEBUTIL_DIR_TS - Download directory on the client for viewing files stored in the database when a terminal server is used. If no value is defined, the default directory C:\tmp applies. This directory must exist on all clients using any of the Excel export functionalities.

Smart Reference Data

COMPANY_IDENT_DOWNLOAD_DEST - Destination directory for download of company ident files.

COMPANY_IDENT_DOWNLOAD_URL - Virtual directory for downloaded company ident files.

COMPANY_IDENT_UPLOAD_DEST - Destination directory for upload of company ident files.

BOM

BOM_EXCEL_MPV_EXPORT_TEMPLATE - Name of the multi position values export template.

BOM_EXCEL_SPV_EXPORT_TEMPLATE - Name of the single position values export template.

MSCM

OPI_IMPORT_PATH - Database server path for OPI import.

OPI_UPLOAD_DEST - Destination path on the application server where the imported files are stored.

Site

MTR_DOWNLOAD_URL - Virtual directory for a downloaded MTR file.

MTR_UPLOAD_DEST - Directory on the application server where an uploaded MTR Excel import file is stored.