EXPORT ASCII won't
Mike Schwartz
mschw at athenet.net
Fri Jun 6 06:10:44 PDT 2014
> So I'm working on this export for a client a list member was kind enough
to
> refer to me, and my export ascii just doesn't seem to want to drop a file
> *anywhere*.
>
> The manpage seems to disagree with itself whether a filename with no path
> will be written `pwd` or in $PFDIR/fpmerge, but I've tried with and
without,
> and looked in `pwd`, in $PFDIR/fpmerge, in /appl/fpmerge, and in /tmp
> (when I specified that), and I get *nothing* at all.
>
> No empty file; no file.
>
> dreport was missing it's suid bit, but I fixed that, and all the relevant
> directories were 777 anyways.
>
> I am running this -a on the table in question, and it's happily finding
> 2300 someodd records, and counting down through them.
>
> Yes, I used -y !!! and -z !!! in various combinations, and they didn't
help
> either.
>
> 4.5.... .05, I think. Definitely 4.5 though.
>
> ::export ascii exp=inventory.txt r=\n f=|:
> then lots of
> ::exp(1)=1{"":
> and a write exp at the end.
>
> Tried using a different tag than exp, as well.
>
> Table passes syntax check, and does *nothing* else.
>
> Any ideas, comrades?
>
> Cheers,
> -- jra
----- ----- ---------------------------------------------------------
Hi Jay:
As I recall, if you don't specify a full path, filePro puts exported
files in $PFPROG/fpmerge (Hmmm... maybe that's $PFDATA/fpmerge) Anyway,
search your server for any fpmerge subdirs. You will probably find your
missing exported files in that fpmerge subdir.
Check and see if PFADDWP=OFF is set. If NOT, then your output file is
probably named inventory.txt.WP
You should find an output file somewhere. Search your entire file
system using this: find / -name invent* -print | more
The only reason I can think of why filePro (even the old 4.5) might not
write this file is that filePro doesn't have permission to write to ALL of
the subdirs involved. Check read-write permissions on ALL the subdirs.
You don't need that last "write exp" unless you are looping through the
code you are showing us to write multiple spreadsheet rows out of one
filePro record.
Try specifying the full path name with: fn="/tmp/inventory.txt",
followed by: export ascii exp=(fn)
Mike Schwartz
PC Support & Services
More information about the Filepro-list
mailing list