8.0 Inventory/Journal files setup

<body topmargin=0 leftmargin=0 marginheight=0 marginwidth=0> <table cellpadding=0 cellspacing=0 border=0><tr> <td valign="top" colspan=2 height=100 BGCOLOR="#CCCCFF" TEXT="#080000" bgproperties="fixed" background="1a500640egdysm.jpg"> <div> <FONT SIZE="5" COLOR="#000066" FACE="Arial" ><B>Eyeglasses Inventory Program  </B></FONT><FONT SIZE="1" COLOR="#000099" FACE="Arial" ><B>(Version 5.0-5   8/31/2003)</B></FONT><B> </B><FONT SIZE="2" COLOR="#000099" FACE="Arial" ><B> </B><B><U>8.0 INVENTORY/JOURNAL FILE SETUP</U></B></FONT> </div> <div> <A HREF="index.htm" TARGET="_top" TITLE="1.0 Eyeglasses Inventory Program"><U><B>1.0 Eyeglasses Inventory Program</B></U></A><B>      </B><A HREF="id11.htm" TARGET="_top" TITLE="2.0 Getting Started"><U><B>2.0 Getting Started</B></U></A><B>     </B><A HREF="id2.htm" TARGET="_top" TITLE="3.0 Basic Functions"><U><B>3.0 Basic Functions</B></U></A><B>               </B><A HREF="id5.htm" TARGET="_top" TITLE="4.0 Reading Glass Inventory"><U><B>4.0 Reading Glass Inventory</B></U></A></div> <div> <A HREF="id6.htm" TARGET="_top" TITLE="5.0 Lens/Frames Inventory"><U><B>5.0 Lens/Frames Inventory</B></U></A><B>                    </B><A HREF="id8.htm" TARGET="_top" TITLE="6.0 Option Settings"><U><B>6.0 Option Settings</B></U></A><B>     </B><A HREF="id3.htm" TARGET="_top" TITLE="7.0 Useful Charts Files"><U><B>7.0 Useful Charts & Files</B></U></A><B>      </B><A HREF="id7.htm" TARGET="_top" TITLE="8.0 Inventory/Journal files setup"><U><B>8.0 Inventory/Journal files setup</B></U></A><B> </B></div> <div> <A HREF="id10.htm" TARGET="_top" TITLE="9.0 Useful Things"><U><B>9.0 Useful Things</B></U></A><B>  </B><A HREF="id9.htm" TARGET="_top" TITLE="10.0 Startup Window"><U><B>10.0 Startup Window</B></U></A><B>  </B><FONT SIZE="2" COLOR="#000099" FACE="Arial" ><B> </B><A HREF="id18_how_to_acquire_this_program.htm" TARGET="_top" TITLE="Purchase Products"><U><B>HOW TO ACQUIRE THESE PROGRAMS</B></U></A></FONT><B>  </B><B>Documentation V4.1 Rev: 9/8/2003</B></div> </td> </tr><tr> <td valign="top" width=5 BGCOLOR="#0000BF" TEXT="#F7F7FF"> <bR> <bR> <bR> </td> <td valign="top" height=380 BGCOLOR="#FFFFFF" TEXT="#080000"> <div> <I>8.0 Inventory/Journal files setup</I></div> <div>       Located on the root of the C drive are two files:  1) Total_Inventory.txt and 2) JournalFile.txt.  These files record the total currently available inventory.  A third file "Diagnostic File" is also available.  These three files are documented below.</div> <div>      When the program is first asked to show inventory, it loads the inventory from these two files.  First it loads all the settings in the "Total_Inventory.txt" file and then later it modifies those settings with the contents of the "JournalFile.txt" file.  Typically at the beginning of a clinic the entire inventory of the program is recorded in the "Total_Inventory.txt" file while the Journal file has only a single record as shown below.  As glasses are used, this inventory reduction is recorded in the Journal file.  This means that the P.C. can be shut down and restarted later automatically returning to the last inventory level.</div> <bR> <div> <B>'_JournalFileOrder___GlassesNumber_(comma)_Used_(True/False)_Flag_(comma)_PersonNumber_(0_if_none)</B></div> <bR> <div> This single record can be anything but cannot have any spaces or commas.</div> <bR> <DIV ALIGN="LEFT"></DIV> <div> <B><U>Total Inventory File</U></B></div> <div> Each prescription inventory record in the "Total_Inventory.txt" file is formatted as shown in the below example:</div> <bR> <div> 25,-5.00,-.00,00,,-5.75,-.00,00,,0,0,0,0,0,M,0,Com,10/6/2001,9:54:41 AM</div> <div> Nr, Ls, Lc, Lx, La, Rs, Rc, Rx, Ra, Sg, Re, Sc, Pr, Bf, Sz, RGn, Cm, Dt, Tm</div> <div> Where:</div> <div>    Nr = Eyeglasses inventory number from 1 to 10,000 (maximum),</div> <div>    Ls = Left Spherical power in Dioplers,</div> <div>    Lc = Left Cylindrical power in Dioplers,</div> <div>    Lx = Left Axis in Degrees,</div> <div>    La = Left Add power in Dioplers,</div> <div>    Rs = Right Spherical power in Dioplers,</div> <div>    Rc = Right Cylindrical power in Dioplers,</div> <div>    Rx = Right Axis in Degrees,</div> <div>    Ra = Right Add power in Dioplers,</div> <div>  The following 1/0 = Yes/No flags:</div> <div>    Sg = Yes/No Sunglasses,</div> <div>    Re = Yes/No Reading glasses,</div> <div>    Sc = Yes/No lens are scratched,</div> <div>    Pr  = Yes/No progressive lens,</div> <div>    Bf  = Yes/No bifocal lens,</div> <div>    Sz = S for small, M for Medium, and L for large,   (For some lensmeters, this shows as a number for PD in mm)</div> <div>    R=  Number of rejects for this pair of glasses. This number is combined with Gn below.</div> <div>    Gn = Gender.  0= Either Male or Female, 1=Female, 2=Male, 3=Child.</div> <div>    Cm = Comment on the glasses,</div> <div>    Dt =  Date glasses were measured,</div> <div>    Tm = Time glasses were measured.</div> <bR> <div> <B>VERY IMPORTANT:</B></div> <div> The author of this program uses a Reichert LenChek Lensometer to read the prescriptions of the eyeglasses.  It has been interfaced to a computer to capture each reading and automatically place it into the "Total_Inventory.txt" file in the exact format required above.  Using the "Glasses Reader" program (described at this link:<A HREF="id12.htm" TARGET="_top" TITLE="Reader Program"><U>Reader Program</U></A>) you can do the following list of basic functions:</div> <div>     1.  Transfer readings from 6 different lensmeters to file and/or bar code printers.  (Tomey TL-900, Humphrey LA360, Humphrey LA340, Nikon NL-2 and also the Topcon CL-100.)</div> <div>     2.  Manually enter data into the system using a specially designed keyboard.</div> <div>     3.  Wand in data from bar coded labels previously created by this program.</div> <div> If anybody reading this should purchase any of these particular units, I will gladly provide the program to go with it for a $50 donation to my ministry fund.  If you are making your reading with a manual Lensometer, then I suggest that you either use the manual function of the above program or construct the file into a multicolumn spreadsheet in Microsoft Excel formatted as follows:</div> <div> <IMG SRC="13f35bf0.jpg" border=0 width="1077" height="191" ALIGN="BOTTOM" HSPACE="0" VSPACE="0"></div> <bR> <div> The spreadsheet can then be saved as a ".CSV" file (comma delimited) and then renamed to "Total_Inventory.txt" for use by the program.  The first title line must be removed for proper operation of the program.</div> <bR> <div> <B>Manual additions to Total Inventory file:</B></div> <div> Instead of beginning with an entry number if a record begins with one of these possibilities, it can indicate other types of inventory information:</div> <bR> <div> <B>     "Reading"</B> </div> <div> A reading record is formatted as follows:</div> <div>   Reading,1.25,50</div> <div> <B>     </B><FONT SIZE="4" COLOR="#000000" FACE="Arial" >Reading,Sp,Cn</FONT></div> <div> Where the first field is always "Reading", the "Sp" is the Spherical power of the glasses and "Cn" is tne number of glasses.   In this example record it shows that there are 50 reading glasses with a spherical power of +1.25.</div> <bR> <div> <B>   "Lens"</B></div> <div> A lens record is formatted as follows:</div> <div>    <FONT SIZE="3" COLOR="#000000" FACE="Courier New" >Lens,5.25,-3,4</FONT></div> <div>    Lens, Sp, Cy, Cn</div> <div> Where the first field is always "Lens", the "Sp" is the Spherical power of the lens, "Cy" is the cylinder power of the lens (=0 if this lens is not for Astigmatism correction) and "Cn" is the number of round lens of this power.</div> <bR> <div> <B>   "LensChild"</B></div> <div> A lens record is formatted as follows:</div> <div>      LensChild,5.00,0,2</div> <div>    LensChild, Sp, Cy, Cn</div> <div> Where the first field is always "LensChild", the "Sp" is the Spherical power of the lens, "Cy" is the cylinder power of the lens (=0 if this lens is not for Astigmatism correction) and "Cn" is the number of round lens of this power.</div> <bR> <div> <B>   "Frames"</B></div> <div> A frames record is formatted as follows:</div> <div>   Frames,70,25</div> <div> <FONT SIZE="2" COLOR="#000000" FACE="Arial" >   </FONT><B> </B><B>Frames, Sz,Cn</B></div> <div> Where the first field is always "Frames", the "Sz" is the size of the lens with value values only of 65,67, and 70 and "Cn" is the number of this size of frames.</div> <bR> <div> <B>   "FramesChild"</B></div> <div> A frames record is formatted as follows:</div> <div>   FramesChild,65,14</div> <div> <B>   </B><B>FramesChild, Sz,Cn</B></div> <div> Where the first field is always "FramesChild", the "Sz" is the size of the lens with value values only of 57,61, and 65 and "Cn" is the number of this size of frames.</div> <bR> <DIV ALIGN="LEFT"></DIV> <div> <B><U>The Journal File</U></B></div> <div> As mentioned above the Journal file always begins with a record formated as below without any spaces or commas.</div> <div> <B>               '_JournalFileOrder___GlassesNumber_(comma)_Used_(True/False)_Flag_(comma)_PersonNumber_(0_if_none)</B></div> <div> It is then followed with other record types to record the use of inventory and to also provide a record of the various prescriptions encountered.  Here is an example of the different types of records:</div> <div> 450,True,1,-1.50,0.00,000,0.00,(-1.50),-0.50,0.00,000,0.00,(-0.50)</div> <div> Nr, Flag, Pn, Lsr, Lcr, Lar, Lrp, Lse, Rsr, Rcr, Rar, Rrp, Rse</div> <div> Where:</div> <div>    <B>Nr</B> = Inventory number used,</div> <div>  <B>  Flag</B> = "True" to remove from inventory and "False" to put back in inventory.  </div> <div>              If this flag is a number then it indicates the number of rejects which have occurred for this pair of glasses.</div> <div>   <B> Pn</B> = Person number using glasses,</div> <div>    <B>Lsr</B> = Left Sphere reading,</div> <div>    <B>Lcr</B> = Left Cylinder reading,</div> <div>    <B>Lar</B> = Left Axis reading,</div> <div>  <B>  Lrp</B> = Left Reading Power,  (=Left Sphere + Left Add)</div> <div>    <B>Lse</B> = Left Spherical equivalent,</div> <div>   <B> Rsr</B> = Right Sphere reading,</div> <div>   <B> Rcr</B> = Right Cylinder reading,</div> <div>    <B>Rar</B> = Right Axis reading,</div> <div>    <B>Rrp</B> = Right reading power, <FONT SIZE="3" COLOR="#000000" FACE="Arial" > </FONT>(=Right Sphere + Right Add)<FONT SIZE="3" COLOR="#000000" FACE="Arial" > </FONT>and</div> <div>   <B> Rse</B> = Right Spherical equivalent.</div> <div>   </div> <div> Reading,1.00,049</div> <div> Reading, Power, Count</div> <div> Where:</div> <div>    Reading = Indicator that record is talking about reading glasses,</div> <div>    Power = Power of the reading glass,</div> <div>    Count = Last known total count of this particular power.</div> <div> This record is written in response to a change in a reading glass count.</div> <bR> <div> Lens,5.75,0.00,011</div> <div> Lens, Sphere, Cylinder, Count</div> <div> Where:</div> <div>    Lens = Indicator that record is talking about a count of 46mm snap-in lens,</div> <div>    Sphere = Spherical power of the lens being counted,</div> <div>    Cylinder = Cylinder powr of the lens being counted,</div> <div>    Count = Last known count of this particular power of lens.</div> <div> This record is written in response to a change in a round lens count.</div> <bR> <div> LensChild,5.75,0.00,011</div> <div> LensChild, Sphere, Cylinder, Count</div> <div> Where:</div> <div>    Lens = Indicator that record is talking about a count of 42mm snap-in lens,</div> <div>    Sphere = Spherical power of the lens being counted,</div> <div>    Cylinder = Cylinder powr of the lens being counted,</div> <div>    Count = Last known count of this particular power of lens.</div> <div> This record is written in response to a change in a round lens count.</div> <bR> <div> Frames,65,024</div> <div> Frames, Size, Count</div> <div> Where:</div> <div>     Frames = Indicator that this record is talking about round frame count,  Lens size is 46mm.</div> <div>    Size = Size of frame with values of 65, 67 and 70,</div> <div>    Count = Last know count of this particular frame size.</div> <div> This record is written in response to a change in a round frames count.</div> <bR> <div> Frames,61,020</div> <div> FramesChild, Size, Count</div> <div> Where:</div> <div>     Frames = Indicator that this record is talking about round frame count, Lens size is 42mm.</div> <div>    Size = Size of frame with values of 57, 61 and 65,</div> <div>    Count = Last know count of this particular frame size.</div> <div> This record is written in response to a change in a round frames count.</div> <bR> <div> Measurement,3,-1,14,2.00,2.50,4.00,-1.25,60,2.00,3.38</div> <div> Measurement, Lsr, Lcr, Lar, Lrp, Lse, Rsr, Rcr, Rar, Rrp, Rse</div> <div> Where:</div> <div>    Measurement = Indicator that this record is a measurement of a person,</div> <div>    Lsr = Left Sphere reading,</div> <div>    Lcr = Left Cylinder reading,</div> <div>    Lar = Left Axis reading,</div> <div>    Lrp = Left Reading Power,  (=Left Sphere + Left Add)</div> <div>    Lse = Left Spherical equivalent,</div> <div>    Rsr = Right Sphere reading,</div> <div>    Rcr = Right Cylinder reading,</div> <div>    Rar = Right Axis reading,</div> <div>    Rrp = Right reading power,  (=Right Sphere + Right Add) and</div> <div>    Rse = Right Spherical equivalent.</div> <div> This record is written as the result of clicking the "<B>Prescription Save</B>" button on the calculator window.</div> <bR> <DIV ALIGN="LEFT"></DIV> <div> <B><U>The Diagnostics File</U></B></div> <bR> <div> <B><U><IMG SRC="07b4ee20.gif" border=0 width="590" height="226" ALT="Bitmap Image" ALIGN="BOTTOM" HSPACE="0" VSPACE="0"></U></B></div> <div> Lens Search under Diagnostics Option</div> <div> Figure 1</div> <div> If under "<B>Search Options</B>" one selects "<B>Set Program Diagnostic Mode</B>" and then initiates the search as shown in Figures 1.  The diagnostics file written will look like the below.  The first line indicates the prescription of the patient.  The second and third lines indicate the Program Options parameters.  The fourth line indicates the match flags.  Subsequent lines show the choices which have been made.  This feature will be used if there is reason to believe that the program is malfunctioning.</div> <bR> <div> <B>Prescription: ,Left= ,,3.00,0.00,000,0.00,[Equiv=3.00],Right= ,4.00,0.00,000,0.00,[Equiv=4.00]</B></div> <div> <B>--Parameters: Over/Under,,,(A) Sphere=,,0.50,,(B) Cylinder=,,0.50,(C) Axis=,,5</B></div> <div> <B>--Parameters (Cont):,,,(D) Max NO Astig Cylinder=,,,.25,(E) Min Sphere for D=,,2.00,</B></div> <div> <B>--Match Flags:,,,(F) Left first=, 0,,(G) Right first=,,, 0,(H) Both=, 1,(I) Reading Power Also=,,, 0,(J) Reading Power ONLY=,,, 0</B></div> <div> <B>--Choice: ,Left= ,0115,3.50,0.00,000,2.25, -Match,Right: ,3.50,-0.25,000,2.25, -Match,Flags: ,Sunglasses= , 0, Reading= , 0, Progressive= , 0, Bi-Trifocal= , 1</B></div> <div> <B>--Choice: ,Left= ,0337,3.25,0.00,000,0.00, -Match,Right: ,4.50,-0.25,087,0.00, -Match,Flags: ,Sunglasses= , 1, Reading= , 0, Progressive= , 0, Bi-Trifocal= , 0</B></div> <div> <B>--Choice: ,Left= ,0495,3.25,0.00,000,0.00, -Match,Right: ,4.50,-0.25,101,0.00, -Match,Flags: ,Sunglasses= , 0, Reading= , 0, Progressive= , 0, Bi-Trifocal= , 0</B></div> <div> <B>--Choice: ,Left= ,0497,3.50,0.00,000,0.00, -Match,Right: ,3.75,-0.25,118,0.00, -Match,Flags: ,Sunglasses= , 0, Reading= , 0, Progressive= , 0, Bi-Trifocal= , 0</B></div> <div> <B>--Choice: ,Left= ,0584,3.50,-0.25,167,2.75, -Match,Right: ,3.50,-0.25,068,2.75, -Match,Flags: ,Sunglasses= , 0, Reading= , 0, Progressive= , 0, Bi-Trifocal= , 1</B></div> <div> <B>--Choice: ,Left= ,1422,3.50,-0.25,130,2.00, -Match,Right: ,3.50,-0.25,157,1.75, -Match,Flags: ,Sunglasses= , 0, Reading= , 0, Progressive= , 0, Bi-Trifocal= , 1</B></div> <div> <B>--Choice: ,Left= ,1426,3.50,-0.25,021,0.00, -Match,Right: ,3.75,0.00,000,0.00, -Match,Flags: ,Sunglasses= , 0, Reading= , 0, Progressive= , 0, Bi-Trifocal= , 0</B></div> <div> <B>--Choice: ,Left= ,1609,3.50,0.00,000,0.00, -Match,Right: ,3.50,-0.25,163,0.00, -Match,Flags: ,Sunglasses= , 0, Reading= , 0, Progressive= , 1, Bi-Trifocal= , 1</B></div> <div> <B>--Choice: ,Left= ,1712,2.50,-0.25,004,2.25, -Match,Right: ,4.00,-0.25,169,2.25, -Match,Flags: ,Sunglasses= , 0, Reading= , 0, Progressive= , 0, Bi-Trifocal= , 1</B></div> <bR> <bR> <div> Go to <A HREF="id10.htm" TARGET="_top" TITLE="9.0 Useful Things"><U><B>9.0 Useful Things</B></U></A> to see several ways to use the program.</div> <div>  </div> <bR> <bR> <bR> <bR> <bR> <bR> <bR> </td> </tr></table></body>