running import command on each record

[Chris Rendall]

I've not seen it documented either, but I learned that many years ago after a lot of trial and error.

-- Chris



From: James Flanagan [mailto:James at Flantec.com] 
Sent: Wednesday, August 16, 2017 8:53 AM
To: Chris Rendall <crendall at teamind.com>
Cc: filePro (filepro-list at lists.celestial.com) <filepro-list at lists.celestial.com>
Subject: Re: running import command on each record

Chris, 

that was the trick.  I cannot find anything in the documentation regarding the necessity to close an import, but you supplied me with the answer i needed.  Thank you again, very much

James Flanagan
http://Flantec.com/

email:	mailto:James at Flantec.com
mobile:	760-458-8498
home: 	219-221-6219
text:		mailto:7604588498 at txt.att.net

aim:		Flantec
oovoo:	Flantec
Skype:	Flantec
ichat:	mailto:Flantec at mac.com

home:	1901 Cidermill Road
		Michigan City, IN 46360

On Aug 16, 2017, at 9:48 AM, Chris Rendall via Filepro-list <mailto:filepro-list at lists.celestial.com> wrote:

On the then line under ‘not data’, add 'close data’ before the end statement so it closes the file you are importing.



On Aug 16, 2017, at 8:40 AM, James Flanagan via Filepro-list <mailto:filepro-list at lists.celestial.com> wrote:

Redhat Enterprise 6.8
Filepro 5.8.01.06D6

I am trying to use an import command in output processing to run on each record and import some data to each from its own separate data file.  My processing works as expected on the very first record, but what appears to happen on record #2 is that even though field 40 is a different value (and ultimately a different file), after defining the import for the 2nd time, the NOT DATA is for some reason TRUE and it kills the import for all subsequent records.  

I cannot find anything in the manual that explains this behavior.  

from what i am seeing, it would appear that I would need to run a separate dreport for each record to get this work properly, which is not a big deal to program, but if there is a way to get this to function so that the import works for each record within the same dreport, i would prefer to use that method.  thank you very much, 

loop::’:
::fn="/tmp/addv/"{40{".txt":
::import ascii data=(fn) r=\n f=^A o=" c=":
:not data:end:
:: <code to populate fields>….
::goto loop:


James Flanagan
http://flantec.com/ <http://flantec.com/>

email:	mailto:James at Flantec.com <mailto:James at Flantec.com>
mobile:	760-458-8498
home: 	219-221-6219
text:		mailto:7604588498 at txt.att.net <mailto:7604588498 at txt.att.net>

aim:		Flantec
oovoo:	Flantec
Skype:	Flantec
ichat:	mailto:Flantec at mac.com <mailto:Flantec at mac.com>

home:	1901 Cidermill Road
		Michigan City, IN 46360

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20170816/e14b8e42/attachment.html>
_______________________________________________
Filepro-list mailing list
mailto:Filepro-list at lists.celestial.com
Subscribe/Unsubscribe/Subscription Changes
http://mailman.celestial.com/mailman/listinfo/filepro-list

_______________________________________________
Filepro-list mailing list
mailto:Filepro-list at lists.celestial.com
Subscribe/Unsubscribe/Subscription Changes
http://mailman.celestial.com/mailman/listinfo/filepro-list