export then email doesn't send whole file

[scooter6 at gmail.com]

That's exactly what it was....it needed the 'close cli'
statement.......ugh...I always forget that ha
thanks guys

Scott


On Thu, Jun 13, 2013 at 3:28 PM, Jeff Harrison <jeffaharrison at yahoo.com>wrote:

> >________________________________
> > From: Jean-Pierre A. Radley <appl at jpr.com>
> >To: FilePro Mailing List <filepro-list at lists.celestial.com>
> >Sent: Thursday, June 13, 2013 2:13 PM
> >Subject: Re: export then email doesn't send whole file
> >
> >
> >scooter6 at gmail.com propounded (on Wed, Jun 12, 2013 at 12:02:53PM -0400):
> >| I have an export where our marketing people can set select whatever
> >| criteria they want
> >| It then asks them for the name of the file to output to csv....and their
> >| name to email it
> >|
> >| it runs    /fp/rreport client -f exportCLI -u -x
> >|
> >| and runs the following process:
> >|
> >| top:aa=""
> >| :input aa(20,*) "What do you want to name the file? (i.e. flclients.csv
> >| )"
> >| :ba=""
> >| :input ba(5,*) "Who are you? (i.e. Kalan, Jim)":
> >| :aa="" or ba=""
> >| :goto top:
> >| ::ab(44,*)="/appl/fpmerge/cliexport/"{aa:
> >| ::export ascii cli=(ab) r=\n f=, o=" c=":
> >|
> ::cli(1)=1;cli(2)=2;cli(3)=3;cli(4)=4;cli(5)=5;cli(6)=6;cli(7)=7;cli(8)=8:
> >| ::cli(9)=17-"1";cli(10)=67;cli(11)=75;cli(12)=77;:
> >| ::ac(4,.0)=@td-67:
> >| ::cli(13)=ac:
> >| ::x(10,.0,g)=x+"1":
> >| ::end:
> >| @done::beep;msgbox "A total of"<x<"Records were selected...Press Enter":
> >| ::system "/appl/fpmerge/cliexport/send_file.scr"<aa<ba:
> >|
> >| So as you can see, using the parameters the user enters, it calls the
> >| send_file script which basically is just using mutt to send the file..
> >| The problem is, once the csv files arrives in the users Inbox, it rarely
> >| has all the records in it (every now and then it does, but typically
> gets
> >| cut off somewhere)
> >| However, if I go look in the directory where the file gets created, all
> of
> >| the records are there
> >| If I send the file from the command line using mutt just like my script
> >| does, then the file will arrive fully intact with all the records?
> >|
> >| I even put a sleep command  (sleep 10) in the beginning of my script -
> just
> >| in case the file hadn't been written out completely, but that didn't
> change
> >| anything....
> >|
> >| What would cause this behaviour?  It's as if the email trigger gets
> called
> >| prior to the entire file being 'written to disk' or something?
> >|
> >| Any insight would be appreciated
> >|
> >
> >What version of mutt are you using, and what mutt command?
> >
> >--
> >JP
>
> Is it possible that the automatic close of the file does not occur until
> after the @done processing?  It sounds like that is the case.  Try
> executing a "close cli" as the first thing after @done
>
> Good luck.
>
> Jeff Harrison
> jeffaharrison at yahoo.com
>
> Author of JHExport and JHIMport.
>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.celestial.com/pipermail/filepro-list/attachments/20130617/5e3158d1/attachment.html