TSImport Function

Normally, a worksheet function performs some calculation and returns some type of result. This worksheet function on the other hand does not return a result. When it is evaluated by Excel, it results in the placement of information into an output buffer that is used for the creation of an import file for a Sage 300 CRE application. The best way to think of this function is as an "instruction" to the software. As such, columns or rows in your worksheet that contain these functions will commonly be hidden.


TSImport( file_format , parent_row , record_type , row_key , values (1,,n) )

The TSImport function syntax has these parts:

File FormatThis is a text value that must equate to a valid file format name. The available file formats can be viewed by clicking the Show Control Panel toolbar button and then selecting the File Formats button on the left. Each file format represents a different type of import file that a specific Sage 300 Construction and Real Estate application can import.
Parent RowIf the File Format requires that the Record Type must be a child of another Record Type, this argument must contain a cell reference to the TSImport function representing the parent record. If no parent is required, an empty text value can be passed for this argument.
Record TypeThis argument identifies the type of record being written to. The valid values for this argument are defined within the File Format that is specified. To write data for a custom view, append an underscore followed by the name of the custom view in upper case. For example, Time_ADMIN indicates to use the custom view named "ADMIN" with the record type "Time".
Row KeyThis argument must provide a unique identifier for the row being written to. For transaction import files, this may simply be a row number. For other import files that create records in a master file, this may be a unique ID that is used to identify the record once it has been imported.
ValuesThis argument is an array of one or more column-value pairs. Therefore the number of arguments specified for values must be an even number. In each pair, the first argument must be a valid column name for the specified Record Type. The second argument in a pair contains the data value being written to the column.


Click here for examples.