Output error

Rick Hane yoresoft at hotmail.com
Tue Nov 9 15:23:38 PST 2004


>From: Kenneth Brody <kenbrody at bestweb.net>
>To: Rick Hane <yoresoft at hotmail.com>
>CC: filepro-list at seaslug.org
>Subject: Re: Output error
>Date: Tue, 09 Nov 2004 18:09:49 -0500
>
>Rick Hane wrote:
> >
> > >From: Kenneth Brody <kenbrody at bestweb.net>
>[...]
> > >Well, if 10 DIF files import just fine, but this 11th one doesn't, 
>there is
> > >obviously something different about this file.  (I'm not sure why you 
>think
> > >changing the filePro processing will eliminate a "not a valid DIF file"
> > >error.)
> > >
> > >Do you get this error on the first record, or some record within the 
>file?
> > >If it's on the first record, it may be in the header.  If it happens on 
>one
> > >of the record in the file, then it's something specific to that record.
>[...]
> > I understand what you are saying and it makes sense but I have 
>re-created
> > the spreadsheet 3 times.  Yes it is on the first record.
> >
> > I will try to copy the data in to another dif file and eliminating the 
>first
> > couple of records to see if either fixes the problem.
>
>If you export the first couple of rows from this spreadsheet, does it still
>fail to import?  If so, then you should have a pretty small file that you
>can post here, and/or make arrangements with fpsupport to look at.
>
>--
>+-------------------------+--------------------+-----------------------------+
>| Kenneth J. Brody        | www.hvcomputer.com |                            
>  |
>| kenbrody/at\spamcop.net | www.fptech.com     | #include 
><std_disclaimer.h> |
>+-------------------------+--------------------+-----------------------------+
>Don't e-mail me at: <mailto:ThisIsASpamTrap at gmail.com>
>

Ken,

Found it!  The third column in contained addresses that included embedded 
several cr in the same field (street addresses).  Removed the column and all 
works well.  I'll have to do a parse then import the file.

Thank you,
Rick




More information about the Filepro-list mailing list