Error when importing dif

[Richard Hane]

*** Sorry Top Posted ***
   
  Ken,
   
  First thing I thought of; however, this same file has worked every days for 6 yrs.  But even realizing this I deleted the dif then recreated it.  Same result.  I have had problems with dif files that are over 30,000 lines.  I usually split them in to two files and all works well.  I will try that on this file later today.
   
  BTW... Here is a question I have never seen asked and I don't know how or why it works.
   
  My Excel worksheets are filled from Microsoft SQL tables via an ODBC link.  I have the first column defined as "text" as our part numbers are alphanumeric and if you don't define it this way preceeding zero's will get dropped. (ie. 070198 will come in as 70198).  Now when you save the dif file there is now prefined sheet and you loose that format.  When you import in to filepro somehow it remembers the definition from the original worksheet.  How is this done?  Is there a reference between the xls and the dif file that filepro follows?  Just curious.
   
  Thanks
  Rick

  
Kenneth Brody <kenbrody at bestweb.net> wrote:
  Quoting Richard Hane (Wed, 13 Aug 2008 06:23:12 -0700 (PDT)):

> Good morning,
>
> I know I have seen this error posted here before but can't 
> remember when the cuase is.
>
> filePro (5.0.15R9)
>
> Situation... Each night I update and import 9 dif files in to 
> filepro. Has been working for 7 yrs and three fp versions.
>
> Last night I rec'd the following error on one of the imports.
>
> On File: /filepro/wonote/index.P
>
> Output Processing
> Line number: 1
> Bad Import Format
> Not a DIF file
>
> This error happens after only 300 of the 31,000 lines have been 
> processed. There is no index P. I have deleted the dif file and 
> created a new one on the same table. Again the same error.
>
> Any thoughts?

Have you considered that there may be a problem with the DIF file at
that point?


-- 
Read the truth behind the movie "Expelled" at 
--
KenBrody at BestWeb dot net spamtrap: 
http://www.hvcomputer.com
http://www.fileProPlus.com

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.celestial.com/pipermail/filepro-list/attachments/20080813/5959f5c8/attachment.html