The information is sent in Comma Separated Value (CSV) format, which allows the data
to be copied into any spreadsheet from where it can be viewed in a number of formats
(e.g. as a graph or a table) and from which reports can be generated.
The relevant data is appended to the email as separate attachments.
The modem needs to know where to send all emails in order for them to be forwarded to
individual email accounts. This is the outgoing SMTP mail server name (e.g.
smtp.yourmailserver.com). An account name and password may be necessary. The
recipient’s email address, subject (email title) and email reporting interval should be set
as required.
The Reply to address field is optional and is the address used to deliver failure
notifications in the event that an email cannot be delivered to the recipient’s email
address.
The following example demonstrates how to graph modem constellation data in a
spreadsheet:
• Configure the SMTP mail server and recipient email details.
• Select the Constellation data check box and click the Send email now button.
• Wait for the email to be received at the recipient’s account and open it.
• To import the constellation data into a spreadsheet program (Microsoft Excel is
used in this example) double click on the email attachment constellation.csv to
open it (this should automatically start the spreadsheet application - if not, then
save the attachment and open it directly from within the spreadsheed application).
• Within Excel, highlight the A and B columns.
• Select the Chart Wizard from the toolbar (or alternatively select the Insert menu
followed by Chart).
• Select XY (Scatter) as the chart type.
• Select the Scatter (topmost) sub-chart type.
• Select Next and then accept the defaults for Data Range and Series.
• Add a chart title and X and Y titles as desired.
• Select Finish and then resize the resulting graph as desired.
An example of the output is shown in Figure 6-13.
To Next Page
Loading...