News:

Welcome on our forum!

Main Menu
Menu

Show posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Show posts Menu

Messages - asenna32

#1
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.
#2
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.
#3
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