The Publication wizard lets you manually publish data to a stream and graphically construct publication formulas meant for automatic publishing.
| Components | Description |
|---|---|
| Connection Name | The name of the connection to use for publishing. Only active connections appear. When you click a connection, the streams the connection object is connected to appear in the Streams field, and the columns and the datatypes for the stream appear in the table named Columns. |
| Operation Code | If a record exists, select UPDATE, DELETE, or UPSERT (the default). Otherwise, select INSERT. |
| Data Range | Specify the range of cells in the Excel worksheet that contain
the data to publish. You cannot edit this field directly:
select the cells in the worksheet to publish, then click the
blue button next to this field to populate it. You cannot simultaneously publish multiple noncontiguous areas. |
| WorkBook Name | A read-only field that shows the workbook in which the selected range is located. |
| WorkSheet Name | A read-only field that shows the worksheet in which the selected range is located. |
| First Row Has Columns | Indicate that the first row in the selected range has column
names. If it does not, leave this field unselected. When you specify data columns, they can be in any order, and only values for the desired fields must be supplied. The rest of the columns are automatically filled with NULL. However, if you do not provide column names, the ESP Add-in for Microsoft Excel expects all the columns in the streams to be in the exact same order as defined in Event Stream Processor. |
| Transpose Rows To Columns | Select this option if the data columns for a record are provided vertically in a single column instead of the horizontally across multiple columns (the normal way of representing records). |
| Streams | Select the stream for which a publication should be made. |
| Columns | Shows the columns and the corresponding datatypes for the selected stream. You cannot select the columns in this table; however, you can copy the names of the columns and paste them in Excel. |
| Log File | (Optional) Specify the path and file name to which publication
errors are written, either by entering it directly into the
field, or by browsing to and selecting it. The errors written to this file in also appear in the Result field. Use a forward slash for both UNIX and Windows paths. |
| Result | Read-only results of the publication. |
| Publish Data | Publish the data to Event Stream Processor.
The result of the publication appears in the Result field. The Event Stream Processor acknowledges only whether the data has been received. To find out whether the record was rejected for some reason, such as a duplicate insert or bad data, either subscribe to the stream or submit a SQL query. |
| Show Formula | Graphically create the formula. This provides a convenient way to create a formula for automatic publishing. If there are no errors, the formula appears in the Results field. You can then copy the formula and place it in the Excel worksheet to start automatically publishing the data. |
| Clear Results | Clear the Result field if there are too many entries. |