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.