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