[PLUG] Capture of CSV data

Chuck Hast wchast at gmail.com
Wed Jun 25 15:16:17 UTC 2014


I have a small stream on port 9040, it has 2 data fields,
DC, Status, EOData

Status is the only field that changes, I am going to see how I
can create a application that can be run on machines to just
monitor the basic status of the machine,
I.e. [Running] [Stopped] and if it is running, [Pass] [Reject]
I will have to see what all the status codes tell me but at this
point, I would be happy just having a screen with icons that
represent the machines in question, and flash for stopped
solid for running, green for pass and red for reject.

That way I can set up monitors and people can quickly see
what is going on, and if a machine is stopped, go and see
why.  Even do this one to put on smart phones and tablets
so that line monitoring becomes even easier.




On Wed, Jun 25, 2014 at 8:05 AM, Chuck Hast <wchast at gmail.com> wrote:

> What you are seeing there is each actual inspection, the status of the
> rotators,
> wall thickness (measures the thickness of the walls of each container)
> ovallity
> and many other parameters that the machine generates in the process of
> insp-
> ecting a container.
>
> As you can see it is in CSV like the original smaller one available on
> port 9030,
> that is why I am going to start with 9030, as I figure once I can work
> with that
> I can go into the more complicated data string from port 9010.
>
>
>
> On Wed, Jun 25, 2014 at 7:56 AM, Chuck Hast <wchast at gmail.com> wrote:
>
>> I think that the email is breaking it up as it is actually I believe all
>> one line.
>>
>>
>>
>> On Wed, Jun 25, 2014 at 7:35 AM, Larry Brigman <larry.brigman at gmail.com>
>> wrote:
>>
>>> These lines contain more data but more 0 data and span multiple lines per
>>> record.
>>> Date,time,....
>>> .....
>>> ......EOData
>>>
>>> Or that is the email parsing and all data is in one line.
>>>
>>>
>>> On Wed, Jun 25, 2014 at 6:16 AM, Chuck Hast <wchast at gmail.com> wrote:
>>>
>>> > Folks,
>>> > I tried both curl and netcat (nc) and both gave me good results, here
>>> are
>>> > some samples with just a simple command, I got a nice dump to the
>>> > screen as the data comes in from the machine:
>>> >
>>> > Using Curl
>>> > kp4djt at NetCracker:/$ curl 172.20.80.5:9030
>>> > Pth,ID,TRACK#,Mld,COUNT#,Path,InspRes1,InspRes2,Status,EOData
>>> > GET / HTTP/1.1
>>> > User-Agent: curl/7.35.0
>>> > Host: 172.20.80.5:9030
>>> > Accept: */*
>>> >
>>> >
>>> >
>>> 06/25/2014,06:07:32.375,Pas,34,000013,098,3538633,0x0041,0x00000000,0x00000000,0x00000c00,EOData
>>> >
>>> >
>>> 06/25/2014,06:07:32.781,Pas,34,000014,003,3538634,0x0041,0x00000000,0x00000000,0x00000200,EOData
>>> >
>>> >
>>> 06/25/2014,06:07:33.78,Pas,34,000015,021,3538635,0x0041,0x00000000,0x00000000,0x00000200,EOData
>>> >
>>> >
>>> 06/25/2014,06:07:33.468,Pas,34,000001,033,3538636,0x0041,0x00000000,0x00000000,0x00000200,EOData
>>> >
>>> >
>>> 06/25/2014,06:07:33.765,Pas,34,000002,026,3538637,0x0041,0x00000000,0x00000000,0x00000200,EOData
>>> >
>>> >
>>> 06/25/2014,06:07:34.171,Pas,34,000003,022,3538638,0x0041,0x00000000,0x00000000,0x00000200,EOData
>>> > ^C
>>> > kp4djt at NetCracker:/$
>>> >
>>> > Using nc
>>> >
>>> > kp4djt at NetCracker:/$ nc 172.20.80.5 9030
>>> > Pth,ID,TRACK#,Mld,COUNT#,Path,InspRes1,InspRes2,Status,EOData
>>> >
>>> >
>>> 06/25/2014,06:08:41.328,Pas,34,000014,173,3538814,0x0041,0x00000000,0x00000000,0x00000a00,EOData
>>> >
>>> >
>>> 06/25/2014,06:08:41.718,Pas,34,000015,023,3538815,0x0041,0x00000000,0x00000000,0x00000200,EOData
>>> >
>>> >
>>> 06/25/2014,06:08:42.125,Pas,34,000001,022,3538816,0x0041,0x00000000,0x00000000,0x00000200,EOData
>>> >
>>> >
>>> 06/25/2014,06:08:42.406,Pas,34,000002,071,3538817,0x0041,0x00000000,0x00000000,0x00000a00,EOData
>>> >
>>> >
>>> 06/25/2014,06:08:42.812,Pas,34,000003,036,3538818,0x0041,0x00000000,0x00000000,0x00000200,EOData
>>> >
>>> >
>>> 06/25/2014,06:08:43.203,Pas,34,000004,019,3538819,0x0041,0x00000000,0x00000000,0x00000200,EOData
>>> > ^C
>>> > kp4djt at NetCracker:/$
>>> >
>>> > Here are two captures of port 9010
>>> > Curl
>>> > kp4djt at NetCracker:/$ curl 172.20.80.5:9010
>>> > EMHART Glass   EOData
>>> > Per Bottle Data over TCP/IP (C) 1998-2001  EOData
>>> > rev: 3, 0, 0, 87   EOData
>>> >  EOData
>>> >
>>> >
>>> Date,Time,Path,Pass,Reject,unknown,SourceID,Track#,Mold#,Count,Path,Results1,Results2,Status,AddedDataSize,Tools:,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,MNR,Current,Hgt,Ring,Plug,Dip,Mold:,Number,Status,ReadErr,ListPath,Dip:,Avg,Setup,Rot:,Rot1,Rot2,Rot3,WT1:,WT1Min,WT1Max,WT1Rng,WT1Oval,WT1Stat,WT2:,WT2Min,WT2Max,WT2Rng,WT2Oval,WT2Stat,WT3:,WT3Min,WT3Max,WT3Rng,WT3Oval,WT3Stat,WT4:,WT4Min,WT4Max,WT4Rng,WT4Oval,WT4Stat,EOData
>>> > GET / HTTP/1.1
>>> > User-Agent: curl/7.35.0
>>> > Host: 172.20.80.5:9010
>>> > Accept: */*
>>> >
>>> > 06/25/2014,06:10:11.890,Pass,1,0,0,34,2,25,3539057,0x0041,0x0000
>>> > 0000,0x0000 0000,0x0000
>>> >
>>> >
>>> 0200,404,Tools:,14,16,0,0,14,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,92,0,0,0,521,0,Mold:,25,0x0000,13,0x080,Dip:,0,0,Rot:,0,749,749,WT1:,0000,0000,0000,0000,0000,WT2:,0000,0000,0000,0000,0000,WT3:,0000,0000,0000,0000,0000,WT4:,0000,0000,0000,0000,0000,EOData
>>> > 06/25/2014,06:10:12.296,Pass,1,0,0,34,3,26,3539058,0x0041,0x0000
>>> > 0000,0x0000 0000,0x0000
>>> >
>>> >
>>> 0200,404,Tools:,16,23,0,0,14,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,94,0,0,0,520,0,Mold:,26,0x0000,12,0x080,Dip:,0,0,Rot:,0,749,749,WT1:,0000,0000,0000,0000,0000,WT2:,0000,0000,0000,0000,0000,WT3:,0000,0000,0000,0000,0000,WT4:,0000,0000,0000,0000,0000,EOData
>>> > 06/25/2014,06:10:12.578,Pass,1,0,0,34,4,21,3539059,0x0041,0x0000
>>> > 0000,0x0000 0000,0x0000
>>> >
>>> >
>>> 0200,404,Tools:,14,26,0,0,14,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,83,0,0,0,521,0,Mold:,21,0x0000,12,0x080,Dip:,0,0,Rot:,0,749,749,WT1:,0000,0000,0000,0000,0000,WT2:,0000,0000,0000,0000,0000,WT3:,0000,0000,0000,0000,0000,WT4:,0000,0000,0000,0000,0000,EOData
>>> > ^C
>>> > kp4djt at NetCracker:/$
>>> >
>>> > nc:
>>> > kp4djt at NetCracker:/$ nc 172.20.80.5 9010
>>> > EMHART Glass   EOData
>>> > Per Bottle Data over TCP/IP (C) 1998-2001  EOData
>>> > rev: 3, 0, 0, 87   EOData
>>> >  EOData
>>> >
>>> >
>>> Date,Time,Path,Pass,Reject,unknown,SourceID,Track#,Mold#,Count,Path,Results1,Results2,Status,AddedDataSize,Tools:,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,MNR,Current,Hgt,Ring,Plug,Dip,Mold:,Number,Status,ReadErr,ListPath,Dip:,Avg,Setup,Rot:,Rot1,Rot2,Rot3,WT1:,WT1Min,WT1Max,WT1Rng,WT1Oval,WT1Stat,WT2:,WT2Min,WT2Max,WT2Rng,WT2Oval,WT2Stat,WT3:,WT3Min,WT3Max,WT3Rng,WT3Oval,WT3Stat,WT4:,WT4Min,WT4Max,WT4Rng,WT4Oval,WT4Stat,EOData
>>> > 06/25/2014,06:11:26.578,Pass,1,0,0,34,6,7,3539256,0x0041,0x0000
>>> 0000,0x0000
>>> > 0000,0x0000
>>> >
>>> >
>>> 0200,404,Tools:,14,22,0,0,13,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,98,0,0,0,522,0,Mold:,7,0x0000,12,0x080,Dip:,0,0,Rot:,0,750,749,WT1:,0000,0000,0000,0000,0000,WT2:,0000,0000,0000,0000,0000,WT3:,0000,0000,0000,0000,0000,WT4:,0000,0000,0000,0000,0000,EOData
>>> > 06/25/2014,06:11:26.984,Pass,1,0,0,34,7,25,3539257,0x0041,0x0000
>>> > 0000,0x0000 0000,0x0000
>>> >
>>> >
>>> 0200,404,Tools:,18,32,0,0,14,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,92,0,0,0,522,0,Mold:,25,0x0000,12,0x080,Dip:,0,0,Rot:,0,749,750,WT1:,0000,0000,0000,0000,0000,WT2:,0000,0000,0000,0000,0000,WT3:,0000,0000,0000,0000,0000,WT4:,0000,0000,0000,0000,0000,EOData
>>> > 06/25/2014,06:11:27.375,Pass,1,0,0,34,8,36,3539258,0x0041,0x0000
>>> > 0000,0x0000 0000,0x0000
>>> >
>>> >
>>> 0200,404,Tools:,14,21,0,0,14,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,91,0,0,0,523,0,Mold:,36,0x0000,12,0x080,Dip:,0,0,Rot:,0,747,747,WT1:,0000,0000,0000,0000,0000,WT2:,0000,0000,0000,0000,0000,WT3:,0000,0000,0000,0000,0000,WT4:,0000,0000,0000,0000,0000,EOData
>>> > 06/25/2014,06:11:27.671,Pass,1,0,0,34,9,71,3539259,0x0041,0x0000
>>> > 0000,0x0000 0000,0x0000
>>> >
>>> >
>>> 0a00,404,Tools:,14,20,0,0,13,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,56,0,0,0,522,0,Mold:,71,0x0000,12,0x080,Dip:,0,0,Rot:,0,748,748,WT1:,0000,0000,0000,0000,0000,WT2:,0000,0000,0000,0000,0000,WT3:,0000,0000,0000,0000,0000,WT4:,0000,0000,0000,0000,0000,EOData
>>> > ^C
>>> > kp4djt at NetCracker:/$
>>> >
>>> > It appears that nc is the much more flexible of the two, but both
>>> > very capable.
>>> >
>>> > The data from port 9010 is the full package of information, sensor by
>>> > sensor
>>> > _______________________________________________
>>> > PLUG mailing list
>>> > PLUG at lists.pdxlinux.org
>>> > http://lists.pdxlinux.org/mailman/listinfo/plug
>>> >
>>> _______________________________________________
>>> PLUG mailing list
>>> PLUG at lists.pdxlinux.org
>>> http://lists.pdxlinux.org/mailman/listinfo/plug
>>>
>>
>>
>>
>> --
>>
>> Chuck Hast  -- KP4DJT --
>> Glass, five thousand years of history and getting better.
>> The only container material that the USDA gives blanket approval on.
>>
>>
>>
>
>
> --
>
> Chuck Hast  -- KP4DJT --
> Glass, five thousand years of history and getting better.
> The only container material that the USDA gives blanket approval on.
>
>
>


-- 

Chuck Hast  -- KP4DJT --
Glass, five thousand years of history and getting better.
The only container material that the USDA gives blanket approval on.



More information about the PLUG mailing list