Franklin, I use external data files for several of our programs. Usually it is used as a lookup table for specified messaging. It is a processor expensive process because the entire lookup table must be loaded into memory at the time the job starts. With over 400,000 records FusionPro would appear to be locked-up. It's probably not but it could be motionless for hours while it is in process. It appears you have the processes reversed.
I assume you are connected to a much smaller database that contains your messaging driven by some kind of version ID field and then matching that code to pull in the realtor information for composition. If your operations are reversed then FusionPro won't be forced to load the entire realtor database before all processes take place. 1. Connect to a small subset of realtor database as your main data source for testing and programming using including all fields necessary for print or programming. 2. Change your lookup table to the messaging database instead of the large realtor database. Only connect to the full database when you are ready for the full composition. Doug Pershing VP-Data & Production WMSG Inc 1278 Titan Dr Dallas, TX 75247 (214) 640-2224 e-mail [EMAIL PROTECTED] web http://wmsginc.com <http://wmsginc.com/> click on information and news to see the latest at WMSG Inc. cid:[email protected] From: Franklin Miller [mailto:[EMAIL PROTECTED] Sent: Friday, November 23, 2007 9:16 AM To: FusionPro Users Forum Subject: [fusionpro] External Data File Help All, Following is an OnJobStart rule: lookuptable = new ExternalDataFileEx("C:\\Realtor\\Kodak\\Realtor.csv", ","); I've been testing this rule using an External Data File of 1,000 - 2,000 records with sucess. Now my client has given me the entire External Data File of 462,000 records with 91 fields. When I try to plug this database in as and External Data File, FusionPro will crash. I'm assuming this data set is too large for FusionPro to handle? Can someone let me know if and what limitations Fusion Pro has using External Data Files? Thanks, -- Franklin Miller Catawba Print & Mail, Inc. Digital Printing and Direct Mail Services Voice - (828) 324-2021 x 305 Fax - (828) 324-0063 Email - [EMAIL PROTECTED] +-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+- FusionPro 5.0 Now Available! Variable text on a curve and soft drop-shadows for variable text LIMITED TIME upgrade offer of $299 per license for current customers: http://fusionpro.printable.com/store/upgrade New licenses available for $599 each at: http://fusionpro.printable.com/store/ All FusionPro 5.0 customers to receive FusionPro 5.1 with Adobe Acrobat 8 and InDesign CS3 support when released for FREE. +-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+- -- Users of FusionPro Desktop have unlimited free email support. Contact Printable Support at [EMAIL PROTECTED] -- View FusionPro Knowledge Base, FusionPro Samples at www.printable.com/vdp/desktop.htm -- You are currently subscribed to fusionpro as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] -- -- Note: All e-mail sent to or from this address will be received or otherwise recorded by the e-mail recipients of this forum. It is subject to archival, monitoring or review by, and/or disclosure to someone other than the recipient. Our privacy policy is posted on www.printplanet.com --
<<image001.jpg>>
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+- FusionPro 5.0 Now Available! Variable text on a curve and soft drop-shadows for variable text LIMITED TIME upgrade offer of $299 per license for current customers: http://fusionpro.printable.com/store/upgrade New licenses available for $599 each at: http://fusionpro.printable.com/store/ All FusionPro 5.0 customers to receive FusionPro 5.1 with Adobe Acrobat 8 and InDesign CS3 support when released for FREE. +-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+- -- Users of FusionPro Desktop have unlimited free email support. Contact Printable Support at [EMAIL PROTECTED] -- View FusionPro Knowledge Base, FusionPro Samples at www.printable.com/vdp/desktop.htm -- You are currently subscribed to fusionpro as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] --
-- Note: All e-mail sent to or from this address will be received or otherwise recorded by the e-mail recipients of this forum. It is subject to archival, monitoring or review by, and/or disclosure to someone other than the recipient. Our privacy policy is posted on www.printplanet.com --
