Description
The BeforeInsert event is executed before a record is inserted during import. Use this event to modify the import data before it is saved in the database.
Syntax
public XVar BeforeInsert(dynamic rawvalues, dynamic values, dynamic pageObject, dynamic message)
Arguments
rawvalues
raw field values from the imported file.
values
an array of values to be written to the database. To access a specific field value, use values["FieldName"].
Note: Field names are case-sensitive. If the field name is PlayerId, you should use values["PlayerId"]. Note that values["playerid"] or values["PlayerID"] will not work.
Note: If the field was assigned an alias in the SQL query, then the values array will get the alias instead of the field name from the database.
E.g., if you have an SQL query SELECT salesrep_id AS Inv_Salesrep ..., you should use values["Inv_Salesrep"].
pageObject
an object representing the current page. For more information, see RunnerPage class.
dynamic message
this message will be added to the Import Log if the record wasn't imported
Return value
True - the record is inserted.
False - the record is not inserted.
Applies to pages
Recommended predefined actions and sample events:
•Insert a record into another table
•Check to see if a specific record exists
•Display a message on the Web page
See also:
•AJAX helper object: setMessage ()
