Data Send Dialog Box

Product and Definition

You must specify a product to post your Microsoft® Office Excel data to, and a data send definition to control how your data is posted.

You can specify the data send definition by clicking the Definition browse button and selecting a definition.

Field Mapping

You use the field mapping section to map fields from your worksheet, to the product database. Field mapping depends on the type of definition you are using:

  • Basic Definition: Map fields from the product database to the appropriate field in your source Excel worksheet. Map the Driver Code field to the mandatory Key field in the product database.
  • Layout Definition: You must specify a cell reference to identify the Layout Identifier in the source Excel worksheet. Map any other fields from the product database to your worksheet. Map the Layout Identifier to the mandatory Key field in the product database.
  • Matrix Definition: Map the Matrix Replicator Indicator to a range of values in your source Excel worksheet. Map any other fields from the product database to your worksheet. Map the Driver Code field to the mandatory Key field in the product database.

Other options:

  • Error Cell: Specify a cell in your worksheet to display any errors.
  • Comment Cell: Specify a cell in your worksheet to display any comments.
  • Matrix Send: Select Matrix Send to indicate that the type of data send is a matrix.
  • Skip Blanks: Select Skip Blanks to ignore blank cells in the driver code, or the layout identifier column. Otherwise, the data send will stop if a blank cell exists in the driver code or layout identifier.

Options Tab

The Options tab provides options for saving the data send definition, and actions for the data send process:

  • Transaction File: Convert your Data Send definition into XML format, and save as a Transaction file. Transaction files can be imported into products that DataLink Server is unable to post to directly.
  • Save As: Save your Data Send definition as an Internal, or External definition. External definition files are saved with a .lsd extension.
  • Abort if error exists: Prevent erroneous data from being posted.
  • Show Message: After the Data Send has successfully completed, show a confirmation message.
  • Send to SunSystems: Post the data from your worksheet to SunSystems.
Parent topic: Data Send