<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:times new roman, new york, times, serif;font-size:12pt"><DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif">Ray,</DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif"> </DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif">Here is the batch file that is used.</DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif"> </DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif">set PFDSK=V<BR>set PFPROG=V:<BR>set PFDATA=V:<BR>set PFDIR=<BR>set PFCMARK=20<BR>set PFLMHOST=server2007<BR>cd fp<BR>dprodir bom -ka<BR>rreport acttime -f getbom -s one<BR>cd\<BR>cls<BR></DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif">Note: dirve V: is mapped to <A href="file://\\server2007\F\fpodbc">\\server2007\F\fpodbc</A></DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif">The batch file resides in the fpodbc and the bom.dif resides in \fp folder</DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif"> </DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif">There is one other dif file that has more rows but I hav not checked it yet. I will do so tonight and advise.</DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif"> </DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif">The process runs one 1 record in a file called acttime (which is where I run all my import processes).</DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif"> </DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif">Here is the process...</DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif">1 (label) = getit Then: import dif fpo = bom</DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif">2. If: not fpo Then: end</DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif">3. Then: a(20,*);q(9,.4);d(10,mdyy/);b(20,*)</DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif">4. Then: q=fpo(3); b=fpo(2); a=fpo(1); d=fpo(4)</DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif">5. Then: np(5,.0)=np+"1"</DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif">6. Then: show ("7","10") "processing part number"<a</DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif">7. Then: show ("9","10") "no. of parts"<np</DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif">8. Then: lookup miv = bom r=free -n</DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif">9. If: not miv Then: errorbox "Part"<a<"Not Created";end</DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif">10. Then: miv(1)=a;miv(2)=b;miv(3)=q;miv(4)=d</DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif">11. Then write miv</DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif">12. Then: goto getit</DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif">13: Then: end</DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif"> </DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif">When the process does not run correctly it creates 47k blank records.</DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif"> </DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif">Thanks</DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif">Rick</DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif"> </DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif"> </DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif"><BR><BR> </DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif">----- Original Message ----<BR>From: Ray Hoover <rhoover@fptech.com><BR>To: filepro support <fpsupport@fptech.com>; Richard Hane <yoresoft@sbcglobal.net><BR>Cc: Rick Hane <rhane@deluxestitcher.com><BR>Sent: Tuesday, May 13, 2008 1:09:15 PM<BR>Subject: Re: Memory change in 5.0.15<BR><BR>
<STYLE type=text/css>DIV {
MARGIN:0px;}
</STYLE>
<DIV><FONT face=Arial size=2>Rick,</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>describe the process that you are using to update data in your excel dif files to filePro. Are you importing the .dif files?</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Do any of the other Excel files have as many or more rows than the problem file?</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Ray</FONT> </DIV>
<BLOCKQUOTE style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV style="BACKGROUND: #e4e4e4; FONT: 10pt arial"><B>From:</B> <A title=yoresoft@sbcglobal.net href="mailto:yoresoft@sbcglobal.net" target=_blank rel=nofollow ymailto="mailto:yoresoft@sbcglobal.net">Richard Hane</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=filepro-list@lists.celestial.com href="mailto:filepro-list@lists.celestial.com" target=_blank rel=nofollow ymailto="mailto:filepro-list@lists.celestial.com">filepro-list@lists.celestial.com</A> ; <A title=fpsupport@fptech.com href="mailto:fpsupport@fptech.com" target=_blank rel=nofollow ymailto="mailto:fpsupport@fptech.com">filepro support</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Cc:</B> <A title=rhane@deluxestitcher.com href="mailto:rhane@deluxestitcher.com" target=_blank rel=nofollow ymailto="mailto:rhane@deluxestitcher.com">Rick Hane</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Tuesday, May 13, 2008 12:28 PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Memory change in 5.0.15</DIV>
<DIV><BR></DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif">
<DIV>I just upgraded from fpodbc 1.0.13 to fpodbc 5.0.15 and moved are files from an old server to a new one. With the help of Ray Hoover (fpTech) everything is now up and running.</DIV>
<DIV> </DIV>
<DIV>However, I see something that may mean I have to change some of my batch files.</DIV>
<DIV> </DIV>
<DIV>Each night I have a serious of batch files that update data in Excel dif files to filePro. Has worked great for several years. I updated last night and all but one worked. The one that did not has 47K rows in the dif file. I have tried it with only half the rows and it works. This makes me think there may be a memory setting that I need make. </DIV>
<DIV> </DIV>
<DIV>Has any one else run in to this or can guide me down the correct path?</DIV>
<DIV> </DIV>
<DIV>BTW... The server has 4 gig on mem so that's not the problem.</DIV>
<DIV> </DIV>
<DIV>Thank you,</DIV>
<DIV>Rick Hane</DIV>
<DIV>Deluxe Stitcher Company Inc.</DIV>
<DIV><A href="http://www.deluxestitcher.com/" target=_blank rel=nofollow>www.deluxestitcher.com</A></DIV>
<DIV><A href="mailto:rhane@deluxestitcher.com" target=_blank rel=nofollow ymailto="mailto:rhane@deluxestitcher.com">rhane@deluxestitcher.com</A></DIV>
<DIV> </DIV></DIV></BLOCKQUOTE></DIV></div></body></html>