Modify Config

In this topic: Hide

 

The Modify Config dialog contains the properties available for the Config.

Label

Enter a new label for the Config.

Enable

Each time data is processed by a translator, all enabled Configs are checked to see if the data fits the set requirements. If a Config is disabled, it will remain in the tree, but will not be checked when data is processed. Disabled Configs appear as highlighted red with white text.

Description

An optional description of the Config may be entered in the Description field.

Extensions

The Extensions field may be used to exclude any unwanted file types automatically when loading data files into a Config. To indicate specific file extensions you want to allow, enter just the extension into the field (no periods), separated by a comma or semicolon. The file extensions 4datasmith, 4jr, 4jx, and [~4j_tmp~]_ are always ignored when adding files to a Config.

For the settings shown in the image above, the file types that would be included would be *.csv, *.txt, and *.db files.

Preprocess

Preprocessing is any processing DataSmith does on a data file without putting the data in the database. Preprocessing can be done on your data files by selecting options within the Modify Config dialog.

Temporary Data Files

When DataSmith does any type of preprocessing, a temporary file will be created. The string [~4j_tmp~]_ will be added as a prefix of the file name, and the extension will be changed to *.[~4j_tmp~]_(original file type extension).

External

The External option for Preprocessing allows you to write a user-defined script to pre-process data files that otherwise cannot be read by DataSmith.

The script must be able to accept two command line parameters. The first parameter will be the name of input file (with complete path). The second parameter will be the name of the output file (with complete path). The script will be required to open the input file, read the contents, perform the desired processing, and write to the output file. The script will need to create the output file.

IGES

When IGES is selected, DataSmith will prepare the IGES data file so that it can be processed.

Tarus

When Tarus is selected, DataSmith will prepare the Tarus data file so that it can be processed.

CSV

When CSV is selected, DataSmith will prepare the CSV data file so that it can be processed.

Insert Header

Insert Header is an internal Preprocessing method in which DataSmith will insert information about the file into the beginning of the file. After the Insert Header box is checked, the DataSmith document needs to be saved, then closed and reopened to view the header information. Below is an example of the information that is inserted at the beginning of a data file when the Insert Header check box is selected.

The drive, directory, title, file extension, filename and path are provided. Then, the creation date of the file is provided in abbreviated and complete formats. Two different time stamp formats are provided. The week number labeled Week1 starts on a Sunday, and Week2 starts on a Monday. The current date is provided in abbreviated and complete formats. To remove the header information from the beginning of the data file, clear the check box next to Insert Header, then save, close, and reopen the data file.

Excel

Excel is an internal Preprocessing method used by DataSmith to read Microsoft Excel documents (*.xls or .xlsx).

·        The Excel preprocessing is upwards compatible from Excel 2000.

·        The version of Excel that is installed on the workstation running DataSmith must support .xlsx files in order for DataSmith to read them.

·        Make sure that the file is not already open in Excel when DataSmith is trying to read the file.

Worksheet Handling in Excel

If there is more than one worksheet within an Excel workbook, all of the worksheets will be processed (starting with the first worksheet, not the sheet that is open when saved) as a single file in DataSmith.

Rich Text

Rich Text is an internal Preprocessing method used by DataSmith to read Rich Text Format (*.rtf) files.

Use International Numbers (Comma as Delimiter)

When Use International Numbers is selected, commas will be used as delimiters instead of decimals.

High Volume Data Processing

High Volume Data Processing can be used to put data in your database quicker. High Volume Data Processing is a considerably faster way to manage data in the database. It is faster because it restricts the way the data goes into the database, making it more compact.

Archive Restore

The Archive Restore option is enabled when data that has been archived using Data Archiver is read back into the Database. The Archive Restore option in the Config Properties will stamp all of the data that is being put back into the Database with the "Restore" flag.

Locate Feature by XYZ

If a feature does not have a feature label defined, DataSmith can use the Locate Feature By option to match features by either the XYZ Nominal or Actual values.

The numerical field used with the Locate Feature option defines how close a value must be to be considered a match. The numeric value is a proximity distance in the units of the data being processed. Locate Feature by XYZ may be used to locate Reference Features.

In order for the Locate Feature By options to work, the feature must:

·        exist in the database (features cannot be added to a database using this method)

·        not have a feature label defined

·        have nominal or actual XYZ values assigned to the feature

↑ Top