Maybe this is too much overhead, but IMO an easy way (because I'm a drupal guy probably) would be to install drupal, then the Feeds module, then pull the CSV into drupal. It'll put it in the database, and you can pull it out, or say use the Charts module to display it in pretty charts, or find any of the other myriad of drupal modules to massage your data how you like it.
https://www.drupal.org/ https://www.drupal.org/project/feeds https://www.drupal.org/project/charts On Tue, Jun 24, 2014 at 9:32 AM, Rich Shepard <[email protected]> wrote: > On Tue, 24 Jun 2014, Chuck Hast wrote: > > > The machine differentiation between same type machines is based on the > > communications connection (IP address) so I assume that I would have a > set > > of descriptions for each machine, and the IP address is mapped to that > > description. So when they view a given machine (IP address), the machine > > info should be presented as part of the page. That will include the job > > being run at that time. Each IS machine makes bottles for two inspection > > lines, there are 3 types of inspection machines on each line. A Side Wall > > Inspector, Base and Finish (sealing surface) inspector and a Rotational > > Inspector steps the bottles through 5 stations 3 of which rotate the > > bottle to do various inspections. (this is my favourite machine). The > data > > stream I sampled to the list is from a Rotational Inspector. But the data > > from all of the machines is in the same format, and the other machines in > > the plant generate data in about the same format also. > > Chuck, > > First step: list each nugget of information that is available. From what > you wrote above, I'd start the list with IP address, machine type, machine > location, job number, job type, inspection line, inspection type, station > number, station role, date, time. > > > But later on I came out when we fielded the system and I got to see the > > Portland area in the day. > > Make the opportunity to drive through central and eastern Oregon, too. > Go > to Burns, then take 205 south to French Glen and continue south to Fields > and Denio, NV. Just watch for cattle on the road! The dummies stand there > and look at you while you honk the horn at them. Calves are particularly > stupid. If you catch it right, you'll see proghorn running across the road, > especially if you take OR 78 east from Burns across the Blue Mountains. > IMHO > it's really worth driving through fly-over country. > > Rich > > _______________________________________________ > PLUG mailing list > [email protected] > http://lists.pdxlinux.org/mailman/listinfo/plug > _______________________________________________ PLUG mailing list [email protected] http://lists.pdxlinux.org/mailman/listinfo/plug
