Memory change in 5.0.15
Richard Hane
yoresoft at sbcglobal.net
Tue May 13 11:58:13 PDT 2008
Ray,
Here is the batch file that is used.
set PFDSK=V
set PFPROG=V:
set PFDATA=V:
set PFDIR=
set PFCMARK=20
set PFLMHOST=server2007
cd fp
dprodir bom -ka
rreport acttime -f getbom -s one
cd\
cls
Note: dirve V: is mapped to \\server2007\F\fpodbc
The batch file resides in the fpodbc and the bom.dif resides in \fp folder
There is one other dif file that has more rows but I hav not checked it yet. I will do so tonight and advise.
The process runs one 1 record in a file called acttime (which is where I run all my import processes).
Here is the process...
1 (label) = getit Then: import dif fpo = bom
2. If: not fpo Then: end
3. Then: a(20,*);q(9,.4);d(10,mdyy/);b(20,*)
4. Then: q=fpo(3); b=fpo(2); a=fpo(1); d=fpo(4)
5. Then: np(5,.0)=np+"1"
6. Then: show ("7","10") "processing part number"<a
7. Then: show ("9","10") "no. of parts"<np
8. Then: lookup miv = bom r=free -n
9. If: not miv Then: errorbox "Part"<a<"Not Created";end
10. Then: miv(1)=a;miv(2)=b;miv(3)=q;miv(4)=d
11. Then write miv
12. Then: goto getit
13: Then: end
When the process does not run correctly it creates 47k blank records.
Thanks
Rick
----- Original Message ----
From: Ray Hoover <rhoover at fptech.com>
To: filepro support <fpsupport at fptech.com>; Richard Hane <yoresoft at sbcglobal.net>
Cc: Rick Hane <rhane at deluxestitcher.com>
Sent: Tuesday, May 13, 2008 1:09:15 PM
Subject: Re: Memory change in 5.0.15
Rick,
describe the process that you are using to update data in your excel dif files to filePro. Are you importing the .dif files?
Do any of the other Excel files have as many or more rows than the problem file?
Ray
----- Original Message -----
From: Richard Hane
To: filepro-list at lists.celestial.com ; filepro support
Cc: Rick Hane
Sent: Tuesday, May 13, 2008 12:28 PM
Subject: Memory change in 5.0.15
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.
However, I see something that may mean I have to change some of my batch files.
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.
Has any one else run in to this or can guide me down the correct path?
BTW... The server has 4 gig on mem so that's not the problem.
Thank you,
Rick Hane
Deluxe Stitcher Company Inc.
www.deluxestitcher.com
rhane at deluxestitcher.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.celestial.com/pipermail/filepro-list/attachments/20080513/8d407d95/attachment.html
More information about the Filepro-list
mailing list