Export

GCC Consulting gccconsulting at comcast.net
Tue Jul 1 08:43:36 PDT 2008



> -----Original Message-----
> From: filepro-list-bounces+gccconsulting=comcast.net at lists.celestial.com
> [mailto:filepro-list-bounces+gccconsulting=comcast.net at lists.celestial.com] On
> Behalf Of Kenneth Brody
> Sent: Tuesday, July 01, 2008 11:30 AM
> To: rkreiss at gccconsulting.net
> Cc: 'filePro Mailing List'
> Subject: Re:Export
> 
> Quoting Richard Kreiss (Tue, 1 Jul 2008 11:17:25 -0400):
> 
> > I have a filepro file with 107,450 records, with 14 fields, that
> > needs to be exported to a csv file.
> >
> > When export word is run, is stops writing records after about
> > 28,600.  The last record written has only the first 3 fields written.
> 
> What is the exact size of the resulting export file?  Does your system
> have some sort of file size limit that's being hit?
> 
> > Is there a limit to how many records can be exported?
> 
> No.
Ken,

Changed the export to export ascii

13  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
      ◄ If:
      Then: export ascii rank=(filename) R=^J F=, O=" C="

With this the only change, the export ran properly.

So, why will export ascii work and export word fail on the same data set?

Richard



> 
> > Is there an export environmental variable that can be set.
> 
> No.
> 
> [...]
> >  11  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
> >        ◄ If: getenv("pfdata") = "F:"
> >        Then: FILENAME="f:\csv_files\ccp.csv"
> >  12  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
> >        ◄ If: getenv("pfdata") = "F:"
> >        Then: FILENAME="W:\CCP\csv_files\ccp.csv"
> >  13  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -
> >   -        ◄ If: getenv("pfdata") = "w:"
> >        Then: export word rank=(filename)
> 
> This code makes no sense.  If PFDATA is "F:", then you never execute the
> EXPORT.  If PDATA is "W:", then you never set FILENAME.
> 
> [...]
> 
> --
> Read the truth behind the movie "Expelled" at
> <http://www.ExpelledExposed.com>
> --
> KenBrody at BestWeb dot net        spamtrap: <g8ymh8uf001 at sneakemail.com>
> http://www.hvcomputer.com
> http://www.fileProPlus.com
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> http://mailman.celestial.com/mailman/listinfo/filepro-list




More information about the Filepro-list mailing list