Export Command

[Jeff Harrison]

----- Original Message -----
> From: Rodgers Hemer <r.hemer at w-link.net>
> To: filepro-list at lists.celestial.com
> Cc: 
> Sent: Tuesday, October 4, 2011 11:17 AM
> Subject: Export Command
> 
> fp5.6.10D4/CentOS5.3
> 
> Perhaps someone can explain the odd behavior I have recently noticed in use of 
> the "export" command.  Despite the definitions and instructions  in 
> the help file and the filePro manual,  I cannot use the command in the 
> prescribed manner.  While using "export word" I am not able to provide 
> an alternative suffix such as ".xls" or ".doc"

Make sure you have PFADDWP=OFF in your environment.


>, and it 
> insists that the "fpmerge" directory be used to receive the output.  
> If I try any other combination, a filePro error appears when checking the 
> syntax.  The syntax checker seems to require that only the output file name be 
> given, with no quotation marks.  If quotation marks are used for the file name, 
> the file is created with the quotation marks as a part of the name with all of 
> the obvious problems that entails when trying to use or modify the file.  This 
> has caused the use of work arounds in the menu script so that I can place and 
> name the file as as needed.
> 
> The only things that are not a simple use of the command is that the applicable 
> output processes and formats are in a script under a menu line, and that 
> "pfdir" is used to point to a different filepro file (i.e., 
> /home/appls/filepro rather than the default /home/appl/filepro).  The menu 
> script also moves the resulting output from fpmerge to the correct directory.
> 
> While I have been able to make this work, the expected filePro actions are 
> significantly different than those I have used for many years in exporting data 
> for use in another program.  Any suggestions?
> 
> Rodgers Hemer

Specifying the file name as follows should work.


fname = /tmp/file.xyz

If you are still having problems, go ahead and post your actual code and I'm sure someone will be able to help you out.

Jeff Harrison
jeffaharrison at yahoo.com
Author of JHExport and JHImport.