Trends

Q: How do I get trend data into a dBASE database?

A: Display the trend on screen and select the File Save/As tool. This tool displays a Save/As dialog box for you to enter the name of the file, and calls the TrnExportDBF function to save the data. (For more complex procedures, call this function directly.)

Q: How do I get trend data into Excel?

A: You can get data into Excel in three ways:

• Display the trend on the screen, select the Clipboard tool to copy the data, and use the Excel paste command to paste the data into Excel.
• Display the trend on the screen and select the File Save/As tool. Save the data in CSV format, and open the CSV file in Excel.
• Display the trend on the screen and select the File Save/As tool. Save the data in DBF format and open the DBF file in Excel.

(For other procedures, call the TrnExportCSV or TrnExportDBF function.)

Q: How do I get trend data into MS Access?

A: You can get data into Access in three ways:

• Display the trend on the screen, select the Clipboard tool to copy the data, and use the Access Paste command to paste the data into Access.
• Display the trend on the screen and select the File Save/As tool. Save the data in CSV format, and open the CSV file in Access.
• Display the trend on the screen and select the File Save/As tool. Save the data in DBF format and open the DBF file in Access.

(For other procedures, call the TrnExportCSV or TrnExportDBF function.)

Q: How do I update trend data?

A: Use the TrnSetTable function to write data back to the trend system.

Q: How do I archive trend data?

A: Use the trend archive Cicode functions from the Examples database. Use the Find Function command to search for the TrendArchive() function.

Q: How do I restore archived trend data to the system?

A: Use the trend archive Cicode functions from the "Examples" database. Use the Find Function command to search for the TrendArchive() function.

Q: How do I get trend data into a report?

A: Use the TrnGetTable function.