[PLUG] Capture of CSV data

Larry Brigman larry.brigman at gmail.com
Wed Jun 25 14:35:57 UTC 2014


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
>



More information about the PLUG mailing list