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