AGG Software Forums

I set up Advanced Serial Data Logger on a laptop and was able to easily get data into log files. However, I need to take the data (example below) and export it into a single Excel file that I can then run analytics on. I see the system has the capability to parse data and then Export to Excel, but I just can't seem to figure out how to set it up right. The data below includes all of the variables that I have to deal with in the incoming data. The only delimiter that I see is variable amount of spaces.  I also attached a sample file in case that helps. In the end, I would like to have a single Excel file with column headings and each piece of data within a row split out (Date, Time, Room#, Alarm Type, Call Type). I would also be happy to extract an entire row of data and place it in a new row in Excel each time a new line comes in. Any help would be appreciated.

Sample data:
01/13/21  14:15:20    137.    PERS ATTN  CALL PLACED
01/13/21  14:16:03    137.    PERS ATTN  CALL CANCELLED
01/13/21  14:27:01    134.    PERS ATTN  CALL PLACED
01/13/21  14:28:11    134.    PERS ATTN  CALL CANCELLED
01/13/21  14:32:26    144     BATH       CALL PLACED
01/13/21  14:33:54    144     BATH       CALL CANCELLED
01/13/21  14:34:55    137.    PERS ATTN  CALL PLACED
01/13/21  14:35:34    137.    PERS ATTN  CALL CANCELLED
01/13/21  14:45:43    154.    PERS ATTN  CALL PLACED
01/13/21  14:46:19    154.    PERS ATTN  CALL CANCELLED
01/13/21  14:51:26    154     BATH       CALL PLACED
01/13/21  14:52:02    154     BATH       CALL CANCELLED
01/13/21  15:27:07    141.    PERS ATTN  CALL PLACED
01/13/21  15:31:58    141.    PERS ATTN  CALL CANCELLED
01/13/21  15:32:00    141     ALARM      CALL PLACED
01/13/21  15:32:07    141     ALARM      CALL CANCELLED
01/13/21  15:32:08    141     ALARM      CALL PLACED

Hello,

If you want to extract the entire row and send it to Excel, you do not need parsing using delimiters. You should only specify line ending characters.

Please, look here:
https://www.aggsoft.com/asdl-barcode-data-logger.htm

If you want to split data to separate columns, you may do the following:

Date, Time, Room - you may extract this data from a fixed position using the ASCII Data Parser plugin.
Alarm type - use the following regular expression in ASCII Data Parser

[\d\.]{3,}\ {2,}(.+?)\ {2}

Call type - use the following regular expression

\ {2,}(.+)$

Maybe, fields in your data are delimited by the TAB ASCII character. Then you may extract data using it.

Thanks for the reply. I followed the advice, but can't seem to get a clean output. I did find out what the delimiters look like for this data (please see attachment). The lines use a variable amount of spaces between the data elements and then a carriage return at the end. I would like to know what plugin would take this type of data and produce a clean CSV with each element in its own column (treating consecutive delimiters as one). I also need a little help understanding what settings to place in the plugin to get these results. If there is a simple way to remove the period that sometimes shows up after the room# that would be great as well.

I have spent around 5 hours playing with different plugins and settings and just can't seem to get it right. Any detailed help would be appreciated.

What device does output this data? We can prepare a custom parser module for it.

Also, I can connect to your computer remotely and help with setup.

Please, open a ticket at https://support.aggsoft.com/, and we'll schedule an appropriate time.

I sent in a ticket to Tech Support as requested. It has sample log files of the actual data along with a detailed description of the system and our needs. I would also really like to have you remote in as well to look at my settings.

Thanks so much for the great support.