EXPORT ASCII won't
Boaz Bezborodko
boaz at mirrotek.com
Fri Jun 6 09:19:51 PDT 2014
On 6/6/2014 8:16 AM, filepro-list-request at lists.celestial.com wrote:
> Message: 2
> Date: Thu, 5 Jun 2014 23:29:12 -0400 (EDT)
> From: Jay Ashworth <jra at baylink.com>
> Subject: EXPORT ASCII won't
> To: FilePro Mailing List <filepro-list at lists.celestial.com>
> Message-ID:
> <32963688.3154.1402025352473.JavaMail.root at benjamin.baylink.com>
> Content-Type: text/plain; charset=utf-8
>
> 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
My experience is based on Filepro for Windows so keep that in mind.
Filepro only exports one record per EXPORT command it encounters. If
Filepro only runs '::exp(1)=1{"":' each time you want a new record
exported you won't get what you want.
If you are selecting 2300 records and each sees :
::export ascii exp=inventory.txt r=\n f=|:
then
::exp(1)=1{"":
::exp(2)=2{"":
then
::END:
You should end up with a file in the directory from which Filepro
normally runs with 2300 records. In my case it's whatever directory is
set in "pfdir". I'll sometimes use a CHDIR command to put it elsewhere
or specify it in the EXPORT command line. I don't use a WRITE command.
Sometimes I'll loop through records from within one record and I'll need
to execute the same EXPORT line each time. At that point I'll use a
CLOSE command if I need to work with the file afterwards should I want
to append or copy it.
I normally use an EXPORT WORD with quotes and commas since it handles
most of what I need. You may want to try that just to see what it
gives you.
Boaz
---
This email is free from viruses and malware because avast! Antivirus protection is active.
http://www.avast.com
More information about the Filepro-list
mailing list