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