On Tue, 24 Jun 2014, Chuck Hast wrote: > I want this to be the basis for all of the data capture from all of the > different types of machines, since they all use a similar format to output > data, I should be able to with small modifications re-use most of it from > machine to machine. Once I have that going then I will look at what I can > put the binary stream to use for, or if it is faster to process, perhaps > look at moving to it.
Chuck, This is where table normalization and relational integrity come to your aid. One table for 'machines' holds all attributes that distinguish one machine from the other. It's separate from the tables for 'bottles' or other discrete types of information you want to capture, store, and analyze. > I will obtain some screen shots of the present form in which the data is > presented, I will probably try to replicate those screens initially and > then take request and recommendations, and try to add them in or do > screens that add the high request items. You're going to use a different tool so the 'form' might very well look different. It was often difficult to convince folks moving from paper to digital that the data input form on the screen did not need to look just like the pieces of paper they used. In fact, usually the paper format was incompatible with database tables. > Does the list allow attachments or is it best just to put the images > in a public dropbox directory and give the URL to it? No. Yes. Do the latter. Rich _______________________________________________ PLUG mailing list [email protected] http://lists.pdxlinux.org/mailman/listinfo/plug
