AGG Software Forums

Simply reading a text file composed of approx. 10-15 lines received once per minute.  Everything works fine, but if the text file consists of 15 lines, then the program creates 15 csv files.  How do I create a single file for all 15 lines and then create another file (different name) when sent again in a minute, and so on.  Thank you for your reply.

How do you create the CSV file? Is it the Advanced Serial Port Monitor software?

We have the Advanced TCP/IP Data Logger, Professional Ed.

The CSV was created as a log file (Options, Configuration Options, Log File, Create Log File on Disk, file name prefix/extension = csv).  Something tells me that's not the correct method...  Here's what I have and what I need to do:

I have data coming across IP sucessfully to the TCP/IP Data Logger.  Here is a sample:
 
<-CALGAS,1,2010-07-21,17:19.19.000,1,.0 ,192
<-BAROM1,1,2010-07-21,17:19.19.000,1,30.0218 ,192
<-CTIM  ,1,2010-07-21,17:19.19.000,1,93.2073 ,192
<-WATTS1,1,2010-07-21,17:19.19.000,1,2.03906 ,192
<-GWATTS,1,2010-07-21,17:19.19.000,1,.0 ,192
<-SSWATT,1,2010-07-21,17:19.19.000,1,204.3 ,192
<-AMPS2 ,1,2010-07-21,17:19.19.000,1,7.45312 ,192
<-GVARS ,1,2010-07-21,17:19.19.000,1,.040781 ,192
<-WATTS2,1,2010-07-21,17:19.19.000,1,.27 ,192
<-DBULB ,1,2010-07-21,17:19.19.000,1,74.6492 ,192
<-WBULB ,1,2010-07-21,17:19.19.000,1,.0 ,192
<-SSVARS,1,2010-07-21,17:19.19.000,1,172.8 ,192
<-VARS1 ,1,2010-07-21,17:19.19.000,1,4.5 ,192
 
This batch (about 10-15 lines), changes and is resent from the source every 1 minute.  I need to save each batch into a directory as a single, unique CSV file.  Therefore, each 10-15 line send should result in a single CSV file (uniquely identified by a timestamp).  A following set of output lines, a minute later, would need to also be saved to a single CSV file (without overwritting the previous file), and so on.... forever.   I have another program that will poll the CSV file and delete once the data is analyzed.
 
Currently, if I send output to a CSV file, I get one file for each line of data (15 lines = 15 files).  How do I get all lines, sent in a batch, in a single CSV?
 
Also, how to I set up the log to name each file uniquely by timestamp?  E.g. filenameHHMMSS, filenameHHMMSS (where filename represents the same name ("TIGER") and the HHMMSS represents an added timestamp to the filename in hours, minutes, and seconds?

1. You should activate the "After data timeout" log file creation mode and specif your timeout.
2. You may add a timestamp to your file name if you'll specify prefix like: log{HH}{NN}{SS}.

It seems like creating a csv file with all the 15 lines of log is not possible as I have look all around in the software and I did not find anything as such. In fact, I believe that there is a solution just that I have missed out the options to do so. I personally have not try this yet as I have not come across a need to do so. Will update you if I find anything useful.