Dynamic filename creation w/export

Nancy Palmquist nlp at vss3.com
Thu Jan 13 12:37:58 PST 2005


Matthew Williams wrote:

> The list has been quiet so I figured I would stir up some conversation.
> 
> I currently have a invoice file, each invoice is flagged with a rep
> code to distinguish who sold what.
> 
> Currently we print out hard copies and send them out to each of the reps.
> 
> I would like to setup a process that will export each invoice record
> (not every field, just a few specific fields, this is no big deal) to
> a simple delimited file which could then be e-mailed to the rep along
> with a Word file to import the file to make it look pretty and
> legible, this would save lots of time, paper and most importantly
> money.
> 
> There are about 20 or so rep codes (3 digit code) so I would like to
> be able to dump out all of these files at once in a batch.  The
> filename would simply be <repcode>.txt.
> 
> I believe I have a decent approach to this situation (just a simple
> output process with a selection set) but was curious to see how the
> pro's would approach it.
> 
> My ultimate question is how would I dynamically set that filename to
> the rep code?  Could it be done as a variable?  Could the date
> possibly be added to it?  Any code examples out there?
> 
> Thanks a lot!
> -Matt
> Hale Mfg.
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> http://mailman.celestial.com/mailman/listinfo/filepro-list
> 
> 

You will need to CLOSE the previous one before you start the next when 
the EXPORT name changes.

I have done something like this to just output the invoice and change 
the name for each invoice.  (Or Rep in your case.) Then you could just 
pick up the relevant file and email it as a document.

You can use PRINTER FILE "fullpath/repcode.doc" and issue that command 
whenever the name changes and generate a form output.

Just another idea.

Nancy

-- 
Nancy Palmquist 		MOS & filePro Training Available
Virtual Software Systems	Web Based Training and Consulting	
PHONE: (412) 835-9417		   Web site:  http://www.vss3.com



More information about the Filepro-list mailing list