Choose the delimiter and the format of the time stamp.
The following delimiters are available:
Fixed Column Width
If you are exporting multiple data files to a single text file, the first column will be the time stamp (time index) data if every data file had the same sample period. Otherwise, there will be one time stamp column for each data file (alternating).
If you are exporting multiple data files to multiple text files, you can save time by selecting Use Source With New Extension. This will choose the directory (folder) and filename of each text file automatically. The folder of the text file will be the same as the data file and the filename will be the same as the data file except a .TXT extension will be used in place of the Analyse-Plus extension (.CSD). If you wish to explicitly specify the path and filename for each text file, click Select New Path and Name.
There are three DDE functions in Analyse-Plus:
DDE Send (pictured above)
In DDE Send and DDE Receive, Analyse-Plus is a client and the other application is the server. In DDE Server, Analyse-Plus is the server and the other application is the client.
DDE Send is used to send data files to other applications such as ExcelTM. You need to know 3 items of information. In the case of ExcelTM, these are the name of the program ("Excel"), the name of the workbook or sheet and the row/column location where the data should go. If you are using ExcelTM, click the Topics button to get a list of open workbooks and sheets; then click on the sheet where the data should go. Then click Send to transmit the data ("one-shot").
You can also send file information (Tag, Description, Units, Data & Time collected, etc.) as well as the time stamp column. Just click the check-boxes.
Some Windows operating systems only allow transmission of chunks of text up to 64K in size. The "First Sample", "Last Sample" and "If Destinations Are Row or Column...64K Chunks" fields allow you to overcome this limitation.
Generally, you click the Activate button of any or all of the topics you wish to make available to the client. Then minimize the window. The Server will remain active until you click on the OK or Cancel buttons. The client must be configured or programmed to inquire with the proper keywords.
The System Topic provides a list of available Topics plus all of the filenames in the Quick List.
The Specific File Topic transmits a data file. The filename can be specified by the user by clicking the Modify button. A client can also poke the Specific File Topic to specify the filename. By using the filenames provided in the System Topic, and poking the Specific File Topic, a client could read all of the data files in the Quick List.
The Collection Status Topic provides detailed information about the progress of the current data collection (with the DataLogger CVF2, if purchased). Once the client determines that the collection has ended, it can use the System Topic to check what new filenames have been created, and the Specific File Topic to read the new files containing sampled data.
Analyse-Plus can import almost any type of Text file. When you select the text file, it will determine the delimiters used between columns (comma, spaces, etc.) and the type of time data. The text file may have no time stamp column, may have one time stamp column that specifies the sample period for all columns of sampled data, or it may have one time stamp column for each column of sampled data (alternating). The time stamp data is only used for determining the sample period. You can override the calculated sample period or manually specify the delimiters.
The columns of data do not have to be the same length.
In the last step of importing, you specify the desired filenames only for columns you wish to import.
DDE Receive can receive data in a single transmission ("one-shot") or repeatedly (like sampling). The data you specify is received when you click the Start Receive button and whenever the sending application indicates that the data is new (typically when it changes). When transferring data from a spreadsheet, typically the entire data set would be transferred at once. In this case, you would click End Receive as soon as the First Sample and Last Sample fields change (indicating that the transmission has been received). When sampling from an industrial computer (typically over a network), the transmitting computer would typically send one or a few samples at a time at an interval determined by it. The transmitting computer would automatically inform Analyse-Plus when the data is new.
If you wish to have the data sent at an interval independent of the update time of the data, click on This Source and enter a different item. This would typically be a sampling trigger, a counter or a clock.
When all the desired data has been received, click End Receive. The file will be saved to the filename you specified under Filename to Save.